Discuz.Web/install/sqlscript/mysql/mysql.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

-- --------------------------------------------------
--
-- Discuz!NT SQL file for installation
--
-- --------------------------------------------------

DROP TABLE IF EXISTS `dnt_admingroups`;
CREATE TABLE `dnt_admingroups` (
  `admingid` smallint(6) NOT NULL,
  `alloweditpost` tinyint(3) unsigned NOT NULL default '0',
  `alloweditpoll` tinyint(3) unsigned NOT NULL default '0',
  `allowstickthread` tinyint(3) unsigned NOT NULL default '0',
  `allowmodpost` tinyint(3) unsigned NOT NULL default '0',
  `allowdelpost` tinyint(3) unsigned NOT NULL default '0',
  `allowmassprune` tinyint(3) unsigned NOT NULL default '0',
  `allowrefund` tinyint(3) unsigned NOT NULL default '0',
  `allowcensorword` tinyint(3) unsigned NOT NULL default '0',
  `allowviewip` tinyint(3) unsigned NOT NULL default '0',
  `allowbanip` tinyint(3) unsigned NOT NULL default '0',
  `allowedituser` tinyint(3) unsigned NOT NULL default '0',
  `allowmoduser` tinyint(3) unsigned NOT NULL default '0',
  `allowbanuser` tinyint(3) unsigned NOT NULL default '0',
  `allowpostannounce` tinyint(3) unsigned NOT NULL default '0',
  `allowviewlog` tinyint(3) unsigned NOT NULL default '0',
  `disablepostctrl` tinyint(3) unsigned NOT NULL default '0',
  `allowviewrealname` tinyint(4) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=gbk;

INSERT INTO `dnt_admingroups` (`admingid`, `alloweditpost`, `alloweditpoll`, `allowstickthread`, `allowmodpost`, `allowdelpost`, `allowmassprune`, `allowrefund`, `allowcensorword`, `allowviewip`, `allowbanip`, `allowedituser`, `allowmoduser`, `allowbanuser`, `allowpostannounce`, `allowviewlog`, `disablepostctrl`, `allowviewrealname`) VALUES 
(1, 1, 1, 3, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1),
(2, 1, 0, 2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1),
(3, 1, 0, 1, 1, 1, 0, 0, 0, 1, 0, 0, 1, 1, 0, 0, 1, 1);

DROP TABLE IF EXISTS `dnt_adminvisitlog`;
CREATE TABLE `dnt_adminvisitlog` (
  `visitid` int(11) NOT NULL auto_increment,
  `uid` int(11) default NULL,
  `username` varchar(20) NOT NULL,
  `groupid` int(11) default NULL,
  `grouptitle` varchar(50) NOT NULL,
  `ip` varchar(15) default NULL,
  `postdatetime` datetime default NULL,
  `actions` varchar(100) NOT NULL,
  `others` varchar(200) NOT NULL,
  KEY `visitid` (`visitid`)
) ENGINE=MyISAM  DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;

DROP TABLE IF EXISTS `dnt_advertisements`;
CREATE TABLE `dnt_advertisements` (
  `advid` int(11) NOT NULL auto_increment,
  `available` int(11) NOT NULL,
  `type` varchar(50) NOT NULL,
  `displayorder` int(11) NOT NULL,
  `title` varchar(50) NOT NULL,
  `targets` varchar(255) NOT NULL,
  `starttime` date default NULL,
  `endtime` date default NULL,
  `code` longtext,
  `parameters` longtext,
  KEY `advid` (`advid`)