添加表:
epass
,执行
SQL
:
CREATE TABLE IF NOT EXISTS `epass` (
`epass_id` int(11) NOT NULL AUTO_INCREMENT,
`epass_sn`
varchar(16)
CHARACTER
SET
utf8
COLLATE
utf8_unicode_ci
NOT
NULL,`epass_key` varchar(16) CHARACTER SET utf8 COLLATE utf8_turkish_ci NOT
NULL, `epass_data`
varchar(32)
CHARACTER
SET
utf8
COLLATE
utf8_unicode_ci
NOT
NULL,
`epass_time`
timestamp
NOT
NULL
DEFAULT
CURRENT_TIMESTAMP,
`state`
int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`epass_id`)) ENGINE=MyISAM DEFAULT
CHARSET=gbk AUTO_INCREMENT=1 ;
USER_INFO
表添加字段:
epass_id
,
epass_state
,
eapss_loagin
,执行
SQL
:
ALTER
TABLE
`user_info`
ADD
`epass_state`
INT(
1
)
NOT
NULL
,ADD
`epass_login`
INT(
1
)
NOT NULL , ADD `epass_id` INT( 1 ) NOT NULL
代码清单