（2）使用易语言CCHTTP开发WEB网站-后台登录

-- Adminer 4.8.1 MySQL 5.5.62-log dump SET NAMES utf8; SET time_zone = '+00:00'; SET foreign_key_checks = 0; SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO'; DROP TABLE IF EXISTS `e_api`; CREATE TABLE `e_api` ( `id` int(11) NOT NULL AUTO_INCREMENT, `fid` int(11) NOT NULL COMMENT '分类id', `apiname` varchar(99) NOT NULL, `name` varchar(999) NOT NULL, `mode` varchar(10) NOT NULL DEFAULT 'GET' COMMENT 'POST / GET', `data` text NOT NULL COMMENT '数据', `haders` text NOT NULL COMMENT '请求头', `describe` text NOT NULL COMMENT '接口描述', `drop` int(10) NOT NULL DEFAULT '1' COMMENT '扣点', `jointime` varchar(13) NOT NULL COMMENT '更新时间', `untime` varchar(13) NOT NULL COMMENT '上线时间', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; INSERT INTO `e_api` (`id`, `fid`, `apiname`, `name`, `mode`, `data`, `haders`, `describe`, `drop`, `jointime`, `untime`) VALUES (14, 0, '获取uuid参数', '/jd.app.uuid', 'GET', '', '', '', 0, '', ''), (15, 0, 'app-paysign', '/jd.app.paysign', 'POST', '{\"orderid\":\"1234567\",\"type\":\"\",\"price\":\"\"}', '', '', 1, '', ''), (12, 0, 'bod加密', '/jd.app.cipher.enc', 'POST', '{\"data\":{\"flag\":\"nickname\",\"fromSource\":1,\"sourceLevel\":1}}', '', '', 0, '', ''), (13, 0, '', '/jd.app.cipher.dec', 'POST', '{\"data\":\"oyTwbQPxStesbwvta25rbWUsBMTwcw9jU291cwDvStenBMTzb3VyY2VCZXZvbMS6CX0\"}', '', '', 0, '', ''), (11, 0, '京东sign-32位', '/jd.app.sign', 'POST', '{\"url\":\"https://api.m.jd.com/client.action?functionId=newUserInfo&clientVersion=12.3.5&client=android&eid=eidAd0618122b8sfCbUn2F1kSZ%2BHUtXKDnkUKAm1KWXmgW%2FSS61tpGYEggJ4YRssb%2FVX7FdsVaHUtea%2FxUdQZk0if11enKSKsGBcv4p5dBXwyboulwhR&ef=1&ep=%7B%22hdid%22%3A%22JM9F1ywUPwflvMIpYPok0tt5k9kW4ArJEU3lfLhxBqw%3D%22%2C%22ts%22%3A1708362876690%2C%22ridx%22%3A-1%2C%22cipher%22%3A%7B%22area%22%3A%22%22%2C%22d_model%22%3A%22%22%2C%22wifiBssid%22%3A%22%22%2C%22osVersion%22%3A%22%22%2C%22d_brand%22%3A%22%22%2C%22screen%22%3A%22%22%2C%22uuid%22%3A%22ZNKyYzHwZtG5YzDwYwDvCNTvYJO3YwUmCzqnYG%22%2C%22aid%22%3A%22ZNKyYzHwZtG5YzDwYwDvCNTvYJO3YwUmCzqnYG%22%2C%22openudid%22%3A%22ZNKyYzHwZtG5YzDwYwDvCNTvYJO3YwUmCzqnYG%22%7D%2C%22ciphertype%22%3A%225%22%2C%22version%22%3A%221.2.0%22%2C%22appname%22%3A%22com.jingdong.app.mall%22%7D&st=1708362876687&sv=111\",\"body\":{\"flag\":\"nickname\",\"fromSource\":1,\"sourceLevel\":1},\"uuid\":\"d02c4ff49c3fbce02ea17be0381a\"}', '', '', 2, '', ''); DROP TABLE IF EXISTS `e_api_sort`; CREATE TABLE `e_api_sort` ( `id` int(9) NOT NULL AUTO_INCREMENT, `off` int(1) NOT NULL DEFAULT '1' COMMENT '0关闭', `name` varchar(999) NOT NULL COMMENT '名称', `describe` varchar(999) NOT NULL COMMENT '描述', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; INSERT INTO `e_api_sort` (`id`, `off`, `name`, `describe`) VALUES (6, 1, '用户接口', '适用系统框架'); DROP TABLE IF EXISTS `e_cms_content`; CREATE TABLE `e_cms_content` ( `id` int(9) NOT NULL AUTO_INCREMENT, `uid` int(9) NOT NULL DEFAULT '1' COMMENT '发布者id', `fid` int(9) NOT NULL COMMENT '分类id', `title` varchar(999) NOT NULL COMMENT '文章标题', `icon` varchar(999) NOT NULL COMMENT '封面图片', `description` varchar(9999) NOT NULL COMMENT '描述', `content` text NOT NULL COMMENT '文章内容', `view` int(11) NOT NULL DEFAULT '0' COMMENT '浏览量', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; INSERT INTO `e_cms_content` (`id`, `uid`, `fid`, `title`, `icon`, `description`, `content`, `view`) VALUES (1, 1, 3, '这是一条测试线报', '', '', '.版本 2\r\n\r\n\' SELECT * FROM `e_cms_sort`\r\n\' SELECT * FROM `e_cms_content`\r\n\r\nUser-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/69.0.3497.100 Safari/537.36', 0), (2, 1, 3, '仍然重拾决心，埋头造轮，', '', '', '一直以来，layui 秉承无偿开源的初心，虔诚致力于服务各层次前后端 Web 开发者，在商业横飞的当今时代，这一信念从未动摇。即便身单力薄，仍然重拾决心，埋头造轮，以尽可能地填补产品本身的缺口。', 0), (3, 1, 4, '豚鼠框架主页开发进度', '', '', '.2024年2月14日03:02:55\r\n 完成线报/资讯的开', 0); DROP TABLE IF EXISTS `e_cms_sort`; CREATE TABLE `e_cms_sort` ( `id` int(9) NOT NULL AUTO_INCREMENT COMMENT '栏目id', `fid` int(9) NOT NULL COMMENT '父级栏目id', `name` varchar(99) NOT NULL COMMENT '栏目名称', `description` varchar(999) NOT NULL DEFAULT '' COMMENT '描述', `icon` varchar(999) NOT NULL COMMENT '封面图片或图标', `keywords` varchar(999) NOT NULL DEFAULT '关键词' COMMENT '栏目关键词', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='cms 栏目管理'; INSERT INTO `e_cms_sort` (`id`, `fid`, `name`, `description`, `icon`, `keywords`) VALUES (4, 0, '资讯', '网站资讯', '', '关键词'), (3, 0, '线报', '关于京东的线报资讯', '', ''); DROP TABLE IF EXISTS `e_config`; CREATE TABLE `e_config` ( `id` int(9) NOT NULL AUTO_INCREMENT, `fid` int(9) NOT NULL DEFAULT '1' COMMENT '类型id', `key` varchar(99) NOT NULL COMMENT '名称', `value` varchar(9999) NOT NULL COMMENT '值', `describe` varchar(9999) NOT NULL COMMENT '描述', `zid` int(2) NOT NULL DEFAULT '1' COMMENT '1编辑框 2密码框 3选择框 4单选框 5下拉选择框 6多行编辑框 7图片上传 8文件上传 9开关', `zstr` text NOT NULL COMMENT '组件默认值', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='系统 配置信息'; INSERT INTO `e_config` (`id`, `fid`, `key`, `value`, `describe`, `zid`, `zstr`) VALUES (1, 1, '网站名称', '海豚框架V1', '网站名称描述', 1, ''), (2, 1, '搜索关键词', 'c 2024 ', '站点搜索关键词', 1, ''), (3, 1, '站点描述', '我是描述', '网站的站点描述', 6, ''), (4, 1, '备案号', 'c 2024 ', '网站域名备案号码', 1, ''), (5, 1, '版本号', '1.1.0', '网站系统版本号', 1, ''), (6, 1, '网站LOGO', '/upload/logo.png', '显示在网站首页的logo图片', 7, ''), (7, 1, '网站开关', '1', '是否启用网站', 9, ''), (8, 1, '客服电话', '00000000', '网站客服电话', 1, ''), (9, 2, '后台登录权限', '1,2', '1管理员，2普通管理员', 1, ''); DROP TABLE IF EXISTS `e_config_class`; CREATE TABLE `e_config_class` ( `id` int(9) NOT NULL AUTO_INCREMENT, `titel` varchar(99) NOT NULL COMMENT '分类名称', `icon` varchar(99) NOT NULL COMMENT '图标', `center` text NOT NULL COMMENT '描述', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='系统 配置分类'; INSERT INTO `e_config_class` (`id`, `titel`, `icon`, `center`) VALUES (1, '系统设置', '', ''), (2, '登录设置', '', ''); DROP TABLE IF EXISTS `e_log`; CREATE TABLE `e_log` ( `id` int(9) NOT NULL AUTO_INCREMENT, `fid` int(9) NOT NULL COMMENT '类型id', `uid` int(9) NOT NULL COMMENT '用户id', `code` int(9) NOT NULL COMMENT '0普通 1成功 -1失败 -2警告', `time` char(13) NOT NULL COMMENT '时间', `data` mediumtext NOT NULL COMMENT '日志内容', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; INSERT INTO `e_log` (`id`, `fid`, `uid`, `code`, `time`, `data`) VALUES (31, 3, 1, 1, '1708863572003', '???????'), (30, 3, 1, 1, '1708863518354', '???????'), (29, 3, 1, 1, '1708863513973', '???????'); DROP TABLE IF EXISTS `e_log_type`; CREATE TABLE `e_log_type` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` char(20) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; INSERT INTO `e_log_type` (`id`, `name`) VALUES (1, '系统信息'), (2, '前台信息'), (3, '用户信息'); DROP TABLE IF EXISTS `e_user`; CREATE TABLE `e_user` ( `id` int(9) NOT NULL AUTO_INCREMENT, `fid` int(5) NOT NULL DEFAULT '0' COMMENT '用户类型 0普通用户 1管理员 2普通管理员 3vip', `off` int(1) NOT NULL DEFAULT '1' COMMENT '1正常 0未审核 -1封禁 ', `username` varchar(16) NOT NULL COMMENT