19547c1efd3b65c213695bb589e9b1a17d59a944
[mmondor.git] / mmsoftware / mmmail / scripts / tables.sql
1 # $Id: tables.sql,v 1.15 2004/11/16 13:43:06 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 PRIMARY KEY (alias_domain,alias_pattern,alias_box)
19 ) TYPE=MyISAM;
20
21 #
22 # Table structure for table 'box'
23 #
24
25 CREATE TABLE box (
26 box_address varchar(64) NOT NULL default '',
27 box_user varchar(32) NOT NULL,
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',
32 box_filter tinyint(1) NOT NULL default '0',
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 #
40 # Table structure for table 'filter'
41 #
42
43 CREATE TABLE filter (
44 filter_address varchar(64) NOT NULL default '',
45 filter_allow varchar(64) NOT NULL default '',
46 filter_created datetime NOT NULL default '0000-00-00 00:00:00',
47 PRIMARY KEY (filter_address,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;