Edit - carbon.sql

Edit: carbon.sql

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

/*!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 */;

--
-- Database: `carbon590`
--

-- --------------------------------------------------------

--
-- Table structure for table `carbon_app`
--

CREATE TABLE `carbon_app` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `AppKey` varchar(20) NOT NULL,
  `AppName` varchar(32) NOT NULL,
  `AppSecret` varchar(40) NOT NULL,
  `Time` int(10) unsigned NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `AppKey` (`AppKey`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `carbon_app_users`
--

CREATE TABLE `carbon_app_users` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `AppID` int(10) unsigned NOT NULL,
  `OpenID` varchar(64) NOT NULL,
  `AppUserName` varchar(50) DEFAULT NULL,
  `UserID` int(10) unsigned NOT NULL,
  `Time` int(10) unsigned NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `Index` (`AppID`,`OpenID`),
  KEY `UserID` (`UserID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `carbon_blogs`
--

CREATE TABLE `carbon_blogs` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ParentID` int(10) unsigned NOT NULL DEFAULT '0',
  `Content` longtext NOT NULL,
  `UserName` varchar(50) NOT NULL,
  `Category` varchar(255) DEFAULT NULL,
  `Subject` varchar(255) DEFAULT NULL,
  `BlogDate` varchar(50) DEFAULT NULL,
  `TotalReplies` int(10) unsigned NOT NULL DEFAULT '0',
  `DateCreated` int(10) unsigned NOT NULL,
  `DateNew` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `Blogs` (`UserName`,`ParentID`,`DateCreated`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `carbon_blogsettings`
--

CREATE TABLE `carbon_blogsettings` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `BlogTitle` varchar(255) DEFAULT NULL,
  `BlogTagline` varchar(255) DEFAULT NULL,
  `UserName` varchar(50) NOT NULL,
  `BlogBgcolor` varchar(255) DEFAULT NULL,
  `BlogPermissions` varchar(50) DEFAULT NULL,
  `BlogBackground` varchar(255) DEFAULT NULL,
  `BlogAudio` varchar(255) DEFAULT NULL,
  `BlogComments` int(11) NOT NULL DEFAULT '1',
  `NumBlogs` int(11) NOT NULL DEFAULT '5',
  `UserSkinID` int(11) DEFAULT '1',
  `BlogCount` int(11) DEFAULT '0',
  `BlogReplies` int(11) DEFAULT '0',
  `BlogViews` int(11) DEFAULT '0',
  `BlogScore` int(11) DEFAULT '0',
  `MusicUrl` longtext,
  `MusicName` longtext,
  PRIMARY KEY (`ID`),
  KEY `BlogSettings` (`UserName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `carbon_config`
--

CREATE TABLE `carbon_config` (
  `ConfigName` varchar(50) NOT NULL DEFAULT '',
  `ConfigValue` text NOT NULL,
  PRIMARY KEY (`ConfigName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `carbon_config`
--

INSERT INTO `carbon_config` VALUES
('AllowEditing', 'true'),
('AllowEmptyTags', 'false'),
('AllowNewTopic', 'true'),
('AppDomainName', 'app.94cb.com'),
('CacheAnnouncements', ''),
('CacheHotTags', ''),
('CacheHotTopics', ''),
('CacheLinks', ''),
('CacheOauth', ''),
('CacheRolesDict', ''),
('CacheTime', ''),
('CloseRegistration', 'false'),
('CookiePrefix', 'CarbonBBS_'),
('DaysDate', '[[regdate]]'),
('DaysPosts', '0'),
('DaysTopics', '0'),
('DaysUsers', '1'),
('FreezingTime', '0'),
('LoadJqueryUrl', '[[relativeurl]]/static/js/jquery.js'),
('MainDomainName', ''),
('MaxPostChars', '60000'),
('MaxTagChars', '128'),
('MaxTagsNum', '5'),
('MaxTitleChars', '255'),
('MobileDomainName', ''),
('NumFiles', '0'),
('NumPosts', '0'),
('NumTags', '0'),
('NumTopics', '0'),
('NumUsers', '1'),
('PageBottomContent', ''),
('PageHeadContent', ''),
('PageSiderContent', 'Hello World'),
('PostingInterval', '8'),
('PostsPerPage', '25'),
('PushConnectionTimeoutPeriod', '22'),
('SiteDesc', '一个精简、高速的基于话题的新式论坛'),
('SiteName', 'Carbon Forum'),
('SMTPAuth', 'true'),
('SMTPHost', 'smtp1.example.com'),
('SMTPPassword', 'secret'),
('SMTPPort', '587'),
('SMTPUsername', 'user@example.com'),
('TopicsPerPage', '20'),
('Version', '5.9.0'),
('WebsitePath', '[[relativeurl]]');

-- --------------------------------------------------------

--
-- Table structure for table `carbon_dict`
--

CREATE TABLE `carbon_dict` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Title` varchar(512) NOT NULL,
  `Abstract` mediumtext NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `title` (`Title`(200)) USING HASH
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `carbon_favorites`
--

CREATE TABLE `carbon_favorites` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `UserID` int(10) unsigned NOT NULL,
  `Category` varchar(255) DEFAULT NULL,
  `Title` varchar(255) DEFAULT NULL,
  `Type` tinyint(1) unsigned DEFAULT NULL,
  `FavoriteID` int(10) unsigned NOT NULL,
  `DateCreated` int(10) unsigned NOT NULL,
  `Description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `IsFavorite` (`UserID`,`Type`,`FavoriteID`),
  KEY `UsersFavorites` (`UserID`,`Type`,`DateCreated`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `carbon_inbox`
--

CREATE TABLE `carbon_inbox` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `SenderID` int(10) NOT NULL,
  `SenderName` varchar(50) NOT NULL,
  `ReceiverID` int(10) NOT NULL,
  `ReceiverName` varchar(50) NOT NULL,
  `LastContent` varchar(255) NOT NULL DEFAULT '',
  `LastTime` int(10) NOT NULL DEFAULT '0',
  `IsDel` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `DialogueID` (`LastTime`) USING BTREE,
  KEY `SenderID` (`SenderID`,`ReceiverID`),
  KEY `ReceiverID` (`ReceiverID`,`SenderID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `carbon_link`
--

CREATE TABLE `carbon_link` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Name` varchar(255) DEFAULT NULL,
  `URL` varchar(255) DEFAULT NULL,
  `Logo` varchar(255) DEFAULT NULL,
  `Intro` varchar(255) DEFAULT NULL,
  `Review` int(11) DEFAULT '0',
  `TopLink` int(11) DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `carbon_log`
--

CREATE TABLE `carbon_log` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `UserName` longtext,
  `IPAddress` longtext,
  `UserAgent` longtext,
  `DateCreated` int(10) unsigned NOT NULL,
  `HttpVerb` varchar(50) DEFAULT NULL,
  `PathAndQuery` longtext,
  `Referrer` varchar(255) DEFAULT NULL,
  `ErrDescription` varchar(255) DEFAULT NULL,
  `POSTData` longtext,
  `Notes` longtext,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `carbon_messages`
--

CREATE TABLE `carbon_messages` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `InboxID` int(10) NOT NULL DEFAULT '0',
  `UserID` int(10) NOT NULL DEFAULT '0',
  `Content` longtext NOT NULL,
  `Time` int(10) unsigned NOT NULL,
  `IsDel` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `Index` (`IsDel`,`InboxID`,`Time`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `carbon_notifications`
--

CREATE TABLE `carbon_notifications` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `UserID` int(10) unsigned NOT NULL,
  `UserName` varchar(50) NOT NULL,
  `Type` tinyint(1) unsigned NOT NULL,
  `TopicID` int(10) unsigned NOT NULL,
  `PostID` int(10) unsigned NOT NULL,
  `Time` int(10) unsigned NOT NULL,
  `IsRead` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `TopicID` (`TopicID`),
  KEY `PostID` (`PostID`),
  KEY `UserID` (`UserID`,`Time`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `carbon_pictures`
--

CREATE TABLE `carbon_pictures` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `PicUrl` varchar(255) DEFAULT NULL,
  `UserName` varchar(255) DEFAULT NULL,
  `PicReadme` varchar(255) DEFAULT NULL,
  `TopicID` int(10) unsigned DEFAULT '0',
  `AddTime` int(10) unsigned NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `carbon_postrating`
--

CREATE TABLE `carbon_postrating` (
  `UserName` varchar(50) NOT NULL,
  `TopicID` int(10) unsigned NOT NULL DEFAULT '0',
  `Rating` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `DateCreated` int(10) unsigned NOT NULL,
  KEY `TopicID` (`TopicID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `carbon_posts`
--

CREATE TABLE `carbon_posts` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `TopicID` int(10) unsigned DEFAULT '0',
  `IsTopic` tinyint(1) unsigned DEFAULT '0',
  `UserID` int(10) unsigned NOT NULL,
  `UserName` varchar(50) NOT NULL,
  `Subject` varchar(255) DEFAULT NULL,
  `Content` longtext,
  `PostIP` varchar(50) DEFAULT NULL,
  `PostTime` int(10) unsigned NOT NULL,
  `IsDel` tinyint(1) unsigned DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `TopicID` (`TopicID`,`PostTime`,`IsDel`) USING BTREE,
  KEY `UserPosts` (`UserName`,`IsDel`,`PostTime`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `carbon_posttags`
--

CREATE TABLE `carbon_posttags` (
  `TagID` int(11) DEFAULT '0',
  `TopicID` int(11) DEFAULT '0',
  `PostID` int(11) DEFAULT '0',
  KEY `TagsIndex` (`TagID`,`TopicID`),
  KEY `TopicID` (`TopicID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `carbon_roles`
--

CREATE TABLE `carbon_roles` (
  `ID` int(8) unsigned NOT NULL,
  `Name` varchar(255) NOT NULL,
  `Description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `carbon_roles`
--

INSERT INTO `carbon_roles` VALUES
(0, '游客', '未登录游客'),
(1, '注册会员', '所有注册用户自动属于该角色。'),
(2, 'VIP会员', '没有特殊权限，只是一个身份象征'),
(3, '版主', '可以管理若干个话题下的帖子'),
(4, '超级版主', '可以管理所有话题下的帖子和所有会员'),
(5, '管理员', '享有论坛的最高权限，可以管理整个论坛，设置整个论坛的参数。');

-- --------------------------------------------------------

--
-- Table structure for table `carbon_statistics`
--

CREATE TABLE `carbon_statistics` (
  `DaysUsers` int(10) unsigned NOT NULL DEFAULT '0',
  `DaysPosts` int(10) unsigned NOT NULL DEFAULT '0',
  `DaysTopics` int(10) unsigned NOT NULL DEFAULT '0',
  `TotalUsers` int(10) unsigned NOT NULL DEFAULT '0',
  `TotalPosts` int(10) unsigned NOT NULL DEFAULT '0',
  `TotalTopics` int(10) unsigned NOT NULL DEFAULT '0',
  `DaysDate` date NOT NULL DEFAULT '2014-11-01',
  `DateCreated` int(10) unsigned NOT NULL,
  PRIMARY KEY (`DaysDate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `carbon_tags`
--

CREATE TABLE `carbon_tags` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Name` varchar(255) NOT NULL,
  `Followers` int(10) unsigned DEFAULT '0',
  `Icon` tinyint(1) unsigned DEFAULT '0',
  `Description` mediumtext,
  `IsEnabled` tinyint(1) unsigned DEFAULT '1',
  `TotalPosts` int(10) unsigned DEFAULT '0',
  `MostRecentPostTime` int(10) unsigned NOT NULL,
  `DateCreated` int(10) unsigned NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `TagName` (`Name`) USING HASH,
  KEY `TotalPosts` (`IsEnabled`,`TotalPosts`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `carbon_topics`
--

CREATE TABLE `carbon_topics` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Topic` varchar(255) NOT NULL,
  `Tags` text,
  `UserID` int(10) unsigned NOT NULL DEFAULT '0',
  `UserName` varchar(50) NOT NULL,
  `LastName` varchar(50) DEFAULT NULL,
  `PostTime` int(10) unsigned NOT NULL,
  `LastTime` int(10) unsigned NOT NULL,
  `IsGood` tinyint(1) unsigned DEFAULT '0',
  `IsTop` tinyint(1) unsigned DEFAULT '0',
  `IsLocked` tinyint(1) unsigned DEFAULT '0',
  `IsDel` tinyint(1) unsigned DEFAULT '0',
  `IsVote` tinyint(1) unsigned DEFAULT '0',
  `Views` int(10) unsigned DEFAULT '0',
  `Replies` int(10) unsigned DEFAULT '0',
  `Favorites` int(10) unsigned DEFAULT '0',
  `RatingSum` int(10) unsigned NOT NULL DEFAULT '0',
  `TotalRatings` int(10) unsigned NOT NULL DEFAULT '0',
  `LastViewedTime` int(10) unsigned NOT NULL,
  `PostsTableName` int(10) unsigned DEFAULT NULL,
  `ThreadStyle` varchar(255) DEFAULT NULL,
  `Lists` longtext,
  `ListsTime` int(10) unsigned NOT NULL,
  `Log` longtext,
  PRIMARY KEY (`ID`),
  KEY `LastTime` (`LastTime`,`IsDel`),
  KEY `UserTopics` (`UserName`,`IsDel`,`LastTime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `carbon_upload`
--

CREATE TABLE `carbon_upload` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `UserName` varchar(50) NOT NULL,
  `FileName` varchar(255) NOT NULL,
  `FileSize` int(10) unsigned NOT NULL DEFAULT '0',
  `FileType` varchar(255) NOT NULL,
  `SHA1` char(40) DEFAULT NULL,
  `MD5` char(32) DEFAULT NULL,
  `FilePath` varchar(255) NOT NULL,
  `Description` varchar(255) DEFAULT NULL,
  `Category` varchar(255) DEFAULT NULL,
  `Class` varchar(255) DEFAULT NULL,
  `PostID` int(10) unsigned DEFAULT NULL,
  `Created` int(10) unsigned NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `Hash` (`FileSize`,`SHA1`,`MD5`) USING BTREE,
  KEY `UsersName` (`UserName`,`Created`) USING BTREE,
  KEY `PostID` (`PostID`,`UserName`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `carbon_users`
--

CREATE TABLE `carbon_users` (
  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `UserName` varchar(50) DEFAULT NULL,
  `Salt` int(6) unsigned DEFAULT NULL,
  `Password` char(32) DEFAULT NULL,
  `UserMail` varchar(255) DEFAULT NULL,
  `UserHomepage` varchar(255) DEFAULT NULL,
  `PasswordQuestion` varchar(255) DEFAULT NULL,
  `PasswordAnswer` char(32) DEFAULT NULL,
  `UserSex` tinyint(1) unsigned DEFAULT NULL,
  `NumFavUsers` int(10) unsigned DEFAULT '0',
  `NumFavTags` int(10) unsigned DEFAULT '0',
  `NumFavTopics` int(10) unsigned DEFAULT '0',
  `NewReply` int(10) unsigned DEFAULT '0',
  `NewMention` int(10) unsigned DEFAULT '0',
  `NewMessage` int(10) unsigned DEFAULT '0',
  `Topics` int(10) unsigned DEFAULT '0',
  `Replies` int(10) unsigned DEFAULT '0',
  `Followers` int(10) unsigned DEFAULT '0',
  `DelTopic` int(10) unsigned DEFAULT '0',
  `GoodTopic` int(10) unsigned DEFAULT '0',
  `UserPhoto` varchar(255) DEFAULT NULL,
  `UserMobile` varchar(255) DEFAULT NULL,
  `UserLastIP` varchar(50) DEFAULT NULL,
  `UserRegTime` int(10) unsigned NOT NULL,
  `LastLoginTime` int(10) unsigned NOT NULL,
  `LastPostTime` int(10) unsigned DEFAULT NULL,
  `BlackLists` longtext,
  `UserFriend` longtext,
  `UserInfo` longtext,
  `UserIntro` longtext,
  `UserIM` longtext,
  `UserRoleID` tinyint(1) unsigned NOT NULL DEFAULT '3',
  `UserAccountStatus` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `Birthday` date DEFAULT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `UserName` (`UserName`) USING HASH
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `carbon_users`
--

INSERT INTO `carbon_users` VALUES
(1, '[[admin_username]]', [[salt]], '[[admin_pass]]', '[[admin_email]]', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '[[clientip]]', [[timestamp]], [[timestamp]], [[timestamp]], '', '', '', '', '', 5, 1, '[[regdate]]');

-- --------------------------------------------------------

--
-- Table structure for table `carbon_vote`
--

CREATE TABLE `carbon_vote` (
  `TopicID` int(10) unsigned NOT NULL DEFAULT '0',
  `Type` tinyint(1) unsigned DEFAULT '0',
  `Expiry` int(10) unsigned NOT NULL,
  `Items` longtext,
  `Result` longtext,
  `BallotUserList` longtext,
  `BallotIPList` longtext,
  `BallotItemsList` longtext,
  PRIMARY KEY (`TopicID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Cancel