From dd49dbc3e8d2033c0dddc80f1d5b3c8e6710a419 Mon Sep 17 00:00:00 2001
From: Ibrahim Hossam <ibrahem.h.basyone@gmail.com>
Date: Tue, 8 Apr 2014 20:40:12 +0200
Subject: Rewritten NSI_UNIQUE_ID system to get rid of the cross-database
 interreg dependency

- Removes the need for map-server to access the interreg table to store the last used ID.
- Login, char and map databases can now be hosted separately.
- Note: the unique_id structure has changed, and it now contains the generator character ID in its upper 32 bits.
- Now NSI_UNIQUE_ID System is enabled always

Special thanks to Haruna.
---
 sql-files/upgrades/2014-04-07--22-04.sql | 3 +++
 1 file changed, 3 insertions(+)
 create mode 100644 sql-files/upgrades/2014-04-07--22-04.sql

(limited to 'sql-files/upgrades/2014-04-07--22-04.sql')

diff --git a/sql-files/upgrades/2014-04-07--22-04.sql b/sql-files/upgrades/2014-04-07--22-04.sql
new file mode 100644
index 000000000..9e33d6aec
--- /dev/null
+++ b/sql-files/upgrades/2014-04-07--22-04.sql
@@ -0,0 +1,3 @@
+#1396893866
+ALTER TABLE `char` ADD COLUMN `uniqueitem_counter`  bigint(20) NOT NULL AFTER `unban_time`;
+INSERT INTO `sql_updates` (`timestamp`) VALUES (1396893866);
-- 
cgit v1.2.3-70-g09d2

