帝国cms 常用的sql代码总结

这里存放一下我自己常用的sql代码，以后方便使用！！

sql代码 7.5用的

TRUNCATE phome_enewsuser;
TRUNCATE phome_enewslink;
TRUNCATE phome_enewsuseradd;
TRUNCATE phome_enewslog;

INSERT INTO `phome_enewsuser` (`userid`, `username`, `password`, `rnd`, `adminclass`, `groupid`, `checked`, `styleid`, `filelevel`, `salt`, `loginnum`, `lasttime`, `lastip`, `truename`, `email`, `classid`, `pretime`, `preip`, `addtime`, `addip`, `userprikey`, `salt2`, `lastipport`, `preipport`, `addipport`, `uprnd`, `wname`, `tel`, `wxno`, `qq`) VALUES (NULL, 'admin', '40c7809c1c2961d3307377d016510418', 'ZUnqgkRVxYjw9OfmxSXH', '', '1', '0', '1', '0', '4foWi39D', '1', '1676284843', '117.173.161.253', '', '', '0', '0', '', '1676284829', '117.173.161.253', 'atZDXpHjRKCph5xL9w9PSP9o9DEE6tiky5ljLL1OgQmb01Xt', 'ln963nZtAEAZxw2Wlhrn', '15537', '15528', '15528', '', '', '', '', '');
INSERT INTO `phome_enewslink` (`lid`, `lname`, `lpic`, `lurl`, `ltime`, `onclick`, `width`, `height`, `target`, `myorder`, `email`, `lsay`, `checked`, `ltype`, `classid`) VALUES (NULL, '红穆博客', '', 'https://img.adminhtml.com/d/file/20240410/10/20240410231113 '2050-02-09 02:27:32', '0', '88', '31', '_blank', '0', '', '', '1', '0', '0');
INSERT INTO `phome_enewslink` (`lid`, `lname`, `lpic`, `lurl`, `ltime`, `onclick`, `width`, `height`, `target`, `myorder`, `email`, `lsay`, `checked`, `ltype`, `classid`) VALUES (NULL, '在线网站缩略图生成', '', 'https://mkpic.4s5.cn/', '2050-02-09 02:27:32', '0', '88', '31', '_blank', '0', '', '', '1', '0', '0');
INSERT INTO `phome_enewslink` (`lid`, `lname`, `lpic`, `lurl`, `ltime`, `onclick`, `width`, `height`, `target`, `myorder`, `email`, `lsay`, `checked`, `ltype`, `classid`) VALUES (NULL, '音乐小播放器', '', 'https://API.4s5.cn/music/', '2050-02-09 02:27:32', '0', '88', '31', '_blank', '0', '', '', '1', '0', '0');
INSERT INTO `phome_enewsuseradd` (`userid`, `equestion`, `eanswer`, `openip`, `certkey`, `certtime`) VALUES (NULL, '0', '', '', '', '0');
INSERT INTO `phome_enewsmenuclass` (`classid`, `classname`, `issys`, `myorder`, `classtype`, `groupids`) VALUES (18, '技术服务', '0', '0', '18', '');
INSERT INTO `phome_enewsmenu` (`menuid`, `menuname`, `menuurl`, `myorder`, `classid`, `addhash`) VALUES (NULL, '技术支持', 'https://img.adminhtml.com/d/file/20240410/10/20240410231113 '0', '18', '0');

sql代码 7.2用的

TRUNCATE phome_enewsuser;
TRUNCATE phome_enewslink;
TRUNCATE phome_enewsuseradd;
TRUNCATE phome_enewslog;

INSERT INTO `phome_enewsuser` (`userid`, `username`, `password`, `rnd`, `adminclass`, `groupid`, `checked`, `styleid`, `filelevel`, `salt`, `loginnum`, `lasttime`, `lastip`, `truename`, `email`, `classid`, `pretime`, `preip`, `addtime`, `addip`, `userprikey`, `salt2`, `lastipport`, `preipport`, `addipport`, `uprnd`) VALUES (NULL, 'admin', '40c7809c1c2961d3307377d016510418', 'ZUnqgkRVxYjw9OfmxSXH', '', '1', '0', '1', '0', '4foWi39D', '1', '1676284843', '117.173.161.253', '', '', '0', '0', '', '1676284829', '117.173.161.253', 'atZDXpHjRKCph5xL9w9PSP9o9DEE6tiky5ljLL1OgQmb01Xt', 'ln963nZtAEAZxw2Wlhrn', '15537', '15528', '15528', '');

INSERT INTO `phome_enewslink` (`lid`, `lname`, `lpic`, `lurl`, `ltime`, `onclick`, `width`, `height`, `target`, `myorder`, `email`, `lsay`, `checked`, `ltype`, `classid`) VALUES (NULL, '红穆博客', '', 'https://img.adminhtml.com/d/file/20240410/10/20240410231113 '2050-02-09 02:27:32', '0', '88', '31', '_blank', '0', '', '', '1', '0', '0');
INSERT INTO `phome_enewslink` (`lid`, `lname`, `lpic`, `lurl`, `ltime`, `onclick`, `width`, `height`, `target`, `myorder`, `email`, `lsay`, `checked`, `ltype`, `classid`) VALUES (NULL, '在线网站缩略图生成', '', 'https://mkpic.4s5.cn/', '2050-02-09 02:27:32', '0', '88', '31', '_blank', '0', '', '', '1', '0', '0');
INSERT INTO `phome_enewslink` (`lid`, `lname`, `lpic`, `lurl`, `ltime`, `onclick`, `width`, `height`, `target`, `myorder`, `email`, `lsay`, `checked`, `ltype`, `classid`) VALUES (NULL, '音乐小播放器', '', 'https://api.4s5.cn/music/', '2050-02-09 02:27:32', '0', '88', '31', '_blank', '0', '', '', '1', '0', '0');
INSERT INTO `phome_enewsuseradd` (`userid`, `equestion`, `eanswer`, `openip`, `certkey`, `certtime`) VALUES (NULL, '0', '', '', '', '0');



INSERT INTO `phome_enewsmenuclass` (`classid`, `classname`, `issys`, `myorder`, `classtype`, `groupids`) VALUES (18, '技术服务', '0', '0', '18', '');

INSERT INTO `phome_enewsmenu` (`menuid`, `menuname`, `menuurl`, `myorder`, `classid`, `addhash`) VALUES (NULL, '技术支持', 'https://img.adminhtml.com/d/file/20240410/10/20240410231113 '0', '18', '0');