summaryrefslogtreecommitdiff
path: root/db/statusnet.sql
diff options
context:
space:
mode:
authorEvan Prodromou <evan@status.net>2010-02-24 23:28:41 -0500
committerEvan Prodromou <evan@status.net>2010-02-24 23:28:41 -0500
commitbd68154772e80a98e9e5c96c6df8772ce3b2a84f (patch)
tree0f287955e7a8fb8456307a1e6118edcf8d7d8e47 /db/statusnet.sql
parent374c488cf136b378d4fb47c4a6add309694e9146 (diff)
Make user_group able to handle remote groups
We add a local_group table to store data about local groups. It has the unique key for nickname, so /group/<nickname> looks up here. Updated DB data object classes and data files.
Diffstat (limited to 'db/statusnet.sql')
-rw-r--r--db/statusnet.sql14
1 files changed, 13 insertions, 1 deletions
diff --git a/db/statusnet.sql b/db/statusnet.sql
index 97117c80a..75d060e28 100644
--- a/db/statusnet.sql
+++ b/db/statusnet.sql
@@ -406,7 +406,7 @@ create table profile_block (
create table user_group (
id integer auto_increment primary key comment 'unique identifier',
- nickname varchar(64) unique key comment 'nickname for addressing',
+ nickname varchar(64) comment 'nickname for addressing',
fullname varchar(255) comment 'display name',
homepage varchar(255) comment 'URL, cached so we dont regenerate',
description text comment 'group description',
@@ -421,6 +421,8 @@ create table user_group (
created datetime not null comment 'date this record was created',
modified timestamp comment 'date this record was modified',
+ uri varchar(255) unique key comment 'universal identifier',
+
index user_group_nickname_idx (nickname)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;
@@ -641,3 +643,13 @@ create table conversation (
modified timestamp comment 'date this record was modified'
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin;
+create table local_group (
+
+ group_id integer primary key comment 'group represented' references user_group (id),
+ nickname varchar(64) unique key comment 'group represented',
+
+ created datetime not null comment 'date this record was created',
+ modified timestamp comment 'date this record was modified'
+
+) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin;
+