-- This file is autogenerated by the Rail schema generator, using -- the schema defined in db/migration/*.rb -- -- Do not edit this file. Instead, add a new migration using -- ./script/generate migration , and then run -- ./script/generate schema -- tables CREATE TABLE addresses ( `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `address` text, `active` tinyint(1) DEFAULT 1, `delivery_attempts` int(11) DEFAULT 0, `bounces` int(11) DEFAULT 0 ) ENGINE=InnoDB; CREATE TABLE addresses_mailinglists ( `address_id` int(11), `mailinglist_id` int(11) ) ENGINE=InnoDB; CREATE TABLE admin_messages ( `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `message` text NOT NULL ) ENGINE=InnoDB; CREATE TABLE confirmationcodes ( `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `mailinglist_id` int(11), `address_id` int(11), `code` text NOT NULL, `confirmed` tinyint(1) DEFAULT 0 ) ENGINE=InnoDB; CREATE TABLE domains ( `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `name` varchar(255) NOT NULL, `password` text NOT NULL ) ENGINE=InnoDB; CREATE TABLE helps ( `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `facility` varchar(255), `command` varchar(255), `parameters` varchar(255), `summary` varchar(255), `explanation` text ) ENGINE=InnoDB; CREATE TABLE mailinglist_classes ( `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `name` text NOT NULL, `description` text, `public` tinyint(1) DEFAULT 0 NOT NULL, `closed` tinyint(1) DEFAULT 0 NOT NULL, `moderated` tinyint(1) DEFAULT 0 NOT NULL, `confirmation` tinyint(1) DEFAULT 1 NOT NULL, `joinable` tinyint(1) DEFAULT 1 NOT NULL, `archived` tinyint(1) DEFAULT 0, `proxify` tinyint(1) DEFAULT 0 ) ENGINE=InnoDB; CREATE TABLE mailinglists ( `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `user_id` int(11), `name` text NOT NULL, `description` text, `welcome_admin_message_id` int(11) DEFAULT 1, `confirmed_admin_message_id` int(11) DEFAULT 2, `sayonara_admin_message_id` int(11) DEFAULT 3, `mailinglist_class_id` int(11) ) ENGINE=InnoDB; CREATE TABLE messages ( `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `mailinglist_id` int(11), `address_id` int(11), `parent_id` int(11), `subject` varchar(255), `messageid` varchar(255), `timestamp` datetime, `headers` text, `body` text, `envelope_from` text, `envelope_to` text ) ENGINE=InnoDB; CREATE TABLE proxy_links ( `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `mailinglist_id` int(11) NOT NULL, `address_id` int(11) NOT NULL ) ENGINE=InnoDB; CREATE TABLE sys_configs ( `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `name` varchar(255), `value` varchar(255), `description` varchar(255), `priority` int(11) ) ENGINE=InnoDB; CREATE TABLE users ( `id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `login` text NOT NULL, `password` text NOT NULL, `mailinglist_id` int(11), `domainadmin` tinyint(1) DEFAULT 0, `domain_id` int(11), `mailinglistadmin` tinyint(1) DEFAULT 0, `virtual` tinyint(1) DEFAULT 0 ) ENGINE=InnoDB; -- schema version meta-info CREATE TABLE schema_info ( `version` int(11) ) ENGINE=InnoDB; insert into schema_info (version) values (27);