CREATE DATABASE  IF NOT EXISTS `sbs` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `sbs`;
-- MySQL dump 10.13  Distrib 5.6.17, for Win32 (x86)
--
-- Host: localhost    Database: sbs
-- ------------------------------------------------------
-- Server version	5.6.20-log

/*!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 */;

--
-- Table structure for table `account_details`
--

DROP TABLE IF EXISTS `account_details`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `account_details` (
  `ACCT_ID` int(11) NOT NULL AUTO_INCREMENT,
  `ACCOUNT_NUMBER` varchar(45) NOT NULL,
  `U_ID` int(11) DEFAULT NULL,
  `BALANCE` double NOT NULL,
  `TEMP_1` varchar(45) DEFAULT NULL,
  `TEMP_2` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`ACCT_ID`),
  UNIQUE KEY `ACCT_ID_UNIQUE` (`ACCT_ID`),
  UNIQUE KEY `ACCOUNT_NUMBER_UNIQUE` (`ACCOUNT_NUMBER`),
  KEY `USER_ID_idx` (`U_ID`),
  CONSTRAINT `USER_ID` FOREIGN KEY (`U_ID`) REFERENCES `user` (`USER_ID`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `account_details`
--

LOCK TABLES `account_details` WRITE;
/*!40000 ALTER TABLE `account_details` DISABLE KEYS */;
INSERT INTO `account_details` VALUES (1,'736953878',11,644.244,NULL,NULL),(2,'342019236',12,355.756,NULL,NULL),(3,'132423552',19,500,NULL,NULL);
/*!40000 ALTER TABLE `account_details` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `bill_pay`
--

DROP TABLE IF EXISTS `bill_pay`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bill_pay` (
  `BILL_ID` int(11) NOT NULL AUTO_INCREMENT,
  `MERCHANT_ID` int(11) DEFAULT NULL,
  `ACCT_NUMBER` varchar(45) DEFAULT NULL,
  `AMOUNT` double DEFAULT NULL,
  `STATUS` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`BILL_ID`),
  UNIQUE KEY `ACCT_NUMBER_UNIQUE` (`ACCT_NUMBER`),
  UNIQUE KEY `MERCHANT_ID_UNIQUE` (`MERCHANT_ID`),
  CONSTRAINT `MERCHANT_FK` FOREIGN KEY (`MERCHANT_ID`) REFERENCES `user` (`USER_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bill_pay`
--

LOCK TABLES `bill_pay` WRITE;
/*!40000 ALTER TABLE `bill_pay` DISABLE KEYS */;
/*!40000 ALTER TABLE `bill_pay` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `notification_details`
--

DROP TABLE IF EXISTS `notification_details`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `notification_details` (
  `NOTIFICATION_ID` int(11) NOT NULL AUTO_INCREMENT,
  `NOTIFICATION_NAME` varchar(45) NOT NULL,
  `NOTIFICATION_DESCRIPTION` varchar(128) DEFAULT NULL,
  `NOTIFICATION_STATUS` int(11) DEFAULT NULL,
  `NOTIFICATION_USER_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`NOTIFICATION_ID`),
  KEY `NOTIFICATION_USER_ID_idx` (`NOTIFICATION_USER_ID`),
  CONSTRAINT `NOTIFICATION_USER_ID` FOREIGN KEY (`NOTIFICATION_USER_ID`) REFERENCES `user` (`USER_ID`) ON DELETE NO ACTION ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `notification_details`
--

LOCK TABLES `notification_details` WRITE;
/*!40000 ALTER TABLE `notification_details` DISABLE KEYS */;
/*!40000 ALTER TABLE `notification_details` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `request_details`
--

DROP TABLE IF EXISTS `request_details`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `request_details` (
  `REQ_ID` int(11) NOT NULL AUTO_INCREMENT,
  `REQ_USER_ID` int(11) DEFAULT NULL,
  `REQ_DESC` varchar(90) DEFAULT NULL,
  `REQ_STATUS` int(11) DEFAULT NULL,
  `REQ_DATE` timestamp NULL DEFAULT NULL,
  `REQ_TYPE` varchar(25) DEFAULT NULL,
  `IS_APPROVED` tinyint(1) DEFAULT NULL,
  `REQ_PRIORITY` varchar(25) DEFAULT NULL,
  `REQ_TRANS_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`REQ_ID`),
  UNIQUE KEY `REQ_TRANS_ID_UNIQUE` (`REQ_TRANS_ID`),
  KEY `REQ_USER_ID_idx` (`REQ_USER_ID`),
  CONSTRAINT `REQ_TRANS_ID` FOREIGN KEY (`REQ_TRANS_ID`) REFERENCES `transaction_details` (`TRANS_ID`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `REQ_USER_ID` FOREIGN KEY (`REQ_USER_ID`) REFERENCES `user` (`USER_ID`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `request_details`
--

LOCK TABLES `request_details` WRITE;
/*!40000 ALTER TABLE `request_details` DISABLE KEYS */;
INSERT INTO `request_details` VALUES (1,NULL,'asdada',NULL,NULL,'Second Issue',NULL,NULL,NULL),(2,NULL,'asdadsd',NULL,NULL,'Second Issue',NULL,NULL,NULL),(3,12,'asdasdsad',0,'2014-10-30 08:44:23','First Issue',NULL,'Critical',NULL),(4,12,'342019236,736953878,20',0,'2014-10-30 08:49:59','Transact',1,NULL,5);
/*!40000 ALTER TABLE `request_details` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `roles`
--

DROP TABLE IF EXISTS `roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `roles` (
  `ROLE_ID` int(11) NOT NULL,
  `ROLE_NAME` varchar(30) NOT NULL,
  `ROLE_DESC` varchar(60) DEFAULT NULL,
  `CREATED_DATE` datetime DEFAULT NULL,
  `IS_ACTIVE` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`ROLE_ID`),
  UNIQUE KEY `role_UNIQUE` (`ROLE_NAME`),
  UNIQUE KEY `ROLE_ID_UNIQUE` (`ROLE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `roles`
--

LOCK TABLES `roles` WRITE;
/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
INSERT INTO `roles` VALUES (6715,'ROLE_USER',NULL,NULL,NULL),(7879,'ROLE_EMPLOYEE',NULL,NULL,NULL),(8767,'ROLE_MERCHANT',NULL,NULL,NULL),(63908673,'ROLE_ADMIN',NULL,NULL,NULL);
/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `transaction_details`
--

DROP TABLE IF EXISTS `transaction_details`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `transaction_details` (
  `TRANS_ID` int(11) NOT NULL AUTO_INCREMENT,
  `TRANS_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `TRANS_AMT` double NOT NULL,
  `FROM_ACCT` varchar(45) DEFAULT NULL,
  `TO_ACCT` varchar(45) DEFAULT NULL,
  `TEMP_1` varchar(45) DEFAULT NULL,
  `TEMP_2` varchar(45) DEFAULT NULL,
  `IS_AUTHORIZED` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`TRANS_ID`),
  KEY `FROM_ACCOUNT_idx` (`FROM_ACCT`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `transaction_details`
--

LOCK TABLES `transaction_details` WRITE;
/*!40000 ALTER TABLE `transaction_details` DISABLE KEYS */;
INSERT INTO `transaction_details` VALUES (1,'2014-10-30 08:14:47',50,NULL,'342019236',NULL,NULL,NULL),(2,'2014-10-30 08:14:59',50,'342019236',NULL,NULL,NULL,NULL),(3,'2014-10-30 08:21:41',123,'342019236','736953878',NULL,NULL,NULL),(4,'2014-10-30 08:22:46',1.244,'342019236','736953878',NULL,NULL,NULL),(5,'2014-10-30 08:49:59',20,'342019236','736953878',NULL,NULL,1);
/*!40000 ALTER TABLE `transaction_details` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user`
--

DROP TABLE IF EXISTS `user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user` (
  `USER_ID` int(11) NOT NULL AUTO_INCREMENT,
  `USER_NAME` varchar(30) NOT NULL,
  `PASSWORD` varchar(70) NOT NULL,
  `EMAIL_ID` varchar(255) NOT NULL,
  `CREATE_TIME` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `FIRST_NAME` varchar(60) NOT NULL,
  `LAST_NAME` varchar(60) NOT NULL,
  `ADDRESS` varchar(560) DEFAULT NULL,
  `DOB` date NOT NULL,
  `CONTACT_NUM` varchar(20) NOT NULL,
  `SEC_QUE1` varchar(128) NOT NULL,
  `SEC_ANS1` varchar(45) NOT NULL,
  `SEC_QUE2` varchar(128) NOT NULL,
  `SEC_ANS2` varchar(45) NOT NULL,
  `PKI_PATH` varchar(45) DEFAULT NULL,
  `PKI_CERTI` varchar(45) DEFAULT NULL,
  `PKI_NUMBER` varchar(45) DEFAULT NULL,
  `PUBLIC_KEY` varchar(240) DEFAULT NULL,
  `OTP` varchar(45) DEFAULT NULL,
  `LOGIN_ATTEMPTS` int(11) DEFAULT '0',
  `ACCT_LOCKED_STATUS` tinyint(1) DEFAULT '0',
  `ACTIVE_STATUS` tinyint(1) DEFAULT '1',
  `ROLE_ID` int(11) DEFAULT NULL,
  PRIMARY KEY (`USER_ID`),
  UNIQUE KEY `id_UNIQUE` (`USER_ID`),
  UNIQUE KEY `username_UNIQUE` (`USER_NAME`),
  UNIQUE KEY `email_UNIQUE` (`EMAIL_ID`),
  KEY `ROLE_ID_FK_idx` (`ROLE_ID`),
  CONSTRAINT `ROLE_ID_FK` FOREIGN KEY (`ROLE_ID`) REFERENCES `roles` (`ROLE_ID`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user`
--

LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` VALUES (11,'newuser1','$2a$10$ykGrPbCTGWBb6AiH8vfjXOey6dVuvcFPSfKWVFozOjFipZH0nh1Qy','<EMAIL>',NULL,'newuser1','newuser1','sadada ','2014-10-13','adasda','asdad',' asdasds',' sdsadas','ddasdads',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,8767),(12,'newuser2','$2a$10$lH.eRAffO7VBfaXr60GxVe7874N5sr4pFYjUjZkZps03uGhpz268.','<EMAIL>',NULL,'newuser2','newuser2','asdadssa ','2014-10-06','asdasd',' adasda','sdasd ','adads ','asdassds',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,6715),(13,'admin','$2a$10$bGb.zn9wT3gqKt02f2vxeuCGyXnCjX23JzoCkrt.uNxOcf1muymK2','<EMAIL>',NULL,'admin','admin','asdasdas ','2014-10-06','adadad',' adadasd',' assdada',' adadad','adadasd',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,63908673),(16,'employee1','$2a$10$bBixETxMmc0hmiNw..yaxu2iJTBrRgcuQWZheyu36FSsXPlCGTC4K','<EMAIL>',NULL,'employee1','employee1','ssdasdas ','2014-10-01','asdasd',' sadasd','asdasdas ','asdasdasd ','asdasdasd',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7879),(19,'merchant3','$2a$10$12TxFdAtUAEwRgOHu7UP2OGRZta1J6llsCpCmId5Vsls8UA4BFfhq','<EMAIL>',NULL,'merchant3','merchant3',' adada','2014-10-03','sdada',' adsasd',' asddasdas',' asdasd','sadadasd',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,8767);
/*!40000 ALTER TABLE `user` 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 2014-10-30 18:45:05
