Alternc  latest
Alternc logiel libre pour l'hébergement
0.9.10.sql
Go to the documentation of this file.
1 ALTER IGNORE TABLE `membres` ADD COLUMN `notes` TEXT NOT NULL AFTER `type`;
2 
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,
9  PRIMARY KEY (`name`)
10 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='The password policies for services';
11 
12 
13 INSERT IGNORE INTO `variable` (`name` ,`value` ,`comment`)
14 VALUES (
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. '
17 );
18 
19 -- --------------------------------------------------------
20 -- TABLES de mémorisation de la taille des dossiers db/listes
21 
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,
26  PRIMARY KEY (`db`),
27  KEY `ts` (`ts`)
28 ) TYPE=MyISAM COMMENT='MySQL Database used space';
29 
30 
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,
36  PRIMARY KEY (`list`),
37  KEY `ts` (`ts`),
38  KEY `uid` (`uid`)
39 ) ENGINE=MyISAM COMMENT='Mailman Lists used space';
40 
41 -- IPv6 compatibility :
42 ALTER TABLE `slaveip` CHANGE `ip` `ip` VARCHAR(40);
43 ALTER TABLE `sessions` CHANGE `ip` `ip` VARCHAR( 40 ) NULL;
44 
45 --- type subdomain evolution
46 ALTER TABLE `sub_domaines` CHANGE `type` `type` VARCHAR(30);
47 ALTER TABLE `sub_domaines_standby` CHANGE `type` `type` VARCHAR(30);
48