diff options
| author | Andrei Karas <akaras@inbox.ru> | 2015-02-25 23:57:32 +0300 |
|---|---|---|
| committer | Andrei Karas <akaras@inbox.ru> | 2015-02-25 23:57:32 +0300 |
| commit | 1a373535934aa786d67dec6fbf42c53b659b540d (patch) | |
| tree | c112951121f5e3412e8d214e5eae5ed9eac801e7 /hercules | |
| parent | c6892d9631000859b04a203b1d2e9e5a828c2ffa (diff) | |
| download | evol-tools-1a373535934aa786d67dec6fbf42c53b659b540d.tar.gz evol-tools-1a373535934aa786d67dec6fbf42c53b659b540d.tar.bz2 evol-tools-1a373535934aa786d67dec6fbf42c53b659b540d.tar.xz evol-tools-1a373535934aa786d67dec6fbf42c53b659b540d.zip | |
hercules: in db converter drop table and the recrate it.
Diffstat (limited to 'hercules')
| -rw-r--r-- | hercules/templates/acc_reg_num_db.sql | 2 | ||||
| -rw-r--r-- | hercules/templates/char.sql | 2 | ||||
| -rw-r--r-- | hercules/templates/char_reg_num_db.sql | 2 | ||||
| -rw-r--r-- | hercules/templates/inventory.sql | 2 | ||||
| -rw-r--r-- | hercules/templates/login.sql | 2 | ||||
| -rw-r--r-- | hercules/templates/party.sql | 2 | ||||
| -rw-r--r-- | hercules/templates/skill.sql | 2 | ||||
| -rw-r--r-- | hercules/templates/storage.sql | 2 |
8 files changed, 16 insertions, 0 deletions
diff --git a/hercules/templates/acc_reg_num_db.sql b/hercules/templates/acc_reg_num_db.sql index 71552c2..da8b061 100644 --- a/hercules/templates/acc_reg_num_db.sql +++ b/hercules/templates/acc_reg_num_db.sql @@ -1,3 +1,5 @@ +DROP TABLE IF EXISTS `acc_reg_num_db`; + CREATE TABLE IF NOT EXISTS `acc_reg_num_db` ( `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', `key` VARCHAR(32) BINARY NOT NULL DEFAULT '', diff --git a/hercules/templates/char.sql b/hercules/templates/char.sql index db30d1b..37a1d55 100644 --- a/hercules/templates/char.sql +++ b/hercules/templates/char.sql @@ -1,3 +1,5 @@ +DROP TABLE IF EXISTS `char`; + CREATE TABLE IF NOT EXISTS `char` ( `char_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', diff --git a/hercules/templates/char_reg_num_db.sql b/hercules/templates/char_reg_num_db.sql index dd96ae9..ea9429f 100644 --- a/hercules/templates/char_reg_num_db.sql +++ b/hercules/templates/char_reg_num_db.sql @@ -1,3 +1,5 @@ +DROP TABLE IF EXISTS `char_reg_num_db`; + CREATE TABLE IF NOT EXISTS `char_reg_num_db` ( `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', `key` VARCHAR(32) BINARY NOT NULL DEFAULT '', diff --git a/hercules/templates/inventory.sql b/hercules/templates/inventory.sql index 196dc5d..9fabd54 100644 --- a/hercules/templates/inventory.sql +++ b/hercules/templates/inventory.sql @@ -1,3 +1,5 @@ +DROP TABLE IF EXISTS `inventory`; + CREATE TABLE IF NOT EXISTS `inventory` ( `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', diff --git a/hercules/templates/login.sql b/hercules/templates/login.sql index 39bf531..804478d 100644 --- a/hercules/templates/login.sql +++ b/hercules/templates/login.sql @@ -1,3 +1,5 @@ +DROP TABLE IF EXISTS `login`; + CREATE TABLE IF NOT EXISTS `login` ( `account_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `userid` VARCHAR(23) NOT NULL DEFAULT '', diff --git a/hercules/templates/party.sql b/hercules/templates/party.sql index 69b2c64..0beb439 100644 --- a/hercules/templates/party.sql +++ b/hercules/templates/party.sql @@ -1,3 +1,5 @@ +DROP TABLE IF EXISTS `party`; + CREATE TABLE IF NOT EXISTS `party` ( `party_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `name` VARCHAR(24) NOT NULL DEFAULT '', diff --git a/hercules/templates/skill.sql b/hercules/templates/skill.sql index d4a93df..2ee3002 100644 --- a/hercules/templates/skill.sql +++ b/hercules/templates/skill.sql @@ -1,3 +1,5 @@ +DROP TABLE IF EXISTS `skill`; + CREATE TABLE IF NOT EXISTS `skill` ( `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', `id` SMALLINT(11) UNSIGNED NOT NULL DEFAULT '0', diff --git a/hercules/templates/storage.sql b/hercules/templates/storage.sql index 80cdb13..027d291 100644 --- a/hercules/templates/storage.sql +++ b/hercules/templates/storage.sql @@ -1,3 +1,5 @@ +DROP TABLE IF EXISTS `storage`; + CREATE TABLE IF NOT EXISTS `storage` ( `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', |