*** empty log message ***
[mmondor.git] / mmsoftware / mmmail / scripts / tables.sql
CommitLineData
a4da92fc 1# $Id: tables.sql,v 1.20 2005/03/26 11:45:44 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 16 alias_box varchar(64) NOT NULL default '',
b251005b 17 alias_created datetime NOT NULL default '0000-00-00 00:00:00',
64e7e8a5 18 PRIMARY KEY (alias_domain,alias_pattern,alias_box)
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 '',
92bee4b2 27 box_user varchar(32) NOT NULL,
47071c2b
MM
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_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',
b251005b
MM
35 box_filter tinyint(1) NOT NULL default '0',
36 box_description varchar(64) NOT NULL default '',
47071c2b
MM
37 PRIMARY KEY (box_address)
38) TYPE=MyISAM;
39
40#
edc0a306
MM
41# Table structure for table 'filter'
42#
43
44CREATE TABLE filter (
45 filter_address varchar(64) NOT NULL default '',
a4da92fc 46 filter_pattern varchar(128) NOT NULL default '',
feed424e 47 filter_created datetime NOT NULL default '0000-00-00 00:00:00',
1693a306 48 filter_description varchar(64) NOT NULL default '',
64e7e8a5 49 PRIMARY KEY (filter_address,filter_allow)
edc0a306
MM
50) TYPE=MyISAM;
51
52#
47071c2b
MM
53# Table structure for table 'mail'
54#
55
56CREATE TABLE mail (
57 mail_id bigint(20) NOT NULL auto_increment,
58 mail_box varchar(64) NOT NULL default '',
5f8db290 59 mail_file varchar(255),
47071c2b
MM
60 mail_created datetime NOT NULL default '0000-00-00 00:00:00',
61 mail_size int(11) NOT NULL default '0',
c1038113 62 mail_data longtext,
47071c2b
MM
63 PRIMARY KEY (mail_id),
64 KEY mail_box (mail_box)
65) TYPE=MyISAM;
66
67#
68# Table structure for table 'nofrom'
69#
70
71CREATE TABLE nofrom (
72 nofrom_pattern varchar(64) NOT NULL default '',
73 PRIMARY KEY (nofrom_pattern)
74) TYPE=MyISAM;
75
76#
77# Table structure for table 'user'
78#
79
80CREATE TABLE user (
92bee4b2 81 user_id varchar(32) NOT NULL,
47071c2b 82 user_name varchar(64) NOT NULL default '',
8a21b7a2 83 user_passwd char(34) binary NOT NULL default '',
47071c2b
MM
84 user_created datetime NOT NULL default '0000-00-00 00:00:00',
85 user_activity datetime NOT NULL default '0000-00-00 00:00:00',
86 user_logins bigint(20) NOT NULL default '0',
47071c2b 87 user_active tinyint(1) NOT NULL default '1',
978cad00 88 user_admin tinyint(1) NOT NULL default '0',
47071c2b
MM
89 PRIMARY KEY (user_id)
90) TYPE=MyISAM;
91
193955a0
MM
92#
93# Table structure for table 'relayqueue'
94#
95
96CREATE TABLE relayqueue (
97 relayqueue_id bigint(20) NOT NULL auto_increment,
98 relayqueue_from varchar(64) NOT NULL default '',
99 relayqueue_ipaddr varchar(16) NOT NULL default '0.0.0.0',
f2c550b1
MM
100 relayqueue_todomain varchar(64) NOT NULL default '',
101 relayqueue_touser varchar(64) NOT NULL default '',
193955a0
MM
102 relayqueue_size int(11) NOT NULL default '0',
103 relayqueue_file varchar(255) NOT NULL default '',
104 relayqueue_queued datetime NOT NULL default '0000-00-00 00:00:00',
105 relayqueue_lasttry datetime NOT NULL default '0000-00-00 00:00:00',
106 relayqueue_expire datetime NOT NULL default '0000-00-00 00:00:00',
107 relayqueue_tries int(11) NOT NULL default '0',
108 relayqueue_lasterror int(11) NOT NULL default '0',
109 PRIMARY KEY (relayqueue_id)
110) TYPE=MyISAM;
111
112#
113# Table structure for table 'relaylocal'
114#
115
116CREATE TABLE relaylocal (
117 relaylocal_pattern varchar(64) NOT NULL default '',
118 PRIMARY KEY (relaylocal_pattern)
119) TYPE=MyISAM;
120
121#
122# Table structure for table 'relayfrom'
123#
124
125CREATE TABLE relayfrom (
126 relayfrom_pattern varchar(64) NOT NULL default '',
127 PRIMARY KEY (relayfrom_pattern)
128) TYPE=MyISAM;
6da9fada
MM
129
130#
131# Table structure for table `session`
132#
133
134CREATE TABLE session (
135 session_id varchar(64) binary NOT NULL default '',
136 session_expires int(11) NOT NULL default '0',
137 session_data text NOT NULL,
138 PRIMARY KEY (session_id)
139) TYPE=MyISAM;
978cad00
MM
140
141#
142# Table structure for table `boxdelete`
143#
144
145CREATE TABLE boxdelete (
146 boxdelete_address varchar(64) NOT NULL default '',
147 PRIMARY KEY (boxdelete_address)
148) TYPE=MyISAM;