summaryrefslogtreecommitdiff
path: root/sql-files/main.sql
diff options
context:
space:
mode:
authorHaruna <haru@dotalux.com>2014-04-19 22:37:54 +0200
committerHaruna <haru@dotalux.com>2014-04-19 22:37:54 +0200
commit93584f7416164985220293b7c08fcc29c4d5060f (patch)
tree2f2f533682e54dfe501ff4a470953e3a6bd2462f /sql-files/main.sql
parentcebfdc692ef4a5897c69304f88e585f8f1272c7e (diff)
parentdd49dbc3e8d2033c0dddc80f1d5b3c8e6710a419 (diff)
downloadhercules-93584f7416164985220293b7c08fcc29c4d5060f.tar.gz
hercules-93584f7416164985220293b7c08fcc29c4d5060f.tar.bz2
hercules-93584f7416164985220293b7c08fcc29c4d5060f.tar.xz
hercules-93584f7416164985220293b7c08fcc29c4d5060f.zip
Merge pull request #272 from hemagx/master
Rewritten NSI_UNIQUE_ID system
Diffstat (limited to 'sql-files/main.sql')
-rw-r--r--sql-files/main.sql3
1 files changed, 1 insertions, 2 deletions
diff --git a/sql-files/main.sql b/sql-files/main.sql
index 49d35a287..e6e71c2c1 100644
--- a/sql-files/main.sql
+++ b/sql-files/main.sql
@@ -111,6 +111,7 @@ CREATE TABLE IF NOT EXISTS `char` (
`char_opt` INT( 11 ) unsigned NOT NULL default '0',
`font` TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT '0',
`unban_time` int(11) unsigned NOT NULL default '0',
+ `uniqueitem_counter` bigint(20) NOT NULL,
PRIMARY KEY (`char_id`),
UNIQUE KEY `name_key` (`name`),
KEY `account_id` (`account_id`),
@@ -709,8 +710,6 @@ CREATE TABLE IF NOT EXISTS `interreg` (
`value` varchar(20) NOT NULL,
PRIMARY KEY (`varname`)
) ENGINE=InnoDB;
-INSERT INTO `interreg` (`varname`, `value`) VALUES
-('unique_id', '0');
--
-- Table structure for table `account_data`