From 4853b1e2a029a844d0c92e6ad5f2a9e8c51b785c Mon Sep 17 00:00:00 2001 From: James Walker Date: Wed, 28 Jul 2010 11:50:04 -0400 Subject: [PATCH] SQL script to update status_network table --- db/site_093to094.sql | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 db/site_093to094.sql diff --git a/db/site_093to094.sql b/db/site_093to094.sql new file mode 100644 index 0000000000..30cea31dfa --- /dev/null +++ b/db/site_093to094.sql @@ -0,0 +1,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; + -- 2.39.2