| Revision 1004,
495 bytes
checked in by remi, 7 years ago
(diff) |
|
encryptage du mot de passe dans ftpusers
|
| Line | |
|---|
| 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!=''; |
|---|
Note: See
TracBrowser
for help on using the repository browser.
