From 4853b1e2a029a844d0c92e6ad5f2a9e8c51b785c Mon Sep 17 00:00:00 2001
From: James Walker <walkah@walkah.net>
Date: Wed, 28 Jul 2010 11:50:04 -0400
Subject: SQL script to update status_network table

---
 db/site_093to094.sql | 13 +++++++++++++
 1 file changed, 13 insertions(+)
 create mode 100644 db/site_093to094.sql

(limited to 'db/site_093to094.sql')

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;
+
-- 
cgit v1.2.3-54-g00ecf

