Skip to content

Instantly share code, notes, and snippets.

@nealmcb
Created August 4, 2022 22:08
Show Gist options
  • Save nealmcb/7163a70c6d3a8936c820ab790139df83 to your computer and use it in GitHub Desktop.
Save nealmcb/7163a70c6d3a8936c820ab790139df83 to your computer and use it in GitHub Desktop.
datatracker
SET autocommit=0;
-- MariaDB dump 10.19 Distrib 10.5.16-MariaDB, for Linux (x86_64)
--
-- Host: localhost Database: ietf_utf8
-- ------------------------------------------------------
-- Server version 10.5.16-MariaDB-log
/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `auth_group`
--
DROP TABLE IF EXISTS `auth_group`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auth_group` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(150) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `auth_group`
--
LOCK TABLES `auth_group` WRITE;
/*!40000 ALTER TABLE `auth_group` DISABLE KEYS */;
/*!40000 ALTER TABLE `auth_group` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `auth_group_permissions`
--
DROP TABLE IF EXISTS `auth_group_permissions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auth_group_permissions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`group_id` int(11) NOT NULL,
`permission_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `group_id` (`group_id`,`permission_id`),
KEY `auth_group_permissions_1e014c8f` (`permission_id`)
) ENGINE=MyISAM AUTO_INCREMENT=148 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `auth_group_permissions`
--
LOCK TABLES `auth_group_permissions` WRITE;
/*!40000 ALTER TABLE `auth_group_permissions` DISABLE KEYS */;
/*!40000 ALTER TABLE `auth_group_permissions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `auth_permission`
--
DROP TABLE IF EXISTS `auth_permission`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auth_permission` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`content_type_id` int(11) NOT NULL,
`codename` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `content_type_id` (`content_type_id`,`codename`)
) ENGINE=MyISAM AUTO_INCREMENT=1344 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `auth_permission`
--
LOCK TABLES `auth_permission` WRITE;
/*!40000 ALTER TABLE `auth_permission` DISABLE KEYS */;
/*!40000 ALTER TABLE `auth_permission` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `auth_user`
--
DROP TABLE IF EXISTS `auth_user`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auth_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(150) NOT NULL,
`first_name` varchar(30) NOT NULL,
`last_name` varchar(150) NOT NULL,
`email` varchar(254) NOT NULL,
`password` varchar(128) NOT NULL,
`is_staff` tinyint(1) NOT NULL,
`is_active` tinyint(1) NOT NULL,
`is_superuser` tinyint(1) NOT NULL,
`last_login` datetime(6) DEFAULT NULL,
`date_joined` datetime NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=18942 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `auth_user`
--
LOCK TABLES `auth_user` WRITE;
/*!40000 ALTER TABLE `auth_user` DISABLE KEYS */;
/*!40000 ALTER TABLE `auth_user` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `auth_user_groups`
--
DROP TABLE IF EXISTS `auth_user_groups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auth_user_groups` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `user_id` (`user_id`,`group_id`),
KEY `auth_user_groups_bda51c3c` (`group_id`)
) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `auth_user_groups`
--
LOCK TABLES `auth_user_groups` WRITE;
/*!40000 ALTER TABLE `auth_user_groups` DISABLE KEYS */;
/*!40000 ALTER TABLE `auth_user_groups` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `auth_user_user_permissions`
--
DROP TABLE IF EXISTS `auth_user_user_permissions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `auth_user_user_permissions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`permission_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `user_id` (`user_id`,`permission_id`),
KEY `auth_user_user_permissions_1e014c8f` (`permission_id`)
) ENGINE=MyISAM AUTO_INCREMENT=852 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `auth_user_user_permissions`
--
LOCK TABLES `auth_user_user_permissions` WRITE;
/*!40000 ALTER TABLE `auth_user_user_permissions` DISABLE KEYS */;
/*!40000 ALTER TABLE `auth_user_user_permissions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `community_communitylist`
--
DROP TABLE IF EXISTS `community_communitylist`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `community_communitylist` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) DEFAULT NULL,
`group_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `community_communitylist_fbfc09f1` (`user_id`),
KEY `community_communitylist_bda51c3c` (`group_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9165 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `community_communitylist`
--
LOCK TABLES `community_communitylist` WRITE;
/*!40000 ALTER TABLE `community_communitylist` DISABLE KEYS */;
/*!40000 ALTER TABLE `community_communitylist` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `community_communitylist_added_docs`
--
DROP TABLE IF EXISTS `community_communitylist_added_docs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `community_communitylist_added_docs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`communitylist_id` int(11) NOT NULL,
`document_id` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `community_communitylist__communitylist_id_documen_fed9da9a_uniq` (`communitylist_id`,`document_id`),
KEY `community_communitylist_added_docs_document_id_fc248758` (`document_id`)
) ENGINE=MyISAM AUTO_INCREMENT=16726 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `community_communitylist_added_docs`
--
LOCK TABLES `community_communitylist_added_docs` WRITE;
/*!40000 ALTER TABLE `community_communitylist_added_docs` DISABLE KEYS */;
/*!40000 ALTER TABLE `community_communitylist_added_docs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `community_communitylist_added_ids`
--
DROP TABLE IF EXISTS `community_communitylist_added_ids`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `community_communitylist_added_ids` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`communitylist_id` int(11) NOT NULL,
`document_id` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `community_communitylist_added_ids_833ae506` (`communitylist_id`),
KEY `community_communitylist_added_ids_f4226d13` (`document_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9522 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `community_communitylist_added_ids`
--
LOCK TABLES `community_communitylist_added_ids` WRITE;
/*!40000 ALTER TABLE `community_communitylist_added_ids` DISABLE KEYS */;
/*!40000 ALTER TABLE `community_communitylist_added_ids` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `community_documentchangedates`
--
DROP TABLE IF EXISTS `community_documentchangedates`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `community_documentchangedates` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`document_id` varchar(255) NOT NULL,
`new_version_date` datetime DEFAULT NULL,
`normal_change_date` datetime DEFAULT NULL,
`significant_change_date` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `community_documentchangedates_f4226d13` (`document_id`)
) ENGINE=MyISAM AUTO_INCREMENT=10701 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `community_documentchangedates`
--
LOCK TABLES `community_documentchangedates` WRITE;
/*!40000 ALTER TABLE `community_documentchangedates` DISABLE KEYS */;
/*!40000 ALTER TABLE `community_documentchangedates` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `community_emailsubscription`
--
DROP TABLE IF EXISTS `community_emailsubscription`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `community_emailsubscription` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`community_list_id` int(11) NOT NULL,
`email_id` varchar(64) NOT NULL,
`notify_on` varchar(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `community_emailsubscription_e5bf4888` (`community_list_id`),
KEY `community_emailsubscription_email_id_2bb1549a59cd26ad_uniq` (`email_id`)
) ENGINE=MyISAM AUTO_INCREMENT=918 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `community_emailsubscription`
--
LOCK TABLES `community_emailsubscription` WRITE;
/*!40000 ALTER TABLE `community_emailsubscription` DISABLE KEYS */;
/*!40000 ALTER TABLE `community_emailsubscription` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `community_expectedchange`
--
DROP TABLE IF EXISTS `community_expectedchange`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `community_expectedchange` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`community_list_id` int(11) NOT NULL,
`document_id` varchar(255) NOT NULL,
`expected_date` date NOT NULL,
PRIMARY KEY (`id`),
KEY `community_expectedchange_e5bf4888` (`community_list_id`),
KEY `community_expectedchange_f4226d13` (`document_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `community_expectedchange`
--
LOCK TABLES `community_expectedchange` WRITE;
/*!40000 ALTER TABLE `community_expectedchange` DISABLE KEYS */;
/*!40000 ALTER TABLE `community_expectedchange` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `community_listnotification`
--
DROP TABLE IF EXISTS `community_listnotification`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `community_listnotification` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`significant` tinyint(1) NOT NULL DEFAULT 0,
`event_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `community_listnotification_e9b82f95` (`event_id`)
) ENGINE=MyISAM AUTO_INCREMENT=118309 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `community_listnotification`
--
LOCK TABLES `community_listnotification` WRITE;
/*!40000 ALTER TABLE `community_listnotification` DISABLE KEYS */;
/*!40000 ALTER TABLE `community_listnotification` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `community_rule_cached_ids`
--
DROP TABLE IF EXISTS `community_rule_cached_ids`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `community_rule_cached_ids` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`rule_id` int(11) NOT NULL,
`document_id` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `community_rule_cached_ids_1c671d36` (`rule_id`),
KEY `community_rule_cached_ids_f4226d13` (`document_id`)
) ENGINE=MyISAM AUTO_INCREMENT=123941827 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `community_rule_cached_ids`
--
LOCK TABLES `community_rule_cached_ids` WRITE;
/*!40000 ALTER TABLE `community_rule_cached_ids` DISABLE KEYS */;
/*!40000 ALTER TABLE `community_rule_cached_ids` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `community_searchrule`
--
DROP TABLE IF EXISTS `community_searchrule`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `community_searchrule` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`community_list_id` int(11) NOT NULL,
`rule_type` varchar(30) NOT NULL,
`group_id` int(11),
`person_id` int(11),
`state_id` int(11),
`text` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `community_rule_e5bf4888` (`community_list_id`),
KEY `community_searchrule_0e939a4f` (`group_id`),
KEY `community_searchrule_a8452ca7` (`person_id`),
KEY `community_searchrule_d5582625` (`state_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4539 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `community_searchrule`
--
LOCK TABLES `community_searchrule` WRITE;
/*!40000 ALTER TABLE `community_searchrule` DISABLE KEYS */;
/*!40000 ALTER TABLE `community_searchrule` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `community_searchrule_name_contains_index`
--
DROP TABLE IF EXISTS `community_searchrule_name_contains_index`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `community_searchrule_name_contains_index` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`searchrule_id` int(11) NOT NULL,
`document_id` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `community_searchrule_nam_searchrule_id_document_i_8941976e_uniq` (`searchrule_id`,`document_id`),
KEY `community_searchrule_name_contains_index_document_id_f2638db1` (`document_id`)
) ENGINE=MyISAM AUTO_INCREMENT=156426 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `community_searchrule_name_contains_index`
--
LOCK TABLES `community_searchrule_name_contains_index` WRITE;
/*!40000 ALTER TABLE `community_searchrule_name_contains_index` DISABLE KEYS */;
/*!40000 ALTER TABLE `community_searchrule_name_contains_index` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `dbtemplate_dbtemplate`
--
DROP TABLE IF EXISTS `dbtemplate_dbtemplate`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dbtemplate_dbtemplate` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`path` varchar(255) NOT NULL,
`title` varchar(255) NOT NULL,
`variables` longtext DEFAULT NULL,
`type_id` varchar(32) NOT NULL,
`content` longtext NOT NULL,
`group_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `path` (`path`),
KEY `dbtemplate_dbtemplate_777d41c8` (`type_id`),
KEY `dbtemplate_dbtemplate_bda51c3c` (`group_id`)
) ENGINE=MyISAM AUTO_INCREMENT=533 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `dbtemplate_dbtemplate`
--
LOCK TABLES `dbtemplate_dbtemplate` WRITE;
/*!40000 ALTER TABLE `dbtemplate_dbtemplate` DISABLE KEYS */;
/*!40000 ALTER TABLE `dbtemplate_dbtemplate` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `django_admin_log`
--
DROP TABLE IF EXISTS `django_admin_log`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `django_admin_log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`action_time` datetime /* mariadb-5.3 */ NOT NULL,
`user_id` int(11) NOT NULL,
`content_type_id` int(11) DEFAULT NULL,
`object_id` longtext DEFAULT NULL,
`object_repr` varchar(200) NOT NULL,
`action_flag` smallint(5) unsigned NOT NULL,
`change_message` longtext NOT NULL,
PRIMARY KEY (`id`),
KEY `django_admin_log_fbfc09f1` (`user_id`),
KEY `django_admin_log_e4470c6e` (`content_type_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7037 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `django_admin_log`
--
LOCK TABLES `django_admin_log` WRITE;
/*!40000 ALTER TABLE `django_admin_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `django_admin_log` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `django_content_type`
--
DROP TABLE IF EXISTS `django_content_type`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `django_content_type` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`app_label` varchar(100) NOT NULL,
`model` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `app_label` (`app_label`,`model`)
) ENGINE=MyISAM AUTO_INCREMENT=379 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `django_content_type`
--
LOCK TABLES `django_content_type` WRITE;
/*!40000 ALTER TABLE `django_content_type` DISABLE KEYS */;
/*!40000 ALTER TABLE `django_content_type` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `django_migrations`
--
DROP TABLE IF EXISTS `django_migrations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `django_migrations` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`app` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
`applied` datetime /* mariadb-5.3 */ NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=723 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `django_migrations`
--
LOCK TABLES `django_migrations` WRITE;
/*!40000 ALTER TABLE `django_migrations` DISABLE KEYS */;
/*!40000 ALTER TABLE `django_migrations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `django_session`
--
DROP TABLE IF EXISTS `django_session`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `django_session` (
`session_key` varchar(40) NOT NULL,
`session_data` longtext NOT NULL,
`expire_date` datetime /* mariadb-5.3 */ NOT NULL,
PRIMARY KEY (`session_key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `django_session`
--
LOCK TABLES `django_session` WRITE;
/*!40000 ALTER TABLE `django_session` DISABLE KEYS */;
/*!40000 ALTER TABLE `django_session` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `django_site`
--
DROP TABLE IF EXISTS `django_site`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `django_site` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`domain` varchar(100) NOT NULL,
`name` varchar(50) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `django_site_domain_a2e37b91_uniq` (`domain`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `django_site`
--
LOCK TABLES `django_site` WRITE;
/*!40000 ALTER TABLE `django_site` DISABLE KEYS */;
/*!40000 ALTER TABLE `django_site` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_addedmessageevent`
--
DROP TABLE IF EXISTS `doc_addedmessageevent`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_addedmessageevent` (
`docevent_ptr_id` int(11) NOT NULL,
`msgtype` varchar(25) NOT NULL,
`in_reply_to_id` int(11) DEFAULT NULL,
`message_id` int(11) DEFAULT NULL,
PRIMARY KEY (`docevent_ptr_id`),
KEY `doc_addedmessageevent_48c25820` (`in_reply_to_id`),
KEY `doc_addedmessageevent_4ccaa172` (`message_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_addedmessageevent`
--
LOCK TABLES `doc_addedmessageevent` WRITE;
/*!40000 ALTER TABLE `doc_addedmessageevent` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_addedmessageevent` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_ballotdocevent`
--
DROP TABLE IF EXISTS `doc_ballotdocevent`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_ballotdocevent` (
`docevent_ptr_id` int(11) NOT NULL,
`ballot_type_id` int(11) NOT NULL,
PRIMARY KEY (`docevent_ptr_id`),
KEY `doc_ballotdocevent_bbb1e71e` (`ballot_type_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_ballotdocevent`
--
LOCK TABLES `doc_ballotdocevent` WRITE;
/*!40000 ALTER TABLE `doc_ballotdocevent` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_ballotdocevent` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_ballotpositiondocevent`
--
DROP TABLE IF EXISTS `doc_ballotpositiondocevent`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_ballotpositiondocevent` (
`docevent_ptr_id` int(11) NOT NULL,
`balloter_id` int(11) NOT NULL,
`pos_id` varchar(32) NOT NULL,
`discuss` longtext NOT NULL,
`discuss_time` datetime DEFAULT NULL,
`comment` longtext NOT NULL,
`comment_time` datetime DEFAULT NULL,
`ballot_id` int(11),
`send_email` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`docevent_ptr_id`),
KEY `doc_ballotpositiondocevent_51c59e2f` (`balloter_id`),
KEY `doc_ballotpositiondocevent_7acf05e3` (`pos_id`),
KEY `doc_ballotpositiondocevent_9ae2384c` (`ballot_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_ballotpositiondocevent`
--
LOCK TABLES `doc_ballotpositiondocevent` WRITE;
/*!40000 ALTER TABLE `doc_ballotpositiondocevent` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_ballotpositiondocevent` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_ballottype`
--
DROP TABLE IF EXISTS `doc_ballottype`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_ballottype` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`doc_type_id` varchar(32),
`slug` varchar(50) NOT NULL,
`name` varchar(255) NOT NULL,
`question` longtext NOT NULL,
`used` tinyint(1) NOT NULL DEFAULT 1,
`order` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
KEY `doc_ballottype_c9a50b03` (`doc_type_id`),
KEY `doc_ballottype_a951d5d6` (`slug`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_ballottype`
--
LOCK TABLES `doc_ballottype` WRITE;
/*!40000 ALTER TABLE `doc_ballottype` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_ballottype` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_ballottype_positions`
--
DROP TABLE IF EXISTS `doc_ballottype_positions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_ballottype_positions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ballottype_id` int(11) NOT NULL,
`ballotpositionname_id` varchar(32) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `doc_ballottype_positions_ballottype_id_1b64f377d91c7738_uniq` (`ballottype_id`,`ballotpositionname_id`),
KEY `doc_ballottype_positions_39ce05e4` (`ballotpositionname_id`)
) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_ballottype_positions`
--
LOCK TABLES `doc_ballottype_positions` WRITE;
/*!40000 ALTER TABLE `doc_ballottype_positions` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_ballottype_positions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_bofreqeditordocevent`
--
DROP TABLE IF EXISTS `doc_bofreqeditordocevent`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_bofreqeditordocevent` (
`docevent_ptr_id` int(11) NOT NULL,
PRIMARY KEY (`docevent_ptr_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_bofreqeditordocevent`
--
LOCK TABLES `doc_bofreqeditordocevent` WRITE;
/*!40000 ALTER TABLE `doc_bofreqeditordocevent` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_bofreqeditordocevent` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_bofreqeditordocevent_editors`
--
DROP TABLE IF EXISTS `doc_bofreqeditordocevent_editors`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_bofreqeditordocevent_editors` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`bofreqeditordocevent_id` int(11) NOT NULL,
`person_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `doc_bofreqeditordocevent_bofreqeditordocevent_id__b3b043ef_uniq` (`bofreqeditordocevent_id`,`person_id`),
KEY `doc_bofreqeditordocevent_ed_bofreqeditordocevent_id_ae7d9a0f` (`bofreqeditordocevent_id`),
KEY `doc_bofreqeditordocevent_editors_person_id_6287485a` (`person_id`)
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_bofreqeditordocevent_editors`
--
LOCK TABLES `doc_bofreqeditordocevent_editors` WRITE;
/*!40000 ALTER TABLE `doc_bofreqeditordocevent_editors` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_bofreqeditordocevent_editors` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_bofreqresponsibledocevent`
--
DROP TABLE IF EXISTS `doc_bofreqresponsibledocevent`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_bofreqresponsibledocevent` (
`docevent_ptr_id` int(11) NOT NULL,
PRIMARY KEY (`docevent_ptr_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_bofreqresponsibledocevent`
--
LOCK TABLES `doc_bofreqresponsibledocevent` WRITE;
/*!40000 ALTER TABLE `doc_bofreqresponsibledocevent` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_bofreqresponsibledocevent` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_bofreqresponsibledocevent_responsible`
--
DROP TABLE IF EXISTS `doc_bofreqresponsibledocevent_responsible`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_bofreqresponsibledocevent_responsible` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`bofreqresponsibledocevent_id` int(11) NOT NULL,
`person_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `doc_bofreqresponsibledoc_bofreqresponsibledoceven_b0bcc7a4_uniq` (`bofreqresponsibledocevent_id`,`person_id`),
KEY `doc_bofreqresponsibledoceve_bofreqresponsibledocevent_i_4487d0fe` (`bofreqresponsibledocevent_id`),
KEY `doc_bofreqresponsibledocevent_responsible_person_id_d45a72dd` (`person_id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_bofreqresponsibledocevent_responsible`
--
LOCK TABLES `doc_bofreqresponsibledocevent_responsible` WRITE;
/*!40000 ALTER TABLE `doc_bofreqresponsibledocevent_responsible` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_bofreqresponsibledocevent_responsible` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_consensusdocevent`
--
DROP TABLE IF EXISTS `doc_consensusdocevent`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_consensusdocevent` (
`docevent_ptr_id` int(11) NOT NULL,
`consensus` tinyint(1),
PRIMARY KEY (`docevent_ptr_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_consensusdocevent`
--
LOCK TABLES `doc_consensusdocevent` WRITE;
/*!40000 ALTER TABLE `doc_consensusdocevent` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_consensusdocevent` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_deletedevent`
--
DROP TABLE IF EXISTS `doc_deletedevent`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_deletedevent` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`content_type_id` int(11) NOT NULL,
`json` longtext NOT NULL,
`by_id` int(11) NOT NULL,
`time` datetime /* mariadb-5.3 */ NOT NULL DEFAULT '2013-01-28 11:20:00',
PRIMARY KEY (`id`),
KEY `doc_deletedevent_e4470c6e` (`content_type_id`),
KEY `doc_deletedevent_3acff7b7` (`by_id`)
) ENGINE=MyISAM AUTO_INCREMENT=46 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_deletedevent`
--
LOCK TABLES `doc_deletedevent` WRITE;
/*!40000 ALTER TABLE `doc_deletedevent` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_deletedevent` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_docalias`
--
DROP TABLE IF EXISTS `doc_docalias`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_docalias` (
`name` varchar(255) NOT NULL,
`id` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`),
UNIQUE KEY `doc_docalias_name_e1c8c37a_uniq` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=118219 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_docalias`
--
LOCK TABLES `doc_docalias` WRITE;
/*!40000 ALTER TABLE `doc_docalias` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_docalias` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_docalias_docs`
--
DROP TABLE IF EXISTS `doc_docalias_docs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_docalias_docs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`docalias_id` int(11) NOT NULL,
`document_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `doc_docalias_docs_docalias_id_document_id_0289170b_uniq` (`docalias_id`,`document_id`),
KEY `doc_docalias_docs_document_id_6d370a96` (`document_id`)
) ENGINE=MyISAM AUTO_INCREMENT=118219 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_docalias_docs`
--
LOCK TABLES `doc_docalias_docs` WRITE;
/*!40000 ALTER TABLE `doc_docalias_docs` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_docalias_docs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_docevent`
--
DROP TABLE IF EXISTS `doc_docevent`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_docevent` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`time` datetime NOT NULL,
`type` varchar(50) NOT NULL,
`by_id` int(11) NOT NULL,
`desc` longtext NOT NULL,
`rev` varchar(16) DEFAULT NULL,
`doc_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `doc_docevent_3acff7b7` (`by_id`),
KEY `doc_docevent_doc2_id_712fd3ed` (`doc_id`),
KEY `doc_doceven_type_43e53e_idx` (`type`,`doc_id`),
KEY `doc_doceven_time_1a258f_idx` (`time`,`id`)
) ENGINE=MyISAM AUTO_INCREMENT=874354 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_docevent`
--
LOCK TABLES `doc_docevent` WRITE;
/*!40000 ALTER TABLE `doc_docevent` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_docevent` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_docextresource`
--
DROP TABLE IF EXISTS `doc_docextresource`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_docextresource` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`display_name` varchar(255) NOT NULL,
`value` varchar(2083) NOT NULL,
`doc_id` int(11) NOT NULL,
`name_id` varchar(32) NOT NULL,
PRIMARY KEY (`id`),
KEY `doc_docextresource_doc_id_c1b3bbb6` (`doc_id`),
KEY `doc_docextresource_name_id_c269293d` (`name_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1845 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_docextresource`
--
LOCK TABLES `doc_docextresource` WRITE;
/*!40000 ALTER TABLE `doc_docextresource` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_docextresource` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_dochistory`
--
DROP TABLE IF EXISTS `doc_dochistory`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_dochistory` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`time` datetime NOT NULL,
`type_id` varchar(32),
`title` varchar(255) NOT NULL,
`stream_id` varchar(32),
`group_id` int(11) DEFAULT NULL,
`abstract` longtext NOT NULL,
`rev` varchar(16) NOT NULL,
`pages` int(11) DEFAULT NULL,
`order` int(11) NOT NULL,
`intended_std_level_id` varchar(32),
`std_level_id` varchar(32),
`ad_id` int(11) DEFAULT NULL,
`expires` datetime DEFAULT NULL,
`notify` varchar(255) NOT NULL,
`external_url` varchar(200) NOT NULL,
`note` longtext NOT NULL,
`internal_comments` longtext NOT NULL,
`name` varchar(255) NOT NULL,
`shepherd_id` varchar(64) DEFAULT NULL,
`words` int(11),
`uploaded_filename` longtext NOT NULL,
`doc_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `doc_dochistory_777d41c8` (`type_id`),
KEY `doc_dochistory_7371fd6` (`stream_id`),
KEY `doc_dochistory_bda51c3c` (`group_id`),
KEY `doc_dochistory_7acb362e` (`intended_std_level_id`),
KEY `doc_dochistory_eb501d8f` (`std_level_id`),
KEY `doc_dochistory_51c59e2f` (`ad_id`),
KEY `doc_dochistory_014c522f` (`shepherd_id`),
KEY `doc_dochistory_doc2_id_4cb7d177` (`doc_id`)
) ENGINE=MyISAM AUTO_INCREMENT=313163 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_dochistory`
--
LOCK TABLES `doc_dochistory` WRITE;
/*!40000 ALTER TABLE `doc_dochistory` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_dochistory` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_dochistory_formal_languages`
--
DROP TABLE IF EXISTS `doc_dochistory_formal_languages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_dochistory_formal_languages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`dochistory_id` int(11) NOT NULL,
`formallanguagename_id` varchar(32) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `doc_dochistory_formal_languages_dochistory_id_f17003ab_uniq` (`dochistory_id`,`formallanguagename_id`),
KEY `doc_dochistory_formal_languages_f9b9ddbe` (`formallanguagename_id`)
) ENGINE=MyISAM AUTO_INCREMENT=18127 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_dochistory_formal_languages`
--
LOCK TABLES `doc_dochistory_formal_languages` WRITE;
/*!40000 ALTER TABLE `doc_dochistory_formal_languages` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_dochistory_formal_languages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_dochistory_states`
--
DROP TABLE IF EXISTS `doc_dochistory_states`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_dochistory_states` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`dochistory_id` int(11) NOT NULL,
`state_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `dochistory_id` (`dochistory_id`,`state_id`),
KEY `state_id_refs_id_4f521aff` (`state_id`)
) ENGINE=MyISAM AUTO_INCREMENT=837649 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_dochistory_states`
--
LOCK TABLES `doc_dochistory_states` WRITE;
/*!40000 ALTER TABLE `doc_dochistory_states` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_dochistory_states` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_dochistory_tags`
--
DROP TABLE IF EXISTS `doc_dochistory_tags`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_dochistory_tags` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`dochistory_id` int(11) NOT NULL,
`doctagname_id` varchar(32) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `dochistory_id` (`dochistory_id`,`doctagname_id`),
KEY `doctagname_id_refs_slug_bdc6b113` (`doctagname_id`)
) ENGINE=MyISAM AUTO_INCREMENT=59106 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_dochistory_tags`
--
LOCK TABLES `doc_dochistory_tags` WRITE;
/*!40000 ALTER TABLE `doc_dochistory_tags` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_dochistory_tags` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_dochistoryauthor`
--
DROP TABLE IF EXISTS `doc_dochistoryauthor`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_dochistoryauthor` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`document_id` int(11) NOT NULL,
`email_id` varchar(64) DEFAULT NULL,
`order` int(11) NOT NULL,
`affiliation` varchar(100) NOT NULL,
`country` varchar(255) NOT NULL,
`person_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `doc_dochistoryauthor_cc846901` (`email_id`),
KEY `doc_dochistoryauthor_a8452ca7` (`person_id`),
KEY `doc_dochist_documen_7e2441_idx` (`document_id`,`order`)
) ENGINE=MyISAM AUTO_INCREMENT=627566 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_dochistoryauthor`
--
LOCK TABLES `doc_dochistoryauthor` WRITE;
/*!40000 ALTER TABLE `doc_dochistoryauthor` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_dochistoryauthor` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_docreminder`
--
DROP TABLE IF EXISTS `doc_docreminder`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_docreminder` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`event_id` int(11) NOT NULL,
`type_id` varchar(32) NOT NULL,
`due` datetime /* mariadb-5.3 */ NOT NULL,
`active` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
KEY `doc_docreminder_e9b82f95` (`event_id`),
KEY `doc_docreminder_777d41c8` (`type_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2294 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_docreminder`
--
LOCK TABLES `doc_docreminder` WRITE;
/*!40000 ALTER TABLE `doc_docreminder` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_docreminder` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_document`
--
DROP TABLE IF EXISTS `doc_document`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_document` (
`time` datetime NOT NULL,
`type_id` varchar(32),
`title` varchar(255) NOT NULL,
`stream_id` varchar(32),
`group_id` int(11) DEFAULT NULL,
`abstract` longtext NOT NULL,
`rev` varchar(16) NOT NULL,
`pages` int(11) DEFAULT NULL,
`order` int(11) NOT NULL,
`intended_std_level_id` varchar(32),
`std_level_id` varchar(32),
`ad_id` int(11) DEFAULT NULL,
`expires` datetime DEFAULT NULL,
`notify` varchar(255) NOT NULL,
`external_url` varchar(200) NOT NULL,
`note` longtext NOT NULL,
`internal_comments` longtext NOT NULL,
`name` varchar(255) NOT NULL,
`shepherd_id` varchar(64) DEFAULT NULL,
`words` int(11),
`uploaded_filename` longtext NOT NULL,
`id` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`),
UNIQUE KEY `doc_document_name_5b2a66de_uniq` (`name`),
KEY `doc_document_777d41c8` (`type_id`),
KEY `doc_document_7371fd6` (`stream_id`),
KEY `doc_document_bda51c3c` (`group_id`),
KEY `doc_document_7acb362e` (`intended_std_level_id`),
KEY `doc_document_eb501d8f` (`std_level_id`),
KEY `doc_document_51c59e2f` (`ad_id`),
KEY `doc_document_014c522f` (`shepherd_id`)
) ENGINE=MyISAM AUTO_INCREMENT=110183 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_document`
--
LOCK TABLES `doc_document` WRITE;
/*!40000 ALTER TABLE `doc_document` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_document` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_document_formal_languages`
--
DROP TABLE IF EXISTS `doc_document_formal_languages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_document_formal_languages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`document_id` int(11) NOT NULL,
`formallanguagename_id` varchar(32) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `doc_document_formal_lang_document_id_formallangua_a40a2725_uniq` (`document_id`,`formallanguagename_id`),
KEY `doc_document_formal_languages_formallanguagename_id_b771e4ee` (`formallanguagename_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6127 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_document_formal_languages`
--
LOCK TABLES `doc_document_formal_languages` WRITE;
/*!40000 ALTER TABLE `doc_document_formal_languages` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_document_formal_languages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_document_states`
--
DROP TABLE IF EXISTS `doc_document_states`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_document_states` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`document_id` int(11) NOT NULL,
`state_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `doc_document_states_document_id_state_id_962482fc_uniq` (`document_id`,`state_id`),
KEY `doc_document_states_state_id_0d51122d` (`state_id`)
) ENGINE=MyISAM AUTO_INCREMENT=364155 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_document_states`
--
LOCK TABLES `doc_document_states` WRITE;
/*!40000 ALTER TABLE `doc_document_states` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_document_states` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_document_tags`
--
DROP TABLE IF EXISTS `doc_document_tags`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_document_tags` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`document_id` int(11) NOT NULL,
`doctagname_id` varchar(32) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `doc_document_tags_document_id_doctagname_id_49f04d1d_uniq` (`document_id`,`doctagname_id`),
KEY `doc_document_tags_doctagname_id_d53de016` (`doctagname_id`)
) ENGINE=MyISAM AUTO_INCREMENT=34435 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_document_tags`
--
LOCK TABLES `doc_document_tags` WRITE;
/*!40000 ALTER TABLE `doc_document_tags` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_document_tags` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_documentactionholder`
--
DROP TABLE IF EXISTS `doc_documentactionholder`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_documentactionholder` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`time_added` datetime(6) NOT NULL,
`document_id` int(11) NOT NULL,
`person_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `unique_action_holder` (`document_id`,`person_id`),
KEY `doc_documentactionholder_document_id_f78c7422` (`document_id`),
KEY `doc_documentactionholder_person_id_85f2cf2f` (`person_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2783 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_documentactionholder`
--
LOCK TABLES `doc_documentactionholder` WRITE;
/*!40000 ALTER TABLE `doc_documentactionholder` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_documentactionholder` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_documentauthor`
--
DROP TABLE IF EXISTS `doc_documentauthor`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_documentauthor` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`email_id` varchar(64) DEFAULT NULL,
`order` int(11) NOT NULL,
`affiliation` varchar(100) NOT NULL,
`country` varchar(255) NOT NULL,
`person_id` int(11) NOT NULL,
`document_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `doc_documentauthor_cc846901` (`email_id`),
KEY `doc_documentauthor_a8452ca7` (`person_id`),
KEY `doc_documen_documen_7fabe2_idx` (`document_id`,`order`)
) ENGINE=MyISAM AUTO_INCREMENT=103100 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_documentauthor`
--
LOCK TABLES `doc_documentauthor` WRITE;
/*!40000 ALTER TABLE `doc_documentauthor` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_documentauthor` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_documenturl`
--
DROP TABLE IF EXISTS `doc_documenturl`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_documenturl` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`desc` varchar(255) NOT NULL,
`url` varchar(2083) NOT NULL,
`tag_id` varchar(32) NOT NULL,
`doc_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `doc_documenturl_76f094bc` (`tag_id`),
KEY `doc_documenturl_doc2_id_9c40d43f` (`doc_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5931 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_documenturl`
--
LOCK TABLES `doc_documenturl` WRITE;
/*!40000 ALTER TABLE `doc_documenturl` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_documenturl` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_editedauthorsdocevent`
--
DROP TABLE IF EXISTS `doc_editedauthorsdocevent`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_editedauthorsdocevent` (
`docevent_ptr_id` int(11) NOT NULL,
`basis` varchar(255) NOT NULL,
PRIMARY KEY (`docevent_ptr_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_editedauthorsdocevent`
--
LOCK TABLES `doc_editedauthorsdocevent` WRITE;
/*!40000 ALTER TABLE `doc_editedauthorsdocevent` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_editedauthorsdocevent` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_ianaexpertdocevent`
--
DROP TABLE IF EXISTS `doc_ianaexpertdocevent`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_ianaexpertdocevent` (
`docevent_ptr_id` int(11) NOT NULL,
PRIMARY KEY (`docevent_ptr_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_ianaexpertdocevent`
--
LOCK TABLES `doc_ianaexpertdocevent` WRITE;
/*!40000 ALTER TABLE `doc_ianaexpertdocevent` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_ianaexpertdocevent` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_initialreviewdocevent`
--
DROP TABLE IF EXISTS `doc_initialreviewdocevent`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_initialreviewdocevent` (
`docevent_ptr_id` int(11) NOT NULL,
`expires` datetime /* mariadb-5.3 */ DEFAULT NULL,
PRIMARY KEY (`docevent_ptr_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_initialreviewdocevent`
--
LOCK TABLES `doc_initialreviewdocevent` WRITE;
/*!40000 ALTER TABLE `doc_initialreviewdocevent` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_initialreviewdocevent` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_irsgballotdocevent`
--
DROP TABLE IF EXISTS `doc_irsgballotdocevent`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_irsgballotdocevent` (
`ballotdocevent_ptr_id` int(11) NOT NULL,
`duedate` datetime(6) DEFAULT NULL,
PRIMARY KEY (`ballotdocevent_ptr_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_irsgballotdocevent`
--
LOCK TABLES `doc_irsgballotdocevent` WRITE;
/*!40000 ALTER TABLE `doc_irsgballotdocevent` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_irsgballotdocevent` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_lastcalldocevent`
--
DROP TABLE IF EXISTS `doc_lastcalldocevent`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_lastcalldocevent` (
`docevent_ptr_id` int(11) NOT NULL,
`expires` datetime /* mariadb-5.3 */ DEFAULT NULL,
PRIMARY KEY (`docevent_ptr_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_lastcalldocevent`
--
LOCK TABLES `doc_lastcalldocevent` WRITE;
/*!40000 ALTER TABLE `doc_lastcalldocevent` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_lastcalldocevent` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_newrevisiondocevent`
--
DROP TABLE IF EXISTS `doc_newrevisiondocevent`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_newrevisiondocevent` (
`docevent_ptr_id` int(11) NOT NULL,
PRIMARY KEY (`docevent_ptr_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_newrevisiondocevent`
--
LOCK TABLES `doc_newrevisiondocevent` WRITE;
/*!40000 ALTER TABLE `doc_newrevisiondocevent` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_newrevisiondocevent` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_relateddochistory`
--
DROP TABLE IF EXISTS `doc_relateddochistory`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_relateddochistory` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`source_id` int(11) NOT NULL,
`relationship_id` varchar(32) NOT NULL,
`target_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `doc_relateddochistory_89f89e85` (`source_id`),
KEY `doc_relateddochistory_6e90f4fe` (`relationship_id`),
KEY `doc_relateddochistory_target2_id_6069e45a` (`target_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2631059 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_relateddochistory`
--
LOCK TABLES `doc_relateddochistory` WRITE;
/*!40000 ALTER TABLE `doc_relateddochistory` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_relateddochistory` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_relateddocument`
--
DROP TABLE IF EXISTS `doc_relateddocument`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_relateddocument` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`relationship_id` varchar(32) NOT NULL,
`source_id` int(11) NOT NULL,
`target_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `doc_relateddocument_6e90f4fe` (`relationship_id`),
KEY `doc_relateddocument_source2_id_c612394e` (`source_id`),
KEY `doc_relateddocument_target2_id_9272309f` (`target_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1062430 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_relateddocument`
--
LOCK TABLES `doc_relateddocument` WRITE;
/*!40000 ALTER TABLE `doc_relateddocument` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_relateddocument` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_reviewassignmentdocevent`
--
DROP TABLE IF EXISTS `doc_reviewassignmentdocevent`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_reviewassignmentdocevent` (
`docevent_ptr_id` int(11) NOT NULL,
`review_assignment_id` int(11) NOT NULL,
`state_id` varchar(32) DEFAULT NULL,
PRIMARY KEY (`docevent_ptr_id`),
KEY `doc_reviewassignmentdocevent_review_assignment_id_a396b7a3` (`review_assignment_id`),
KEY `doc_reviewassignmentdocevent_state_id_fe077702` (`state_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_reviewassignmentdocevent`
--
LOCK TABLES `doc_reviewassignmentdocevent` WRITE;
/*!40000 ALTER TABLE `doc_reviewassignmentdocevent` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_reviewassignmentdocevent` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_reviewrequestdocevent`
--
DROP TABLE IF EXISTS `doc_reviewrequestdocevent`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_reviewrequestdocevent` (
`docevent_ptr_id` int(11) NOT NULL,
`review_request_id` int(11) NOT NULL,
`state_id` varchar(32) DEFAULT NULL,
PRIMARY KEY (`docevent_ptr_id`),
KEY `doc_reviewrequestdocevent_bb4d595b` (`review_request_id`),
KEY `doc_reviewrequestdocevent_d5582625` (`state_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_reviewrequestdocevent`
--
LOCK TABLES `doc_reviewrequestdocevent` WRITE;
/*!40000 ALTER TABLE `doc_reviewrequestdocevent` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_reviewrequestdocevent` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_state`
--
DROP TABLE IF EXISTS `doc_state`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_state` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type_id` varchar(30) NOT NULL,
`slug` varchar(50) NOT NULL,
`name` varchar(255) NOT NULL,
`used` tinyint(1) NOT NULL,
`desc` longtext NOT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `doc_state_777d41c8` (`type_id`),
KEY `doc_state_a951d5d6` (`slug`)
) ENGINE=MyISAM AUTO_INCREMENT=165 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_state`
--
LOCK TABLES `doc_state` WRITE;
/*!40000 ALTER TABLE `doc_state` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_state` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_state_next_states`
--
DROP TABLE IF EXISTS `doc_state_next_states`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_state_next_states` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`from_state_id` int(11) NOT NULL,
`to_state_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `from_state_id` (`from_state_id`,`to_state_id`),
KEY `to_state_id_refs_id_623cf7a0` (`to_state_id`)
) ENGINE=MyISAM AUTO_INCREMENT=114 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_state_next_states`
--
LOCK TABLES `doc_state_next_states` WRITE;
/*!40000 ALTER TABLE `doc_state_next_states` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_state_next_states` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_statedocevent`
--
DROP TABLE IF EXISTS `doc_statedocevent`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_statedocevent` (
`docevent_ptr_id` int(11) NOT NULL,
`state_type_id` varchar(30) NOT NULL,
`state_id` int(11) DEFAULT NULL,
PRIMARY KEY (`docevent_ptr_id`),
KEY `doc_statedocevent_879785e8` (`state_type_id`),
KEY `doc_statedocevent_b9608dc2` (`state_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_statedocevent`
--
LOCK TABLES `doc_statedocevent` WRITE;
/*!40000 ALTER TABLE `doc_statedocevent` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_statedocevent` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_statetype`
--
DROP TABLE IF EXISTS `doc_statetype`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_statetype` (
`slug` varchar(30) NOT NULL,
`label` varchar(255) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_statetype`
--
LOCK TABLES `doc_statetype` WRITE;
/*!40000 ALTER TABLE `doc_statetype` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_statetype` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_submissiondocevent`
--
DROP TABLE IF EXISTS `doc_submissiondocevent`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_submissiondocevent` (
`docevent_ptr_id` int(11) NOT NULL,
`submission_id` int(11) NOT NULL,
PRIMARY KEY (`docevent_ptr_id`),
KEY `doc_submissiondocevent_1dd9cfcc` (`submission_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_submissiondocevent`
--
LOCK TABLES `doc_submissiondocevent` WRITE;
/*!40000 ALTER TABLE `doc_submissiondocevent` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_submissiondocevent` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_telechatdocevent`
--
DROP TABLE IF EXISTS `doc_telechatdocevent`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_telechatdocevent` (
`docevent_ptr_id` int(11) NOT NULL,
`telechat_date` date DEFAULT NULL,
`returning_item` tinyint(1) NOT NULL,
PRIMARY KEY (`docevent_ptr_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_telechatdocevent`
--
LOCK TABLES `doc_telechatdocevent` WRITE;
/*!40000 ALTER TABLE `doc_telechatdocevent` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_telechatdocevent` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `doc_writeupdocevent`
--
DROP TABLE IF EXISTS `doc_writeupdocevent`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_writeupdocevent` (
`docevent_ptr_id` int(11) NOT NULL,
`text` longtext NOT NULL,
PRIMARY KEY (`docevent_ptr_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `doc_writeupdocevent`
--
LOCK TABLES `doc_writeupdocevent` WRITE;
/*!40000 ALTER TABLE `doc_writeupdocevent` DISABLE KEYS */;
/*!40000 ALTER TABLE `doc_writeupdocevent` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `draft_versions_mirror`
--
DROP TABLE IF EXISTS `draft_versions_mirror`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `draft_versions_mirror` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`filename` varchar(200) NOT NULL,
`revision` varchar(2) NOT NULL,
`revision_date` date NOT NULL,
PRIMARY KEY (`id`),
KEY `draft_versions_mirror_ce54a6c0` (`filename`)
) ENGINE=MyISAM AUTO_INCREMENT=50529871 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `draft_versions_mirror`
--
LOCK TABLES `draft_versions_mirror` WRITE;
/*!40000 ALTER TABLE `draft_versions_mirror` DISABLE KEYS */;
/*!40000 ALTER TABLE `draft_versions_mirror` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `group_changestategroupevent`
--
DROP TABLE IF EXISTS `group_changestategroupevent`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `group_changestategroupevent` (
`groupevent_ptr_id` int(11) NOT NULL,
`state_id` varchar(32) NOT NULL,
PRIMARY KEY (`groupevent_ptr_id`),
KEY `group_changestategroupevent_b9608dc2` (`state_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `group_changestategroupevent`
--
LOCK TABLES `group_changestategroupevent` WRITE;
/*!40000 ALTER TABLE `group_changestategroupevent` DISABLE KEYS */;
/*!40000 ALTER TABLE `group_changestategroupevent` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `group_group`
--
DROP TABLE IF EXISTS `group_group`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `group_group` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`time` datetime NOT NULL,
`name` varchar(80) NOT NULL,
`state_id` varchar(32),
`type_id` varchar(32),
`parent_id` int(11) DEFAULT NULL,
`list_email` varchar(64) NOT NULL,
`list_subscribe` varchar(255) NOT NULL,
`list_archive` varchar(255) NOT NULL,
`comments` longtext NOT NULL,
`acronym` varchar(40) NOT NULL,
`description` longtext NOT NULL,
`charter_id` int(11) DEFAULT NULL,
`uses_milestone_dates` tinyint(1) NOT NULL,
`used_roles` longtext NOT NULL,
`meeting_seen_as_area` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `acronym` (`acronym`),
UNIQUE KEY `charter2_id` (`charter_id`),
KEY `group_group_b9608dc2` (`state_id`),
KEY `group_group_777d41c8` (`type_id`),
KEY `group_group_63f17a16` (`parent_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2342 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `group_group`
--
LOCK TABLES `group_group` WRITE;
/*!40000 ALTER TABLE `group_group` DISABLE KEYS */;
/*!40000 ALTER TABLE `group_group` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `group_group_unused_states`
--
DROP TABLE IF EXISTS `group_group_unused_states`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `group_group_unused_states` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`group_id` int(11) NOT NULL,
`state_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `group_id` (`group_id`,`state_id`),
KEY `state_id_refs_id_6a1b3772` (`state_id`)
) ENGINE=MyISAM AUTO_INCREMENT=117 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `group_group_unused_states`
--
LOCK TABLES `group_group_unused_states` WRITE;
/*!40000 ALTER TABLE `group_group_unused_states` DISABLE KEYS */;
/*!40000 ALTER TABLE `group_group_unused_states` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `group_group_unused_tags`
--
DROP TABLE IF EXISTS `group_group_unused_tags`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `group_group_unused_tags` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`group_id` int(11) NOT NULL,
`doctagname_id` varchar(32) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `group_id` (`group_id`,`doctagname_id`),
KEY `doctagname_id_refs_slug_336630ea` (`doctagname_id`)
) ENGINE=MyISAM AUTO_INCREMENT=40 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `group_group_unused_tags`
--
LOCK TABLES `group_group_unused_tags` WRITE;
/*!40000 ALTER TABLE `group_group_unused_tags` DISABLE KEYS */;
/*!40000 ALTER TABLE `group_group_unused_tags` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `group_groupevent`
--
DROP TABLE IF EXISTS `group_groupevent`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `group_groupevent` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`group_id` int(11) NOT NULL,
`time` datetime /* mariadb-5.3 */ NOT NULL,
`type` varchar(50) NOT NULL,
`by_id` int(11) NOT NULL,
`desc` longtext NOT NULL,
PRIMARY KEY (`id`),
KEY `group_groupevent_bda51c3c` (`group_id`),
KEY `group_groupevent_3acff7b7` (`by_id`),
KEY `group_group_time_ee7c7c_idx` (`time`,`id`)
) ENGINE=MyISAM AUTO_INCREMENT=19848 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `group_groupevent`
--
LOCK TABLES `group_groupevent` WRITE;
/*!40000 ALTER TABLE `group_groupevent` DISABLE KEYS */;
/*!40000 ALTER TABLE `group_groupevent` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `group_groupextresource`
--
DROP TABLE IF EXISTS `group_groupextresource`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `group_groupextresource` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`display_name` varchar(255) NOT NULL,
`value` varchar(2083) NOT NULL,
`group_id` int(11) NOT NULL,
`name_id` varchar(32) NOT NULL,
PRIMARY KEY (`id`),
KEY `group_groupextresource_group_id_5bdbf6b6` (`group_id`),
KEY `group_groupextresource_name_id_5a353fd4` (`name_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1513 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `group_groupextresource`
--
LOCK TABLES `group_groupextresource` WRITE;
/*!40000 ALTER TABLE `group_groupextresource` DISABLE KEYS */;
/*!40000 ALTER TABLE `group_groupextresource` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `group_groupfeatures`
--
DROP TABLE IF EXISTS `group_groupfeatures`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `group_groupfeatures` (
`type_id` varchar(32) NOT NULL,
`has_milestones` tinyint(1) NOT NULL,
`has_chartering_process` tinyint(1) NOT NULL,
`has_documents` tinyint(1) NOT NULL,
`has_nonsession_materials` tinyint(1) NOT NULL,
`has_meetings` tinyint(1) NOT NULL,
`has_reviews` tinyint(1) NOT NULL,
`has_default_chat` tinyint(1) NOT NULL,
`customize_workflow` tinyint(1) NOT NULL,
`about_page` varchar(64) NOT NULL,
`default_tab` varchar(64) NOT NULL,
`material_types` longtext NOT NULL,
`admin_roles` longtext NOT NULL,
`agenda_type_id` varchar(32) DEFAULT NULL,
`acts_like_wg` tinyint(1) NOT NULL,
`create_wiki` tinyint(1) NOT NULL,
`custom_group_roles` tinyint(1) NOT NULL,
`has_session_materials` tinyint(1) NOT NULL,
`is_schedulable` tinyint(1) NOT NULL,
`role_order` longtext NOT NULL,
`show_on_agenda` tinyint(1) NOT NULL,
`req_subm_approval` tinyint(1) NOT NULL,
`matman_roles` longtext NOT NULL,
`docman_roles` longtext NOT NULL,
`groupman_roles` longtext NOT NULL,
`groupman_authroles` longtext NOT NULL,
`default_used_roles` longtext NOT NULL,
`need_parent` tinyint(1) NOT NULL,
`default_parent` varchar(40) NOT NULL,
`agenda_filter_type_id` varchar(32) NOT NULL,
`session_purposes` longtext NOT NULL,
PRIMARY KEY (`type_id`),
KEY `group_groupfeatures_agenda_type_id_f0e56757` (`agenda_type_id`),
KEY `group_groupfeatures_agenda_filter_type_id_8729c6f1` (`agenda_filter_type_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `group_groupfeatures`
--
LOCK TABLES `group_groupfeatures` WRITE;
/*!40000 ALTER TABLE `group_groupfeatures` DISABLE KEYS */;
/*!40000 ALTER TABLE `group_groupfeatures` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `group_groupfeatures_parent_types`
--
DROP TABLE IF EXISTS `group_groupfeatures_parent_types`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `group_groupfeatures_parent_types` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`groupfeatures_id` varchar(32) NOT NULL,
`grouptypename_id` varchar(32) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `group_groupfeatures_pare_groupfeatures_id_groupty_979a26b0_uniq` (`groupfeatures_id`,`grouptypename_id`),
KEY `group_groupfeatures_parent_types_groupfeatures_id_a032381c` (`groupfeatures_id`),
KEY `group_groupfeatures_parent_types_grouptypename_id_d01dad59` (`grouptypename_id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `group_groupfeatures_parent_types`
--
LOCK TABLES `group_groupfeatures_parent_types` WRITE;
/*!40000 ALTER TABLE `group_groupfeatures_parent_types` DISABLE KEYS */;
/*!40000 ALTER TABLE `group_groupfeatures_parent_types` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `group_grouphistory`
--
DROP TABLE IF EXISTS `group_grouphistory`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `group_grouphistory` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`time` datetime NOT NULL,
`name` varchar(80) NOT NULL,
`state_id` varchar(32) NOT NULL,
`type_id` varchar(32) NOT NULL,
`parent_id` int(11) DEFAULT NULL,
`list_email` varchar(64) NOT NULL,
`list_subscribe` varchar(255) NOT NULL,
`list_archive` varchar(255) NOT NULL,
`comments` longtext NOT NULL,
`group_id` int(11) NOT NULL,
`acronym` varchar(40) NOT NULL,
`description` longtext NOT NULL,
`uses_milestone_dates` tinyint(1) NOT NULL,
`used_roles` longtext NOT NULL,
`meeting_seen_as_area` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
KEY `group_grouphistory_b9608dc2` (`state_id`),
KEY `group_grouphistory_777d41c8` (`type_id`),
KEY `group_grouphistory_63f17a16` (`parent_id`),
KEY `group_grouphistory_bda51c3c` (`group_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5690 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `group_grouphistory`
--
LOCK TABLES `group_grouphistory` WRITE;
/*!40000 ALTER TABLE `group_grouphistory` DISABLE KEYS */;
/*!40000 ALTER TABLE `group_grouphistory` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `group_grouphistory_unused_states`
--
DROP TABLE IF EXISTS `group_grouphistory_unused_states`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `group_grouphistory_unused_states` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`grouphistory_id` int(11) NOT NULL,
`state_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `grouphistory_id` (`grouphistory_id`,`state_id`),
KEY `state_id_refs_id_301f3c31` (`state_id`)
) ENGINE=MyISAM AUTO_INCREMENT=331 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `group_grouphistory_unused_states`
--
LOCK TABLES `group_grouphistory_unused_states` WRITE;
/*!40000 ALTER TABLE `group_grouphistory_unused_states` DISABLE KEYS */;
/*!40000 ALTER TABLE `group_grouphistory_unused_states` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `group_grouphistory_unused_tags`
--
DROP TABLE IF EXISTS `group_grouphistory_unused_tags`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `group_grouphistory_unused_tags` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`grouphistory_id` int(11) NOT NULL,
`doctagname_id` varchar(32) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `grouphistory_id` (`grouphistory_id`,`doctagname_id`),
KEY `doctagname_id_refs_slug_787a221d` (`doctagname_id`)
) ENGINE=MyISAM AUTO_INCREMENT=52 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `group_grouphistory_unused_tags`
--
LOCK TABLES `group_grouphistory_unused_tags` WRITE;
/*!40000 ALTER TABLE `group_grouphistory_unused_tags` DISABLE KEYS */;
/*!40000 ALTER TABLE `group_grouphistory_unused_tags` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `group_groupmilestone`
--
DROP TABLE IF EXISTS `group_groupmilestone`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `group_groupmilestone` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`group_id` int(11) NOT NULL,
`desc` varchar(500) NOT NULL,
`due` date DEFAULT NULL,
`time` datetime NOT NULL,
`resolved` varchar(50) NOT NULL,
`state_id` varchar(32) NOT NULL,
`order` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `group_groupmilestone_bda51c3c` (`group_id`),
KEY `group_groupmilestone_b9608dc2` (`state_id`)
) ENGINE=MyISAM AUTO_INCREMENT=8914 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `group_groupmilestone`
--
LOCK TABLES `group_groupmilestone` WRITE;
/*!40000 ALTER TABLE `group_groupmilestone` DISABLE KEYS */;
/*!40000 ALTER TABLE `group_groupmilestone` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `group_groupmilestone_docs`
--
DROP TABLE IF EXISTS `group_groupmilestone_docs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `group_groupmilestone_docs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`groupmilestone_id` int(11) NOT NULL,
`document_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `group_groupmilestone_doc_groupmilestone_id_docume_a3b78464_uniq` (`groupmilestone_id`,`document_id`),
KEY `group_groupmilestone_docs_document_id_a8b59394` (`document_id`)
) ENGINE=MyISAM AUTO_INCREMENT=532 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `group_groupmilestone_docs`
--
LOCK TABLES `group_groupmilestone_docs` WRITE;
/*!40000 ALTER TABLE `group_groupmilestone_docs` DISABLE KEYS */;
/*!40000 ALTER TABLE `group_groupmilestone_docs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `group_groupmilestonehistory`
--
DROP TABLE IF EXISTS `group_groupmilestonehistory`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `group_groupmilestonehistory` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`group_id` int(11) NOT NULL,
`state_id` varchar(32) NOT NULL,
`desc` varchar(500) NOT NULL,
`due` date DEFAULT NULL,
`resolved` varchar(50) NOT NULL,
`time` datetime NOT NULL,
`milestone_id` int(11) NOT NULL,
`order` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `group_groupmilestonehistory_bda51c3c` (`group_id`),
KEY `group_groupmilestonehistory_b9608dc2` (`state_id`),
KEY `group_groupmilestonehistory_9cfa291f` (`milestone_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7593 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `group_groupmilestonehistory`
--
LOCK TABLES `group_groupmilestonehistory` WRITE;
/*!40000 ALTER TABLE `group_groupmilestonehistory` DISABLE KEYS */;
/*!40000 ALTER TABLE `group_groupmilestonehistory` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `group_groupmilestonehistory_docs`
--
DROP TABLE IF EXISTS `group_groupmilestonehistory_docs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `group_groupmilestonehistory_docs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`groupmilestonehistory_id` int(11) NOT NULL,
`document_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `group_groupmilestonehist_groupmilestonehistory_id_45564ba9_uniq` (`groupmilestonehistory_id`,`document_id`),
KEY `group_groupmilestonehistory_docs_document_id_c1186b08` (`document_id`)
) ENGINE=MyISAM AUTO_INCREMENT=688 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `group_groupmilestonehistory_docs`
--
LOCK TABLES `group_groupmilestonehistory_docs` WRITE;
/*!40000 ALTER TABLE `group_groupmilestonehistory_docs` DISABLE KEYS */;
/*!40000 ALTER TABLE `group_groupmilestonehistory_docs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `group_groupstatetransitions`
--
DROP TABLE IF EXISTS `group_groupstatetransitions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `group_groupstatetransitions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`group_id` int(11) NOT NULL,
`state_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `group_groupstatetransitions_bda51c3c` (`group_id`),
KEY `group_groupstatetransitions_b9608dc2` (`state_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `group_groupstatetransitions`
--
LOCK TABLES `group_groupstatetransitions` WRITE;
/*!40000 ALTER TABLE `group_groupstatetransitions` DISABLE KEYS */;
/*!40000 ALTER TABLE `group_groupstatetransitions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `group_groupstatetransitions_next_states`
--
DROP TABLE IF EXISTS `group_groupstatetransitions_next_states`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `group_groupstatetransitions_next_states` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`groupstatetransitions_id` int(11) NOT NULL,
`state_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `groupstatetransitions_id` (`groupstatetransitions_id`,`state_id`),
KEY `state_id_refs_id_15f3230a` (`state_id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `group_groupstatetransitions_next_states`
--
LOCK TABLES `group_groupstatetransitions_next_states` WRITE;
/*!40000 ALTER TABLE `group_groupstatetransitions_next_states` DISABLE KEYS */;
/*!40000 ALTER TABLE `group_groupstatetransitions_next_states` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `group_groupurl`
--
DROP TABLE IF EXISTS `group_groupurl`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `group_groupurl` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`group_id` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
`url` varchar(200) NOT NULL,
PRIMARY KEY (`id`),
KEY `group_groupurl_bda51c3c` (`group_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1182 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `group_groupurl`
--
LOCK TABLES `group_groupurl` WRITE;
/*!40000 ALTER TABLE `group_groupurl` DISABLE KEYS */;
/*!40000 ALTER TABLE `group_groupurl` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `group_milestonegroupevent`
--
DROP TABLE IF EXISTS `group_milestonegroupevent`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `group_milestonegroupevent` (
`groupevent_ptr_id` int(11) NOT NULL,
`milestone_id` int(11) NOT NULL,
PRIMARY KEY (`groupevent_ptr_id`),
KEY `group_milestonegroupevent_9cfa291f` (`milestone_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `group_milestonegroupevent`
--
LOCK TABLES `group_milestonegroupevent` WRITE;
/*!40000 ALTER TABLE `group_milestonegroupevent` DISABLE KEYS */;
/*!40000 ALTER TABLE `group_milestonegroupevent` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `group_role`
--
DROP TABLE IF EXISTS `group_role`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `group_role` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name_id` varchar(32) NOT NULL,
`group_id` int(11) NOT NULL,
`person_id` int(11) NOT NULL,
`email_id` varchar(64) NOT NULL,
PRIMARY KEY (`id`),
KEY `group_role_632e075f` (`name_id`),
KEY `group_role_bda51c3c` (`group_id`),
KEY `group_role_21b911c5` (`person_id`),
KEY `group_role_6abdd435` (`email_id`)
) ENGINE=MyISAM AUTO_INCREMENT=12965 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `group_role`
--
LOCK TABLES `group_role` WRITE;
/*!40000 ALTER TABLE `group_role` DISABLE KEYS */;
/*!40000 ALTER TABLE `group_role` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `group_rolehistory`
--
DROP TABLE IF EXISTS `group_rolehistory`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `group_rolehistory` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name_id` varchar(32) NOT NULL,
`group_id` int(11) NOT NULL,
`person_id` int(11) NOT NULL,
`email_id` varchar(64) NOT NULL,
PRIMARY KEY (`id`),
KEY `group_rolehistory_632e075f` (`name_id`),
KEY `group_rolehistory_bda51c3c` (`group_id`),
KEY `group_rolehistory_21b911c5` (`person_id`),
KEY `group_rolehistory_6abdd435` (`email_id`)
) ENGINE=MyISAM AUTO_INCREMENT=27225 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `group_rolehistory`
--
LOCK TABLES `group_rolehistory` WRITE;
/*!40000 ALTER TABLE `group_rolehistory` DISABLE KEYS */;
/*!40000 ALTER TABLE `group_rolehistory` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `iesg_telechatagendaitem`
--
DROP TABLE IF EXISTS `iesg_telechatagendaitem`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `iesg_telechatagendaitem` (
`template_id` int(11) NOT NULL AUTO_INCREMENT,
`template_text` longtext NOT NULL,
`template_type` int(11) NOT NULL,
`template_title` varchar(255) NOT NULL,
PRIMARY KEY (`template_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1041 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `iesg_telechatagendaitem`
--
LOCK TABLES `iesg_telechatagendaitem` WRITE;
/*!40000 ALTER TABLE `iesg_telechatagendaitem` DISABLE KEYS */;
/*!40000 ALTER TABLE `iesg_telechatagendaitem` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `iesg_telechatdate`
--
DROP TABLE IF EXISTS `iesg_telechatdate`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `iesg_telechatdate` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`date` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=428 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `iesg_telechatdate`
--
LOCK TABLES `iesg_telechatdate` WRITE;
/*!40000 ALTER TABLE `iesg_telechatdate` DISABLE KEYS */;
/*!40000 ALTER TABLE `iesg_telechatdate` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `iesg_wgaction`
--
DROP TABLE IF EXISTS `iesg_wgaction`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `iesg_wgaction` (
`group_acronym_id` int(11) NOT NULL,
`note` longtext DEFAULT NULL,
`status_date` date NOT NULL,
`agenda` tinyint(1) NOT NULL,
`token_name` varchar(25) NOT NULL,
`pwg_cat_id` int(11) NOT NULL,
`telechat_date` date NOT NULL,
PRIMARY KEY (`group_acronym_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `iesg_wgaction`
--
LOCK TABLES `iesg_wgaction` WRITE;
/*!40000 ALTER TABLE `iesg_wgaction` DISABLE KEYS */;
/*!40000 ALTER TABLE `iesg_wgaction` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ietfworkflows_annotationtag`
--
DROP TABLE IF EXISTS `ietfworkflows_annotationtag`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ietfworkflows_annotationtag` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`workflow_id` int(11) NOT NULL,
`permission_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `ietfworkflows_annotationtag_26cddbc7` (`workflow_id`),
KEY `ietfworkflows_annotationtag_1e014c8f` (`permission_id`)
) ENGINE=MyISAM AUTO_INCREMENT=38 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ietfworkflows_annotationtag`
--
LOCK TABLES `ietfworkflows_annotationtag` WRITE;
/*!40000 ALTER TABLE `ietfworkflows_annotationtag` DISABLE KEYS */;
/*!40000 ALTER TABLE `ietfworkflows_annotationtag` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ietfworkflows_statedescription`
--
DROP TABLE IF EXISTS `ietfworkflows_statedescription`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ietfworkflows_statedescription` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`state_id` int(11) NOT NULL,
`definition` longtext NOT NULL,
`order` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `ietfworkflows_statedescription_b9608dc2` (`state_id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ietfworkflows_statedescription`
--
LOCK TABLES `ietfworkflows_statedescription` WRITE;
/*!40000 ALTER TABLE `ietfworkflows_statedescription` DISABLE KEYS */;
/*!40000 ALTER TABLE `ietfworkflows_statedescription` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ietfworkflows_stream`
--
DROP TABLE IF EXISTS `ietfworkflows_stream`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ietfworkflows_stream` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`document_group_attribute` varchar(255) DEFAULT NULL,
`group_chair_attribute` varchar(255) DEFAULT NULL,
`workflow_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `ietfworkflows_stream_26cddbc7` (`workflow_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ietfworkflows_stream`
--
LOCK TABLES `ietfworkflows_stream` WRITE;
/*!40000 ALTER TABLE `ietfworkflows_stream` DISABLE KEYS */;
/*!40000 ALTER TABLE `ietfworkflows_stream` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ietfworkflows_wgworkflow`
--
DROP TABLE IF EXISTS `ietfworkflows_wgworkflow`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ietfworkflows_wgworkflow` (
`workflow_ptr_id` int(11) NOT NULL,
PRIMARY KEY (`workflow_ptr_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ietfworkflows_wgworkflow`
--
LOCK TABLES `ietfworkflows_wgworkflow` WRITE;
/*!40000 ALTER TABLE `ietfworkflows_wgworkflow` DISABLE KEYS */;
/*!40000 ALTER TABLE `ietfworkflows_wgworkflow` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ipr_genericiprdisclosure`
--
DROP TABLE IF EXISTS `ipr_genericiprdisclosure`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ipr_genericiprdisclosure` (
`iprdisclosurebase_ptr_id` int(11) NOT NULL,
`holder_contact_name` varchar(255) NOT NULL,
`holder_contact_email` varchar(254) NOT NULL,
`holder_contact_info` longtext NOT NULL,
`statement` longtext NOT NULL,
PRIMARY KEY (`iprdisclosurebase_ptr_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ipr_genericiprdisclosure`
--
LOCK TABLES `ipr_genericiprdisclosure` WRITE;
/*!40000 ALTER TABLE `ipr_genericiprdisclosure` DISABLE KEYS */;
/*!40000 ALTER TABLE `ipr_genericiprdisclosure` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ipr_holderiprdisclosure`
--
DROP TABLE IF EXISTS `ipr_holderiprdisclosure`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ipr_holderiprdisclosure` (
`iprdisclosurebase_ptr_id` int(11) NOT NULL,
`ietfer_name` varchar(255) NOT NULL,
`ietfer_contact_email` varchar(254) NOT NULL,
`ietfer_contact_info` longtext NOT NULL,
`patent_info` longtext NOT NULL,
`has_patent_pending` tinyint(1) NOT NULL,
`holder_contact_email` varchar(254) NOT NULL,
`holder_contact_name` varchar(255) NOT NULL,
`holder_contact_info` longtext NOT NULL,
`licensing_id` varchar(32) NOT NULL,
`licensing_comments` longtext NOT NULL,
`submitter_claims_all_terms_disclosed` tinyint(1) NOT NULL,
PRIMARY KEY (`iprdisclosurebase_ptr_id`),
KEY `ipr_holderiprdisclosure_618506c9` (`licensing_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ipr_holderiprdisclosure`
--
LOCK TABLES `ipr_holderiprdisclosure` WRITE;
/*!40000 ALTER TABLE `ipr_holderiprdisclosure` DISABLE KEYS */;
/*!40000 ALTER TABLE `ipr_holderiprdisclosure` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ipr_iprdisclosurebase`
--
DROP TABLE IF EXISTS `ipr_iprdisclosurebase`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ipr_iprdisclosurebase` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`by_id` int(11) NOT NULL,
`compliant` tinyint(1) NOT NULL,
`holder_legal_name` varchar(255) NOT NULL,
`notes` longtext NOT NULL,
`other_designations` varchar(255) NOT NULL,
`state_id` varchar(32) NOT NULL,
`submitter_name` varchar(255) NOT NULL,
`submitter_email` varchar(254) NOT NULL,
`time` datetime NOT NULL,
`title` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `ipr_iprdisclosurebase_e48e5091` (`by_id`),
KEY `ipr_iprdisclosurebase_5654bf12` (`state_id`),
KEY `ipr_iprdisc_time_846a78_idx` (`time`,`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5776 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ipr_iprdisclosurebase`
--
LOCK TABLES `ipr_iprdisclosurebase` WRITE;
/*!40000 ALTER TABLE `ipr_iprdisclosurebase` DISABLE KEYS */;
/*!40000 ALTER TABLE `ipr_iprdisclosurebase` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ipr_iprdocrel`
--
DROP TABLE IF EXISTS `ipr_iprdocrel`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ipr_iprdocrel` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`disclosure_id` int(11) NOT NULL,
`sections` longtext NOT NULL,
`revisions` varchar(16) NOT NULL,
`document_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `ipr_iprdocrel_494f1cc1` (`disclosure_id`),
KEY `ipr_iprdocrel_document2_id_eb12dea6` (`document_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4284 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ipr_iprdocrel`
--
LOCK TABLES `ipr_iprdocrel` WRITE;
/*!40000 ALTER TABLE `ipr_iprdocrel` DISABLE KEYS */;
/*!40000 ALTER TABLE `ipr_iprdocrel` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ipr_iprevent`
--
DROP TABLE IF EXISTS `ipr_iprevent`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ipr_iprevent` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`time` datetime /* mariadb-5.3 */ NOT NULL,
`type_id` varchar(32) NOT NULL,
`by_id` int(11) NOT NULL,
`disclosure_id` int(11) NOT NULL,
`desc` longtext NOT NULL,
`message_id` int(11) DEFAULT NULL,
`in_reply_to_id` int(11) DEFAULT NULL,
`response_due` datetime /* mariadb-5.3 */ DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `ipr_iprevent_403d8ff3` (`type_id`),
KEY `ipr_iprevent_e48e5091` (`by_id`),
KEY `ipr_iprevent_494f1cc1` (`disclosure_id`),
KEY `ipr_iprevent_d4a47933` (`message_id`),
KEY `ipr_iprevent_37d43f37` (`in_reply_to_id`),
KEY `ipr_ipreven_time_9630c4_idx` (`time`,`id`)
) ENGINE=MyISAM AUTO_INCREMENT=20404 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ipr_iprevent`
--
LOCK TABLES `ipr_iprevent` WRITE;
/*!40000 ALTER TABLE `ipr_iprevent` DISABLE KEYS */;
/*!40000 ALTER TABLE `ipr_iprevent` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ipr_iprlicensing`
--
DROP TABLE IF EXISTS `ipr_iprlicensing`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ipr_iprlicensing` (
`licensing_option` int(11) NOT NULL AUTO_INCREMENT,
`licensing_option_value` varchar(255) NOT NULL,
PRIMARY KEY (`licensing_option`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ipr_iprlicensing`
--
LOCK TABLES `ipr_iprlicensing` WRITE;
/*!40000 ALTER TABLE `ipr_iprlicensing` DISABLE KEYS */;
/*!40000 ALTER TABLE `ipr_iprlicensing` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ipr_iprselecttype`
--
DROP TABLE IF EXISTS `ipr_iprselecttype`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ipr_iprselecttype` (
`type_id` int(11) NOT NULL AUTO_INCREMENT,
`selecttype` int(11) NOT NULL,
`type_display` varchar(15) NOT NULL,
PRIMARY KEY (`type_id`),
UNIQUE KEY `selecttype` (`selecttype`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ipr_iprselecttype`
--
LOCK TABLES `ipr_iprselecttype` WRITE;
/*!40000 ALTER TABLE `ipr_iprselecttype` DISABLE KEYS */;
/*!40000 ALTER TABLE `ipr_iprselecttype` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ipr_legacymigrationiprevent`
--
DROP TABLE IF EXISTS `ipr_legacymigrationiprevent`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ipr_legacymigrationiprevent` (
`iprevent_ptr_id` int(11) NOT NULL,
PRIMARY KEY (`iprevent_ptr_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ipr_legacymigrationiprevent`
--
LOCK TABLES `ipr_legacymigrationiprevent` WRITE;
/*!40000 ALTER TABLE `ipr_legacymigrationiprevent` DISABLE KEYS */;
/*!40000 ALTER TABLE `ipr_legacymigrationiprevent` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ipr_nondocspecificiprdisclosure`
--
DROP TABLE IF EXISTS `ipr_nondocspecificiprdisclosure`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ipr_nondocspecificiprdisclosure` (
`iprdisclosurebase_ptr_id` int(11) NOT NULL,
`holder_contact_name` varchar(255) NOT NULL,
`holder_contact_email` varchar(254) NOT NULL,
`holder_contact_info` longtext NOT NULL,
`patent_info` longtext NOT NULL,
`has_patent_pending` tinyint(1) NOT NULL,
`statement` longtext NOT NULL,
PRIMARY KEY (`iprdisclosurebase_ptr_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ipr_nondocspecificiprdisclosure`
--
LOCK TABLES `ipr_nondocspecificiprdisclosure` WRITE;
/*!40000 ALTER TABLE `ipr_nondocspecificiprdisclosure` DISABLE KEYS */;
/*!40000 ALTER TABLE `ipr_nondocspecificiprdisclosure` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ipr_relatedipr`
--
DROP TABLE IF EXISTS `ipr_relatedipr`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ipr_relatedipr` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`source_id` int(11) NOT NULL,
`target_id` int(11) NOT NULL,
`relationship_id` varchar(32) NOT NULL,
PRIMARY KEY (`id`),
KEY `ipr_relatedipr_a34b03a6` (`source_id`),
KEY `ipr_relatedipr_70bfdfd1` (`target_id`),
KEY `ipr_relatedipr_6f9399d2` (`relationship_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2798 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ipr_relatedipr`
--
LOCK TABLES `ipr_relatedipr` WRITE;
/*!40000 ALTER TABLE `ipr_relatedipr` DISABLE KEYS */;
/*!40000 ALTER TABLE `ipr_relatedipr` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ipr_thirdpartyiprdisclosure`
--
DROP TABLE IF EXISTS `ipr_thirdpartyiprdisclosure`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ipr_thirdpartyiprdisclosure` (
`iprdisclosurebase_ptr_id` int(11) NOT NULL,
`ietfer_name` varchar(255) NOT NULL,
`ietfer_contact_email` varchar(254) NOT NULL,
`ietfer_contact_info` longtext NOT NULL,
`patent_info` longtext NOT NULL,
`has_patent_pending` tinyint(1) NOT NULL,
PRIMARY KEY (`iprdisclosurebase_ptr_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `ipr_thirdpartyiprdisclosure`
--
LOCK TABLES `ipr_thirdpartyiprdisclosure` WRITE;
/*!40000 ALTER TABLE `ipr_thirdpartyiprdisclosure` DISABLE KEYS */;
/*!40000 ALTER TABLE `ipr_thirdpartyiprdisclosure` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `liaisons_liaisonstatement`
--
DROP TABLE IF EXISTS `liaisons_liaisonstatement`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `liaisons_liaisonstatement` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL,
`purpose_id` varchar(32) NOT NULL,
`body` longtext NOT NULL,
`deadline` date DEFAULT NULL,
`from_contact_id` varchar(64) DEFAULT NULL,
`to_contacts` varchar(2000) NOT NULL,
`response_contacts` varchar(255) DEFAULT NULL,
`technical_contacts` varchar(255) DEFAULT NULL,
`cc_contacts` longtext DEFAULT NULL,
`action_holder_contacts` varchar(255) NOT NULL,
`other_identifiers` longtext DEFAULT NULL,
`state_id` varchar(32) NOT NULL,
PRIMARY KEY (`id`),
KEY `liaisons_liaisonstatement_3f385c1b` (`purpose_id`),
KEY `liaisons_liaisonstatement_cd79070f` (`from_contact_id`),
KEY `liaisons_liaisonstatement_d5582625` (`state_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1794 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `liaisons_liaisonstatement`
--
LOCK TABLES `liaisons_liaisonstatement` WRITE;
/*!40000 ALTER TABLE `liaisons_liaisonstatement` DISABLE KEYS */;
/*!40000 ALTER TABLE `liaisons_liaisonstatement` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `liaisons_liaisonstatement_from_groups`
--
DROP TABLE IF EXISTS `liaisons_liaisonstatement_from_groups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `liaisons_liaisonstatement_from_groups` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`liaisonstatement_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `liaisonstatement_id` (`liaisonstatement_id`,`group_id`),
KEY `liaisons_liaisonstatement_from_groups_0e939a4f` (`group_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1773 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `liaisons_liaisonstatement_from_groups`
--
LOCK TABLES `liaisons_liaisonstatement_from_groups` WRITE;
/*!40000 ALTER TABLE `liaisons_liaisonstatement_from_groups` DISABLE KEYS */;
/*!40000 ALTER TABLE `liaisons_liaisonstatement_from_groups` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `liaisons_liaisonstatement_tags`
--
DROP TABLE IF EXISTS `liaisons_liaisonstatement_tags`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `liaisons_liaisonstatement_tags` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`liaisonstatement_id` int(11) NOT NULL,
`liaisonstatementtagname_id` varchar(32) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `liaisonstatement_id` (`liaisonstatement_id`,`liaisonstatementtagname_id`),
KEY `liaisons_liaisonstatement_tags_e89c78a0` (`liaisonstatementtagname_id`)
) ENGINE=MyISAM AUTO_INCREMENT=595 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `liaisons_liaisonstatement_tags`
--
LOCK TABLES `liaisons_liaisonstatement_tags` WRITE;
/*!40000 ALTER TABLE `liaisons_liaisonstatement_tags` DISABLE KEYS */;
/*!40000 ALTER TABLE `liaisons_liaisonstatement_tags` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `liaisons_liaisonstatement_to_groups`
--
DROP TABLE IF EXISTS `liaisons_liaisonstatement_to_groups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `liaisons_liaisonstatement_to_groups` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`liaisonstatement_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `liaisonstatement_id` (`liaisonstatement_id`,`group_id`),
KEY `liaisons_liaisonstatement_to_groups_0e939a4f` (`group_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2339 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `liaisons_liaisonstatement_to_groups`
--
LOCK TABLES `liaisons_liaisonstatement_to_groups` WRITE;
/*!40000 ALTER TABLE `liaisons_liaisonstatement_to_groups` DISABLE KEYS */;
/*!40000 ALTER TABLE `liaisons_liaisonstatement_to_groups` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `liaisons_liaisonstatementattachment`
--
DROP TABLE IF EXISTS `liaisons_liaisonstatementattachment`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `liaisons_liaisonstatementattachment` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`removed` tinyint(1) NOT NULL,
`statement_id` int(11) NOT NULL,
`document_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `liaisons_liaisonstatementattachment_63757fd3` (`statement_id`),
KEY `liaisons_liaisonstatementattachment_document2_id_4947ea15` (`document_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1907 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `liaisons_liaisonstatementattachment`
--
LOCK TABLES `liaisons_liaisonstatementattachment` WRITE;
/*!40000 ALTER TABLE `liaisons_liaisonstatementattachment` DISABLE KEYS */;
/*!40000 ALTER TABLE `liaisons_liaisonstatementattachment` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `liaisons_liaisonstatementevent`
--
DROP TABLE IF EXISTS `liaisons_liaisonstatementevent`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `liaisons_liaisonstatementevent` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`time` datetime /* mariadb-5.3 */ NOT NULL,
`desc` longtext NOT NULL,
`by_id` int(11) NOT NULL,
`statement_id` int(11) NOT NULL,
`type_id` varchar(32) NOT NULL,
PRIMARY KEY (`id`),
KEY `liaisons_liaisonstatementevent_6940e846` (`by_id`),
KEY `liaisons_liaisonstatementevent_63757fd3` (`statement_id`),
KEY `liaisons_liaisonstatementevent_94757cae` (`type_id`),
KEY `liaisons_li_time_3e1646_idx` (`time`,`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3904 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `liaisons_liaisonstatementevent`
--
LOCK TABLES `liaisons_liaisonstatementevent` WRITE;
/*!40000 ALTER TABLE `liaisons_liaisonstatementevent` DISABLE KEYS */;
/*!40000 ALTER TABLE `liaisons_liaisonstatementevent` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `liaisons_relatedliaisonstatement`
--
DROP TABLE IF EXISTS `liaisons_relatedliaisonstatement`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `liaisons_relatedliaisonstatement` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`relationship_id` varchar(32) NOT NULL,
`source_id` int(11) NOT NULL,
`target_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `liaisons_relatedliaisonstatement_fad43076` (`relationship_id`),
KEY `liaisons_relatedliaisonstatement_0afd9202` (`source_id`),
KEY `liaisons_relatedliaisonstatement_55e2df16` (`target_id`)
) ENGINE=MyISAM AUTO_INCREMENT=206 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `liaisons_relatedliaisonstatement`
--
LOCK TABLES `liaisons_relatedliaisonstatement` WRITE;
/*!40000 ALTER TABLE `liaisons_relatedliaisonstatement` DISABLE KEYS */;
/*!40000 ALTER TABLE `liaisons_relatedliaisonstatement` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mailinglists_list`
--
DROP TABLE IF EXISTS `mailinglists_list`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mailinglists_list` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(32) NOT NULL,
`description` varchar(256) NOT NULL,
`advertised` tinyint(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10834 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mailinglists_list`
--
LOCK TABLES `mailinglists_list` WRITE;
/*!40000 ALTER TABLE `mailinglists_list` DISABLE KEYS */;
/*!40000 ALTER TABLE `mailinglists_list` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mailinglists_subscribed`
--
DROP TABLE IF EXISTS `mailinglists_subscribed`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mailinglists_subscribed` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`time` datetime NOT NULL,
`email` varchar(128) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=86195 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mailinglists_subscribed`
--
LOCK TABLES `mailinglists_subscribed` WRITE;
/*!40000 ALTER TABLE `mailinglists_subscribed` DISABLE KEYS */;
/*!40000 ALTER TABLE `mailinglists_subscribed` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mailinglists_subscribed_lists`
--
DROP TABLE IF EXISTS `mailinglists_subscribed_lists`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mailinglists_subscribed_lists` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`subscribed_id` int(11) NOT NULL,
`list_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `subscribed_id` (`subscribed_id`,`list_id`),
KEY `mailinglists_subscribed_lists_4da3e820` (`list_id`)
) ENGINE=MyISAM AUTO_INCREMENT=284036 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mailinglists_subscribed_lists`
--
LOCK TABLES `mailinglists_subscribed_lists` WRITE;
/*!40000 ALTER TABLE `mailinglists_subscribed_lists` DISABLE KEYS */;
/*!40000 ALTER TABLE `mailinglists_subscribed_lists` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mailinglists_whitelisted`
--
DROP TABLE IF EXISTS `mailinglists_whitelisted`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mailinglists_whitelisted` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`time` datetime NOT NULL,
`email` varchar(64) NOT NULL,
`by_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `mailinglists_whitelisted_6940e846` (`by_id`)
) ENGINE=MyISAM AUTO_INCREMENT=799 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mailinglists_whitelisted`
--
LOCK TABLES `mailinglists_whitelisted` WRITE;
/*!40000 ALTER TABLE `mailinglists_whitelisted` DISABLE KEYS */;
/*!40000 ALTER TABLE `mailinglists_whitelisted` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mailtrigger_mailtrigger`
--
DROP TABLE IF EXISTS `mailtrigger_mailtrigger`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mailtrigger_mailtrigger` (
`slug` varchar(64) NOT NULL,
`desc` longtext NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mailtrigger_mailtrigger`
--
LOCK TABLES `mailtrigger_mailtrigger` WRITE;
/*!40000 ALTER TABLE `mailtrigger_mailtrigger` DISABLE KEYS */;
/*!40000 ALTER TABLE `mailtrigger_mailtrigger` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mailtrigger_mailtrigger_cc`
--
DROP TABLE IF EXISTS `mailtrigger_mailtrigger_cc`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mailtrigger_mailtrigger_cc` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`mailtrigger_id` varchar(64) DEFAULT NULL,
`recipient_id` varchar(32) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `mailtrigger_id` (`mailtrigger_id`,`recipient_id`),
KEY `mailtrigger_mailtrigger_cc_8b938c66` (`recipient_id`)
) ENGINE=MyISAM AUTO_INCREMENT=274 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mailtrigger_mailtrigger_cc`
--
LOCK TABLES `mailtrigger_mailtrigger_cc` WRITE;
/*!40000 ALTER TABLE `mailtrigger_mailtrigger_cc` DISABLE KEYS */;
/*!40000 ALTER TABLE `mailtrigger_mailtrigger_cc` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mailtrigger_mailtrigger_to`
--
DROP TABLE IF EXISTS `mailtrigger_mailtrigger_to`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mailtrigger_mailtrigger_to` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`mailtrigger_id` varchar(64) DEFAULT NULL,
`recipient_id` varchar(32) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `mailtrigger_id` (`mailtrigger_id`,`recipient_id`),
KEY `mailtrigger_mailtrigger_to_8b938c66` (`recipient_id`)
) ENGINE=MyISAM AUTO_INCREMENT=261 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mailtrigger_mailtrigger_to`
--
LOCK TABLES `mailtrigger_mailtrigger_to` WRITE;
/*!40000 ALTER TABLE `mailtrigger_mailtrigger_to` DISABLE KEYS */;
/*!40000 ALTER TABLE `mailtrigger_mailtrigger_to` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mailtrigger_recipient`
--
DROP TABLE IF EXISTS `mailtrigger_recipient`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mailtrigger_recipient` (
`slug` varchar(32) NOT NULL,
`desc` longtext NOT NULL,
`template` longtext DEFAULT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mailtrigger_recipient`
--
LOCK TABLES `mailtrigger_recipient` WRITE;
/*!40000 ALTER TABLE `mailtrigger_recipient` DISABLE KEYS */;
/*!40000 ALTER TABLE `mailtrigger_recipient` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `meeting_attended`
--
DROP TABLE IF EXISTS `meeting_attended`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `meeting_attended` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`person_id` int(11) NOT NULL,
`session_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `meeting_attended_person_id_session_id_912d4af1_uniq` (`person_id`,`session_id`),
KEY `meeting_attended_person_id_7a96a8b9` (`person_id`),
KEY `meeting_attended_session_id_cc86f1b8` (`session_id`)
) ENGINE=MyISAM AUTO_INCREMENT=59824 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `meeting_attended`
--
LOCK TABLES `meeting_attended` WRITE;
/*!40000 ALTER TABLE `meeting_attended` DISABLE KEYS */;
/*!40000 ALTER TABLE `meeting_attended` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `meeting_businessconstraint`
--
DROP TABLE IF EXISTS `meeting_businessconstraint`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `meeting_businessconstraint` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`penalty` int(11) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `meeting_businessconstraint`
--
LOCK TABLES `meeting_businessconstraint` WRITE;
/*!40000 ALTER TABLE `meeting_businessconstraint` DISABLE KEYS */;
/*!40000 ALTER TABLE `meeting_businessconstraint` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `meeting_constraint`
--
DROP TABLE IF EXISTS `meeting_constraint`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `meeting_constraint` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`meeting_id` int(11) NOT NULL,
`source_id` int(11) NOT NULL,
`target_id` int(11),
`name_id` varchar(32) NOT NULL,
`person_id` int(11),
`time_relation` varchar(200) NOT NULL,
PRIMARY KEY (`id`),
KEY `meeting_constraint_784bb48` (`meeting_id`),
KEY `meeting_constraint_89f89e85` (`source_id`),
KEY `meeting_constraint_9358c897` (`target_id`),
KEY `meeting_constraint_632e075f` (`name_id`),
KEY `meeting_constraint_21b911c5` (`person_id`)
) ENGINE=MyISAM AUTO_INCREMENT=88412 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `meeting_constraint`
--
LOCK TABLES `meeting_constraint` WRITE;
/*!40000 ALTER TABLE `meeting_constraint` DISABLE KEYS */;
/*!40000 ALTER TABLE `meeting_constraint` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `meeting_constraint_timeranges`
--
DROP TABLE IF EXISTS `meeting_constraint_timeranges`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `meeting_constraint_timeranges` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`constraint_id` int(11) NOT NULL,
`timerangename_id` varchar(32) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `meeting_constraint_timer_constraint_id_timerangen_14c26090_uniq` (`constraint_id`,`timerangename_id`),
KEY `meeting_constraint_timeranges_timerangename_id_17b51398` (`timerangename_id`)
) ENGINE=MyISAM AUTO_INCREMENT=254 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `meeting_constraint_timeranges`
--
LOCK TABLES `meeting_constraint_timeranges` WRITE;
/*!40000 ALTER TABLE `meeting_constraint_timeranges` DISABLE KEYS */;
/*!40000 ALTER TABLE `meeting_constraint_timeranges` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `meeting_floorplan`
--
DROP TABLE IF EXISTS `meeting_floorplan`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `meeting_floorplan` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`order` smallint(6) NOT NULL,
`image` varchar(100) NOT NULL,
`meeting_id` int(11) NOT NULL,
`modified` datetime(6) NOT NULL,
`short` varchar(3) NOT NULL,
PRIMARY KEY (`id`),
KEY `meeting_floorplan_383440d3` (`meeting_id`)
) ENGINE=MyISAM AUTO_INCREMENT=92 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `meeting_floorplan`
--
LOCK TABLES `meeting_floorplan` WRITE;
/*!40000 ALTER TABLE `meeting_floorplan` DISABLE KEYS */;
/*!40000 ALTER TABLE `meeting_floorplan` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `meeting_importantdate`
--
DROP TABLE IF EXISTS `meeting_importantdate`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `meeting_importantdate` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`date` date NOT NULL,
`meeting_id` int(11) NOT NULL,
`name_id` varchar(32) NOT NULL,
PRIMARY KEY (`id`),
KEY `meeting_importantdate_383440d3` (`meeting_id`),
KEY `meeting_importantdate_3db78b68` (`name_id`)
) ENGINE=MyISAM AUTO_INCREMENT=526 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `meeting_importantdate`
--
LOCK TABLES `meeting_importantdate` WRITE;
/*!40000 ALTER TABLE `meeting_importantdate` DISABLE KEYS */;
/*!40000 ALTER TABLE `meeting_importantdate` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `meeting_meeting`
--
DROP TABLE IF EXISTS `meeting_meeting`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `meeting_meeting` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`number` varchar(64) NOT NULL,
`type_id` varchar(32) NOT NULL,
`date` date NOT NULL,
`city` varchar(255) NOT NULL,
`country` varchar(2) NOT NULL,
`time_zone` varchar(255) NOT NULL,
`venue_name` varchar(255) NOT NULL,
`venue_addr` longtext NOT NULL,
`break_area` varchar(255) NOT NULL,
`reg_area` varchar(255) NOT NULL,
`agenda_warning_note` longtext NOT NULL,
`schedule_id` int(11) DEFAULT NULL,
`session_request_lock_message` varchar(255) NOT NULL,
`idsubmit_cutoff_day_offset_00` int(11) NOT NULL,
`idsubmit_cutoff_day_offset_01` int(11) NOT NULL,
`submission_correction_day_offset` int(11) NOT NULL,
`submission_cutoff_day_offset` int(11) NOT NULL,
`submission_start_day_offset` int(11) NOT NULL,
`proceedings_final` tinyint(1) NOT NULL,
`acknowledgements` longtext NOT NULL,
`overview_id` int(11),
`idsubmit_cutoff_time_utc` bigint(20) NOT NULL,
`idsubmit_cutoff_warning_days` bigint(20) NOT NULL,
`days` int(11) NOT NULL,
`show_important_dates` tinyint(1) NOT NULL,
`attendees` int(11) DEFAULT NULL,
`agenda_info_note` longtext NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `number` (`number`),
KEY `meeting_meeting_777d41c8` (`type_id`),
KEY `meeting_meeting_77686b7a` (`schedule_id`),
KEY `meeting_meeting_144f0405` (`overview_id`),
KEY `meeting_mee_date_40ca21_idx` (`date`,`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1685 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `meeting_meeting`
--
LOCK TABLES `meeting_meeting` WRITE;
/*!40000 ALTER TABLE `meeting_meeting` DISABLE KEYS */;
/*!40000 ALTER TABLE `meeting_meeting` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `meeting_meeting_group_conflict_types`
--
DROP TABLE IF EXISTS `meeting_meeting_group_conflict_types`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `meeting_meeting_group_conflict_types` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`meeting_id` int(11) NOT NULL,
`constraintname_id` varchar(32) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `meeting_meeting_group_co_meeting_id_constraintnam_f2cfbbc1_uniq` (`meeting_id`,`constraintname_id`),
KEY `meeting_meeting_group_conflict_types_meeting_id_8149cf0b` (`meeting_id`),
KEY `meeting_meeting_group_conflict_types_constraintname_id_064db381` (`constraintname_id`)
) ENGINE=MyISAM AUTO_INCREMENT=349 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `meeting_meeting_group_conflict_types`
--
LOCK TABLES `meeting_meeting_group_conflict_types` WRITE;
/*!40000 ALTER TABLE `meeting_meeting_group_conflict_types` DISABLE KEYS */;
/*!40000 ALTER TABLE `meeting_meeting_group_conflict_types` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `meeting_meetinghost`
--
DROP TABLE IF EXISTS `meeting_meetinghost`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `meeting_meetinghost` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`logo` varchar(100) NOT NULL,
`logo_width` int(10) unsigned DEFAULT NULL,
`logo_height` int(10) unsigned DEFAULT NULL,
`meeting_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `meeting_meetinghost_meeting_id_name_fe48837d_uniq` (`meeting_id`,`name`),
KEY `meeting_meetinghost_meeting_id_55b0f944` (`meeting_id`)
) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `meeting_meetinghost`
--
LOCK TABLES `meeting_meetinghost` WRITE;
/*!40000 ALTER TABLE `meeting_meetinghost` DISABLE KEYS */;
/*!40000 ALTER TABLE `meeting_meetinghost` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `meeting_proceedingsmaterial`
--
DROP TABLE IF EXISTS `meeting_proceedingsmaterial`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `meeting_proceedingsmaterial` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`meeting_id` int(11) NOT NULL,
`type_id` varchar(32) NOT NULL,
`document_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `document_id` (`document_id`),
UNIQUE KEY `meeting_proceedingsmaterial_meeting_id_type_id_80df1bb9_uniq` (`meeting_id`,`type_id`),
KEY `meeting_proceedingsmaterial_meeting_id_56cf4e8a` (`meeting_id`),
KEY `meeting_proceedingsmaterial_type_id_ab5bab8c` (`type_id`)
) ENGINE=MyISAM AUTO_INCREMENT=49 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `meeting_proceedingsmaterial`
--
LOCK TABLES `meeting_proceedingsmaterial` WRITE;
/*!40000 ALTER TABLE `meeting_proceedingsmaterial` DISABLE KEYS */;
/*!40000 ALTER TABLE `meeting_proceedingsmaterial` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `meeting_resourceassociation`
--
DROP TABLE IF EXISTS `meeting_resourceassociation`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `meeting_resourceassociation` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name_id` varchar(32) NOT NULL,
`icon` varchar(64) NOT NULL,
`desc` varchar(256) NOT NULL,
PRIMARY KEY (`id`),
KEY `meeting_resourceassociation_4da47e07` (`name_id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `meeting_resourceassociation`
--
LOCK TABLES `meeting_resourceassociation` WRITE;
/*!40000 ALTER TABLE `meeting_resourceassociation` DISABLE KEYS */;
/*!40000 ALTER TABLE `meeting_resourceassociation` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `meeting_room`
--
DROP TABLE IF EXISTS `meeting_room`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `meeting_room` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`meeting_id` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
`capacity` int(11),
`functional_name` varchar(255) NOT NULL,
`floorplan_id` int(11) DEFAULT NULL,
`x1` smallint(6) DEFAULT NULL,
`x2` smallint(6) DEFAULT NULL,
`y1` smallint(6) DEFAULT NULL,
`y2` smallint(6) DEFAULT NULL,
`modified` datetime(6) NOT NULL,
PRIMARY KEY (`id`),
KEY `meeting_room_784bb48` (`meeting_id`),
KEY `meeting_room_ca5a5fcf` (`floorplan_id`)
) ENGINE=MyISAM AUTO_INCREMENT=850 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `meeting_room`
--
LOCK TABLES `meeting_room` WRITE;
/*!40000 ALTER TABLE `meeting_room` DISABLE KEYS */;
/*!40000 ALTER TABLE `meeting_room` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `meeting_room_resources`
--
DROP TABLE IF EXISTS `meeting_room_resources`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `meeting_room_resources` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`room_id` int(11) NOT NULL,
`resourceassociation_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `meeting_room_resources_room_id_36e4198d82c3a188_uniq` (`room_id`,`resourceassociation_id`),
KEY `meeting_room_resources_fbc7c5ba` (`resourceassociation_id`)
) ENGINE=MyISAM AUTO_INCREMENT=123 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `meeting_room_resources`
--
LOCK TABLES `meeting_room_resources` WRITE;
/*!40000 ALTER TABLE `meeting_room_resources` DISABLE KEYS */;
/*!40000 ALTER TABLE `meeting_room_resources` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `meeting_room_session_types`
--
DROP TABLE IF EXISTS `meeting_room_session_types`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `meeting_room_session_types` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`room_id` int(11) NOT NULL,
`timeslottypename_id` varchar(32) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `room_id` (`room_id`,`timeslottypename_id`),
KEY `meeting_room_session_types_1e76b1b0` (`timeslottypename_id`)
) ENGINE=MyISAM AUTO_INCREMENT=888 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `meeting_room_session_types`
--
LOCK TABLES `meeting_room_session_types` WRITE;
/*!40000 ALTER TABLE `meeting_room_session_types` DISABLE KEYS */;
/*!40000 ALTER TABLE `meeting_room_session_types` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `meeting_schedtimesessassignment`
--
DROP TABLE IF EXISTS `meeting_schedtimesessassignment`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `meeting_schedtimesessassignment` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`timeslot_id` int(11) NOT NULL,
`session_id` int(11),
`schedule_id` int(11) NOT NULL,
`notes` longtext NOT NULL,
`modified` datetime /* mariadb-5.3 */ NOT NULL,
`extendedfrom_id` int(11) DEFAULT NULL,
`badness` int(11),
`pinned` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
KEY `meeting_scheduledsession_c36ced57` (`timeslot_id`),
KEY `meeting_scheduledsession_6b4dc4c3` (`session_id`),
KEY `meeting_scheduledsession_10d3e039` (`schedule_id`),
KEY `meeting_scheduledsession_10486051` (`extendedfrom_id`)
) ENGINE=MyISAM AUTO_INCREMENT=106096 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `meeting_schedtimesessassignment`
--
LOCK TABLES `meeting_schedtimesessassignment` WRITE;
/*!40000 ALTER TABLE `meeting_schedtimesessassignment` DISABLE KEYS */;
/*!40000 ALTER TABLE `meeting_schedtimesessassignment` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `meeting_schedule`
--
DROP TABLE IF EXISTS `meeting_schedule`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `meeting_schedule` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(64) NOT NULL,
`owner_id` int(11) NOT NULL,
`visible` tinyint(1) NOT NULL DEFAULT 1,
`public` tinyint(1) NOT NULL DEFAULT 1,
`meeting_id` int(11),
`badness` int(11),
`notes` longtext NOT NULL,
`origin_id` int(11) DEFAULT NULL,
`base_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `meeting_schedule_5d52dd10` (`owner_id`),
KEY `meeting_schedule_784bb48` (`meeting_id`),
KEY `meeting_schedule_origin_id_0c287cc7` (`origin_id`),
KEY `meeting_schedule_base_id_206bce41` (`base_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1975 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `meeting_schedule`
--
LOCK TABLES `meeting_schedule` WRITE;
/*!40000 ALTER TABLE `meeting_schedule` DISABLE KEYS */;
/*!40000 ALTER TABLE `meeting_schedule` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `meeting_schedulingevent`
--
DROP TABLE IF EXISTS `meeting_schedulingevent`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `meeting_schedulingevent` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`time` datetime(6) NOT NULL,
`by_id` int(11) NOT NULL,
`session_id` int(11) NOT NULL,
`status_id` varchar(32) NOT NULL,
PRIMARY KEY (`id`),
KEY `meeting_schedulingevent_by_id_02cc76e8` (`by_id`),
KEY `meeting_schedulingevent_session_id_6871cf75` (`session_id`),
KEY `meeting_schedulingevent_status_id_59de6612` (`status_id`)
) ENGINE=MyISAM AUTO_INCREMENT=19237 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `meeting_schedulingevent`
--
LOCK TABLES `meeting_schedulingevent` WRITE;
/*!40000 ALTER TABLE `meeting_schedulingevent` DISABLE KEYS */;
/*!40000 ALTER TABLE `meeting_schedulingevent` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `meeting_session`
--
DROP TABLE IF EXISTS `meeting_session`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `meeting_session` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`meeting_id` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
`group_id` int(11) NOT NULL,
`attendees` int(11) DEFAULT NULL,
`agenda_note` varchar(255) NOT NULL,
`comments` longtext NOT NULL,
`scheduled` datetime DEFAULT NULL,
`modified` datetime NOT NULL,
`short` varchar(32) NOT NULL,
`type_id` varchar(32) NOT NULL,
`remote_instructions` varchar(1024) NOT NULL,
`requested_duration` bigint(20) NOT NULL,
`tombstone_for_id` int(11) DEFAULT NULL,
`purpose_id` varchar(32) NOT NULL,
`on_agenda` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
KEY `meeting_session_784bb48` (`meeting_id`),
KEY `meeting_session_bda51c3c` (`group_id`),
KEY `meeting_session_94757cae` (`type_id`),
KEY `meeting_session_tombstone_for_id_f2ec3570` (`tombstone_for_id`),
KEY `meeting_session_purpose_id_689d3830` (`purpose_id`)
) ENGINE=MyISAM AUTO_INCREMENT=29800 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `meeting_session`
--
LOCK TABLES `meeting_session` WRITE;
/*!40000 ALTER TABLE `meeting_session` DISABLE KEYS */;
/*!40000 ALTER TABLE `meeting_session` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `meeting_session_joint_with_groups`
--
DROP TABLE IF EXISTS `meeting_session_joint_with_groups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `meeting_session_joint_with_groups` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`session_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `meeting_session_joint_wi_session_id_group_id_6a5335b1_uniq` (`session_id`,`group_id`),
KEY `meeting_session_joint_with_groups_group_id_7df47655` (`group_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `meeting_session_joint_with_groups`
--
LOCK TABLES `meeting_session_joint_with_groups` WRITE;
/*!40000 ALTER TABLE `meeting_session_joint_with_groups` DISABLE KEYS */;
/*!40000 ALTER TABLE `meeting_session_joint_with_groups` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `meeting_session_materials`
--
DROP TABLE IF EXISTS `meeting_session_materials`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `meeting_session_materials` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`session_id` int(11) NOT NULL,
`rev` varchar(16) DEFAULT NULL,
`order` smallint(5) unsigned NOT NULL,
`document_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `meeting_session_materials_session_id_document_id_e0171500_uniq` (`session_id`,`document_id`),
KEY `meeting_session_materials_document2_id_d14037fb` (`document_id`)
) ENGINE=MyISAM AUTO_INCREMENT=72759 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `meeting_session_materials`
--
LOCK TABLES `meeting_session_materials` WRITE;
/*!40000 ALTER TABLE `meeting_session_materials` DISABLE KEYS */;
/*!40000 ALTER TABLE `meeting_session_materials` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `meeting_session_resources`
--
DROP TABLE IF EXISTS `meeting_session_resources`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `meeting_session_resources` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`session_id` int(11) NOT NULL,
`resourceassociation_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `meeting_session_resources_session_id_1afa5e860e98e4f4_uniq` (`session_id`,`resourceassociation_id`),
KEY `meeting_session_resources_fbc7c5ba` (`resourceassociation_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1125 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `meeting_session_resources`
--
LOCK TABLES `meeting_session_resources` WRITE;
/*!40000 ALTER TABLE `meeting_session_resources` DISABLE KEYS */;
/*!40000 ALTER TABLE `meeting_session_resources` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `meeting_slidesubmission`
--
DROP TABLE IF EXISTS `meeting_slidesubmission`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `meeting_slidesubmission` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL,
`filename` varchar(255) NOT NULL,
`apply_to_all` tinyint(1) NOT NULL,
`session_id` int(11) NOT NULL,
`submitter_id` int(11) NOT NULL,
`time` datetime(6) NOT NULL,
`doc_id` int(11) DEFAULT NULL,
`status_id` varchar(32),
PRIMARY KEY (`id`),
KEY `meeting_slidesubmission_session_id_022ea4fe` (`session_id`),
KEY `meeting_slidesubmission_submitter_id_2e34f06b` (`submitter_id`),
KEY `meeting_slidesubmission_doc_id_6bbb9d51` (`doc_id`),
KEY `meeting_slidesubmission_status_id_d9dac7ab` (`status_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2371 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `meeting_slidesubmission`
--
LOCK TABLES `meeting_slidesubmission` WRITE;
/*!40000 ALTER TABLE `meeting_slidesubmission` DISABLE KEYS */;
/*!40000 ALTER TABLE `meeting_slidesubmission` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `meeting_timeslot`
--
DROP TABLE IF EXISTS `meeting_timeslot`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `meeting_timeslot` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`meeting_id` int(11) NOT NULL,
`type_id` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`time` datetime NOT NULL,
`location_id` int(11) DEFAULT NULL,
`show_location` tinyint(1) NOT NULL,
`modified` datetime NOT NULL,
`duration` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `meeting_timeslot_784bb48` (`meeting_id`),
KEY `meeting_timeslot_777d41c8` (`type_id`),
KEY `meeting_timeslot_319d859` (`location_id`),
KEY `meeting_tim_time_b802cb_idx` (`time`,`id`)
) ENGINE=MyISAM AUTO_INCREMENT=14652 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `meeting_timeslot`
--
LOCK TABLES `meeting_timeslot` WRITE;
/*!40000 ALTER TABLE `meeting_timeslot` DISABLE KEYS */;
/*!40000 ALTER TABLE `meeting_timeslot` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `meeting_urlresource`
--
DROP TABLE IF EXISTS `meeting_urlresource`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `meeting_urlresource` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`url` varchar(200) DEFAULT NULL,
`name_id` varchar(32) NOT NULL,
`room_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `meeting_urlresource_3db78b68` (`name_id`),
KEY `meeting_urlresource_8273f993` (`room_id`)
) ENGINE=MyISAM AUTO_INCREMENT=405 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `meeting_urlresource`
--
LOCK TABLES `meeting_urlresource` WRITE;
/*!40000 ALTER TABLE `meeting_urlresource` DISABLE KEYS */;
/*!40000 ALTER TABLE `meeting_urlresource` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `message_announcementfrom`
--
DROP TABLE IF EXISTS `message_announcementfrom`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `message_announcementfrom` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`address` varchar(255) NOT NULL,
`group_id` int(11) NOT NULL,
`name_id` varchar(32) NOT NULL,
PRIMARY KEY (`id`),
KEY `message_announcementfrom_0e939a4f` (`group_id`),
KEY `message_announcementfrom_3db78b68` (`name_id`)
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `message_announcementfrom`
--
LOCK TABLES `message_announcementfrom` WRITE;
/*!40000 ALTER TABLE `message_announcementfrom` DISABLE KEYS */;
/*!40000 ALTER TABLE `message_announcementfrom` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `message_message`
--
DROP TABLE IF EXISTS `message_message`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `message_message` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`time` datetime NOT NULL,
`by_id` int(11) NOT NULL,
`subject` varchar(255) NOT NULL,
`frm` varchar(255) NOT NULL,
`to` varchar(1024) NOT NULL,
`cc` varchar(1024) NOT NULL,
`bcc` varchar(255) NOT NULL,
`reply_to` varchar(255) NOT NULL,
`body` longtext NOT NULL,
`content_type` varchar(255) NOT NULL,
`msgid` varchar(255),
`sent` datetime(6) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `message_message_3acff7b7` (`by_id`),
KEY `message_mes_time_20eabf_idx` (`time`)
) ENGINE=MyISAM AUTO_INCREMENT=508491 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `message_message`
--
LOCK TABLES `message_message` WRITE;
/*!40000 ALTER TABLE `message_message` DISABLE KEYS */;
/*!40000 ALTER TABLE `message_message` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `message_message_related_docs`
--
DROP TABLE IF EXISTS `message_message_related_docs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `message_message_related_docs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`message_id` int(11) NOT NULL,
`document_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `message_message_related__message_id_document_id_f5445085_uniq` (`message_id`,`document_id`),
KEY `message_message_related_docs_document_id_63bab4b6` (`document_id`)
) ENGINE=MyISAM AUTO_INCREMENT=23013 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `message_message_related_docs`
--
LOCK TABLES `message_message_related_docs` WRITE;
/*!40000 ALTER TABLE `message_message_related_docs` DISABLE KEYS */;
/*!40000 ALTER TABLE `message_message_related_docs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `message_message_related_groups`
--
DROP TABLE IF EXISTS `message_message_related_groups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `message_message_related_groups` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`message_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `message_id` (`message_id`,`group_id`),
KEY `group_id_refs_id_42b58143` (`group_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7533 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `message_message_related_groups`
--
LOCK TABLES `message_message_related_groups` WRITE;
/*!40000 ALTER TABLE `message_message_related_groups` DISABLE KEYS */;
/*!40000 ALTER TABLE `message_message_related_groups` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `message_messageattachment`
--
DROP TABLE IF EXISTS `message_messageattachment`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `message_messageattachment` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`filename` varchar(255) NOT NULL,
`content_type` varchar(255) NOT NULL,
`encoding` varchar(255) NOT NULL,
`removed` tinyint(1) NOT NULL,
`body` longtext NOT NULL,
`message_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `message_messageattachment_435ed7e9` (`filename`),
KEY `message_messageattachment_4ccaa172` (`message_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `message_messageattachment`
--
LOCK TABLES `message_messageattachment` WRITE;
/*!40000 ALTER TABLE `message_messageattachment` DISABLE KEYS */;
/*!40000 ALTER TABLE `message_messageattachment` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `message_sendqueue`
--
DROP TABLE IF EXISTS `message_sendqueue`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `message_sendqueue` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`time` datetime /* mariadb-5.3 */ NOT NULL,
`by_id` int(11) NOT NULL,
`message_id` int(11) NOT NULL,
`send_at` datetime /* mariadb-5.3 */ DEFAULT NULL,
`sent_at` datetime /* mariadb-5.3 */ DEFAULT NULL,
`note` longtext NOT NULL,
PRIMARY KEY (`id`),
KEY `message_sendqueue_3acff7b7` (`by_id`),
KEY `message_sendqueue_38373776` (`message_id`),
KEY `message_sen_time_07ab31_idx` (`time`)
) ENGINE=MyISAM AUTO_INCREMENT=43978 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `message_sendqueue`
--
LOCK TABLES `message_sendqueue` WRITE;
/*!40000 ALTER TABLE `message_sendqueue` DISABLE KEYS */;
/*!40000 ALTER TABLE `message_sendqueue` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_agendafiltertypename`
--
DROP TABLE IF EXISTS `name_agendafiltertypename`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_agendafiltertypename` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_agendafiltertypename`
--
LOCK TABLES `name_agendafiltertypename` WRITE;
/*!40000 ALTER TABLE `name_agendafiltertypename` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_agendafiltertypename` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_agendatypename`
--
DROP TABLE IF EXISTS `name_agendatypename`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_agendatypename` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_agendatypename`
--
LOCK TABLES `name_agendatypename` WRITE;
/*!40000 ALTER TABLE `name_agendatypename` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_agendatypename` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_ballotpositionname`
--
DROP TABLE IF EXISTS `name_ballotpositionname`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_ballotpositionname` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
`blocking` tinyint(1) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_ballotpositionname`
--
LOCK TABLES `name_ballotpositionname` WRITE;
/*!40000 ALTER TABLE `name_ballotpositionname` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_ballotpositionname` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_constraintname`
--
DROP TABLE IF EXISTS `name_constraintname`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_constraintname` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
`penalty` int(11) NOT NULL,
`is_group_conflict` tinyint(1) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_constraintname`
--
LOCK TABLES `name_constraintname` WRITE;
/*!40000 ALTER TABLE `name_constraintname` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_constraintname` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_continentname`
--
DROP TABLE IF EXISTS `name_continentname`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_continentname` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_continentname`
--
LOCK TABLES `name_continentname` WRITE;
/*!40000 ALTER TABLE `name_continentname` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_continentname` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_countryname`
--
DROP TABLE IF EXISTS `name_countryname`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_countryname` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
`in_eu` tinyint(1) NOT NULL,
`continent_id` varchar(32) NOT NULL,
PRIMARY KEY (`slug`),
KEY `name_countryname_071e6d87` (`continent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_countryname`
--
LOCK TABLES `name_countryname` WRITE;
/*!40000 ALTER TABLE `name_countryname` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_countryname` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_dbtemplatetypename`
--
DROP TABLE IF EXISTS `name_dbtemplatetypename`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_dbtemplatetypename` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL DEFAULT 1,
`order` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_dbtemplatetypename`
--
LOCK TABLES `name_dbtemplatetypename` WRITE;
/*!40000 ALTER TABLE `name_dbtemplatetypename` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_dbtemplatetypename` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_docrelationshipname`
--
DROP TABLE IF EXISTS `name_docrelationshipname`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_docrelationshipname` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
`revname` varchar(255) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_docrelationshipname`
--
LOCK TABLES `name_docrelationshipname` WRITE;
/*!40000 ALTER TABLE `name_docrelationshipname` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_docrelationshipname` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_docremindertypename`
--
DROP TABLE IF EXISTS `name_docremindertypename`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_docremindertypename` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_docremindertypename`
--
LOCK TABLES `name_docremindertypename` WRITE;
/*!40000 ALTER TABLE `name_docremindertypename` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_docremindertypename` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_doctagname`
--
DROP TABLE IF EXISTS `name_doctagname`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_doctagname` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_doctagname`
--
LOCK TABLES `name_doctagname` WRITE;
/*!40000 ALTER TABLE `name_doctagname` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_doctagname` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_doctypename`
--
DROP TABLE IF EXISTS `name_doctypename`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_doctypename` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
`prefix` varchar(16) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_doctypename`
--
LOCK TABLES `name_doctypename` WRITE;
/*!40000 ALTER TABLE `name_doctypename` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_doctypename` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_docurltagname`
--
DROP TABLE IF EXISTS `name_docurltagname`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_docurltagname` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_docurltagname`
--
LOCK TABLES `name_docurltagname` WRITE;
/*!40000 ALTER TABLE `name_docurltagname` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_docurltagname` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_draftsubmissionstatename`
--
DROP TABLE IF EXISTS `name_draftsubmissionstatename`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_draftsubmissionstatename` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL DEFAULT 1,
`order` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_draftsubmissionstatename`
--
LOCK TABLES `name_draftsubmissionstatename` WRITE;
/*!40000 ALTER TABLE `name_draftsubmissionstatename` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_draftsubmissionstatename` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_draftsubmissionstatename_next_states`
--
DROP TABLE IF EXISTS `name_draftsubmissionstatename_next_states`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_draftsubmissionstatename_next_states` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`from_draftsubmissionstatename_id` varchar(32) DEFAULT NULL,
`to_draftsubmissionstatename_id` varchar(32) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name_draft_from_draftsubmissionstatename_id_ceae8cdb14b8be_uniq` (`from_draftsubmissionstatename_id`,`to_draftsubmissionstatename_id`),
KEY `name_draftsubmissionstatename_next_states_b07ebca0` (`to_draftsubmissionstatename_id`)
) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_draftsubmissionstatename_next_states`
--
LOCK TABLES `name_draftsubmissionstatename_next_states` WRITE;
/*!40000 ALTER TABLE `name_draftsubmissionstatename_next_states` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_draftsubmissionstatename_next_states` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_extresourcename`
--
DROP TABLE IF EXISTS `name_extresourcename`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_extresourcename` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
`type_id` varchar(32) NOT NULL,
PRIMARY KEY (`slug`),
KEY `name_extresourcename_type_id_7e372eb4` (`type_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_extresourcename`
--
LOCK TABLES `name_extresourcename` WRITE;
/*!40000 ALTER TABLE `name_extresourcename` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_extresourcename` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_extresourcetypename`
--
DROP TABLE IF EXISTS `name_extresourcetypename`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_extresourcetypename` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_extresourcetypename`
--
LOCK TABLES `name_extresourcetypename` WRITE;
/*!40000 ALTER TABLE `name_extresourcetypename` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_extresourcetypename` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_feedbacktypename`
--
DROP TABLE IF EXISTS `name_feedbacktypename`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_feedbacktypename` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL DEFAULT 1,
`order` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_feedbacktypename`
--
LOCK TABLES `name_feedbacktypename` WRITE;
/*!40000 ALTER TABLE `name_feedbacktypename` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_feedbacktypename` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_formallanguagename`
--
DROP TABLE IF EXISTS `name_formallanguagename`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_formallanguagename` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_formallanguagename`
--
LOCK TABLES `name_formallanguagename` WRITE;
/*!40000 ALTER TABLE `name_formallanguagename` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_formallanguagename` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_groupmilestonestatename`
--
DROP TABLE IF EXISTS `name_groupmilestonestatename`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_groupmilestonestatename` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL DEFAULT 1,
`order` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_groupmilestonestatename`
--
LOCK TABLES `name_groupmilestonestatename` WRITE;
/*!40000 ALTER TABLE `name_groupmilestonestatename` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_groupmilestonestatename` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_groupstatename`
--
DROP TABLE IF EXISTS `name_groupstatename`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_groupstatename` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_groupstatename`
--
LOCK TABLES `name_groupstatename` WRITE;
/*!40000 ALTER TABLE `name_groupstatename` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_groupstatename` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_grouptypename`
--
DROP TABLE IF EXISTS `name_grouptypename`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_grouptypename` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
`verbose_name` varchar(255) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_grouptypename`
--
LOCK TABLES `name_grouptypename` WRITE;
/*!40000 ALTER TABLE `name_grouptypename` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_grouptypename` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_importantdatename`
--
DROP TABLE IF EXISTS `name_importantdatename`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_importantdatename` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
`default_offset_days` smallint(6) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_importantdatename`
--
LOCK TABLES `name_importantdatename` WRITE;
/*!40000 ALTER TABLE `name_importantdatename` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_importantdatename` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_intendedstdlevelname`
--
DROP TABLE IF EXISTS `name_intendedstdlevelname`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_intendedstdlevelname` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_intendedstdlevelname`
--
LOCK TABLES `name_intendedstdlevelname` WRITE;
/*!40000 ALTER TABLE `name_intendedstdlevelname` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_intendedstdlevelname` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_iprdisclosurestatename`
--
DROP TABLE IF EXISTS `name_iprdisclosurestatename`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_iprdisclosurestatename` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_iprdisclosurestatename`
--
LOCK TABLES `name_iprdisclosurestatename` WRITE;
/*!40000 ALTER TABLE `name_iprdisclosurestatename` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_iprdisclosurestatename` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_ipreventtypename`
--
DROP TABLE IF EXISTS `name_ipreventtypename`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_ipreventtypename` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_ipreventtypename`
--
LOCK TABLES `name_ipreventtypename` WRITE;
/*!40000 ALTER TABLE `name_ipreventtypename` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_ipreventtypename` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_iprlicensetypename`
--
DROP TABLE IF EXISTS `name_iprlicensetypename`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_iprlicensetypename` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_iprlicensetypename`
--
LOCK TABLES `name_iprlicensetypename` WRITE;
/*!40000 ALTER TABLE `name_iprlicensetypename` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_iprlicensetypename` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_liaisonstatementeventtypename`
--
DROP TABLE IF EXISTS `name_liaisonstatementeventtypename`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_liaisonstatementeventtypename` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_liaisonstatementeventtypename`
--
LOCK TABLES `name_liaisonstatementeventtypename` WRITE;
/*!40000 ALTER TABLE `name_liaisonstatementeventtypename` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_liaisonstatementeventtypename` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_liaisonstatementpurposename`
--
DROP TABLE IF EXISTS `name_liaisonstatementpurposename`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_liaisonstatementpurposename` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_liaisonstatementpurposename`
--
LOCK TABLES `name_liaisonstatementpurposename` WRITE;
/*!40000 ALTER TABLE `name_liaisonstatementpurposename` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_liaisonstatementpurposename` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_liaisonstatementstate`
--
DROP TABLE IF EXISTS `name_liaisonstatementstate`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_liaisonstatementstate` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_liaisonstatementstate`
--
LOCK TABLES `name_liaisonstatementstate` WRITE;
/*!40000 ALTER TABLE `name_liaisonstatementstate` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_liaisonstatementstate` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_liaisonstatementtagname`
--
DROP TABLE IF EXISTS `name_liaisonstatementtagname`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_liaisonstatementtagname` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_liaisonstatementtagname`
--
LOCK TABLES `name_liaisonstatementtagname` WRITE;
/*!40000 ALTER TABLE `name_liaisonstatementtagname` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_liaisonstatementtagname` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_meetingtypename`
--
DROP TABLE IF EXISTS `name_meetingtypename`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_meetingtypename` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_meetingtypename`
--
LOCK TABLES `name_meetingtypename` WRITE;
/*!40000 ALTER TABLE `name_meetingtypename` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_meetingtypename` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_nomineepositionstatename`
--
DROP TABLE IF EXISTS `name_nomineepositionstatename`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_nomineepositionstatename` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_nomineepositionstatename`
--
LOCK TABLES `name_nomineepositionstatename` WRITE;
/*!40000 ALTER TABLE `name_nomineepositionstatename` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_nomineepositionstatename` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_proceedingsmaterialtypename`
--
DROP TABLE IF EXISTS `name_proceedingsmaterialtypename`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_proceedingsmaterialtypename` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_proceedingsmaterialtypename`
--
LOCK TABLES `name_proceedingsmaterialtypename` WRITE;
/*!40000 ALTER TABLE `name_proceedingsmaterialtypename` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_proceedingsmaterialtypename` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_reviewassignmentstatename`
--
DROP TABLE IF EXISTS `name_reviewassignmentstatename`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_reviewassignmentstatename` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_reviewassignmentstatename`
--
LOCK TABLES `name_reviewassignmentstatename` WRITE;
/*!40000 ALTER TABLE `name_reviewassignmentstatename` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_reviewassignmentstatename` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_reviewerqueuepolicyname`
--
DROP TABLE IF EXISTS `name_reviewerqueuepolicyname`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_reviewerqueuepolicyname` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_reviewerqueuepolicyname`
--
LOCK TABLES `name_reviewerqueuepolicyname` WRITE;
/*!40000 ALTER TABLE `name_reviewerqueuepolicyname` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_reviewerqueuepolicyname` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_reviewrequeststatename`
--
DROP TABLE IF EXISTS `name_reviewrequeststatename`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_reviewrequeststatename` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_reviewrequeststatename`
--
LOCK TABLES `name_reviewrequeststatename` WRITE;
/*!40000 ALTER TABLE `name_reviewrequeststatename` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_reviewrequeststatename` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_reviewresultname`
--
DROP TABLE IF EXISTS `name_reviewresultname`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_reviewresultname` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_reviewresultname`
--
LOCK TABLES `name_reviewresultname` WRITE;
/*!40000 ALTER TABLE `name_reviewresultname` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_reviewresultname` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_reviewtypename`
--
DROP TABLE IF EXISTS `name_reviewtypename`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_reviewtypename` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_reviewtypename`
--
LOCK TABLES `name_reviewtypename` WRITE;
/*!40000 ALTER TABLE `name_reviewtypename` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_reviewtypename` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_rolename`
--
DROP TABLE IF EXISTS `name_rolename`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_rolename` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_rolename`
--
LOCK TABLES `name_rolename` WRITE;
/*!40000 ALTER TABLE `name_rolename` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_rolename` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_roomresourcename`
--
DROP TABLE IF EXISTS `name_roomresourcename`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_roomresourcename` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_roomresourcename`
--
LOCK TABLES `name_roomresourcename` WRITE;
/*!40000 ALTER TABLE `name_roomresourcename` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_roomresourcename` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_sessionpurposename`
--
DROP TABLE IF EXISTS `name_sessionpurposename`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_sessionpurposename` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
`timeslot_types` longtext NOT NULL,
`on_agenda` tinyint(1) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_sessionpurposename`
--
LOCK TABLES `name_sessionpurposename` WRITE;
/*!40000 ALTER TABLE `name_sessionpurposename` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_sessionpurposename` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_sessionstatusname`
--
DROP TABLE IF EXISTS `name_sessionstatusname`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_sessionstatusname` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_sessionstatusname`
--
LOCK TABLES `name_sessionstatusname` WRITE;
/*!40000 ALTER TABLE `name_sessionstatusname` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_sessionstatusname` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_slidesubmissionstatusname`
--
DROP TABLE IF EXISTS `name_slidesubmissionstatusname`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_slidesubmissionstatusname` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_slidesubmissionstatusname`
--
LOCK TABLES `name_slidesubmissionstatusname` WRITE;
/*!40000 ALTER TABLE `name_slidesubmissionstatusname` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_slidesubmissionstatusname` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_stdlevelname`
--
DROP TABLE IF EXISTS `name_stdlevelname`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_stdlevelname` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_stdlevelname`
--
LOCK TABLES `name_stdlevelname` WRITE;
/*!40000 ALTER TABLE `name_stdlevelname` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_stdlevelname` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_streamname`
--
DROP TABLE IF EXISTS `name_streamname`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_streamname` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_streamname`
--
LOCK TABLES `name_streamname` WRITE;
/*!40000 ALTER TABLE `name_streamname` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_streamname` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_timerangename`
--
DROP TABLE IF EXISTS `name_timerangename`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_timerangename` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_timerangename`
--
LOCK TABLES `name_timerangename` WRITE;
/*!40000 ALTER TABLE `name_timerangename` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_timerangename` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_timeslottypename`
--
DROP TABLE IF EXISTS `name_timeslottypename`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_timeslottypename` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_timeslottypename`
--
LOCK TABLES `name_timeslottypename` WRITE;
/*!40000 ALTER TABLE `name_timeslottypename` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_timeslottypename` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `name_topicaudiencename`
--
DROP TABLE IF EXISTS `name_topicaudiencename`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name_topicaudiencename` (
`slug` varchar(32) NOT NULL,
`name` varchar(255) NOT NULL,
`desc` longtext NOT NULL,
`used` tinyint(1) NOT NULL,
`order` int(11) NOT NULL,
PRIMARY KEY (`slug`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `name_topicaudiencename`
--
LOCK TABLES `name_topicaudiencename` WRITE;
/*!40000 ALTER TABLE `name_topicaudiencename` DISABLE KEYS */;
/*!40000 ALTER TABLE `name_topicaudiencename` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nomcom_feedback`
--
DROP TABLE IF EXISTS `nomcom_feedback`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nomcom_feedback` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nomcom_id` int(11) NOT NULL,
`author` varchar(254) NOT NULL,
`comments` longblob NOT NULL,
`type_id` varchar(32),
`user_id` int(11) DEFAULT NULL,
`time` datetime NOT NULL,
`subject` longtext NOT NULL,
PRIMARY KEY (`id`),
KEY `nomcom_feedback_82eb091d` (`nomcom_id`),
KEY `nomcom_feedback_777d41c8` (`type_id`),
KEY `nomcom_feedback_fbfc09f1` (`user_id`),
KEY `nomcom_feed_time_35cf38_idx` (`time`)
) ENGINE=MyISAM AUTO_INCREMENT=14582 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nomcom_feedback`
--
LOCK TABLES `nomcom_feedback` WRITE;
/*!40000 ALTER TABLE `nomcom_feedback` DISABLE KEYS */;
/*!40000 ALTER TABLE `nomcom_feedback` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nomcom_feedback_nominees`
--
DROP TABLE IF EXISTS `nomcom_feedback_nominees`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nomcom_feedback_nominees` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`feedback_id` int(11) NOT NULL,
`nominee_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `nomcom_feedback_nominees_feedback_id_3b804ef6bf94b5eb_uniq` (`feedback_id`,`nominee_id`),
KEY `nomcom_feedback_nominees_2b1dcb5e` (`nominee_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9655 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nomcom_feedback_nominees`
--
LOCK TABLES `nomcom_feedback_nominees` WRITE;
/*!40000 ALTER TABLE `nomcom_feedback_nominees` DISABLE KEYS */;
/*!40000 ALTER TABLE `nomcom_feedback_nominees` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nomcom_feedback_positions`
--
DROP TABLE IF EXISTS `nomcom_feedback_positions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nomcom_feedback_positions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`feedback_id` int(11) NOT NULL,
`position_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `nomcom_feedback_positions_feedback_id_4ec413276f1df471_uniq` (`feedback_id`,`position_id`),
KEY `nomcom_feedback_positions_80180135` (`position_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9505 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nomcom_feedback_positions`
--
LOCK TABLES `nomcom_feedback_positions` WRITE;
/*!40000 ALTER TABLE `nomcom_feedback_positions` DISABLE KEYS */;
/*!40000 ALTER TABLE `nomcom_feedback_positions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nomcom_feedback_topics`
--
DROP TABLE IF EXISTS `nomcom_feedback_topics`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nomcom_feedback_topics` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`feedback_id` int(11) NOT NULL,
`topic_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `nomcom_feedback_topics_feedback_id_c676ff7f_uniq` (`feedback_id`,`topic_id`),
KEY `nomcom_feedback_topics_19b4d727` (`topic_id`)
) ENGINE=MyISAM AUTO_INCREMENT=410 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nomcom_feedback_topics`
--
LOCK TABLES `nomcom_feedback_topics` WRITE;
/*!40000 ALTER TABLE `nomcom_feedback_topics` DISABLE KEYS */;
/*!40000 ALTER TABLE `nomcom_feedback_topics` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nomcom_feedbacklastseen`
--
DROP TABLE IF EXISTS `nomcom_feedbacklastseen`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nomcom_feedbacklastseen` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`time` datetime /* mariadb-5.3 */ NOT NULL,
`nominee_id` int(11) NOT NULL,
`reviewer_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `nomcom_feedbacklastseen_2e0f1201` (`nominee_id`),
KEY `nomcom_feedbacklastseen_071d8141` (`reviewer_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9039 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nomcom_feedbacklastseen`
--
LOCK TABLES `nomcom_feedbacklastseen` WRITE;
/*!40000 ALTER TABLE `nomcom_feedbacklastseen` DISABLE KEYS */;
/*!40000 ALTER TABLE `nomcom_feedbacklastseen` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nomcom_nomcom`
--
DROP TABLE IF EXISTS `nomcom_nomcom`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nomcom_nomcom` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`public_key` varchar(100) DEFAULT NULL,
`group_id` int(11) NOT NULL,
`send_questionnaire` tinyint(1) NOT NULL DEFAULT 0,
`reminder_interval` int(10) unsigned DEFAULT NULL,
`initial_text` longtext NOT NULL,
`show_nominee_pictures` tinyint(1) NOT NULL,
`show_accepted_nominees` tinyint(1) NOT NULL,
`first_call_for_volunteers` date DEFAULT NULL,
`is_accepting_volunteers` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
KEY `nomcom_nomcom_bda51c3c` (`group_id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nomcom_nomcom`
--
LOCK TABLES `nomcom_nomcom` WRITE;
/*!40000 ALTER TABLE `nomcom_nomcom` DISABLE KEYS */;
/*!40000 ALTER TABLE `nomcom_nomcom` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nomcom_nomination`
--
DROP TABLE IF EXISTS `nomcom_nomination`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nomcom_nomination` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`position_id` int(11) NOT NULL,
`candidate_name` varchar(255) NOT NULL,
`candidate_email` varchar(255) NOT NULL,
`candidate_phone` varchar(255) NOT NULL,
`nominee_id` int(11) NOT NULL,
`comments_id` int(11) NOT NULL,
`nominator_email` varchar(254) NOT NULL,
`user_id` int(11) DEFAULT NULL,
`time` datetime NOT NULL,
`share_nominator` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
KEY `nomcom_nomination_80180135` (`position_id`),
KEY `nomcom_nomination_2b1dcb5e` (`nominee_id`),
KEY `nomcom_nomination_f18362ee` (`comments_id`),
KEY `nomcom_nomination_fbfc09f1` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1318 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nomcom_nomination`
--
LOCK TABLES `nomcom_nomination` WRITE;
/*!40000 ALTER TABLE `nomcom_nomination` DISABLE KEYS */;
/*!40000 ALTER TABLE `nomcom_nomination` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nomcom_nominee`
--
DROP TABLE IF EXISTS `nomcom_nominee`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nomcom_nominee` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`email_id` varchar(64) NOT NULL,
`duplicated_id` int(11) DEFAULT NULL,
`nomcom_id` int(11) NOT NULL,
`person_id` int(11),
PRIMARY KEY (`id`),
UNIQUE KEY `nomcom_nominee_email_id_6a78daffc6a0d077_uniq` (`email_id`,`nomcom_id`),
KEY `nomcom_nominee_aa4ce359` (`duplicated_id`),
KEY `nomcom_nominee_82eb091d` (`nomcom_id`),
KEY `nomcom_nominee_a8452ca7` (`person_id`)
) ENGINE=MyISAM AUTO_INCREMENT=889 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nomcom_nominee`
--
LOCK TABLES `nomcom_nominee` WRITE;
/*!40000 ALTER TABLE `nomcom_nominee` DISABLE KEYS */;
/*!40000 ALTER TABLE `nomcom_nominee` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nomcom_nomineeposition`
--
DROP TABLE IF EXISTS `nomcom_nomineeposition`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nomcom_nomineeposition` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`position_id` int(11) NOT NULL,
`nominee_id` int(11) NOT NULL,
`state_id` varchar(32) NOT NULL,
`time` datetime /* mariadb-5.3 */ NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `nomcom_nomineeposition_position_id_3655a292b6595f69_uniq` (`position_id`,`nominee_id`),
KEY `nomcom_nomineeposition_2b1dcb5e` (`nominee_id`),
KEY `nomcom_nomineeposition_b9608dc2` (`state_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1095 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nomcom_nomineeposition`
--
LOCK TABLES `nomcom_nomineeposition` WRITE;
/*!40000 ALTER TABLE `nomcom_nomineeposition` DISABLE KEYS */;
/*!40000 ALTER TABLE `nomcom_nomineeposition` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nomcom_position`
--
DROP TABLE IF EXISTS `nomcom_position`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nomcom_position` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nomcom_id` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
`requirement_id` int(11) DEFAULT NULL,
`questionnaire_id` int(11) DEFAULT NULL,
`is_open` tinyint(1) NOT NULL DEFAULT 0,
`accepting_feedback` tinyint(1) NOT NULL,
`accepting_nominations` tinyint(1) NOT NULL,
`is_iesg_position` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
KEY `nomcom_position_82eb091d` (`nomcom_id`),
KEY `nomcom_position_99a85f32` (`requirement_id`),
KEY `nomcom_position_57172026` (`questionnaire_id`)
) ENGINE=MyISAM AUTO_INCREMENT=118 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nomcom_position`
--
LOCK TABLES `nomcom_position` WRITE;
/*!40000 ALTER TABLE `nomcom_position` DISABLE KEYS */;
/*!40000 ALTER TABLE `nomcom_position` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nomcom_reminderdates`
--
DROP TABLE IF EXISTS `nomcom_reminderdates`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nomcom_reminderdates` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`date` date NOT NULL,
`nomcom_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `nomcom_reminderdates_82eb091d` (`nomcom_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nomcom_reminderdates`
--
LOCK TABLES `nomcom_reminderdates` WRITE;
/*!40000 ALTER TABLE `nomcom_reminderdates` DISABLE KEYS */;
/*!40000 ALTER TABLE `nomcom_reminderdates` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nomcom_topic`
--
DROP TABLE IF EXISTS `nomcom_topic`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nomcom_topic` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`subject` varchar(255) NOT NULL,
`accepting_feedback` tinyint(1) NOT NULL,
`audience_id` varchar(32) NOT NULL,
`description_id` int(11) DEFAULT NULL,
`nomcom_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `nomcom_topic_cc4f3858` (`audience_id`),
KEY `nomcom_topic_73b5be45` (`description_id`),
KEY `nomcom_topic_901f3763` (`nomcom_id`)
) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nomcom_topic`
--
LOCK TABLES `nomcom_topic` WRITE;
/*!40000 ALTER TABLE `nomcom_topic` DISABLE KEYS */;
/*!40000 ALTER TABLE `nomcom_topic` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nomcom_topicfeedbacklastseen`
--
DROP TABLE IF EXISTS `nomcom_topicfeedbacklastseen`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nomcom_topicfeedbacklastseen` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`time` datetime(6) NOT NULL,
`reviewer_id` int(11) NOT NULL,
`topic_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `nomcom_topicfeedbacklastseen_071d8141` (`reviewer_id`),
KEY `nomcom_topicfeedbacklastseen_19b4d727` (`topic_id`)
) ENGINE=MyISAM AUTO_INCREMENT=166 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nomcom_topicfeedbacklastseen`
--
LOCK TABLES `nomcom_topicfeedbacklastseen` WRITE;
/*!40000 ALTER TABLE `nomcom_topicfeedbacklastseen` DISABLE KEYS */;
/*!40000 ALTER TABLE `nomcom_topicfeedbacklastseen` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `nomcom_volunteer`
--
DROP TABLE IF EXISTS `nomcom_volunteer`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nomcom_volunteer` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`affiliation` varchar(255) NOT NULL,
`nomcom_id` int(11) NOT NULL,
`person_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `nomcom_volunteer_nomcom_id_57e29f61` (`nomcom_id`),
KEY `nomcom_volunteer_person_id_8b53f433` (`person_id`)
) ENGINE=MyISAM AUTO_INCREMENT=629 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `nomcom_volunteer`
--
LOCK TABLES `nomcom_volunteer` WRITE;
/*!40000 ALTER TABLE `nomcom_volunteer` DISABLE KEYS */;
/*!40000 ALTER TABLE `nomcom_volunteer` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `oidc_provider_client`
--
DROP TABLE IF EXISTS `oidc_provider_client`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oidc_provider_client` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`client_id` varchar(228) NOT NULL,
`client_secret` varchar(228) NOT NULL,
`_redirect_uris` longtext NOT NULL,
`date_created` date NOT NULL,
`client_type` varchar(30) NOT NULL,
`jwt_alg` varchar(10) NOT NULL,
`contact_email` varchar(228) NOT NULL,
`logo` varchar(100) NOT NULL,
`terms_url` varchar(228) NOT NULL,
`website_url` varchar(228) NOT NULL,
`_post_logout_redirect_uris` longtext NOT NULL,
`require_consent` tinyint(1) NOT NULL,
`reuse_consent` tinyint(1) NOT NULL,
`owner_id` int(11) DEFAULT NULL,
`_scope` longtext NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `client_id` (`client_id`),
KEY `oidc_provider_client_owner_id_735e6178` (`owner_id`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `oidc_provider_client`
--
LOCK TABLES `oidc_provider_client` WRITE;
/*!40000 ALTER TABLE `oidc_provider_client` DISABLE KEYS */;
/*!40000 ALTER TABLE `oidc_provider_client` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `oidc_provider_client_response_types`
--
DROP TABLE IF EXISTS `oidc_provider_client_response_types`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oidc_provider_client_response_types` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`client_id` int(11) NOT NULL,
`responsetype_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `oidc_provider_client_res_client_id_responsetype_i_0d116294_uniq` (`client_id`,`responsetype_id`),
KEY `oidc_provider_client_response_types_responsetype_id_c90751ad` (`responsetype_id`)
) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `oidc_provider_client_response_types`
--
LOCK TABLES `oidc_provider_client_response_types` WRITE;
/*!40000 ALTER TABLE `oidc_provider_client_response_types` DISABLE KEYS */;
/*!40000 ALTER TABLE `oidc_provider_client_response_types` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `oidc_provider_code`
--
DROP TABLE IF EXISTS `oidc_provider_code`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oidc_provider_code` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`expires_at` datetime(6) NOT NULL,
`_scope` longtext NOT NULL,
`code` varchar(228) NOT NULL,
`client_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`nonce` varchar(228) NOT NULL,
`is_authentication` tinyint(1) NOT NULL,
`code_challenge` varchar(228) DEFAULT NULL,
`code_challenge_method` varchar(228) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `code` (`code`),
KEY `oidc_provider_code_client_id_2449f20c` (`client_id`),
KEY `oidc_provider_code_user_id_14775b3f` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1307998 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `oidc_provider_code`
--
LOCK TABLES `oidc_provider_code` WRITE;
/*!40000 ALTER TABLE `oidc_provider_code` DISABLE KEYS */;
/*!40000 ALTER TABLE `oidc_provider_code` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `oidc_provider_responsetype`
--
DROP TABLE IF EXISTS `oidc_provider_responsetype`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oidc_provider_responsetype` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`value` varchar(30) NOT NULL,
`description` varchar(50) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `value` (`value`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `oidc_provider_responsetype`
--
LOCK TABLES `oidc_provider_responsetype` WRITE;
/*!40000 ALTER TABLE `oidc_provider_responsetype` DISABLE KEYS */;
/*!40000 ALTER TABLE `oidc_provider_responsetype` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `oidc_provider_rsakey`
--
DROP TABLE IF EXISTS `oidc_provider_rsakey`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oidc_provider_rsakey` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`key` longtext NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `oidc_provider_rsakey`
--
LOCK TABLES `oidc_provider_rsakey` WRITE;
/*!40000 ALTER TABLE `oidc_provider_rsakey` DISABLE KEYS */;
/*!40000 ALTER TABLE `oidc_provider_rsakey` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `oidc_provider_token`
--
DROP TABLE IF EXISTS `oidc_provider_token`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oidc_provider_token` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`expires_at` datetime(6) NOT NULL,
`_scope` longtext NOT NULL,
`access_token` varchar(228) NOT NULL,
`_id_token` longtext NOT NULL,
`client_id` int(11) NOT NULL,
`user_id` int(11) DEFAULT NULL,
`refresh_token` varchar(228) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `access_token` (`access_token`),
UNIQUE KEY `refresh_token` (`refresh_token`),
KEY `oidc_provider_token_client_id_86a72d16` (`client_id`),
KEY `oidc_provider_token_user_id_c61045ea` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=100352 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `oidc_provider_token`
--
LOCK TABLES `oidc_provider_token` WRITE;
/*!40000 ALTER TABLE `oidc_provider_token` DISABLE KEYS */;
/*!40000 ALTER TABLE `oidc_provider_token` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `oidc_provider_userconsent`
--
DROP TABLE IF EXISTS `oidc_provider_userconsent`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oidc_provider_userconsent` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`expires_at` datetime(6) NOT NULL,
`_scope` longtext NOT NULL,
`client_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`date_given` datetime(6) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `oidc_provider_userconsent_user_id_client_id_1c2032f6_uniq` (`user_id`,`client_id`),
KEY `oidc_provider_userconsent_client_id_7837dc61` (`client_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9179 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `oidc_provider_userconsent`
--
LOCK TABLES `oidc_provider_userconsent` WRITE;
/*!40000 ALTER TABLE `oidc_provider_userconsent` DISABLE KEYS */;
/*!40000 ALTER TABLE `oidc_provider_userconsent` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `person_alias`
--
DROP TABLE IF EXISTS `person_alias`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `person_alias` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`person_id` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `person_alias_21b911c5` (`person_id`),
KEY `person_alias_52094d6e` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=46998 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `person_alias`
--
LOCK TABLES `person_alias` WRITE;
/*!40000 ALTER TABLE `person_alias` DISABLE KEYS */;
/*!40000 ALTER TABLE `person_alias` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `person_email`
--
DROP TABLE IF EXISTS `person_email`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `person_email` (
`address` varchar(64) NOT NULL,
`person_id` int(11) DEFAULT NULL,
`time` datetime NOT NULL,
`active` tinyint(1) NOT NULL,
`primary` tinyint(1) NOT NULL,
`origin` varchar(150) NOT NULL,
PRIMARY KEY (`address`),
KEY `person_email_21b911c5` (`person_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `person_email`
--
LOCK TABLES `person_email` WRITE;
/*!40000 ALTER TABLE `person_email` DISABLE KEYS */;
/*!40000 ALTER TABLE `person_email` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `person_historicalemail`
--
DROP TABLE IF EXISTS `person_historicalemail`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `person_historicalemail` (
`address` varchar(64) NOT NULL,
`time` datetime(6) NOT NULL,
`primary` tinyint(1) NOT NULL,
`origin` varchar(150) NOT NULL,
`active` tinyint(1) NOT NULL,
`history_id` int(11) NOT NULL AUTO_INCREMENT,
`history_date` datetime(6) NOT NULL,
`history_change_reason` varchar(100) DEFAULT NULL,
`history_type` varchar(1) NOT NULL,
`history_user_id` int(11) DEFAULT NULL,
`person_id` int(11) DEFAULT NULL,
PRIMARY KEY (`history_id`),
KEY `person_historicalemail_address_e9fdbf78` (`address`),
KEY `person_historicalemail_history_user_id_1487237a` (`history_user_id`),
KEY `person_historicalemail_person_id_8c8d31e5` (`person_id`),
KEY `person_historicalemail_history_date_0c392071` (`history_date`)
) ENGINE=MyISAM AUTO_INCREMENT=173632 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `person_historicalemail`
--
LOCK TABLES `person_historicalemail` WRITE;
/*!40000 ALTER TABLE `person_historicalemail` DISABLE KEYS */;
/*!40000 ALTER TABLE `person_historicalemail` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `person_historicalperson`
--
DROP TABLE IF EXISTS `person_historicalperson`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `person_historicalperson` (
`id` int(11) NOT NULL,
`time` datetime(6) NOT NULL,
`name` varchar(255) NOT NULL,
`ascii` varchar(255) NOT NULL,
`ascii_short` varchar(32) DEFAULT NULL,
`biography` longtext NOT NULL,
`photo` longtext NOT NULL,
`photo_thumb` longtext NOT NULL,
`name_from_draft` varchar(255) DEFAULT NULL,
`history_id` int(11) NOT NULL AUTO_INCREMENT,
`history_date` datetime(6) NOT NULL,
`history_change_reason` varchar(100) DEFAULT NULL,
`history_type` varchar(1) NOT NULL,
`history_user_id` int(11) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`consent` tinyint(1) DEFAULT NULL,
`plain` varchar(64) NOT NULL,
`pronouns_freetext` varchar(30) DEFAULT NULL,
`pronouns_selectable` varchar(120),
PRIMARY KEY (`history_id`),
KEY `person_historicalperson_id_6ca5c28a` (`id`),
KEY `person_historicalperson_name_abe3f559` (`name`),
KEY `person_historicalperson_history_user_id_acefaaa5` (`history_user_id`),
KEY `person_historicalperson_user_id_c72265f4` (`user_id`),
KEY `person_historicalperson_history_date_b3968bfa` (`history_date`)
) ENGINE=MyISAM AUTO_INCREMENT=29785 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `person_historicalperson`
--
LOCK TABLES `person_historicalperson` WRITE;
/*!40000 ALTER TABLE `person_historicalperson` DISABLE KEYS */;
/*!40000 ALTER TABLE `person_historicalperson` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `person_person`
--
DROP TABLE IF EXISTS `person_person`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `person_person` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`time` datetime NOT NULL,
`name` varchar(255) NOT NULL,
`ascii` varchar(255) NOT NULL,
`ascii_short` varchar(32) DEFAULT NULL,
`user_id` int(11) DEFAULT NULL,
`biography` longtext NOT NULL,
`photo` varchar(100) NOT NULL,
`photo_thumb` varchar(100) NOT NULL,
`name_from_draft` varchar(255) DEFAULT NULL,
`consent` tinyint(1) DEFAULT NULL,
`plain` varchar(64) NOT NULL,
`pronouns_freetext` varchar(30) DEFAULT NULL,
`pronouns_selectable` varchar(120),
PRIMARY KEY (`id`),
UNIQUE KEY `user_id` (`user_id`),
KEY `person_person_52094d6e` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=132462 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `person_person`
--
LOCK TABLES `person_person` WRITE;
/*!40000 ALTER TABLE `person_person` DISABLE KEYS */;
/*!40000 ALTER TABLE `person_person` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `person_personalapikey`
--
DROP TABLE IF EXISTS `person_personalapikey`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `person_personalapikey` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`endpoint` varchar(128) NOT NULL,
`created` datetime(6) NOT NULL,
`valid` tinyint(1) NOT NULL,
`salt` longblob NOT NULL,
`count` int(11) NOT NULL,
`latest` datetime(6) DEFAULT NULL,
`person_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `person_personalapikey_a8452ca7` (`person_id`)
) ENGINE=MyISAM AUTO_INCREMENT=385 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `person_personalapikey`
--
LOCK TABLES `person_personalapikey` WRITE;
/*!40000 ALTER TABLE `person_personalapikey` DISABLE KEYS */;
/*!40000 ALTER TABLE `person_personalapikey` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `person_personapikeyevent`
--
DROP TABLE IF EXISTS `person_personapikeyevent`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `person_personapikeyevent` (
`personevent_ptr_id` int(11) NOT NULL,
`key_id` int(11) NOT NULL,
PRIMARY KEY (`personevent_ptr_id`),
KEY `person_personapikeyevent_30f69126` (`key_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `person_personapikeyevent`
--
LOCK TABLES `person_personapikeyevent` WRITE;
/*!40000 ALTER TABLE `person_personapikeyevent` DISABLE KEYS */;
/*!40000 ALTER TABLE `person_personapikeyevent` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `person_personevent`
--
DROP TABLE IF EXISTS `person_personevent`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `person_personevent` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`time` datetime(6) NOT NULL,
`type` varchar(50) NOT NULL,
`desc` longtext NOT NULL,
`person_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `person_personevent_a8452ca7` (`person_id`),
KEY `person_pers_time_8dfbc5_idx` (`time`,`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2546430 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `person_personevent`
--
LOCK TABLES `person_personevent` WRITE;
/*!40000 ALTER TABLE `person_personevent` DISABLE KEYS */;
/*!40000 ALTER TABLE `person_personevent` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `person_personextresource`
--
DROP TABLE IF EXISTS `person_personextresource`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `person_personextresource` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`display_name` varchar(255) NOT NULL,
`value` varchar(2083) NOT NULL,
`name_id` varchar(32) NOT NULL,
`person_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `person_personextresource_name_id_33680dc6` (`name_id`),
KEY `person_personextresource_person_id_982104c7` (`person_id`)
) ENGINE=MyISAM AUTO_INCREMENT=260 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `person_personextresource`
--
LOCK TABLES `person_personextresource` WRITE;
/*!40000 ALTER TABLE `person_personextresource` DISABLE KEYS */;
/*!40000 ALTER TABLE `person_personextresource` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `redirects_command`
--
DROP TABLE IF EXISTS `redirects_command`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `redirects_command` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`command` varchar(50) NOT NULL,
`url` varchar(50) NOT NULL,
`script_id` int(11) NOT NULL,
`suffix_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `script_id` (`script_id`,`command`),
KEY `redirects_command_7c3c77f7` (`suffix_id`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `redirects_command`
--
LOCK TABLES `redirects_command` WRITE;
/*!40000 ALTER TABLE `redirects_command` DISABLE KEYS */;
/*!40000 ALTER TABLE `redirects_command` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `redirects_redirect`
--
DROP TABLE IF EXISTS `redirects_redirect`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `redirects_redirect` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`cgi` varchar(50) NOT NULL,
`url` varchar(255) NOT NULL,
`rest` varchar(100) NOT NULL,
`remove` varchar(50) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `cgi` (`cgi`)
) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `redirects_redirect`
--
LOCK TABLES `redirects_redirect` WRITE;
/*!40000 ALTER TABLE `redirects_redirect` DISABLE KEYS */;
/*!40000 ALTER TABLE `redirects_redirect` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `redirects_suffix`
--
DROP TABLE IF EXISTS `redirects_suffix`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `redirects_suffix` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`rest` varchar(100) NOT NULL,
`remove` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `redirects_suffix`
--
LOCK TABLES `redirects_suffix` WRITE;
/*!40000 ALTER TABLE `redirects_suffix` DISABLE KEYS */;
/*!40000 ALTER TABLE `redirects_suffix` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `request_profiler_profilingrecord`
--
DROP TABLE IF EXISTS `request_profiler_profilingrecord`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `request_profiler_profilingrecord` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`session_key` varchar(40) NOT NULL,
`start_ts` datetime(6) NOT NULL,
`end_ts` datetime(6) NOT NULL,
`duration` double NOT NULL,
`http_method` varchar(10) NOT NULL,
`request_uri` varchar(200) NOT NULL,
`remote_addr` varchar(100) NOT NULL,
`http_user_agent` varchar(400) NOT NULL,
`view_func_name` varchar(100) NOT NULL,
`response_status_code` int(11) NOT NULL,
`response_content_length` int(11) NOT NULL,
`user_id` int(11) DEFAULT NULL,
`http_referer` varchar(400) NOT NULL,
`query_string` longtext NOT NULL,
`query_count` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `request_profiler_profilingrecord_user_id_c64de95a` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=11458615 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `request_profiler_profilingrecord`
--
LOCK TABLES `request_profiler_profilingrecord` WRITE;
/*!40000 ALTER TABLE `request_profiler_profilingrecord` DISABLE KEYS */;
/*!40000 ALTER TABLE `request_profiler_profilingrecord` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `request_profiler_ruleset`
--
DROP TABLE IF EXISTS `request_profiler_ruleset`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `request_profiler_ruleset` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`enabled` tinyint(1) NOT NULL,
`uri_regex` varchar(100) NOT NULL,
`user_filter_type` int(11) NOT NULL,
`user_group_filter` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
KEY `request_profiler_ruleset_enabled_e0987840` (`enabled`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `request_profiler_ruleset`
--
LOCK TABLES `request_profiler_ruleset` WRITE;
/*!40000 ALTER TABLE `request_profiler_ruleset` DISABLE KEYS */;
/*!40000 ALTER TABLE `request_profiler_ruleset` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `review_historicalreviewassignment`
--
DROP TABLE IF EXISTS `review_historicalreviewassignment`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `review_historicalreviewassignment` (
`id` int(11) NOT NULL,
`history_change_reason` longtext DEFAULT NULL,
`assigned_on` datetime(6) DEFAULT NULL,
`completed_on` datetime(6) DEFAULT NULL,
`reviewed_rev` varchar(16) NOT NULL,
`mailarch_url` varchar(200) DEFAULT NULL,
`history_id` int(11) NOT NULL AUTO_INCREMENT,
`history_date` datetime(6) NOT NULL,
`history_type` varchar(1) NOT NULL,
`history_user_id` int(11) DEFAULT NULL,
`result_id` varchar(32) DEFAULT NULL,
`review_id` int(11) DEFAULT NULL,
`review_request_id` int(11) DEFAULT NULL,
`reviewer_id` varchar(64) DEFAULT NULL,
`state_id` varchar(32) DEFAULT NULL,
PRIMARY KEY (`history_id`),
KEY `review_historicalreviewassignment_id_20ac40f0` (`id`),
KEY `review_historicalreviewassignment_history_user_id_e539d5f6` (`history_user_id`),
KEY `review_historicalreviewassignment_result_id_38eec0f1` (`result_id`),
KEY `review_historicalreviewassignment_review_id_52559242` (`review_id`),
KEY `review_historicalreviewassignment_review_request_id_ccdd4b25` (`review_request_id`),
KEY `review_historicalreviewassignment_reviewer_id_6515ebf0` (`reviewer_id`),
KEY `review_historicalreviewassignment_state_id_dd8136b3` (`state_id`),
KEY `review_historicalreviewassignment_history_date_791d85e8` (`history_date`)
) ENGINE=MyISAM AUTO_INCREMENT=6290 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `review_historicalreviewassignment`
--
LOCK TABLES `review_historicalreviewassignment` WRITE;
/*!40000 ALTER TABLE `review_historicalreviewassignment` DISABLE KEYS */;
/*!40000 ALTER TABLE `review_historicalreviewassignment` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `review_historicalreviewersettings`
--
DROP TABLE IF EXISTS `review_historicalreviewersettings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `review_historicalreviewersettings` (
`id` int(11) NOT NULL,
`min_interval` int(11) DEFAULT NULL,
`filter_re` varchar(255) NOT NULL,
`skip_next` int(11) NOT NULL,
`remind_days_before_deadline` int(11) DEFAULT NULL,
`expertise` longtext NOT NULL,
`history_id` int(11) NOT NULL AUTO_INCREMENT,
`history_change_reason` longtext DEFAULT NULL,
`history_date` datetime(6) NOT NULL,
`history_type` varchar(1) NOT NULL,
`history_user_id` int(11) DEFAULT NULL,
`person_id` int(11) DEFAULT NULL,
`team_id` int(11) DEFAULT NULL,
`remind_days_open_reviews` int(10) unsigned DEFAULT NULL,
`request_assignment_next` tinyint(1) NOT NULL,
PRIMARY KEY (`history_id`),
KEY `review_historicalreviewersettings_id_f9777f2c` (`id`),
KEY `review_historicalreviewersettings_history_user_id_eb08647f` (`history_user_id`),
KEY `review_historicalreviewersettings_person_id_9f942164` (`person_id`),
KEY `review_historicalreviewersettings_team_id_e2570292` (`team_id`),
KEY `review_historicalreviewersettings_history_date_cae5a08d` (`history_date`)
) ENGINE=MyISAM AUTO_INCREMENT=19952 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `review_historicalreviewersettings`
--
LOCK TABLES `review_historicalreviewersettings` WRITE;
/*!40000 ALTER TABLE `review_historicalreviewersettings` DISABLE KEYS */;
/*!40000 ALTER TABLE `review_historicalreviewersettings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `review_historicalreviewrequest`
--
DROP TABLE IF EXISTS `review_historicalreviewrequest`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `review_historicalreviewrequest` (
`id` int(11) NOT NULL,
`history_change_reason` longtext DEFAULT NULL,
`time` datetime(6) NOT NULL,
`deadline` date NOT NULL,
`requested_rev` varchar(16) NOT NULL,
`comment` longtext NOT NULL,
`history_id` int(11) NOT NULL AUTO_INCREMENT,
`history_date` datetime(6) NOT NULL,
`history_type` varchar(1) NOT NULL,
`doc_id` int(11) DEFAULT NULL,
`history_user_id` int(11) DEFAULT NULL,
`requested_by_id` int(11) DEFAULT NULL,
`state_id` varchar(32) DEFAULT NULL,
`team_id` int(11) DEFAULT NULL,
`type_id` varchar(32) DEFAULT NULL,
PRIMARY KEY (`history_id`),
KEY `review_historicalreviewrequest_id_88985d8f` (`id`),
KEY `review_historicalreviewrequest_doc_id_f83e4791` (`doc_id`),
KEY `review_historicalreviewrequest_history_user_id_887571a9` (`history_user_id`),
KEY `review_historicalreviewrequest_requested_by_id_5802f639` (`requested_by_id`),
KEY `review_historicalreviewrequest_state_id_d13a45ea` (`state_id`),
KEY `review_historicalreviewrequest_team_id_914f70a4` (`team_id`),
KEY `review_historicalreviewrequest_type_id_02e2b5b2` (`type_id`),
KEY `review_historicalreviewrequest_history_date_0a17b857` (`history_date`)
) ENGINE=MyISAM AUTO_INCREMENT=5266 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `review_historicalreviewrequest`
--
LOCK TABLES `review_historicalreviewrequest` WRITE;
/*!40000 ALTER TABLE `review_historicalreviewrequest` DISABLE KEYS */;
/*!40000 ALTER TABLE `review_historicalreviewrequest` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `review_historicalunavailableperiod`
--
DROP TABLE IF EXISTS `review_historicalunavailableperiod`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `review_historicalunavailableperiod` (
`id` int(11) NOT NULL,
`history_change_reason` longtext DEFAULT NULL,
`start_date` date DEFAULT NULL,
`end_date` date DEFAULT NULL,
`availability` varchar(30) NOT NULL,
`reason` longtext NOT NULL,
`history_id` int(11) NOT NULL AUTO_INCREMENT,
`history_date` datetime(6) NOT NULL,
`history_type` varchar(1) NOT NULL,
`history_user_id` int(11) DEFAULT NULL,
`person_id` int(11) DEFAULT NULL,
`team_id` int(11) DEFAULT NULL,
PRIMARY KEY (`history_id`),
KEY `review_historicalunavailableperiod_id_1ef945c9` (`id`),
KEY `review_historicalunavailableperiod_history_user_id_cb14dcad` (`history_user_id`),
KEY `review_historicalunavailableperiod_person_id_645b6568` (`person_id`),
KEY `review_historicalunavailableperiod_team_id_0ff920dc` (`team_id`),
KEY `review_historicalunavailableperiod_history_date_0acb0f03` (`history_date`)
) ENGINE=MyISAM AUTO_INCREMENT=192 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `review_historicalunavailableperiod`
--
LOCK TABLES `review_historicalunavailableperiod` WRITE;
/*!40000 ALTER TABLE `review_historicalunavailableperiod` DISABLE KEYS */;
/*!40000 ALTER TABLE `review_historicalunavailableperiod` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `review_nextreviewerinteam`
--
DROP TABLE IF EXISTS `review_nextreviewerinteam`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `review_nextreviewerinteam` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`next_reviewer_id` int(11) NOT NULL,
`team_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `review_nextreviewerinteam_0198dc8c` (`next_reviewer_id`),
KEY `review_nextreviewerinteam_f6a7ca40` (`team_id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `review_nextreviewerinteam`
--
LOCK TABLES `review_nextreviewerinteam` WRITE;
/*!40000 ALTER TABLE `review_nextreviewerinteam` DISABLE KEYS */;
/*!40000 ALTER TABLE `review_nextreviewerinteam` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `review_reviewassignment`
--
DROP TABLE IF EXISTS `review_reviewassignment`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `review_reviewassignment` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`assigned_on` datetime(6) DEFAULT NULL,
`completed_on` datetime(6) DEFAULT NULL,
`reviewed_rev` varchar(16) NOT NULL,
`mailarch_url` varchar(200) DEFAULT NULL,
`result_id` varchar(32) DEFAULT NULL,
`review_request_id` int(11) NOT NULL,
`reviewer_id` varchar(64) NOT NULL,
`state_id` varchar(32) NOT NULL,
`review_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `review2_id` (`review_id`),
KEY `review_reviewassignment_result_id_7aa27d27` (`result_id`),
KEY `review_reviewassignment_review_request_id_23e71fb2` (`review_request_id`),
KEY `review_reviewassignment_reviewer_id_e7e852d9` (`reviewer_id`),
KEY `review_reviewassignment_state_id_9a2b3432` (`state_id`)
) ENGINE=MyISAM AUTO_INCREMENT=13601 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `review_reviewassignment`
--
LOCK TABLES `review_reviewassignment` WRITE;
/*!40000 ALTER TABLE `review_reviewassignment` DISABLE KEYS */;
/*!40000 ALTER TABLE `review_reviewassignment` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `review_reviewersettings`
--
DROP TABLE IF EXISTS `review_reviewersettings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `review_reviewersettings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`min_interval` int(11) DEFAULT NULL,
`filter_re` varchar(255) NOT NULL,
`skip_next` int(11) NOT NULL,
`remind_days_before_deadline` int(11) DEFAULT NULL,
`person_id` int(11) NOT NULL,
`team_id` int(11) NOT NULL,
`expertise` longtext NOT NULL,
`remind_days_open_reviews` int(10) unsigned DEFAULT NULL,
`request_assignment_next` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `unique_reviewer_settings_per_team_person` (`team_id`,`person_id`),
KEY `review_reviewersettings_a8452ca7` (`person_id`),
KEY `review_reviewersettings_f6a7ca40` (`team_id`)
) ENGINE=MyISAM AUTO_INCREMENT=424 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `review_reviewersettings`
--
LOCK TABLES `review_reviewersettings` WRITE;
/*!40000 ALTER TABLE `review_reviewersettings` DISABLE KEYS */;
/*!40000 ALTER TABLE `review_reviewersettings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `review_reviewrequest`
--
DROP TABLE IF EXISTS `review_reviewrequest`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `review_reviewrequest` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`time` datetime NOT NULL,
`deadline` date NOT NULL,
`requested_rev` varchar(16) NOT NULL,
`requested_by_id` int(11) NOT NULL,
`state_id` varchar(32) NOT NULL,
`team_id` int(11) NOT NULL,
`type_id` varchar(32) NOT NULL,
`comment` longtext NOT NULL,
`doc_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `review_reviewrequest_0a0193c8` (`requested_by_id`),
KEY `review_reviewrequest_d5582625` (`state_id`),
KEY `review_reviewrequest_f6a7ca40` (`team_id`),
KEY `review_reviewrequest_94757cae` (`type_id`),
KEY `review_reviewrequest_doc2_id_bca9eea9` (`doc_id`)
) ENGINE=MyISAM AUTO_INCREMENT=16170 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `review_reviewrequest`
--
LOCK TABLES `review_reviewrequest` WRITE;
/*!40000 ALTER TABLE `review_reviewrequest` DISABLE KEYS */;
/*!40000 ALTER TABLE `review_reviewrequest` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `review_reviewsecretarysettings`
--
DROP TABLE IF EXISTS `review_reviewsecretarysettings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `review_reviewsecretarysettings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`remind_days_before_deadline` int(11) DEFAULT NULL,
`person_id` int(11) NOT NULL,
`team_id` int(11) NOT NULL,
`days_to_show_in_reviewer_list` int(11) DEFAULT NULL,
`max_items_to_show_in_reviewer_list` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `review_reviewsecretarysettings_a8452ca7` (`person_id`),
KEY `review_reviewsecretarysettings_f6a7ca40` (`team_id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `review_reviewsecretarysettings`
--
LOCK TABLES `review_reviewsecretarysettings` WRITE;
/*!40000 ALTER TABLE `review_reviewsecretarysettings` DISABLE KEYS */;
/*!40000 ALTER TABLE `review_reviewsecretarysettings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `review_reviewteamsettings`
--
DROP TABLE IF EXISTS `review_reviewteamsettings`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `review_reviewteamsettings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`autosuggest` tinyint(1) NOT NULL,
`group_id` int(11) NOT NULL,
`secr_mail_alias` varchar(255) NOT NULL,
`remind_days_unconfirmed_assignments` int(10) unsigned DEFAULT NULL,
`reviewer_queue_policy_id` varchar(32) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `group_id` (`group_id`),
KEY `review_reviewteamsettings_reviewer_queue_policy_id_fe8c5535` (`reviewer_queue_policy_id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `review_reviewteamsettings`
--
LOCK TABLES `review_reviewteamsettings` WRITE;
/*!40000 ALTER TABLE `review_reviewteamsettings` DISABLE KEYS */;
/*!40000 ALTER TABLE `review_reviewteamsettings` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `review_reviewteamsettings_notify_ad_when`
--
DROP TABLE IF EXISTS `review_reviewteamsettings_notify_ad_when`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `review_reviewteamsettings_notify_ad_when` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`reviewteamsettings_id` int(11) NOT NULL,
`reviewresultname_id` varchar(32) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `review_reviewteamsetting_reviewteamsettings_id_re_3383836c_uniq` (`reviewteamsettings_id`,`reviewresultname_id`),
KEY `review_reviewteamsettings_n_reviewresultname_id_cdad5fdd` (`reviewresultname_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `review_reviewteamsettings_notify_ad_when`
--
LOCK TABLES `review_reviewteamsettings_notify_ad_when` WRITE;
/*!40000 ALTER TABLE `review_reviewteamsettings_notify_ad_when` DISABLE KEYS */;
/*!40000 ALTER TABLE `review_reviewteamsettings_notify_ad_when` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `review_reviewteamsettings_review_results`
--
DROP TABLE IF EXISTS `review_reviewteamsettings_review_results`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `review_reviewteamsettings_review_results` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`reviewteamsettings_id` int(11) NOT NULL,
`reviewresultname_id` varchar(32) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `reviewteamsettings_id` (`reviewteamsettings_id`,`reviewresultname_id`),
KEY `review_reviewteamsettings_review_results_04c9fc1d` (`reviewresultname_id`)
) ENGINE=MyISAM AUTO_INCREMENT=67 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `review_reviewteamsettings_review_results`
--
LOCK TABLES `review_reviewteamsettings_review_results` WRITE;
/*!40000 ALTER TABLE `review_reviewteamsettings_review_results` DISABLE KEYS */;
/*!40000 ALTER TABLE `review_reviewteamsettings_review_results` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `review_reviewteamsettings_review_types`
--
DROP TABLE IF EXISTS `review_reviewteamsettings_review_types`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `review_reviewteamsettings_review_types` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`reviewteamsettings_id` int(11) NOT NULL,
`reviewtypename_id` varchar(32) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `reviewteamsettings_id` (`reviewteamsettings_id`,`reviewtypename_id`),
KEY `review_reviewteamsettings_review_types_edc47c9b` (`reviewtypename_id`)
) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `review_reviewteamsettings_review_types`
--
LOCK TABLES `review_reviewteamsettings_review_types` WRITE;
/*!40000 ALTER TABLE `review_reviewteamsettings_review_types` DISABLE KEYS */;
/*!40000 ALTER TABLE `review_reviewteamsettings_review_types` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `review_reviewwish`
--
DROP TABLE IF EXISTS `review_reviewwish`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `review_reviewwish` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`time` datetime NOT NULL,
`person_id` int(11) NOT NULL,
`team_id` int(11) NOT NULL,
`doc_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `review_reviewwish_a8452ca7` (`person_id`),
KEY `review_reviewwish_f6a7ca40` (`team_id`),
KEY `review_reviewwish_doc2_id_f3c1af11` (`doc_id`)
) ENGINE=MyISAM AUTO_INCREMENT=60 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `review_reviewwish`
--
LOCK TABLES `review_reviewwish` WRITE;
/*!40000 ALTER TABLE `review_reviewwish` DISABLE KEYS */;
/*!40000 ALTER TABLE `review_reviewwish` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `review_unavailableperiod`
--
DROP TABLE IF EXISTS `review_unavailableperiod`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `review_unavailableperiod` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`start_date` date DEFAULT NULL,
`end_date` date DEFAULT NULL,
`availability` varchar(30) NOT NULL,
`person_id` int(11) NOT NULL,
`team_id` int(11) NOT NULL,
`reason` longtext NOT NULL,
PRIMARY KEY (`id`),
KEY `review_unavailableperiod_a8452ca7` (`person_id`),
KEY `review_unavailableperiod_f6a7ca40` (`team_id`)
) ENGINE=MyISAM AUTO_INCREMENT=483 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `review_unavailableperiod`
--
LOCK TABLES `review_unavailableperiod` WRITE;
/*!40000 ALTER TABLE `review_unavailableperiod` DISABLE KEYS */;
/*!40000 ALTER TABLE `review_unavailableperiod` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `south_migrationhistory`
--
DROP TABLE IF EXISTS `south_migrationhistory`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `south_migrationhistory` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`app_name` varchar(255) NOT NULL,
`migration` varchar(255) NOT NULL,
`applied` datetime /* mariadb-5.3 */ NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=131 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `south_migrationhistory`
--
LOCK TABLES `south_migrationhistory` WRITE;
/*!40000 ALTER TABLE `south_migrationhistory` DISABLE KEYS */;
/*!40000 ALTER TABLE `south_migrationhistory` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `stats_affiliationalias`
--
DROP TABLE IF EXISTS `stats_affiliationalias`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stats_affiliationalias` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`alias` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `alias` (`alias`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `stats_affiliationalias`
--
LOCK TABLES `stats_affiliationalias` WRITE;
/*!40000 ALTER TABLE `stats_affiliationalias` DISABLE KEYS */;
/*!40000 ALTER TABLE `stats_affiliationalias` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `stats_affiliationignoredending`
--
DROP TABLE IF EXISTS `stats_affiliationignoredending`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stats_affiliationignoredending` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ending` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `stats_affiliationignoredending`
--
LOCK TABLES `stats_affiliationignoredending` WRITE;
/*!40000 ALTER TABLE `stats_affiliationignoredending` DISABLE KEYS */;
/*!40000 ALTER TABLE `stats_affiliationignoredending` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `stats_countryalias`
--
DROP TABLE IF EXISTS `stats_countryalias`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stats_countryalias` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`alias` varchar(255) NOT NULL,
`country_id` varchar(32) NOT NULL,
PRIMARY KEY (`id`),
KEY `stats_countryalias_93bfec8a` (`country_id`)
) ENGINE=MyISAM AUTO_INCREMENT=304 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `stats_countryalias`
--
LOCK TABLES `stats_countryalias` WRITE;
/*!40000 ALTER TABLE `stats_countryalias` DISABLE KEYS */;
/*!40000 ALTER TABLE `stats_countryalias` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `stats_meetingregistration`
--
DROP TABLE IF EXISTS `stats_meetingregistration`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stats_meetingregistration` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`first_name` varchar(255) NOT NULL,
`last_name` varchar(255) NOT NULL,
`affiliation` varchar(255) NOT NULL,
`country_code` varchar(2) NOT NULL,
`meeting_id` int(11) NOT NULL,
`person_id` int(11) DEFAULT NULL,
`email` varchar(254),
`reg_type` varchar(255) NOT NULL,
`ticket_type` varchar(255) NOT NULL,
`attended` tinyint(1) NOT NULL,
`checkedin` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
KEY `stats_meetingregistration_383440d3` (`meeting_id`),
KEY `stats_meetingregistration_a8452ca7` (`person_id`)
) ENGINE=MyISAM AUTO_INCREMENT=54910 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `stats_meetingregistration`
--
LOCK TABLES `stats_meetingregistration` WRITE;
/*!40000 ALTER TABLE `stats_meetingregistration` DISABLE KEYS */;
/*!40000 ALTER TABLE `stats_meetingregistration` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `submit_idapproveddetail`
--
DROP TABLE IF EXISTS `submit_idapproveddetail`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `submit_idapproveddetail` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`filename` varchar(255) DEFAULT NULL,
`approved_status` int(11) DEFAULT NULL,
`approved_person_tag` int(11) DEFAULT NULL,
`approved_date` date DEFAULT NULL,
`recorded_by` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `submit_idapproveddetail_ce54a6c0` (`filename`)
) ENGINE=MyISAM AUTO_INCREMENT=1177 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `submit_idapproveddetail`
--
LOCK TABLES `submit_idapproveddetail` WRITE;
/*!40000 ALTER TABLE `submit_idapproveddetail` DISABLE KEYS */;
/*!40000 ALTER TABLE `submit_idapproveddetail` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `submit_preapproval`
--
DROP TABLE IF EXISTS `submit_preapproval`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `submit_preapproval` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`by_id` int(11) NOT NULL,
`time` datetime /* mariadb-5.3 */ NOT NULL,
PRIMARY KEY (`id`),
KEY `submit_preapproval_52094d6e` (`name`),
KEY `submit_preapproval_3acff7b7` (`by_id`)
) ENGINE=MyISAM AUTO_INCREMENT=409 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `submit_preapproval`
--
LOCK TABLES `submit_preapproval` WRITE;
/*!40000 ALTER TABLE `submit_preapproval` DISABLE KEYS */;
/*!40000 ALTER TABLE `submit_preapproval` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `submit_submission`
--
DROP TABLE IF EXISTS `submit_submission`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `submit_submission` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL DEFAULT '',
`group_id` int(11) DEFAULT NULL,
`name` varchar(255) NOT NULL DEFAULT '',
`document_date` date DEFAULT NULL,
`submission_date` date NOT NULL,
`remote_ip` varchar(100) NOT NULL DEFAULT '',
`rev` varchar(3) NOT NULL DEFAULT '',
`auth_key` varchar(255) NOT NULL DEFAULT '',
`file_types` varchar(50) NOT NULL DEFAULT '',
`note` longtext NOT NULL,
`abstract` longtext NOT NULL,
`pages` int(11) DEFAULT NULL,
`file_size` int(11) DEFAULT NULL,
`first_two_pages` longtext NOT NULL,
`access_key` varchar(255) NOT NULL DEFAULT '',
`replaces` varchar(1000) DEFAULT NULL,
`state_id` varchar(32) NOT NULL,
`authors` longtext NOT NULL,
`submitter` varchar(255) NOT NULL DEFAULT '',
`words` int(11),
`draft_id` int(11) DEFAULT NULL,
`xml_version` varchar(4) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `submit_idsubmissiondetail_3d50c576` (`group_id`),
KEY `submit_idsubmissiondetail_ce54a6c0` (`name`),
KEY `submit_submission_b9608dc2` (`state_id`),
KEY `submit_submission_draft2_id_c628d89a` (`draft_id`)
) ENGINE=MyISAM AUTO_INCREMENT=127936 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `submit_submission`
--
LOCK TABLES `submit_submission` WRITE;
/*!40000 ALTER TABLE `submit_submission` DISABLE KEYS */;
/*!40000 ALTER TABLE `submit_submission` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `submit_submission_formal_languages`
--
DROP TABLE IF EXISTS `submit_submission_formal_languages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `submit_submission_formal_languages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`submission_id` int(11) NOT NULL,
`formallanguagename_id` varchar(32) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `submit_submission_formal_languages_submission_id_5ed923d0_uniq` (`submission_id`,`formallanguagename_id`),
KEY `submit_submission_formal_languages_f9b9ddbe` (`formallanguagename_id`)
) ENGINE=MyISAM AUTO_INCREMENT=8711 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `submit_submission_formal_languages`
--
LOCK TABLES `submit_submission_formal_languages` WRITE;
/*!40000 ALTER TABLE `submit_submission_formal_languages` DISABLE KEYS */;
/*!40000 ALTER TABLE `submit_submission_formal_languages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `submit_submissioncheck`
--
DROP TABLE IF EXISTS `submit_submissioncheck`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `submit_submissioncheck` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`time` datetime NOT NULL,
`checker` varchar(256) NOT NULL,
`passed` tinyint(1) DEFAULT NULL,
`message` longtext DEFAULT NULL,
`warnings` int(11) DEFAULT NULL,
`errors` int(11) DEFAULT NULL,
`items` longtext DEFAULT NULL,
`submission_id` int(11) NOT NULL,
`symbol` varchar(64) NOT NULL,
PRIMARY KEY (`id`),
KEY `submit_submissioncheck_1dd9cfcc` (`submission_id`)
) ENGINE=MyISAM AUTO_INCREMENT=373264 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `submit_submissioncheck`
--
LOCK TABLES `submit_submissioncheck` WRITE;
/*!40000 ALTER TABLE `submit_submissioncheck` DISABLE KEYS */;
/*!40000 ALTER TABLE `submit_submissioncheck` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `submit_submissionemailevent`
--
DROP TABLE IF EXISTS `submit_submissionemailevent`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `submit_submissionemailevent` (
`submissionevent_ptr_id` int(11) NOT NULL,
`msgtype` varchar(25) NOT NULL,
`in_reply_to_id` int(11) DEFAULT NULL,
`message_id` int(11) DEFAULT NULL,
PRIMARY KEY (`submissionevent_ptr_id`),
KEY `submit_submissionemailevent_48c25820` (`in_reply_to_id`),
KEY `submit_submissionemailevent_4ccaa172` (`message_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `submit_submissionemailevent`
--
LOCK TABLES `submit_submissionemailevent` WRITE;
/*!40000 ALTER TABLE `submit_submissionemailevent` DISABLE KEYS */;
/*!40000 ALTER TABLE `submit_submissionemailevent` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `submit_submissionevent`
--
DROP TABLE IF EXISTS `submit_submissionevent`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `submit_submissionevent` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`submission_id` int(11) NOT NULL,
`time` datetime /* mariadb-5.3 */ NOT NULL DEFAULT '2013-12-20 14:56:48',
`by_id` int(11) DEFAULT NULL,
`desc` longtext NOT NULL,
PRIMARY KEY (`id`),
KEY `submit_submissionevent_b3d6235a` (`submission_id`),
KEY `submit_submissionevent_3acff7b7` (`by_id`),
KEY `submit_subm_time_fcd790_idx` (`time`,`id`)
) ENGINE=MyISAM AUTO_INCREMENT=233024 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `submit_submissionevent`
--
LOCK TABLES `submit_submissionevent` WRITE;
/*!40000 ALTER TABLE `submit_submissionevent` DISABLE KEYS */;
/*!40000 ALTER TABLE `submit_submissionevent` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `submit_submissionextresource`
--
DROP TABLE IF EXISTS `submit_submissionextresource`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `submit_submissionextresource` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`display_name` varchar(255) NOT NULL,
`value` varchar(2083) NOT NULL,
`name_id` varchar(32) NOT NULL,
`submission_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `submit_submissionextresource_name_id_0ec74579` (`name_id`),
KEY `submit_submissionextresource_submission_id_bf26096c` (`submission_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3591 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `submit_submissionextresource`
--
LOCK TABLES `submit_submissionextresource` WRITE;
/*!40000 ALTER TABLE `submit_submissionextresource` DISABLE KEYS */;
/*!40000 ALTER TABLE `submit_submissionextresource` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tastypie_apiaccess`
--
DROP TABLE IF EXISTS `tastypie_apiaccess`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tastypie_apiaccess` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`identifier` varchar(255) NOT NULL,
`url` longtext NOT NULL,
`request_method` varchar(10) NOT NULL,
`accessed` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tastypie_apiaccess`
--
LOCK TABLES `tastypie_apiaccess` WRITE;
/*!40000 ALTER TABLE `tastypie_apiaccess` DISABLE KEYS */;
/*!40000 ALTER TABLE `tastypie_apiaccess` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `tastypie_apikey`
--
DROP TABLE IF EXISTS `tastypie_apikey`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tastypie_apikey` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`key` varchar(256) NOT NULL,
`created` datetime NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `user_id` (`user_id`),
KEY `tastypie_apikey_key_index` (`key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `tastypie_apikey`
--
LOCK TABLES `tastypie_apikey` WRITE;
/*!40000 ALTER TABLE `tastypie_apikey` DISABLE KEYS */;
/*!40000 ALTER TABLE `tastypie_apikey` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `telechat`
--
DROP TABLE IF EXISTS `telechat`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `telechat` (
`telechat_id` int(11) NOT NULL,
`telechat_date` date DEFAULT NULL,
`minute_approved` int(11) DEFAULT NULL,
`wg_news_txt` longtext NOT NULL,
`iab_news_txt` longtext NOT NULL,
`management_issue` longtext NOT NULL,
`frozen` int(11) DEFAULT NULL,
`mi_frozen` int(11) DEFAULT NULL,
PRIMARY KEY (`telechat_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `telechat`
--
LOCK TABLES `telechat` WRITE;
/*!40000 ALTER TABLE `telechat` DISABLE KEYS */;
/*!40000 ALTER TABLE `telechat` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `utils_dumpinfo`
--
DROP TABLE IF EXISTS `utils_dumpinfo`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `utils_dumpinfo` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`date` datetime NOT NULL,
`host` varchar(128) NOT NULL,
`tz` varchar(32) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `utils_dumpinfo`
--
LOCK TABLES `utils_dumpinfo` WRITE;
/*!40000 ALTER TABLE `utils_dumpinfo` DISABLE KEYS */;
/*!40000 ALTER TABLE `utils_dumpinfo` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `utils_versioninfo`
--
DROP TABLE IF EXISTS `utils_versioninfo`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `utils_versioninfo` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`time` datetime(6) NOT NULL,
`command` varchar(32) NOT NULL,
`switch` varchar(16) NOT NULL,
`version` varchar(64) NOT NULL,
`used` tinyint(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `utils_versioninfo`
--
LOCK TABLES `utils_versioninfo` WRITE;
/*!40000 ALTER TABLE `utils_versioninfo` DISABLE KEYS */;
/*!40000 ALTER TABLE `utils_versioninfo` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `workflows_state`
--
DROP TABLE IF EXISTS `workflows_state`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `workflows_state` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`workflow_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `workflows_state_26cddbc7` (`workflow_id`)
) ENGINE=MyISAM AUTO_INCREMENT=63 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `workflows_state`
--
LOCK TABLES `workflows_state` WRITE;
/*!40000 ALTER TABLE `workflows_state` DISABLE KEYS */;
/*!40000 ALTER TABLE `workflows_state` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `workflows_state_transitions`
--
DROP TABLE IF EXISTS `workflows_state_transitions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `workflows_state_transitions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`state_id` int(11) NOT NULL,
`transition_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `workflows_state_transitions_b9608dc2` (`state_id`),
KEY `workflows_state_transitions_78d221b3` (`transition_id`)
) ENGINE=MyISAM AUTO_INCREMENT=481 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `workflows_state_transitions`
--
LOCK TABLES `workflows_state_transitions` WRITE;
/*!40000 ALTER TABLE `workflows_state_transitions` DISABLE KEYS */;
/*!40000 ALTER TABLE `workflows_state_transitions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `workflows_transition`
--
DROP TABLE IF EXISTS `workflows_transition`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `workflows_transition` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`workflow_id` int(11) NOT NULL,
`destination_id` int(11) DEFAULT NULL,
`condition` varchar(100) NOT NULL,
`permission_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `workflows_transition_26cddbc7` (`workflow_id`),
KEY `workflows_transition_90a09905` (`destination_id`),
KEY `workflows_transition_1e014c8f` (`permission_id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `workflows_transition`
--
LOCK TABLES `workflows_transition` WRITE;
/*!40000 ALTER TABLE `workflows_transition` DISABLE KEYS */;
/*!40000 ALTER TABLE `workflows_transition` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `workflows_workflow`
--
DROP TABLE IF EXISTS `workflows_workflow`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `workflows_workflow` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`initial_state_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
KEY `workflows_workflow_84f4d443` (`initial_state_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `workflows_workflow`
--
LOCK TABLES `workflows_workflow` WRITE;
/*!40000 ALTER TABLE `workflows_workflow` DISABLE KEYS */;
/*!40000 ALTER TABLE `workflows_workflow` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2022-08-03 22:40:55
COMMIT;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment