diff options
Diffstat (limited to 'sql-files/main.sql')
-rw-r--r-- | sql-files/main.sql | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/sql-files/main.sql b/sql-files/main.sql index f2c574c79..f159260f1 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -21,7 +21,7 @@ CREATE TABLE IF NOT EXISTS `auction` ( `card1` smallint(11) NOT NULL default '0', `card2` smallint(11) NOT NULL default '0', `card3` smallint(11) NOT NULL default '0', - `nsiuid` bigint(20) unsigned NOT NULL default '0', + `unique_id` bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (`auction_id`) ) ENGINE=MyISAM; @@ -43,7 +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', - `nsiuid` bigint(20) unsigned NOT NULL default '0', + `unique_id` bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `char_id` (`char_id`) ) ENGINE=MyISAM; @@ -343,7 +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', - `nsiuid` bigint(20) unsigned NOT NULL default '0', + `unique_id` bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `guild_id` (`guild_id`) ) ENGINE=MyISAM; @@ -407,7 +407,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', - `nsiuid` bigint(20) unsigned NOT NULL default '0', + `unique_id` bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `char_id` (`char_id`) ) ENGINE=MyISAM; @@ -504,7 +504,7 @@ CREATE TABLE IF NOT EXISTS `mail` ( `card1` smallint(11) NOT NULL default '0', `card2` smallint(11) NOT NULL default '0', `card3` smallint(11) NOT NULL default '0', - `nsiuid` bigint(20) unsigned NOT NULL default '0', + `unique_id` bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM; @@ -666,7 +666,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', - `nsiuid` bigint(20) unsigned NOT NULL default '0', + `unique_id` bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=MyISAM; @@ -677,4 +677,4 @@ CREATE TABLE IF NOT EXISTS `interreg` ( PRIMARY KEY (`varname`) ) ENGINE=InnoDB; INSERT INTO `interreg` (`varname`, `value`) VALUES -('nsiuid', '0'); +('unique_id', '0'); |