aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoricewing <icewing@36083f99-b078-4883-b0ff-0f9b5a30f544>2008-03-03 16:45:43 +0000
committericewing <icewing@36083f99-b078-4883-b0ff-0f9b5a30f544>2008-03-03 16:45:43 +0000
commit9a59f37df205fa7fafefcb65cc750aebe4d756a1 (patch)
treeef190d0e39168fd12a7d7cbf32d0925827983990
parentc463d6c936261948320c4c0fc33595d4545d02c2 (diff)
downloadelgg-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
-rw-r--r--engine/schema/mysql.sql13
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', '');