From 72df5c9eb4941eb0770758862e065940e05f2abc Mon Sep 17 00:00:00 2001 From: Brenda Wallace Date: Thu, 25 Jun 2009 21:59:33 +1200 Subject: removed semicolons from comments (mucks up logic in install.php) and fixed stray commas that stopped it parsing as valid SQL --- db/laconica_pg.sql | 11 ++++++----- 1 file changed, 6 insertions(+), 5 deletions(-) (limited to 'db') diff --git a/db/laconica_pg.sql b/db/laconica_pg.sql index b213bbd50..622242bdf 100644 --- a/db/laconica_pg.sql +++ b/db/laconica_pg.sql @@ -118,6 +118,7 @@ create table notice ( is_local integer default 0 /* comment 'notice was generated by a user' */, source varchar(32) /* comment 'source of comment, like "web", "im", or "clientname"' */ + /* FULLTEXT(content) */ ); create index notice_profile_id_idx on notice using btree(profile_id); @@ -172,7 +173,7 @@ create table token ( tok char(32) not null /* comment 'identifying value' */, secret char(32) not null /* comment 'secret value' */, type integer not null default 0 /* comment 'request or access' */, - state integer default 0 /* comment 'for requests; 0 = initial, 1 = authorized, 2 = used' */, + state integer default 0 /* comment 'for requests 0 = initial, 1 = authorized, 2 = used' */, created timestamp not null default CURRENT_TIMESTAMP /* comment 'date this record was created' */, modified timestamp /* comment 'date this record was modified' */, @@ -346,7 +347,7 @@ create table notice_inbox ( user_id integer not null /* comment 'user receiving the message' */ references "user" (id), notice_id integer not null /* comment 'notice received' */ references notice (id), created timestamp not null default CURRENT_TIMESTAMP /* comment 'date the notice was created' */, - source integer default 1 /* comment 'reason it is in the inbox; 1=subscription' */, + source integer default 1 /* comment 'reason it is in the inbox: 1=subscription' */, primary key (user_id, notice_id) ); @@ -436,8 +437,8 @@ create table file ( mimetype varchar(50), size integer, title varchar(255), - date integer(11), - protected integer(1) + date integer, + protected integer ); create sequence file_oembed_seq; @@ -454,7 +455,7 @@ create table file_oembed ( title varchar(255), author_name varchar(50), author_url varchar(255), - url varchar(255), + url varchar(255) ); create sequence file_redirection_seq; -- cgit v1.2.3-54-g00ecf