ALTER TABLE `rooms101_rtsdev`.`customers`
    MODIFY COLUMN `creationdate` datetime NOT NULL AFTER `greencard`;

ALTER TABLE `rooms101_rtsdev`.`customers`
    MODIFY COLUMN `firstname2` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT '' AFTER `lastname1`,
    MODIFY COLUMN `lastname2` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT '' AFTER `firstname2`,
    MODIFY COLUMN `age2` int(11) NULL DEFAULT 0 AFTER `age1`,
    MODIFY COLUMN `groupname` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT '' AFTER `age2`,
    MODIFY COLUMN `address2` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT '' AFTER `address1`,
    MODIFY COLUMN `region` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT '' AFTER `country`,
    MODIFY COLUMN `homephone` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT '' AFTER `region`,
    MODIFY COLUMN `workphone` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT '' AFTER `homephone`,
    MODIFY COLUMN `cellphone` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT '' AFTER `workphone`;

