diff options
| author | shennetsind <ind@henn.et> | 2013-02-14 17:18:11 -0200 |
|---|---|---|
| committer | shennetsind <ind@henn.et> | 2013-02-14 17:18:11 -0200 |
| commit | 2bc85620e0b91aaaa29f929e618d5f6d6623b4f0 (patch) | |
| tree | 3f828ba070367820df99d4e286dc2cc023b92cd9 /sql-files | |
| parent | 810ba40b78087cc6aa7eb9ad3a3e46534393b9e8 (diff) | |
| download | hercules-2bc85620e0b91aaaa29f929e618d5f6d6623b4f0.tar.gz hercules-2bc85620e0b91aaaa29f929e618d5f6d6623b4f0.tar.bz2 hercules-2bc85620e0b91aaaa29f929e618d5f6d6623b4f0.tar.xz hercules-2bc85620e0b91aaaa29f929e618d5f6d6623b4f0.zip | |
Fixed Bug #5018
Skills granted through scripts are now permanent, until this date they were not relog persistent
Signed-off-by: shennetsind <ind@henn.et>
Diffstat (limited to 'sql-files')
| -rw-r--r-- | sql-files/main.sql | 3 | ||||
| -rw-r--r-- | sql-files/upgrades/2013-02-14--16-15.sql | 7 | ||||
| -rw-r--r-- | sql-files/upgrades/index.txt | 1 |
3 files changed, 11 insertions, 0 deletions
diff --git a/sql-files/main.sql b/sql-files/main.sql index d772cec98..fbdf40dde 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -618,6 +618,7 @@ CREATE TABLE IF NOT EXISTS `skill` ( `char_id` int(11) unsigned NOT NULL default '0', `id` smallint(11) unsigned NOT NULL default '0', `lv` tinyint(4) unsigned NOT NULL default '0', + `flag` TINYINT(1) UNSIGNED NOT NULL default 0, PRIMARY KEY (`char_id`,`id`) ) ENGINE=MyISAM; @@ -641,6 +642,8 @@ CREATE TABLE IF NOT EXISTS `sql_updates` ( `ignored` enum('Yes','No') NOT NULL DEFAULT 'No' ) ENGINE=MyISAM; +-- Existent updates to enter +INSERT INTO `sql_updates` (`timestamp`) VALUES (1360858500); -- -- Table structure for table `sstatus` diff --git a/sql-files/upgrades/2013-02-14--16-15.sql b/sql-files/upgrades/2013-02-14--16-15.sql new file mode 100644 index 000000000..9afd034b1 --- /dev/null +++ b/sql-files/upgrades/2013-02-14--16-15.sql @@ -0,0 +1,7 @@ +#1360858500 +CREATE TABLE IF NOT EXISTS `sql_updates` ( + `timestamp` int(11) unsigned NOT NULL, + `ignored` enum('Yes','No') NOT NULL DEFAULT 'No' +) ENGINE=MyISAM; +ALTER TABLE `skill` ADD COLUMN `flag` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0; +INSERT INTO `sql_updates` (`timestamp`) VALUES (1360858500);
\ No newline at end of file diff --git a/sql-files/upgrades/index.txt b/sql-files/upgrades/index.txt index e69de29bb..e0c49cbce 100644 --- a/sql-files/upgrades/index.txt +++ b/sql-files/upgrades/index.txt @@ -0,0 +1 @@ +2013-02-14--16-15.sql
\ No newline at end of file |