Brad
Well-Known Member
Hey, Quick release.
some reason it won't let me post it here due to the thread being too long.
So use this:
Thank you.
Here are the SQLs too.
some reason it won't let me post it here due to the thread being too long.
So use this:
You must be registered for see links
Thank you.
Here are the SQLs too.
Code:
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for group_forums_logs
-- ----------------------------
DROP TABLE IF EXISTS `group_forums_logs`;
CREATE TABLE `group_forums_logs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`thread_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`type` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of group_forums_logs
-- ----------------------------
INSERT INTO `group_forums_logs` VALUES ('1', '5', '1', 'post');
INSERT INTO `group_forums_logs` VALUES ('2', '5', '1', 'post');
INSERT INTO `group_forums_logs` VALUES ('3', '5', '22', 'post');
INSERT INTO `group_forums_logs` VALUES ('4', '7', '203', 'post');
INSERT INTO `group_forums_logs` VALUES ('5', '7', '203', 'post');
-- ----------------------------
-- Table structure for group_forums_settings
-- ----------------------------
DROP TABLE IF EXISTS `group_forums_settings`;
CREATE TABLE `group_forums_settings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`group_id` int(11) NOT NULL,
`who_can_read` int(11) NOT NULL,
`who_can_post` int(11) NOT NULL,
`who_can_init_discussions` int(11) NOT NULL,
`who_can_mod` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of group_forums_settings
-- ----------------------------
-- ----------------------------
-- Table structure for group_forums_thread_posts
-- ----------------------------
DROP TABLE IF EXISTS `group_forums_thread_posts`;
CREATE TABLE `group_forums_thread_posts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`timestamp` int(11) DEFAULT NULL,
`message` varchar(255) NOT NULL,
`deleted_level` int(11) NOT NULL,
`deleter_user_id` int(11) NOT NULL,
`thread_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of group_forums_thread_posts
-- ----------------------------
-- ----------------------------
-- Table structure for group_forums_thread_views
-- ----------------------------
DROP TABLE IF EXISTS `group_forums_thread_views`;
CREATE TABLE `group_forums_thread_views` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`thread_id` int(11) NOT NULL,
`timestamp` int(11) DEFAULT '0',
`user_id` int(11) NOT NULL,
`count` int(11) NOT NULL,
`deleted_level` int(11) NOT NULL,
`deleter_user_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of group_forums_thread_views
-- ----------------------------
-- ----------------------------
-- Table structure for group_forums_threads
-- ----------------------------
DROP TABLE IF EXISTS `group_forums_threads`;
CREATE TABLE `group_forums_threads` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`timestamp` int(11) DEFAULT NULL,
`caption` varchar(255) NOT NULL,
`pinned` enum('0','1') NOT NULL DEFAULT '0',
`locked` enum('0','1') NOT NULL DEFAULT '0',
`deleted_level` int(11) NOT NULL,
`deleter_user_id` int(11) NOT NULL,
`forum_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;