1 ALTER IGNORE
TABLE `membres`
ADD COLUMN `notes` TEXT
NOT NULL AFTER `type`;
3 CREATE TABLE IF NOT EXISTS `policy` (
4 `name`
varchar(
64)
NOT NULL,
5 `minsize` tinyint(
3) unsigned
NOT NULL,
6 `maxsize` tinyint(
3) unsigned
NOT NULL,
7 `classcount` tinyint(
3) unsigned
NOT NULL,
8 `allowlogin` tinyint(
3) unsigned
NOT NULL,
10 ) ENGINE=MyISAM
DEFAULT CHARSET=latin1 COMMENT=
'The password policies for services';
13 INSERT IGNORE
INTO `variable` (`name` ,`
value` ,`comment`)
15 'subadmin_restriction',
'',
16 'This variable set the way the account list works for accounts other than "admin" (2000). 0 (default) = admin other than admin/2000 can see their own account, but not the other one 1 = admin other than admin/2000 can see any account by clicking the ''show all accounts'' link. '
22 CREATE TABLE IF NOT EXISTS `size_db` (
23 `db`
varchar(
255)
NOT NULL default '',
24 `size`
int(
10) unsigned
NOT NULL default '0',
25 `ts`
timestamp(
14)
NOT NULL,
28 ) TYPE=MyISAM COMMENT=
'MySQL Database used space';
31 CREATE TABLE IF NOT EXISTS `size_mailman` (
32 `list`
varchar(
255)
NOT NULL default '',
33 `uid`
int(
11)
NOT NULL default '0',
34 `size`
int(
10) unsigned
NOT NULL default '0',
35 `ts`
timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
39 ) ENGINE=MyISAM COMMENT=
'Mailman Lists used space';
42 ALTER TABLE `slaveip` CHANGE `ip` `ip`
VARCHAR(
40);
43 ALTER TABLE `sessions` CHANGE `ip` `ip`
VARCHAR(
40 )
NULL;
46 ALTER TABLE `sub_domaines` CHANGE `type` `type`
VARCHAR(
30);
47 ALTER TABLE `sub_domaines_standby` CHANGE `type` `type`
VARCHAR(
30);