prefix."admin` ( `admin_id` int(4) NOT NULL AUTO_INCREMENT, `admin_name` varchar(20) DEFAULT NULL, `admin_account` varchar(50) DEFAULT NULL, `admin_password` varchar(50) DEFAULT NULL, `admin_salt` varchar(20) DEFAULT NULL, `admin_group` tinyint(1) DEFAULT NULL, `admin_lastloginip` varchar(100) DEFAULT NULL, `admin_lastlogintime` int(11) DEFAULT NULL, `admin_logincount` int(10) DEFAULT '0', `admin_addtime` int(11) DEFAULT NULL, PRIMARY KEY (`admin_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;"; $sqlarr[] = "INSERT INTO `".$mypdo->prefix."admin`(admin_id, admin_name, admin_account, admin_password, admin_salt, admin_group, admin_lastloginip, admin_lastlogintime, admin_logincount, admin_addtime) VALUES('1','','zhima','5ccf71a9c408315c57eddc0d8e317e60','1&Ge34YFtb','1','127.0.0.1','1524140927','6','1523696149');"; $sqlarr[] = "CREATE TABLE IF NOT EXISTS `".$mypdo->prefix."admingroup` ( `admingroup_id` int(4) NOT NULL AUTO_INCREMENT, `admingroup_name` varchar(50) NOT NULL, `admingroup_auth` varchar(600) DEFAULT NULL, `admingroup_order` int(4) NOT NULL DEFAULT '99', PRIMARY KEY (`admingroup_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;"; $sqlarr[] = "INSERT INTO `".$mypdo->prefix."admingroup` (`admingroup_id`, `admingroup_name`, `admingroup_auth`, `admingroup_order`) VALUES(1, '超级管理员', 'SUPER', 1);"; $sqlarr[] = "CREATE TABLE IF NOT EXISTS `".$mypdo->prefix."adminlog` ( `adminlog_id` int(10) NOT NULL AUTO_INCREMENT, `adminlog_admin` int(4) DEFAULT NULL, `adminlog_time` int(11) DEFAULT NULL, `adminlog_log` varchar(600) DEFAULT NULL, `adminlog_ip` varchar(100) DEFAULT NULL, PRIMARY KEY (`adminlog_id`), KEY `adminlog_admin` (`adminlog_admin`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;"; $count = count($sqlarr); for($i=0; $i<$count; $i++){ $mypdo->pdo->exec($sqlarr[$i]); } echo '执行完毕！
'.'执行时间：'.getRunTime().'秒'; ?>