diff options
Diffstat (limited to 'hercules/templates')
| -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', |