summaryrefslogtreecommitdiff
path: root/util/sql/schema.sql
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2010-12-21 10:37:54 +0100
committerYorhel <git@yorhel.nl>2010-12-21 10:37:54 +0100
commit19e353c480091ec607324ee09a8821dd3d895975 (patch)
tree5cf8567f728e5539954d5b2e89ca25bbe4752350 /util/sql/schema.sql
parentd9aebf063c8ba2b6368418f9b9cab1fbbf241582 (diff)
Added notes field to the user VN list
The interface to set this could be more dynamic, since it'll be a lot of work to set different notes for each VN. But oh well, let's first see how many people will use this feature.
Diffstat (limited to 'util/sql/schema.sql')
-rw-r--r--util/sql/schema.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/util/sql/schema.sql b/util/sql/schema.sql
index a68a901d..eff5edde 100644
--- a/util/sql/schema.sql
+++ b/util/sql/schema.sql
@@ -346,6 +346,7 @@ CREATE TABLE vnlists (
vid integer NOT NULL,
status smallint NOT NULL DEFAULT 0,
added TIMESTAMPTZ NOT NULL DEFAULT NOW(),
+ notes varchar NOT NULL DEFAULT '',
PRIMARY KEY(uid, vid)
);