summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
authorEvan Prodromou <evan@controlyourself.ca>2009-04-07 17:10:54 -0400
committerEvan Prodromou <evan@controlyourself.ca>2009-04-07 17:10:54 -0400
commit60861760fc3bdc1cdea407e8ee21eb8c54e77b8f (patch)
tree2bd269851136ae88494e09c10b774ae3c58aa690 /db
parent95bb1c6a99766d065ffcde9523de05d8a1162c3d (diff)
Host multiple sites with the same codebase
This is the beginning of the code for status.net and related status farms. It will read basic information about a site from a shared, central database and use the data stored there to switch on the hostname.
Diffstat (limited to 'db')
-rw-r--r--db/site.sql17
1 files changed, 17 insertions, 0 deletions
diff --git a/db/site.sql b/db/site.sql
new file mode 100644
index 000000000..660ba475b
--- /dev/null
+++ b/db/site.sql
@@ -0,0 +1,17 @@
+/* For managing multiple sites */
+
+create table status_network (
+
+ nickname varchar(64) primary key comment 'nickname',
+ hostname varchar(255) unique key comment 'alternate hostname if any',
+ pathname varchar(255) unique key comment 'alternate pathname if any',
+ sitename varchar(255) comment 'display name',
+ dbhost varchar(255) comment 'database host',
+ dbuser varchar(255) comment 'database username',
+ dbpass varchar(255) comment 'database password',
+ dbname varchar(255) comment 'database name',
+
+ 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;