summaryrefslogtreecommitdiff
path: root/sql-files/main.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql-files/main.sql')
-rw-r--r--sql-files/main.sql14
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');