Added filter_created field to filter table
[mmondor.git] / mmsoftware / mmmail / scripts / tables.sql
1 # $Id: tables.sql,v 1.14 2004/11/16 04:51:34 mmondor Exp $
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
13 CREATE TABLE alias (
14 alias_domain varchar(64) NOT NULL default '',
15 alias_pattern varchar(64) NOT NULL default '',
16 alias_box varchar(64) NOT NULL default '',
17 alias_created datetime NOT NULL default '0000-00-00 00:00:00'
18 ) TYPE=MyISAM;
19
20 #
21 # Table structure for table 'box'
22 #
23
24 CREATE TABLE box (
25 box_address varchar(64) NOT NULL default '',
26 box_user varchar(32) NOT NULL,
27 box_max_size int(11) NOT NULL default '0',
28 box_size int(11) NOT NULL default '0',
29 box_max_msgs int(11) NOT NULL default '0',
30 box_msgs int(11) NOT NULL default '0',
31 box_filter tinyint(1) NOT NULL default '0',
32 box_created datetime NOT NULL default '0000-00-00 00:00:00',
33 box_in datetime NOT NULL default '0000-00-00 00:00:00',
34 box_out datetime NOT NULL default '0000-00-00 00:00:00',
35 PRIMARY KEY (box_address)
36 ) TYPE=MyISAM;
37
38 #
39 # Table structure for table 'filter'
40 #
41
42 CREATE TABLE filter (
43 filter_address varchar(64) NOT NULL default '',
44 filter_allow varchar(64) NOT NULL default '',
45 filter_created datetime NOT NULL default '0000-00-00 00:00:00',
46 KEY filter_address (filter_address),
47 KEY filter_allow (filter_allow)
48 ) TYPE=MyISAM;
49
50 #
51 # Table structure for table 'mail'
52 #
53
54 CREATE TABLE mail (
55 mail_id bigint(20) NOT NULL auto_increment,
56 mail_box varchar(64) NOT NULL default '',
57 mail_file varchar(255),
58 mail_created datetime NOT NULL default '0000-00-00 00:00:00',
59 mail_size int(11) NOT NULL default '0',
60 mail_data longtext,
61 PRIMARY KEY (mail_id),
62 KEY mail_box (mail_box)
63 ) TYPE=MyISAM;
64
65 #
66 # Table structure for table 'nofrom'
67 #
68
69 CREATE 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
78 CREATE TABLE user (
79 user_id varchar(32) NOT NULL,
80 user_name varchar(64) NOT NULL default '',
81 user_passwd char(34) binary NOT NULL default '',
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_active tinyint(1) NOT NULL default '1',
86 PRIMARY KEY (user_id)
87 ) TYPE=MyISAM;
88
89 #
90 # Table structure for table 'relayqueue'
91 #
92
93 CREATE TABLE relayqueue (
94 relayqueue_id bigint(20) NOT NULL auto_increment,
95 relayqueue_from varchar(64) NOT NULL default '',
96 relayqueue_ipaddr varchar(16) NOT NULL default '0.0.0.0',
97 relayqueue_todomain varchar(64) NOT NULL default '',
98 relayqueue_touser 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
113 CREATE 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
122 CREATE TABLE relayfrom (
123 relayfrom_pattern varchar(64) NOT NULL default '',
124 PRIMARY KEY (relayfrom_pattern)
125 ) TYPE=MyISAM;