<commit_before>-- +----------------------------------------------------------------------------+
-- |	Demon - dAmn Emulator												    |
-- |============================================================================|
-- |	Copyright  2008 Nol888												    |
-- |============================================================================|
-- |	This file is part of Demon.											    |
-- |																		    |
-- |	Demon is free software: you can redistribute it and/or modify		    |
-- |	it under the terms of the GNU Affero General Public License as		    |
-- |	published by the Free Software Foundation, either version 3 of the	    |
-- |	License, or (at your option) any later version.						    |
-- |																		    |
-- |	This program is distributed in the hope that it will be useful,		    |
-- |	but WITHOUT ANY WARRANTY; without even the implied warranty of		    |
-- |	MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the		    |
-- |	GNU Affero General Public License for more details.					    |
-- |																		    |
-- |	You should have received a copy of the GNU Affero General Public License|
-- |	along with this program.  If not, see <http://www.gnu.org/licenses/>.	|
-- |																			|
-- |============================================================================|
-- |	> $Date$
-- |	> $Revision$
-- |	> $Author$
-- +----------------------------------------------------------------------------+

-- phpMyAdmin SQL Dump
-- version 3.2.0-dev
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 21, 2009 at 11:57 PM
-- Server version: 5.0.67
-- PHP Version: 5.2.8

SET FOREIGN_KEY_CHECKS=0;

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

SET AUTOCOMMIT=0;
START TRANSACTION;

--
-- Database: `demonserver`
--

DROP DATABASE IF EXISTS `demonserver`;
CREATE DATABASE `demonserver` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin */;
USE `demonserver`;

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

--
-- Table structure for table `chatrooms`
--

DROP TABLE IF EXISTS `chatrooms`;
CREATE TABLE IF NOT EXISTS `chatrooms` (
  `chatroom_id` int(6) unsigned NOT NULL auto_increment COMMENT 'The ID of the chatroom.',
  `chatroom_creator_id` int(6) unsigned NOT NULL COMMENT 'The ID of the creator of the chatroom.',
  `chatroom_name` varchar(30) collate utf8_bin NOT NULL COMMENT 'The name of the chatroom.',
  `chatroom_title` int(6) unsigned NOT NULL COMMENT 'The current title of the chatroom.',
  `chatroom_topic` int(6) unsigned NOT NULL COMMENT 'The current topic of the chatroom.',
  `room_privs` int(3) unsigned NOT NULL default '127' COMMENT 'The combined flag that stores the global privs of the room.  See DemonServer.DAmnRoom.Privs for more info.',
  PRIMARY KEY  (`chatroom_id`),
  UNIQUE KEY `chatroom_name` (`chatroom_name`),
  KEY `roomcreatorid` (`chatroom_creator_id`),
  KEY `chatroomtitleref` (`chatroom_title`),
  KEY `chatroomtopicref` (`chatroom_topic`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=COMPACT COMMENT='Stores core data about all chatrooms existing on the server.' AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `privclasses`
--

DROP TABLE IF EXISTS `privclasses`;
CREATE TABLE IF NOT EXISTS `privclasses` (
  `privclass_id` int(8) unsigned NOT NULL auto_increment COMMENT 'The ID of the privclass.',
  `privclass_name` varchar(255) collate utf8_bin NOT NULL COMMENT 'The name of the privclass.',
  `chatroom_id` int(6) unsigned NOT NULL COMMENT 'The room to which the privclass belongs.',
  `order` smallint(2) unsigned NOT NULL COMMENT 'The chatroom order of the privclass.',
  `admin` tinyint(1) NOT NULL default '0' COMMENT 'Admin privs?',
  `kick` tinyint(1) NOT NULL default '0' COMMENT 'Kick privs?',
  `join` tinyint(1) NOT NULL default '1' COMMENT 'Join privs?',
  `msg` tinyint(1) NOT NULL default '1' COMMENT 'Message privs?',
  `topic` tinyint(1) NOT NULL default '0' COMMENT 'Topic privs?',
  `title` tinyint(1) NOT NULL default '0' COMMENT 'Title privs?',
  `shownotice` tinyint(1) NOT NULL default '1' COMMENT 'Show notices apon join/part?',
  `promote` smallint(2) unsigned NOT NULL default '0' COMMENT 'Promote privs.',
  `demote` smallint(2) unsigned NOT NULL default '0' COMMENT 'Demote privs.',
  `images` mediumint(3) NOT NULL default '0' COMMENT 'Image privs. -1 for unlimited, 0 for none, [number] max.',
  `smilies` mediumint(3) NOT NULL default '0' COMMENT 'Smilie privs. -1 for unlimited, 0 for none, [number] max.',
  `emoticons` mediumint(3) NOT NULL default '0' COMMENT 'Emoticon privs. -1 for unlimited, 0 for none, [number] max.',
  `thumbs` mediumint(3) NOT NULL default '0' COMMENT 'Thumb privs. -1 for unlimited, 0 for none, [number] max.',
  `avatars` mediumint(3) NOT NULL default '0' COMMENT 'Avatar privs. -1 for unlimited, 0 for none, [number] max.',
  `websites` mediumint(3) NOT NULL default '0' COMMENT 'Website privs. -1 for unlimited, 0 for none, [number] max.',
  `objects` mediumint(3) NOT NULL default '0' COMMENT 'Object privs. -1 for unlimited, 0 for none, [number] max.',
  `default` tinyint(1) NOT NULL default '0' COMMENT 'Default Privclass?',
  PRIMARY KEY  (`privclass_id`),
  KEY `chatroomidref` (`chatroom_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Privclass definition table.' AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `privclasses_entries`
--
<commit_msg>Update database schema to use type `bit' for bools.<commit_after>-- +----------------------------------------------------------------------------+
-- |	Demon - dAmn Emulator												    |
-- |============================================================================|
-- |	Copyright  2008 Nol888												    |
-- |============================================================================|
-- |	This file is part of Demon.											    |
-- |																		    |
-- |	Demon is free software: you can redistribute it and/or modify		    |
-- |	it under the terms of the GNU Affero General Public License as		    |
-- |	published by the Free Software Foundation, either version 3 of the	    |
-- |	License, or (at your option) any later version.						    |
-- |																		    |
-- |	This program is distributed in the hope that it will be useful,		    |
-- |	but WITHOUT ANY WARRANTY; without even the implied warranty of		    |
-- |	MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the		    |
-- |	GNU Affero General Public License for more details.					    |
-- |																		    |
-- |	You should have received a copy of the GNU Affero General Public License|
-- |	along with this program.  If not, see <http://www.gnu.org/licenses/>.	|
-- |																			|
-- |============================================================================|
-- |	> $Date$
-- |	> $Revision$
-- |	> $Author$
-- +----------------------------------------------------------------------------+

-- phpMyAdmin SQL Dump
-- version 3.2.0-dev
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 21, 2009 at 11:57 PM
-- Server version: 5.0.67
-- PHP Version: 5.2.8

SET FOREIGN_KEY_CHECKS=0;

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

SET AUTOCOMMIT=0;
START TRANSACTION;

--
-- Database: `demonserver`
--

DROP DATABASE IF EXISTS `demonserver`;
CREATE DATABASE `demonserver` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin */;
USE `demonserver`;

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

--
-- Table structure for table `chatrooms`
--

DROP TABLE IF EXISTS `chatrooms`;
CREATE TABLE IF NOT EXISTS `chatrooms` (
  `chatroom_id` int(6) unsigned NOT NULL auto_increment COMMENT 'The ID of the chatroom.',
  `chatroom_creator_id` int(6) unsigned NOT NULL COMMENT 'The ID of the creator of the chatroom.',
  `chatroom_name` varchar(30) collate utf8_bin NOT NULL COMMENT 'The name of the chatroom.',
  `chatroom_title` int(6) unsigned NOT NULL COMMENT 'The current title of the chatroom.',
  `chatroom_topic` int(6) unsigned NOT NULL COMMENT 'The current topic of the chatroom.',
  `room_privs` int(3) unsigned NOT NULL default '127' COMMENT 'The combined flag that stores the global privs of the room.  See DemonServer.DAmnRoom.Privs for more info.',
  PRIMARY KEY  (`chatroom_id`),
  UNIQUE KEY `chatroom_name` (`chatroom_name`),
  KEY `roomcreatorid` (`chatroom_creator_id`),
  KEY `chatroomtitleref` (`chatroom_title`),
  KEY `chatroomtopicref` (`chatroom_topic`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=COMPACT COMMENT='Stores core data about all chatrooms existing on the server.' AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `privclasses`
--

DROP TABLE IF EXISTS `privclasses`;
CREATE TABLE IF NOT EXISTS `privclasses` (
  `privclass_id` int(8) unsigned NOT NULL auto_increment COMMENT 'The ID of the privclass.',
  `privclass_name` varchar(255) collate utf8_bin NOT NULL COMMENT 'The name of the privclass.',
  `chatroom_id` int(6) unsigned NOT NULL COMMENT 'The room to which the privclass belongs.',
  `order` smallint(2) unsigned NOT NULL COMMENT 'The chatroom order of the privclass.',
  `admin` bit NOT NULL default 0 COMMENT 'Admin privs?',
  `kick` bit NOT NULL default 0 COMMENT 'Kick privs?',
  `join` bit NOT NULL default 1 COMMENT 'Join privs?',
  `msg` bit NOT NULL default 1 COMMENT 'Message privs?',
  `topic` bit NOT NULL default 0 COMMENT 'Topic privs?',
  `title` bit NOT NULL default 0 COMMENT 'Title privs?',
  `shownotice` bit NOT NULL default 1 COMMENT 'Show notices upon join/part?',
  `promote` smallint(2) unsigned NOT NULL default '0' COMMENT 'Promote privs.',
  `demote` smallint(2) unsigned NOT NULL default '0' COMMENT 'Demote privs.',
  `images` mediumint(3) NOT NULL default '0' COMMENT 'Image privs. -1 for unlimited, 0 for none, [number] max.',
  `smilies` mediumint(3) NOT NULL default '0' COMMENT 'Smilie privs. -1 for unlimited, 0 for none, [number] max.',
  `emoticons` mediumint(3) NOT NULL default '0' COMMENT 'Emoticon privs. -1 for unlimited, 0 for none, [number] max.',
  `thumbs` mediumint(3) NOT NULL default '0' COMMENT 'Thumb privs. -1 for unlimited, 0 for none, [number] max.',
  `avatars` mediumint(3) NOT NULL default '0' COMMENT 'Avatar privs. -1 for unlimited, 0 for none, [number] max.',
  `websites` mediumint(3) NOT NULL default '0' COMMENT 'Website privs. -1 for unlimited, 0 for none, [number] max.',
  `objects` mediumint(3) NOT NULL default '0' COMMENT 'Object privs. -1 for unlimited, 0 for none, [number] max.',
  `default` bit NOT NULL default 0 COMMENT 'Default Privclass?',
  PRIMARY KEY  (`privclass_id`),
  KEY `chatroomidref` (`chatroom_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Privclass definition table.' AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `privclasses_entries`
--

{'fraction_non_alphanumeric': 0.2065928078459862, 'fraction_numerical': 0.019070105339629495, 'mean_word_length': 2.810726643598616, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 11, 'https://': 0, 'lorem ipsum': 0, 'www.': 4, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '3891944', 'n_tokens_mistral': 3677, 'n_tokens_neox': 3288, 'n_words': 1202}