CREATE TABLE `cyber_user_devices` (
	`user_device_id` INT(10) NULL AUTO_INCREMENT,
	`user_id` INT(10) NULL DEFAULT '0',
	`device` VARCHAR(255) NULL,
	`device_id` VARCHAR(255) NULL,
	PRIMARY KEY (`user_device_id`)
)ENGINE=MyISAM;
ALTER TABLE `cyber_user` ADD COLUMN `fbId` VARCHAR(255) NULL DEFAULT NULL AFTER `nCredits`;
ALTER TABLE `cyber_user` ADD COLUMN `premiumUser` ENUM('Y','N') NULL DEFAULT 'N' AFTER `fbId`;

ALTER TABLE `cyber_user` ADD COLUMN `vDate_Preference` VARCHAR(250) NULL DEFAULT NULL AFTER `dDob`;

CREATE TABLE `cyber_matching_profiles` (
       `match_id` INT(10) NOT NULL AUTO_INCREMENT,
       `nUser_Id` INT(10) NOT NULL DEFAULT '0',
       `profile_Id` INT(10) NOT NULL DEFAULT '0',
       `match_date` DATE NULL DEFAULT NULL,
       PRIMARY KEY (`match_id`)
)
ENGINE=MyISAM;
ALTER TABLE `cyber_matching_profiles` CHANGE COLUMN `match_date` `match_date` DATE NULL DEFAULT NULL AFTER `profile_Id`;
INSERT INTO `cyber_lookup` (`vName`,`vValue`) VALUES ('credit_value','1');
INSERT INTO `cyber_lookup` (`vName`, `vValue`) VALUES ('freemium_period', '30');