New sys_pref

INSERT INTO `dating`.`sys_pref` (`name`, `value`) VALUES ('rest_token_timeout', '300');
INSERT INTO `dating`.`sys_pref` (`name`, `value`) VALUES ('rest_login_diff', '15');

new tables:

CREATE TABLE `rest_token` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `accesstoken` varchar(65) DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `valid_until` int(14) DEFAULT NULL,
  `refresh_token` varchar(65) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `accesstoken_UNIQUE` (`accesstoken`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;

INSERT INTO `rest_token` VALUES (1,'c23f9351-4209-4641-bdd2-7b42406b5c35','10.10.1.1',1,1502299759,'388143d4-b64f-4021-be75-71698c706311');

CREATE TABLE `rest_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(32) DEFAULT NULL,
  `name` varchar(64) DEFAULT NULL,
  `password` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_name_UNIQUE` (`user_name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

INSERT INTO `rest_user` VALUES (1,'jan','jans test','kalle anka');

CREATE TABLE `dating`.`r_user` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `username` VARCHAR(32) NULL,
  `password` VARCHAR(64) NULL,
  `name` VARCHAR(64) NULL,
  `status` VARCHAR(5) NULL,
  `ext1_id` VARCHAR(64) NULL,
  `ext1_pwd` VARCHAR(64) NULL,
PRIMARY KEY (`id`),
UNIQUE INDEX `id_UNIQUE` (`id` ASC),
UNIQUE INDEX `username_UNIQUE` (`username` ASC));


REATE TABLE `r_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(32) DEFAULT NULL,
  `password` varchar(64) DEFAULT NULL,
  `name` varchar(64) DEFAULT NULL,
  `status` varchar(5) DEFAULT NULL,
  `ext1_id` varchar(64) DEFAULT NULL,
  `ext1_pwd` varchar(64) DEFAULT NULL,
  `ext1_session` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`),
  UNIQUE KEY `username_UNIQUE` (`username`),
  UNIQUE KEY `ext1_session_UNIQUE` (`ext1_session`),
  UNIQUE KEY `ext1_id_UNIQUE` (`ext1_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

ALTER TABLE `dating`.`r_user` 
ADD COLUMN `ext1_session` VARCHAR(64) NULL AFTER `ext1_pwd`,
ADD UNIQUE INDEX `ext1_session_UNIQUE` (`ext1_session` ASC),
ADD UNIQUE INDEX `ext1_id_UNIQUE` (`ext1_id` ASC);


ALTER TABLE `dating`.`r_user` 
ADD COLUMN `cust_id` INT(11) NULL DEFAULT 0 AFTER `ext1_session`;

ALTER TABLE `dating`.`r_user` 
ADD COLUMN `saldo` DECIMAL(10,2) NULL DEFAULT 0.0 AFTER `cust_id`;

CREATE TABLE `dating`.`r_transaction` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `transaction_date` DATETIME NULL,
  `r_user_id` INT(11) NULL,
  `status` VARCHAR(5) NULL,
  `amount` DECIMAL(10,2) NULL,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `id_UNIQUE` (`id` ASC),
  INDEX `r_user_date` (`r_user_id` ASC, `transaction_date` ASC));

CREATE TABLE `r_transaction` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `transaction_date` datetime DEFAULT NULL,
  `r_user_id` int(11) DEFAULT NULL,
  `status` varchar(5) DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT '0.00',
  `invoice_no` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`),
  KEY `r_user_date` (`r_user_id`,`transaction_date`)
  ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;


ALTER TABLE `dating`.`customer` 
ADD INDEX `email_idx` (`email` ASC),
ADD INDEX `pnum_idx` (`pnum` ASC);

ALTER TABLE `dating`.`r_transactions` 
RENAME TO  `dating`.`r_transaction` ;

ALTER TABLE `dating`.`r_user` 
ADD COLUMN `family_name` VARCHAR(50) NULL AFTER `saldo`,
ADD COLUMN `first_name` VARCHAR(50) NULL AFTER `family_name`,
ADD COLUMN `address_1` VARCHAR(128) NULL AFTER `first_name`,
ADD COLUMN `address_2` VARCHAR(128) NULL AFTER `address_1`,
ADD COLUMN `zip_code` VARCHAR(10) NULL AFTER `address_2`,
ADD COLUMN `city` VARCHAR(50) NULL AFTER `zip_code`;

ALTER TABLE `dating`.`r_transaction` 
ADD COLUMN `invoice_no` VARCHAR(10) NULL AFTER `amount`;

ALTER TABLE `dating`.`opencall_history`
ADD INDEX `cust_id` (`cust_id` ASC, `date` DESC);

ALTER TABLE `dating`.`r_user` 
ADD COLUMN `prepaid_used` DECIMAL(10,2) NULL DEFAULT '0.00' AFTER `saldo`;

ALTER TABLE `dating`.`r_user` 
ADD COLUMN `email` VARCHAR(64) NULL DEFAULT '' AFTER `city`;

2018-01-12
ALTER TABLE `dating`.`r_user` 
ADD COLUMN `trustly_account_id` VARCHAR(50) NULL DEFAULT NULL AFTER `email`;