From fac61fa985a0227a1746a671c0e54adedc96ec48 Mon Sep 17 00:00:00 2001 From: ben Date: Fri, 15 Feb 2008 18:21:35 +0000 Subject: All kinds of object and database stuff git-svn-id: https://code.elgg.org/elgg/trunk@44 36083f99-b078-4883-b0ff-0f9b5a30f544 --- engine/schema/mysql.sql | 7 ++++++- 1 file changed, 6 insertions(+), 1 deletion(-) (limited to 'engine/schema/mysql.sql') 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', ''); -- cgit v1.2.3