2 add uri varchar(255) unique key comment 'universal identifier',
3 add mainpage varchar(255) comment 'page for group info to link to',
6 create table local_group (
8 group_id integer primary key comment 'group represented' references user_group (id),
9 nickname varchar(64) unique key comment 'group represented',
11 created datetime not null comment 'date this record was created',
12 modified timestamp comment 'date this record was modified'
14 ) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin;
16 insert into local_group (group_id, nickname, created, modified)
17 select id, nickname, created, modified from user_group;