450485a318046d8450b7026983098aacb33e9d0e
[mmondor.git] / mmsoftware / mmmail / scripts / tables.sql
1 # $Id: tables.sql,v 1.13 2004/11/15 23:02:03 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 KEY filter_address (filter_address),
46 KEY filter_allow (filter_allow)
47 ) TYPE=MyISAM;
48
49 #
50 # Table structure for table 'mail'
51 #
52
53 CREATE TABLE mail (
54 mail_id bigint(20) NOT NULL auto_increment,
55 mail_box varchar(64) NOT NULL default '',
56 mail_file varchar(255),
57 mail_created datetime NOT NULL default '0000-00-00 00:00:00',
58 mail_size int(11) NOT NULL default '0',
59 mail_data longtext,
60 PRIMARY KEY (mail_id),
61 KEY mail_box (mail_box)
62 ) TYPE=MyISAM;
63
64 #
65 # Table structure for table 'nofrom'
66 #
67
68 CREATE TABLE nofrom (
69 nofrom_pattern varchar(64) NOT NULL default '',
70 PRIMARY KEY (nofrom_pattern)
71 ) TYPE=MyISAM;
72
73 #
74 # Table structure for table 'user'
75 #
76
77 CREATE TABLE user (
78 user_id varchar(32) NOT NULL,
79 user_name varchar(64) NOT NULL default '',
80 user_passwd char(34) binary NOT NULL default '',
81 user_created datetime NOT NULL default '0000-00-00 00:00:00',
82 user_activity datetime NOT NULL default '0000-00-00 00:00:00',
83 user_logins bigint(20) NOT NULL default '0',
84 user_active tinyint(1) NOT NULL default '1',
85 PRIMARY KEY (user_id)
86 ) TYPE=MyISAM;
87
88 #
89 # Table structure for table 'relayqueue'
90 #
91
92 CREATE TABLE relayqueue (
93 relayqueue_id bigint(20) NOT NULL auto_increment,
94 relayqueue_from varchar(64) NOT NULL default '',
95 relayqueue_ipaddr varchar(16) NOT NULL default '0.0.0.0',
96 relayqueue_todomain varchar(64) NOT NULL default '',
97 relayqueue_touser varchar(64) NOT NULL default '',
98 relayqueue_size int(11) NOT NULL default '0',
99 relayqueue_file varchar(255) NOT NULL default '',
100 relayqueue_queued datetime NOT NULL default '0000-00-00 00:00:00',
101 relayqueue_lasttry datetime NOT NULL default '0000-00-00 00:00:00',
102 relayqueue_expire datetime NOT NULL default '0000-00-00 00:00:00',
103 relayqueue_tries int(11) NOT NULL default '0',
104 relayqueue_lasterror int(11) NOT NULL default '0',
105 PRIMARY KEY (relayqueue_id)
106 ) TYPE=MyISAM;
107
108 #
109 # Table structure for table 'relaylocal'
110 #
111
112 CREATE TABLE relaylocal (
113 relaylocal_pattern varchar(64) NOT NULL default '',
114 PRIMARY KEY (relaylocal_pattern)
115 ) TYPE=MyISAM;
116
117 #
118 # Table structure for table 'relayfrom'
119 #
120
121 CREATE TABLE relayfrom (
122 relayfrom_pattern varchar(64) NOT NULL default '',
123 PRIMARY KEY (relayfrom_pattern)
124 ) TYPE=MyISAM;