diff options
author | Yorhel <git@yorhel.nl> | 2012-06-05 20:56:02 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2012-06-05 20:56:02 +0200 |
commit | 32650cb653766d1cf3de6bd7f1719fb554b5e086 (patch) | |
tree | dc89b130a6f128b8a6a116758a73a374f1f9b07d /util | |
parent | ee1c00e6a9fbd6faa4d3e1a7c3465e8c6d588425 (diff) |
schema.sql: Fix order of some columns + remove useless DEFAULT NULL
The ordering unfortunately matters for some tables, due to the edit_*
stored procedures relying on it. :-(
Diffstat (limited to 'util')
-rw-r--r-- | util/sql/schema.sql | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/util/sql/schema.sql b/util/sql/schema.sql index 3b7a3347..324f3f76 100644 --- a/util/sql/schema.sql +++ b/util/sql/schema.sql @@ -170,8 +170,8 @@ CREATE TABLE releases_platforms ( -- releases_producers CREATE TABLE releases_producers ( - rid integer NOT NULL, pid integer NOT NULL, + rid integer NOT NULL, developer boolean NOT NULL DEFAULT FALSE, publisher boolean NOT NULL DEFAULT TRUE, CHECK(developer OR publisher), @@ -415,7 +415,6 @@ CREATE TABLE vn_rev ( id integer NOT NULL PRIMARY KEY, vid integer NOT NULL DEFAULT 0, title varchar(250) NOT NULL DEFAULT '', - original varchar(250) NOT NULL DEFAULT '', alias varchar(500) NOT NULL DEFAULT '', img_nsfw boolean NOT NULL DEFAULT FALSE, length smallint NOT NULL DEFAULT 0, @@ -424,7 +423,8 @@ CREATE TABLE vn_rev ( l_vnn integer NOT NULL DEFAULT 0, image integer NOT NULL DEFAULT 0, l_encubed varchar(100) NOT NULL DEFAULT '', - l_renai varchar(100) NOT NULL DEFAULT '' + l_renai varchar(100) NOT NULL DEFAULT '', + original varchar(250) NOT NULL DEFAULT '' ); -- vn_screenshots @@ -432,7 +432,7 @@ CREATE TABLE vn_screenshots ( vid integer NOT NULL DEFAULT 0, scr integer NOT NULL DEFAULT 0, nsfw boolean NOT NULL DEFAULT FALSE, - rid integer DEFAULT NULL, + rid integer, PRIMARY KEY(vid, scr) ); |