It's funny how after looking at lines of code for several hours, you miss one little character.
On Tue, Dec 16, 2008 at 2:08 PM, D. Richard Hipp <d...@hwaci.com> wrote: > > On Dec 16, 2008, at 2:04 PM, David Frischknect wrote: > > > Hello, > > > > I'm having trouble with an SQL script file I'm using in my C# > > application. > > I'm trying to use the script file to create the database if the > > database > > does not exist when the program starts. As far as I can tell, there > > are no > > errors in the script file. > > > > ----begin pasted SQL script file > > CREATE TABLE Artist ( > > Artist_ID INTEGER PRIMARY KEY, > > Artist_Name TEXT NOT NULL > > ); > > > > CREATE TABLE Genre ( > > Genre_ID INTEGER PRIMARY KEY, > > Genre_Name TEXT NOT NULL > > ); > > > > CREATE TABLE Label ( > > Label_ID INTEGER PRIMARY KEY, > > Label_Name TEXT NOT NULL > > ); > > > > CREATE TABLE Medium ( > > Medium_ID INTEGER PRIMARY KEY, > > Medium_Name TEXT NOT NULL > > ); > > > > CREATE TABLE Album ( > > Album_ID INTEGER PRIMARY KEY, > > Album_Title TEXT NOT NULL, > > Album_Year NUMERIC, > > Artist_ID INTEGER NOT NULL REFERENCES Artist(Artist_ID), > > Genre_ID INTEGER NOT NULL REFERENCES Genre(Genre_ID, > > Did you omit the ")" at the end of the previous line? > > > > > > Medium_ID INTEGER NOT NULL REFERENCES Medium(Medium_ID), > > Album_Cover BLOB > > ); > > > > CREATE TABLE AlbumLabel ( > > Album_ID INTEGER NOT NULL REFERENCES Album(Album_ID), > > Label_ID INTEGER NOT NULL REFERENCES Label(Label_ID), > > PRIMARY KEY (Album_ID, Label_ID) > > ); > > > > CREATE TABLE Track ( > > Track_ID INTEGER PRIMARY KEY, > > Track_Number NUMERIC NOT NULL, > > Track_Title TEXT NOT NULL, > > Track_Length TEXT, > > Album_ID INTEGER NOT NULL REFERENCES Album(Album_ID) > > ); > > -----end pasted SQL script file > > > > -- > > David A. Frischknecht > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > D. Richard Hipp > d...@hwaci.com > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- David A. Frischknecht _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
