summaryrefslogtreecommitdiff
path: root/db/statusnet.sql
diff options
context:
space:
mode:
authorEvan Prodromou <evan@status.net>2009-11-16 16:02:47 +0100
committerEvan Prodromou <evan@status.net>2009-11-16 16:02:47 +0100
commit4e00ce01a9841ac055c058a4f0e221cc56eca06e (patch)
tree9d11f61f0f367e4736efbd34de9ffc5d848675fa /db/statusnet.sql
parent792590bcdccfabc8565dea138d93f6f3405131da (diff)
Rename user_role to profile_role
Renamed the user_role table to profile_role. Remote users can have a role on the site; that 'role' may be negative (silenced or sandboxed).
Diffstat (limited to 'db/statusnet.sql')
-rw-r--r--db/statusnet.sql6
1 files changed, 3 insertions, 3 deletions
diff --git a/db/statusnet.sql b/db/statusnet.sql
index 732aded5a..18abcdfdb 100644
--- a/db/statusnet.sql
+++ b/db/statusnet.sql
@@ -557,13 +557,13 @@ create table config (
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin;
-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 datetime not null comment 'date the role was granted',
- constraint primary key (user_id, role)
+ constraint primary key (profile_id, role)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin;