diff options
| author | shennetsind <ind@henn.et> | 2013-11-06 22:40:57 -0200 |
|---|---|---|
| committer | shennetsind <ind@henn.et> | 2013-11-06 22:40:57 -0200 |
| commit | b1f7e524a79ce3e7afd64becaa7657c71d59f18f (patch) | |
| tree | 3d0f808a23cb1ead6cc0811542ac4263643203dc /sql-files | |
| parent | 47401a4195c58e14f12200f1ba6aeb34ecd87df7 (diff) | |
| parent | 6be40f56a21e48505baa4ff69acc198aa6206bf1 (diff) | |
| download | hercules-b1f7e524a79ce3e7afd64becaa7657c71d59f18f.tar.gz hercules-b1f7e524a79ce3e7afd64becaa7657c71d59f18f.tar.bz2 hercules-b1f7e524a79ce3e7afd64becaa7657c71d59f18f.tar.xz hercules-b1f7e524a79ce3e7afd64becaa7657c71d59f18f.zip | |
Merge remote-tracking branch 'origin/master'
Signed-off-by: shennetsind <ind@henn.et>
Conflicts:
conf/messages.conf
src/common/mmo.h
src/map/pc_groups.c
src/map/pc_groups.h
Diffstat (limited to 'sql-files')
| -rw-r--r-- | sql-files/main.sql | 4 | ||||
| -rw-r--r-- | sql-files/upgrades/2013-10-31--07-49.sql | 4 |
2 files changed, 8 insertions, 0 deletions
diff --git a/sql-files/main.sql b/sql-files/main.sql index f8a225ee9..ddf3b6712 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -43,6 +43,7 @@ CREATE TABLE IF NOT EXISTS `cart_inventory` ( `card2` smallint(11) NOT NULL default '0', `card3` smallint(11) NOT NULL default '0', `expire_time` int(11) unsigned NOT NULL default '0', + `bound` tinyint(1) unsigned NOT NULL default '0', `unique_id` bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `char_id` (`char_id`) @@ -342,6 +343,7 @@ CREATE TABLE IF NOT EXISTS `guild_storage` ( `card2` smallint(11) NOT NULL default '0', `card3` smallint(11) NOT NULL default '0', `expire_time` int(11) unsigned NOT NULL default '0', + `bound` tinyint(1) unsigned NOT NULL default '0', `unique_id` bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `guild_id` (`guild_id`) @@ -406,6 +408,7 @@ CREATE TABLE IF NOT EXISTS `inventory` ( `card3` smallint(11) NOT NULL default '0', `expire_time` int(11) unsigned NOT NULL default '0', `favorite` tinyint(3) unsigned NOT NULL default '0', + `bound` tinyint(1) unsigned NOT NULL default '0', `unique_id` bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `char_id` (`char_id`) @@ -692,6 +695,7 @@ CREATE TABLE IF NOT EXISTS `storage` ( `card2` smallint(11) NOT NULL default '0', `card3` smallint(11) NOT NULL default '0', `expire_time` int(11) unsigned NOT NULL default '0', + `bound` tinyint(1) unsigned NOT NULL default '0', `unique_id` bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) diff --git a/sql-files/upgrades/2013-10-31--07-49.sql b/sql-files/upgrades/2013-10-31--07-49.sql new file mode 100644 index 000000000..40e0421c8 --- /dev/null +++ b/sql-files/upgrades/2013-10-31--07-49.sql @@ -0,0 +1,4 @@ +ALTER TABLE `inventory` ADD COLUMN `bound` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `favorite`; +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(3) UNSIGNED NOT NULL default '0' AFTER `expire_time`;
\ No newline at end of file |