CREATE TABLE IF NOT EXISTS `condo_unit_upload` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `house_no` varchar(15) NOT NULL,
  `block` varchar(15) NOT NULL,
  `level` varchar(15) NOT NULL,
  `unit` varchar(15) NOT NULL,
  `condo_id` int(11) NOT NULL,
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `status` varchar(1) NOT NULL DEFAULT 'P',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

ALTER TABLE `user_profile` CHANGE `email` `email` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL ;

ALTER TABLE `user` ADD `password_sent_status` VARCHAR( 1 ) NULL DEFAULT 'N' AFTER `status` ;

ALTER TABLE `residence_upload` ADD `mobile` VARCHAR( 20 ) NULL DEFAULT NULL AFTER `email` ;

ALTER TABLE `residence_upload` CHANGE `block` `block` VARCHAR( 15 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL ,
CHANGE `level` `level` VARCHAR( 15 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL ,
CHANGE `unit` `unit` VARCHAR( 15 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL ,
CHANGE `email` `email` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL ;