| Index: trunk/extensions/ConfirmAccount/schema/mysql/patch-account_credentials.sql |
| — | — | @@ -20,7 +20,7 @@ |
| 21 | 21 | -- Initially NULL; when a user's e-mail address has been |
| 22 | 22 | -- validated by returning with a mailed token, this is |
| 23 | 23 | -- set to the current timestamp. |
| 24 | | - acd_email_authenticated binary(14) default NULL, |
| | 24 | + acd_email_authenticated varbinary(14) default NULL, |
| 25 | 25 | -- A little about this user |
| 26 | 26 | acd_bio mediumblob NOT NULL, |
| 27 | 27 | -- Private info for reviewers to look at when considering request |
| — | — | @@ -36,10 +36,10 @@ |
| 37 | 37 | acd_areas mediumblob NOT NULL, |
| 38 | 38 | |
| 39 | 39 | -- Timestamp of account registration. |
| 40 | | - acd_registration char(14) NOT NULL, |
| | 40 | + acd_registration varbinary(14) NOT NULL, |
| 41 | 41 | |
| 42 | 42 | -- Timestamp of acceptance |
| 43 | | - acd_accepted binary(14), |
| | 43 | + acd_accepted varbinary(14), |
| 44 | 44 | -- The user who accepted it |
| 45 | 45 | acd_user int unsigned NOT NULL default 0, |
| 46 | 46 | -- Reason given in email |
| Index: trunk/extensions/ConfirmAccount/schema/mysql/ConfirmAccount.sql |
| — | — | @@ -21,12 +21,12 @@ |
| 22 | 22 | -- Initially NULL; when a user's e-mail address has been |
| 23 | 23 | -- validated by returning with a mailed token, this is |
| 24 | 24 | -- set to the current timestamp. |
| 25 | | - acr_email_authenticated binary(14) default NULL, |
| | 25 | + acr_email_authenticated varbinary(14) default NULL, |
| 26 | 26 | -- Randomly generated token created when the e-mail address |
| 27 | 27 | -- is set and a confirmation test mail sent. |
| 28 | 28 | acr_email_token binary(32), |
| 29 | 29 | -- Expiration date for the user_email_token |
| 30 | | - acr_email_token_expires binary(14), |
| | 30 | + acr_email_token_expires varbinary(14), |
| 31 | 31 | -- A little about this user |
| 32 | 32 | acr_bio mediumblob NOT NULL, |
| 33 | 33 | -- Private info for reviewers to look at when considering request |
| — | — | @@ -44,14 +44,14 @@ |
| 45 | 45 | acr_areas mediumblob NOT NULL, |
| 46 | 46 | |
| 47 | 47 | -- Timestamp of account registration. |
| 48 | | - acr_registration char(14) NOT NULL, |
| | 48 | + acr_registration varbinary(14) NOT NULL, |
| 49 | 49 | |
| 50 | 50 | -- Flag for rejected accounts |
| 51 | 51 | acr_deleted bool NOT NULL, |
| 52 | 52 | -- Time of rejection (if rejected) |
| 53 | | - acr_rejected binary(14), |
| | 53 | + acr_rejected varbinary(14), |
| 54 | 54 | -- Time request was put on hold (if held) |
| 55 | | - acr_held binary(14), |
| | 55 | + acr_held varbinary(14), |
| 56 | 56 | -- The user who rejected/held it |
| 57 | 57 | acr_user int unsigned NOT NULL default 0, |
| 58 | 58 | -- Reason |
| — | — | @@ -78,7 +78,7 @@ |
| 79 | 79 | -- Initially NULL; when a user's e-mail address has been |
| 80 | 80 | -- validated by returning with a mailed token, this is |
| 81 | 81 | -- set to the current timestamp. |
| 82 | | - acd_email_authenticated binary(14) default NULL, |
| | 82 | + acd_email_authenticated varbinary(14) default NULL, |
| 83 | 83 | -- A little about this user |
| 84 | 84 | acd_bio mediumblob NOT NULL, |
| 85 | 85 | -- Private info for reviewers to look at when considering request |
| — | — | @@ -94,10 +94,10 @@ |
| 95 | 95 | acd_areas mediumblob NOT NULL, |
| 96 | 96 | |
| 97 | 97 | -- Timestamp of account registration. |
| 98 | | - acd_registration char(14) NOT NULL, |
| | 98 | + acd_registration varbinary(14) NOT NULL, |
| 99 | 99 | |
| 100 | 100 | -- Timestamp of acceptance |
| 101 | | - acd_accepted binary(14), |
| | 101 | + acd_accepted varbinary(14), |
| 102 | 102 | -- The user who accepted it |
| 103 | 103 | acd_user int unsigned NOT NULL default 0, |
| 104 | 104 | -- Reason given in email |