-- phpMyAdmin SQL Dump
-- version 2.6.1-rc1
-- http://www.phpmyadmin.net
-- 
-- 主機: localhost
-- 建立日期: Oct 28, 2015, 03:50 PM
-- 伺服器版本: 5.5.31
-- PHP 版本: 5.5.20
-- 
-- 資料庫: `zjr-bank`
-- 

-- --------------------------------------------------------

-- 
-- 資料表格式： `cell_coin_trans`
-- 

CREATE TABLE `cell_coin_trans` (
  `TransId` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `OkFlag` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `UserId` bigint(13) unsigned NOT NULL,
  `TransTmk` datetime NOT NULL,
  `TransAmt` bigint(20) NOT NULL,
  `TransCat` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `RefId` bigint(20) unsigned NOT NULL,
  `TransMemo` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`TransId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- 資料表格式： `coin_balance`
-- 

CREATE TABLE `coin_balance` (
  `UserId` bigint(13) unsigned NOT NULL,
  `OkFlag` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `ShopBal` bigint(20) NOT NULL,
  `GameBal` bigint(20) NOT NULL,
  `LuckyBal` bigint(20) NOT NULL,
  `PromoBal` bigint(20) NOT NULL,
  `CellBal` bigint(20) NOT NULL,
  `ScoreBal` bigint(20) NOT NULL,
  `RebateBal` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

-- 
-- 資料表格式： `game_coin_trans`
-- 

CREATE TABLE `game_coin_trans` (
  `TransId` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `OkFlag` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `UserId` bigint(13) unsigned NOT NULL,
  `TransTmk` datetime NOT NULL,
  `TransAmt` bigint(20) NOT NULL,
  `TransCat` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `RefId` bigint(20) unsigned NOT NULL,
  `TransMemo` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`TransId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- 資料表格式： `game_score_balance`
-- 

CREATE TABLE `game_score_balance` (
  `UserId` bigint(13) unsigned NOT NULL,
  `OkFlag` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `GameCat` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
  `GameScore` bigint(20) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

-- 
-- 資料表格式： `game_score_trans`
-- 

CREATE TABLE `game_score_trans` (
  `TransId` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `OkFlag` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `UserId` bigint(13) unsigned NOT NULL,
  `TransTmk` datetime NOT NULL,
  `TransAmt` bigint(20) NOT NULL,
  `TransCat` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `RefId` bigint(20) unsigned NOT NULL,
  `TransMemo` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`TransId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- 資料表格式： `lucky_coin_trans`
-- 

CREATE TABLE `lucky_coin_trans` (
  `TransId` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `OkFlag` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `UserId` bigint(13) unsigned NOT NULL,
  `TransTmk` datetime NOT NULL,
  `TransAmt` bigint(20) NOT NULL,
  `TransCat` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `RefId` bigint(20) unsigned NOT NULL,
  `TransMemo` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`TransId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- 資料表格式： `promo_coin_trans`
-- 

CREATE TABLE `promo_coin_trans` (
  `TransId` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `OkFlag` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `UserId` bigint(13) unsigned NOT NULL,
  `TransTmk` datetime NOT NULL,
  `TransAmt` bigint(20) NOT NULL,
  `TransCat` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `RefId` bigint(20) unsigned NOT NULL,
  `TransMemo` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`TransId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- 資料表格式： `rebate_coin_trans`
-- 

CREATE TABLE `rebate_coin_trans` (
  `TransId` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `OkFlag` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `UserId` bigint(13) unsigned NOT NULL,
  `TransTmk` datetime NOT NULL,
  `TransAmt` bigint(20) NOT NULL,
  `TransCat` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `RefId` bigint(20) unsigned NOT NULL,
  `TransMemo` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`TransId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- 資料表格式： `shop_coin_trans`
-- 

CREATE TABLE `shop_coin_trans` (
  `TransId` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `OkFlag` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `UserId` bigint(13) unsigned NOT NULL,
  `TransTmk` datetime NOT NULL,
  `TransAmt` bigint(20) NOT NULL,
  `TransCat` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `RefId` bigint(20) unsigned NOT NULL,
  `TransMemo` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `GameCat` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`TransId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
