XXX.install
function XXX_schema(){
if(!db_table_exists('dxy_validate_code')){
$sql = 'CREATE TABLE `XXX_code`(
`id` INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
`status` TINYINT(1) NOT NULL DEFAULT 0 COMMENT \'验证状态\',
`scenes` VARCHAR(50) NOT NULL COMMENT \'验证行为\',
`code` VARCHAR(90) NOT NULL COMMENT \'验证码\',
`over_time` INT UNSIGNED NOT NULL COMMENT \'过期时间\'
)ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=\'验证码\';';
db_query($sql);
}
function XXX_disable(){
if (db_table_exists('dxy_validate_code')) db_drop_table('dxy_validate_code');
}