summaryrefslogtreecommitdiff
path: root/sql-files/upgrade_svn14713_log.sql
diff options
context:
space:
mode:
authorai4rei <ai4rei@54d463be-8e91-2dee-dedb-b68131a5f0ec>2011-02-19 12:59:36 +0000
committerai4rei <ai4rei@54d463be-8e91-2dee-dedb-b68131a5f0ec>2011-02-19 12:59:36 +0000
commit4c5b768b6ac5a561e96b492d66d44042227fb856 (patch)
tree1035af16b8e7f6fc5d941e2a883f4658c0b95dbc /sql-files/upgrade_svn14713_log.sql
parente29d0c257f7e762dcd81994ca987768d54ddb14d (diff)
downloadhercules-4c5b768b6ac5a561e96b492d66d44042227fb856.tar.gz
hercules-4c5b768b6ac5a561e96b492d66d44042227fb856.tar.bz2
hercules-4c5b768b6ac5a561e96b492d66d44042227fb856.tar.xz
hercules-4c5b768b6ac5a561e96b492d66d44042227fb856.zip
* Implemented buying store system (aka. reverse vending, purchase shop) together with related skill and items, without NPCs.
- For SQL apply upgrade_svn14713_log.sql to upgrade tables `picklog` and `zenylog`; for TXT no action is necessary. - Requires 2010-04-20aRagexeRE or later and can be disabled in 'conf/battle/feature.conf'. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@14713 54d463be-8e91-2dee-dedb-b68131a5f0ec
Diffstat (limited to 'sql-files/upgrade_svn14713_log.sql')
-rw-r--r--sql-files/upgrade_svn14713_log.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/sql-files/upgrade_svn14713_log.sql b/sql-files/upgrade_svn14713_log.sql
new file mode 100644
index 000000000..be4059ebe
--- /dev/null
+++ b/sql-files/upgrade_svn14713_log.sql
@@ -0,0 +1,4 @@
+-- Adds 'B' to `type` in `picklog` and `zenylog`
+
+ALTER TABLE `picklog` MODIFY `type` ENUM('M','P','L','T','V','S','N','C','A','R','G','E','B') NOT NULL DEFAULT 'P';
+ALTER TABLE `zenylog` MODIFY `type` ENUM('M','T','V','S','N','A','E','B') NOT NULL DEFAULT 'S';