aboutsummaryrefslogtreecommitdiff
path: root/engine/schema
diff options
context:
space:
mode:
Diffstat (limited to 'engine/schema')
-rw-r--r--engine/schema/mysql.sql26
1 files changed, 21 insertions, 5 deletions
diff --git a/engine/schema/mysql.sql b/engine/schema/mysql.sql
index 9c0428ce7..2882d2c7a 100644
--- a/engine/schema/mysql.sql
+++ b/engine/schema/mysql.sql
@@ -17,6 +17,7 @@
CREATE TABLE `prefix_access_groups` (
`id` int(11) NOT NULL,
`name` varchar(16) NOT NULL,
+ `site_id` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `name` (`name`)
) ENGINE=MyISAM ;
@@ -25,10 +26,10 @@ CREATE TABLE `prefix_access_groups` (
-- Dumping data for table `access_groups`
--
-INSERT INTO `prefix_access_groups` (`id`, `name`) VALUES
-(0, 'PRIVATE'),
-(1, 'LOGGED_IN'),
-(2, 'PUBLIC');
+INSERT INTO `prefix_access_groups` (`id`, `name`, `site_id`) VALUES
+(0, 'PRIVATE', 0),
+(1, 'LOGGED_IN', 0),
+(2, 'PUBLIC', 0);
-- --------------------------------------------------------
@@ -53,6 +54,7 @@ CREATE TABLE `prefix_configuration` (
`id` int(11) NOT NULL,
`name` varchar(32) NOT NULL,
`value` text NOT NULL,
+ `site_id` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `name` (`name`)
) ENGINE=MyISAM ;
@@ -94,7 +96,7 @@ CREATE TABLE `prefix_metadata_value` (
CREATE TABLE `prefix_objects` (
`id` int(11) NOT NULL auto_increment,
`owner_id` int(11) NOT NULL,
- `site_id` int(11) NOT NULL,
+ `site_id` int(11) NOT NULL default '0',
`type_id` int(11) NOT NULL,
`title` text NOT NULL,
`description` text NOT NULL,
@@ -116,6 +118,7 @@ CREATE TABLE `prefix_object_metadata` (
`metadata_type_id` int(11) NOT NULL,
`value_id` int(11) NOT NULL,
`access_id` int(11) NOT NULL,
+ `site_id` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `object_id` (`object_id`,`metadata_type_id`,`value_id`),
KEY `access_id` (`access_id`)
@@ -175,3 +178,16 @@ CREATE TABLE `prefix_user_metadata` (
KEY `user_id` (`user_id`,`metadata_type_id`,`value_id`),
KEY `access_id` (`access_id`)
) ENGINE=MyISAM ;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `sites`
+--
+
+CREATE TABLE `prefix_sites` (
+ `id` int(11) NOT NULL auto_increment,
+ `name` text NOT NULL,
+ `domain` text NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=MyISAM ; \ No newline at end of file