diff options
author | Evan Prodromou <evan@status.net> | 2010-02-25 18:45:32 -0500 |
---|---|---|
committer | Evan Prodromou <evan@status.net> | 2010-02-25 18:45:32 -0500 |
commit | 4aa82f75ed692e254c573096168e1cd7c0890ac6 (patch) | |
tree | 9fb87849f1f09c69c1c8e1a7c93d76fa283d5330 /db | |
parent | 6578e0e1afed8e8738bbcb31d200927e10074f11 (diff) | |
parent | e254c660f66e1a04ac18220c95ef47aa88117e3c (diff) |
Merge branch 'testing' of git@gitorious.org:statusnet/mainline into testing
Diffstat (limited to 'db')
-rw-r--r-- | db/local_group.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/db/local_group.sql b/db/local_group.sql new file mode 100644 index 000000000..14973e755 --- /dev/null +++ b/db/local_group.sql @@ -0,0 +1,17 @@ +alter table user_group + add uri varchar(255) unique key comment 'universal identifier', + add mainpage varchar(255) comment 'page for group info to link to', + drop index nickname; + +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; + +insert into local_group (group_id, nickname, created, modified) + select id, nickname, created, modified from user_group; |