From 4dcfd46b8b6e3bbe9c12493e744be04d8861684e Mon Sep 17 00:00:00 2001 From: brettp Date: Sun, 10 Jan 2010 21:21:11 +0000 Subject: Fixes #1432: Version number is set during installation. Refs #1424: The upgrade functions now detect if no version number is saved to the db and silences all upgrade warnings and errors. This is required for all installations < this commit to upgrade correctly because of #1432. More strict regex for finding upgrade files. Upgrade mysql.sql schema with latest. git-svn-id: http://code.elgg.org/elgg/trunk@3791 36083f99-b078-4883-b0ff-0f9b5a30f544 --- engine/schema/mysql.sql | 811 ++++++++++++++++++++++++++---------------------- 1 file changed, 446 insertions(+), 365 deletions(-) (limited to 'engine/schema/mysql.sql') diff --git a/engine/schema/mysql.sql b/engine/schema/mysql.sql index dd5d43592..988e70d89 100644 --- a/engine/schema/mysql.sql +++ b/engine/schema/mysql.sql @@ -1,370 +1,451 @@ --- --- Main Elgg database --- --- @link http://elgg.org/ --- - --- -------------------------------------------------------- - --- --- *** The main tables *** --- - --- Site configuration. -CREATE TABLE `prefix_config` ( - `name` varchar(32) NOT NULL, - `value` text NOT NULL, - `site_guid` int(11) NOT NULL, - PRIMARY KEY (`name`,`site_guid`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - --- Define entities. -CREATE TABLE `prefix_entities` ( - `guid` bigint(20) unsigned NOT NULL auto_increment, - - `type` enum ('object', 'user', 'group', 'site') NOT NULL, - `subtype` int(11) NULL, - - `owner_guid` bigint(20) unsigned NOT NULL, - `site_guid` bigint(20) unsigned NOT NULL, - `container_guid` bigint(20) unsigned NOT NULL, - `access_id` int(11) NOT NULL, - - `time_created` int(11) NOT NULL, - `time_updated` int(11) NOT NULL, - - `enabled` enum ('yes', 'no') NOT NULL default 'yes', - - primary key (`guid`), - KEY `type` (`type`), - KEY `subtype` (`subtype`), - KEY `owner_guid` (`owner_guid`), - KEY `site_guid` (`site_guid`), - KEY `container_guid` (`container_guid`), - KEY `access_id` (`access_id`), - KEY `time_created` (`time_created`), - KEY `time_updated` (`time_updated`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - --- Entity subtypes - lets you subtype one of the main objects (sites/objects/etc) -CREATE TABLE `prefix_entity_subtypes` ( - `id` int(11) NOT NULL auto_increment, - - `type` enum ('object', 'user', 'group', 'site') NOT NULL, - `subtype` varchar(50) NOT NULL, - - class varchar(50) NOT NULL default '', - - PRIMARY KEY (`id`), - UNIQUE KEY (`type`, `subtype`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - --- Describe relationships between entities, can describe friendships but also site membership, depending on context -CREATE TABLE `prefix_entity_relationships` ( - `id` int(11) NOT NULL auto_increment, - - `guid_one` bigint(20) unsigned NOT NULL, - `relationship` varchar(50) NOT NULL, - `guid_two` bigint(20) unsigned NOT NULL, - PRIMARY KEY (`id`), - UNIQUE KEY (`guid_one`,`relationship`,`guid_two`), - KEY `relationship` (`relationship`), - KEY `guid_two` (`guid_two`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - --- --- *** Access controls *** --- - --- Table structure for table `access_collections` -CREATE TABLE `prefix_access_collections` ( - `id` int(11) NOT NULL auto_increment, - `name` text NOT NULL, - `owner_guid` bigint(20) unsigned NOT NULL, - `site_guid` bigint(20) unsigned NOT NULL default '0', - - PRIMARY KEY (`id`), - KEY `owner_guid` (`owner_guid`), - KEY `site_guid` (`site_guid`) -) AUTO_INCREMENT=3 ENGINE=MyISAM DEFAULT CHARSET=utf8; - --- Access containers -CREATE TABLE `prefix_access_collection_membership` ( - `user_guid` int(11) NOT NULL, - `access_collection_id` int(11) NOT NULL, - PRIMARY KEY (`user_guid`,`access_collection_id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - - --- --- *** Entity superclass details *** --- NB: Aside from GUID, these should now have any field names in common with the entities table. --- - --- Extra information relating to "objects" -CREATE TABLE `prefix_objects_entity` ( - `guid` bigint(20) unsigned NOT NULL, - - `title` text NOT NULL, - `description` text NOT NULL, - +-- +-- Main Elgg database +-- +-- @link http://elgg.org/ +-- + +-- -------------------------------------------------------- + +/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; +/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; +/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; +/*!40101 SET NAMES utf8 */; +/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; +/*!40103 SET TIME_ZONE='+00:00' */; +/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; +/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; +/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; +/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; + +-- +-- Table structure for table `prefix_access_collection_membership` +-- + +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `prefix_access_collection_membership` ( + `user_guid` int(11) NOT NULL, + `access_collection_id` int(11) NOT NULL, + PRIMARY KEY (`user_guid`,`access_collection_id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `prefix_access_collections` +-- + +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `prefix_access_collections` ( + `id` int(11) NOT NULL auto_increment, + `name` text NOT NULL, + `owner_guid` bigint(20) unsigned NOT NULL, + `site_guid` bigint(20) unsigned NOT NULL default '0', + PRIMARY KEY (`id`), + KEY `owner_guid` (`owner_guid`), + KEY `site_guid` (`site_guid`) +) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `prefix_annotations` +-- + +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `prefix_annotations` ( + `id` int(11) NOT NULL auto_increment, + `entity_guid` bigint(20) unsigned NOT NULL, + `name_id` int(11) NOT NULL, + `value_id` int(11) NOT NULL, + `value_type` enum('integer','text') NOT NULL, + `owner_guid` bigint(20) unsigned NOT NULL, + `access_id` int(11) NOT NULL, + `time_created` int(11) NOT NULL, + `enabled` enum('yes','no') NOT NULL default 'yes', + PRIMARY KEY (`id`), + KEY `entity_guid` (`entity_guid`), + KEY `name_id` (`name_id`), + KEY `value_id` (`value_id`), + KEY `owner_guid` (`owner_guid`), + KEY `access_id` (`access_id`) +) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `prefix_api_users` +-- + +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `prefix_api_users` ( + `id` int(11) NOT NULL auto_increment, + `site_guid` bigint(20) unsigned default NULL, + `api_key` varchar(40) default NULL, + `secret` varchar(40) NOT NULL, + `active` int(1) default '1', + PRIMARY KEY (`id`), + UNIQUE KEY `api_key` (`api_key`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `prefix_config` +-- + +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `prefix_config` ( + `name` varchar(32) NOT NULL, + `value` text NOT NULL, + `site_guid` int(11) NOT NULL, + PRIMARY KEY (`name`,`site_guid`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `prefix_datalists` +-- + +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `prefix_datalists` ( + `name` varchar(32) NOT NULL, + `value` text NOT NULL, + PRIMARY KEY (`name`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `prefix_entities` +-- + +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `prefix_entities` ( + `guid` bigint(20) unsigned NOT NULL auto_increment, + `type` enum('object','user','group','site') NOT NULL, + `subtype` int(11) default NULL, + `owner_guid` bigint(20) unsigned NOT NULL, + `site_guid` bigint(20) unsigned NOT NULL, + `container_guid` bigint(20) unsigned NOT NULL, + `access_id` int(11) NOT NULL, + `time_created` int(11) NOT NULL, + `time_updated` int(11) NOT NULL, + `enabled` enum('yes','no') NOT NULL default 'yes', PRIMARY KEY (`guid`), - FULLTEXT KEY (`title`,`description`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - --- Extra information relating to "sites" -CREATE TABLE `prefix_sites_entity` ( - `guid` bigint(20) unsigned NOT NULL, - - `name` text NOT NULL, - `description` text NOT NULL, - `url` varchar(255) NOT NULL, - - PRIMARY KEY (`guid`), - UNIQUE KEY (`url`), - FULLTEXT KEY (`name`,`description`, `url`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - --- Extra information relating to "users" -CREATE TABLE `prefix_users_entity` ( - `guid` bigint(20) unsigned NOT NULL, - - `name` text NOT NULL, - `username` varchar(128) NOT NULL default '', - `password` varchar(32) NOT NULL default '', - `salt` varchar(8) NOT NULL default '', - `email` text NOT NULL, - `language` varchar(6) NOT NULL default '', - `code` varchar(32) NOT NULL default '', - `banned` enum ('yes', 'no') NOT NULL default 'no', - - `last_action` int(11) NOT NULL default '0', - `prev_last_action` int(11) NOT NULL default '0', - `last_login` int(11) NOT NULL default '0', - `prev_last_login` int(11) NOT NULL default '0', - - PRIMARY KEY (`guid`), - UNIQUE KEY (`username`), - KEY `password` (`password`), - KEY `email` (`email`(50)), - KEY `code` (`code`), - KEY `last_action` (`last_action`), - KEY `last_login` (`last_login`), - FULLTEXT KEY `name` (`name`), - FULLTEXT KEY (`name`,`username`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; + KEY `type` (`type`), + KEY `subtype` (`subtype`), + KEY `owner_guid` (`owner_guid`), + KEY `site_guid` (`site_guid`), + KEY `container_guid` (`container_guid`), + KEY `access_id` (`access_id`), + KEY `time_created` (`time_created`), + KEY `time_updated` (`time_updated`) +) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `prefix_entity_relationships` +-- + +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `prefix_entity_relationships` ( + `id` int(11) NOT NULL auto_increment, + `guid_one` bigint(20) unsigned NOT NULL, + `relationship` varchar(50) NOT NULL, + `guid_two` bigint(20) unsigned NOT NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `guid_one` (`guid_one`,`relationship`,`guid_two`), + KEY `relationship` (`relationship`), + KEY `guid_two` (`guid_two`) +) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `prefix_entity_subtypes` +-- --- Extra information relating to "groups" +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `prefix_entity_subtypes` ( + `id` int(11) NOT NULL auto_increment, + `type` enum('object','user','group','site') NOT NULL, + `subtype` varchar(50) NOT NULL, + `class` varchar(50) NOT NULL default '', + PRIMARY KEY (`id`), + UNIQUE KEY `type` (`type`,`subtype`) +) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `prefix_geocode_cache` +-- + +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `prefix_geocode_cache` ( + `id` int(11) NOT NULL auto_increment, + `location` varchar(128) default NULL, + `lat` varchar(20) default NULL, + `long` varchar(20) default NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `location` (`location`) +) ENGINE=MEMORY DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `prefix_groups_entity` +-- + +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; CREATE TABLE `prefix_groups_entity` ( - `guid` bigint(20) unsigned NOT NULL, - - `name` text NOT NULL, - `description` text NOT NULL, - - PRIMARY KEY (`guid`), - KEY `name` (`name`(50)), + `guid` bigint(20) unsigned NOT NULL, + `name` text NOT NULL, + `description` text NOT NULL, + PRIMARY KEY (`guid`), + KEY `name` (`name`(50)), KEY `description` (`description`(50)), - FULLTEXT KEY (`name`,`description`) + FULLTEXT KEY `name_2` (`name`,`description`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; - --- --- *** Annotations and tags *** --- - --- Table structure for annotations -CREATE TABLE `prefix_annotations` ( - `id` int(11) NOT NULL auto_increment, - - `entity_guid` bigint(20) unsigned NOT NULL, - - `name_id` int(11) NOT NULL, - `value_id` int(11) NOT NULL, - `value_type` enum ('integer','text') NOT NULL, - - `owner_guid` bigint(20) unsigned NOT NULL, - `access_id` int(11) NOT NULL, - - `time_created` int(11) NOT NULL, - - `enabled` enum ('yes', 'no') NOT NULL default 'yes', - - PRIMARY KEY (`id`), - KEY `entity_guid` (`entity_guid`), - KEY `name_id` (`name_id`), - KEY `value_id` (`value_id`), - KEY `owner_guid` (`owner_guid`), - KEY `access_id` (`access_id`) - -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - --- Table structure for metadata -CREATE TABLE `prefix_metadata` ( - `id` int(11) NOT NULL auto_increment, - - `entity_guid` bigint(20) unsigned NOT NULL, - - `name_id` int(11) NOT NULL, - `value_id` int(11) NOT NULL, - `value_type` enum ('integer','text') NOT NULL, - - `owner_guid` bigint(20) unsigned NOT NULL, - `access_id` int(11) NOT NULL, - - `time_created` int(11) NOT NULL, - - `enabled` enum ('yes', 'no') NOT NULL default 'yes', - - PRIMARY KEY (`id`), - KEY `entity_guid` (`entity_guid`), - KEY `name_id` (`name_id`), - KEY `value_id` (`value_id`), - KEY `owner_guid` (`owner_guid`), - KEY `access_id` (`access_id`) - -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - --- Meta strings table (avoids storing text strings more than once) -CREATE TABLE `prefix_metastrings` ( - `id` int(11) NOT NULL auto_increment, - `string` TEXT NOT NULL, - - PRIMARY KEY (`id`), - KEY `string` (`string`(50)) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - --- --- *** Misc *** --- - --- API Users -CREATE TABLE `prefix_api_users` ( - id int(11) auto_increment, - - site_guid bigint(20) unsigned, - - api_key varchar(40), - secret varchar(40) NOT NULL, - active int(1) default 1, - - unique key (api_key), - primary key (id) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - --- API Sessions -CREATE TABLE `prefix_users_apisessions` ( - `id` int(11) NOT NULL auto_increment, - `user_guid` bigint(20) unsigned NOT NULL, - `site_guid` bigint(20) unsigned NOT NULL, - - `token` varchar(40), - - `expires` int(11) NOT NULL, - - PRIMARY KEY (`id`), - UNIQUE KEY (`user_guid`,`site_guid`), - KEY `token` (`token`) -) ENGINE=MEMORY; - --- HMAC Cache protecting against Replay attacks -CREATE TABLE `prefix_hmac_cache` ( - `hmac` varchar(255) NOT NULL, - `ts` int(11) NOT NULL, - - PRIMARY KEY (`hmac`), - KEY `ts` (`ts`) -) ENGINE=MEMORY; - --- Geocode engine cache -CREATE TABLE `prefix_geocode_cache` ( - id int(11) auto_increment, - location varchar(128), - `lat` varchar(20), - `long` varchar(20), - - PRIMARY KEY (`id`), - UNIQUE KEY `location` (`location`) - -) ENGINE=MEMORY; - --- PHP Session storage -CREATE TABLE `prefix_users_sessions` ( - `session` varchar(255) NOT NULL, - `ts` int(11) unsigned NOT NULL default '0', - `data` mediumblob, - - PRIMARY KEY `session` (`session`), - KEY `ts` (`ts`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - --- Datalists for things like db version -CREATE TABLE `prefix_datalists` ( - `name` varchar(32) NOT NULL, - `value` text NOT NULL, - PRIMARY KEY `name` (`name`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - --- Ultra-private system settings for entities -CREATE TABLE `prefix_private_settings` ( - `id` INT NOT NULL auto_increment, - `entity_guid` INT NOT NULL , - `name` varchar(128) NOT NULL , - `value` TEXT NOT NULL , - PRIMARY KEY ( `id` ) , - UNIQUE KEY ( `entity_guid` , `name` ), - KEY `name` (`name`), - KEY `value` (`value` (50)) -) ENGINE = MYISAM DEFAULT CHARSET=utf8; - --- System log -CREATE TABLE `prefix_system_log` ( - `id` int(11) NOT NULL auto_increment, - - `object_id` int(11) NOT NULL, - - `object_class` varchar(50) NOT NULL, - `object_type` varchar(50) NOT NULL, - `object_subtype` varchar(50) NOT NULL, - - `event` varchar(50) NOT NULL, - `performed_by_guid` int(11) NOT NULL, - - `owner_guid` int(11) NOT NULL, - `access_id` int(11) NOT NULL, - - `enabled` enum ('yes', 'no') NOT NULL default 'yes', - - `time_created` int(11) NOT NULL, - - PRIMARY KEY (`id`), - KEY `object_id` (`object_id`), - KEY `object_class` (`object_class`), - KEY `object_type` (`object_type`), - KEY `object_subtype` (`object_subtype`), - KEY `event` (`event`), - KEY `performed_by_guid` (`performed_by_guid`), - KEY `access_id` (`access_id`), - KEY `time_created` (`time_created`), - KEY `river_key` (`object_type`, `object_subtype`, `event`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - --- River - CREATE TABLE `prefix_river` ( - `id` INT NOT NULL AUTO_INCREMENT , - `type` VARCHAR( 8 ) NOT NULL , - `subtype` VARCHAR( 32 ) NOT NULL , - `action_type` VARCHAR( 32 ) NOT NULL , - `access_id` INT NOT NULL , - `view` TEXT NOT NULL , - `subject_guid` INT NOT NULL , - `object_guid` INT NOT NULL , - `annotation_id` int(11) NOT NULL, - `posted` INT NOT NULL , - PRIMARY KEY ( `id` ) , - KEY `type` (`type`), - KEY `action_type` (`action_type`), - KEY `access_id` (`access_id`), - KEY `subject_guid` (`subject_guid`), - KEY `object_guid` (`object_guid`), - KEY `annotation_id` (`annotation_id`), - KEY `posted` (`posted`) -) ENGINE = MYISAM DEFAULT CHARSET=utf8; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `prefix_hmac_cache` +-- + +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `prefix_hmac_cache` ( + `hmac` varchar(255) NOT NULL, + `ts` int(11) NOT NULL, + PRIMARY KEY (`hmac`), + KEY `ts` (`ts`) +) ENGINE=MEMORY DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `prefix_metadata` +-- + +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `prefix_metadata` ( + `id` int(11) NOT NULL auto_increment, + `entity_guid` bigint(20) unsigned NOT NULL, + `name_id` int(11) NOT NULL, + `value_id` int(11) NOT NULL, + `value_type` enum('integer','text') NOT NULL, + `owner_guid` bigint(20) unsigned NOT NULL, + `access_id` int(11) NOT NULL, + `time_created` int(11) NOT NULL, + `enabled` enum('yes','no') NOT NULL default 'yes', + PRIMARY KEY (`id`), + KEY `entity_guid` (`entity_guid`), + KEY `name_id` (`name_id`), + KEY `value_id` (`value_id`), + KEY `owner_guid` (`owner_guid`), + KEY `access_id` (`access_id`) +) ENGINE=MyISAM AUTO_INCREMENT=92 DEFAULT CHARSET=utf8; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `prefix_metastrings` +-- + +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `prefix_metastrings` ( + `id` int(11) NOT NULL auto_increment, + `string` text NOT NULL, + PRIMARY KEY (`id`), + KEY `string` (`string`(50)) +) ENGINE=MyISAM AUTO_INCREMENT=67 DEFAULT CHARSET=utf8; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `prefix_objects_entity` +-- + +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `prefix_objects_entity` ( + `guid` bigint(20) unsigned NOT NULL, + `title` text NOT NULL, + `description` text NOT NULL, + PRIMARY KEY (`guid`), + FULLTEXT KEY `title` (`title`,`description`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `prefix_private_settings` +-- + +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `prefix_private_settings` ( + `id` int(11) NOT NULL auto_increment, + `entity_guid` int(11) NOT NULL, + `name` varchar(128) NOT NULL, + `value` text NOT NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `entity_guid` (`entity_guid`,`name`), + KEY `name` (`name`), + KEY `value` (`value`(50)) +) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `prefix_river` +-- + +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `prefix_river` ( + `id` int(11) NOT NULL auto_increment, + `type` varchar(8) NOT NULL, + `subtype` varchar(32) NOT NULL, + `action_type` varchar(32) NOT NULL, + `access_id` int(11) NOT NULL, + `view` text NOT NULL, + `subject_guid` int(11) NOT NULL, + `object_guid` int(11) NOT NULL, + `annotation_id` int(11) NOT NULL, + `posted` int(11) NOT NULL, + PRIMARY KEY (`id`), + KEY `type` (`type`), + KEY `action_type` (`action_type`), + KEY `access_id` (`access_id`), + KEY `subject_guid` (`subject_guid`), + KEY `object_guid` (`object_guid`), + KEY `annotation_id` (`annotation_id`), + KEY `posted` (`posted`) +) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `prefix_sites_entity` +-- + +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `prefix_sites_entity` ( + `guid` bigint(20) unsigned NOT NULL, + `name` text NOT NULL, + `description` text NOT NULL, + `url` varchar(255) NOT NULL, + PRIMARY KEY (`guid`), + UNIQUE KEY `url` (`url`), + FULLTEXT KEY `name` (`name`,`description`,`url`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `prefix_system_log` +-- + +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `prefix_system_log` ( + `id` int(11) NOT NULL auto_increment, + `object_id` int(11) NOT NULL, + `object_class` varchar(50) NOT NULL, + `object_type` varchar(50) NOT NULL, + `object_subtype` varchar(50) NOT NULL, + `event` varchar(50) NOT NULL, + `performed_by_guid` int(11) NOT NULL, + `owner_guid` int(11) NOT NULL, + `access_id` int(11) NOT NULL, + `enabled` enum('yes','no') NOT NULL default 'yes', + `time_created` int(11) NOT NULL, + PRIMARY KEY (`id`), + KEY `object_id` (`object_id`), + KEY `object_class` (`object_class`), + KEY `object_type` (`object_type`), + KEY `object_subtype` (`object_subtype`), + KEY `event` (`event`), + KEY `performed_by_guid` (`performed_by_guid`), + KEY `access_id` (`access_id`), + KEY `time_created` (`time_created`), + KEY `river_key` (`object_type`,`object_subtype`,`event`) +) ENGINE=MyISAM AUTO_INCREMENT=194 DEFAULT CHARSET=utf8; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `prefix_users_apisessions` +-- + +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `prefix_users_apisessions` ( + `id` int(11) NOT NULL auto_increment, + `user_guid` bigint(20) unsigned NOT NULL, + `site_guid` bigint(20) unsigned NOT NULL, + `token` varchar(40) default NULL, + `expires` int(11) NOT NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `user_guid` (`user_guid`,`site_guid`), + KEY `token` (`token`) +) ENGINE=MEMORY DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `prefix_users_entity` +-- + +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `prefix_users_entity` ( + `guid` bigint(20) unsigned NOT NULL, + `name` text NOT NULL, + `username` varchar(128) NOT NULL default '', + `password` varchar(32) NOT NULL default '', + `salt` varchar(8) NOT NULL default '', + `email` text NOT NULL, + `language` varchar(6) NOT NULL default '', + `code` varchar(32) NOT NULL default '', + `banned` enum('yes','no') NOT NULL default 'no', + `last_action` int(11) NOT NULL default '0', + `prev_last_action` int(11) NOT NULL default '0', + `last_login` int(11) NOT NULL default '0', + `prev_last_login` int(11) NOT NULL default '0', + PRIMARY KEY (`guid`), + UNIQUE KEY `username` (`username`), + KEY `password` (`password`), + KEY `email` (`email`(50)), + KEY `code` (`code`), + KEY `last_action` (`last_action`), + KEY `last_login` (`last_login`), + FULLTEXT KEY `name` (`name`), + FULLTEXT KEY `name_2` (`name`,`username`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `prefix_users_sessions` +-- + +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `prefix_users_sessions` ( + `session` varchar(255) NOT NULL, + `ts` int(11) unsigned NOT NULL default '0', + `data` mediumblob, + PRIMARY KEY (`session`), + KEY `ts` (`ts`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +SET character_set_client = @saved_cs_client; +/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; + +/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; +/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; +/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; +/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; +/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; +/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; +/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; + +-- Dump completed on 2010-01-08 20:13:45 -- cgit v1.2.3