summaryrefslogtreecommitdiffstats
path: root/tqtinterface/qt4/tools/designer/examples/book/book.sql
diff options
context:
space:
mode:
Diffstat (limited to 'tqtinterface/qt4/tools/designer/examples/book/book.sql')
-rw-r--r--tqtinterface/qt4/tools/designer/examples/book/book.sql42
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 );