[Openxava-commits] OpenXavaTest/data openxava-test-db.script, 1.95, 1.96
Java platform for fast time-to-market of business applications
Brought to you by:
javierpaniza
Menu
▾
▴
[Openxava-commits] OpenXavaTest/data openxava-test-db.script, 1.95, 1.96
|
From: Javier P. <jav...@us...> - 2009-06-26 17:40:52
|
Update of /cvsroot/openxava/OpenXavaTest/data In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv22765/data Modified Files: openxava-test-db.script Log Message: Fix: @EmbeddedId with int/long and NUMERIC in DB fails Index: openxava-test-db.script =================================================================== RCS file: /cvsroot/openxava/OpenXavaTest/data/openxava-test-db.script,v retrieving revision 1.95 retrieving revision 1.96 diff -C2 -d -r1.95 -r1.96 *** openxava-test-db.script 10 Jun 2009 10:45:33 -0000 1.95 --- openxava-test-db.script 26 Jun 2009 17:39:43 -0000 1.96 *************** *** 3,7 **** CREATE SCHEMA TRACKING AUTHORIZATION DBA CREATE MEMORY TABLE ACCESS(OID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,APPLICATION VARCHAR(20),MODEL VARCHAR(50),TABLE_NAME VARCHAR(50),USER VARCHAR(20),ACCESS_DATE DATE,ACCESS_TIME VARCHAR(5),TYPE VARCHAR(1),AUTHORIZED INTEGER,RECORD VARCHAR(100)) ! ALTER TABLE ACCESS ALTER COLUMN OID RESTART WITH 63610 CREATE SCHEMA DUAL_XAVATEST AUTHORIZATION DBA CREATE MEMORY TABLE SIZE_ID_SEQ(ID INTEGER NOT NULL PRIMARY KEY) --- 3,7 ---- CREATE SCHEMA TRACKING AUTHORIZATION DBA CREATE MEMORY TABLE ACCESS(OID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,APPLICATION VARCHAR(20),MODEL VARCHAR(50),TABLE_NAME VARCHAR(50),USER VARCHAR(20),ACCESS_DATE DATE,ACCESS_TIME VARCHAR(5),TYPE VARCHAR(1),AUTHORIZED INTEGER,RECORD VARCHAR(100)) ! ALTER TABLE ACCESS ALTER COLUMN OID RESTART WITH 63796 CREATE SCHEMA DUAL_XAVATEST AUTHORIZATION DBA CREATE MEMORY TABLE SIZE_ID_SEQ(ID INTEGER NOT NULL PRIMARY KEY) *************** *** 9,13 **** CREATE MEMORY TABLE RECEPTIONIST_ID_SEQ(ID INTEGER NOT NULL PRIMARY KEY) CREATE SCHEMA XAVATEST AUTHORIZATION DBA ! CREATE SEQUENCE SIZE_ID_SEQ AS INTEGER START WITH 218 CREATE SEQUENCE DELIVERYPLACE_ID_SEQ AS INTEGER START WITH 73 CREATE SEQUENCE RECEPTIONIST_ID_SEQ AS INTEGER START WITH 142 --- 9,13 ---- CREATE MEMORY TABLE RECEPTIONIST_ID_SEQ(ID INTEGER NOT NULL PRIMARY KEY) CREATE SCHEMA XAVATEST AUTHORIZATION DBA ! CREATE SEQUENCE SIZE_ID_SEQ AS INTEGER START WITH 219 CREATE SEQUENCE DELIVERYPLACE_ID_SEQ AS INTEGER START WITH 73 CREATE SEQUENCE RECEPTIONIST_ID_SEQ AS INTEGER START WITH 142 *************** *** 31,35 **** CREATE MEMORY TABLE TRANSPORTCHARGE(DELIVERY_INVOICE_YEAR INTEGER NOT NULL,DELIVERY_INVOICE_NUMBER INTEGER NOT NULL,DELIVERY_TYPE INTEGER NOT NULL,DELIVERY_NUMBER NUMERIC(6) NOT NULL,AMOUNT NUMERIC(18,2),PRIMARY KEY(DELIVERY_INVOICE_YEAR,DELIVERY_INVOICE_NUMBER,DELIVERY_TYPE,DELIVERY_NUMBER)) CREATE MEMORY TABLE TRANSPORTCHARGE2(YEAR INTEGER NOT NULL,DELIVERY_INVOICE_NUMBER INTEGER NOT NULL,DELIVERY_TYPE INTEGER NOT NULL,DELIVERY_NUMBER NUMERIC(6) NOT NULL,AMOUNT NUMERIC(18,2),PRIMARY KEY(YEAR,DELIVERY_INVOICE_NUMBER,DELIVERY_TYPE,DELIVERY_NUMBER)) ! CREATE MEMORY TABLE WAREHOUSE(ZONE INTEGER NOT NULL,NAME VARCHAR(40),NUMBER INTEGER NOT NULL,PRIMARY KEY(ZONE,NUMBER)) CREATE MEMORY TABLE FAMILY(DESCRIPTION VARCHAR(40),OID VARCHAR(32) NOT NULL PRIMARY KEY,NUMBER INTEGER) CREATE MEMORY TABLE FAMILY2(DESCRIPTION VARCHAR(40),NUMBER INTEGER NOT NULL PRIMARY KEY) --- 31,35 ---- CREATE MEMORY TABLE TRANSPORTCHARGE(DELIVERY_INVOICE_YEAR INTEGER NOT NULL,DELIVERY_INVOICE_NUMBER INTEGER NOT NULL,DELIVERY_TYPE INTEGER NOT NULL,DELIVERY_NUMBER NUMERIC(6) NOT NULL,AMOUNT NUMERIC(18,2),PRIMARY KEY(DELIVERY_INVOICE_YEAR,DELIVERY_INVOICE_NUMBER,DELIVERY_TYPE,DELIVERY_NUMBER)) CREATE MEMORY TABLE TRANSPORTCHARGE2(YEAR INTEGER NOT NULL,DELIVERY_INVOICE_NUMBER INTEGER NOT NULL,DELIVERY_TYPE INTEGER NOT NULL,DELIVERY_NUMBER NUMERIC(6) NOT NULL,AMOUNT NUMERIC(18,2),PRIMARY KEY(YEAR,DELIVERY_INVOICE_NUMBER,DELIVERY_TYPE,DELIVERY_NUMBER)) ! CREATE MEMORY TABLE WAREHOUSE(ZONE INTEGER NOT NULL,NAME VARCHAR(40),NUMBER NUMERIC NOT NULL,PRIMARY KEY(ZONE,NUMBER)) CREATE MEMORY TABLE FAMILY(DESCRIPTION VARCHAR(40),OID VARCHAR(32) NOT NULL PRIMARY KEY,NUMBER INTEGER) CREATE MEMORY TABLE FAMILY2(DESCRIPTION VARCHAR(40),NUMBER INTEGER NOT NULL PRIMARY KEY) *************** *** 41,45 **** CREATE MEMORY TABLE SUBFAMILY(FAMILY INTEGER,DESCRIPTION VARCHAR(40),OID VARCHAR(32) NOT NULL PRIMARY KEY,NUMBER DECIMAL,REMARKS VARCHAR(400)) CREATE MEMORY TABLE SUBFAMILY2(FAMILY INTEGER,DESCRIPTION VARCHAR(40),NUMBER DECIMAL NOT NULL PRIMARY KEY,REMARKS VARCHAR(400),CONSTRAINT FK93F48F27A57D59B7 FOREIGN KEY(FAMILY) REFERENCES FAMILY2(NUMBER)) ! CREATE MEMORY TABLE CARRIER(WAREHOUSE_ZONE INTEGER,WAREHOUSE_NUMBER INTEGER,NUMBER INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(40),DRIVINGLICENCE_TYPE VARCHAR(2) NOT NULL,DRIVINGLICENCE_LEVEL INTEGER,REMARKS VARCHAR(500),CONSTRAINT FK25393D7FCAFD6A75 FOREIGN KEY(WAREHOUSE_ZONE,WAREHOUSE_NUMBER) REFERENCES WAREHOUSE(ZONE,NUMBER)) CREATE MEMORY TABLE DRIVINGLICENCE(TYPE VARCHAR(2) NOT NULL,LEVEL INTEGER NOT NULL,DESCRIPTION VARCHAR(40),PRIMARY KEY(TYPE,LEVEL)) CREATE MEMORY TABLE DRIVER(NUMBER INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(40),TYPE VARCHAR(2) NOT NULL,DRIVINGLICENCE_LEVEL INTEGER) --- 41,45 ---- CREATE MEMORY TABLE SUBFAMILY(FAMILY INTEGER,DESCRIPTION VARCHAR(40),OID VARCHAR(32) NOT NULL PRIMARY KEY,NUMBER DECIMAL,REMARKS VARCHAR(400)) CREATE MEMORY TABLE SUBFAMILY2(FAMILY INTEGER,DESCRIPTION VARCHAR(40),NUMBER DECIMAL NOT NULL PRIMARY KEY,REMARKS VARCHAR(400),CONSTRAINT FK93F48F27A57D59B7 FOREIGN KEY(FAMILY) REFERENCES FAMILY2(NUMBER)) ! CREATE MEMORY TABLE CARRIER(WAREHOUSE_ZONE INTEGER,WAREHOUSE_NUMBER NUMERIC,NUMBER INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(40),DRIVINGLICENCE_TYPE VARCHAR(2) NOT NULL,DRIVINGLICENCE_LEVEL INTEGER,REMARKS VARCHAR(500),CONSTRAINT FK25393D7FCAFD6A75 FOREIGN KEY(WAREHOUSE_ZONE,WAREHOUSE_NUMBER) REFERENCES WAREHOUSE(ZONE,NUMBER)) CREATE MEMORY TABLE DRIVINGLICENCE(TYPE VARCHAR(2) NOT NULL,LEVEL INTEGER NOT NULL,DESCRIPTION VARCHAR(40),PRIMARY KEY(TYPE,LEVEL)) CREATE MEMORY TABLE DRIVER(NUMBER INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(40),TYPE VARCHAR(2) NOT NULL,DRIVINGLICENCE_LEVEL INTEGER) *************** *** 50,54 **** CREATE MEMORY TABLE SHIPMENT(TYPE VARCHAR(1) NOT NULL,MODE INTEGER NOT NULL,NUMBER INTEGER NOT NULL,DESCRIPTION VARCHAR(50),TIME TIMESTAMP,CUSTOMERCONTACT INTEGER,PRIMARY KEY(TYPE,MODE,NUMBER)) CREATE MEMORY TABLE OFFICE(ZONE INTEGER NOT NULL,NUMBER INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(40),WAREHOUSE_ZONE INTEGER,WAREHOUSE_NUMBER INTEGER,MANAGER_NUMBER INTEGER,CARRIER_NUMBER INTEGER,RECEPTIONIST_OID INTEGER) ! CREATE MEMORY TABLE OFFICE2(ZONE INTEGER NOT NULL,NUMBER INTEGER NOT NULL,NAME VARCHAR(40),WAREHOUSE_ZONE INTEGER,WAREHOUSE_NUMBER INTEGER NOT NULL,MANAGER_NUMBER INTEGER,CARRIER_NUMBER INTEGER,RECEPTIONIST_OID INTEGER,PRIMARY KEY(ZONE,NUMBER,WAREHOUSE_NUMBER),CONSTRAINT FKA7DEF79DCB7CAA79 FOREIGN KEY(ZONE,WAREHOUSE_NUMBER) REFERENCES WAREHOUSE(ZONE,NUMBER)) CREATE MEMORY TABLE CLERK(ZONE INTEGER NOT NULL,OFFICE INTEGER NOT NULL,NUMBER INTEGER NOT NULL,NAME VARCHAR(40),ARRIVALTIME TIME,ENDINGTIME VARCHAR(5),COMMENTS VARBINARY(500),PRIMARY KEY(ZONE,OFFICE,NUMBER)) CREATE MEMORY TABLE DELIVERYDETAIL(NUMBER INTEGER NOT NULL PRIMARY KEY,DELIVERY_INVOICE_YEAR INTEGER,DELIVERY_INVOICE_NUMBER INTEGER,DELIVERY_TYPE_NUMBER INTEGER,DELIVERY_NUMBER INTEGER,DESCRIPTION VARCHAR(50)) --- 50,54 ---- CREATE MEMORY TABLE SHIPMENT(TYPE VARCHAR(1) NOT NULL,MODE INTEGER NOT NULL,NUMBER INTEGER NOT NULL,DESCRIPTION VARCHAR(50),TIME TIMESTAMP,CUSTOMERCONTACT INTEGER,PRIMARY KEY(TYPE,MODE,NUMBER)) CREATE MEMORY TABLE OFFICE(ZONE INTEGER NOT NULL,NUMBER INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(40),WAREHOUSE_ZONE INTEGER,WAREHOUSE_NUMBER INTEGER,MANAGER_NUMBER INTEGER,CARRIER_NUMBER INTEGER,RECEPTIONIST_OID INTEGER) ! CREATE MEMORY TABLE OFFICE2(ZONE INTEGER NOT NULL,NUMBER INTEGER NOT NULL,NAME VARCHAR(40),WAREHOUSE_ZONE INTEGER,WAREHOUSE_NUMBER NUMERIC NOT NULL,MANAGER_NUMBER INTEGER,CARRIER_NUMBER INTEGER,RECEPTIONIST_OID INTEGER,PRIMARY KEY(ZONE,NUMBER,WAREHOUSE_NUMBER),CONSTRAINT FKA7DEF79DCB7CAA79 FOREIGN KEY(ZONE,WAREHOUSE_NUMBER) REFERENCES WAREHOUSE(ZONE,NUMBER)) CREATE MEMORY TABLE CLERK(ZONE INTEGER NOT NULL,OFFICE INTEGER NOT NULL,NUMBER INTEGER NOT NULL,NAME VARCHAR(40),ARRIVALTIME TIME,ENDINGTIME VARCHAR(5),COMMENTS VARBINARY(500),PRIMARY KEY(ZONE,OFFICE,NUMBER)) CREATE MEMORY TABLE DELIVERYDETAIL(NUMBER INTEGER NOT NULL PRIMARY KEY,DELIVERY_INVOICE_YEAR INTEGER,DELIVERY_INVOICE_NUMBER INTEGER,DELIVERY_TYPE_NUMBER INTEGER,DELIVERY_NUMBER INTEGER,DESCRIPTION VARCHAR(50)) *************** *** 78,82 **** ALTER TABLE COMMENT ADD CONSTRAINT FK9BDE863F3D46815F FOREIGN KEY(ISSUE_ID) REFERENCES ISSUE(ID) ALTER TABLE ISSUE ADD CONSTRAINT FK43AB8B9B97FB755 FOREIGN KEY(WORKER_ID) REFERENCES WORKER(ID) ! ALTER TABLE COLOR ALTER COLUMN NUMBER RESTART WITH 232 ALTER TABLE COMMENT ALTER COLUMN ID RESTART WITH 1 ALTER TABLE OPENXAVA_TABUSERPREFERENCES ALTER COLUMN OID RESTART WITH 1 --- 78,82 ---- ALTER TABLE COMMENT ADD CONSTRAINT FK9BDE863F3D46815F FOREIGN KEY(ISSUE_ID) REFERENCES ISSUE(ID) ALTER TABLE ISSUE ADD CONSTRAINT FK43AB8B9B97FB755 FOREIGN KEY(WORKER_ID) REFERENCES WORKER(ID) ! ALTER TABLE COLOR ALTER COLUMN NUMBER RESTART WITH 233 ALTER TABLE COMMENT ALTER COLUMN ID RESTART WITH 1 ALTER TABLE OPENXAVA_TABUSERPREFERENCES ALTER COLUMN OID RESTART WITH 1 *************** *** 98,235 **** SET WRITE_DELAY 20 SET SCHEMA TRACKING ! INSERT INTO ACCESS VALUES(63476,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:27','C',1,'{number=666, zoneNumber=66}') ! INSERT INTO ACCESS VALUES(63477,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:27','R',1,'{number=666, zoneNumber=66}') ! INSERT INTO ACCESS VALUES(63478,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:27','U',1,'{number=666, zoneNumber=66}') ! INSERT INTO ACCESS VALUES(63479,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:27','R',1,'{number=666, zoneNumber=66}') ! INSERT INTO ACCESS VALUES(63480,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:27','D',1,'{number=666, zoneNumber=66}') ! INSERT INTO ACCESS VALUES(63481,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:27','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63482,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:28','R',1,'{number=2, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63483,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:28','R',1,'{number=1, zoneNumber=3}') ! INSERT INTO ACCESS VALUES(63484,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:28','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63485,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:28','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63486,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:29','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63487,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:29','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63488,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:29','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63489,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:29','R',1,'{number=2, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63490,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:29','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63491,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:29','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63492,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:29','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63493,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:29','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63494,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:29','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63495,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:29','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63496,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:29','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63497,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:29','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63498,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:29','R',1,'{number=1, zoneNumber=3}') ! INSERT INTO ACCESS VALUES(63499,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:29','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63500,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:29','R',1,'{number=3, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63501,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:29','R',1,'{number=1, zoneNumber=3}') ! INSERT INTO ACCESS VALUES(63502,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:31','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63503,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:32','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63504,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:33','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63505,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:33','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63506,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:33','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63507,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:33','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63508,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:33','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63509,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:33','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63510,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:33','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63511,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:34','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63512,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:34','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63513,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:34','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63514,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:34','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63515,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:34','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63516,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:34','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63517,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:34','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63518,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:34','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63519,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:34','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63520,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:34','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63521,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:34','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63522,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:34','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63523,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:34','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63524,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:34','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63525,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:34','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63526,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:34','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63527,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:34','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63528,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:34','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63529,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:34','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63530,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:34','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63531,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:34','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63532,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:35','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63533,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:35','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63534,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:35','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63535,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:35','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63536,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:35','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63537,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:35','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63538,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:35','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63539,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:35','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63540,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:35','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63541,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:35','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63542,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:35','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63543,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:36','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63544,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:36','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63545,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:36','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63546,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:36','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63547,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:36','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63548,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:36','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63549,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:36','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63550,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:36','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63551,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:36','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63552,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:36','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63553,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:36','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63554,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:36','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63555,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:36','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63556,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:36','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63557,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:36','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63558,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:36','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63559,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:36','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63560,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:36','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63561,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:36','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63562,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:36','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63563,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:36','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63564,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:36','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63565,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:36','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63566,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:36','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63567,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:36','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63568,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:37','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63569,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:37','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63570,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:37','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63571,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:37','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63572,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:37','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63573,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:37','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63574,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:37','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63575,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:37','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63576,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:37','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63577,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:37','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63578,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:37','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63579,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:44','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63580,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:47','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63581,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:51','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63582,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:52','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63583,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:54','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63584,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:55','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63585,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:56','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63586,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','11:57','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63587,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','12:18','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63588,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','12:18','R',1,'{number=2, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63589,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','12:18','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63590,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','12:18','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63591,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','12:18','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63592,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','12:18','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63593,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','12:18','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63594,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','12:19','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63595,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','12:20','R',1,'{number=1, zoneNumber=3}') ! INSERT INTO ACCESS VALUES(63596,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','12:20','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63597,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','12:20','R',1,'{number=1, zoneNumber=3}') ! INSERT INTO ACCESS VALUES(63598,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','12:20','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63599,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','12:20','R',1,'{number=3, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63600,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','12:20','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63601,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','12:20','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63602,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','12:20','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63603,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','12:20','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63604,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','12:21','R',1,'{number=1, zoneNumber=3}') ! INSERT INTO ACCESS VALUES(63605,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','12:21','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63606,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','12:21','R',1,'{number=1, zoneNumber=3}') ! INSERT INTO ACCESS VALUES(63607,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','12:27','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63608,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','12:27','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63609,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-10','12:28','R',1,'{number=1, zoneNumber=1}') SET SCHEMA DUAL_XAVATEST INSERT INTO SIZE_ID_SEQ VALUES(1) --- 98,132 ---- SET WRITE_DELAY 20 SET SCHEMA TRACKING ! INSERT INTO ACCESS VALUES(63765,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-26','17:02','C',1,'{number=666, zoneNumber=66}') ! INSERT INTO ACCESS VALUES(63766,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-26','17:02','R',1,'{number=666, zoneNumber=66}') ! INSERT INTO ACCESS VALUES(63767,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-26','17:02','U',1,'{number=666, zoneNumber=66}') ! INSERT INTO ACCESS VALUES(63768,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-26','17:02','R',1,'{number=666, zoneNumber=66}') ! INSERT INTO ACCESS VALUES(63769,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-26','17:02','D',1,'{number=666, zoneNumber=66}') ! INSERT INTO ACCESS VALUES(63770,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-26','17:02','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63771,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-26','17:03','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63772,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-26','17:04','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63773,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-26','17:06','R',1,'{number=1, zoneNumber=3}') ! INSERT INTO ACCESS VALUES(63774,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-26','17:06','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63775,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-26','17:06','R',1,'{number=3, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63776,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-26','17:06','R',1,'{number=1, zoneNumber=3}') ! INSERT INTO ACCESS VALUES(63777,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-26','17:06','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63778,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-26','17:06','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63779,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-26','17:06','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63780,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-26','17:06','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63781,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-26','17:06','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63782,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-26','17:06','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63783,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-26','17:06','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63784,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-26','17:06','R',1,'{number=2, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63785,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-26','17:06','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63786,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-26','17:06','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63787,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-26','17:06','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63788,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-26','17:06','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63789,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-26','17:06','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63790,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-26','17:07','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63791,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-26','17:07','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63792,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-26','17:07','R',1,'{number=1, zoneNumber=3}') ! INSERT INTO ACCESS VALUES(63793,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-26','17:08','R',1,'{number=1, zoneNumber=1}') ! INSERT INTO ACCESS VALUES(63794,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-26','17:08','R',1,'{number=1, zoneNumber=2}') ! INSERT INTO ACCESS VALUES(63795,'test','Warehouse','XAVATEST.Warehouse','nobody','2009-06-26','17:08','R',1,'{number=1, zoneNumber=1}') SET SCHEMA DUAL_XAVATEST INSERT INTO SIZE_ID_SEQ VALUES(1) *************** *** 423,431 **** INSERT INTO SIZE VALUES(216,'JUNIT SIZE 20') INSERT INTO SIZE VALUES(217,'JUNIT SIZE 16') INSERT INTO SERVICEINVOICE VALUES('402881961623e3aa011623ed945b0002',2007,1,'Primer servicio',790.00) INSERT INTO SERVICEINVOICE VALUES('402881961623e3aa011623ee6df10003',2007,2,'Second service',1730.00) INSERT INTO COLOR VALUES(0,'ROJO',1,'FF0000') INSERT INTO COLOR VALUES(1,'NEGRO',1,'000000') ! INSERT INTO COLOR VALUES(28,'COLOR B2',222,'3333FF') INSERT INTO COLOR VALUES(176,'JUNIT COLOR 15',0,NULL) INSERT INTO COLOR VALUES(177,'JUNIT COLOR 87',0,NULL) --- 320,329 ---- INSERT INTO SIZE VALUES(216,'JUNIT SIZE 20') INSERT INTO SIZE VALUES(217,'JUNIT SIZE 16') + INSERT INTO SIZE VALUES(218,'JUNIT SIZE 128') INSERT INTO SERVICEINVOICE VALUES('402881961623e3aa011623ed945b0002',2007,1,'Primer servicio',790.00) INSERT INTO SERVICEINVOICE VALUES('402881961623e3aa011623ee6df10003',2007,2,'Second service',1730.00) INSERT INTO COLOR VALUES(0,'ROJO',1,'FF0000') INSERT INTO COLOR VALUES(1,'NEGRO',1,'000000') ! INSERT INTO COLOR VALUES(28,'COLOR B2',224,'3333FF') INSERT INTO COLOR VALUES(176,'JUNIT COLOR 15',0,NULL) INSERT INTO COLOR VALUES(177,'JUNIT COLOR 87',0,NULL) *************** *** 484,487 **** --- 382,386 ---- INSERT INTO COLOR VALUES(230,'JUNIT COLOR 91',0,'') INSERT INTO COLOR VALUES(231,'JUNIT COLOR 81',0,'') + INSERT INTO COLOR VALUES(232,'JUNIT COLOR 26',0,'') INSERT INTO FORMULA VALUES('8D399FB4C0A80116081480A154F71F21','HTML TEST','Esto es una prueba<br />\u000d\u000ade <em><strong>HTML</strong></em><br de="" />\u000d\u000aDex oscuro <strong>negro</strong> y trágico <font color="#ff0000">rojo</font>, de muerte y <strong>dolor<br />\u000d\u000aY largo</strong>,<span style="background-color: rgb(153, 204, 0);"> verde </span>y <font color="#993300"><strong>marrón</strong></font> como los <em>ojitos</em> del <font size="5">mundo</font>.<br />\u000d\u000a<br en="" />\u000d\u000a<font color="#00b0d0"></font>') INSERT INTO FORMULA VALUES('FB8B0443C0A8011600ACDD02B3C81CD4','JUNIT FROM MapFacade','') *************** *** 491,495 **** INSERT INTO INGREDIENT VALUES('03C6C61DC0A801160000000076765581','LECHE CONDENSADA',NULL,NULL) INSERT INTO INGREDIENT VALUES('03C6E1ADC0A8011600000000498BC537','CAFE CON LECHE',NULL,NULL) ! INSERT INTO SHIPMENTCHARGE VALUES('4028819621c97c1d0121c9b638c10011',1,'I',1,150.00) INSERT INTO FORMULAINGREDIENT VALUES('4028819820ae7b8a0120ae7d1aa80004','03C5C64CC0A80116000000009590B64C',NULL,NULL,'8D399FB4C0A80116081480A154F71F21',NULL) INSERT INTO FORMULAINGREDIENT VALUES('4028819820ae7b8a0120ae7d244d0005','03C59CF0C0A8011600000000618CC74B',NULL,NULL,'8D399FB4C0A80116081480A154F71F21',NULL) --- 390,394 ---- INSERT INTO INGREDIENT VALUES('03C6C61DC0A801160000000076765581','LECHE CONDENSADA',NULL,NULL) INSERT INTO INGREDIENT VALUES('03C6E1ADC0A8011600000000498BC537','CAFE CON LECHE',NULL,NULL) ! INSERT INTO SHIPMENTCHARGE VALUES('402881962218b52a012218ea1cd80011',1,'I',1,150.00) INSERT INTO FORMULAINGREDIENT VALUES('4028819820ae7b8a0120ae7d1aa80004','03C5C64CC0A80116000000009590B64C',NULL,NULL,'8D399FB4C0A80116081480A154F71F21',NULL) INSERT INTO FORMULAINGREDIENT VALUES('4028819820ae7b8a0120ae7d244d0005','03C59CF0C0A8011600000000618CC74B',NULL,NULL,'8D399FB4C0A80116081480A154F71F21',NULL) *************** *** 634,638 **** INSERT INTO RECEPTIONIST VALUES(3,1,'JUAN') INSERT INTO RECEPTIONIST VALUES(4,1,'PEPE') ! INSERT INTO PRODUCT VALUES(1,'MULTAS DE TRAFICO',1,2,3,1,11.00,'','C9AF5D81C0A80116000000002AEA8B5F',NULL,NULL,28) INSERT INTO PRODUCT VALUES(2,'IBM ESERVER ISERIES 270',1,11,1,2,20,'','0D6E8E66C0A8011600000000E96D87B9',NULL,NULL,NULL) INSERT INTO PRODUCT VALUES(1,'XAVA',3,1,1,3,0,'',NULL,NULL,NULL,NULL) --- 533,537 ---- INSERT INTO RECEPTIONIST VALUES(3,1,'JUAN') INSERT INTO RECEPTIONIST VALUES(4,1,'PEPE') ! INSERT INTO PRODUCT VALUES(1,'MULTAS DE TRAFICO',1,2,3,1,11.00,'','18E47CADC0A8011600000000F374E639',NULL,NULL,28) INSERT INTO PRODUCT VALUES(2,'IBM ESERVER ISERIES 270',1,11,1,2,20,'','0D6E8E66C0A8011600000000E96D87B9',NULL,NULL,NULL) INSERT INTO PRODUCT VALUES(1,'XAVA',3,1,1,3,0,'',NULL,NULL,NULL,NULL) *************** *** 726,730 **** INSERT INTO SHIPMENT VALUES('I',1,1,'UNO INTERNO',NULL,NULL) INSERT INTO SHIPMENT VALUES('I',2,5,'CINC','2006-12-25 11:33:00.0',NULL) ! INSERT INTO CLERK VALUES(1,1,1,'PEPE','11:37:00','11:37','437265617465642061742031313a3337') INSERT INTO CLERK VALUES(1,1,2,'JUAN',NULL,NULL,NULL) INSERT INTO CLERK VALUES(1,2,1,'ANTONIO',NULL,NULL,NULL) --- 625,629 ---- INSERT INTO SHIPMENT VALUES('I',1,1,'UNO INTERNO',NULL,NULL) INSERT INTO SHIPMENT VALUES('I',2,5,'CINC','2006-12-25 11:33:00.0',NULL) ! INSERT INTO CLERK VALUES(1,1,1,'PEPE','20:48:00','20:48','437265617465642061742032303a3438') INSERT INTO CLERK VALUES(1,1,2,'JUAN',NULL,NULL,NULL) INSERT INTO CLERK VALUES(1,2,1,'ANTONIO',NULL,NULL,NULL) *************** *** 747,750 **** --- 646,650 ---- INSERT INTO COURSE VALUES(2007,9948,'JUNIT FROM MapFacade') INSERT INTO COURSE VALUES(2007,11102,'JUNIT FROM MapFacade') + INSERT INTO COURSE VALUES(2007,11194,'JUNIT FROM MapFacade') INSERT INTO COURSE VALUES(2007,11499,'JUNIT FROM MapFacade') INSERT INTO COURSE VALUES(2007,14178,'JUNIT FROM MapFacade') *************** *** 842,845 **** --- 742,747 ---- INSERT INTO BLOGCOMMENT VALUES('BlogComment','4028819621bf02a50121bf12f49c0004','Me too','2009-06-08 00:00:00.0',NULL,'4028819621a5ce730121a5cf69910001') INSERT INTO BLOGCOMMENT VALUES('BlogComment','4028819621c97c1d0121c981042f0003','Me too','2009-06-10 00:00:00.0',NULL,'4028819621a5ce730121a5cf69910001') + INSERT INTO BLOGCOMMENT VALUES('BlogComment','402881962218b52a012218b9880a0003','Me too','2009-06-25 00:00:00.0',NULL,'4028819621a5ce730121a5cf69910001') + INSERT INTO BLOGCOMMENT VALUES('BlogComment','402881962218b52a01221d19ea460012','Me too','2009-06-26 00:00:00.0',NULL,'4028819621a5ce730121a5cf69910001') SET SCHEMA COMPANYA INSERT INTO ISSUE VALUES('A0001','COMPANY A ISSUE 1',NULL) |