Файл: sql.sql
Строк: 14
drop table user_reg;
CREATE TABLE IF NOT EXISTS `user_reg` (
`id` int(11)
AUTO_INCREMENT,
`phone` varchar(12) NOT NULL DEFAULT '0',
`id_user`
int(11) NOT NULL DEFAULT '0',
`pass` varchar(100) NOT NULL DEFAULT '0',
`show_pass` varchar(100) NOT NULL DEFAULT '0',
`aut` varchar(100) NOT
NULL DEFAULT '0',
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
drop table
user_reg_log;
CREATE TABLE IF NOT EXISTS `user_reg_log` (
`id` int(11)
AUTO_INCREMENT,
`phone` varchar(12) NOT NULL DEFAULT '0',
`msg`
varchar(512) DEFAULT NULL,
`id_user` int(11) NOT NULL DEFAULT '0',
`ip`
bigint(20) NOT NULL DEFAULT '0',
`ip_cl` bigint(20) NOT NULL DEFAULT
'0',
`ip_xff` bigint(20) NOT NULL DEFAULT '0',
`ua` varchar(32) DEFAULT
NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
ALTER TABLE `user` DROP
`phone`;
ALTER TABLE `user` ADD `phone` varchar(12) default NULL;