From 1a373535934aa786d67dec6fbf42c53b659b540d Mon Sep 17 00:00:00 2001
From: Andrei Karas <akaras@inbox.ru>
Date: Wed, 25 Feb 2015 23:57:32 +0300
Subject: hercules: in db converter drop table and the recrate it.

---
 hercules/templates/acc_reg_num_db.sql  | 2 ++
 hercules/templates/char.sql            | 2 ++
 hercules/templates/char_reg_num_db.sql | 2 ++
 hercules/templates/inventory.sql       | 2 ++
 hercules/templates/login.sql           | 2 ++
 hercules/templates/party.sql           | 2 ++
 hercules/templates/skill.sql           | 2 ++
 hercules/templates/storage.sql         | 2 ++
 8 files changed, 16 insertions(+)

(limited to 'hercules')

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',
-- 
cgit v1.2.3-70-g09d2