diff options
| author | ben <ben@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2008-02-15 18:21:35 +0000 |
|---|---|---|
| committer | ben <ben@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2008-02-15 18:21:35 +0000 |
| commit | fac61fa985a0227a1746a671c0e54adedc96ec48 (patch) | |
| tree | 2446259aa9aaa160a2b444c9e0f4583631d9cc84 /engine/schema | |
| parent | a210406591f6a97d9f3d90df0dd375fcca3571f4 (diff) | |
| download | elgg-fac61fa985a0227a1746a671c0e54adedc96ec48.tar.gz elgg-fac61fa985a0227a1746a671c0e54adedc96ec48.tar.bz2 | |
All kinds of object and database stuff
git-svn-id: https://code.elgg.org/elgg/trunk@44 36083f99-b078-4883-b0ff-0f9b5a30f544
Diffstat (limited to 'engine/schema')
| -rw-r--r-- | engine/schema/mysql.sql | 7 |
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', '');
|