diff options
Diffstat (limited to 'tqtinterface/qt4/tools/designer/examples/book/book.sql')
-rw-r--r-- | tqtinterface/qt4/tools/designer/examples/book/book.sql | 42 |
1 files changed, 0 insertions, 42 deletions
diff --git a/tqtinterface/qt4/tools/designer/examples/book/book.sql b/tqtinterface/qt4/tools/designer/examples/book/book.sql deleted file mode 100644 index a92daac..0000000 --- a/tqtinterface/qt4/tools/designer/examples/book/book.sql +++ /dev/null @@ -1,42 +0,0 @@ --- The following SQL generates the database --- used by the 'book' example programs ---** Copyright (C) 2010 Timothy Pearson and (C) 1992-2008 Trolltech ASA. --- --- This file is part of an example program for Qt. This example --- program may be used, distributed and modified without limitation. - -DROP TABLE author; -DROP TABLE book; -DROP TABLE sequence; - -CREATE TABLE author -( id integer primary key, -forename varchar(40), -surname varchar(40) ); - -CREATE TABLE book -( id integer primary key, -title varchar(40), -price numeric(10,2), -authorid integer, -notes varchar(255) ); - -create index book_authorid_idx on book( authorid ); - -CREATE TABLE sequence -( tablename varchar(10), -sequence numeric); - -INSERT INTO author VALUES ( 0, 'Philip K', 'Dick' ); -INSERT INTO author VALUES ( 1, 'Robert', 'Heinlein' ); -INSERT INTO author VALUES ( 2, 'Sarah', 'Paretsky' ); - -INSERT INTO book VALUES ( 0, 'The Man Who Japed', 6.99, 0, 'A good book' ); -INSERT INTO book VALUES ( 1, 'The Man in the High Castle', 9.99, 0, 'Worth reading' ); -INSERT INTO book VALUES ( 2, 'The Number of the Beast', 8.99, 1, 'Get this!' ); -INSERT INTO book VALUES ( 3, 'Indemnity Only', 9.99, 2, 'Cool' ); -INSERT INTO book VALUES ( 4, 'Burn Marks', 9.99, 2, 'Need to make notes' ); -INSERT INTO book VALUES ( 5, 'Deadlock', 9.99, 2, 'Hmmm..' ); - -INSERT INTO sequence VALUES ( 'author', 2 ); -INSERT INTO sequence VALUES ( 'book', 5 ); |