diff options
| author | icewing <icewing@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2008-03-03 16:45:43 +0000 |
|---|---|---|
| committer | icewing <icewing@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2008-03-03 16:45:43 +0000 |
| commit | 9a59f37df205fa7fafefcb65cc750aebe4d756a1 (patch) | |
| tree | ef190d0e39168fd12a7d7cbf32d0925827983990 /engine/schema | |
| parent | c463d6c936261948320c4c0fc33595d4545d02c2 (diff) | |
| download | elgg-9a59f37df205fa7fafefcb65cc750aebe4d756a1.tar.gz elgg-9a59f37df205fa7fafefcb65cc750aebe4d756a1.tar.bz2 | |
new site db
git-svn-id: https://code.elgg.org/elgg/trunk@64 36083f99-b078-4883-b0ff-0f9b5a30f544
Diffstat (limited to 'engine/schema')
| -rw-r--r-- | engine/schema/mysql.sql | 13 |
1 files changed, 10 insertions, 3 deletions
diff --git a/engine/schema/mysql.sql b/engine/schema/mysql.sql index 062541e63..f1b52e62d 100644 --- a/engine/schema/mysql.sql +++ b/engine/schema/mysql.sql @@ -190,9 +190,16 @@ CREATE TABLE `prefix_user_metadata` ( CREATE TABLE `prefix_sites` (
`id` int(11) NOT NULL auto_increment,
`name` text NOT NULL,
- `domain` text NOT NULL,
+ `description` text NOT NULL,
+ `url` text NOT NULL,
+
+ `owner_id` int(11) NOT NULL,
+ `created` int(11) NOT NULL,
+ `last_updated` int(11) NOT NULL,
+
+ `access_id` int(11) NOT NULL,
+ `write_access_id` int(11) NOT NULL,
+
PRIMARY KEY (`id`)
) ENGINE=MyISAM ;
-INSERT INTO `prefix_sites` (`id` ,`name` ,`domain`) VALUES
-(1 , 'New Elgg site', '');
|