All kinds of object and database stuff

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

1 files changed, 6 insertions, 1 deletions

diff --git a/engine/schema/mysql.sql b/engine/schema/mysql.sql
index 2882d2c7a..787a44e15 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,

+  `owner_id` int(11) NOT NULL,

   `site_id` int(11) NOT NULL default '0',

   PRIMARY KEY  (`id`),

   KEY `name` (`name`)

@@ -98,6 +99,7 @@ CREATE TABLE `prefix_objects` (
   `owner_id` int(11) NOT NULL,

   `site_id` int(11) NOT NULL default '0',

   `type_id` int(11) NOT NULL,

+  `access_id` int(11) NOT NULL default '0',

   `title` text NOT NULL,

   `description` text NOT NULL,

   `time_created` int(11) NOT NULL,

@@ -190,4 +192,7 @@ CREATE TABLE `prefix_sites` (
   `name` text NOT NULL,

   `domain` text NOT NULL,

   PRIMARY KEY  (`id`)

-) ENGINE=MyISAM ;
\ No newline at end of file
+) ENGINE=MyISAM ;

+

+INSERT INTO `prefix_elggnew`.`sites` (`id` ,`name` ,`domain`) VALUES 

+(1 , 'New Elgg site', '');