/www/wwwroot/cloud.lincq.cn/工作项目/后端/fjrsadmin_com_20220418_173611.sql-- MySQL dump 10.13 Distrib 5.5.62, for Win64 (AMD64) -- -- Host: localhost Database: fjrsadmin_com -- ------------------------------------------------------ -- Server version 5.5.62-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `fjrs_ad` -- DROP TABLE IF EXISTS `fjrs_ad`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `fjrs_ad` ( `id` int(11) NOT NULL AUTO_INCREMENT, `img` varchar(255) DEFAULT NULL, `link` text, `title` varchar(100) DEFAULT NULL, `height` varchar(5) DEFAULT NULL, `width` varchar(5) DEFAULT NULL, `content` text, `adtype` varchar(255) DEFAULT NULL, `addtime` int(11) NOT NULL DEFAULT '0', `sys` tinyint(1) NOT NULL DEFAULT '0', `edate` int(10) NOT NULL DEFAULT '0', `type` tinyint(1) NOT NULL DEFAULT '1', `tag` varchar(200) DEFAULT NULL, `bgcolor` varchar(200) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=127 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `fjrs_ad` -- LOCK TABLES `fjrs_ad` WRITE; /*!40000 ALTER TABLE `fjrs_ad` DISABLE KEYS */; INSERT INTO `fjrs_ad` VALUES (126,'http://www.ssh1688.com/upLoad/ad/month_1507/201507171445206233.jpg','','','124','220','','产品列表页左侧广告',1507713822,0,1570723200,2,'',''),(125,'http://www.ssh1688.com/upLoad/image/20160303/14569860798084364.jpg','','','160','960','','幻灯片下面广告',1507639381,0,1539100800,2,'',''); /*!40000 ALTER TABLE `fjrs_ad` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `fjrs_adminlog` -- DROP TABLE IF EXISTS `fjrs_adminlog`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `fjrs_adminlog` ( `id` int(11) NOT NULL AUTO_INCREMENT, `admin_name` varchar(50) NOT NULL, `ip` varchar(15) NOT NULL, `mod` varchar(50) NOT NULL, `do` varchar(20) NOT NULL, `addtime` int(10) NOT NULL, PRIMARY KEY (`id`) USING BTREE, KEY `admin_name` (`admin_name`) USING BTREE, KEY `mod` (`mod`) USING BTREE, KEY `addtime` (`addtime`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=7087 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `fjrs_adminlog` -- LOCK TABLES `fjrs_adminlog` WRITE; /*!40000 ALTER TABLE `fjrs_adminlog` DISABLE KEYS */; INSERT INTO `fjrs_adminlog` VALUES (6947,'wdlyhs','110.88.97.145','student','insert',1644818226),(6946,'wdlyhs','110.88.97.145','user','update',1644805604),(6945,'wdlyhs','117.29.132.35','student','insert',1644760501),(6944,'admin','125.77.66.233','user','delete',1644583643),(6943,'admin','125.77.66.233','user','update',1644583244),(7084,'wdlyhs','127.0.0.1','webset','set',1649755635),(7085,'wdlyhs','127.0.0.1','webset','set',1649756695),(7086,'wdlyhs','127.0.0.1','webset','set',1649770328),(6979,'admin','127.0.0.1','menu','insert',1645352463),(6978,'admin','127.0.0.1','jl','update',1645352383),(6977,'admin','127.0.0.1','jl','update',1645352373),(6976,'admin','127.0.0.1','menu','update',1645351877),(6975,'admin','127.0.0.1','menu','update',1645351870),(6974,'admin','127.0.0.1','menu','update',1645351859),(6973,'admin','127.0.0.1','zp','update',1645345429),(6972,'admin','127.0.0.1','zp','update',1645345423),(6971,'admin','127.0.0.1','menu','update',1645271073),(6970,'admin','127.0.0.1','menu','update',1645271065),(6969,'admin','127.0.0.1','menu','update',1645271053),(6968,'admin','127.0.0.1','menu','insert',1645270644),(6967,'admin','127.0.0.1','menu','insert',1645270634),(6966,'admin','127.0.0.1','menu','insert',1645270622),(6965,'admin','127.0.0.1','webset','set',1645269650),(6964,'admin','127.0.0.1','zw','update',1645269384),(6963,'admin','127.0.0.1','webset','set',1645268755),(6962,'admin','127.0.0.1','webset','set',1645268737),(6961,'admin','127.0.0.1','zw','update',1645266928),(6960,'admin','127.0.0.1','zw','update',1645266660),(6959,'admin','127.0.0.1','zw','update',1645266627),(6958,'admin','127.0.0.1','zw','update',1645101053),(6957,'admin','127.0.0.1','zw','update',1645100999),(6956,'admin','127.0.0.1','zw','update',1645100968),(6955,'admin','127.0.0.1','zw','update',1645100940),(6993,'admin','127.0.0.1','student','update',1645796475),(6992,'admin','127.0.0.1','student','update',1645796196),(6991,'admin','127.0.0.1','student','update',1645796136),(6990,'admin','127.0.0.1','student','update',1645796041),(6989,'admin','127.0.0.1','student','update',1645796007),(6988,'admin','127.0.0.1','student','update',1645795927),(6987,'admin','127.0.0.1','student','update',1645795880),(6986,'admin','127.0.0.1','student','update',1645795837),(6985,'admin','127.0.0.1','student','update',1645795831),(6984,'admin','127.0.0.1','student','update',1645795830),(6983,'admin','127.0.0.1','menu','update',1645354332),(6982,'admin','127.0.0.1','menu','insert',1645354315),(7066,'admin','127.0.0.1','article','update',1647077156),(7065,'admin','127.0.0.1','article','update',1647077126),(7064,'admin','127.0.0.1','role','delete',1647060715),(7063,'admin','127.0.0.1','type','insert',1647060671),(7062,'admin','127.0.0.1','type','update',1647060657),(7061,'admin','127.0.0.1','menu','delete',1647060621),(7060,'admin','127.0.0.1','menu','delete',1647060614),(7059,'admin','127.0.0.1','menu','delete',1647060603),(7058,'admin','127.0.0.1','menu','delete',1647060595),(7057,'admin','127.0.0.1','menu','update',1647060568),(7056,'admin','127.0.0.1','menu','update',1647060558),(7055,'admin','127.0.0.1','menu','delete',1647060532),(7054,'admin','127.0.0.1','menu','delete',1647060514),(7053,'admin','127.0.0.1','menu','delete',1647060506),(7052,'admin','127.0.0.1','menu','delete',1647060499),(7051,'admin','127.0.0.1','menu','delete',1647060482),(7050,'admin','127.0.0.1','menu','delete',1647060474),(7049,'admin','127.0.0.1','menu','delete',1647060461),(7048,'admin','127.0.0.1','menu','delete',1647060455),(7047,'admin','127.0.0.1','menu','update',1647060010),(7046,'admin','127.0.0.1','menu','update',1647060004),(7045,'admin','127.0.0.1','menu','update',1647059999),(7044,'admin','127.0.0.1','menu','delete',1647059923),(7043,'admin','127.0.0.1','menu','delete',1647059909),(7042,'admin','127.0.0.1','menu','delete',1647059898),(7041,'admin','127.0.0.1','menu','delete',1647059889),(7040,'admin','127.0.0.1','menu','delete',1647059860),(7039,'admin','127.0.0.1','menu','delete',1647059850),(7038,'admin','127.0.0.1','menu','delete',1647059797),(7037,'admin','127.0.0.1','menu','delete',1647059792),(7036,'admin','127.0.0.1','menu','delete',1647059778),(7035,'admin','127.0.0.1','menu','delete',1647059764),(7034,'admin','127.0.0.1','menu','delete',1647059757),(7033,'admin','127.0.0.1','menu','delete',1647059749),(7032,'admin','127.0.0.1','menu','delete',1647059741),(7031,'admin','127.0.0.1','menu','delete',1647059729),(7030,'admin','127.0.0.1','menu','delete',1647059700),(7029,'admin','127.0.0.1','menu','delete',1647059692),(7028,'admin','127.0.0.1','menu','delete',1647059684),(7027,'admin','127.0.0.1','menu','delete',1647059671),(7026,'admin','127.0.0.1','menu','delete',1647059662),(7025,'admin','127.0.0.1','menu','delete',1647059653),(7024,'admin','127.0.0.1','menu','delete',1647059643),(7023,'admin','127.0.0.1','menu','delete',1647059635),(7022,'admin','127.0.0.1','menu','delete',1647059624),(7021,'admin','127.0.0.1','menu','delete',1647059615),(7020,'admin','127.0.0.1','menu','delete',1647059605),(7019,'admin','127.0.0.1','menu','delete',1647059570),(7018,'admin','127.0.0.1','menu','delete',1647059563),(7017,'admin','127.0.0.1','menu','delete',1647059550),(7016,'admin','127.0.0.1','menu','delete',1647059538),(7015,'admin','127.0.0.1','menu','delete',1647059529),(7014,'admin','127.0.0.1','menu','delete',1647059514),(7013,'admin','127.0.0.1','menu','delete',1647059500),(7012,'admin','127.0.0.1','menu','delete',1647059490),(7011,'admin','127.0.0.1','menu','delete',1647059481),(7010,'admin','127.0.0.1','menu','delete',1647059471),(7009,'admin','127.0.0.1','menu','delete',1647059463),(7008,'admin','127.0.0.1','menu','delete',1647059453),(7007,'admin','127.0.0.1','menu','delete',1647059442),(7006,'admin','127.0.0.1','menu','delete',1647059425),(7005,'admin','127.0.0.1','menu','delete',1647059397),(7004,'admin','127.0.0.1','menu','delete',1647059383),(7003,'admin','127.0.0.1','menu','delete',1647059359),(7002,'admin','127.0.0.1','menu','delete',1647059328),(7001,'admin','127.0.0.1','menu','delete',1647059324),(7000,'admin','127.0.0.1','menu','delete',1647059319),(6999,'admin','127.0.0.1','menu','delete',1647059316),(6998,'admin','127.0.0.1','menu','delete',1647059313),(7083,'admin','127.0.0.1','role','update',1649745791),(7082,'admin','127.0.0.1','diacrisis','update',1649736155),(7081,'admin','127.0.0.1','menu','update',1649734557),(7080,'admin','127.0.0.1','menu','insert',1649686061),(7079,'admin','127.0.0.1','diacrisis','update',1649685933),(7078,'admin','127.0.0.1','diacrisis','update',1649685930),(7077,'admin','127.0.0.1','webset','set',1649667624),(7076,'admin','127.0.0.1','webset','set',1649667594),(7075,'admin','127.0.0.1','webset','set',1649667489),(6948,'admin','127.0.0.1','problems','update',1644925597),(6949,'admin','127.0.0.1','problems','update',1644925609),(6950,'admin','127.0.0.1','menu','insert',1645098354),(6951,'admin','127.0.0.1','menu','insert',1645098367),(6952,'admin','127.0.0.1','menu','insert',1645098380),(6953,'admin','127.0.0.1','menu','insert',1645098390),(6954,'admin','127.0.0.1','zw','insert',1645098548),(6980,'admin','127.0.0.1','menu','insert',1645352485),(6981,'admin','127.0.0.1','zw','update',1645352662),(6994,'admin','127.0.0.1','webset','set',1647058382),(6995,'admin','127.0.0.1','webset','set',1647059290),(6996,'admin','127.0.0.1','webset','set',1647059299),(6997,'admin','127.0.0.1','menu','delete',1647059310),(7067,'admin','127.0.0.1','menu','insert',1649657691),(7068,'admin','127.0.0.1','menu','insert',1649657783),(7069,'admin','127.0.0.1','menu','insert',1649657795),(7070,'admin','127.0.0.1','menu','update',1649657802),(7071,'admin','127.0.0.1','menu','insert',1649657817),(7072,'admin','127.0.0.1','menu','insert',1649657828),(7073,'admin','127.0.0.1','menu','insert',1649657849),(7074,'admin','127.0.0.1','role','update',1649657862); /*!40000 ALTER TABLE `fjrs_adminlog` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `fjrs_article` -- DROP TABLE IF EXISTS `fjrs_article`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `fjrs_article` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(200) DEFAULT NULL COMMENT '[标题]', `cid` int(11) DEFAULT NULL COMMENT '[角色]', `title` int(2) DEFAULT '1', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `adminname` (`adminname`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `fjrs_duoduo2020` -- LOCK TABLES `fjrs_duoduo2020` WRITE; /*!40000 ALTER TABLE `fjrs_duoduo2020` DISABLE KEYS */; INSERT INTO `fjrs_duoduo2020` VALUES (1,'admin','22a8e7276df9acbd6ec0cd4bbe6b4e37',1647056104,1478942156,'127.0.0.1',151,1649651344,'127.0.0.1',1,1),(2,'wdlyhs','22a8e7276df9acbd6ec0cd4bbe6b4e37',1644891778,1494468576,'121.204.120.12',102,1649745804,'127.0.0.1',12,1),(3,'wdlyhss','ad1819a08c335ba4eecdb75a539515df',0,1496282378,NULL,0,0,NULL,1,1); /*!40000 ALTER TABLE `fjrs_duoduo2020` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `fjrs_link` -- DROP TABLE IF EXISTS `fjrs_link`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `fjrs_link` ( `id` int(11) NOT NULL AUTO_INCREMENT, `url` varchar(255) DEFAULT NULL, `title` varchar(255) DEFAULT NULL, `addtime` int(10) NOT NULL DEFAULT '0', `type` int(1) NOT NULL DEFAULT '0', `img` varchar(255) DEFAULT NULL, `sort` int(11) DEFAULT '0', `status` int(2) DEFAULT '1', PRIMARY KEY (`id`) USING BTREE, KEY `type` (`type`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `fjrs_link` -- LOCK TABLES `fjrs_link` WRITE; /*!40000 ALTER TABLE `fjrs_link` DISABLE KEYS */; INSERT INTO `fjrs_link` VALUES (4,'/','新三板资讯',1492845185,0,'',0,1),(12,'','我要省',1492845440,0,'upload/2017/0422/15171916773.jpg',0,1); /*!40000 ALTER TABLE `fjrs_link` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `fjrs_log` -- DROP TABLE IF EXISTS `fjrs_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `fjrs_log` ( `id` int(10) NOT NULL AUTO_INCREMENT, `addtime` int(10) DEFAULT NULL, `items` text, `openid` varchar(50) DEFAULT NULL, `did` int(10) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `fjrs_log` -- LOCK TABLES `fjrs_log` WRITE; /*!40000 ALTER TABLE `fjrs_log` DISABLE KEYS */; INSERT INTO `fjrs_log` VALUES (5,1649755611,'a:6:{i:0;a:4:{s:3:\"num\";i:1;s:6:\"notice\";s:326:\"尊敬的企业负责人，您好呀！欢迎进入泉州高企条件诊断系统，我是高企小行家“泉科君”，很高兴为您服务，初次见面，请多关照哈。“泉科君”会努力为您分析条件并为您制作评分表哦!
请确认贵单位于申报期之前满365个日历天再进行填写。\";s:7:\"notice1\";s:54:\"首先，让泉科君认识一下您与您的单位吧\";s:2:\"qs\";a:8:{i:0;a:6:{s:4:\"desc\";s:45:\"请问尊敬的负责人您的尊姓大名是\";s:4:\"type\";s:5:\"input\";s:5:\"field\";s:8:\"username\";s:3:\"num\";i:1;s:3:\"msg\";s:18:\"名字不能为空\";s:5:\"value\";s:9:\"黄小明\";}i:1;a:6:{s:4:\"desc\";s:90:\"麻烦您提供一下您的联系方式，以便咱们主管单位后期消息推送哦：\";s:4:\"type\";s:6:\"number\";s:5:\"field\";s:6:\"mobile\";s:3:\"num\";i:2;s:3:\"msg\";s:24:\"联系方式不能为空\";s:5:\"value\";s:11:\"18558754398\";}i:2;a:6:{s:4:\"desc\";s:90:\"您单位的名称是(一个微信号绑定一个企业,请填写正确的企业名称)：\";s:4:\"type\";s:5:\"input\";s:5:\"field\";s:7:\"company\";s:3:\"num\";i:3;s:3:\"msg\";s:24:\"单位名称不能为空\";s:5:\"value\";s:18:\"福州顺升科技\";}i:3;a:7:{s:4:\"desc\";s:30:\"您单位的注册地址为：\";s:4:\"type\";s:4:\"area\";s:9:\"area_data\";a:13:{i:1;s:9:\"泉港区\";i:2;s:9:\"洛江区\";i:3;s:9:\"丰泽区\";i:4;s:9:\"鲤城区\";i:5;s:21:\"经济技术开发区\";i:6;s:15:\"台商投资区\";i:7;s:9:\"惠安县\";i:8;s:9:\"安溪县\";i:9;s:9:\"德化县\";i:10;s:9:\"永春县\";i:11;s:9:\"石狮市\";i:12;s:9:\"南安市\";i:13;s:9:\"晋江市\";}s:5:\"field\";s:7:\"address\";s:3:\"num\";i:4;s:3:\"msg\";s:24:\"注册地址不能为空\";s:5:\"value\";s:9:\"鲤城区\";}i:4;a:6:{s:4:\"desc\";s:30:\"您单位的成立时间为：\";s:4:\"type\";s:4:\"date\";s:5:\"field\";s:5:\"sdate\";s:3:\"num\";i:5;s:3:\"msg\";s:24:\"成立时间不能为空\";s:5:\"value\";s:10:\"2022-04-11\";}i:5;a:6:{s:4:\"desc\";s:30:\"您单位的主营业务是：\";s:4:\"type\";s:5:\"input\";s:5:\"field\";s:2:\"yw\";s:3:\"num\";i:6;s:3:\"msg\";s:24:\"主营业务不能为空\";s:5:\"value\";s:12:\"网站建设\";}i:6;a:8:{s:4:\"desc\";s:30:\"您单位的行业分属是：\";s:4:\"type\";s:8:\"industry\";s:5:\"field\";s:8:\"industry\";s:3:\"num\";i:7;s:3:\"msg\";s:24:\"行业分属不能为空\";s:4:\"data\";a:2:{i:0;a:20:{i:0;s:42:\"农、林、牧、渔业采矿业制造业\";i:1;s:9:\"采矿业\";i:2;s:9:\"制造业\";i:3;s:57:\"电力、热力、燃气及水生产和供应业建筑业\";i:4;s:9:\"建筑业\";i:5;s:18:\"批发和零售业\";i:6;s:33:\"交通运输、仓储和邮政业\";i:7;s:18:\"住宿和餐饮业\";i:8;s:66:\"信息传输、软件和信息技术服务业金融业房地产业\";i:9;s:9:\"金融业\";i:10;s:15:\"房地产行业\";i:11;s:24:\"租赁和商务服务业\";i:12;s:30:\"科学研究和技术服务业\";i:13;s:39:\"水利、环境和公共设施管理业\";i:14;s:39:\"居民服务、修理和其他服务业\";i:15;s:6:\"教育\";i:16;s:21:\"卫生和社会工作\";i:17;s:27:\"文化、体育和娱乐业\";i:18;s:54:\"公共管理、社会保障和社会组织国际组织\";i:19;s:12:\"国际组织\";}i:1;a:15:{i:0;s:36:\"农副食品加工业食品制造业\";i:1;s:57:\"酒、饮料和精制茶制造业烟草制品业纺织业\";i:2;s:24:\"纺织服装、服饰业\";i:3;s:111:\"皮革毛皮、羽毛及其制品和制鞋业木材加工和木、竹、藤、棕、草制品业家具制造业\";i:4;s:21:\"造纸和纸制品业\";i:5;s:30:\"印刷和记录媒介复制业\";i:6;s:138:\"文教、工美、体育和娱乐用品制造业石油、煤炭及其他燃料加工业化学原料和化学制品制造业医药制造业\";i:7;s:69:\"化学纤维制造业橡胶和塑料制品业非金属矿物制品业\";i:8;s:36:\"黑色金属冶炼和压延加工业\";i:9;s:51:\"有色金属冶炼和压延加工业金属制品业\";i:10;s:57:\"通用设备制造业专用设备制造业汽车制造业\";i:11;s:90:\"铁路、船舶、航空航天和其他运输设备制造业电气机械和器材制造业\";i:12;s:84:\"计算机、通信和其他电子设备制造业仪器仪表制造业其他制造业\";i:13;s:27:\"废弃资源综合利用业\";i:14;s:39:\"金属制品、机械和设备修理业\";}}s:9:\"dataChild\";a:20:{i:0;a:5:{i:0;s:6:\"农业\";i:1;s:6:\"林业\";i:2;s:6:\"畜牧\";i:3;s:9:\"业渔业\";i:4;s:45:\"农、林、牧、渔专业及辅助性活动\";}i:1;a:7:{i:0;s:21:\"非金属矿采选业\";i:1;s:30:\"开采专业及辅助性活动\";i:2;s:15:\"其他采矿业\";i:3;s:24:\"煤炭开采和洗选业\";i:4;s:27:\"石油和天然气开采业\";i:5;s:24:\"黑色金属矿采选业\";i:6;s:24:\"有色金属矿采选业\";}i:2;a:15:{i:0;s:36:\"农副食品加工业食品制造业\";i:1;s:57:\"酒、饮料和精制茶制造业烟草制品业纺织业\";i:2;s:24:\"纺织服装、服饰业\";i:3;s:111:\"皮革毛皮、羽毛及其制品和制鞋业木材加工和木、竹、藤、棕、草制品业家具制造业\";i:4;s:21:\"造纸和纸制品业\";i:5;s:30:\"印刷和记录媒介复制业\";i:6;s:138:\"文教、工美、体育和娱乐用品制造业石油、煤炭及其他燃料加工业化学原料和化学制品制造业医药制造业\";i:7;s:69:\"化学纤维制造业橡胶和塑料制品业非金属矿物制品业\";i:8;s:36:\"黑色金属冶炼和压延加工业\";i:9;s:51:\"有色金属冶炼和压延加工业金属制品业\";i:10;s:57:\"通用设备制造业专用设备制造业汽车制造业\";i:11;s:90:\"铁路、船舶、航空航天和其他运输设备制造业电气机械和器材制造业\";i:12;s:84:\"计算机、通信和其他电子设备制造业仪器仪表制造业其他制造业\";i:13;s:27:\"废弃资源综合利用业\";i:14;s:39:\"金属制品、机械和设备修理业\";}i:3;a:3:{i:0;s:33:\"电力、热力生产和供应业\";i:1;s:24:\"燃气生产和供应业\";i:2;s:24:\"水的生产和供应业\";}i:4;a:3:{i:0;s:15:\"房屋建筑业\";i:1;s:36:\"土木工程建筑业建筑安装业\";i:2;s:39:\"建筑装饰、装修和其他建筑业\";}i:5;a:2:{i:0;s:9:\"批发业\";i:1;s:9:\"零售业\";}i:6;a:7:{i:0;s:15:\"铁路运输业\";i:1;s:15:\"道路运输业\";i:2;s:15:\"水上运输业\";i:3;s:15:\"航空运输业\";i:4;s:15:\"管道运输业\";i:5;s:30:\"多式联运和运输代理业\";i:6;s:33:\"装卸搬运和仓储业邮政业\";}i:7;a:2:{i:0;s:9:\"住宿业\";i:1;s:9:\"餐饮业\";}i:8;a:3:{i:0;s:42:\"电信、广播电视和卫星传输服务\";i:1;s:24:\"互联网和相关服务\";i:2;s:30:\"软件和信息技术服务业\";}i:9;a:4:{i:0;s:18:\"货币金融服务\";i:1;s:18:\"资本市场服务\";i:2;s:9:\"保险业\";i:3;s:15:\"其他金融业\";}i:10;a:1:{i:0;s:15:\"房地产行业\";}i:11;a:2:{i:0;s:9:\"租赁业\";i:1;s:15:\"商务服务业\";}i:12;a:3:{i:0;s:21:\"研究和试验发展\";i:1;s:21:\"专业技术服务业\";i:2;s:30:\"科技推广和应用服务业\";}i:13;a:4:{i:0;s:15:\"水利管理业\";i:1;s:30:\"生态保护和环境治理业\";i:2;s:21:\"公共设施管理业\";i:3;s:15:\"土地管理业\";}i:14;a:3:{i:0;s:15:\"居民服务业\";i:1;s:48:\"机动车、电子产品和日用产品修理业\";i:2;s:15:\"其他服务业\";}i:15;a:1:{i:0;s:6:\"教育\";}i:16;a:2:{i:0;s:6:\"卫生\";i:1;s:12:\"社会工作\";}i:17;a:5:{i:0;s:18:\"新闻和出版业\";i:1;s:42:\"广播、电视、电影和录音制作业\";i:2;s:15:\"文化艺术业\";i:3;s:6:\"体育\";i:4;s:9:\"娱乐业\";}i:18;a:6:{i:0;s:21:\"中国共产党机关\";i:1;s:12:\"国家机构\";i:2;s:27:\"人民政协、民主党派\";i:3;s:12:\"社会保障\";i:4;s:48:\"群众团体、社会团体和其他成员组织\";i:5;s:39:\"基层群众自治组织及其他组织\";}i:19;a:1:{i:0;s:12:\"国际组织\";}}s:5:\"value\";s:36:\"制造业 - 纺织服装、服饰业\";}i:7;a:6:{s:4:\"desc\";s:30:\"您预计申报高企年度：\";s:4:\"type\";s:4:\"year\";s:5:\"field\";s:7:\"sb_year\";s:3:\"num\";i:8;s:3:\"msg\";s:24:\"申报年份不能为空\";s:5:\"value\";s:4:\"2022\";}}}i:1;a:4:{s:3:\"num\";i:2;s:6:\"notice\";s:435:\"很高兴认识您哦，\"泉科君\"和您一定会成为很好的朋友的,那咱们现在要正式开始条件分析咯，泉科君迫不及待想了解一下贵单位的具体情况呢,首先让泉科君来了解一下贵单位的人员情况吧!
企业当年职工总数、科技人员数均按照全年月平均数计算。
月平均数＝（月初数＋月末数）÷2
全年月平均数＝全年各月平均数之和÷12\";s:7:\"notice1\";s:0:\"\";s:2:\"qs\";a:4:{i:0;a:7:{s:4:\"desc\";s:63:\"请问贵单位的近一年的总人员年平均数有多少呢\";s:4:\"type\";s:6:\"number\";s:5:\"field\";s:4:\"aren\";s:6:\"notice\";s:167:\"“泉科君”提醒一下您：总人员年平均数的算法为近一年每个月的人员数之和除以12，如果还没能完全计算，可以填个预估数哈\";s:3:\"num\";i:7;s:3:\"msg\";s:43:\"近一年的总人员年平均数须大于0\";s:5:\"value\";s:2:\"22\";}i:1;a:6:{s:4:\"desc\";s:84:\"请问贵单位在近一年缴纳社保满足183天以上的人员有多少人呢？\";s:4:\"type\";s:6:\"number\";s:5:\"field\";s:7:\"aren183\";s:3:\"num\";i:8;s:3:\"msg\";s:51:\"缴纳社保满足183天以上的人员不能为空\";s:5:\"value\";s:1:\"2\";}i:2;a:6:{s:4:\"desc\";s:108:\"请问贵单位在近一年申报个税（包含个税零申报）满183天以上的人员有多少人呢？\";s:4:\"type\";s:6:\"number\";s:5:\"field\";s:4:\"shui\";s:3:\"num\";i:9;s:3:\"msg\";s:72:\"缴近一年申报个税（包含个税零申报）的人数不能为空\";s:5:\"value\";s:2:\"43\";}i:3;a:6:{s:4:\"desc\";s:138:\"请问缴纳社保与申报个税满183天以上的人员的学历专业与贵司的产品以及技术相关联的人数有多少人呢？\";s:4:\"type\";s:6:\"number\";s:5:\"field\";s:5:\"jsren\";s:3:\"num\";i:10;s:3:\"msg\";s:36:\"技术相关联的人数不能为空\";s:5:\"value\";s:2:\"33\";}}}i:2;a:4:{s:3:\"num\";i:3;s:6:\"notice\";s:693:\"“泉科君”大体心里有数了，接下来让“泉科君”继续了解一下贵单位的知识产权情况吧,“高企”政策当中知识产权分为一类知识产权与二类知识产权，一类知识产权包含：发明专利（含国防专利）、植物新品种、国家级农作物品种、国家新药、国家一级中药保护品种、集成电路布图设计专有权等，二类知识产权包含：实用新型专利，软件著作权，外观专利等。提示一下:一类知识产权可以重复使用来申报高企，二类知识产权不可重复使用。
下面麻烦您告知一下“泉科君”贵单位目前可用于申报高企的知识产权情况哈\";s:7:\"notice1\";s:0:\"\";s:2:\"qs\";a:3:{i:0;a:6:{s:4:\"desc\";s:72:\"请问贵单位知识产权是自主申请的还是转让变更过来的\";s:4:\"type\";s:8:\"checkbox\";s:5:\"field\";s:7:\"field11\";s:7:\"answers\";a:4:{i:0;s:12:\"自主申请\";i:1;s:12:\"转让变更\";i:2;s:6:\"都有\";i:3;s:3:\"无\";}s:3:\"num\";i:11;s:9:\"user_code\";i:0;}i:1;a:5:{s:4:\"desc\";s:100:\"请问贵司有几个与产品或产品生产工艺密切关联的发明专利等一类知识产权?\";s:4:\"type\";s:6:\"number\";s:5:\"field\";s:7:\"field12\";s:3:\"msg\";s:48:\"请输入发明专利等一类知识产权数量\";s:5:\"value\";s:1:\"2\";}i:2;a:5:{s:4:\"desc\";s:153:\"请问贵单位拥有与产品或产品生产工艺密切关联的发明专利、实用新型，软件著作权等知识产权的数量总和为多少？\";s:4:\"type\";s:6:\"number\";s:5:\"field\";s:7:\"field14\";s:3:\"msg\";s:33:\"请输入二类知识产权数量\";s:5:\"value\";s:2:\"33\";}}}i:3;a:5:{s:3:\"num\";i:4;s:6:\"notice\";s:199:\"贵单位具备很优秀的研发能力，科技创新绝对是第一生产力哦，“泉科君”要给您点100个赞啦，那接下来“泉科君”需要了解一下贵单位的财务情况哦!\";s:8:\"notice_1\";s:240:\"虽然咱们暂时专利比较薄弱，但是，咱们还有时间补足条件哦，不要灰心哈，踩在巨人前辈的肩膀上创新，指不定还能青出于蓝呢。那让“泉科君”继续了解一下贵单位的财务情况吧\";s:7:\"notice1\";s:0:\"\";s:2:\"qs\";a:5:{i:0;a:5:{s:4:\"desc\";s:57:\"贵单位近三年的总收入分别为（万元单位）\";s:4:\"type\";s:6:\"inputs\";s:5:\"field\";s:7:\"filed16\";s:6:\"inputs\";a:3:{i:0;a:3:{s:5:\"title\";s:22:\"2019年销售收入：\";s:3:\"msg\";s:31:\"2019年销售收入不能为空\";s:5:\"value\";s:3:\"333\";}i:1;a:3:{s:5:\"title\";s:22:\"2020年销售收入：\";s:3:\"msg\";s:31:\"2020年销售收入不能为空\";s:5:\"value\";s:3:\"322\";}i:2;a:3:{s:5:\"title\";s:22:\"2021年销售收入：\";s:3:\"msg\";s:31:\"2020年销售收入不能为空\";s:5:\"value\";s:2:\"33\";}}s:3:\"num\";i:16;}i:1;a:7:{s:4:\"desc\";s:106:\"2021与专利软件著作权等知识产权相关的产品或服务的销售收入为（万元单位）：\";s:2:\"zl\";i:1;s:4:\"type\";s:6:\"number\";s:5:\"field\";s:7:\"filed17\";s:3:\"num\";i:17;s:3:\"msg\";s:28:\"2021销售收入不能为空\";s:5:\"value\";s:1:\"3\";}i:2;a:5:{s:4:\"desc\";s:57:\"贵单位近三年的净资产分别为（万元单位）\";s:4:\"type\";s:6:\"inputs\";s:5:\"field\";s:7:\"filed18\";s:6:\"inputs\";a:3:{i:0;a:3:{s:5:\"title\";s:19:\"2019年净资产：\";s:3:\"msg\";s:28:\"2019年净资产不能为空\";s:5:\"value\";s:1:\"2\";}i:1;a:3:{s:5:\"title\";s:19:\"2020年净资产：\";s:3:\"msg\";s:28:\"2020年净资产不能为空\";s:5:\"value\";s:1:\"3\";}i:2;a:3:{s:5:\"title\";s:19:\"2021年净资产：\";s:3:\"msg\";s:28:\"2021年净资产不能为空\";s:5:\"value\";s:1:\"3\";}}s:3:\"num\";i:18;}i:3;a:6:{s:4:\"desc\";s:54:\"贵单位的税收征收方式是否为查账征收？\";s:4:\"type\";s:8:\"checkbox\";s:5:\"field\";s:7:\"filed19\";s:7:\"answers\";a:2:{i:0;s:3:\"是\";i:1;s:3:\"否\";}s:3:\"num\";i:19;s:9:\"user_code\";i:0;}i:4;a:6:{s:4:\"desc\";s:54:\"贵单位是否有设立研发费用独立账务科目\";s:4:\"type\";s:8:\"checkbox\";s:5:\"field\";s:7:\"filed20\";s:3:\"num\";i:20;s:7:\"answers\";a:2:{i:0;s:3:\"是\";i:1;s:3:\"否\";}s:9:\"user_code\";i:0;}}}i:4;a:3:{s:3:\"num\";i:5;s:6:\"notice\";s:162:\"研发费用的归集是个辛苦活哦，贵单位的财务人员真的好负责呢，能够规范研发费用财务管理的财务人员，一定是个好同志\";s:2:\"qs\";a:1:{i:0;a:5:{s:4:\"desc\";s:69:\"“泉科君”需要了解一下贵单位近三年的研发费用，\";s:4:\"type\";s:6:\"inputs\";s:5:\"field\";s:7:\"filed21\";s:6:\"inputs\";a:3:{i:0;a:3:{s:5:\"title\";s:19:\"2019年研发费用\";s:3:\"msg\";s:31:\"2019年研发费用不能为空\";s:5:\"value\";s:1:\"3\";}i:1;a:3:{s:5:\"title\";s:19:\"2020年研发费用\";s:3:\"msg\";s:31:\"2020年研发费用不能为空\";s:5:\"value\";s:1:\"2\";}i:2;a:3:{s:5:\"title\";s:19:\"2021年研发费用\";s:3:\"msg\";s:31:\"2021年研发费用不能为空\";s:5:\"value\";s:1:\"3\";}}s:3:\"num\";i:21;}}}i:5;a:3:{s:3:\"num\";i:6;s:6:\"notice\";s:216:\"“泉科君”已经对您的财务情况有了初步的了解啦，泉科君”祝愿咱们单位继续蓬勃发展，继往开来。接下来，“泉科君”还需要了解一下咱们单位其他方面的情况\";s:2:\"qs\";a:4:{i:0;a:6:{s:4:\"desc\";s:57:\"咱们单位是否有独立的研发场所及设备呢？\";s:4:\"type\";s:8:\"checkbox\";s:5:\"field\";s:7:\"filed22\";s:3:\"num\";i:22;s:7:\"answers\";a:2:{i:0;s:3:\"是\";i:1;s:3:\"否\";}s:9:\"user_code\";i:1;}i:1;a:6:{s:4:\"desc\";s:90:\"咱们单位是否有与高校、研究所等科研单位产生过技术开发合作呢？\";s:4:\"type\";s:8:\"checkbox\";s:5:\"field\";s:7:\"filed23\";s:3:\"num\";i:23;s:7:\"answers\";a:2:{i:0;s:3:\"是\";i:1;s:3:\"否\";}s:9:\"user_code\";i:0;}i:2;a:6:{s:4:\"desc\";s:133:\"2021年贵单位是否有发生过重大安全、重大质量事故、严重环境违法行为或者相关失信等违法行为呢？\";s:4:\"type\";s:8:\"checkbox\";s:5:\"field\";s:7:\"filed24\";s:3:\"num\";i:24;s:7:\"answers\";a:2:{i:0;s:3:\"是\";i:1;s:3:\"否\";}s:9:\"user_code\";i:1;}i:3;a:6:{s:4:\"desc\";s:99:\"咱们单位是否参与过国家标准、行业标准、检测方法，技术规范等活动呢？\";s:4:\"type\";s:8:\"checkbox\";s:5:\"field\";s:7:\"filed25\";s:3:\"num\";i:25;s:7:\"answers\";a:2:{i:0;s:3:\"是\";i:1;s:3:\"否\";}s:9:\"user_code\";i:0;}}}}','omksN5mGT3XLl-J7_lOJKOntx_VA',28); /*!40000 ALTER TABLE `fjrs_log` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `fjrs_menu` -- DROP TABLE IF EXISTS `fjrs_menu`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `fjrs_menu` ( `id` int(11) NOT NULL AUTO_INCREMENT, `parent_id` int(11) NOT NULL DEFAULT '0', `node` varchar(20) NOT NULL, `mod` varchar(50) NOT NULL, `act` varchar(15) NOT NULL, `listorder` int(11) NOT NULL DEFAULT '0', `sort` int(5) NOT NULL DEFAULT '0', `title` varchar(20) NOT NULL, `url` varchar(255) DEFAULT NULL, `hide` tinyint(1) NOT NULL DEFAULT '0', `sys` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) USING BTREE, KEY `mod` (`mod`) USING BTREE, KEY `act` (`act`) USING BTREE, KEY `sort` (`sort`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=578 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `fjrs_menu` -- LOCK TABLES `fjrs_menu` WRITE; /*!40000 ALTER TABLE `fjrs_menu` DISABLE KEYS */; INSERT INTO `fjrs_menu` VALUES (1,0,'base','','',11092,0,'网站设置','',0,1),(2,1,'base','webset','center',0,100,'后台中心','',1,1),(3,1,'base','webset','set',0,999999,'基本设置','',0,1),(7,0,'fun','','',10113,0,'功能模块','',1,1),(8,7,'fun','fun','upload',0,0,'图片上传','',1,1),(10,214,'tuiguang','slides','list',0,999999,'幻灯片管理','',0,1),(11,214,'tuiguang','slides','addedi',0,0,'幻灯片添加修改','',1,1),(12,214,'tuiguang','slides','del',0,0,'幻灯片删除','',1,1),(27,214,'tuiguang','link','list',0,999999,'友情链接','',0,1),(29,214,'tuiguang','link','addedi',0,0,'友情链接添加修改','',1,1),(56,0,'user','','',11098,0,'会员管理','',0,1),(57,56,'user','user','list',0,8,'会员列表','',0,1),(59,1,'base','data','list',0,97,'数据库管理','',0,1),(60,56,'user','user','addedi',0,0,'会员修改','',1,1),(64,56,'user','user','del',0,0,'会员删除','',1,1),(70,58,'database','data','backup',0,0,'还原数据库','',1,1),(71,58,'database','data','check',0,0,'数据库检测','',1,1),(76,0,'article','','',11095,0,'文章管理','',0,1),(77,76,'article','type','list',0,999999,'文章分类','',0,1),(78,1,'base','type','addedi',0,0,'类别添加修改','',1,1),(79,76,'article','article','list',0,999999,'文章列表','',0,1),(80,76,'article','article','addedi',0,0,'文章添加修改','',1,1),(94,58,'database','noword','list',0,95,'敏感词管理','',1,1),(95,58,'database','noword','addedi',0,0,'敏感词添加修改','',1,1),(98,1,'base','seo','set',0,87,'加密设置','',1,1),(99,1,'base','seo','list',0,87,'seo管理','',0,1),(100,1,'base','seo','addedi',0,0,'seo添加修改','',1,1),(101,1,'base','seo','del',0,0,'seo删除','',1,1),(102,0,'admin','','',11090,0,'管理员','',0,1),(103,102,'admin','role','list',0,999999,'管理员组','',0,1),(104,102,'admin','role','addedi',0,0,'管理员组添加修改','',1,1),(105,102,'admin','role','del',0,0,'管理员组删除','',1,1),(106,102,'admin','duoduo2020','list',0,999999,'管理员列表','',0,1),(107,102,'admin','duoduo2020','addedi',0,0,'管理员添加修改','',1,1),(108,102,'admin','duoduo2020','del',0,0,'管理员删除','',1,1),(109,102,'admin','menu','list',0,97,'管理菜单','',0,1),(110,102,'admin','menu','addedi',0,0,'菜单添加修改','',1,1),(113,1,'base','adminlog','list',0,91,'系统日志','',0,1),(114,102,'admin','adminlog','del',0,0,'日志删除','',1,1),(118,214,'tuiguang','link','del',0,0,'友情链接删除','',1,1),(121,58,'database','noword','del',0,0,'敏感词删除','',1,1),(134,1,'base','type','del',0,0,'文章栏目删除','',1,1),(135,76,'article','article','del',0,0,'文章删除','',1,1),(137,7,'fun','fun','cache',0,0,'更新全站缓存','',1,1),(150,102,'admin','menu','del',0,0,'删除后台菜单','',1,1),(164,214,'tuiguang','seo','arr',0,0,'自定义网址','',1,1),(176,76,'article','article','removecid',0,0,'文章移动栏目','',1,1),(191,56,'user','user','award',0,0,'金额积分修改','',1,1),(214,0,'tuiguang','','',11097,0,'运营推广','',0,1),(221,1,'base','sitemap','list',0,97,'网站地图','',1,1),(320,102,'admin','menu','s_list',0,0,'后台菜单搜索','',1,1),(408,0,'model','','',10000,0,'模块管理','',0,0),(413,408,'model','model','addedi',0,0,'模块添加','',0,0),(412,408,'model','model','list',0,0,'模块列表','',0,0),(414,408,'model','model','del',0,0,'模块删除','',1,0),(572,0,'diacrisis','','',10000,0,'诊断管理','',0,0),(573,572,'diacrisis','diacrisis','list',0,0,'诊断列表','',0,0),(574,572,'diacrisis','diacrisis','addedi',0,0,'编辑诊断','',1,0),(575,572,'diacrisis','diacrisis','del',0,0,'删除诊断','',1,0),(576,572,'diacrisis','diacrisis','total',0,0,'诊断统计','',0,0),(577,572,'diacrisis','diacrisis','show',0,0,'诊断明细','',1,0); /*!40000 ALTER TABLE `fjrs_menu` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `fjrs_menu_access` -- DROP TABLE IF EXISTS `fjrs_menu_access`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `fjrs_menu_access` ( `id` int(11) NOT NULL AUTO_INCREMENT, `role_id` int(11) NOT NULL, `menu_id` int(11) NOT NULL, PRIMARY KEY (`id`) USING BTREE, KEY `role_id` (`role_id`) USING BTREE, KEY `menu_id` (`menu_id`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=5473 DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `fjrs_menu_access` -- LOCK TABLES `fjrs_menu_access` WRITE; /*!40000 ALTER TABLE `fjrs_menu_access` DISABLE KEYS */; INSERT INTO `fjrs_menu_access` VALUES (5205,1,413),(5204,1,414),(5203,1,412),(5202,1,408),(5174,1,137),(5173,1,8),(5172,1,7),(5171,1,114),(5443,1,107),(5442,1,106),(5441,1,108),(5167,1,109),(5166,1,150),(5165,1,320),(5164,1,110),(5163,1,103),(5162,1,105),(5161,1,104),(5160,1,102),(5444,1,113),(5445,1,59),(5145,1,70),(5144,1,71),(5134,1,121),(5133,1,94),(5132,1,95),(5094,1,99),(5093,1,98),(5092,1,100),(5091,1,101),(5087,1,221),(5069,1,134),(5068,1,78),(5065,1,3),(5063,1,2),(5055,1,1),(5054,1,79),(5053,1,80),(5052,1,135),(5051,1,176),(5050,1,77),(5049,1,76),(1250,2,3),(1249,2,1),(1248,2,176),(1247,2,79),(1246,2,80),(1245,2,135),(1241,2,76),(1239,2,11),(1238,2,10),(1237,2,12),(1236,2,214),(1562,9,306),(1560,9,315),(1559,9,311),(1558,9,328),(1557,9,91),(1556,9,87),(1554,9,92),(1553,9,93),(1552,9,317),(1550,9,345),(1549,9,346),(1548,9,353),(1547,9,318),(1541,9,254),(1540,9,253),(1532,9,322),(1528,9,207),(1527,9,206),(1526,9,302),(1525,9,303),(1523,9,67),(1521,9,159),(1520,9,160),(1519,9,161),(1518,9,53),(1583,10,53),(1584,10,161),(1585,10,160),(1586,10,159),(1588,10,67),(1590,10,303),(1591,10,302),(1592,10,206),(1593,10,207),(1597,10,322),(1605,10,253),(1606,10,254),(1612,10,318),(1613,10,353),(1614,10,346),(1615,10,345),(1617,10,317),(1618,10,93),(1619,10,92),(1621,10,87),(1622,10,91),(1623,10,328),(1624,10,311),(1625,10,315),(1627,10,306),(1662,11,53),(5039,1,27),(5038,1,29),(5037,1,118),(5036,1,164),(5035,1,12),(5034,1,11),(5033,1,10),(5018,1,214),(5472,12,577),(5463,1,577),(5471,12,573),(5000,1,64),(4998,1,60),(4997,1,57),(4995,1,191),(4994,1,56),(5470,12,574),(5469,12,575),(5468,12,576),(5467,12,572),(5446,1,572),(5448,1,573),(5449,1,574),(5450,1,575),(5466,12,3),(5452,1,576),(5465,12,1); /*!40000 ALTER TABLE `fjrs_menu_access` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `fjrs_model` -- DROP TABLE IF EXISTS `fjrs_model`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `fjrs_model` ( `id` int(10) NOT NULL AUTO_INCREMENT, `title` varchar(100) DEFAULT NULL, `act` varchar(50) DEFAULT NULL, `mod` varchar(50) DEFAULT NULL, `sort` int(10) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=gbk ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `fjrs_model` -- LOCK TABLES `fjrs_model` WRITE; /*!40000 ALTER TABLE `fjrs_model` DISABLE KEYS */; INSERT INTO `fjrs_model` VALUES (1,'文章模块','list','article',122),(4,'单页模块','index','about',1333); /*!40000 ALTER TABLE `fjrs_model` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `fjrs_msg` -- DROP TABLE IF EXISTS `fjrs_msg`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `fjrs_msg` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(100) DEFAULT NULL, `content` varchar(255) DEFAULT NULL, `addtime` datetime DEFAULT NULL, `see` int(11) DEFAULT '0', `uid` int(11) NOT NULL DEFAULT '0', `senduser` int(11) NOT NULL DEFAULT '0', `sid` int(11) NOT NULL DEFAULT '0', `admin` varchar(100) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, KEY `uid` (`uid`) USING BTREE, KEY `senduser` (`senduser`) USING BTREE, KEY `admin` (`admin`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `fjrs_msg` -- LOCK TABLES `fjrs_msg` WRITE; /*!40000 ALTER TABLE `fjrs_msg` DISABLE KEYS */; /*!40000 ALTER TABLE `fjrs_msg` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `fjrs_msgset` -- DROP TABLE IF EXISTS `fjrs_msgset`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `fjrs_msgset` ( `id` int(11) NOT NULL AUTO_INCREMENT, `web` text, `email` text, `sms` text, `title` varchar(255) DEFAULT NULL, `addtime` int(10) NOT NULL DEFAULT '0', `web_open` tinyint(1) NOT NULL DEFAULT '0', `email_open` tinyint(1) NOT NULL DEFAULT '0', `sms_open` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `fjrs_msgset` -- LOCK TABLES `fjrs_msgset` WRITE; /*!40000 ALTER TABLE `fjrs_msgset` DISABLE KEYS */; INSERT INTO `fjrs_msgset` VALUES (1,'尊敬的{username}您好:欢迎注册{webnick}，去淘宝网、淘宝商城购物最高返利35%。当当网、卓越网、凡客等上百家网上知名商城购物！{webnick}让你省得多，活得更好，谢谢！','尊敬的{username}您好:欢迎注册{webnick}，去淘宝网、淘宝商城购物最高返利35%。当当网、卓越网、凡客等上百家网上知名商城购物！{webnick}让你省得多，活得更好，谢谢！','尊敬的{username}您好:欢迎注册{webnick}，去淘宝网、淘宝商城、当当网、卓越网、凡客等上百家网上知名商城购物，最高返利35%。','网站注册',1335529021,1,1,0),(2,'您好：您的提现申请已经受理完毕！本次提现{money}已经支付到您提供的{txtool}，查看明细进入“我的账户明细”！','您好：您的提现申请已经受理完毕！本次提现{money}已经支付到您提供的支付宝{txtool}，查看明细进入“我的账户明细”！','您好：您的申请已经受理完毕！本次申请提取{money}已经支付到您提供的{txtool}，查看明细进入“我的账户明细”！','提现成功',1335529021,1,0,1),(3,'您有一笔提现申请失败，提现{money}已返回您的账户。{why}','您有一笔提现申请失败，提现{money}已返回您的账户。{why}','您有一笔申请失败，提取的{money}已返回您的账户。{why}','提现失败',1335529021,1,0,1),(4,'您好：您的兑换申请（{goods_title}）已受理完毕。{code}','您好：您的兑换申请（{goods_title}）已受理完毕。{code}','您好：您的兑换申请（{goods_title}）已受理完毕。{code}','兑换成功',1335529021,1,0,1),(5,'您好：您的兑换申请（{goods_title}）已审核失败。{why}。','您好：您的兑换申请（{goods_title}）已审核失败。{why}。','您好：您的兑换申请（{goods_title}）已审核失败。{why}。','兑换失败',1335529021,1,1,0),(6,'尊敬的会员{name}您好，您{date}的金额（{money}元）和积分（{jifen}点）已核对有效，感谢您对网站的支持！','尊敬的会员{name}您好，您{date}的金额（{money}元）和积分（{jifen}点）已核对有效，感谢您对网站的支持！','尊敬的会员{name}您好，您{date}的金额（{money}元）和积分（{jifen}点）已核对有效，感谢您对网站的支持！','解冻通知',1343147219,0,0,0),(7,'您的淘宝订单{trade_id}发生异常，现给您减去此订单的返利金额，积分和等级。','您的淘宝订单{trade_id}发生异常，现给您减去此订单的返利金额，积分和等级。','您的淘宝订单{trade_id}发生异常，现给您减去此订单的返利金额，积分和等级。','退款通知',1344101761,1,0,0),(8,'','您的网站激活链接{jihuo_url}','','网站激活',1349359385,0,1,0),(9,'站长奖励：{money}。
原因：{why}。','站长奖励：{money}。
原因：{why}。','站长奖励：{money}。原因：{why}。','站长奖励',1355814783,1,0,1),(10,'站长扣除：{money}。
原因：{why}。','站长扣除：{money}。
原因：{why}。','站长扣除：{money}。原因：{why}。','站长扣除',1355814868,1,0,0),(11,'','','亲，您好，您申请的短信校验码为：{yzm}，请在页面填写。如非本人操作，请忽略。','短信验证码',1358495361,0,0,1); /*!40000 ALTER TABLE `fjrs_msgset` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `fjrs_nav` -- DROP TABLE IF EXISTS `fjrs_nav`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `fjrs_nav` ( `id` int(5) NOT NULL AUTO_INCREMENT, `title` varchar(20) NOT NULL, `url` text, `tip` tinyint(1) NOT NULL DEFAULT '0', `sort` int(5) NOT NULL DEFAULT '0', `hide` tinyint(1) NOT NULL DEFAULT '0', `type` tinyint(4) NOT NULL DEFAULT '0', `auto` tinyint(1) NOT NULL DEFAULT '0', `target` tinyint(1) NOT NULL DEFAULT '0', `custom` varchar(255) DEFAULT NULL, `mod` varchar(50) DEFAULT NULL, `act` varchar(50) DEFAULT NULL, `code` varchar(20) DEFAULT NULL, `tag` varchar(10) DEFAULT NULL, `addtime` int(10) NOT NULL DEFAULT '0', `pid` int(11) NOT NULL DEFAULT '0', `alt` varchar(30) DEFAULT NULL, `sys` tinyint(1) NOT NULL DEFAULT '0', `plugin` tinyint(1) NOT NULL DEFAULT '0', `lianjie` int(1) NOT NULL DEFAULT '0', `bankuai_name` varchar(50) DEFAULT NULL, `mod_name` varchar(50) DEFAULT NULL, `diaoyong` int(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `fjrs_nav` -- LOCK TABLES `fjrs_nav` WRITE; /*!40000 ALTER TABLE `fjrs_nav` DISABLE KEYS */; INSERT INTO `fjrs_nav` VALUES (1,'首页','',0,1,0,0,0,0,'','index','index',NULL,'index',1343495490,0,'',1,0,0,NULL,NULL,0),(10,'精选专享','',0,2,0,0,0,0,NULL,'goods','index','','goods',1438176963,0,'',0,0,0,'','goods',1),(14,'比价搜索','',0,0,1,0,0,0,'','mall','goods',NULL,'mall',1343495490,0,'比一比',1,0,0,NULL,NULL,0),(4,'晒单秀','',0,5,0,0,0,0,'','baobei','list','','baobei',1343495490,0,'',1,0,0,'','index',0),(8,'站点文章','',0,0,1,0,0,0,'','article','index',NULL,'article',1343495490,0,'',1,0,0,NULL,NULL,0),(13,'值得买','',0,0,0,0,0,0,NULL,'goods','index','zhidemai','goods',1348990106,10,'',1,0,0,'zhidemai','goods',2),(12,'19.9包邮','',0,0,0,0,0,0,NULL,'goods','index','shijiu','goods',1348990105,10,'',1,0,0,'shijiu','goods',2),(5,'积分商城','',0,6,0,0,0,0,'','huan','list','','huan',1401696979,0,'',1,0,0,'','index',0),(6,'任务赚钱','',0,7,0,1,0,0,'','task','index','','task',1401697176,0,'',1,0,0,'','index',0),(3,'购物返利','',0,4,0,0,0,0,'','mall','index',NULL,'mall',1405411223,0,'',1,0,0,NULL,NULL,0),(11,'9.9包邮','',0,0,0,0,0,0,NULL,'goods','index','jiu','goods',1348990104,10,'',1,0,0,'jiu','goods',2),(2,'淘宝返利','',0,3,0,2,0,0,'','tao','index','','tao',1406167909,0,'',0,0,0,'','index',0); /*!40000 ALTER TABLE `fjrs_nav` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `fjrs_product` -- DROP TABLE IF EXISTS `fjrs_product`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `fjrs_product` ( `id` int(10) NOT NULL AUTO_INCREMENT, `cid` int(10) DEFAULT NULL, `img` varchar(222) DEFAULT NULL, `tj` varchar(100) DEFAULT NULL, `title` varchar(100) DEFAULT NULL, `sort` int(10) DEFAULT '0', `author` varchar(10) DEFAULT NULL, `number` varchar(50) DEFAULT NULL, `type` varchar(100) DEFAULT NULL, `Specifications` varchar(111) DEFAULT NULL, `purpose` varchar(100) DEFAULT NULL, `Place` varchar(100) DEFAULT NULL, `content` text, `Texture` varchar(111) DEFAULT NULL, `index_img` varchar(222) DEFAULT NULL, `price` varchar(110) DEFAULT NULL, `p_img` varchar(255) DEFAULT NULL, `cx` int(2) DEFAULT '1', PRIMARY KEY (`id`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=gbk ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `fjrs_product` -- LOCK TABLES `fjrs_product` WRITE; /*!40000 ALTER TABLE `fjrs_product` DISABLE KEYS */; INSERT INTO `fjrs_product` VALUES (32,NULL,'upload/2017/0816/10462376050.png','1','李远兴柴烧建盏',0,'李远兴','','李远兴柴烧建盏','9cm*6.5cm','品茗/馈赠/收藏/把玩','福建建阳','','纯正铁胎，原矿釉料，草木灰','upload/2017/0817/19110977931.png','','upload/2017/0817/19111470540.png',1),(33,NULL,'upload/2017/0816/10492678263.png','1','刘学财星空建盏',0,'刘学财','','刘学财星空建盏','8.5cm*5.5cm','品茗/馈赠/收藏/把玩','福建建阳','','纯正铁胎，原矿釉料，草木灰','upload/2017/0817/19095746570.png','','upload/2017/0817/19100387181.png',1),(14,NULL,'upload/2017/0815/16070128886.png','1','李光熙握心茶盏',0,'李光熙','','李光熙握心茶盏','8.8cm*5.5cm','品茗/馈赠/收藏/把玩','福建建阳','','纯正铁胎，原矿釉料，草木灰','upload/2017/0817/19244933227.png','','upload/2017/0817/19245526526.png',1),(34,NULL,'upload/2017/0816/11421585409.png','1','危敏杰柴烧兔毫',0,'危敏杰','','危敏杰柴烧兔毫建盏','9cm*5cm','','','','','upload/2017/0817/19072275522.png','','upload/2017/0817/19081889576.png',1),(15,NULL,'upload/2017/0815/15595030519.png','2','黄美金油滴茶盏',89,'黄美金','','黄美金油滴茶盏','11.5cm*4.8cm','品茗/馈赠/收藏/把玩','福建建阳','','纯正铁胎，原矿釉料，草木灰','upload/2017/0817/18575542947.png','','upload/2017/0817/18583442651.png',1),(16,NULL,'upload/2017/0815/15493958700.png','1','李光熙大度茶盏',0,'李光熙','','李光熙大度茶盏','9.3cm*7.3cm','品茗/馈赠/收藏/把玩','福建建阳','','纯正铁胎，原矿釉料，草木灰','upload/2017/0817/19230127943.png','','upload/2017/0817/19230764964.png',1),(17,NULL,'upload/2017/0816/11503987779.png','1','李远兴油滴茶盏',0,'李远兴','','李远兴油滴茶盏','8.5CM*5CM','品茗/馈赠/收藏/把玩','福建建阳','','纯正铁胎，原矿釉料，草木灰','upload/2017/0817/19214855186.png','','upload/2017/0817/19215342796.png',1),(18,NULL,'upload/2017/0815/15190222556.png','2','陈大鹏鹧鸪斑茶盏',95,'陈大鹏','','小束口','7CM*4.5CM','品茗/馈赠/收藏/把玩','福建建阳','','纯正铁胎，原矿釉料，草木灰','upload/2017/0817/18514796819.png','','upload/2017/0817/18530258490.png',1),(19,NULL,'upload/2017/0815/15123330100.png','1','范大量紫金油滴茶盏',0,'范大量','','范大量紫金油滴茶盏','7.6CM*5.2CM','品茗/馈赠/收藏/把玩','福建建阳','','纯正铁胎，原矿釉料，草木灰','upload/2017/0817/19202388972.png','','upload/2017/0817/19202989079.png',1),(20,NULL,'upload/2017/0815/15105669822.png','1','沐仙生夜华茶盏',0,'沐仙生','','沐仙生夜华茶盏','8.5CM*5.5CM','品茗/馈赠/收藏/把玩','福建建阳','','纯正铁胎，原矿釉料，草木灰','upload/2017/0817/19190224309.png','','upload/2017/0817/19190834381.png',1),(21,NULL,'upload/2017/0815/15093576310.png','1','孙建兴回蓝釉茶盏',0,'孙建兴','','孙建兴回蓝釉茶盏','8CM*4.6CM','品茗/馈赠/收藏/把玩','福建建阳','','纯正铁胎，原矿釉料，草木灰','upload/2017/0817/19171863470.png','','upload/2017/0817/19172393111.png',1),(22,NULL,'upload/2017/0815/15083729069.png','1','叶礼忠窑变兔毫茶盏',0,'叶礼忠','','叶礼忠窑变兔毫茶盏','9CM*5CM','品茗/馈赠/收藏/把玩','福建建阳','','纯正铁胎，原矿釉料，草木灰','upload/2017/0817/19154124694.png','','upload/2017/0817/19154672734.png',1),(23,NULL,'upload/2017/0815/15064898718.png','1','蔡炳盛油滴茶盏',0,'蔡炳盛','','蔡炳盛油滴茶盏','9CM*5CM','品茗/馈赠/收藏/把玩','福建建阳','

\r\n
\r\n

','纯正铁胎，原矿釉料，草木灰','upload/2017/0817/19142941580.png','','upload/2017/0817/19142130849.png',1),(24,NULL,'upload/2017/0815/12305427309.png','2','蔡炳盛火凤凰茶盏',0,'蔡炳盛','','蔡炳盛火凤凰茶盏','9CM*5CM','品茗/馈赠/收藏/把玩','福建建阳','','纯正铁胎，原矿釉料，草木灰','upload/2017/0817/19122199846.png','','upload/2017/0817/19122786907.png',1),(25,NULL,'upload/2017/0815/12291667807.png','2','李达油滴鹧鸪斑茶盏',100,'李达','','敛口','9CM*5CM','品茗/馈赠/收藏/把玩','福建建阳','

\r\n
\r\n

\r\n

\r\n \"建盏大师饶飞熊，赖敏惺，敛口彩金油滴\" \r\n

','纯正铁胎，原矿釉料，草木灰','upload/2017/0817/18503389711.png','','upload/2017/0817/18491829176.png',2),(26,NULL,'upload/2017/0815/12255443482.png','2','熊忠贵柴烧茶盏',73,'熊忠贵','','熊忠贵柴烧茶盏','7.5CM*5CM','品茗/馈赠/收藏/把玩','福建建阳','','纯正铁胎，原矿釉料，草木灰','upload/2017/0817/19055118464.png','','upload/2017/0817/19063569532.png',1),(27,NULL,'upload/2017/0815/12233388890.png','2','阙梅娇菊花茶盏',78,'阙梅娇','','阙梅娇菊花茶盏','9CM*5.5CM','品茗/馈赠/收藏/把玩','福建建阳','','纯正铁胎，原矿釉料，草木灰','upload/2017/0817/19042224771.png','','upload/2017/0817/19050457227.png',1),(28,NULL,'upload/2017/0815/12203546947.png','2','孙建兴柿红茶盏',90,'孙建兴','','束口','9.5CM*5CM','品茗/馈赠/收藏/把玩','福建建阳','','纯正铁胎，原矿釉料，草木灰','upload/2017/0817/18570539663.png','','upload/2017/0817/18563132659.png',1),(29,NULL,'upload/2017/0815/12183445991.png','2','卓立旗油滴茶盏',80,'卓立旗','4113','卓立旗油滴茶盏','8.5CM*4.5CM','品茗/馈赠/收藏/把玩','福建建阳','','纯正铁胎，原矿釉料，草木灰','upload/2017/0817/19025719478.png','','upload/2017/0817/19033389115.png',1),(30,NULL,'upload/2017/0815/15150333421.png','2','飞惺紫金油滴茶盏',83,'飞惺','','飞惺紫金油滴茶盏','8.8CM*4.5CM','品茗/馈赠/收藏/把玩','福建建阳','','纯正铁胎，原矿釉料，草木灰','upload/2017/0817/19012910384.png','','upload/2017/0817/19021516877.png',1),(31,NULL,'upload/2017/0815/12102714022.png','2','蔡炳盛油滴茶盏',87,'蔡炳盛','','蔡炳盛油滴茶盏','8CM*4.5CM','品茗/馈赠/收藏/把玩','福建建阳','','纯正铁胎，原矿釉料，草木灰','upload/2017/0817/19000628654.png','1111','upload/2017/0817/19004278043.png',1); /*!40000 ALTER TABLE `fjrs_product` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `fjrs_role` -- DROP TABLE IF EXISTS `fjrs_role`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `fjrs_role` ( `id` int(6) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(50) NOT NULL, `status` tinyint(1) unsigned NOT NULL, `sys` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `fjrs_role` -- LOCK TABLES `fjrs_role` WRITE; /*!40000 ALTER TABLE `fjrs_role` DISABLE KEYS */; INSERT INTO `fjrs_role` VALUES (1,'超级管理员',1,1),(12,'普通管理员',1,0); /*!40000 ALTER TABLE `fjrs_role` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `fjrs_slides` -- DROP TABLE IF EXISTS `fjrs_slides`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `fjrs_slides` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(100) DEFAULT NULL COMMENT '[标题]', `cid` varchar(10) DEFAULT NULL COMMENT '[类别]