#!/bin/bash

# Create the database
mysql_cmd="mysql -h210.244.39.156 -u game -prpdla1OK!@"
$mysql_cmd -Ne "set names utf8; CREATE DATABASE IF NOT EXISTS mb_pay_db CHARSET=utf8;"

$mysql_cmd -Ne "set names utf8; USE mb_pay_db; 
CREATE TABLE IF NOT EXISTS transaction_table  (
      transaction_id int(10) unsigned NOT NULL auto_increment,
      partner varchar(64) NOT NULL,
      transaction_time timestamp NOT NULL default CURRENT_TIMESTAMP,
      out_trade_id varchar(128) NOT NULL,
      amt int(10) unsigned NOT NULL default '0',
      product_name varchar(128) default NULL,
      product_count int(10) unsigned NOT NULL default '0',
      user_id int(10) unsigned NOT NULL default '0',
      notify_url varchar(128) default NULL,
      ext varchar(512) default NULL,
      order_status int(10) unsigned default '0',
      callback_status int(10) unsigned default '0',
      PRIMARY KEY  (transaction_id),
      KEY user_id (user_id),
      KEY out_trade_id (out_trade_id),
      KEY transaction_time (transaction_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS mbsys_error_table (
      transaction_id int(10) unsigned NOT NULL auto_increment,
      out_trade_id varchar(128) NOT NULL,
      amt int(10) unsigned NOT NULL default '0',
      user_id int(10) unsigned NOT NULL default '0',
      insert_time timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
      errcode int(10) unsigned default '0',
      PRIMARY KEY  (transaction_id),
      KEY out_trade_id (out_trade_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS usrsys_error_table (
      transaction_id int(10) unsigned NOT NULL auto_increment,
      order_id int(10) unsigned NOT NULL default '0',
      user_id int(10) unsigned NOT NULL,
      app_id varchar(64) NOT NULL,
      product_id int(10) unsigned NOT NULL,
      product_count smallint(5) unsigned NOT NULL,
      error_code smallint(5) unsigned NOT NULL,
      insert_time timestamp NOT NULL default '0000-00-00 00:00:00',
      dealed_status tinyint(3) unsigned NOT NULL default '0',
      dealed_time datetime NOT NULL default '0000-00-00 00:00:00',
      PRIMARY KEY  (transaction_id),
      KEY user_id (user_id),
      KEY order_id (order_id),
      KEY app_id (app_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;"