· 7 years ago · Nov 10, 2018, 11:34 AM
1CREATE TABLE IF NOT EXISTS `admin_passwords` (
2`password_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Password
3Id',
4`user_id` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'User Id',
5`password_hash` varchar(100) DEFAULT NULL COMMENT 'Password Hash',
6`expires` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Expires',
7`last_updated` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Last Updated',
8PRIMARY KEY (`password_id`),
9KEY `ADMIN_PASSWORDS_USER_ID` (`user_id`)
10) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Admin Passwords';
11
12CREATE TABLE IF NOT EXISTS `admin_passwords` (
13`password_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Password
14Id',
15`user_id` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'User Id',
16`password_hash` varchar(100) DEFAULT NULL COMMENT 'Password Hash',
17`expires` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Expires',
18`last_updated` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Last Updated',
19PRIMARY KEY (`password_id`),
20KEY `ADMIN_PASSWORDS_USER_ID` (`user_id`)
21) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Admin Passwords';