aboutsummaryrefslogtreecommitdiff
path: root/engine/schema/mysql.sql
diff options
context:
space:
mode:
Diffstat (limited to 'engine/schema/mysql.sql')
-rw-r--r--engine/schema/mysql.sql7
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', '');