Unfortunately only half the changes required to bring the PostgreSQL support up to 0.6.4 standard were pulled into the main Laconica trunk. As well as changes to the create script, as you noticed, there are code changes required.
Evan - the rest of the changes are still in my repo, and now rebased up to the latest laconica trunk. Jason Riedy wrote: > Fixes: > - A comment in "user" began with / *. > - Index foreign_user_user_id_idx was defined twice. The second should > be foreign_link_user_id_idx. And the first no longer refers to user_id > but rather just id. > - A comment in foreign_link wasn't terminated. > - A comment in foreign_subscription ended with / and not */. > > Signed-off-by: Jason Riedy <[email protected]> > --- > Stumbled on these while poking at SQLite support... BTW, the source > could use some line-ending fixes. > > db/laconica_pg.sql | 10 +++++----- > 1 files changed, 5 insertions(+), 5 deletions(-) > > diff --git a/db/laconica_pg.sql b/db/laconica_pg.sql > index eb0dfc0..d2e311a 100644 > --- a/db/laconica_pg.sql > +++ b/db/laconica_pg.sql > @@ -49,7 +49,7 @@ create table "user" ( > emailnotifysub integer default 1 /* comment 'Notify by email of > subscriptions' */, > > emailnotifyfav integer default 1 /* comment 'Notify by email of > favorites' */, > > emailnotifynudge integer default 1 /* comment 'Notify by email of > nudges' */, > > - emailnotifymsg integer default 1 / * comment 'Notify by email of direct > messages' */, > > + emailnotifymsg integer default 1 /* comment 'Notify by email of direct > messages' */, > > emailmicroid integer default 1 /* comment 'whether to publish email microid' > */, > > language varchar(50) /* comment 'preferred language' */, > > timezone varchar(50) /* comment 'timezone' */, > > @@ -280,13 +280,13 @@ create table foreign_user ( > > > primary key (id, service) > > ); > > -create index foreign_user_user_id_idx on foreign_user using btree(user_id); > > +create index foreign_user_id_idx on foreign_user using btree(id); > > > > create table foreign_link ( > > user_id int /* comment 'link to user on this system, if exists' */ > references "user" (id), > > foreign_id int /* comment 'link' */ references foreign_user (id), > > service int not null /* comment 'foreign key to service' */ references > foreign_service (id), > > - credentials varchar(255) /* comment 'authc credentials, typically a > password', > > + credentials varchar(255) /* comment 'authc credentials, typically a > password' */, > > noticesync int not null default 1 /* comment 'notice synchronisation, > bit 1 = sync outgoing, bit 2 = sync incoming, bit 3 = filter local replies' > */, > > friendsync int not null default 2 /* comment 'friend synchronisation, > bit 1 = sync outgoing, bit 2 = sync incoming > > created timestamp not null /* comment 'date this record was created' */, > > @@ -294,13 +294,13 @@ create table foreign_link ( > > > primary key (user_id,foreign_id,service) > > ); > > -create index foreign_user_user_id_idx on foreign_link using btree(user_id); > > +create index foreign_link_user_id_idx on foreign_link using btree(user_id); > > > > create table foreign_subscription ( > > service int not null /* comment 'service where relationship happens' */ > references foreign_service(id) , > > subscriber int not null /* comment 'subscriber on foreign service' */ , > > subscribed int not null /* comment 'subscribed user' */ , > > - created timestamp not null /* comment 'date this record was created' /, > > + created timestamp not null /* comment 'date this record was created' */, > > > > primary key (service, subscriber, subscribed) > > ); > _______________________________________________ Laconica-dev mailing list [email protected] http://mail.laconi.ca/mailman/listinfo/laconica-dev
