diff options
Diffstat (limited to 'sql-files/upgrades')
-rw-r--r-- | sql-files/upgrades/2013-10-09--21-38.sql | 2 | ||||
-rw-r--r-- | sql-files/upgrades/2013-10-10--16-36.sql | 2 | ||||
-rw-r--r-- | sql-files/upgrades/2013-10-27--16-47.sql | 2 | ||||
-rw-r--r-- | sql-files/upgrades/2013-10-30--19-53.sql | 2 | ||||
-rw-r--r-- | sql-files/upgrades/2013-10-30--21-12.sql | 2 | ||||
-rw-r--r-- | sql-files/upgrades/2013-10-31--07-49.sql | 2 | ||||
-rw-r--r-- | sql-files/upgrades/2013-11-09--00-03.sql | 2 | ||||
-rw-r--r-- | sql-files/upgrades/2013-11-15--19-57.sql | 2 | ||||
-rw-r--r-- | sql-files/upgrades/2013-11-16--07-49.sql | 2 | ||||
-rw-r--r-- | sql-files/upgrades/2014-01-04--16-47.sql | 2 | ||||
-rw-r--r-- | sql-files/upgrades/2014-02-19--17-57.sql | 2 | ||||
-rw-r--r-- | sql-files/upgrades/index.txt | 2 |
12 files changed, 12 insertions, 12 deletions
diff --git a/sql-files/upgrades/2013-10-09--21-38.sql b/sql-files/upgrades/2013-10-09--21-38.sql index fee85c40b..918f8cd21 100644 --- a/sql-files/upgrades/2013-10-09--21-38.sql +++ b/sql-files/upgrades/2013-10-09--21-38.sql @@ -1,3 +1,3 @@ #1381354728 ALTER TABLE `zenylog` MODIFY `type` enum('T','V','P','M','S','N','D','C','A','E','I','B','K') NOT NULL DEFAULT 'S'; -INSERT INTO `sql_updates` (`timestamp`) VALUES (1381354728);
\ No newline at end of file +INSERT INTO `sql_updates` (`timestamp`) VALUES (1381354728); diff --git a/sql-files/upgrades/2013-10-10--16-36.sql b/sql-files/upgrades/2013-10-10--16-36.sql index 784449898..764e632aa 100644 --- a/sql-files/upgrades/2013-10-10--16-36.sql +++ b/sql-files/upgrades/2013-10-10--16-36.sql @@ -4,4 +4,4 @@ CREATE TABLE IF NOT EXISTS `account_data` ( `bank_vault` int(11) unsigned NOT NULL default '0', PRIMARY KEY (`account_id`) ) ENGINE=MyISAM; -INSERT INTO `sql_updates` (`timestamp`) VALUES (1381423003);
\ No newline at end of file +INSERT INTO `sql_updates` (`timestamp`) VALUES (1381423003); diff --git a/sql-files/upgrades/2013-10-27--16-47.sql b/sql-files/upgrades/2013-10-27--16-47.sql index e1a4a28f2..81131726c 100644 --- a/sql-files/upgrades/2013-10-27--16-47.sql +++ b/sql-files/upgrades/2013-10-27--16-47.sql @@ -3,4 +3,4 @@ ALTER TABLE `inventory` MODIFY `equip` int(11) unsigned NOT NULL default '0'; ALTER TABLE `storage` MODIFY `equip` int(11) unsigned NOT NULL default '0'; ALTER TABLE `cart_inventory` MODIFY `equip` int(11) unsigned NOT NULL default '0'; ALTER TABLE `guild_storage` MODIFY `equip` int(11) unsigned NOT NULL default '0'; -INSERT INTO `sql_updates` (`timestamp`) VALUES (1382892428);
\ No newline at end of file +INSERT INTO `sql_updates` (`timestamp`) VALUES (1382892428); diff --git a/sql-files/upgrades/2013-10-30--19-53.sql b/sql-files/upgrades/2013-10-30--19-53.sql index 8bc63b1f1..6bff8eaa5 100644 --- a/sql-files/upgrades/2013-10-30--19-53.sql +++ b/sql-files/upgrades/2013-10-30--19-53.sql @@ -2,4 +2,4 @@ ALTER TABLE `account_data` ADD `base_exp` TINYINT( 4 ) UNSIGNED NOT NULL default '100'; ALTER TABLE `account_data` ADD `base_drop` TINYINT( 4 ) UNSIGNED NOT NULL default '100'; ALTER TABLE `account_data` ADD `base_death` TINYINT( 4 ) UNSIGNED NOT NULL default '100'; -INSERT INTO `sql_updates` (`timestamp`) VALUES (1383162785);
\ No newline at end of file +INSERT INTO `sql_updates` (`timestamp`) VALUES (1383162785); diff --git a/sql-files/upgrades/2013-10-30--21-12.sql b/sql-files/upgrades/2013-10-30--21-12.sql index fdc16f418..33f052326 100644 --- a/sql-files/upgrades/2013-10-30--21-12.sql +++ b/sql-files/upgrades/2013-10-30--21-12.sql @@ -1,3 +1,3 @@ #1383167577 ALTER TABLE `char` ADD `font` TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT '0'; -INSERT INTO `sql_updates` (`timestamp`) VALUES (1383167577);
\ No newline at end of file +INSERT INTO `sql_updates` (`timestamp`) VALUES (1383167577); diff --git a/sql-files/upgrades/2013-10-31--07-49.sql b/sql-files/upgrades/2013-10-31--07-49.sql index f0c51b0d9..607753d54 100644 --- a/sql-files/upgrades/2013-10-31--07-49.sql +++ b/sql-files/upgrades/2013-10-31--07-49.sql @@ -3,4 +3,4 @@ ALTER TABLE `inventory` ADD COLUMN `bound` TINYINT(1) UNSIGNED NOT NULL DEFAULT ALTER TABLE `cart_inventory` ADD COLUMN `bound` tinyint(1) UNSIGNED NOT NULL default '0' AFTER `expire_time`; ALTER TABLE `storage` ADD COLUMN `bound` tinyint(1) UNSIGNED NOT NULL default '0' AFTER `expire_time`; ALTER TABLE `guild_storage` ADD COLUMN `bound` TINYINT(1) UNSIGNED NOT NULL default '0' AFTER `expire_time`; -INSERT INTO `sql_updates` (`timestamp`) VALUES (1383205740);
\ No newline at end of file +INSERT INTO `sql_updates` (`timestamp`) VALUES (1383205740); diff --git a/sql-files/upgrades/2013-11-09--00-03.sql b/sql-files/upgrades/2013-11-09--00-03.sql index 09c63307f..7ca887653 100644 --- a/sql-files/upgrades/2013-11-09--00-03.sql +++ b/sql-files/upgrades/2013-11-09--00-03.sql @@ -2,4 +2,4 @@ ALTER TABLE `account_data` MODIFY `base_exp` TINYINT( 4 ) UNSIGNED NOT NULL default '100'; ALTER TABLE `account_data` MODIFY `base_drop` TINYINT( 4 ) UNSIGNED NOT NULL default '100'; ALTER TABLE `account_data` MODIFY `base_death` TINYINT( 4 ) UNSIGNED NOT NULL default '100'; -INSERT INTO `sql_updates` (`timestamp`) VALUES (1383955424);
\ No newline at end of file +INSERT INTO `sql_updates` (`timestamp`) VALUES (1383955424); diff --git a/sql-files/upgrades/2013-11-15--19-57.sql b/sql-files/upgrades/2013-11-15--19-57.sql index 0644c47c9..d4d8ec501 100644 --- a/sql-files/upgrades/2013-11-15--19-57.sql +++ b/sql-files/upgrades/2013-11-15--19-57.sql @@ -2,4 +2,4 @@ UPDATE `account_data` SET `base_exp` = '100' WHERE `base_exp` = '0'; UPDATE `account_data` SET `base_drop` = '100' WHERE `base_drop` = '0'; UPDATE `account_data` SET `base_death` = '100' WHERE `base_death` = '0'; -INSERT INTO `sql_updates` (`timestamp`) VALUES (1384545461);
\ No newline at end of file +INSERT INTO `sql_updates` (`timestamp`) VALUES (1384545461); diff --git a/sql-files/upgrades/2013-11-16--07-49.sql b/sql-files/upgrades/2013-11-16--07-49.sql index 9f4b80452..15c740fd0 100644 --- a/sql-files/upgrades/2013-11-16--07-49.sql +++ b/sql-files/upgrades/2013-11-16--07-49.sql @@ -1,3 +1,3 @@ #1384588175 ALTER TABLE `char` ADD COLUMN `unban_time` int(11) unsigned NOT NULL default '0'; -INSERT INTO `sql_updates` (`timestamp`) VALUES (1384588175);
\ No newline at end of file +INSERT INTO `sql_updates` (`timestamp`) VALUES (1384588175); diff --git a/sql-files/upgrades/2014-01-04--16-47.sql b/sql-files/upgrades/2014-01-04--16-47.sql index a60ec1d24..53320a712 100644 --- a/sql-files/upgrades/2014-01-04--16-47.sql +++ b/sql-files/upgrades/2014-01-04--16-47.sql @@ -58,4 +58,4 @@ INSERT INTO `char_reg_str_db` (`char_id`, `key`, `index`, `value`) SELECT `char_ INSERT INTO `global_acc_reg_num_db` (`account_id`, `key`, `index`, `value`) SELECT `account_id`, `str`, 0, `value` FROM `global_reg_value` WHERE `type` = 1 AND `str` NOT LIKE '%$'; INSERT INTO `global_acc_reg_str_db` (`account_id`, `key`, `index`, `value`) SELECT `account_id`, `str`, 0, `value` FROM `global_reg_value` WHERE `type` = 1 AND `str` LIKE '%$'; #DROP TABLE `global_reg_value`; -INSERT INTO `sql_updates` (`timestamp`) VALUES (1388854043);
\ No newline at end of file +INSERT INTO `sql_updates` (`timestamp`) VALUES (1388854043); diff --git a/sql-files/upgrades/2014-02-19--17-57.sql b/sql-files/upgrades/2014-02-19--17-57.sql index ebebe6665..74cfdfe37 100644 --- a/sql-files/upgrades/2014-02-19--17-57.sql +++ b/sql-files/upgrades/2014-02-19--17-57.sql @@ -1,4 +1,4 @@ #1392832626 DELETE FROM `sc_data` WHERE `tick` = '-1'; ALTER TABLE `sc_data` ADD PRIMARY KEY (`account_id`,`char_id`,`type`); -INSERT INTO `sql_updates` (`timestamp`) VALUES (1392832626);
\ No newline at end of file +INSERT INTO `sql_updates` (`timestamp`) VALUES (1392832626); diff --git a/sql-files/upgrades/index.txt b/sql-files/upgrades/index.txt index 88019e12a..2383c0775 100644 --- a/sql-files/upgrades/index.txt +++ b/sql-files/upgrades/index.txt @@ -21,4 +21,4 @@ 2014-02-19--17-57.sql 2014-03-25--23-57.sql 2014-04-07--22-04.sql -2014-04-26--10-00.sql
\ No newline at end of file +2014-04-26--10-00.sql |