summaryrefslogtreecommitdiff
path: root/db/site.sql
diff options
context:
space:
mode:
authorJames Walker <walkah@walkah.net>2010-07-20 17:34:58 -0700
committerJames Walker <walkah@walkah.net>2010-07-20 17:34:58 -0700
commit7065450f03078fb1ac2105b75f9c7a4e052bca9c (patch)
treeb0800c0552fd1f17a365d27bb878338f2b4c1ee9 /db/site.sql
parentc5e89527d9636275d58ef438c5e12a5aad283115 (diff)
normalizing tags for status_network
Diffstat (limited to 'db/site.sql')
-rw-r--r--db/site.sql16
1 files changed, 12 insertions, 4 deletions
diff --git a/db/site.sql b/db/site.sql
index 791303bd5..bc425841d 100644
--- a/db/site.sql
+++ b/db/site.sql
@@ -1,8 +1,9 @@
/* For managing multiple sites */
create table status_network (
-
- nickname varchar(64) primary key comment 'nickname',
+
+ site_id integer auto_increment primary key comment 'unique id',
+ nickname varchar(64) unique key comment 'nickname',
hostname varchar(255) unique key comment 'alternate hostname if any',
pathname varchar(255) unique key comment 'alternate pathname if any',
@@ -15,9 +16,16 @@ create table status_network (
theme varchar(255) comment 'theme name',
logo varchar(255) comment 'site logo',
- tags text comment 'site meta-info tags (pipe-separated)',
-
created datetime not null comment 'date this record was created',
modified timestamp comment 'date this record was modified'
) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;
+
+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;
+