Up to [Platon] / mylist / sql

- new features in data model
  - table mylist_administrators - list of administrators (users that are
    allowed to create new lists, manage threads, etc)

-- MySQL dump 9.11
--
-- Host: localhost    Database: mylist
-- ------------------------------------------------------
-- Server version    4.0.24_Debian-2-log

--
-- Table structure for table `mylist_administrators`
--

DROP TABLE IF EXISTS `mylist_administrators`;
CREATE TABLE `mylist_administrators` (
  `user_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`user_id`)
) TYPE=MyISAM;

--
-- Table structure for table `mylist_list_stats`
--

DROP TABLE IF EXISTS `mylist_list_stats`;
CREATE TABLE `mylist_list_stats` (
  `list_id` int(11) NOT NULL default '0',
  `dt_created` datetime NOT NULL default '0000-00-00 00:00:00',
  `dt_last_used` datetime NOT NULL default '0000-00-00 00:00:00',
  `times_used` int(11) NOT NULL default '0',
  PRIMARY KEY  (`list_id`)
) TYPE=MyISAM;

--
-- Table structure for table `mylist_list_users`
--

DROP TABLE IF EXISTS `mylist_list_users`;
CREATE TABLE `mylist_list_users` (
  `list_id` int(11) NOT NULL default '0',
  `user_id` int(11) NOT NULL default '0',
  `email` varchar(255) default NULL,
  `f_admin` tinyint(4) default '0',
  PRIMARY KEY  (`list_id`,`user_id`)
) TYPE=MyISAM;

--
-- Table structure for table `mylist_lists`
--

DROP TABLE IF EXISTS `mylist_lists`;
CREATE TABLE `mylist_lists` (
  `id` int(11) NOT NULL auto_increment,
  `project_id` int(11) NOT NULL default '0',
  `name` varchar(60) NOT NULL default '',
  `short_desc` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `f_reply_to_mlist` tinyint(1) unsigned NOT NULL default '1',
  `f_prefix_subject` tinyint(1) unsigned NOT NULL default '0',
  `f_append_sig` tinyint(1) unsigned NOT NULL default '1',
  `f_mail_back_to_sender` tinyint(1) unsigned NOT NULL default '1',
  `f_members_only_post` tinyint(1) unsigned NOT NULL default '1',
  `f_archive` tinyint(1) unsigned NOT NULL default '1',
  `f_archive_for_members_only` tinyint(1) unsigned NOT NULL default '1',
  `max_message_size` int(11) NOT NULL default '0',
  `max_attachement_size` int(11) NOT NULL default '0',
  `f_valid` tinyint(4) NOT NULL default '1',
  `f_free_subscriptions` tinyint(4) NOT NULL default '1',
  `prefix` varchar(64) default 'Prefix',
  `signature` text,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `mylist_lists_name` (`name`)
) TYPE=MyISAM;

--
-- Table structure for table `mylist_message_atts`
--

DROP TABLE IF EXISTS `mylist_message_atts`;
CREATE TABLE `mylist_message_atts` (
  `id` int(11) NOT NULL auto_increment,
  `message_id` int(11) NOT NULL default '0',
  `atts_headers` longtext,
  `atts_body` longblob,
  `path` varchar(255) default NULL,
  `filename` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

--
-- Table structure for table `mylist_messages`
--

DROP TABLE IF EXISTS `mylist_messages`;
CREATE TABLE `mylist_messages` (
  `id` int(11) NOT NULL auto_increment,
  `list_id` int(11) NOT NULL default '0',
  `messageid` varchar(200) NOT NULL default '',
  `from` varchar(255) NOT NULL default '',
  `dt_header` datetime default NULL,
  `dt_received` datetime default NULL,
  `header` text,
  `subject` text,
  `body` text,
  `parent_id` int(11) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `messageid` (`messageid`,`list_id`)
) TYPE=MyISAM;

--
-- Table structure for table `mylist_queue`
--

DROP TABLE IF EXISTS `mylist_queue`;
CREATE TABLE `mylist_queue` (
  `queue_message_id` int(11) NOT NULL default '0',
  `recipient` varchar(255) NOT NULL default '',
  `dt_queued` datetime default NULL,
  `dt_sent` datetime default NULL,
  PRIMARY KEY  (`queue_message_id`,`recipient`)
) TYPE=MyISAM;

--
-- Table structure for table `mylist_queue_messages`
--

DROP TABLE IF EXISTS `mylist_queue_messages`;
CREATE TABLE `mylist_queue_messages` (
  `id` int(11) NOT NULL auto_increment,
  `message_header` longtext NOT NULL,
  `message_body` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

--
-- Table structure for table `mylist_search_index`
--

DROP TABLE IF EXISTS `mylist_search_index`;
CREATE TABLE `mylist_search_index` (
  `message_id` int(11) NOT NULL default '0',
  `word` char(48) NOT NULL default '',
  `search_type_id` int(11) NOT NULL default '0',
  `weight` float default NULL,
  PRIMARY KEY  (`message_id`,`word`,`search_type_id`)
) TYPE=MyISAM;

--
-- Table structure for table `mylist_search_types`
--

DROP TABLE IF EXISTS `mylist_search_types`;
CREATE TABLE `mylist_search_types` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `description` varchar(255) default NULL,
  `default_weight` float default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

--
-- Table structure for table `mylist_senders`
--

DROP TABLE IF EXISTS `mylist_senders`;
CREATE TABLE `mylist_senders` (
  `list_id` int(11) NOT NULL default '0',
  `user_email` varchar(255) NOT NULL default '',
  `permission` enum('allow','deny') NOT NULL default 'deny',
  PRIMARY KEY  (`list_id`,`user_email`)
) TYPE=MyISAM;

--
-- Table structure for table `projects`
--

DROP TABLE IF EXISTS `projects`;
CREATE TABLE `projects` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(64) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `uk_proj_name` (`name`)
) TYPE=MyISAM;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(32) NOT NULL default '',
  `password` varchar(32) NOT NULL default '',
  `reg_email` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `uk_user_name` (`name`)
) TYPE=MyISAM;