好友
阅读权限25
听众
最后登录1970-1-1
|
mosou
发表于 2019-4-20 21:07
Xiao伟 发表于 2019-4-20 20:49
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'duanshipin.mac_admin' doesn't exist 缺 ...
-- ----------------------------
-- Database structure for `jiexi`
-- ----------------------------
-- ----------------------------
-- Table structure for `jx_admin`
-- ----------------------------
DROP TABLE IF EXISTS `jx_admin`;
CREATE TABLE `jx_admin` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(15) NOT NULL,
`password` varchar(32) NOT NULL,
`salt` varchar(8) NOT NULL DEFAULT '',
`nickname` varchar(20) NOT NULL,
`qq` int(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ;
-- ----------------------------
-- Table structure for `jx_dingdan`
-- ----------------------------
DROP TABLE IF EXISTS `jx_dingdan`;
CREATE TABLE `jx_dingdan` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`order_code` varchar(17) NOT NULL,
`time` int(10) NOT NULL,
`userid` int(10) NOT NULL,
`type` int(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ;
-- ----------------------------
-- Table structure for `jx_interface`
-- ----------------------------
DROP TABLE IF EXISTS `jx_interface`;
CREATE TABLE `jx_interface` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '接口id',
`name` varchar(35) NOT NULL COMMENT '接口名称',
`nickname` varchar(35) NOT NULL COMMENT '接口别名(匹配url唯一根据)',
`url` varchar(255) NOT NULL COMMENT '接口地址',
`status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '接口状态',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ;
-- ----------------------------
-- Table structure for `jx_user`
-- ----------------------------
DROP TABLE IF EXISTS `jx_user`;
CREATE TABLE `jx_user` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(20) NOT NULL,
`password` varchar(32) NOT NULL,
`salt` varchar(8) NOT NULL,
`email` varchar(255) NOT NULL,
`qq` varchar(11) NOT NULL,
`status` tinyint(1) NOT NULL DEFAULT '1',
`vip` tinyint(1) NOT NULL DEFAULT '0',
`money` decimal(6,2) NOT NULL DEFAULT '0.00',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ;
-- ----------------------------
-- Table structure for `jx_viplist`
-- ----------------------------
DROP TABLE IF EXISTS `jx_viplist`;
CREATE TABLE `jx_viplist` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`userid` int(10) NOT NULL,
`startime` int(15) NOT NULL,
`endtime` int(15) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ; |
|