-- phpMyAdmin SQL Dump
-- version 4.9.0.1
-- https://www.phpmyadmin.net/
--
-- Host:
-- Generation Time: Nov 03, 2020 at 10:05 AM
-- Server version: 5.5.62
-- PHP Version: 7.1.14
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
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 utf8mb4 */;
--
-- Database: `mooclabxf`
--
-- --------------------------------------------------------
--
-- Table structure for table `xf_tl_group`
--
CREATE TABLE `xf_tl_group` (
`group_id` int(10) UNSIGNED NOT NULL,
`name` varchar(100) NOT NULL,
`short_description` varchar(255) NOT NULL,
`description` mediumtext NOT NULL,
`category_id` int(10) UNSIGNED NOT NULL,
`owner_user_id` int(10) UNSIGNED NOT NULL,
`owner_username` varchar(50) NOT NULL,
`privacy` varbinary(25) NOT NULL DEFAULT 'public',
`group_state` enum('visible','moderated','deleted') NOT NULL DEFAULT 'visible',
`created_date` int(10) UNSIGNED NOT NULL DEFAULT '0',
`member_count` int(10) UNSIGNED NOT NULL DEFAULT '0',
`event_count` int(10) UNSIGNED NOT NULL DEFAULT '0',
`discussion_count` int(10) UNSIGNED NOT NULL DEFAULT '0',
`node_count` int(10) UNSIGNED NOT NULL DEFAULT '0',
`tags` blob,
`language_code` varchar(32) NOT NULL,
`member_cache` mediumblob NOT NULL,
`view_count` int(10) UNSIGNED NOT NULL DEFAULT '0',
`custom_fields` mediumblob NOT NULL,
`last_activity` int(10) UNSIGNED NOT NULL DEFAULT '0',
`member_moderated_count` int(10) UNSIGNED NOT NULL DEFAULT '0',
`always_moderate_join` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
`cover_crop_data` blob NOT NULL,
`album_count` int(10) UNSIGNED NOT NULL DEFAULT '0',
`cover_attachment_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
`avatar_attachment_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
`allow_guest_posting` tinyint(3) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `xf_tl_group`
--
INSERT INTO `xf_tl_group` (`tags`) VALUES
(0x5b226361726565722070617468222c2273747564792067726f7570222c2275692064657369676e222c2275782064657369676e225d);
--
-- Indexes for dumped tables
--
--
-- Indexes for table `xf_tl_group`
--
ALTER TABLE `xf_tl_group`
ADD PRIMARY KEY (`group_id`),
ADD KEY `owner_user_id` (`owner_user_id`),
ADD KEY `category_last_activity` (`category_id`,`last_activity`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `xf_tl_group`
--
ALTER TABLE `xf_tl_group`
MODIFY `group_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=105;
COMMIT;
/*!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 */;