PHP实例开发源码-口号帮h5微信游戏营销系统.zip

DROP TABLE IF EXISTS `{dbprefix}cron`; CREATE TABLE IF NOT EXISTS `{dbprefix}cron` ( `id` int(10) NOT NULL AUTO_INCREMENT, `site` int(10) NOT NULL COMMENT '站点', `type` varchar(20) NOT NULL COMMENT '类型', `value` text NOT NULL COMMENT '参数值', `status` tinyint(1) unsigned NOT NULL COMMENT '状态', `error` text DEFAULT NULL COMMENT '错误信息', `updatetime` int(10) unsigned NOT NULL COMMENT '执行时间', `inputtime` int(10) unsigned NOT NULL COMMENT '写入时间', PRIMARY KEY (`id`), KEY `site` (`site`), KEY `type` (`type`), KEY `status` (`status`), KEY `updatetime` (`updatetime`), KEY `inputtime` (`inputtime`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='任务管理'; DROP TABLE IF EXISTS `{dbprefix}var`; CREATE TABLE IF NOT EXISTS `{dbprefix}var` ( `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'Id', `name` varchar(100) NOT NULL COMMENT '变量描述名称', `cname` varchar(100) NOT NULL COMMENT '变量名称', `type` tinyint(2) NOT NULL COMMENT '变量类型', `value` text NOT NULL COMMENT '变量值', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='自定义变量表'; DROP TABLE IF EXISTS `{dbprefix}api_auth`; CREATE TABLE IF NOT EXISTS `{dbprefix}api_auth` ( `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'Id', `name` varchar(100) NOT NULL COMMENT '名称', `secret` varchar(100) NOT NULL COMMENT '密钥', `disabled` tinyint(1) unsigned NOT NULL COMMENT '禁用', `inputtime` int(10) unsigned NOT NULL COMMENT '创建时间', PRIMARY KEY (`id`), KEY `disabled` (`disabled`), KEY `inputtime` (`inputtime`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='api接口认证表'; DROP TABLE IF EXISTS `{dbprefix}api_http`; CREATE TABLE IF NOT EXISTS `{dbprefix}api_http` ( `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'Id', `name` varchar(100) NOT NULL COMMENT '名称', `content` text NOT NULL COMMENT '数据格式', `disabled` tinyint(1) unsigned NOT NULL COMMENT '禁用', `inputtime` int(10) unsigned NOT NULL COMMENT '创建时间', PRIMARY KEY (`id`), KEY `disabled` (`disabled`), KEY `inputtime` (`inputtime`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='api接口http数据表'; DROP TABLE IF EXISTS `{dbprefix}export`; CREATE TABLE IF NOT EXISTS `{dbprefix}export` ( `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'Id', `name` varchar(100) NOT NULL COMMENT '表名称', `value` text CHARACTER SET utf8 NOT NULL COMMENT '字段配置项目', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='导出数据字段配置'; DROP TABLE IF EXISTS `{dbprefix}urlrule`; CREATE TABLE IF NOT EXISTS `{dbprefix}urlrule` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `type` tinyint(1) unsigned NOT NULL COMMENT '规则类型', `name` varchar(50) NOT NULL COMMENT '规则名称', `value` text NOT NULL COMMENT '详细规则', PRIMARY KEY (`id`), KEY `type` (`type`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='URL规则表' ; DROP TABLE IF EXISTS `{dbprefix}admin`; CREATE TABLE IF NOT EXISTS `{dbprefix}admin` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `uid` int(10) unsigned NOT NULL COMMENT '管理员uid', `setting` Text DEFAULT NULL COMMENT '相关配置', `usermenu` text COMMENT '自定义面板菜单，序列化数组格式', PRIMARY KEY (`id`), UNIQUE KEY `uid` (`uid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='管理员表'; DROP TABLE IF EXISTS `{dbprefix}admin_notice`; CREATE TABLE IF NOT EXISTS `{dbprefix}admin_notice` ( `id` int(10) NOT NULL COMMENT 'id' AUTO_INCREMENT, `site` int(5) NOT NULL COMMENT '站点id', `type` varchar(20) NOT NULL COMMENT '提醒类型：系统、内容、会员、应用', `msg` text NOT NULL COMMENT '提醒内容说明', `uri` varchar(100) NOT NULL COMMENT '对应的URI', `to_rid` smallint(5) NOT NULL COMMENT '指定角色组', `to_uid` int(10) NOT NULL COMMENT '指定管理员', `status` tinyint(1) NOT NULL COMMENT '未处理0，1已查看，2处理中，3处理完成', `uid` int(10) NOT NULL COMMENT '申请人', `username` varchar(100) NOT NULL COMMENT '申请人', `op_uid` int(10) NOT NULL COMMENT '处理人', `op_username` varchar(100) NOT NULL COMMENT '处理人', `updatetime` int(10) NOT NULL COMMENT '处理时间', `inputtime` int(10) NOT NULL COMMENT '提醒时间', PRIMARY KEY (`id`), KEY `uri` (`uri`), KEY `site` (`site`), KEY `status` (`status`), KEY `uid` (`uid`), KEY `op_uid` (`op_uid`), KEY `to_uid` (`to_uid`), KEY `to_rid` (`to_rid`), KEY `updatetime` (`updatetime`), KEY `inputtime` (`inputtime`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='后台提醒表'; DROP TABLE IF EXISTS `{dbprefix}admin_login`; CREATE TABLE IF NOT EXISTS `{dbprefix}admin_login` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uid` mediumint(8) unsigned DEFAULT NULL COMMENT '会员uid', `loginip` varchar(50) NOT NULL COMMENT '登录Ip', `logintime` int(10) unsigned NOT NULL COMMENT '登录时间', `useragent` varchar(255) NOT NULL COMMENT '客户端信息', PRIMARY KEY (`id`), KEY `uid` (`uid`), KEY `loginip` (`loginip`), KEY `logintime` (`logintime`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='登录日志记录'; DROP TABLE IF EXISTS `{dbprefix}admin_menu`; CREATE TABLE IF NOT EXISTS `{dbprefix}admin_menu` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `pid` smallint(5) unsigned NOT NULL COMMENT '上级菜单id', `name` text NOT NULL COMMENT '菜单语言名称', `uri` varchar(255) DEFAULT NULL COMMENT 'uri字符串', `url` varchar(255) DEFAULT NULL COMMENT '外链地址', `mark` varchar(255) DEFAULT NULL COMMENT '菜单标识', `hidden` tinyint(1) unsigned DEFAULT NULL COMMENT '是否隐藏', `icon` varchar(255) DEFAULT NULL COMMENT '图标标示', `displayorder` int(5) DEFAULT NULL COMMENT '排序值', PRIMARY KEY (`id`), KEY `list` (`pid`), KEY `displayorder` (`displayorder`), KEY `mark` (`mark`), KEY `hidden` (`hidden`), KEY `uri` (`uri`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='后台菜单表'; DROP TABLE IF EXISTS `{dbprefix}admin_role`; CREATE TABLE IF NOT EXISTS `{dbprefix}admin_role` ( `id` smallint(5) NOT NULL AUTO_INCREMENT, `site` text NOT NULL COMMENT '允许管理的站点，序列化数组格式', `name` text NOT NULL COMMENT '角色组语言名称', `system` text NOT NULL COMMENT '系统权限', `module` text NOT NULL COMMENT '模块权限', `application` text NOT NULL COMMENT '应用权限', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='后台角色权限表'; DROP TABLE IF EXISTS `{dbprefix}admin_role_index`; CREATE TABLE IF NOT EXISTS `{dbprefix}admin_role_index` ( `id` smallint(5) NOT NULL AUTO_INCREMENT, `uid` mediumint(8) unsigned DEFAULT NULL COMMENT '会员uid', `roleid` mediumint(8) unsigned DEFAULT NULL COMMENT '角色组id', PRIMARY KEY (`id`), KEY (`uid`), KEY (`roleid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='后台角色组分配表'; DROP TABLE IF EXISTS `{dbprefix}admin_verify`; CREATE TABLE IF NOT EXISTS `{dbprefix}admin_verify` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `name` text NOT NULL COMMENT '名称', `verify` text NOT NULL COMMENT '审核部署', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='审核管理表'; DROP TABLE IF EXISTS `{dbprefix}mail_smtp`; CREATE TABLE IF NOT EXISTS `{dbprefix}mail_smtp` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `host` varchar(255) NOT NULL, `user` varchar(255) NOT NULL, `pass` varchar(255) NOT NULL, `port` mediumint(8) unsigned NOT NULL, `displayorder` smallint(5) DEFAULT NULL, PRIMARY KEY (`id`), KEY (`displayorder`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='邮件账�