Lines 24-30
Link Here
|
24 |
sieve int(10) NOT NULL default '1', |
24 |
sieve int(10) NOT NULL default '1', |
25 |
smtpauth int(10) NOT NULL default '1', |
25 |
smtpauth int(10) NOT NULL default '1', |
26 |
UNIQUE KEY username (username) |
26 |
UNIQUE KEY username (username) |
27 |
) TYPE=MyISAM; |
27 |
) engine=MariaDB; |
28 |
# -------------------------------------------------------- |
28 |
# -------------------------------------------------------- |
29 |
|
29 |
|
30 |
# |
30 |
# |
Lines 38-44
Link Here
|
38 |
SID varchar(255) NOT NULL default '', |
38 |
SID varchar(255) NOT NULL default '', |
39 |
home varchar(255) NOT NULL default '', |
39 |
home varchar(255) NOT NULL default '', |
40 |
PRIMARY KEY (username) |
40 |
PRIMARY KEY (username) |
41 |
) TYPE=MyISAM; |
41 |
) engine=MariaDB; |
42 |
# -------------------------------------------------------- |
42 |
# -------------------------------------------------------- |
43 |
|
43 |
|
44 |
# |
44 |
# |
Lines 51-57
Link Here
|
51 |
`maxdisplay` int(4) NOT NULL default '15', |
51 |
`maxdisplay` int(4) NOT NULL default '15', |
52 |
`warnlevel` int(3) NOT NULL default '90', |
52 |
`warnlevel` int(3) NOT NULL default '90', |
53 |
PRIMARY KEY (username) |
53 |
PRIMARY KEY (username) |
54 |
) TYPE=MyISAM; |
54 |
) engine=MariaDB; |
55 |
# -------------------------------------------------------- |
55 |
# -------------------------------------------------------- |
56 |
|
56 |
|
57 |
# |
57 |
# |
Lines 64-70
Link Here
|
64 |
username varchar(50) NOT NULL default '', |
64 |
username varchar(50) NOT NULL default '', |
65 |
status int(11) NOT NULL default '1', |
65 |
status int(11) NOT NULL default '1', |
66 |
PRIMARY KEY (alias) |
66 |
PRIMARY KEY (alias) |
67 |
) TYPE=MyISAM; |
67 |
) engine=MariaDB; |
68 |
# -------------------------------------------------------- |
68 |
# -------------------------------------------------------- |
69 |
|
69 |
|
70 |
# |
70 |
# |
Lines 83-89
Link Here
|
83 |
folders varchar(255) NOT NULL default '', |
83 |
folders varchar(255) NOT NULL default '', |
84 |
PRIMARY KEY (domain_name), |
84 |
PRIMARY KEY (domain_name), |
85 |
UNIQUE KEY prefix (prefix) |
85 |
UNIQUE KEY prefix (prefix) |
86 |
) TYPE=MyISAM; |
86 |
) engine=MariaDB; |
87 |
# -------------------------------------------------------- |
87 |
# -------------------------------------------------------- |
88 |
|
88 |
|
89 |
# |
89 |
# |
Lines 93-99
Link Here
|
93 |
CREATE TABLE domainadmin ( |
93 |
CREATE TABLE domainadmin ( |
94 |
domain_name varchar(255) NOT NULL default '', |
94 |
domain_name varchar(255) NOT NULL default '', |
95 |
adminuser varchar(255) NOT NULL default '' |
95 |
adminuser varchar(255) NOT NULL default '' |
96 |
) TYPE=MyISAM; |
96 |
) engine=MariaDB; |
97 |
# -------------------------------------------------------- |
97 |
# -------------------------------------------------------- |
98 |
|
98 |
|
99 |
# |
99 |
# |
Lines 104-113
Link Here
|
104 |
search_id varchar(255) NOT NULL default '', |
104 |
search_id varchar(255) NOT NULL default '', |
105 |
search_sql text NOT NULL, |
105 |
search_sql text NOT NULL, |
106 |
perpage int(11) NOT NULL default '0', |
106 |
perpage int(11) NOT NULL default '0', |
107 |
timestamp timestamp(14) NOT NULL, |
107 |
timestamp timestamp, |
108 |
PRIMARY KEY (search_id), |
108 |
PRIMARY KEY (search_id), |
109 |
KEY search_id (search_id) |
109 |
KEY search_id (search_id) |
110 |
) TYPE=MyISAM; |
110 |
) engine=MariaDB; |
111 |
# -------------------------------------------------------- |
111 |
# -------------------------------------------------------- |
112 |
|
112 |
|
113 |
# |
113 |
# |
Lines 120-126
Link Here
|
120 |
username varchar(50) NOT NULL default '', |
120 |
username varchar(50) NOT NULL default '', |
121 |
status int(11) NOT NULL default '1', |
121 |
status int(11) NOT NULL default '1', |
122 |
KEY alias (alias) |
122 |
KEY alias (alias) |
123 |
) TYPE=MyISAM; |
123 |
) engine=MariaDB; |
124 |
|
124 |
|
125 |
CREATE TABLE log ( |
125 |
CREATE TABLE log ( |
126 |
id int(11) NOT NULL auto_increment, |
126 |
id int(11) NOT NULL auto_increment, |
Lines 130-136
Link Here
|
130 |
time datetime NOT NULL default '2000-00-00 00:00:00', |
130 |
time datetime NOT NULL default '2000-00-00 00:00:00', |
131 |
pid varchar(255) NOT NULL default '', |
131 |
pid varchar(255) NOT NULL default '', |
132 |
PRIMARY KEY (id) |
132 |
PRIMARY KEY (id) |
133 |
) TYPE=MyISAM; |
133 |
) engine=MariaDB; |
134 |
|
134 |
|
135 |
INSERT INTO adminuser (username, password) VALUES ('admin', ENCRYPT('test')); |
135 |
INSERT INTO adminuser (username, password) VALUES ('admin', ENCRYPT('test')); |
136 |
INSERT INTO domainadmin (domain_name,adminuser) VALUES ('*','admin'); |
136 |
INSERT INTO domainadmin (domain_name,adminuser) VALUES ('*','admin'); |