db/site_093to094.sql


1
2
3
4
5
6
7
8
9
10
11
12
13

alter table status_network 
      drop primary key,
      add column site_id integer auto_increment primary key first,
      add unique key (nickname);

create table status_network_tag (
    site_id integer  comment 'unique id',
    tag varchar(64) comment 'tag name',
    created datetime not null comment 'date the record was created',

    constraint primary key (site_id, tag)
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;