summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2012-06-05 20:56:02 +0200
committerYorhel <git@yorhel.nl>2012-06-05 20:56:02 +0200
commit32650cb653766d1cf3de6bd7f1719fb554b5e086 (patch)
treedc89b130a6f128b8a6a116758a73a374f1f9b07d /util
parentee1c00e6a9fbd6faa4d3e1a7c3465e8c6d588425 (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.sql8
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)
);