File: //opt/cloudlinux/alt-php54/root/usr/share/pear/RVSeagullMod/modules/user/data/update.my.2.sql
-- Modify database seagull Table user
-- =========================== block schema ======================
ALTER TABLE usr ADD image_url longtext NOT NULL AFTER updated_by;
ALTER TABLE usr ADD image_upload VARCHAR( 255 ) NOT NULL AFTER updated_by;
ALTER TABLE usr ADD personal_text longtext NOT NULL AFTER updated_by;
ALTER TABLE usr ADD birthdate VARCHAR( 12 ) NOT NULL AFTER updated_by;
ALTER TABLE usr ADD gender VARCHAR( 16 ) NOT NULL AFTER updated_by;
ALTER TABLE usr ADD icq VARCHAR( 200 ) NOT NULL AFTER updated_by;
ALTER TABLE usr ADD aim VARCHAR( 200 ) NOT NULL AFTER updated_by;
ALTER TABLE usr ADD msn VARCHAR( 200 ) NOT NULL AFTER updated_by;
ALTER TABLE usr ADD yim VARCHAR( 200 ) NOT NULL AFTER updated_by;
ALTER TABLE usr ADD website_title VARCHAR( 255 ) NOT NULL AFTER updated_by;
ALTER TABLE usr ADD website_url VARCHAR( 255 ) NOT NULL AFTER updated_by;
--ALTER TABLE usr ADD visual_verification VARCHAR( 16 ) NOT NULL AFTER website_url;--
ALTER TABLE usr ADD onlinestatus VARCHAR( 16 ) NOT NULL AFTER updated_by ;
ALTER TABLE usr ADD hidemail VARCHAR( 128 ) NOT NULL AFTER updated_by;
ALTER TABLE usr ADD signager longtext NOT NULL AFTER updated_by;
ALTER TABLE usr ADD typeImage VARCHAR( 255 ) NOT NULL AFTER updated_by;
--end