summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorJames Walker <walkah@walkah.net>2010-07-28 11:50:04 -0400
committerJames Walker <walkah@walkah.net>2010-07-28 11:50:04 -0400
commit4853b1e2a029a844d0c92e6ad5f2a9e8c51b785c (patch)
treeb5627fd552afedd83571ea12b0a01cb88ab3ae58
parentdd7647aa9538abdc24edf9c89b8e563bbdbb519e (diff)
SQL script to update status_network table
-rw-r--r--db/site_093to094.sql13
1 files changed, 13 insertions, 0 deletions
diff --git a/db/site_093to094.sql b/db/site_093to094.sql
new file mode 100644
index 000000000..30cea31df
--- /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;
+