Added the concept of a site_id to msot of the database tables. Also some extra installation stuff.

git-svn-id: https://code.elgg.org/elgg/trunk@43 36083f99-b078-4883-b0ff-0f9b5a30f544

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