-
Notifications
You must be signed in to change notification settings - Fork 46
/
db.sql
106 lines (94 loc) · 5.56 KB
/
db.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
-- --------------------------------------------------------
-- Host: localhost
-- Server version: 5.6.35 - MySQL Community Server (GPL)
-- Server OS: Win32
-- HeidiSQL Version: 9.4.0.5174
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!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' */;
-- Dumping database structure for cias
DROP DATABASE IF EXISTS `cias`;
CREATE DATABASE IF NOT EXISTS `cias` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `cias`;
-- Dumping structure for table cias.tbl_items
DROP TABLE IF EXISTS `tbl_items`;
CREATE TABLE IF NOT EXISTS `tbl_items` (
`itemId` int(11) NOT NULL AUTO_INCREMENT,
`itemHeader` varchar(512) NOT NULL COMMENT 'Heading',
`itemSub` varchar(1021) NOT NULL COMMENT 'sub heading',
`itemDesc` text COMMENT 'content or description',
`itemImage` varchar(80) DEFAULT NULL,
`isDeleted` tinyint(4) NOT NULL DEFAULT '0',
`createdBy` int(11) NOT NULL,
`createdDtm` datetime NOT NULL,
`updatedDtm` datetime DEFAULT NULL,
`updatedBy` int(11) DEFAULT NULL,
PRIMARY KEY (`itemId`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- Dumping data for table cias.tbl_items: 2 rows
/*!40000 ALTER TABLE `tbl_items` DISABLE KEYS */;
REPLACE INTO `tbl_items` (`itemId`, `itemHeader`, `itemSub`, `itemDesc`, `itemImage`, `isDeleted`, `createdBy`, `createdDtm`, `updatedDtm`, `updatedBy`) VALUES
(1, 'jquery.validation.js', 'Contribution towards jquery.validation.js', 'jquery.validation.js is the client side javascript validation library authored by Jörn Zaefferer hosted on github for us and we are trying to contribute to it. Working on localization now', 'validation.png', 0, 1, '2015-09-02 00:00:00', NULL, NULL),
(2, 'CodeIgniter User Management', 'Demo for user management system', 'This the demo of User Management System (Admin Panel) using CodeIgniter PHP MVC Framework and AdminLTE bootstrap theme. You can download the code from the repository or forked it to contribute. Usage and installation instructions are provided in ReadMe.MD', 'cias.png', 0, 1, '2015-09-02 00:00:00', NULL, NULL);
/*!40000 ALTER TABLE `tbl_items` ENABLE KEYS */;
-- Dumping structure for table cias.tbl_reset_password
DROP TABLE IF EXISTS `tbl_reset_password`;
CREATE TABLE IF NOT EXISTS `tbl_reset_password` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`email` varchar(128) NOT NULL,
`activation_id` varchar(32) NOT NULL,
`agent` varchar(512) NOT NULL,
`client_ip` varchar(32) NOT NULL,
`isDeleted` tinyint(4) NOT NULL DEFAULT '0',
`createdBy` bigint(20) NOT NULL DEFAULT '1',
`createdDtm` datetime NOT NULL,
`updatedBy` bigint(20) DEFAULT NULL,
`updatedDtm` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;
-- Dumping data for table cias.tbl_reset_password: ~0 rows (approximately)
/*!40000 ALTER TABLE `tbl_reset_password` DISABLE KEYS */;
/*!40000 ALTER TABLE `tbl_reset_password` ENABLE KEYS */;
-- Dumping structure for table cias.tbl_roles
DROP TABLE IF EXISTS `tbl_roles`;
CREATE TABLE IF NOT EXISTS `tbl_roles` (
`roleId` tinyint(4) NOT NULL AUTO_INCREMENT COMMENT 'role id',
`role` varchar(50) NOT NULL COMMENT 'role text',
PRIMARY KEY (`roleId`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
-- Dumping data for table cias.tbl_roles: 3 rows
/*!40000 ALTER TABLE `tbl_roles` DISABLE KEYS */;
REPLACE INTO `tbl_roles` (`roleId`, `role`) VALUES
(1, 'System Administrator'),
(2, 'Manager'),
(3, 'Employee');
/*!40000 ALTER TABLE `tbl_roles` ENABLE KEYS */;
-- Dumping structure for table cias.tbl_users
DROP TABLE IF EXISTS `tbl_users`;
CREATE TABLE IF NOT EXISTS `tbl_users` (
`userId` int(11) NOT NULL AUTO_INCREMENT,
`email` varchar(128) NOT NULL COMMENT 'login email',
`password` varchar(128) NOT NULL COMMENT 'hashed login password',
`name` varchar(128) DEFAULT NULL COMMENT 'full name of user',
`mobile` varchar(20) DEFAULT NULL,
`roleId` tinyint(4) NOT NULL,
`isDeleted` tinyint(4) NOT NULL DEFAULT '0',
`createdBy` int(11) NOT NULL,
`createdDtm` datetime NOT NULL,
`updatedBy` int(11) DEFAULT NULL,
`updatedDtm` datetime DEFAULT NULL,
PRIMARY KEY (`userId`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
-- Dumping data for table cias.tbl_users: 3 rows
/*!40000 ALTER TABLE `tbl_users` DISABLE KEYS */;
REPLACE INTO `tbl_users` (`userId`, `email`, `password`, `name`, `mobile`, `roleId`, `isDeleted`, `createdBy`, `createdDtm`, `updatedBy`, `updatedDtm`) VALUES
(1, 'admin@bewithdhanu.in', '$2y$10$SAvFim22ptA9gHVORtIaru1dn9rhgerJlJCPxRNA02MjQaJnkxawq', 'System Administrator', '9890098900', 1, 0, 0, '2015-07-01 18:56:49', 1, '2017-06-19 09:22:53'),
(2, 'manager@bewithdhanu.in', '$2y$10$Gkl9ILEdGNoTIV9w/xpf3.mSKs0LB1jkvvPKK7K0PSYDsQY7GE9JK', 'Manager', '9890098900', 2, 0, 1, '2016-12-09 17:49:56', 1, '2017-06-19 09:22:29'),
(3, 'employee@bewithdhanu.in', '$2y$10$MB5NIu8i28XtMCnuExyFB.Ao1OXSteNpCiZSiaMSRPQx1F1WLRId2', 'Employee', '9890098900', 3, 0, 1, '2016-12-09 17:50:22', 1, '2017-06-19 09:23:21');
/*!40000 ALTER TABLE `tbl_users` ENABLE KEYS */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;