· 6 years ago · Sep 22, 2019, 03:24 AM
1-- phpMyAdmin SQL Dump
2-- version 4.0.10deb1
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Jun 11, 2015 at 04:17 PM
7-- Server version: 5.5.43-0ubuntu0.14.04.1
8-- PHP Version: 5.5.9-1ubuntu4.9
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `rc1`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `booking_entry`
27--
28
29CREATE TABLE IF NOT EXISTS `booking_entry` (
30 `book_main_id` int(11) NOT NULL AUTO_INCREMENT,
31 `booking_no` varchar(100) CHARACTER SET utf8 NOT NULL,
32 `date_booking` date NOT NULL,
33 `customer_name` varchar(100) CHARACTER SET utf8 NOT NULL,
34 `pincode` varchar(100) CHARACTER SET utf8 NOT NULL,
35 `city` varchar(100) CHARACTER SET utf8 NOT NULL,
36 `mobile_no` varchar(100) CHARACTER SET utf8 NOT NULL,
37 `address` text CHARACTER SET utf8 NOT NULL,
38 `booking_date` datetime NOT NULL,
39 `bed_amt` varchar(100) NOT NULL,
40 `others` varchar(100) NOT NULL,
41 `adv_amt` varchar(100) NOT NULL,
42 `bal_amt` varchar(100) NOT NULL,
43 `status` int(11) NOT NULL,
44 `created_date` date NOT NULL,
45 `actual_amt` varchar(100) NOT NULL,
46 `hidden_amt` varchar(100) CHARACTER SET utf8 NOT NULL,
47 `hidden_boxs` double(10,2) NOT NULL,
48 PRIMARY KEY (`book_main_id`)
49) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
50
51--
52-- Dumping data for table `booking_entry`
53--
54
55INSERT INTO `booking_entry` (`book_main_id`, `booking_no`, `date_booking`, `customer_name`, `pincode`, `city`, `mobile_no`, `address`, `booking_date`, `bed_amt`, `others`, `adv_amt`, `bal_amt`, `status`, `created_date`, `actual_amt`, `hidden_amt`, `hidden_boxs`) VALUES
56(1, 'BO-0001', '2015-05-28', 'Jeyaprakash.n', '628501', 'tuticorin', '9790403008', '23/a n no jeeva kovilpatti', '2015-05-28 18:21:00', '0.00', '0.00', '2000', '-700.00', 1, '2015-05-28', '1300.00', '', 0.00),
57(2, 'BO-0002', '2015-05-28', 'Babu', '627811', 'courtallam', '9952241321', 'kari kadai courtallam', '2015-05-28 23:54:00', '0.00', '0.00', '3000', '-500.00', 1, '2015-05-28', '2500.00', '', 0.00),
58(3, 'BO-0003', '2015-05-30', 'MR.DILPKUMAR', '638006', 'NAMAKKAL', '9952312359', '11MUNIAYAPAN NAGAR PALLIPALAYAM', '2015-05-30 07:02:00', '0.00', '0.00', '1500', '-700.00', 1, '2015-05-29', '800.00', '', 0.00),
59(5, 'BO-0004', '2015-06-03', 'MR.Ramanathan', '600005', 'chennai', '9790774878', '25/13(4b) singarachari st tiruvallikkenni', '2015-06-03 09:15:00', '', '0.00', '1000', 'NaN', 1, '2015-06-02', 'NaN', '', 0.00);
60
61-- --------------------------------------------------------
62
63--
64-- Table structure for table `booking_subentry`
65--
66
67CREATE TABLE IF NOT EXISTS `booking_subentry` (
68 `book_sub_id` int(11) NOT NULL AUTO_INCREMENT,
69 `room_no` varchar(100) CHARACTER SET utf8 NOT NULL,
70 `room_rent` varchar(100) CHARACTER SET utf8 NOT NULL,
71 `no_days` varchar(100) CHARACTER SET utf8 NOT NULL,
72 `no_persons` varchar(100) CHARACTER SET utf8 NOT NULL,
73 `amount` varchar(100) CHARACTER SET utf8 NOT NULL,
74 `created` date NOT NULL,
75 `booking_no` varchar(100) NOT NULL,
76 `renewal` int(11) NOT NULL,
77 `room_status` int(11) NOT NULL,
78 `status` int(11) NOT NULL,
79 PRIMARY KEY (`book_sub_id`)
80) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;
81
82--
83-- Dumping data for table `booking_subentry`
84--
85
86INSERT INTO `booking_subentry` (`book_sub_id`, `room_no`, `room_rent`, `no_days`, `no_persons`, `amount`, `created`, `booking_no`, `renewal`, `room_status`, `status`) VALUES
87(1, '20', '1300', '1', '7', '1300', '2015-05-28', 'BO-0001', 0, 1, 1),
88(11, '5', '500', '1', '3', '500', '2015-05-28', 'BO-0002', 0, 1, 1),
89(9, '3', '500', '1', '3', '500', '2015-05-28', 'BO-0002', 0, 1, 1),
90(10, '4', '500', '1', '4', '500', '2015-05-28', 'BO-0002', 0, 1, 1),
91(7, '2', '500', '1', '3', '500', '2015-05-28', 'BO-0002', 0, 1, 1),
92(12, '16', '500', '1', '3', '500', '2015-05-28', 'BO-0002', 0, 1, 1),
93(13, '3', '800', '1', '4', '800', '2015-05-29', 'BO-0003', 0, 1, 1),
94(15, '4', '600', '2', '1', '1200', '2015-06-02', 'BO-0004', 0, 1, 1);
95
96-- --------------------------------------------------------
97
98--
99-- Table structure for table `checkout_entry`
100--
101
102CREATE TABLE IF NOT EXISTS `checkout_entry` (
103 `check_id` int(11) NOT NULL AUTO_INCREMENT,
104 `booking_no` varchar(100) CHARACTER SET utf8 NOT NULL,
105 `booking_date` date NOT NULL,
106 `from_date` datetime NOT NULL,
107 `to_date` datetime NOT NULL,
108 `cust_details` varchar(100) CHARACTER SET utf8 NOT NULL,
109 `adv_amt` varchar(100) CHARACTER SET utf8 NOT NULL,
110 `address` varchar(100) CHARACTER SET utf8 NOT NULL,
111 `act_amt` varchar(100) CHARACTER SET utf8 NOT NULL,
112 `rec_amt` double(10,2) NOT NULL,
113 `pay_amt` double(10,2) NOT NULL,
114 `renewal_amt` double(10,2) NOT NULL,
115 `city` varchar(100) CHARACTER SET utf8 NOT NULL,
116 `bal_amt` varchar(100) CHARACTER SET utf8 NOT NULL,
117 `status` int(11) NOT NULL,
118 `room_no` varchar(100) NOT NULL,
119 `created_date` datetime NOT NULL,
120 PRIMARY KEY (`check_id`)
121) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
122
123--
124-- Dumping data for table `checkout_entry`
125--
126
127INSERT INTO `checkout_entry` (`check_id`, `booking_no`, `booking_date`, `from_date`, `to_date`, `cust_details`, `adv_amt`, `address`, `act_amt`, `rec_amt`, `pay_amt`, `renewal_amt`, `city`, `bal_amt`, `status`, `room_no`, `created_date`) VALUES
128(1, 'BO-0001', '2015-05-28', '2015-05-28 00:00:00', '2015-05-29 00:00:00', 'Jeyaprakash.n', '2000.00 ', '23/a n no jeeva kovilpatti', '1300.00', 0.00, 700.00, 0.00, 'tuticorin', '0.00', 1, '206 ', '2015-05-28 18:21:00'),
129(2, 'BO-0002', '2015-05-28', '2015-05-28 00:00:00', '2015-05-29 00:00:00', 'Babu', '3000.00 ', 'kari kadai courtallam', '2500.00', 0.00, 500.00, 0.00, 'courtallam', '0.00', 1, '105 ,103 ,104 ,102 ,106 ', '2015-05-29 23:54:00'),
130(3, 'BO-0003', '2015-05-30', '2015-05-30 00:00:00', '2015-05-31 00:00:00', 'MR.DILPKUMAR', '1500.00 ', '11MUNIAYAPAN NAGAR PALLIPALAYAM', '800.00', 0.00, 700.00, 0.00, 'NAMAKKAL', '0.00', 1, '103 ', '2015-05-30 18:56:45'),
131(12, 'BO-0004', '2015-06-03', '2015-06-03 00:00:00', '2015-06-05 00:00:00', 'MR.Ramanathan', '1000.00 ', '25/13(4b) singarachari st tiruvallikkenni', '1200.00', 200.00, 0.00, 0.00, 'chennai', '0.00', 1, '104 ', '2015-06-04 21:14:28');
132
133-- --------------------------------------------------------
134
135--
136-- Table structure for table `expenses`
137--
138
139CREATE TABLE IF NOT EXISTS `expenses` (
140 `id` int(11) NOT NULL AUTO_INCREMENT,
141 `booking_expense` varchar(100) CHARACTER SET utf8 NOT NULL,
142 `description` text CHARACTER SET utf8 NOT NULL,
143 `expense_amt` double(10,2) NOT NULL,
144 `exp_date` date NOT NULL,
145 PRIMARY KEY (`id`)
146) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
147
148--
149-- Dumping data for table `expenses`
150--
151
152INSERT INTO `expenses` (`id`, `booking_expense`, `description`, `expense_amt`, `exp_date`) VALUES
153(1, 'EXP-0001', 'commission room206', 130.00, '2015-05-28'),
154(2, 'EXP-0002', 'COMMISION ROOM 103', 80.00, '2015-05-29'),
155(4, 'EXP-0003', 'Senbaga Devi Kovil pooja ku', 500.00, '2015-06-05');
156
157-- --------------------------------------------------------
158
159--
160-- Table structure for table `extrabed`
161--
162
163CREATE TABLE IF NOT EXISTS `extrabed` (
164 `id` int(11) NOT NULL AUTO_INCREMENT,
165 `no_day` varchar(100) CHARACTER SET utf8 NOT NULL,
166 `booking_no` varchar(100) CHARACTER SET utf8 NOT NULL,
167 `extra_bed` varchar(100) CHARACTER SET utf8 NOT NULL,
168 `extra_amt` double(10,2) NOT NULL,
169 `tot_bed_amt` double(10,2) NOT NULL,
170 `renewal` int(11) NOT NULL,
171 `create_date` date NOT NULL,
172 PRIMARY KEY (`id`)
173) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
174
175-- --------------------------------------------------------
176
177--
178-- Table structure for table `room_no`
179--
180
181CREATE TABLE IF NOT EXISTS `room_no` (
182 `id` int(11) NOT NULL AUTO_INCREMENT,
183 `room_no` int(11) NOT NULL,
184 `room_status` int(11) NOT NULL,
185 PRIMARY KEY (`id`)
186) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=24 ;
187
188--
189-- Dumping data for table `room_no`
190--
191
192INSERT INTO `room_no` (`id`, `room_no`, `room_status`) VALUES
193(2, 102, 0),
194(3, 103, 0),
195(4, 104, 0),
196(5, 105, 0),
197(6, 201, 0),
198(7, 202, 0),
199(8, 203, 0),
200(9, 204, 0),
201(10, 205, 0),
202(11, 301, 0),
203(12, 302, 0),
204(13, 303, 0),
205(14, 304, 0),
206(15, 305, 0),
207(16, 106, 0),
208(17, 107, 0),
209(20, 206, 0),
210(22, 306, 0),
211(23, 307, 0);
212
213-- --------------------------------------------------------
214
215--
216-- Table structure for table `transcation_table`
217--
218
219CREATE TABLE IF NOT EXISTS `transcation_table` (
220 `id` int(11) NOT NULL AUTO_INCREMENT,
221 `date` date NOT NULL,
222 `booking_expense` varchar(100) CHARACTER SET utf8 NOT NULL,
223 `description` text CHARACTER SET utf8 NOT NULL,
224 `dr` double(10,2) NOT NULL,
225 `cr` double(10,2) NOT NULL,
226 `amt` double(10,2) NOT NULL,
227 `create_date` date NOT NULL,
228 PRIMARY KEY (`id`)
229) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;
230
231--
232-- Dumping data for table `transcation_table`
233--
234
235INSERT INTO `transcation_table` (`id`, `date`, `booking_expense`, `description`, `dr`, `cr`, `amt`, `create_date`) VALUES
236(1, '2015-05-28', 'BO-0001', 'Booking', 0.00, 2000.00, 0.00, '2015-05-28'),
237(2, '2015-05-28', 'EXP-0001', 'Expenses', 130.00, 0.00, 0.00, '2015-05-28'),
238(3, '2015-05-28', 'BO-0002', 'Booking', 0.00, 3000.00, 0.00, '2015-05-28'),
239(4, '2015-05-28', 'BO-0001', 'Checkout', 700.00, 0.00, 0.00, '2015-05-28'),
240(5, '2015-05-29', 'BO-0002', 'Checkout', 500.00, 0.00, 0.00, '2015-05-29'),
241(6, '2015-05-30', 'BO-0003', 'Booking', 0.00, 1500.00, 0.00, '2015-05-29'),
242(7, '2015-05-30', 'EXP-0002', 'Expenses', 80.00, 0.00, 0.00, '2015-05-30'),
243(9, '2015-05-30', 'BO-0003', 'Checkout', 700.00, 0.00, 0.00, '2015-05-30'),
244(20, '2015-06-04', 'BO-0004', 'Checkout', 0.00, 200.00, 0.00, '2015-06-04'),
245(19, '2015-06-03', 'BO-0004', 'Booking', 0.00, 1000.00, 0.00, '2015-06-02'),
246(21, '2015-06-05', 'EXP-0003', 'Expenses', 500.00, 0.00, 0.00, '0000-00-00');
247
248-- --------------------------------------------------------
249
250--
251-- Table structure for table `user_creation`
252--
253
254CREATE TABLE IF NOT EXISTS `user_creation` (
255 `user_id` int(11) NOT NULL AUTO_INCREMENT,
256 `staff_id` int(11) NOT NULL,
257 `user_type` varchar(100) NOT NULL,
258 `user_name` varchar(100) NOT NULL,
259 `password` varchar(100) NOT NULL,
260 `confirm_password` varchar(100) NOT NULL,
261 `status` varchar(100) NOT NULL,
262 `create_date` date NOT NULL,
263 PRIMARY KEY (`user_id`)
264) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
265
266--
267-- Dumping data for table `user_creation`
268--
269
270INSERT INTO `user_creation` (`user_id`, `staff_id`, `user_type`, `user_name`, `password`, `confirm_password`, `status`, `create_date`) VALUES
271(1, 1, 'Admin', 'admin', '12345', '12345', 'Yes', '2015-04-08'),
272(2, 2, 'Admin', 'user', '60609', '60609', 'Yes', '2015-04-05');
273
274-- --------------------------------------------------------
275
276--
277-- Table structure for table `user_rights`
278--
279
280CREATE TABLE IF NOT EXISTS `user_rights` (
281 `id` int(11) NOT NULL AUTO_INCREMENT,
282 `user_id` int(11) NOT NULL,
283 `user_screen` varchar(100) NOT NULL,
284 `user_form_name` varchar(100) NOT NULL,
285 `access_form` varchar(100) NOT NULL,
286 PRIMARY KEY (`id`)
287) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
288
289--
290-- Dumping data for table `user_rights`
291--
292
293INSERT INTO `user_rights` (`id`, `user_id`, `user_screen`, `user_form_name`, `access_form`) VALUES
294(1, 1, 'Admin', 'user_creation', 'user_creation,user_rights'),
295(2, 1, 'Admin', 'user_rights', 'user_creation,user_rights'),
296(3, 1, 'Booking Entry', 'booking_creation', 'booking_creation'),
297(10, 2, 'Report', 'day_report', 'day_report'),
298(12, 1, 'Check Out', 'checkout_creation', 'checkout_creation');
299
300/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
301/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
302/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;