Now issues From: and To: headers automatically if necessary, which seem
[mmondor.git] / mmsoftware / mmmail / scripts / tables.sql
CommitLineData
193955a0 1# $Id: tables.sql,v 1.11 2004/11/09 05:31:14 mmondor Exp $
47071c2b
MM
2#
3# MySQL dump 8.13
4#
5# Host: localhost Database: mmmail
6#--------------------------------------------------------
7# Server version 3.23.35
8
9#
10# Table structure for table 'alias'
11#
12
13CREATE TABLE alias (
42dd3825 14 alias_domain varchar(64) NOT NULL default '',
d5cf2b1f 15 alias_pattern varchar(64) NOT NULL default '',
47071c2b
MM
16 alias_box varchar(64) NOT NULL default '',
17 alias_user bigint(20) NOT NULL default '0',
917e9cbb 18 alias_created datetime NOT NULL default '0000-00-00 00:00:00'
47071c2b
MM
19) TYPE=MyISAM;
20
21#
22# Table structure for table 'box'
23#
24
25CREATE TABLE box (
26 box_address varchar(64) NOT NULL default '',
27 box_user bigint(20) NOT NULL default '0',
28 box_max_size int(11) NOT NULL default '0',
29 box_size int(11) NOT NULL default '0',
30 box_max_msgs int(11) NOT NULL default '0',
31 box_msgs int(11) NOT NULL default '0',
edc0a306 32 box_filter tinyint(1) NOT NULL default '0',
47071c2b
MM
33 box_created datetime NOT NULL default '0000-00-00 00:00:00',
34 box_in datetime NOT NULL default '0000-00-00 00:00:00',
35 box_out datetime NOT NULL default '0000-00-00 00:00:00',
36 PRIMARY KEY (box_address)
37) TYPE=MyISAM;
38
39#
edc0a306
MM
40# Table structure for table 'filter'
41#
42
43CREATE TABLE filter (
44 filter_address varchar(64) NOT NULL default '',
45 filter_allow varchar(64) NOT NULL default '',
e4574856
MM
46 KEY filter_address (filter_address),
47 KEY filter_allow (filter_allow)
edc0a306
MM
48) TYPE=MyISAM;
49
50#
47071c2b
MM
51# Table structure for table 'mail'
52#
53
54CREATE TABLE mail (
55 mail_id bigint(20) NOT NULL auto_increment,
56 mail_box varchar(64) NOT NULL default '',
5f8db290 57 mail_file varchar(255),
47071c2b
MM
58 mail_created datetime NOT NULL default '0000-00-00 00:00:00',
59 mail_size int(11) NOT NULL default '0',
c1038113 60 mail_data longtext,
47071c2b
MM
61 PRIMARY KEY (mail_id),
62 KEY mail_box (mail_box)
63) TYPE=MyISAM;
64
65#
66# Table structure for table 'nofrom'
67#
68
69CREATE TABLE nofrom (
70 nofrom_pattern varchar(64) NOT NULL default '',
71 PRIMARY KEY (nofrom_pattern)
72) TYPE=MyISAM;
73
74#
75# Table structure for table 'user'
76#
77
78CREATE TABLE user (
79 user_id bigint(20) NOT NULL auto_increment,
80 user_name varchar(64) NOT NULL default '',
8a21b7a2 81 user_passwd char(34) binary NOT NULL default '',
47071c2b
MM
82 user_created datetime NOT NULL default '0000-00-00 00:00:00',
83 user_activity datetime NOT NULL default '0000-00-00 00:00:00',
84 user_logins bigint(20) NOT NULL default '0',
85 user_admin bigint(20) NOT NULL default '0',
86 user_active tinyint(1) NOT NULL default '1',
87 PRIMARY KEY (user_id)
88) TYPE=MyISAM;
89
193955a0
MM
90#
91# Table structure for table 'relayqueue'
92#
93
94CREATE TABLE relayqueue (
95 relayqueue_id bigint(20) NOT NULL auto_increment,
96 relayqueue_from varchar(64) NOT NULL default '',
97 relayqueue_ipaddr varchar(16) NOT NULL default '0.0.0.0',
98 relayqueue_to varchar(64) NOT NULL default '',
99 relayqueue_size int(11) NOT NULL default '0',
100 relayqueue_file varchar(255) NOT NULL default '',
101 relayqueue_queued datetime NOT NULL default '0000-00-00 00:00:00',
102 relayqueue_lasttry datetime NOT NULL default '0000-00-00 00:00:00',
103 relayqueue_expire datetime NOT NULL default '0000-00-00 00:00:00',
104 relayqueue_tries int(11) NOT NULL default '0',
105 relayqueue_lasterror int(11) NOT NULL default '0',
106 PRIMARY KEY (relayqueue_id)
107) TYPE=MyISAM;
108
109#
110# Table structure for table 'relaylocal'
111#
112
113CREATE TABLE relaylocal (
114 relaylocal_pattern varchar(64) NOT NULL default '',
115 PRIMARY KEY (relaylocal_pattern)
116) TYPE=MyISAM;
117
118#
119# Table structure for table 'relayfrom'
120#
121
122CREATE TABLE relayfrom (
123 relayfrom_pattern varchar(64) NOT NULL default '',
124 PRIMARY KEY (relayfrom_pattern)
125) TYPE=MyISAM;