From d28efc8fea64aeacb34077c1d4c29192e2aa72c5 Mon Sep 17 00:00:00 2001 From: brettp Date: Fri, 29 Jan 2010 19:37:35 +0000 Subject: Added db migration 2010012901 that adds last_action column to entities table. Bumped version number to 1.7b (2010012901). git-svn-id: http://code.elgg.org/elgg/trunk@3857 36083f99-b078-4883-b0ff-0f9b5a30f544 --- engine/schema/mysql.sql | 285 +++++++++++++++++----------------- engine/schema/upgrades/2010012901.sql | 1 + 2 files changed, 143 insertions(+), 143 deletions(-) create mode 100644 engine/schema/upgrades/2010012901.sql (limited to 'engine/schema') diff --git a/engine/schema/mysql.sql b/engine/schema/mysql.sql index 988e70d89..2235797ea 100644 --- a/engine/schema/mysql.sql +++ b/engine/schema/mysql.sql @@ -1,10 +1,8 @@ +-- MySQL dump 10.13 Distrib 5.1.37, for debian-linux-gnu (i486) -- --- Main Elgg database --- --- @link http://elgg.org/ --- - --- -------------------------------------------------------- +-- Host: localhost Database: elgg +-- ------------------------------------------------------ +-- Server version 5.1.37-1ubuntu5 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -21,40 +19,40 @@ -- Table structure for table `prefix_access_collection_membership` -- -SET @saved_cs_client = @@character_set_client; -SET character_set_client = utf8; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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`) + PRIMARY KEY (`user_guid`,`access_collection_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -SET character_set_client = @saved_cs_client; +/*!40101 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; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `prefix_access_collections` ( - `id` int(11) NOT NULL auto_increment, + `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`), + `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; +) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; +/*!40101 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; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `prefix_annotations` ( - `id` int(11) NOT NULL auto_increment, + `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, @@ -62,78 +60,79 @@ CREATE TABLE `prefix_annotations` ( `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`), + `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; +) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; +/*!40101 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; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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, + `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`), + `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; +/*!40101 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; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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`) + PRIMARY KEY (`name`,`site_guid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -SET character_set_client = @saved_cs_client; +/*!40101 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; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `prefix_datalists` ( `name` varchar(32) NOT NULL, `value` text NOT NULL, - PRIMARY KEY (`name`) + PRIMARY KEY (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -SET character_set_client = @saved_cs_client; +/*!40101 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; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `prefix_entities` ( - `guid` bigint(20) unsigned NOT NULL auto_increment, + `guid` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `type` enum('object','user','group','site') NOT NULL, - `subtype` int(11) default 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`), + `last_action` 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`), @@ -142,98 +141,98 @@ CREATE TABLE `prefix_entities` ( 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; +) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; +/*!40101 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; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `prefix_entity_relationships` ( - `id` int(11) NOT NULL auto_increment, + `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`), + 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; +) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `prefix_entity_subtypes` -- -SET @saved_cs_client = @@character_set_client; -SET character_set_client = utf8; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `prefix_entity_subtypes` ( - `id` int(11) NOT NULL auto_increment, + `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`), + `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; +) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; +/*!40101 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; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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`), + `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; +/*!40101 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; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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`), + PRIMARY KEY (`guid`), KEY `name` (`name`(50)), KEY `description` (`description`(50)), FULLTEXT KEY `name_2` (`name`,`description`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -SET character_set_client = @saved_cs_client; +/*!40101 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; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `prefix_hmac_cache` ( `hmac` varchar(255) NOT NULL, `ts` int(11) NOT NULL, - PRIMARY KEY (`hmac`), + PRIMARY KEY (`hmac`), KEY `ts` (`ts`) ) ENGINE=MEMORY DEFAULT CHARSET=latin1; -SET character_set_client = @saved_cs_client; +/*!40101 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; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `prefix_metadata` ( - `id` int(11) NOT NULL auto_increment, + `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, @@ -241,71 +240,71 @@ CREATE TABLE `prefix_metadata` ( `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`), + `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; +) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; +/*!40101 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; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `prefix_metastrings` ( - `id` int(11) NOT NULL auto_increment, + `id` int(11) NOT NULL AUTO_INCREMENT, `string` text NOT NULL, - PRIMARY KEY (`id`), + PRIMARY KEY (`id`), KEY `string` (`string`(50)) -) ENGINE=MyISAM AUTO_INCREMENT=67 DEFAULT CHARSET=utf8; -SET character_set_client = @saved_cs_client; +) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; +/*!40101 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; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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`), + PRIMARY KEY (`guid`), FULLTEXT KEY `title` (`title`,`description`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -SET character_set_client = @saved_cs_client; +/*!40101 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; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `prefix_private_settings` ( - `id` int(11) NOT NULL auto_increment, + `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`), + 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; +) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; +/*!40101 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; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `prefix_river` ( - `id` int(11) NOT NULL auto_increment, + `id` int(11) NOT NULL AUTO_INCREMENT, `type` varchar(8) NOT NULL, `subtype` varchar(32) NOT NULL, `action_type` varchar(32) NOT NULL, @@ -315,7 +314,7 @@ CREATE TABLE `prefix_river` ( `object_guid` int(11) NOT NULL, `annotation_id` int(11) NOT NULL, `posted` int(11) NOT NULL, - PRIMARY KEY (`id`), + PRIMARY KEY (`id`), KEY `type` (`type`), KEY `action_type` (`action_type`), KEY `access_id` (`access_id`), @@ -323,34 +322,34 @@ CREATE TABLE `prefix_river` ( 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; +) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; +/*!40101 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; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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`), + 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; +/*!40101 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; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `prefix_system_log` ( - `id` int(11) NOT NULL auto_increment, + `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, @@ -359,9 +358,9 @@ CREATE TABLE `prefix_system_log` ( `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', + `enabled` enum('yes','no') NOT NULL DEFAULT 'yes', `time_created` int(11) NOT NULL, - PRIMARY KEY (`id`), + PRIMARY KEY (`id`), KEY `object_id` (`object_id`), KEY `object_class` (`object_class`), KEY `object_type` (`object_type`), @@ -371,48 +370,48 @@ CREATE TABLE `prefix_system_log` ( 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; +) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; +/*!40101 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; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `prefix_users_apisessions` ( - `id` int(11) NOT NULL auto_increment, + `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, + `token` varchar(40) DEFAULT NULL, `expires` int(11) NOT NULL, - PRIMARY KEY (`id`), + 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; +/*!40101 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; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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 '', + `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`), + `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)), @@ -422,22 +421,22 @@ CREATE TABLE `prefix_users_entity` ( FULLTEXT KEY `name` (`name`), FULLTEXT KEY `name_2` (`name`,`username`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -SET character_set_client = @saved_cs_client; +/*!40101 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; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `prefix_users_sessions` ( `session` varchar(255) NOT NULL, - `ts` int(11) unsigned NOT NULL default '0', + `ts` int(11) unsigned NOT NULL DEFAULT '0', `data` mediumblob, - PRIMARY KEY (`session`), + PRIMARY KEY (`session`), KEY `ts` (`ts`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -SET character_set_client = @saved_cs_client; +/*!40101 SET character_set_client = @saved_cs_client */; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; @@ -448,4 +447,4 @@ SET character_set_client = @saved_cs_client; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2010-01-08 20:13:45 +-- Dump completed on 2010-01-29 14:28:11 diff --git a/engine/schema/upgrades/2010012901.sql b/engine/schema/upgrades/2010012901.sql new file mode 100644 index 000000000..fe5cb6849 --- /dev/null +++ b/engine/schema/upgrades/2010012901.sql @@ -0,0 +1 @@ +ALTER TABLE `prefix_entities` ADD `last_action` INT( 11 ) NOT NULL AFTER `time_updated` -- cgit v1.2.3