From 9a59f37df205fa7fafefcb65cc750aebe4d756a1 Mon Sep 17 00:00:00 2001 From: icewing Date: Mon, 3 Mar 2008 16:45:43 +0000 Subject: new site db git-svn-id: https://code.elgg.org/elgg/trunk@64 36083f99-b078-4883-b0ff-0f9b5a30f544 --- engine/schema/mysql.sql | 13 ++++++++++--- 1 file changed, 10 insertions(+), 3 deletions(-) (limited to 'engine') 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', ''); -- cgit v1.2.3