[Trovacap-java-loginfo] jTrovaCap/data/hsqldb trova_cap.script, 1.1, 1.2
Brought to you by:
marcoratto
|
From: Marco R. <mar...@us...> - 2008-07-02 09:51:02
|
Update of /cvsroot/trovacap-java/jTrovaCap/data/hsqldb In directory sc8-pr-cvs10.sourceforge.net:/tmp/cvs-serv12152/data/hsqldb Modified Files: trova_cap.script Log Message: Update to release 1.2 Index: trova_cap.script =================================================================== RCS file: /cvsroot/trovacap-java/jTrovaCap/data/hsqldb/trova_cap.script,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** trova_cap.script 18 Jun 2007 09:57:29 -0000 1.1 --- trova_cap.script 2 Jul 2008 09:48:51 -0000 1.2 *************** *** 1,85077 **** CREATE SCHEMA PUBLIC AUTHORIZATION DBA ! CREATE MEMORY TABLE TAB_CAP(ID_CAP INTEGER NOT NULL PRIMARY KEY,PROV_CAP VARCHAR(50),COMU_CAP VARCHAR(50),COM2_CAP VARCHAR(50),FRAZ_CAP VARCHAR(50),FRA2_CAP VARCHAR(50),TOPO_CAP VARCHAR(50),TOP2_CAP VARCHAR(50),DUGT_CAP VARCHAR(50),NCIV_CAP VARCHAR(50),CAPI_CAP VARCHAR(50)) CREATE USER SA PASSWORD "" GRANT DBA TO SA SET WRITE_DELAY 10 SET SCHEMA PUBLIC ! INSERT INTO TAB_CAP VALUES(1,'AN','ANCONA','','','','ACHILLE BARILATTI','','VIA','','60127') ! INSERT INTO TAB_CAP VALUES(2,'AN','ANCONA','','','','AD ALTO','','VIA','','60122') ! INSERT INTO TAB_CAP VALUES(3,'AN','ANCONA','','','','AGOSTINO PERUZZI','','VIA','','60128') ! INSERT INTO TAB_CAP VALUES(4,'AN','ANCONA','','','','AGRICOLTURA','','VIA DELL''','','60127') [...170125 lines suppressed...] ! INSERT INTO CAP VALUES(85052,'VV','SORIANO CALABRO','','','','','','','','89831') ! INSERT INTO CAP VALUES(85053,'VV','SPADOLA','','','','','','','','89822') ! INSERT INTO CAP VALUES(85054,'VV','SPILINGA','','','','','','','','89864') ! INSERT INTO CAP VALUES(85055,'VV','SPILINGA','','PANAIA','','','','','','89864') ! INSERT INTO CAP VALUES(85056,'VV','STEFANACONI','','','','','','','','89843') ! INSERT INTO CAP VALUES(85057,'VV','TROPEA','','','','','','','','89861') ! INSERT INTO CAP VALUES(85058,'VV','VALLELONGA','','','','','','','','89821') ! INSERT INTO CAP VALUES(85059,'VV','VAZZANO','','','','','','','','89834') ! INSERT INTO CAP VALUES(85060,'VV','VIBO VALENTIA','','','','','','','','89900') ! INSERT INTO CAP VALUES(85061,'VV','VIBO VALENTIA','','LONGOBARDI','','','','','','89900') ! INSERT INTO CAP VALUES(85062,'VV','VIBO VALENTIA','','PISCOPIO','','','','','','89900') ! INSERT INTO CAP VALUES(85063,'VV','VIBO VALENTIA','','PORTO SALVO','','','','','','89900') ! INSERT INTO CAP VALUES(85064,'VV','VIBO VALENTIA','','TRIPARNI','','','','','','89900') ! INSERT INTO CAP VALUES(85065,'VV','VIBO VALENTIA','','VENA','VENA SUPERIORE','','','','','89900') ! INSERT INTO CAP VALUES(85066,'VV','VIBO VALENTIA','','VIBO MARINA','VIBO VALENTIA MARINA','','','','','89900') ! INSERT INTO CAP VALUES(85067,'VV','ZACCANOPOLI','','','','','','','','89867') ! INSERT INTO CAP VALUES(85068,'VV','ZAMBRONE','','','','','','','','89868') ! INSERT INTO CAP VALUES(85069,'VV','ZAMBRONE','','DAFFINA''','','','','','','89868') ! INSERT INTO CAP VALUES(85070,'VV','ZAMBRONE','','SAN GIOVANNI DI ZAMBRONE','','','','','','89868') ! INSERT INTO CAP VALUES(85071,'VV','ZUNGRI','','','','','','','','89867') |