📄 table.sql

📁 交易撮合系统是一套买卖信息沟通的平台
💻 SQL
📖 第 1 页 / 共 4 页
字号:
  `PostTime` bigint(20) default '0',
  `LastTime` bigint(20) default '0',
  `IPAddress` varchar(20) default NULL,
  `IsNew` tinyint(1) default '0',
  `Elite` bigint(20) default '0',
  `EliteID` bigint(20) default '0',
  `Agree` int(11) default '0',
  `BeAgainst` int(11) default '0',
  `CanNotDel` tinyint(1) default '0',
  `CanNotRe` tinyint(1) default '0',
  `Commend` bigint(20) default '0',
  `DelSign` tinyint(1) default '0',
  `DelUserID` varchar(40) default NULL,
  `DelUserName` varchar(20) default NULL,
  `DelTime` bigint(20) default '0',
  `DelIP` varchar(20) default NULL,
  `Amend` varchar(255) default NULL,
  `DoEliteName` varchar(20) default '0',
  `DoEliteTime` bigint(20) default '0',
  `HaveAttachFile` tinyint(1) default '0',
  `AttachFileName` text,
  `LastPostUserName` varchar(20) default NULL,
  `LastPostTitle` varchar(150) default NULL,
  `LastPostNickName` varchar(60) default NULL,
  `IsTop` bigint(20) default '0',
  `IsLock` tinyint(1) default '0',
  `Auditing` tinyint(1) default '0',
  `AuditingAttachFile` tinyint(1) default '0',
  `IsVote` tinyint(1) default '0',
  `IsHidden` tinyint(4) default '0',
  `IsHiddenValue` int(11) default '1',
  `EditType` tinyint(1) default '0',
  `QuoteText` text,
  `QuoteEditType` tinyint(1) default '0',
  `PostType` tinyint(1) default '0',
  `TitleColor` tinyint(2) default '0',
  `UserBlog` tinyint(1) default '0',
  `IndexStatus` tinyint(1) default '0',
  `EmailInform` tinyint(1) default '0',
  `MsgInform` tinyint(1) default '0',
  `VoteID` varchar(40) default NULL,
  `TagID` varchar(40) default '0',
  `TagName` varchar(255) default NULL,
  `IsGuest` tinyint(1) default '0',
  `PreviewAttach` tinyint(1) default '0',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `ID` (`ID`),
  KEY `MainID` (`MainID`),
  KEY `BoardID` (`BoardID`),
  KEY `LastTime` (`LastTime`),
  KEY `PostTime` (`PostTime`),
  KEY `UserID` (`UserID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
######
CREATE TABLE `bbscs_forumarchives_1` (
  `ID` varchar(40) NOT NULL default '',
  `ParentID` varchar(40) NOT NULL default '',
  `MainID` varchar(40) NOT NULL default '',
  `BoardID` bigint(20) NOT NULL default '0',
  `BoardName` varchar(60) default NULL,
  `ReNum` int(11) default '0',
  `Face` tinyint(2) default '1',
  `UserID` varchar(40) default NULL,
  `UserName` varchar(20) default NULL,
  `NickName` varchar(60) default NULL,
  `Title` varchar(150) default NULL,
  `Detail` text,
  `Sign` text,
  `ArtSize` int(11) default '0',
  `Click` int(11) default '0',
  `PostTime` bigint(20) default '0',
  `LastTime` bigint(20) default '0',
  `IPAddress` varchar(20) default NULL,
  `IsNew` tinyint(1) default '0',
  `Elite` bigint(20) default '0',
  `EliteID` bigint(20) default '0',
  `Agree` int(11) default '0',
  `BeAgainst` int(11) default '0',
  `CanNotDel` tinyint(1) default '0',
  `CanNotRe` tinyint(1) default '0',
  `Commend` bigint(20) default '0',
  `DelSign` tinyint(1) default '0',
  `DelUserID` varchar(40) default NULL,
  `DelUserName` varchar(20) default NULL,
  `DelTime` bigint(20) default '0',
  `DelIP` varchar(20) default NULL,
  `Amend` varchar(255) default NULL,
  `DoEliteName` varchar(20) default '0',
  `DoEliteTime` bigint(20) default '0',
  `HaveAttachFile` tinyint(1) default '0',
  `AttachFileName` text,
  `LastPostUserName` varchar(20) default NULL,
  `LastPostTitle` varchar(150) default NULL,
  `LastPostNickName` varchar(60) default NULL,
  `IsTop` bigint(20) default '0',
  `IsLock` tinyint(1) default '0',
  `Auditing` tinyint(1) default '0',
  `AuditingAttachFile` tinyint(1) default '0',
  `IsVote` tinyint(1) default '0',
  `IsHidden` tinyint(4) default '0',
  `IsHiddenValue` int(11) default '1',
  `EditType` tinyint(1) default '0',
  `QuoteText` text,
  `QuoteEditType` tinyint(1) default '0',
  `PostType` tinyint(1) default '0',
  `TitleColor` tinyint(2) default '0',
  `UserBlog` tinyint(1) default '0',
  `IndexStatus` tinyint(1) default '0',
  `EmailInform` tinyint(1) default '0',
  `MsgInform` tinyint(1) default '0',
  `VoteID` varchar(40) default NULL,
  `TagID` varchar(40) default '0',
  `TagName` varchar(255) default NULL,
  `IsGuest` tinyint(1) default '0',
  `PreviewAttach` tinyint(1) default '0',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `ID` (`ID`),
  KEY `MainID` (`MainID`),
  KEY `BoardID` (`BoardID`),
  KEY `LastTime` (`LastTime`),
  KEY `PostTime` (`PostTime`),
  KEY `UserID` (`UserID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
######
CREATE TABLE `bbscs_forumarchives_2` (
  `ID` varchar(40) NOT NULL default '',
  `ParentID` varchar(40) NOT NULL default '',
  `MainID` varchar(40) NOT NULL default '',
  `BoardID` bigint(20) NOT NULL default '0',
  `BoardName` varchar(60) default NULL,
  `ReNum` int(11) default '0',
  `Face` tinyint(2) default '1',
  `UserID` varchar(40) default NULL,
  `UserName` varchar(20) default NULL,
  `NickName` varchar(60) default NULL,
  `Title` varchar(150) default NULL,
  `Detail` text,
  `Sign` text,
  `ArtSize` int(11) default '0',
  `Click` int(11) default '0',
  `PostTime` bigint(20) default '0',
  `LastTime` bigint(20) default '0',
  `IPAddress` varchar(20) default NULL,
  `IsNew` tinyint(1) default '0',
  `Elite` bigint(20) default '0',
  `EliteID` bigint(20) default '0',
  `Agree` int(11) default '0',
  `BeAgainst` int(11) default '0',
  `CanNotDel` tinyint(1) default '0',
  `CanNotRe` tinyint(1) default '0',
  `Commend` bigint(20) default '0',
  `DelSign` tinyint(1) default '0',
  `DelUserID` varchar(40) default NULL,
  `DelUserName` varchar(20) default NULL,
  `DelTime` bigint(20) default '0',
  `DelIP` varchar(20) default NULL,
  `Amend` varchar(255) default NULL,
  `DoEliteName` varchar(20) default '0',
  `DoEliteTime` bigint(20) default '0',
  `HaveAttachFile` tinyint(1) default '0',
  `AttachFileName` text,
  `LastPostUserName` varchar(20) default NULL,
  `LastPostTitle` varchar(150) default NULL,
  `LastPostNickName` varchar(60) default NULL,
  `IsTop` bigint(20) default '0',
  `IsLock` tinyint(1) default '0',
  `Auditing` tinyint(1) default '0',
  `AuditingAttachFile` tinyint(1) default '0',
  `IsVote` tinyint(1) default '0',
  `IsHidden` tinyint(4) default '0',
  `IsHiddenValue` int(11) default '1',
  `EditType` tinyint(1) default '0',
  `QuoteText` text,
  `QuoteEditType` tinyint(1) default '0',
  `PostType` tinyint(1) default '0',
  `TitleColor` tinyint(2) default '0',
  `UserBlog` tinyint(1) default '0',
  `IndexStatus` tinyint(1) default '0',
  `EmailInform` tinyint(1) default '0',
  `MsgInform` tinyint(1) default '0',
  `VoteID` varchar(40) default NULL,
  `TagID` varchar(40) default '0',
  `TagName` varchar(255) default NULL,
  `IsGuest` tinyint(1) default '0',
  `PreviewAttach` tinyint(1) default '0',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `ID` (`ID`),
  KEY `MainID` (`MainID`),
  KEY `BoardID` (`BoardID`),
  KEY `LastTime` (`LastTime`),
  KEY `PostTime` (`PostTime`),
  KEY `UserID` (`UserID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
######
CREATE TABLE `bbscs_forumarchives_3` (
  `ID` varchar(40) NOT NULL default '',
  `ParentID` varchar(40) NOT NULL default '',
  `MainID` varchar(40) NOT NULL default '',
  `BoardID` bigint(20) NOT NULL default '0',
  `BoardName` varchar(60) default NULL,
  `ReNum` int(11) default '0',
  `Face` tinyint(2) default '1',
  `UserID` varchar(40) default NULL,
  `UserName` varchar(20) default NULL,
  `NickName` varchar(60) default NULL,
  `Title` varchar(150) default NULL,
  `Detail` text,
  `Sign` text,
  `ArtSize` int(11) default '0',
  `Click` int(11) default '0',
  `PostTime` bigint(20) default '0',
  `LastTime` bigint(20) default '0',
  `IPAddress` varchar(20) default NULL,
  `IsNew` tinyint(1) default '0',
  `Elite` bigint(20) default '0',
  `EliteID` bigint(20) default '0',
  `Agree` int(11) default '0',
  `BeAgainst` int(11) default '0',
  `CanNotDel` tinyint(1) default '0',
  `CanNotRe` tinyint(1) default '0',
  `Commend` bigint(20) default '0',
  `DelSign` tinyint(1) default '0',
  `DelUserID` varchar(40) default NULL,
  `DelUserName` varchar(20) default NULL,
  `DelTime` bigint(20) default '0',
  `DelIP` varchar(20) default NULL,
  `Amend` varchar(255) default NULL,
  `DoEliteName` varchar(20) default '0',
  `DoEliteTime` bigint(20) default '0',
  `HaveAttachFile` tinyint(1) default '0',
  `AttachFileName` text,
  `LastPostUserName` varchar(20) default NULL,
  `LastPostTitle` varchar(150) default NULL,
  `LastPostNickName` varchar(60) default NULL,
  `IsTop` bigint(20) default '0',
  `IsLock` tinyint(1) default '0',
  `Auditing` tinyint(1) default '0',
  `AuditingAttachFile` tinyint(1) default '0',
  `IsVote` tinyint(1) default '0',
  `IsHidden` tinyint(4) default '0',
  `IsHiddenValue` int(11) default '1',
  `EditType` tinyint(1) default '0',
  `QuoteText` text,
  `QuoteEditType` tinyint(1) default '0',
  `PostType` tinyint(1) default '0',
  `TitleColor` tinyint(2) default '0',
  `UserBlog` tinyint(1) default '0',
  `IndexStatus` tinyint(1) default '0',
  `EmailInform` tinyint(1) default '0',
  `MsgInform` tinyint(1) default '0',
  `VoteID` varchar(40) default NULL,
  `TagID` varchar(40) default '0',
  `TagName` varchar(255) default NULL,
  `IsGuest` tinyint(1) default '0',
  `PreviewAttach` tinyint(1) default '0',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `ID` (`ID`),
  KEY `MainID` (`MainID`),
  KEY `BoardID` (`BoardID`),
  KEY `LastTime` (`LastTime`),
  KEY `PostTime` (`PostTime`),
  KEY `UserID` (`UserID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
######
CREATE TABLE `bbscs_forumarchives_4` (
  `ID` varchar(40) NOT NULL default '',
  `ParentID` varchar(40) NOT NULL default '',
  `MainID` varchar(40) NOT NULL default '',
  `BoardID` bigint(20) NOT NULL default '0',
  `BoardName` varchar(60) default NULL,
  `ReNum` int(11) default '0',
  `Face` tinyint(2) default '1',
  `UserID` varchar(40) default NULL,
  `UserName` varchar(20) default NULL,
  `NickName` varchar(60) default NULL,
  `Title` varchar(150) default NULL,
  `Detail` text,
  `Sign` text,
  `ArtSize` int(11) default '0',
  `Click` int(11) default '0',
  `PostTime` bigint(20) default '0',
  `LastTime` bigint(20) default '0',
  `IPAddress` varchar(20) default NULL,
  `IsNew` tinyint(1) default '0',
  `Elite` bigint(20) default '0',
  `EliteID` bigint(20) default '0',
  `Agree` int(11) default '0',
  `BeAgainst` int(11) default '0',
  `CanNotDel` tinyint(1) default '0',
  `CanNotRe` tinyint(1) default '0',
  `Commend` bigint(20) default '0',
  `DelSign` tinyint(1) default '0',
  `DelUserID` varchar(40) default NULL,
  `DelUserName` varchar(20) default NULL,
  `DelTime` bigint(20) default '0',
  `DelIP` varchar(20) default NULL,
  `Amend` varchar(255) default NULL,
  `DoEliteName` varchar(20) default '0',
  `DoEliteTime` bigint(20) default '0',
  `HaveAttachFile` tinyint(1) default '0',
  `AttachFileName` text,
  `LastPostUserName` varchar(20) default NULL,
  `LastPostTitle` varchar(150) default NULL,
  `LastPostNickName` varchar(60) default NULL,
  `IsTop` bigint(20) default '0',
  `IsLock` tinyint(1) default '0',
  `Auditing` tinyint(1) default '0',
  `AuditingAttachFile` tinyint(1) default '0',
  `IsVote` tinyint(1) default '0',
  `IsHidden` tinyint(4) default '0',
  `IsHiddenValue` int(11) default '1',
  `EditType` tinyint(1) default '0',
  `QuoteText` text,
  `QuoteEditType` tinyint(1) default '0',
  `PostType` tinyint(1) default '0',
  `TitleColor` tinyint(2) default '0',
  `UserBlog` tinyint(1) default '0',
💿 文件大小 45766 K
👤 上传用户 SAMDUK
📂 所属分类 Jsp/Servlet
🏷️ 相关标签

#沟通
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -