Initial functional version of feed subscription plugin, currently supporting only...

[quix0rs-gnu-social.git] / db / statusnet_pg.sql

diff --git a/db/statusnet_pg.sql b/db/statusnet_pg.sql
index 8dbaf8598142e1715c7ff726db8d809a8a764add..27b189e288d24485018b391b52dfd954f35534d6 100644 (file)
--- a/db/statusnet_pg.sql
+++ b/db/statusnet_pg.sql
@@ -560,22 +560,12 @@ create table config (
 
 );
 
-create table user_role (
+create table profile_role (
 
-    user_id integer not null /* comment 'user having the role'*/ references "user" (id),
+    profile_id integer not null /* comment 'account having the role'*/ references profile (id),
     role    varchar(32) not null /* comment 'string representing the role'*/,
     created timestamp /* not null comment 'date the role was granted'*/,
 
-    primary key (user_id, role)
-
-);
-
-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'*/,
-    created timestamp not null DEFAULT CURRENT_TIMESTAMP /* comment 'date this record was created'*/,
-    modified timestamp /* comment 'date this record was modified'*/,
-
-    primary key (user_id)
-);
+    primary key (profile_id, role)
 
+);
\ No newline at end of file