[XPERIA X10 General] Mark_Dawson:
Well Lollylost didn.t work I did notice in the extendlocal folder the ma3localdb has this in the file maybe a reason why it is doing this??

CREATE SCHEMA PUBLIC AUTHORIZATION DBA

CREATE MEMORY TABLE TBLFILE(FIL_LOCAL_PK INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,FIL_SERVER_ID VARCHAR NOT NULL,FIL_SERVERVERSION_ID VARCHAR NOT NULL,FIL_SERVERVERSIONNAME VARCHAR NOT NULL,FIL_NAME VARCHAR NOT NULL,FIL_FORMATNAME VARCHAR NOT NULL,FIL_SECURITYNAME VARCHAR NOT NULL,FIL_TYPENAME VARCHAR NOT NULL,FIL_SERVERCONTENTINFO_ID VARCHAR NOT NULL,FIL_CONTENTLENGTH VARCHAR NOT NULL,FIL_BLOB_CHECKSUM VARCHAR,FIL_SERVERFILE_LASTUPDATED VARCHAR NOT NULL,FIL_SERVERVERSION_LASTUPDATED VARCHAR NOT NULL,FIL_PRESENTATION VARCHAR NOT NULL,FIL_DESCRIPTION VARCHAR NOT NULL,FIL_RELEASENOTES VARCHAR NOT NULL,CONSTRAINT SYS_CT_46 UNIQUE(FIL_SERVERVERSION_ID,FIL_SERVERFILE_LASTUPDATED,FIL_SERVERVERSION_LASTUPDATED))

CREATE MEMORY TABLE TBLFILEPROPERTY(FP_LOCAL_PK INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,FP_FIL_LOCAL_FK INTEGER NOT NULL,FP_CATEGORYNAME VARCHAR NOT NULL,FP_PROPERTYVALUE VARCHAR NOT NULL,CONSTRAINT SYS_FK_50 FOREIGN KEY(FP_FIL_LOCAL_FK) REFERENCES TBLFILE(FIL_LOCAL_PK))

CREATE MEMORY TABLE TBLSERVICE(SER_LOCAL_PK INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,SER_ID VARCHAR NOT NULL,SER_NAME VARCHAR(50) NOT NULL,SER_DESCRIPTION VARCHAR(200),SER_ONLINEONLY VARCHAR NOT NULL,SER_PIDF_ID VARCHAR NOT NULL,SER_DOMAIN VARCHAR(50) NOT NULL,SER_TESTVERSION VARCHAR NOT NULL,SER_DOMAIN_ID VARCHAR NOT NULL,SER_SERVICETYPE VARCHAR NOT NULL,SER_CODE VARCHAR NOT NULL,SER_CREATED VARCHAR NOT NULL,SER_LASTMODIFIED VARCHAR NOT NULL,CONSTRAINT SYS_CT_55 UNIQUE(SER_ID,SER_DOMAIN_ID))

CREATE MEMORY TABLE TBLIDENTIFIERSTOSERVICE(ITS_LOCAL_PK INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,ITS_SER_LOCAL_FK INTEGER NOT NULL,ITS_IDENTIFIERCATEGORY VARCHAR NOT NULL,ITS_IDENTIFIERVALUE VARCHAR NOT NULL,ITS_CLIENTDESCRIPTION VARCHAR,CONSTRAINT SYS_FK_59 FOREIGN KEY(ITS_SER_LOCAL_FK) REFERENCES TBLSERVICE(SER_LOCAL_PK))

CREATE MEMORY TABLE TBLATTRIBUTESTOSERVICE(CTS_LOCAL_PK INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,CTS_SER_LOCAL_FK INTEGER NOT NULL,CTS_ATTRIBUTE_NAME VARCHAR(100) NOT NULL,CTS_ATTRIBUTE_TYPE VARCHAR(100),CTS_ATTRIBUTE_VALUE VARCHAR(100),CTS_FIL_LOCAL_FK INTEGER,CONSTRAINT SYS_FK_64 FOREIGN KEY(CTS_SER_LOCAL_FK) REFERENCES TBLSERVICE(SER_LOCAL_PK),CONSTRAINT SYS_FK_65 FOREIGN KEY(CTS_FIL_LOCAL_FK) REFERENCES TBLFILE(FIL_LOCAL_PK))

ALTER TABLE TBLFILE ALTER COLUMN FIL_LOCAL_PK RESTART WITH 3

ALTER TABLE TBLFILEPROPERTY ALTER COLUMN FP_LOCAL_PK RESTART WITH 10

ALTER TABLE TBLSERVICE ALTER COLUMN SER_LOCAL_PK RESTART WITH 1

ALTER TABLE TBLIDENTIFIERSTOSERVICE ALTER COLUMN ITS_LOCAL_PK RESTART WITH 112

ALTER TABLE TBLATTRIBUTESTOSERVICE ALTER COLUMN CTS_LOCAL_PK RESTART WITH 208

CREATE USER SA PASSWORD ""

GRANT DBA TO SA

SET WRITE_DELAY 10

SET SCHEMA PUBLIC

INSERT INTO TBLFILE VALUES(0,'277163716','277196794','R4A024','S1_QSD8250_eSheep_Loader_1226-2250_LIVE_AID0x0001','SIN','INFILE_LONGTERM','LOADER','277196791','87559','2920342618','1264160195000','1264061951000','','','')

INSERT INTO TBLFILE VALUES(1,'277188670','277286594','R1FA014','APP-SW_RACHAEL_GENERIC_1227-4612_S1-SW-LIVE-AC12-0001-S1-PARTITION','ZIP','INFILE_LONGTERM','SIN_FILE_SET','277286592','16629674','3774343335','1270622078000','1268290408000','APP-SW: [FileProp(Id)] [Version]','','')

INSERT INTO TBLFILE VALUES(2,'277232822','277303059','R16A-R1FA014','FSP_X10i_VFE-UK_VFE_1234-4579_S1-SW-LIVE-AC12-0001-S1-PARTITION-WITH-SPARE','ZIP','INFILE_LONGTERM','SIN_FILE_SET','277303055','115339810','3560336409','1270622069000','1269508005000','CDF: [FileProp(CDFId)], FS: [FileProp(LangRegion)], CDFVer-FSVer: [Version]','','')

INSERT INTO TBLFILEPROPERTY VALUES(0,0,'Id','1226-2250')

INSERT INTO TBLFILEPROPERTY VALUES(1,1,'RevisionIdentifier','SoftwareRev')

INSERT INTO TBLFILEPROPERTY VALUES(2,1,'RFSId','1')

INSERT INTO TBLFILEPROPERTY VALUES(3,1,'Id','1227-4612')

INSERT INTO TBLFILEPROPERTY VALUES(4,2,'LangRegion','VFE')

INSERT INTO TBLFILEPROPERTY VALUES(5,2,'CDFVer','R16A')

INSERT INTO TBLFILEPROPERTY VALUES(6,2,'FSVer','R1FA014')

INSERT INTO TBLFILEPROPERTY VALUES(7,2,'CDFId','1234-4579')

INSERT INTO TBLFILEPROPERTY VALUES(8,2,'RevisionProperties','CDFVer,FSVer')

INSERT INTO TBLFILEPROPERTY VALUES(9,2,'RFSId','2')

INSERT INTO TBLSERVICE VALUES(0,'277303487','X10i VFE-UK VFE 1234-4579',NULL,'false','276855164','Update Service','false','13150273','Software Update Content Refresh','import com.sonyericsson.cs.ma.tess.api.ServiceException;\u000aimport com.sonyericsson.cs.ma.tess.api.ServiceRuntimeException;\u000aimport com.sonyericsson.cs.ma.tess.api.StringUtil;\u000aimport com.sonyericsson.cs.ma.tess.api.TessFile;\u000aimport com.sonyericsson.cs.ma.tess.api.UI;\u000aimport com.sonyericsson.cs.ma.tess.api.ZipFileUtil;\u000aimport com.sonyericsson.cs.ma.tess.api.device.IdentificationResult;\u000aimport com.sonyericsson.cs.ma.tess.api.inject.InjectConfigValue;\u000aimport com.sonyericsson.cs.ma.tess.api.inject.InjectRef;\u000aimport com.sonyericsson.cs.ma.tess.api.inject.IncludeFor;\u000aimport com.sonyericsson.cs.ma.tess.api.inject.ServiceMethod;\u000aimport com.sonyericsson.cs.ma.tess.api.logging.Logging;\u000aimport com.sonyericsson.cs.ma.tess.api.protocols.DataArea;\u000aimport com.sonyericsson.cs.ma.tess.api.protocols.ProtocolFactory;\u000aimport com.sonyericsson.cs.ma.tess.api.protocols.VersionResponse;