Changeset 8627 for trunk

Timestamp:

01/14/12 07:44:49 (16 months ago)

Author:

MELERIX

Message:

BETA/STABLE: Added email & created_time columns to accounts.sql (used by some tools like ACM and Drupal).

Location:

trunk/L2J_DataPack/dist/sql/login

Files:

• accounts.sql (modified) (1 diff)
• updates/20120114update.sql (added)

trunk/L2J_DataPack/dist/sql/login/accounts.sql

@@ -1 +1 @@
 CREATE TABLE IF NOT EXISTS `accounts` (
   `login` VARCHAR(45) NOT NULL default '',
-  `password` VARCHAR(45) ,
+  `password` VARCHAR(45),
+  `email` varchar(255) DEFAULT NULL,
+  `created_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
   `lastactive` bigint(13) unsigned NOT NULL DEFAULT '0',
   `accessLevel` TINYINT NOT NULL DEFAULT 0,