| Index: trunk/extensions/EmailCapture/sql/CreateEmailCaptureTable.sql |
| — | — | @@ -1,9 +1,9 @@ |
| 2 | 2 | -- Captured email addresses |
| 3 | 3 | CREATE TABLE IF NOT EXISTS /*_*/email_capture ( |
| 4 | 4 | -- Email address |
| 5 | | - ec_email tinytext NOT NULL, |
| | 5 | + ec_email varbinary(255) NOT NULL DEFAULT '', |
| 6 | 6 | -- Additional information |
| 7 | | - ec_info blob NOT NULL, |
| | 7 | + ec_info blob NOT NULL DEFAULT '', |
| 8 | 8 | -- Verification code |
| 9 | 9 | ec_code varbinary(32) NOT NULL DEFAULT '', |
| 10 | 10 | -- Verified |