· 9 years ago · Dec 20, 2016, 04:54 AM
1-- phpMyAdmin SQL Dump
2-- version 4.0.10deb1
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Dec 19, 2016 at 01:21 PM
7-- Server version: 5.5.52-0ubuntu0.14.04.1
8-- PHP Version: 5.5.9-1ubuntu4.20
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13--
14-- Database: `equity`
15--
16
17-- --------------------------------------------------------
18
19--
20-- Table structure for table `tblACLs`
21--
22
23CREATE TABLE IF NOT EXISTS `tblACLs` (
24 `id` int(11) NOT NULL AUTO_INCREMENT,
25 `target` int(11) NOT NULL DEFAULT '0',
26 `targetType` tinyint(4) NOT NULL DEFAULT '0',
27 `userID` int(11) NOT NULL DEFAULT '-1',
28 `groupID` int(11) NOT NULL DEFAULT '-1',
29 `mode` tinyint(4) NOT NULL DEFAULT '0',
30 `is_share` int(11) NOT NULL,
31 `exp` int(12) NOT NULL,
32 PRIMARY KEY (`id`)
33) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
34
35--
36-- Dumping data for table `tblACLs`
37--
38
39INSERT INTO `tblACLs` (`id`, `target`, `targetType`, `userID`, `groupID`, `mode`, `is_share`, `exp`) VALUES
40(1, 10, 2, 5876, -1, 2, 1, 1475773200);
41
42-- --------------------------------------------------------
43
44--
45-- Table structure for table `tblDirPath`
46--
47
48CREATE TABLE IF NOT EXISTS `tblDirPath` (
49 `dirID` int(11) NOT NULL AUTO_INCREMENT,
50 `dirPath` varchar(255) NOT NULL,
51 PRIMARY KEY (`dirPath`,`dirID`)
52) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
53
54-- --------------------------------------------------------
55
56--
57-- Table structure for table `tblDocumentApproveLog`
58--
59
60CREATE TABLE IF NOT EXISTS `tblDocumentApproveLog` (
61 `approveLogID` int(11) NOT NULL AUTO_INCREMENT,
62 `approveID` int(11) NOT NULL DEFAULT '0',
63 `status` tinyint(4) NOT NULL DEFAULT '0',
64 `comment` text NOT NULL,
65 `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
66 `userID` int(11) NOT NULL DEFAULT '0',
67 `show` varchar(100) NOT NULL DEFAULT '0',
68 PRIMARY KEY (`approveLogID`)
69) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
70
71-- --------------------------------------------------------
72
73--
74-- Table structure for table `tblDocumentApprovers`
75--
76
77CREATE TABLE IF NOT EXISTS `tblDocumentApprovers` (
78 `approveID` int(11) NOT NULL AUTO_INCREMENT,
79 `documentID` int(11) NOT NULL DEFAULT '0',
80 `version` smallint(5) unsigned NOT NULL DEFAULT '0',
81 `type` tinyint(4) NOT NULL DEFAULT '0',
82 `required` int(11) NOT NULL DEFAULT '0',
83 `exp` int(12) NOT NULL,
84 `userDeadline` varchar(100) NOT NULL,
85 `grpDeadline` varchar(100) NOT NULL,
86 `sendEmail` int(1) NOT NULL,
87 `hash` varchar(6) NOT NULL,
88 PRIMARY KEY (`approveID`),
89 UNIQUE KEY `documentID` (`documentID`,`version`,`type`,`required`)
90) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
91
92-- --------------------------------------------------------
93
94--
95-- Table structure for table `tblDocumentApproversSerial`
96--
97
98CREATE TABLE IF NOT EXISTS `tblDocumentApproversSerial` (
99 `approveID` int(11) NOT NULL AUTO_INCREMENT,
100 `documentID` int(11) NOT NULL,
101 `version` smallint(5) unsigned NOT NULL,
102 `type` tinyint(4) NOT NULL,
103 `required` int(11) NOT NULL,
104 `exp` int(12) NOT NULL,
105 `userDeadline` varchar(100) NOT NULL,
106 `grpDeadline` varchar(100) NOT NULL,
107 PRIMARY KEY (`approveID`)
108) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
109
110-- --------------------------------------------------------
111
112--
113-- Table structure for table `tblDocumentTreasureLog`
114--
115
116CREATE TABLE IF NOT EXISTS `tblDocumentTreasureLog` (
117 `treasureLogID` int(11) NOT NULL AUTO_INCREMENT,
118 `treasureID` int(11) NOT NULL DEFAULT '0',
119 `status` tinyint(4) NOT NULL DEFAULT '0',
120 `comment` text NOT NULL,
121 `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
122 `userID` int(11) NOT NULL DEFAULT '0',
123 `show` varchar(100) NOT NULL DEFAULT '0',
124 PRIMARY KEY (`treasureLogID`)
125) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
126
127-- --------------------------------------------------------
128
129--
130-- Table structure for table `tblDocumentTreasurers`
131--
132
133CREATE TABLE IF NOT EXISTS `tblDocumentTreasurers` (
134 `treasureID` int(11) NOT NULL AUTO_INCREMENT,
135 `documentID` int(11) NOT NULL DEFAULT '0',
136 `version` smallint(5) unsigned NOT NULL DEFAULT '0',
137 `type` tinyint(4) NOT NULL DEFAULT '0',
138 `required` int(11) NOT NULL DEFAULT '0',
139 PRIMARY KEY (`treasureID`),
140 UNIQUE KEY `documentID` (`documentID`,`version`,`type`,`required`)
141) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
142
143-- --------------------------------------------------------
144
145--
146-- Table structure for table `tblDocumentTreasurersSerial`
147--
148
149CREATE TABLE IF NOT EXISTS `tblDocumentTreasurersSerial` (
150 `treasureID` int(11) NOT NULL AUTO_INCREMENT,
151 `documentID` int(11) NOT NULL,
152 `version` smallint(5) unsigned NOT NULL,
153 `type` tinyint(4) NOT NULL,
154 `required` int(11) NOT NULL,
155 PRIMARY KEY (`treasureID`)
156) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;