-- MySQL dump 10.11
--
-- Host: localhost    Database: diner
-- ------------------------------------------------------
-- Server version	5.0.51a-3ubuntu5.5

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Current Database: `BugTest`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `BugTest` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `BugTest`;

--
-- Table structure for table `Customer`
--

DROP TABLE IF EXISTS `Customer`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `Customer` (
  `cusId` bigint(20) NOT NULL auto_increment,
  `cusArea` char(3) NOT NULL,
  `cusAccount` char(9) NOT NULL,
  `cusPassword` varchar(32) NOT NULL,
  `cusName` varchar(10) NOT NULL,
  `cusEmail` varchar(30) NOT NULL,
  `cusSchool` varchar(10) NOT NULL,
  `cusPhone` varchar(20) NOT NULL,
  `cusMemo` varchar(1024) default NULL,
  `cusToken` varchar(64) default NULL,
  `cusActivateTime` datetime default NULL,
  `cusCreateTime` datetime NOT NULL,
  PRIMARY KEY  (`cusId`),
  UNIQUE KEY `UK_Customer_cusAccount` (`cusAccount`),
  UNIQUE KEY `UK_Customer_cusEmail` (`cusEmail`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `Customer`
--

LOCK TABLES `Customer` WRITE;
/*!40000 ALTER TABLE `Customer` DISABLE KEYS */;
INSERT INTO `Customer` VALUES (1,'XXX','XXX111111','a','test','1@a.b','no','0911111111','','','2010-03-15 22:31:28','2010-03-15 22:31:11'),(2,'XXX','XXX222222','b','test2','2@b.c','test','0922222222',NULL,'','2010-04-10 10:33:49','2010-04-10 10:31:35'),(3,'XXX','XXX333333','3','test3','3@b.c','test','0933333333',NULL,'','2010-04-14 09:12:41','2010-04-10 10:35:39'),(4,'XXX','XXX555555','4','test','4@b.c','test','0955555555',NULL,'','2010-04-15 14:49:36','2010-04-15 14:49:15'),(5,'YYY','YYY111111','5','no','5@b.c','no','0911111111',NULL,'','2010-04-22 20:20:20','2010-04-22 20:19:28'),(6,'AAA','AAA999999','6','no','6@b.c','no','0999999999',NULL,'','2010-05-02 11:15:56','2010-04-29 23:29:01'),(7,'AAA','AAA888888','7','no','7@b.c','no','0988888888',NULL,'',NULL,'2010-05-02 11:16:56'),
(17,'XXX','XXX666666','8','no','8@b.c','no','0966666666',NULL,'','2010-05-04 14:08:39','2010-05-04 14:04:30'),(18,'XXX','XXX777777','9','no','9@b.c','no','0977777777',NULL,'','2010-05-04 14:45:16','2010-05-04 14:38:15'),(19,'DDD','DDD345678','10','no','10@b.c','no','0912345678',NULL,'','2010-05-14 15:36:57','2010-05-14 15:36:43'),(20,'EEE','EEE111111','11','no','11@b.c','no','0911111111',NULL,'','2010-05-16 22:11:40','2010-05-16 22:11:23'),
(21,'XXX','XXX768042','12','abc','12@b.c','abc','0933768042',NULL,'','2010-05-26 05:44:11','2010-05-26 05:43:33'),(22,'XXX','XXX987654','13','no','13@b.c','no','0911987654',NULL,'','2010-05-26 22:50:00','2010-05-26 22:49:27');
/*!40000 ALTER TABLE `Customer` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `CustomerPlan`
--

DROP TABLE IF EXISTS `CustomerPlan`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `CustomerPlan` (
  `cplId` bigint(20) NOT NULL auto_increment,
  `cusId` bigint(20) NOT NULL,
  `cplEffDate` date NOT NULL,
  `rplId` bigint(20) NOT NULL,
  `cplCreateTime` datetime NOT NULL,
  PRIMARY KEY  (`cplId`),
  UNIQUE KEY `UK_CustomerPlan_cusId_cplEffDate` (`cusId`,`cplEffDate`),
  KEY `FK_CustomerPlan_rplId` (`rplId`),
  CONSTRAINT `FK_CustomerPlan_cusId` FOREIGN KEY (`cusId`) REFERENCES `Customer` (`cusId`),
  CONSTRAINT `FK_CustomerPlan_rplId` FOREIGN KEY (`rplId`) REFERENCES `RatePlan` (`rplId`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `CustomerPlan`
--

LOCK TABLES `CustomerPlan` WRITE;
/*!40000 ALTER TABLE `CustomerPlan` DISABLE KEYS */;
INSERT INTO `CustomerPlan` VALUES 
(1,1,'2010-03-01',2,'2010-03-15 22:32:04'),
(2,1,'2010-04-01',3,'2010-03-15 22:32:04'),
(3,1,'2010-05-01',4,'2010-04-02 21:54:25'),
(4,5,'2010-04-01',3,'2010-04-22 20:24:41'),
(5,5,'2010-05-01',1,'2010-04-22 20:24:41'),
(6,6,'2010-05-01',3,'2010-04-30 12:23:39'),
(7,6,'2010-06-01',3,'2010-04-30 12:23:39'),
(8,1,'2010-06-01',1,'2010-04-30 16:36:23'),
(9,17,'2010-05-01',3,'2010-05-04 14:26:12'),
(10,17,'2010-06-01',3,'2010-05-04 14:26:12'),
(11,18,'2010-05-01',3,'2010-05-04 14:38:15'),
(12,18,'2010-06-01',3,'2010-05-04 14:38:15'),
(13,19,'2010-05-01',3,'2010-05-14 15:44:18'),
(14,19,'2010-06-01',3,'2010-05-14 15:44:18'),
(15,21,'2010-05-01',3,'2010-05-26 05:43:33'),
(16,21,'2010-06-01',3,'2010-05-26 05:43:33'),
(17,22,'2010-05-01',4,'2010-05-26 22:49:27'),(18,22,'2010-06-01',1,'2010-05-26 22:49:27'),
(19,1,'2010-07-01',1,'2010-06-01 12:05:27'),(21,22,'2010-07-01',1,'2010-06-01 12:06:54'),
(22,3,'2010-06-01',2,'2010-06-01 16:25:53'),(23,3,'2010-07-01',1,'2010-06-01 16:25:53'),
(24,2,'2010-06-01',1,'2010-06-01 16:28:16'),(25,2,'2010-07-01',1,'2010-06-01 16:28:16'),
(26,17,'2010-07-01',1,'2010-06-01 19:10:48');
/*!40000 ALTER TABLE `CustomerPlan` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `RatePlan`
--

DROP TABLE IF EXISTS `RatePlan`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `RatePlan` (
  `rplId` bigint(20) NOT NULL auto_increment,
  `rplName` varchar(10) NOT NULL,
  `rplQuota` int(11) NOT NULL,
  `rplNextEffDate` date default NULL,
  `rplNextQuota` int(11) default NULL,
  `rplCreateTime` datetime NOT NULL,
  PRIMARY KEY  (`rplId`),
  UNIQUE KEY `UK_RatePlan_rplName` (`rplName`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `RatePlan`
--

LOCK TABLES `RatePlan` WRITE;
/*!40000 ALTER TABLE `RatePlan` DISABLE KEYS */;
INSERT INTO `RatePlan` VALUES (1,'',0,NULL,NULL,'2010-03-14 12:47:02'),(2,'test',1000,NULL,NULL,'2010-03-15 22:32:27'),(3,'NORMAL',10000,NULL,NULL,'2010-04-02 21:53:26'),(4,'EXTRA',300,NULL,NULL,'2010-05-26 22:39:51');
/*!40000 ALTER TABLE `RatePlan` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2010-06-01 11:49:17