diff options
Diffstat (limited to 'engine/schema/upgrades')
| -rw-r--r-- | engine/schema/upgrades/2008111901.sql | 2 | ||||
| -rw-r--r-- | engine/schema/upgrades/2008112002.sql | 2 | ||||
| -rw-r--r-- | engine/schema/upgrades/2008120501.sql | 9 | ||||
| -rw-r--r-- | engine/schema/upgrades/2009010801.sql | 5 | ||||
| -rw-r--r-- | engine/schema/upgrades/2009010901.sql | 3 | ||||
| -rw-r--r-- | engine/schema/upgrades/2009021201.sql | 19 | ||||
| -rw-r--r-- | engine/schema/upgrades/2009021301.sql | 2 | ||||
| -rw-r--r-- | engine/schema/upgrades/2009051401.sql | 5 | ||||
| -rw-r--r-- | engine/schema/upgrades/2009052201.sql | 5 | ||||
| -rw-r--r-- | engine/schema/upgrades/2009091901.sql | 3 | ||||
| -rw-r--r-- | engine/schema/upgrades/2009100701.sql | 2 | ||||
| -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 |
14 files changed, 58 insertions, 2 deletions
diff --git a/engine/schema/upgrades/2008111901.sql b/engine/schema/upgrades/2008111901.sql index 7c27c9c50..617678bb6 100644 --- a/engine/schema/upgrades/2008111901.sql +++ b/engine/schema/upgrades/2008111901.sql @@ -1,7 +1,7 @@ CREATE TABLE IF NOT EXISTS `prefix_private_settings` (
`id` INT NOT NULL auto_increment,
`entity_guid` INT NOT NULL ,
- `name` VARCHAR( 32 ) NOT NULL ,
+ `name` VARCHAR( 128 ) NOT NULL ,
`value` TEXT NOT NULL ,
PRIMARY KEY ( `id` ) ,
UNIQUE KEY ( `entity_guid` , `name` )
diff --git a/engine/schema/upgrades/2008112002.sql b/engine/schema/upgrades/2008112002.sql index 31b3cc6eb..cdd308fe0 100644 --- a/engine/schema/upgrades/2008112002.sql +++ b/engine/schema/upgrades/2008112002.sql @@ -10,7 +10,7 @@ INSERT INTO `prefix_private_settings` (entity_guid, name, `value`) -- Delete previous settings CREATE TEMPORARY TABLE __upgrade_2008112002_1 ( - SELECT distinct meta.id as id from `prefix_metadata meta` + SELECT distinct meta.id as id from `prefix_metadata` meta JOIN `prefix_private_settings` settings ON meta.entity_guid = settings.entity_guid JOIN `prefix_entities` e ON e.guid = meta.entity_guid diff --git a/engine/schema/upgrades/2008120501.sql b/engine/schema/upgrades/2008120501.sql new file mode 100644 index 000000000..dd44b96b0 --- /dev/null +++ b/engine/schema/upgrades/2008120501.sql @@ -0,0 +1,9 @@ +-- Modify field length in private settings (for people who upgraded while #611 present) +ALTER TABLE `prefix_private_settings` MODIFY `name` varchar(128) NOT NULL; + +-- While we're at it, add some more keys +ALTER TABLE `prefix_private_settings` DROP KEY `name`; +ALTER TABLE `prefix_private_settings` ADD KEY `name` (`name`); + +ALTER TABLE `prefix_private_settings` DROP KEY `value`; +ALTER TABLE `prefix_private_settings` ADD KEY `value` (`value` (50));
\ No newline at end of file diff --git a/engine/schema/upgrades/2009010801.sql b/engine/schema/upgrades/2009010801.sql new file mode 100644 index 000000000..1e7c020e8 --- /dev/null +++ b/engine/schema/upgrades/2009010801.sql @@ -0,0 +1,5 @@ +ALTER TABLE `prefix_users_entity` DROP KEY `last_action`; +ALTER TABLE `prefix_users_entity` ADD KEY `last_action` (`last_action`); + +ALTER TABLE `prefix_users_entity` DROP KEY `last_login`; +ALTER TABLE `prefix_users_entity` ADD KEY `last_login` (`last_login`);
\ No newline at end of file diff --git a/engine/schema/upgrades/2009010901.sql b/engine/schema/upgrades/2009010901.sql new file mode 100644 index 000000000..29eb68f29 --- /dev/null +++ b/engine/schema/upgrades/2009010901.sql @@ -0,0 +1,3 @@ +-- Add banned column refs #668 +ALTER TABLE `prefix_users_entity` ADD COLUMN `banned` enum ('yes', 'no') NOT NULL default 'no' AFTER `code`; + diff --git a/engine/schema/upgrades/2009021201.sql b/engine/schema/upgrades/2009021201.sql new file mode 100644 index 000000000..e3edf66ba --- /dev/null +++ b/engine/schema/upgrades/2009021201.sql @@ -0,0 +1,19 @@ +-- River
+ CREATE TABLE IF NOT EXISTS `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 ,
+ `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 `posted` (`posted`)
+) ENGINE = MYISAM DEFAULT CHARSET=utf8;
\ No newline at end of file diff --git a/engine/schema/upgrades/2009021301.sql b/engine/schema/upgrades/2009021301.sql new file mode 100644 index 000000000..efec52b93 --- /dev/null +++ b/engine/schema/upgrades/2009021301.sql @@ -0,0 +1,2 @@ +-- Changing the ACLs on existing groups
+UPDATE `prefix_entities` SET access_id=2 WHERE type='group';
\ No newline at end of file diff --git a/engine/schema/upgrades/2009051401.sql b/engine/schema/upgrades/2009051401.sql new file mode 100644 index 000000000..57348968e --- /dev/null +++ b/engine/schema/upgrades/2009051401.sql @@ -0,0 +1,5 @@ +-- Fix error in geocode cache table +DELETE FROM `prefix_geocode_cache`; + +ALTER TABLE `prefix_geocode_cache` DROP KEY `location`; +ALTER TABLE `prefix_geocode_cache` ADD UNIQUE KEY `location` (`location`); diff --git a/engine/schema/upgrades/2009052201.sql b/engine/schema/upgrades/2009052201.sql new file mode 100644 index 000000000..b825f9936 --- /dev/null +++ b/engine/schema/upgrades/2009052201.sql @@ -0,0 +1,5 @@ +ALTER TABLE `prefix_groups_entity` DROP KEY `name`; +ALTER TABLE `prefix_groups_entity` ADD KEY `name` (`name`(50)); + +ALTER TABLE `prefix_groups_entity` DROP KEY `description`; +ALTER TABLE `prefix_groups_entity` ADD KEY `description` (`description`(50)); diff --git a/engine/schema/upgrades/2009091901.sql b/engine/schema/upgrades/2009091901.sql new file mode 100644 index 000000000..074d042c3 --- /dev/null +++ b/engine/schema/upgrades/2009091901.sql @@ -0,0 +1,3 @@ +-- add an additional column to the river table
+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 new file mode 100644 index 000000000..74249e901 --- /dev/null +++ b/engine/schema/upgrades/2009100701.sql @@ -0,0 +1,2 @@ +-- 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 |