diff options
| author | Mike Macgirvin <mike@macgirvin.com> | 2010-07-10 08:18:58 -0700 |
|---|---|---|
| committer | Mike Macgirvin <mike@macgirvin.com> | 2010-07-10 08:18:58 -0700 |
| commit | e3b86cc583c693071a9fda462f2145b7a5d55400 (patch) | |
| tree | 34d41743edf77bec38883002ff615cd616100db4 /updates.sql | |
| parent | 44b19841360099cc3e78d1a3612f7aa23e2e6524 (diff) | |
| download | volse-hubzilla-e3b86cc583c693071a9fda462f2145b7a5d55400.tar.gz volse-hubzilla-e3b86cc583c693071a9fda462f2145b7a5d55400.tar.bz2 volse-hubzilla-e3b86cc583c693071a9fda462f2145b7a5d55400.zip | |
adding profile fields
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 |