/*
SQLyog Community Edition- MySQL GUI v7.15 
MySQL - 5.5.29 : Database - dna
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

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

CREATE DATABASE /*!32312 IF NOT EXISTS*/`dna` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `dna`;

/*Table structure for table `aplhabets` */

DROP TABLE IF EXISTS `aplhabets`;

CREATE TABLE `aplhabets` (
  `alphabets` varchar(1000) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `aplhabets` */

insert  into `aplhabets`(`alphabets`) values ('ABCDEFGHIJKLMNOPQRSTUVWXYZ');

/*Table structure for table `cloud1` */

DROP TABLE IF EXISTS `cloud1`;

CREATE TABLE `cloud1` (
  `username` varchar(10) DEFAULT NULL,
  `password` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `cloud1` */

insert  into `cloud1`(`username`,`password`) values ('cloud1','cloud1');

/*Table structure for table `cloud2` */

DROP TABLE IF EXISTS `cloud2`;

CREATE TABLE `cloud2` (
  `username` varchar(10) DEFAULT NULL,
  `password` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `cloud2` */

insert  into `cloud2`(`username`,`password`) values ('cloud2','cloud2');

/*Table structure for table `datavalues` */

DROP TABLE IF EXISTS `datavalues`;

CREATE TABLE `datavalues` (
  `alphabets` varchar(1000) DEFAULT NULL,
  `quaternary` varchar(1000) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `datavalues` */

insert  into `datavalues`(`alphabets`,`quaternary`) values ('A','10000000000000000000000000'),('B','01000000000000000000000000'),('C','00100000000000000000000000'),('D','00010000000000000000000000'),('E','00001000000000000000000000'),('F','00000100000000000000000000'),('G','00000010000000000000000000'),('H','00000001000000000000000000'),('I','00000000100000000000000000'),('J','00000000010000000000000000'),('K','00000000001000000000000000'),('L','00000000000100000000000000'),('M','00000000000010000000000000'),('N','00000000000001000000000000'),('O','00000000000000100000000000'),('P','00000000000000010000000000'),('Q','00000000000000001000000000'),('R','00000000000000000100000000'),('S','00000000000000000010000000'),('T','00000000000000000001000000'),('U','00000000000000000000100000'),('V','00000000000000000000010000'),('W','00000000000000000000001000'),('X','00000000000000000000000100'),('Y','00000000000000000000000010'),('Z','00000000000000000000000001');

/*Table structure for table `encfile` */

DROP TABLE IF EXISTS `encfile`;

CREATE TABLE `encfile` (
  `pid` varchar(20) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `privatekey` varchar(50) DEFAULT NULL,
  `dna1` varchar(1000) DEFAULT NULL,
  `dna2` varchar(1000) DEFAULT NULL,
  `dna3` varchar(1000) DEFAULT NULL,
  `dna4` varchar(1000) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `encfile` */

insert  into `encfile`(`pid`,`date`,`privatekey`,`dna1`,`dna2`,`dna3`,`dna4`) values ('P789','2017-10-03','msqABPZVfOrbYbHVArZUwQ==','10000000000000000000000000','00000000000000000000100000','00000001000000000000000000','00000000000000000001000000');

/*Table structure for table `f` */

DROP TABLE IF EXISTS `f`;

CREATE TABLE `f` (
  `FinalList` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `f` */

/*Table structure for table `hfiles` */

DROP TABLE IF EXISTS `hfiles`;

CREATE TABLE `hfiles` (
  `id` int(200) NOT NULL AUTO_INCREMENT,
  `pid` varchar(20) DEFAULT NULL,
  `dna1` varchar(20) DEFAULT NULL,
  `dna2` varchar(20) DEFAULT NULL,
  `dna3` varchar(20) DEFAULT NULL,
  `dna4` varchar(20) DEFAULT NULL,
  `date` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;

/*Data for the table `hfiles` */

insert  into `hfiles`(`id`,`pid`,`dna1`,`dna2`,`dna3`,`dna4`,`date`) values (15,'P789','A','U','H','T','2017-10-03');

/*Table structure for table `hospital1` */

DROP TABLE IF EXISTS `hospital1`;

CREATE TABLE `hospital1` (
  `username` varchar(10) DEFAULT NULL,
  `password` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `hospital1` */

insert  into `hospital1`(`username`,`password`) values ('hospital1','hospital1');

/*Table structure for table `hospital2` */

DROP TABLE IF EXISTS `hospital2`;

CREATE TABLE `hospital2` (
  `username` varchar(10) DEFAULT NULL,
  `password` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `hospital2` */

insert  into `hospital2`(`username`,`password`) values ('hospital2','hospital2');

/*Table structure for table `keygen` */

DROP TABLE IF EXISTS `keygen`;

CREATE TABLE `keygen` (
  `pid` varchar(100) NOT NULL,
  `dna1` varchar(100) DEFAULT NULL,
  `dna2` varchar(100) DEFAULT NULL,
  `dna3` varchar(100) DEFAULT NULL,
  `dna4` varchar(100) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `skey` varchar(100) DEFAULT NULL,
  `privatekey` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `keygen` */

insert  into `keygen`(`pid`,`dna1`,`dna2`,`dna3`,`dna4`,`date`,`skey`,`privatekey`) values ('P789','A','U','H','T','2017-10-03','5620','msqABPZVfOrbYbHVArZUwQ==');

/*Table structure for table `request` */

DROP TABLE IF EXISTS `request`;

CREATE TABLE `request` (
  `pid` varchar(40) NOT NULL,
  `dna1` varchar(1000) DEFAULT NULL,
  `dna2` varchar(1000) DEFAULT NULL,
  `dna3` varchar(1000) DEFAULT NULL,
  `dna4` varchar(1000) DEFAULT NULL,
  `date` varchar(40) DEFAULT NULL,
  `status` varchar(40) DEFAULT NULL,
  `privatekey` varchar(40) DEFAULT NULL,
  `email` varchar(40) DEFAULT NULL,
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `request` */

insert  into `request`(`pid`,`dna1`,`dna2`,`dna3`,`dna4`,`date`,`status`,`privatekey`,`email`) values ('P789','10000000000000000000000000','00000000000000000000100000','00000001000000000000000000','00000000000000000001000000','2017-10-03','yes','msqABPZVfOrbYbHVArZUwQ==','shiva.1000projects@gmail.com');

/*Table structure for table `sendfiles` */

DROP TABLE IF EXISTS `sendfiles`;

CREATE TABLE `sendfiles` (
  `pid` varchar(100) NOT NULL,
  `dna1` varchar(100) DEFAULT NULL,
  `dna2` varchar(100) DEFAULT NULL,
  `dna3` varchar(100) DEFAULT NULL,
  `dna4` varchar(100) DEFAULT NULL,
  `date` date DEFAULT NULL,
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `sendfiles` */

insert  into `sendfiles`(`pid`,`dna1`,`dna2`,`dna3`,`dna4`,`date`) values ('P789','A','U','H','T ','2017-10-03');

/*Table structure for table `upload` */

DROP TABLE IF EXISTS `upload`;

CREATE TABLE `upload` (
  `pid` varchar(100) DEFAULT NULL,
  `dna1` varchar(100) DEFAULT NULL,
  `dna2` varchar(100) DEFAULT NULL,
  `dna3` varchar(100) DEFAULT NULL,
  `dna4` varchar(100) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `privatekey` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `upload` */

/*Table structure for table `user` */

DROP TABLE IF EXISTS `user`;

CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(45) NOT NULL,
  `email` varchar(45) NOT NULL,
  `password` varchar(45) DEFAULT NULL,
  `dob` varchar(45) DEFAULT NULL,
  `phoneno` varchar(45) DEFAULT NULL,
  `status` varchar(40) DEFAULT NULL,
  `dkey` varchar(40) DEFAULT NULL,
  PRIMARY KEY (`id`,`email`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

/*Data for the table `user` */

insert  into `user`(`id`,`username`,`email`,`password`,`dob`,`phoneno`,`status`,`dkey`) values (1,'shivakrishna','shiva.1000projects@gmail.com','shivaa','1991-05-11','9052016340','yes',NULL);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
