);
+
+
create table login_token (
user_id integer not null /* comment 'user owning this token'*/ references "user" (id),
token char(32) not null /* comment 'token useable for logging in'*/,
primary key (user_id)
);
+CREATE TABLE forward (
+ profile_id integer not null /*comment 'profile who forwarded the notice'*/ references profile (id),
+ notice_id integer not null /*comment 'notice they forwarded'*/ references notice (id),
+ created timestamp not null /*comment 'date this record was created'*/ DEFAULT CURRENT_TIMESTAMP,
+ PRIMARY KEY (profile_id, notice_id)
+);