代码拉取完成，页面将自动刷新
/*
SQLyog Ultimate v12.08 (32 bit)
MySQL - 5.7.26 : Database - tw
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!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 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`tw` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;
USE `tw`;
/*Table structure for table `department` */
DROP TABLE IF EXISTS `department`;
CREATE TABLE `department` (
`did` int(2) NOT NULL AUTO_INCREMENT,
`dname` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
`first` int(5) DEFAULT NULL,
`second` int(5) DEFAULT NULL,
PRIMARY KEY (`did`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `department` */
insert into `department`(`did`,`dname`,`first`,`second`) values (1,'新媒体部',NULL,NULL),(2,'视频设计部',NULL,NULL),(3,'宣传部',NULL,NULL),(0,'软件传媒',NULL,NULL);
/*Table structure for table `file` */
DROP TABLE IF EXISTS `file`;
CREATE TABLE `file` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`name` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
`url` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`fromid` int(3) DEFAULT NULL,
`type` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
`uptime` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
`pruename` varchar(180) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `file` */
insert into `file`(`id`,`name`,`url`,`fromid`,`type`,`uptime`,`pruename`) values (1,'pconline1555782310344_2.zip','http://benben2022.oss-cn-hangzhou.aliyuncs.com/pconline1555782310344_2.zip',1,'zip',NULL,NULL),(2,'pconline1555782310344_2.zip','http://benben2022.oss-cn-hangzhou.aliyuncs.com/pconline1555782310344_2.zip',1,'zip',NULL,NULL),(3,'pconline1543669203633.zip','http://benben2022.oss-cn-hangzhou.aliyuncs.com/pconline1543669203633.zip',1,'zip',NULL,NULL),(4,' 7-12 1-22-0pconline1543669203633.zip','http://benben2022.oss-cn-hangzhou.aliyuncs.com/%207-12%201-22-0pconline1543669203633.zip',1,'zip',NULL,NULL),(5,'7-12 1-22-28 pconline1543669203633.zip','http://benben2022.oss-cn-hangzhou.aliyuncs.com/7-12%201-22-28%20pconline1543669203633.zip',1,'zip',NULL,NULL),(6,'7-15 18-29-39 0-00000001.bmp','http://benben2022.oss-cn-hangzhou.aliyuncs.com/7-15%2018-29-39%200-00000001.bmp',1,'bmp',NULL,NULL),(7,'7-15 18-29-39 0-00000001.bmp','http://benben2022.oss-cn-hangzhou.aliyuncs.com/7-15%2018-29-39%200-00000001.bmp',1,'bmp',NULL,NULL),(8,'7-15 18-31-2 0-00000001.bmp','http://benben2022.oss-cn-hangzhou.aliyuncs.com/7-15%2018-31-2%200-00000001.bmp',1,'bmp',NULL,NULL),(9,'7-15 18-40-1 0-00000001.bmp','http://benben2022.oss-cn-hangzhou.aliyuncs.com/7-15%2018-40-1%200-00000001.bmp',1,'bmp','7-15 18-40-1 ','0-00000001.bmp'),(10,'7-15 18-47-17 0-00000001.bmp','http://benben2022.oss-cn-hangzhou.aliyuncs.com/7-15%2018-47-17%200-00000001.bmp',1,'bmp','7-15 18-47-17 ','0-00000001.bmp'),(11,'003f36bd5cbc42d751539d87fd3b6bca211700578.png@1295w.webp','https://i0.hdslb.com/bfs/new_dyn/003f36bd5cbc42d751539d87fd3b6bca211700578.png@1295w.webp',NULL,'png@1295w','7-15 19-16-33 ','003f36bd5cbc42d751539d87fd3b6bca211700578.png@1295w.webp'),(12,'logo.svg','https://www.cnblogs.com/images/logo.svg',NULL,'svg','7-15 19-16-33 ','logo.svg'),(13,'result.png','https://www.baidu.com/img/flexible/logo/pc/result.png',1,'png','7-15 19-31-35 ','result.png'),(14,'result.png','https://www.baidu.com/img/flexible/logo/pc/result.png',1,'png','7-15 19-31-35 ','result.png'),(15,'result.png','https://www.baidu.com/img/flexible/logo/pc/result.png',1,'png','7-15 19-31-35 ','result.png'),(16,'result.png','https://www.baidu.com/img/flexible/logo/pc/result.png',1,'png','7-15 19-31-35 ','result.png'),(17,'result.png','https://www.baidu.com/img/flexible/logo/pc/result.png',1,'png','7-15 19-31-35 ','result.png'),(18,'result.png','https://www.baidu.com/img/flexible/logo/pc/result.png',1,'png','7-15 19-31-35 ','result.png'),(19,'result.png','https://www.baidu.com/img/flexible/logo/pc/result.png',1,'png','7-15 19-31-35 ','result.png'),(20,'result.png','https://www.baidu.com/img/flexible/logo/pc/result.png',1,'png','7-15 19-31-35 ','result.png'),(21,'result.png','https://www.baidu.com/img/flexible/logo/pc/result.png',1,'png','7-15 19-31-35 ','result.png'),(22,'20220715194668986898.txt','http://www.e100soft.com/lwsh/downfile/upload/20220715194668986898.txt',1,'txt','7-15 19-31-35 ','20220715194668986898.txt'),(23,'','https://www.baidu.com/',1,'undefined','7-19 3-3-20 ',''),(24,'result.png','https://www.baidu.com/result.png',1,'png','7-19 3-3-20 ','result.png');
/*Table structure for table `freshman` */
DROP TABLE IF EXISTS `freshman`;
CREATE TABLE `freshman` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`classes` varchar(4) COLLATE utf8_unicode_ci NOT NULL,
`json` text COLLATE utf8_unicode_ci NOT NULL,
`gmt_create` datetime NOT NULL,
`gmt_modified` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `freshman` */
/*Table structure for table `group` */
DROP TABLE IF EXISTS `group`;
CREATE TABLE `group` (
`id` int(2) NOT NULL,
`department` int(2) DEFAULT NULL,
`name` varchar(12) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `group` */
/*Table structure for table `guanq` */
DROP TABLE IF EXISTS `guanq`;
CREATE TABLE `guanq` (
`id` int(4) NOT NULL,
`fromid` int(4) DEFAULT NULL,
`writerid` int(4) DEFAULT NULL,
`message` text COLLATE utf8_unicode_ci,
`uptime` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
`url` varchar(70) COLLATE utf8_unicode_ci DEFAULT NULL,
`shen` int(1) DEFAULT '0',
`imgurls` text COLLATE utf8_unicode_ci,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `guanq` */
insert into `guanq`(`id`,`fromid`,`writerid`,`message`,`uptime`,`url`,`shen`,`imgurls`) values (1,2,2,'5','6','',1,NULL),(24,2,1,'<p class=\"ql-align-center\"><strong><s>#{10024]喜迎除夕{10024]#</s></strong></p><p> <img src=\"http://qzonestyle.gtimg.cn/qzone/em/e206.gif\">达旦不眠，谓之守岁<img src=\"http://qzonestyle.gtimg.cn/qzone/em/e206.gif\">新年的钟声在人们的召唤中越来越近，你们的除夕是怎样过的呢？<img src=\"http://qzonestyle.gtimg.cn/qzone/em/e10294.gif\"><img src=\"http://qzonestyle.gtimg.cn/qzone/em/e10294.gif\">希望大家爆竹声声辞旧年，除去烦恼与不安，贴春联<img src=\"http://qzonestyle.gtimg.cn/qzone/em/e207.gif\"><img src=\"http://qzonestyle.gtimg.cn/qzone/em/e207.gif\">、品佳肴，来年生活更美好！除夕之夜，华灯初上，万家灯火通明，除夕夜最美好的是大街上绚丽的烟花映照下的笑脸<img src=\"http://qzonestyle.gtimg.cn/qzone/em/e176.gif\">，最热闹的是觥筹交错之后围坐在一起欢声笑语。<img src=\"http://qzonestyle.gtimg.cn/qzone/em/e10320.gif\"><img src=\"http://qzonestyle.gtimg.cn/qzone/em/e10320.gif\">希望珍惜当下，珍惜团聚，除夕过后，又是新的开始！<img src=\"http://qzonestyle.gtimg.cn/qzone/em/e10332.gif\"><img src=\"http://qzonestyle.gtimg.cn/qzone/em/e10332.gif\">555</p>','7-22 17-10-54 ','',1,'http://benben2022.oss-cn-hangzhou.aliyuncs.com/7-15%2018-29-39%200-00000001.bmp,http://benben2022.oss-cn-hangzhou.aliyuncs.com/7-15%2018-29-39%200-00000001.bmp,https://gitee.com/bendantada/img/raw/master/2023-7-30/276dWC1.png'),(25,1,7,NULL,'2022-7-22','',0,NULL),(26,1,NULL,NULL,'2022-7-22','',0,NULL),(27,1,NULL,NULL,'2022-7-22','',0,NULL),(23,1,NULL,'<p>666777</p>','7-23 18-4-14 ',NULL,5,NULL);
/*Table structure for table `identity` */
DROP TABLE IF EXISTS `identity`;
CREATE TABLE `identity` (
`id` int(2) NOT NULL AUTO_INCREMENT,
`desc` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`canEdit` int(1) NOT NULL,
`qx` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`from` int(3) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `identity` */
insert into `identity`(`id`,`desc`,`canEdit`,`qx`,`from`) values (1,'超管',0,'1111111111',1),(2,'主席',0,'1111111111',1),(3,'宣传部第一负责人',0,'0110111111',1),(4,'视频设计部第一负责人',0,'0010011111',1),(5,'新媒体部第一负责人',0,'0111011111',1),(6,'宣传部第二负责人',0,'0010111111',1),(7,'视频设计部第二负责人',0,'0010011111',1),(8,'新媒体部第二负责人',0,'0011011111',1);
/*Table structure for table `imgs` */
DROP TABLE IF EXISTS `imgs`;
CREATE TABLE `imgs` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`url` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
`name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`fromid` int(5) NOT NULL,
`msgid` int(5) NOT NULL,
`msgtype` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `imgs` */
/*Table structure for table `news` */
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
`id` int(4) NOT NULL,
`fromid` int(4) DEFAULT NULL,
`writerid` int(4) DEFAULT NULL,
`message` text COLLATE utf8_unicode_ci,
`uptime` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `news` */
insert into `news`(`id`,`fromid`,`writerid`,`message`,`uptime`) values (27,1,NULL,NULL,'2022-7-22');
/*Table structure for table `questionnaire` */
DROP TABLE IF EXISTS `questionnaire`;
CREATE TABLE `questionnaire` (
`id` int(3) NOT NULL AUTO_INCREMENT,
`tempJSON` text COLLATE utf8_unicode_ci NOT NULL,
`title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`states` int(1) NOT NULL DEFAULT '0',
`url` text COLLATE utf8_unicode_ci,
`configJSON` text COLLATE utf8_unicode_ci,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `questionnaire` */
/*Table structure for table `questionnaireresult` */
DROP TABLE IF EXISTS `questionnaireresult`;
CREATE TABLE `questionnaireresult` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`resultJSON` text COLLATE utf8_unicode_ci NOT NULL,
`temp` int(3) NOT NULL,
`sendTime` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
`infoJSON` text COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `questionnaireresult` */
/*Table structure for table `rl` */
DROP TABLE IF EXISTS `rl`;
CREATE TABLE `rl` (
`id` int(4) NOT NULL AUTO_INCREMENT,
`name` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`year` int(4) DEFAULT '2022',
`month` int(2) DEFAULT NULL,
`day` int(2) DEFAULT NULL,
`type` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`needUrl` int(1) DEFAULT NULL,
`whoCan` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`url` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`department` int(2) DEFAULT NULL COMMENT '部门',
`other` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=66 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*Data for the table `rl` */
insert into `rl`(`id`,`name`,`year`,`month`,`day`,`type`,`needUrl`,`whoCan`,`url`,`department`,`other`) values (52,'测试',2023,8,3,'官Q稿',NULL,NULL,NULL,NULL,NULL),(65,'测试',2023,8,23,'work',1,'6','work/paper?id=31',0,''),(54,'最后测试4',2023,8,16,'work',1,'1','work/paper?id=18',0,''),(55,'1',2023,8,19,'work',1,'6','work/paper?id=21',0,''),(56,'测试4',2023,8,20,'work',1,'1','work/paper?id=22',0,''),(57,'11',2023,8,21,'work',1,'1','work/paper?id=23',0,''),(58,'周子健',2023,7,21,'work',1,'1','work/paper?id=24',0,''),(59,'测试',2023,8,22,'work',1,'1','work/paper?id=25',0,''),(60,'测试',2023,8,22,'work',1,'1','work/paper?id=26',0,''),(61,'测试',2023,8,22,'work',1,'1','work/paper?id=27',0,''),(62,'ceshi5',2023,8,23,'work',1,'1','work/paper?id=28',0,''),(63,'ceshi5',2023,8,23,'work',1,'1','work/paper?id=29',0,''),(64,'ceshi8',2023,8,23,'work',1,'1','work/paper?id=30',0,'');
/*Table structure for table `tools` */
DROP TABLE IF EXISTS `tools`;
CREATE TABLE `tools` (
`id` int(4) NOT NULL AUTO_INCREMENT,
`img` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`name` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
`url` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`department` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
`hot` int(1) DEFAULT '0',
`qx` int(1) DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `tools` */
/*Table structure for table `users` */
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`name` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
`status` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '身份',
`class` int(4) DEFAULT NULL,
`password` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
`phone` varchar(11) COLLATE utf8_unicode_ci DEFAULT NULL,
`qq` varchar(12) COLLATE utf8_unicode_ci DEFAULT NULL,
`dept_id` int(2) DEFAULT NULL COMMENT '部门',
`grade` int(2) DEFAULT NULL,
`group` int(2) DEFAULT NULL,
`qx` int(3) DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `users` */
insert into `users`(`id`,`name`,`status`,`class`,`password`,`phone`,`qq`,`dept_id`,`grade`,`group`,`qx`) values (1,'周子健','退休！',2019,'2010650312','17739039954','1394255600',0,20,0,3),(8,'马洛茗','视频设计部第一负责人',2127,'2811799122','18437923178','2811799122',2,21,0,2),(7,'刘泽宇','宣传部第一负责人',2107,'1559856171','18537291585','1559856171',3,21,0,2),(6,'李薇','新媒体部第一负责人',2104,'642597522','18939316192','642597522',1,21,0,2);
/*Table structure for table `work` */
DROP TABLE IF EXISTS `work`;
CREATE TABLE `work` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`start` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`end` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`other` text COLLATE utf8_unicode_ci,
`fileid` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
`order` varchar(12) COLLATE utf8_unicode_ci DEFAULT NULL,
`dos` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`fromid` int(5) DEFAULT NULL,
`cansee` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`gq` int(4) DEFAULT NULL,
`news` int(4) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=32 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `work` */
insert into `work`(`id`,`name`,`start`,`end`,`other`,`fileid`,`order`,`dos`,`fromid`,`cansee`,`gq`,`news`) values (29,'ceshi5','2022-7-23','2022-7-23','','','666','',1,NULL,0,0),(28,'ceshi5','2022-7-23','2022-7-23','','','666','',1,NULL,0,0),(27,'测试','2022-7-22','2022-7-22','','','666','',1,'',1,1),(26,'测试','2022-7-22','2022-7-22','','','666','',1,NULL,1,1),(18,'最后测试4','2022-7-16','2022-7-16','','','111','',1,NULL,NULL,NULL),(19,'1','2','3','5','4','6','7',NULL,NULL,NULL,NULL),(20,'1','2','3','5','4','6','7',8,NULL,9,10),(21,'1','2','3','5','4','6','7',8,NULL,9,10),(25,'测试','2022-7-22','2022-7-22','1,2,3','1,1,2','666','',1,NULL,1,1),(23,'11','2022-7-21','2022-7-22','','24','zzj','zzj1',1,NULL,1,0),(24,'周子健5','2022-7-21','2022-7-22','1,6,18,5','other6','44,122','4,4',2,'5,3,6',1,0);
/* Function structure for function `fn_split` */
/*!50003 DROP FUNCTION IF EXISTS `fn_split` */;
DELIMITER $$
/*!50003 CREATE DEFINER=`root`@`%` FUNCTION `fn_split`( s TEXT , del CHAR(1) , i INT) RETURNS varchar(1024) CHARSET utf8 COLLATE utf8_unicode_ci
DETERMINISTIC
SQL SECURITY INVOKER
BEGIN
DECLARE n INT ;
-- get max number of items
SET n = LENGTH(s) - LENGTH(REPLACE(s, del, '')) + 1;
IF i > n THEN
RETURN NULL ;
ELSE
RETURN SUBSTRING_INDEX(SUBSTRING_INDEX(s, del, i) , del , -1 ) ;
END IF;
END */$$
DELIMITER ;
/* Procedure structure for procedure `addWork` */
/*!50003 DROP PROCEDURE IF EXISTS `addWork` */;
DELIMITER $$
/*!50003 CREATE DEFINER=`root`@`%` PROCEDURE `addWork`(IN `name` VARCHAR(100),IN `start` VARCHAR(50),IN `end` VARCHAR(50),
IN fileid VARCHAR(60),IN other TEXT,IN `order` VARCHAR(12),IN dos VARCHAR(100),
IN fromid INT,IN guanq INT,IN news INT)
BEGIN
INSERT INTO `work` (`name`, `start`, `end`, fileid, other, `order`, dos,fromid,gq,news)
VALUES (`name`,`start`,`end`,fileid,other,`order`,dos,fromid,guanq,news);
SET @workinsert =LAST_INSERT_ID();
INSERT INTO `tw`.`rl` (`name`, `year`, `month`, `day`, `type`, `needUrl`, `whoCan`, `url`, `department`, `other`)
VALUES (`name`, fn_split(`start`,"-",1), fn_split(`start`,"-",2), fn_split(`start`,"-",3), "work",1, fromid, CONCAT("work/paper?id=",@workinsert), 0, "");
SELECT * FROM `work` WHERE id=@workinsert;
IF guanq>=1 THEN
INSERT INTO `guanq` (`id`, `fromid`, `writerid`, `message`, `uptime`, `url`)
VALUES (@workinsert, `fromid`, NULL, NULL, `start`, '');
END IF;
IF news>=1 THEN
INSERT INTO `news` (`id`, `fromid`, `writerid`, `message`, `uptime`)
VALUES (@workinsert, `fromid`, NULL, NULL, `start`);
END IF;
END */$$
DELIMITER ;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手
