diff options
Diffstat (limited to 'sqlplain/doc/books1.sql')
-rw-r--r-- | sqlplain/doc/books1.sql | 42 |
1 files changed, 0 insertions, 42 deletions
diff --git a/sqlplain/doc/books1.sql b/sqlplain/doc/books1.sql deleted file mode 100644 index 77da2ad..0000000 --- a/sqlplain/doc/books1.sql +++ /dev/null @@ -1,42 +0,0 @@ -CREATE TABLE bookid ( - id INTEGER PRIMARY KEY, - title VARCHAR(128), - author VARCHAR(64), - rdate DATETIME, - UNIQUE (title, author, rdate) -); - -CREATE TABLE score ( - score VARCHAR(4) PRIMARY KEY, - value INTEGER); - -INSERT INTO score VALUES ('+', 1); -INSERT INTO score VALUES ('O', 2); -INSERT INTO score VALUES ('O+', 3); -INSERT INTO score VALUES ('OO', 4); -INSERT INTO score VALUES ('OO+', 5); -INSERT INTO score VALUES ('OOO', 6); -INSERT INTO score VALUES ('OOO+', 7); -INSERT INTO score VALUES ('OOOO', 8); - -CREATE TABLE genre ( - id CHAR(2) PRIMARY KEY, - descr VARCHAR(32)) - -CREATE TABLE nation ( - id CHAR(2) PRIMARY KEY, - descr VARCHAR(32)); - -CREATE TABLE book ( - id INTEGER PRIMARY KEY REFERENCES bookid (id), - genre CHAR(2) REFERENCES genre (id), - nation CHAR(2) REFERENCES nation (id), - score INTEGER REFERENCES score (value)); - -CREATE VIEW book_view AS - SELECT a.id, a.title, a.author, a.rdate, b.genre, b.nation, c.score - FROM bookid AS a - INNER JOIN book AS b - ON a.id = b.id - INNER JOIN score AS c - ON c.value=b.score; |