-- jewel 76528  ANA Business solution_Table Def_20190909.xlsx

ALTER TABLE `person_contacts` 
CHANGE COLUMN `contact_id` `contact_id` VARCHAR(36) NOT NULL ,
CHANGE COLUMN `person_id` `person_id` VARCHAR(36) NOT NULL ,
CHANGE COLUMN `date_modified` `date_modified` DATETIME NOT NULL ,
CHANGE COLUMN `deleted` `deleted` TINYINT(3) NOT NULL DEFAULT '0' ,
CHANGE COLUMN `person_contact_status` `person_contact_status` VARCHAR(36) NOT NULL DEFAULT '0' ;

ALTER TABLE `smsevent` DROP COLUMN `opportunityNo`;
ALTER TABLE `accounts` DROP COLUMN `ana_flg`;


ALTER TABLE `smsevent` 
DROP COLUMN `field69`,
DROP COLUMN `field68`,
DROP COLUMN `field67`,
DROP COLUMN `salesstaff`,
DROP COLUMN `account_id`;

ALTER TABLE `contacts` DROP COLUMN `gokakusaki`;

-- Rio : 77645 ( add manual_transaction )
CREATE TABLE IF NOT EXISTS `manual_transaction` (
  `id` char(36) NOT NULL DEFAULT '',
  `salesno` varchar(36) DEFAULT NULL,
  `contact_name` varchar(36) DEFAULT NULL,
  `t_date` datetime DEFAULT NULL,
  `actual_in_amount` double DEFAULT NULL,
  `payment_type` varchar(36) DEFAULT NULL,
  `status` int DEFAULT NULL,
  `date_entered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_user_id` varchar(36) DEFAULT NULL,
  `created_by` varchar(36) DEFAULT NULL,
  `school_id` char(36) DEFAULT NULL ,
  `area_id` char(36) DEFAULT NULL,
  `nyuukinsaki_koza` int DEFAULT NULL,
  `bank_name` varchar(36) DEFAULT NULL,
  `bank_branch_name` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;