diff options
Diffstat (limited to 'engine/schema/upgrades')
| -rw-r--r-- | engine/schema/upgrades/2009091901.sql | 3 | ||||
| -rw-r--r-- | engine/schema/upgrades/2009100701.sql | 37 | ||||
| -rw-r--r-- | engine/schema/upgrades/2010012901.sql | 1 | ||||
| -rw-r--r-- | engine/schema/upgrades/2010030101.sql | 1 | ||||
| -rw-r--r-- | engine/schema/upgrades/2010062401.sql | 1 |
5 files changed, 7 insertions, 36 deletions
diff --git a/engine/schema/upgrades/2009091901.sql b/engine/schema/upgrades/2009091901.sql index 7182c7f76..074d042c3 100644 --- a/engine/schema/upgrades/2009091901.sql +++ b/engine/schema/upgrades/2009091901.sql @@ -1,2 +1,3 @@ -- add an additional column to the river table
-ALTER TABLE `prefix_river` ADD COLUMN `annotation_id` int(11) NOT NULL AFTER `posted`;
\ No newline at end of file +ALTER TABLE `prefix_river` ADD COLUMN `annotation_id` int(11) NOT NULL AFTER `object_guid`;
+ALTER TABLE `prefix_river` ADD KEY `annotation_id` (`annotation_id`);
\ No newline at end of file diff --git a/engine/schema/upgrades/2009100701.sql b/engine/schema/upgrades/2009100701.sql index 62ffac354..74249e901 100644 --- a/engine/schema/upgrades/2009100701.sql +++ b/engine/schema/upgrades/2009100701.sql @@ -1,35 +1,2 @@ -SET NAMES utf8; - -LOCK TABLES `prefix_metastrings` WRITE; -ALTER TABLE `prefix_metastrings` DISABLE KEYS; -REPLACE INTO `prefix_metastrings` (id, string) - SELECT id, unhex(hex(convert(string using latin1))) - FROM `prefix_metastrings`; -ALTER TABLE `prefix_metastrings` ENABLE KEYS; -UNLOCK TABLES; - -LOCK TABLES `prefix_groups_entity` WRITE; -ALTER TABLE `prefix_groups_entity` DISABLE KEYS; -REPLACE INTO `prefix_groups_entity` (guid, name, description) - SELECT guid, unhex(hex(convert(name using latin1))), unhex(hex(convert(description using latin1))) - FROM `prefix_groups_entity`; -ALTER TABLE `prefix_groups_entity` ENABLE KEYS; -UNLOCK TABLES; - -LOCK TABLES `prefix_objects_entity` WRITE; -ALTER TABLE `prefix_objects_entity` DISABLE KEYS; -REPLACE INTO `prefix_objects_entity` (guid, title, description) - SELECT guid, unhex(hex(convert(title using latin1))), unhex(hex(convert(description using latin1))) - FROM `prefix_objects_entity`; -ALTER TABLE `prefix_objects_entity` ENABLE KEYS; -UNLOCK TABLES; - -LOCK TABLES `prefix_users_entity` WRITE; -ALTER TABLE `prefix_users_entity` DISABLE KEYS; -REPLACE INTO `prefix_users_entity` (guid, name, username, password, salt, email, language, code, - banned, last_action, prev_last_action, last_login, prev_last_login) - SELECT guid, unhex(hex(convert(name using latin1))), username, password, salt, email, language, code, - banned, last_action, prev_last_action, last_login, prev_last_login - FROM `prefix_users_entity`; -ALTER TABLE `prefix_users_entity` ENABLE KEYS; -UNLOCK TABLES; +-- Previously was the UTF8 migration that is now in code at engine/lib/upgrades/2010033101.php +-- Keeping this file to force an overwrite and to avoid confusion with missing migrations. 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` diff --git a/engine/schema/upgrades/2010030101.sql b/engine/schema/upgrades/2010030101.sql new file mode 100644 index 000000000..cc7af98c9 --- /dev/null +++ b/engine/schema/upgrades/2010030101.sql @@ -0,0 +1 @@ +ALTER TABLE `prefix_entities` CHANGE `last_action` `last_action` INT( 11 ) NOT NULL DEFAULT '0' diff --git a/engine/schema/upgrades/2010062401.sql b/engine/schema/upgrades/2010062401.sql new file mode 100644 index 000000000..fbb49bfcf --- /dev/null +++ b/engine/schema/upgrades/2010062401.sql @@ -0,0 +1 @@ +ALTER TABLE `prefix_entity_relationships` ADD COLUMN `time_created` int(11) NOT NULL AFTER `guid_two`;
\ No newline at end of file |