Alternc
latest
Alternc logiel libre pour l'hébergement
0.9.5.sql
Go to the documentation of this file.
1
-- Pour les durées de comptes
2
ALTER
IGNORE
TABLE
membres
ADD
COLUMN
created datetime
default
NULL
AFTER type;
3
ALTER
IGNORE
TABLE
membres
ADD
COLUMN
renewed datetime
default
NULL
AFTER created;
4
ALTER
IGNORE
TABLE
membres
ADD
COLUMN
duration
int
(
4
)
default
NULL
AFTER renewed;
5
6
-- Pour l'encryptage des mots de passe ftp
7
ALTER
IGNORE
TABLE
ftpusers
ADD
COLUMN
encrypted_password
VARCHAR
(
32
)
default
NULL
AFTER password;
8
UPDATE
ftpusers
SET
encrypted_password=ENCRYPT(password)
WHERE
password!=
''
;
9
10
-- --------------------------------------------------------
11
-- TABLES de mémorisation de la taille des dossiers web/mail/db
12
13
CREATE
TABLE
IF
NOT
EXISTS
`size_db` (
14
`db`
varchar
(
255
)
NOT
NULL
default
''
,
15
`size`
int
(
10
) unsigned
NOT
NULL
default
'0'
,
16
`ts`
timestamp
(
14
)
NOT
NULL
,
17
PRIMARY
KEY (`db`),
18
KEY `ts` (`ts`)
19
) TYPE=MyISAM COMMENT=
'MySQL Database used space'
;
20
21
22
-- --------------------------------------------------------
23
CREATE
TABLE
IF
NOT
EXISTS
`size_mail` (
24
`alias`
varchar
(
255
)
NOT
NULL
default
''
,
25
`size`
int
(
10
) unsigned
NOT
NULL
default
'0'
,
26
`ts`
timestamp
(
14
)
NOT
NULL
,
27
PRIMARY
KEY (`alias`),
28
KEY `ts` (`ts`)
29
) TYPE=MyISAM COMMENT=
'Mail space used by pop accounts.'
;
30
31
-- --------------------------------------------------------
32
CREATE
TABLE
IF
NOT
EXISTS
`size_web` (
33
`uid`
int
(
10
) unsigned
NOT
NULL
default
'0'
,
34
`size`
int
(
10
) unsigned
NOT
NULL
default
'0'
,
35
`ts`
timestamp
(
14
)
NOT
NULL
,
36
PRIMARY
KEY (`uid`),
37
KEY `ts` (`ts`)
38
) TYPE=MyISAM COMMENT=
'Web space used by accounts.'
;
39
40
-- ajout d'une table pour la gestion des utilisateurs mysql
41
CREATE
TABLE
IF
NOT
EXISTS
`dbusers` (
42
`id`
int
(
10
) unsigned
NOT
NULL
auto_increment,
43
`uid`
int
(
10
) unsigned
NOT
NULL
default
'0'
,
44
`name`
varchar
(
16
)
NOT
NULL
default
''
,
45
KEY `id` (`id`)
46
) TYPE=MyISAM COMMENT=
'Utilisateurs MySQL des membres'
;
47
install
upgrades
0.9.5.sql
Generated on Sat Sep 16 2023 12:00:04 for Alternc by
1.9.1