>si possibile
>prova a digitare in SQL
>Script 'nomechevuoi.txt'
>clicca su esegui
>leggi il file nella tua home e dimmi cosa vedi
>
te lo allego
ora mi sa che devo rimboccarmi le maniche per capire come si usa MySQL
poi come collegarlo a Base
e poi chi lo sa
... non si finisce mai di imparare
... e nemmeno di tribolare
intanto grazie
SET DATABASE COLLATION "Italian"
CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE CACHED TABLE "IterProgettazione"("IDITER" INTEGER GENERATED BY DEFAULT
AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"IDPROG" INTEGER,"LIVELLO"
VARCHAR(100),"CUP" VARCHAR(20),"CIG" VARCHAR(20),"DATAAPPR" DATE,"DELGCAPPR"
VARCHAR(100),"IMPLAVORI" NUMERIC(10,2),"SOMMEAMM" NUMERIC(10,2),"PROGETT"
VARCHAR(100),"INTERNO" BOOLEAN,"SICUREZZA" BOOLEAN,"COORDPROG" VARCHAR(100))
CREATE CACHED TABLE "AnagraficaDitte"("IDDITTA" INTEGER GENERATED BY DEFAULT AS
IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"DITTA" VARCHAR(100),"RAGSOC"
VARCHAR(10),"INDVIA" VARCHAR(25),"INDCAP" SMALLINT,"INDCITTA"
VARCHAR(30),"INDPROV" VARCHAR(30),"PIVA" NUMERIC(11),"CODFISC"
VARCHAR(13),"INAIL" VARCHAR(20),"INPS" VARCHAR(20),"CASSAED"
VARCHAR(20),"CCIAA" VARCHAR(11))
CREATE CACHED TABLE "Pagamenti"("IDPAGAMENTO" INTEGER GENERATED BY DEFAULT AS
IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"IDESEC" INTEGER,"SALN"
VARCHAR(100),"IMPORTO" VARCHAR(100),"DATACERT" VARCHAR(100),"DATADURC"
VARCHAR(100),"NDURC" VARCHAR(100),"ESITODURC" BOOLEAN)
CREATE CACHED TABLE "Sospensioni"("IDSOSP" INTEGER GENERATED BY DEFAULT AS
IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"IDESECUZIONE" INTEGER,"DATASOSP"
DATE,"DATARIP" DATE)
CREATE CACHED TABLE "Proroghe"("IDPROROGA" INTEGER GENERATED BY DEFAULT AS
IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"IDESECUZIONE" INTEGER,"DATAPROR"
VARCHAR(100),"DURATA" VARCHAR(100))
CREATE CACHED TABLE "Contratti"("IDCONTRATTO" INTEGER GENERATED BY DEFAULT AS
IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"IDESECUZIONE" INTEGER,"REPERTORIO"
SMALLINT,"DATACONTR" DATE,"IMPCONTR" NUMERIC(10,1),"REGDATA" DATE,"REGLUOGO"
VARCHAR(30),"REGEREG" VARCHAR(10))
CREATE CACHED TABLE "Codifica"("IDCOD" INTEGER NOT NULL PRIMARY KEY,"ANNO"
VARCHAR(4),"CODAMB" VARCHAR(3),"CODSTRU" VARCHAR(100))
CREATE CACHED TABLE "Ambiti"("CODAMB" VARCHAR(2) NOT NULL PRIMARY KEY,"AMBITO"
VARCHAR(30) NOT NULL)
CREATE CACHED TABLE "Progetti"("IDPROGETTO" INTEGER NOT NULL PRIMARY
KEY,"TITOLO" VARCHAR(50),"OGGETTO" VARCHAR(50),"STANZ" NUMERIC(10,2),"IDSTRU"
INTEGER,"FINANZ" VARCHAR(50),"ARCHARM" VARCHAR(50),"ARCHRIP"
VARCHAR(50),"ANNOPROG" VARCHAR(50),"AMBITO" VARCHAR(50),"STRUTTURA"
VARCHAR(50),CONSTRAINT SYS_FK_368 FOREIGN KEY("AMBITO") REFERENCES
"Ambiti"("CODAMB"))
CREATE CACHED TABLE "Esecuzione"("IDESECUZIONE" INTEGER GENERATED BY DEFAULT AS
IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"IDPROG" INTEGER,"DATAAFF"
DATE,"DETAFF" SMALLINT,"IDDITTA" INTEGER,"COORDESEC" VARCHAR(50),"DL"
VARCHAR(50),"CONSLAV" DATE,"DURATA" SMALLINT,"OFFERTA" NUMERIC(10,2),"RIBASSO"
NUMERIC(6,4),CONSTRAINT SYS_FK_157 FOREIGN KEY("IDDITTA") REFERENCES
"AnagraficaDitte"("IDDITTA"),CONSTRAINT SYS_FK_206 FOREIGN KEY("IDPROG")
REFERENCES "Progetti"("IDPROGETTO"))
CREATE CACHED TABLE "Fabbricati"("IDFABB" INTEGER NOT NULL PRIMARY
KEY,"FABBRICATO" VARCHAR(30) NOT NULL,"CODFABB" VARCHAR(4) NOT NULL)
CREATE CACHED TABLE "Aree verdi"("IDAVERDE" INTEGER NOT NULL PRIMARY
KEY,"NOMEAREAV" VARCHAR(30) NOT NULL,"CODAREAV" VARCHAR(4) NOT NULL,"IDSTRADA"
INTEGER)
CREATE CACHED TABLE "Strutture"("IDSTRU" INTEGER GENERATED BY DEFAULT AS
IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"IDAMB" VARCHAR(2),"SUBSTRU"
VARCHAR(1),"DESCSTRU" VARCHAR(50),"CODSTRADA" INTEGER,CONSTRAINT SYS_FK_310
FOREIGN KEY("IDAMB") REFERENCES "Ambiti"("CODAMB"))
CREATE CACHED TABLE "Strade"("IDSTRADA" INTEGER GENERATED BY DEFAULT AS
IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"NOMESTRADA" VARCHAR(255))
ALTER TABLE "IterProgettazione" ADD CONSTRAINT SYS_FK_139 FOREIGN KEY("IDPROG")
REFERENCES "Progetti"("IDPROGETTO")
ALTER TABLE "Pagamenti" ADD CONSTRAINT SYS_FK_148 FOREIGN KEY("IDESEC")
REFERENCES "Esecuzione"("IDESECUZIONE")
ALTER TABLE "Sospensioni" ADD CONSTRAINT SYS_FK_151 FOREIGN KEY("IDESECUZIONE")
REFERENCES "Esecuzione"("IDESECUZIONE")
ALTER TABLE "Proroghe" ADD CONSTRAINT SYS_FK_154 FOREIGN KEY("IDESECUZIONE")
REFERENCES "Esecuzione"("IDESECUZIONE")
ALTER TABLE "Contratti" ADD CONSTRAINT SYS_FK_145 FOREIGN KEY("IDESECUZIONE")
REFERENCES "Esecuzione"("IDESECUZIONE")
ALTER TABLE "Progetti" ADD CONSTRAINT SYS_FK_318 FOREIGN KEY("IDSTRU")
REFERENCES "Strutture"("IDSTRU")
ALTER TABLE "Strutture" ADD CONSTRAINT SYS_FK_349 FOREIGN KEY("CODSTRADA")
REFERENCES "Strade"("IDSTRADA")
ALTER TABLE "IterProgettazione" ALTER COLUMN "IDITER" RESTART WITH 0
ALTER TABLE "AnagraficaDitte" ALTER COLUMN "IDDITTA" RESTART WITH 2
ALTER TABLE "Pagamenti" ALTER COLUMN "IDPAGAMENTO" RESTART WITH 0
ALTER TABLE "Sospensioni" ALTER COLUMN "IDSOSP" RESTART WITH 0
ALTER TABLE "Proroghe" ALTER COLUMN "IDPROROGA" RESTART WITH 0
ALTER TABLE "Contratti" ALTER COLUMN "IDCONTRATTO" RESTART WITH 0
ALTER TABLE "Esecuzione" ALTER COLUMN "IDESECUZIONE" RESTART WITH 0
ALTER TABLE "Strutture" ALTER COLUMN "IDSTRU" RESTART WITH 64
ALTER TABLE "Strade" ALTER COLUMN "IDSTRADA" RESTART WITH 140
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 60
SET SCHEMA PUBLIC
INSERT INTO "Ambiti" VALUES('AL','Fabbricati')
INSERT INTO "Ambiti" VALUES('AV','Aree verdi')
INSERT INTO "Ambiti" VALUES('EC','Ecologia')
INSERT INTO "Ambiti" VALUES('FA','Fabbricati')
INSERT INTO "Ambiti" VALUES('IP','Illuminazione pubblica')
INSERT INTO "Ambiti" VALUES('ST','Strade')
INSERT INTO "Progetti" VALUES(1,'manutenzione strade comunali','manutenzione
straordinaria via Dante',150000.00,0,'misto',NULL,NULL,'2010','ST',NULL)
INSERT INTO "Fabbricati" VALUES(1,'Vari','F000')
INSERT INTO "Fabbricati" VALUES(2,'Municipio','F001')
INSERT INTO "Fabbricati" VALUES(3,'Distretto sanitario','F002')
INSERT INTO "Fabbricati" VALUES(4,'asilo nido','F003')
INSERT INTO "Fabbricati" VALUES(5,'scuola materna arcobaleno','F004')
INSERT INTO "Fabbricati" VALUES(6,'scuola elementare centro','F005')
INSERT INTO "Fabbricati" VALUES(7,'scuola elementare grumello','F006')
INSERT INTO "Fabbricati" VALUES(8,'scuola media','F007')
INSERT INTO "Fabbricati" VALUES(9,'magazzino comunale','F008')
INSERT INTO "Fabbricati" VALUES(10,'biblioteca','F009')
INSERT INTO "Fabbricati" VALUES(11,'centro diurno','F010')
INSERT INTO "Fabbricati" VALUES(12,'ambulatori via laguna','F011')
INSERT INTO "Fabbricati" VALUES(13,'stadio via rizzardini','F012')
INSERT INTO "Fabbricati" VALUES(14,'stadio vecchio','F013')
INSERT INTO "Fabbricati" VALUES(15,'auditorium','F014')
INSERT INTO "Fabbricati" VALUES(16,'palestra grumello','F015')
INSERT INTO "Fabbricati" VALUES(17,'palestra scuole medie','F016')
INSERT INTO "Fabbricati" VALUES(18,'casa ex galiotto','F017')
INSERT INTO "Fabbricati" VALUES(19,'birreria vecchia','F018')
INSERT INTO "Fabbricati" VALUES(20,'chiesetta ospizio','F019')
INSERT INTO "Fabbricati" VALUES(21,'appartamenti via ospizio','F020')
INSERT INTO "Aree verdi" VALUES(1,'AREE VARIE','V000',NULL)
INSERT INTO "Aree verdi" VALUES(2,'PIAVE1','V001',97)
INSERT INTO "Aree verdi" VALUES(3,'PIAVE2','V002',97)
INSERT INTO "Aree verdi" VALUES(4,'GRUMELLO','V003',69)
INSERT INTO "Aree verdi" VALUES(5,'LENGORE1','V004',72)
INSERT INTO "Aree verdi" VALUES(6,'ISONZO','V005',70)
INSERT INTO "Aree verdi" VALUES(7,'GARIBALDI','V006',65)
INSERT INTO "Aree verdi" VALUES(8,'MARONARO','V007',44)
INSERT INTO "Aree verdi" VALUES(9,'TONDELLE','V008',110)
INSERT INTO "Aree verdi" VALUES(10,'BRAGGI','V009',24)
INSERT INTO "Aree verdi" VALUES(11,'GRITTI','V010',16)
INSERT INTO "Aree verdi" VALUES(12,'PASCOLI','V011',64)
INSERT INTO "Aree verdi" VALUES(13,'LEOPARDI','V012',60)
INSERT INTO "Aree verdi" VALUES(14,'PAPA GIOVANNI','V013',94)
INSERT INTO "Aree verdi" VALUES(15,'ROSE','V014',139)
INSERT INTO "Aree verdi" VALUES(16,'BATTISTI','V015',35)
INSERT INTO "Aree verdi" VALUES(17,'VITTORIA','V016',6)
INSERT INTO "Aree verdi" VALUES(18,'GIARDINI RODARI','V017',6)
INSERT INTO "Aree verdi" VALUES(19,'ROSSI FTV','V018',15)
INSERT INTO "Aree verdi" VALUES(20,'GEN DALLA CHIESA','V019',9)
INSERT INTO "Aree verdi" VALUES(21,'OPERAIO','V020',12)
INSERT INTO "Aree verdi" VALUES(22,'TORARO','V021',89)
INSERT INTO "Aree verdi" VALUES(23,'CIMITERO NUOVO','V022',28)
INSERT INTO "Aree verdi" VALUES(24,'GIOVE','V023',82)
INSERT INTO "Aree verdi" VALUES(25,'PIALSTRI','V024',98)
INSERT INTO "Aree verdi" VALUES(26,'TRENTO','V025',113)
INSERT INTO "Aree verdi" VALUES(27,'ROTATORIA','V026',140)
INSERT INTO "Aree verdi" VALUES(28,'CIMITERO VECCHIO','V027',113)
INSERT INTO "Aree verdi" VALUES(29,'STADIO','V028',107)
INSERT INTO "Aree verdi" VALUES(30,'RIZZARDINI','V029',102)
INSERT INTO "Aree verdi" VALUES(31,'LENGORE2','V030',72)
INSERT INTO "Aree verdi" VALUES(32,'ADAMELLO','V031',78)
INSERT INTO "Aree verdi" VALUES(33,'CAMPILUNGHI','V032',29)
INSERT INTO "Aree verdi" VALUES(34,'PIP','V033',49)
INSERT INTO "Aree verdi" VALUES(35,'MANZONI','V034',14)
INSERT INTO "Aree verdi" VALUES(36,'LARICI','V035',37)
INSERT INTO "Aree verdi" VALUES(37,'THIENE','V036',109)
INSERT INTO "Strutture" VALUES(0,'FA',NULL,'Municipio',75)
INSERT INTO "Strutture" VALUES(1,'FA',NULL,'Distretto sanitario',70)
INSERT INTO "Strutture" VALUES(2,'FA',NULL,'Scuola materna Arcobaleno',105)
INSERT INTO "Strutture" VALUES(3,'FA',NULL,'Asilo Nido Le fontanelle',138)
INSERT INTO "Strutture" VALUES(4,'FA',NULL,'Scuola elementare centro',5)
INSERT INTO "Strutture" VALUES(5,'FA',NULL,'Scuola elementare Grumello',71)
INSERT INTO "Strutture" VALUES(6,'FA',NULL,'Scuola materna Grumello',71)
INSERT INTO "Strutture" VALUES(7,'FA',NULL,'Scuola media',124)
INSERT INTO "Strutture" VALUES(8,'FA',NULL,'Magazzino comunale',109)
INSERT INTO "Strutture" VALUES(9,'FA',NULL,'Biblioteca',124)
INSERT INTO "Strutture" VALUES(10,'FA',NULL,'Centro diurno',5)
INSERT INTO "Strutture" VALUES(11,'FA',NULL,'Ambulatori medici',70)
INSERT INTO "Strutture" VALUES(12,'FA',NULL,'Stadio Bertoldi',101)
INSERT INTO "Strutture" VALUES(13,'FA',NULL,'Stadio vecchio',106)
INSERT INTO "Strutture" VALUES(14,'FA',NULL,'Auditorium',4)
INSERT INTO "Strutture" VALUES(15,'FA',NULL,'Palestra Grumello',71)
INSERT INTO "Strutture" VALUES(16,'FA',NULL,'Palestra scuole medie',124)
INSERT INTO "Strutture" VALUES(17,'FA',NULL,'Casa Galiotto',5)
INSERT INTO "Strutture" VALUES(18,'FA',NULL,'Birreria vecchia',74)
INSERT INTO "Strutture" VALUES(19,'FA',NULL,'Chiesetta ospizio',92)
INSERT INTO "Strutture" VALUES(20,'FA',NULL,'Appartamenti ospizio',92)
INSERT INTO "Strutture" VALUES(21,'AV','1','Area verde via Piave 1',96)
INSERT INTO "Strutture" VALUES(22,'AV','2','Area verde via Piave 2',96)
INSERT INTO "Strutture" VALUES(23,'AV','1','Area verde via Grumello 1',68)
INSERT INTO "Strutture" VALUES(24,'AV','1','Area verde Lengore 1 scuole',71)
INSERT INTO "Strutture" VALUES(25,'AV','2','Area verde Lengore 2 lott.',71)
INSERT INTO "Strutture" VALUES(26,'AV',NULL,NULL,69)
INSERT INTO "Strutture" VALUES(27,'AV',NULL,NULL,64)
INSERT INTO "Strutture" VALUES(28,'AV',NULL,NULL,7)
INSERT INTO "Strutture" VALUES(29,'AV',NULL,NULL,109)
INSERT INTO "Strutture" VALUES(30,'AV',NULL,NULL,23)
INSERT INTO "Strutture" VALUES(31,'AV',NULL,NULL,15)
INSERT INTO "Strutture" VALUES(32,'AV',NULL,NULL,63)
INSERT INTO "Strutture" VALUES(33,'AV',NULL,NULL,59)
INSERT INTO "Strutture" VALUES(34,'AV',NULL,NULL,94)
INSERT INTO "Strutture" VALUES(35,'AV',NULL,'Q.re alle rose',105)
INSERT INTO "Strutture" VALUES(36,'AV',NULL,NULL,34)
INSERT INTO "Strutture" VALUES(37,'AV','1','Giardini pubblici comunali',5)
INSERT INTO "Strutture" VALUES(38,'AV','2','Giardino Rodari (ex Villa Sega)',5)
INSERT INTO "Strutture" VALUES(39,'AV',NULL,'Capolinea FTV',14)
INSERT INTO "Strutture" VALUES(40,'AV',NULL,NULL,8)
INSERT INTO "Strutture" VALUES(41,'AV',NULL,NULL,11)
INSERT INTO "Strutture" VALUES(42,'AV',NULL,NULL,88)
INSERT INTO "Strutture" VALUES(43,'AV',NULL,'Cimitero nuovo',27)
INSERT INTO "Strutture" VALUES(44,'AV',NULL,NULL,81)
INSERT INTO "Strutture" VALUES(45,'AV',NULL,NULL,97)
INSERT INTO "Strutture" VALUES(46,'AV','1',NULL,112)
INSERT INTO "Strutture" VALUES(47,'AV',NULL,'Rotatoria al Bivio',139)
INSERT INTO "Strutture" VALUES(48,'AV','2','Cimitero vecchio',112)
INSERT INTO "Strutture" VALUES(49,'AV','3','Stadio vecchio',112)
INSERT INTO "Strutture" VALUES(50,'AV',NULL,'Stadio Bertoldi',101)
INSERT INTO "Strutture" VALUES(51,'AV',NULL,NULL,72)
INSERT INTO "Strutture" VALUES(52,'AV',NULL,NULL,77)
INSERT INTO "Strutture" VALUES(53,'AV',NULL,'Zona PIP',48)
INSERT INTO "Strutture" VALUES(54,'AV',NULL,NULL,28)
INSERT INTO "Strutture" VALUES(55,'AV',NULL,NULL,13)
INSERT INTO "Strutture" VALUES(56,'AV',NULL,'Spartitraffico',108)
INSERT INTO "Strutture" VALUES(57,'AV',NULL,NULL,36)
INSERT INTO "Strutture" VALUES(58,'ST',NULL,'ST - Largo A. Peugeot',139)
INSERT INTO "Strutture" VALUES(59,'ST',NULL,'ST - Piazza Forziana',1)
INSERT INTO "Strutture" VALUES(60,'ST',NULL,'ST - Piazza G. Marconi',2)
INSERT INTO "Strutture" VALUES(61,'ST',NULL,'ST - Piazzale degli Alpini',4)
INSERT INTO "Strutture" VALUES(62,'ST',NULL,'ST - Piazzale Vittoria',5)
INSERT INTO "Strutture" VALUES(63,'ST',NULL,'ST - Piazza Papiria',3)
INSERT INTO "Strade" VALUES(1,'PIAZZA FORZIANA')
INSERT INTO "Strade" VALUES(2,'PIAZZA GUGLIELMO MARCONI')
INSERT INTO "Strade" VALUES(3,'PIAZZA PAPIRIA')
INSERT INTO "Strade" VALUES(4,'PIAZZALE DEGLI ALPINI')
INSERT INTO "Strade" VALUES(5,'PIAZZALE VITTORIA')
INSERT INTO "Strade" VALUES(6,'Q.RE A. DE GASPERI')
INSERT INTO "Strade" VALUES(7,'Q.RE DEL MARONARO')
INSERT INTO "Strade" VALUES(8,'Q.RE GEN.DALLA CHIESA')
INSERT INTO "Strade" VALUES(9,'Q.RE MONTE GRAPPA')
INSERT INTO "Strade" VALUES(10,'Q.RE MONTE MAGGIO')
INSERT INTO "Strade" VALUES(11,'Q.RE OPERAIO')
INSERT INTO "Strade" VALUES(12,'VIA ADIGE')
INSERT INTO "Strade" VALUES(13,'VIA MANZONI A.')
INSERT INTO "Strade" VALUES(14,'VIA ROSSI A.')
INSERT INTO "Strade" VALUES(15,'VIA GRITTI A.')
INSERT INTO "Strade" VALUES(16,'VIA FOGAZZARO A.')
INSERT INTO "Strade" VALUES(17,'VIA FUSINATO A.')
INSERT INTO "Strade" VALUES(18,'VIA ASTICO')
INSERT INTO "Strade" VALUES(19,'VIA BACCHIGLIONE')
INSERT INTO "Strade" VALUES(20,'VIA BASSANO')
INSERT INTO "Strade" VALUES(21,'VIA BELVEDERE')
INSERT INTO "Strade" VALUES(22,'VIA BIANCHE')
INSERT INTO "Strade" VALUES(23,'VIA BRAGGI')
INSERT INTO "Strade" VALUES(24,'VIA BRENTA')
INSERT INTO "Strade" VALUES(25,'VIA BURANO')
INSERT INTO "Strade" VALUES(26,'VIA CALCROSE')
INSERT INTO "Strade" VALUES(27,'VIA CALTRANO')
INSERT INTO "Strade" VALUES(28,'VIA CAMPILUNGHI')
INSERT INTO "Strade" VALUES(29,'VIA CASTEGNARE')
INSERT INTO "Strade" VALUES(30,'VIA CASTEL MANDUCA')
INSERT INTO "Strade" VALUES(31,'VIA CASTEL PELLUCA')
INSERT INTO "Strade" VALUES(32,'VIA CAVA''')
INSERT INTO "Strade" VALUES(33,'VIA CERIOTTI')
INSERT INTO "Strade" VALUES(34,'VIA CESARE BATTISTI')
INSERT INTO "Strade" VALUES(35,'VIA CIMA DODICI')
INSERT INTO "Strade" VALUES(36,'VIA CIMA LARICI')
INSERT INTO "Strade" VALUES(37,'VIA CIMITERO VECCHIO')
INSERT INTO "Strade" VALUES(38,'VIA CURTOLINI')
INSERT INTO "Strade" VALUES(39,'VIA DANTE ALIGHIERI')
INSERT INTO "Strade" VALUES(40,'VIA DEL BARCO')
INSERT INTO "Strade" VALUES(41,'VIA DEL BO''')
INSERT INTO "Strade" VALUES(42,'VIA DEL LAVORO')
INSERT INTO "Strade" VALUES(43,'VIA DEL MARONARO')
INSERT INTO "Strade" VALUES(44,'VIA DEL MONTE')
INSERT INTO "Strade" VALUES(45,'VIA DELL''ANGELO')
INSERT INTO "Strade" VALUES(46,'VIA DELL''ARTIGIANATO')
INSERT INTO "Strade" VALUES(47,'VIA DELLE FONTI')
INSERT INTO "Strade" VALUES(48,'VIA DELL''INDUSTRIA')
INSERT INTO "Strade" VALUES(49,'VIA DELLO SPORT')
INSERT INTO "Strade" VALUES(50,'VIA DON ANTONIO LUNARDI')
INSERT INTO "Strade" VALUES(51,'VIA FILZI F.')
INSERT INTO "Strade" VALUES(52,'VIA FALCONE E BORSELLINO')
INSERT INTO "Strade" VALUES(53,'VIA BERNARDI F.')
INSERT INTO "Strade" VALUES(54,'VIA FERRARI F.')
INSERT INTO "Strade" VALUES(55,'VIA PETRARCA F.')
INSERT INTO "Strade" VALUES(56,'VIA FRATELLI MARTINI')
INSERT INTO "Strade" VALUES(57,'VIA D''ANNUNZIO G.')
INSERT INTO "Strade" VALUES(58,'VIA GARZIERE')
INSERT INTO "Strade" VALUES(59,'VIA LEOPARDI G.')
INSERT INTO "Strade" VALUES(60,'VIA ZANELLA G.')
INSERT INTO "Strade" VALUES(61,'VIA GIARE')
INSERT INTO "Strade" VALUES(62,'VIA CARDUCCI G.')
INSERT INTO "Strade" VALUES(63,'VIA PASCOLI G.')
INSERT INTO "Strade" VALUES(64,'VIA GARIBALDI G.')
INSERT INTO "Strade" VALUES(65,'VIA MAZZINI G.')
INSERT INTO "Strade" VALUES(66,'VIA UNGARETTI G.')
INSERT INTO "Strade" VALUES(67,'VIA GORIZIA')
INSERT INTO "Strade" VALUES(68,'VIA GRUMELLO')
INSERT INTO "Strade" VALUES(69,'VIA ISONZO')
INSERT INTO "Strade" VALUES(70,'VIA LAGUNA')
INSERT INTO "Strade" VALUES(71,'VIA LENGORE 1')
INSERT INTO "Strade" VALUES(72,'VIA LENGORE 2')
INSERT INTO "Strade" VALUES(73,'VIA LEVA''')
INSERT INTO "Strade" VALUES(74,'VIA LEVRENA')
INSERT INTO "Strade" VALUES(75,'VIA LIBERTA''')
INSERT INTO "Strade" VALUES(76,'VIA LIVENZA')
INSERT INTO "Strade" VALUES(77,'VIA MONTE ADAMELLO')
INSERT INTO "Strade" VALUES(78,'VIA MONTE ANTELAO')
INSERT INTO "Strade" VALUES(79,'VIA MONTE CENGIO')
INSERT INTO "Strade" VALUES(80,'VIA MONTE CIMONE')
INSERT INTO "Strade" VALUES(81,'VIA MONTE GIOVE')
INSERT INTO "Strade" VALUES(82,'VIA MONTE NOVEGNO')
INSERT INTO "Strade" VALUES(83,'VIA MONTE ORTIGARA')
INSERT INTO "Strade" VALUES(84,'VIA MONTE PASUBIO')
INSERT INTO "Strade" VALUES(85,'VIA MONTE PELMO')
INSERT INTO "Strade" VALUES(86,'VIA MONTE PORTULE')
INSERT INTO "Strade" VALUES(87,'VIA MONTE PRIAFORA''')
INSERT INTO "Strade" VALUES(88,'VIA MONTE TORARO')
INSERT INTO "Strade" VALUES(89,'VIA MONTE VERENA')
INSERT INTO "Strade" VALUES(90,'VIA MURANO')
INSERT INTO "Strade" VALUES(91,'VIA NAZARIO SAURO')
INSERT INTO "Strade" VALUES(92,'VIA OSPIZIO')
INSERT INTO "Strade" VALUES(93,'VIA PAPA GIOVANNI PAOLO II')
INSERT INTO "Strade" VALUES(94,'VIA PAPA GIOVANNI XXIII')
INSERT INTO "Strade" VALUES(95,'VIA PELLESTRINA')
INSERT INTO "Strade" VALUES(96,'VIA PIAVE')
INSERT INTO "Strade" VALUES(97,'VIA PILASTRI')
INSERT INTO "Strade" VALUES(98,'VIA PREARE')
INSERT INTO "Strade" VALUES(99,'VIA PREAZZI DI SOPRA')
INSERT INTO "Strade" VALUES(100,'VIA PREAZZI DI SOTTO')
INSERT INTO "Strade" VALUES(101,'VIA RIZZARDINI')
INSERT INTO "Strade" VALUES(102,'VIA ROMA')
INSERT INTO "Strade" VALUES(103,'VIA ROVERETO')
INSERT INTO "Strade" VALUES(104,'VIA ROVREA')
INSERT INTO "Strade" VALUES(105,'VIA S. EUROSIA')
INSERT INTO "Strade" VALUES(106,'VIA STADIO')
INSERT INTO "Strade" VALUES(107,'VIA TAGLIAMENTO')
INSERT INTO "Strade" VALUES(108,'VIA THIENE')
INSERT INTO "Strade" VALUES(109,'VIA TONDELLE')
INSERT INTO "Strade" VALUES(110,'VIA TORCELLO')
INSERT INTO "Strade" VALUES(111,'VIA TORINO')
INSERT INTO "Strade" VALUES(112,'VIA TRENTO')
INSERT INTO "Strade" VALUES(113,'VIA TRIESTE')
INSERT INTO "Strade" VALUES(114,'VIA TRONCHETTO')
INSERT INTO "Strade" VALUES(115,'VIA ULISSE DELLAI')
INSERT INTO "Strade" VALUES(116,'VIA VAL LEOGRA')
INSERT INTO "Strade" VALUES(117,'VIA VAL POSINA')
INSERT INTO "Strade" VALUES(118,'VIA VAL RUDENELLA')
INSERT INTO "Strade" VALUES(119,'VIA VAL VOLPARA')
INSERT INTO "Strade" VALUES(120,'VIA VALLARSA')
INSERT INTO "Strade" VALUES(121,'VIA VALSUGANA')
INSERT INTO "Strade" VALUES(122,'VIA VENEZIA')
INSERT INTO "Strade" VALUES(123,'VIA VITTORIO VENETO')
INSERT INTO "Strade" VALUES(124,'VIALE MATTEOTTI G.')
INSERT INTO "Strade" VALUES(125,'VICOLO ASTICO')
INSERT INTO "Strade" VALUES(126,'VICOLO BELVEDERE')
INSERT INTO "Strade" VALUES(127,'VICOLO CASTEL MANDUCA')
INSERT INTO "Strade" VALUES(128,'VICOLO CHIESA')
INSERT INTO "Strade" VALUES(129,'VICOLO DEL MONTE')
INSERT INTO "Strade" VALUES(130,'VICOLO DELLA VIGNOLA')
INSERT INTO "Strade" VALUES(131,'VICOLO DELLE FONTI')
INSERT INTO "Strade" VALUES(132,'VICOLO GRUMELLO')
INSERT INTO "Strade" VALUES(133,'VICOLO LAGUNA')
INSERT INTO "Strade" VALUES(134,'VICOLO LEVRENA')
INSERT INTO "Strade" VALUES(135,'VICOLO MONTE MONTELLO')
INSERT INTO "Strade" VALUES(136,'VICOLO MONTE PAU''')
INSERT INTO "Strade" VALUES(137,'VICOLO SAN VITO')
INSERT INTO "Strade" VALUES(138,'VIA FORZIANA')
INSERT INTO "Strade" VALUES(139,'LARGO A. PEUGEOT')
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
