On 6 Dic, 14:43, "Jay A. Kreibich" <[email protected]> wrote:
> On Mon, Dec 06, 2010 at 06:20:13PM +0600, Dagdamor scratched on the wall:
>zac
Yes ...my error...i want translate name from italian....
I resolve error!
Table models is auto generate from csv import file...and...not have a
PK !!! i dont see this macro error!
Correct SQL:
Anagrafica (Owner)
CREATE TABLE [Anagrafica] (
[Idscheda] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
[Nominativo] NVARCHAR(100) NOT NULL,
[CF] NVARCHAR(16) NOT NULL,
[Indirizzo] NVARCHAR(100) NOT NULL,
[Citta] NVARCHAR(50) NOT NULL,
[Prov] NCHAR(2),
[CAP] NCHAR(5),
[telefono] NVARCHAR(30),
[fax] NVARCHAR(30),
[email] NVARCHAR(40),
[web] NVARCHAR(55),
[datareg] TIMESTAMP NOT NULL DEFAULT
('datetime(''now'',''localtime'')'),
[Mostra] BOOLEAN DEFAULT ('1'));
Modelli(Models)
CREATE TABLE "Modelli" (
[IDschedamodello] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
[Marca] NCHAR(25) NOT NULL,
[Modello] NCHAR(45) NOT NULL);
and.....
Vetture (Cars)
CREATE TABLE [Vetture] (
[IDvettura] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
[IDmodello] INTEGER NOT NULL CONSTRAINT [FKmodello] REFERENCES
[Modelli]([IDschedamodello]),
[IDproprietario] INTEGER NOT NULL CONSTRAINT [FKproprietario]
REFERENCES [Anagrafica]([Idscheda]),
[DataImmatricolazione] DATE,
[Targa] NVARCHAR(20) NOT NULL);
Sorry! :)
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
