summaryrefslogtreecommitdiff
path: root/sql-files
diff options
context:
space:
mode:
authorshennetsind <ind@henn.et>2013-10-30 19:39:40 -0200
committershennetsind <ind@henn.et>2013-10-30 19:39:40 -0200
commit4340bf74d5fa64d8205bc86a3d2c0592b7a542c7 (patch)
tree32ce19a100e51f91c6ee167d175176535688d78a /sql-files
parent629c80479f0276882ae998f8cefa28a376621c9a (diff)
downloadhercules-4340bf74d5fa64d8205bc86a3d2c0592b7a542c7.tar.gz
hercules-4340bf74d5fa64d8205bc86a3d2c0592b7a542c7.tar.bz2
hercules-4340bf74d5fa64d8205bc86a3d2c0592b7a542c7.tar.xz
hercules-4340bf74d5fa64d8205bc86a3d2c0592b7a542c7.zip
Official Font Support
Fonts are now relog-persistent. Font items are now toggle-on/off, they no longer go away on use, they go away when their rental duration is over (and the font effect goes back to original). Special Thanks to Yommy for all the data! Signed-off-by: shennetsind <ind@henn.et>
Diffstat (limited to 'sql-files')
-rw-r--r--sql-files/main.sql2
-rw-r--r--sql-files/upgrades/2013-10-30--21-12.sql3
-rw-r--r--sql-files/upgrades/index.txt3
3 files changed, 7 insertions, 1 deletions
diff --git a/sql-files/main.sql b/sql-files/main.sql
index 8bd28c414..2c91d58b1 100644
--- a/sql-files/main.sql
+++ b/sql-files/main.sql
@@ -108,6 +108,7 @@ CREATE TABLE IF NOT EXISTS `char` (
`delete_date` INT(11) unsigned NOT NULL DEFAULT '0',
`slotchange` SMALLINT(3) unsigned NOT NULL default '0',
`char_opt` INT( 11 ) unsigned NOT NULL default '0',
+ `font` TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`char_id`),
UNIQUE KEY `name_key` (`name`),
KEY `account_id` (`account_id`),
@@ -660,6 +661,7 @@ INSERT INTO `sql_updates` (`timestamp`) VALUES (1366078541);
INSERT INTO `sql_updates` (`timestamp`) VALUES (1381354728);
INSERT INTO `sql_updates` (`timestamp`) VALUES (1381423003);
INSERT INTO `sql_updates` (`timestamp`) VALUES (1382892428);
+INSERT INTO `sql_updates` (`timestamp`) VALUES (1383167577);
--
-- Table structure for table `sstatus`
diff --git a/sql-files/upgrades/2013-10-30--21-12.sql b/sql-files/upgrades/2013-10-30--21-12.sql
new file mode 100644
index 000000000..fdc16f418
--- /dev/null
+++ b/sql-files/upgrades/2013-10-30--21-12.sql
@@ -0,0 +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
diff --git a/sql-files/upgrades/index.txt b/sql-files/upgrades/index.txt
index 4afcc5a0d..ca06e9c31 100644
--- a/sql-files/upgrades/index.txt
+++ b/sql-files/upgrades/index.txt
@@ -6,4 +6,5 @@
2013-04-16--01-24.sql
2013-10-09--21-38.sql
2013-10-10--16-36.sql
-2013-10-27--16-47.sql \ No newline at end of file
+2013-10-27--16-47.sql
+2013-10-30--21-12.sql \ No newline at end of file