diff options
author | Yorhel <git@yorhel.nl> | 2015-09-06 03:35:36 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2015-09-06 03:35:36 +0200 |
commit | 19ce5fcf536ed478ad34b6b1014bf6f44841d25d (patch) | |
tree | 772556d6df88dc204f2a9dbe3d0cb118d94cc3cf /util/sql/schema.sql | |
parent | 6e0def1868b20ef1174d06c4bd8655548c024302 (diff) |
SQL: Convert threads_board.type to ENUM
The char(2) solution is both inefficient and ugly. Also needed to be
careful with handling the extra space that Postgres would automatically
add to single-character types.
Diffstat (limited to 'util/sql/schema.sql')
-rw-r--r-- | util/sql/schema.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/util/sql/schema.sql b/util/sql/schema.sql index 5c4342e2..8de05fde 100644 --- a/util/sql/schema.sql +++ b/util/sql/schema.sql @@ -352,7 +352,7 @@ CREATE TABLE threads_posts ( -- threads_boards CREATE TABLE threads_boards ( tid integer NOT NULL DEFAULT 0, - type character(2) NOT NULL DEFAULT 0, + type board_type NOT NULL, iid integer NOT NULL DEFAULT 0, PRIMARY KEY(tid, type, iid) ); |