diff options
Diffstat (limited to 'updates.sql')
| -rw-r--r-- | updates.sql | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/updates.sql b/updates.sql index 07c4c760c..de7bfa1e4 100644 --- a/updates.sql +++ b/updates.sql @@ -21,4 +21,8 @@ ALTER TABLE `profile` ADD `summary` CHAR( 255 ) NOT NULL AFTER `about` ; ALTER TABLE `profile` ADD `dob_hide` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `dob` ; ALTER TABLE `profile` DROP `age`; - ALTER TABLE `profile` DROP `dob_hide` ;
\ No newline at end of file + ALTER TABLE `profile` DROP `dob_hide` ; + ALTER TABLE `profile` CHANGE `school` `education` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ; + ALTER TABLE `profile` DROP `employer` ; + +ALTER TABLE `profile` ADD `contact` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `education` ;
\ No newline at end of file |