uYbsbMcA

1-- MySQL Administrator dump 1.4
2--
3-- ------------------------------------------------------
4-- Server version	5.7.9-log
5
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11
12/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
13/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
14/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
15
16
17--
18-- Create schema yakyak
19--
20
21CREATE DATABASE IF NOT EXISTS yakyak;
22USE yakyak;
23
24--
25-- Definition of table `tbl_docs`
26--
27
28DROP TABLE IF EXISTS `tbl_docs`;
29CREATE TABLE `tbl_docs` (
30  `idtbl_Docs` int(10) unsigned NOT NULL AUTO_INCREMENT,
31  `doc_refno` varchar(45) NOT NULL,
32  `doc_sub` varchar(45) NOT NULL,
33  `doc_orig` varchar(45) NOT NULL,
34  `date_orig` varchar(45) NOT NULL,
35  `doc_recieve` varchar(45) NOT NULL,
36  `date_recieve` varchar(45) NOT NULL,
37  `refto_inst` varchar(45) NOT NULL,
38  `refto1_inst` varchar(45) NOT NULL,
39  `docstats` varchar(45) NOT NULL,
40  PRIMARY KEY (`idtbl_Docs`)
41) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;
42
43--
44-- Dumping data for table `tbl_docs`
45--
46
47/*!40000 ALTER TABLE `tbl_docs` DISABLE KEYS */;
48INSERT INTO `tbl_docs` (`idtbl_Docs`,`doc_refno`,`doc_sub`,`doc_orig`,`date_orig`,`doc_recieve`,`date_recieve`,`refto_inst`,`refto1_inst`,`docstats`) VALUES 
49 (27,'1','1','1','Monday, June 4, 2018','1','Monday, June 4, 2018','1','','1');
50/*!40000 ALTER TABLE `tbl_docs` ENABLE KEYS */;
51
52
53--
54-- Definition of table `tbl_ref`
55--
56
57DROP TABLE IF EXISTS `tbl_ref`;
58CREATE TABLE `tbl_ref` (
59  `idtbl_ref` int(10) unsigned NOT NULL AUTO_INCREMENT,
60  `doc_ref` varchar(45) NOT NULL,
61  `CH` varchar(45) NOT NULL,
62  `OPCDS` varchar(45) NOT NULL,
63  `PM` varchar(45) NOT NULL,
64  `RO` varchar(45) NOT NULL,
65  `AS3` varchar(45) NOT NULL,
66  `FO` varchar(45) NOT NULL,
67  PRIMARY KEY (`idtbl_ref`),
68  UNIQUE KEY `Unique` (`idtbl_ref`)
69) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
70
71--
72-- Dumping data for table `tbl_ref`
73--
74
75/*!40000 ALTER TABLE `tbl_ref` DISABLE KEYS */;
76INSERT INTO `tbl_ref` (`idtbl_ref`,`doc_ref`,`CH`,`OPCDS`,`PM`,`RO`,`AS3`,`FO`) VALUES 
77 (11,'1','1','0','1','1','0','0');
78/*!40000 ALTER TABLE `tbl_ref` ENABLE KEYS */;
79
80
81--
82-- Definition of table `tbl_register`
83--
84
85DROP TABLE IF EXISTS `tbl_register`;
86CREATE TABLE `tbl_register` (
87  `idtbl_register` int(10) unsigned NOT NULL AUTO_INCREMENT,
88  `username` varchar(45) NOT NULL,
89  `passcode` varchar(45) NOT NULL,
90  `utype` varchar(45) NOT NULL,
91  PRIMARY KEY (`idtbl_register`)
92) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
93
94--
95-- Dumping data for table `tbl_register`
96--
97
98/*!40000 ALTER TABLE `tbl_register` DISABLE KEYS */;
99INSERT INTO `tbl_register` (`idtbl_register`,`username`,`passcode`,`utype`) VALUES 
100 (1,'franz','franz','Admin'),
101 (2,'franz1','franz','CH'),
102 (3,'q','q','CH');
103/*!40000 ALTER TABLE `tbl_register` ENABLE KEYS */;
104
105
106
107
108/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
109/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
110/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
111/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
112/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
113/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
114/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;