Alternc
latest
Alternc logiel libre pour l'hébergement
0.9.4.sql
Go to the documentation of this file.
1
-- Ajout du champ 'type' pour les membres
2
ALTER
TABLE
membres
ADD
COLUMN
type
varchar
(
128
)
default
'default'
AFTER admlist;
3
4
-- Ajout du champ 'type' pour les quotas par défaut
5
ALTER
TABLE
defquotas
ADD
COLUMN
type
varchar
(
128
)
default
'default'
AFTER
value
;
6
7
-- we don't store cleartext passwords anymore, we use saslauthd
8
ALTER
TABLE
`mail_users`
DROP
`sasl`;
9
10
-- We don't use "used" quota anymore.
11
ALTER
TABLE
`quotas`
DROP
`used`;
12
13
-- Add a primary key to 'defquotas'
14
ALTER
TABLE
`defquotas`
ADD
PRIMARY
KEY (`quota`,`type`);
install
upgrades
0.9.4.sql
Generated on Sat Sep 16 2023 12:00:04 for Alternc by
1.9.1