· 9 years ago · Feb 03, 2017, 12:54 AM
1-- phpMyAdmin SQL Dump
2-- version 2.6.3-pl1
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Oct 17, 2005 at 09:59 AM
7-- Server version: 4.0.25
8-- PHP Version: 4.3.11
9--
10-- Database: `lhubbar4_truck`
11--
12
13-- --------------------------------------------------------
14
15--
16-- Table structure for table `addressbook`
17--
18CREATE DATABASE lhubbar4_truck;
19USE lhubbar4_truck;
20DROP TABLE IF EXISTS `addressbook`;
21CREATE TABLE `addressbook` (
22 `company_id` int(11) NOT NULL auto_increment,
23 `id` int(11) default '0',
24 `info_id` varchar(20) default '0',
25 `fname` varchar(25) default '0',
26 `mlname` varchar(25) default '0',
27 `lname` varchar(25) default '0',
28 `address` varchar(45) default '0',
29 `company_name` varchar(25) default '0',
30 `city` varchar(25) default '0',
31 `businesshour` varchar(25) default '0',
32 `from_show` varchar(45) default '0',
33 `state` varchar(25) default '0',
34 `zip` varchar(25) default '0',
35 `email` varchar(25) default '0',
36 `workpone` varchar(25) default '0',
37 `phone` varchar(25) default '0',
38 `fax` varchar(25) default '0',
39 `website` varchar(25) default '0',
40 `home` varchar(25) default '0',
41 `from` varchar(45) default '0',
42 `category` varchar(23) default '0',
43 `bday` varchar(23) default '0',
44 `aday` varchar(23) default '0',
45 `wname` varchar(45) default '0',
46 `truck_no` varchar(23) default '0',
47 `drivlinc` varchar(45) default '0',
48 `dthired` varchar(23) default '0',
49 `dtterm` varchar(23) default '0',
50 `diexp` varchar(24) default '0',
51 `createdt` varchar(23) default '0',
52 `modifydt` varchar(23) default '0',
53 `terms` varchar(45) default '0',
54 `ss` varchar(25) default '0',
55 `notes` longtext,
56 `direction` longtext,
57 PRIMARY KEY (`company_id`)
58) ENGINE=MyISAM AUTO_INCREMENT=66 ;
59
60--
61-- Dumping data for table `addressbook`
62--
63
64INSERT INTO `addressbook` VALUES (57, 1, '2435', 'saikat', '', 'dutta', 'Golfgreen', 'ezone', 'kolkata', '10:30', 'Xzone', 'W.B', '0', 'saik123@yahoo.com', '', '0', '', '', '0', '0', '------Select a Category', '14', '14', '', '', '', '14', '14', '0', '0', '0', '', '', 'sjfgjkshjkglgjkldfjgklgjklhjkl', 'asfsdgdfhgfhjgh');
65INSERT INTO `addressbook` VALUES (58, 8, '1', 'debjyoti', 'kumai', 'chakraborty', 'asdadadad', 'asdasd', '242', 'asdadad', '', 'asdad', '70001', 'saik@y.ocm', '854684', '0', '7555', 'eee.ery.nom', '0', '0', '------Select a Category', 'sdfsf', 'sdfdsf', 'sdfsf', '', '', 'sdfsf', 'sdfsf', 'sdfsdf', 'sdfs', 'sdffdsf', '', 'sdfdsf', 'sdgsdgdfgfdgdfgdfgdfg', 'dfgdfgdgdgdgdg');
66INSERT INTO `addressbook` VALUES (59, 0, '111', 'saikat', '', 'dutta', 'sadsadsf', 'sdsads', '', '', '', '', '0', 'saik999@yahoo.com', '', '0', '', '', '0', '0', 'broker', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', NULL, NULL);
67INSERT INTO `addressbook` VALUES (65, 2, '1223', 'rajiv', 'sads', 'gfdfggf', 'dfghh', 'fdg', '', '', '', '', '0', 'saik9992@asgh.com', '', '0', '', '', '0', '0', '------Select a Category', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', NULL, NULL);
68INSERT INTO `addressbook` VALUES (61, 1, '12', 'rupok', '', 'bhat', 'bikramgrah', 'ezone', '', '', '', '', '0', 'rupok123@yahoo.com', '', '0', '', '', '0', '0', 'shipper', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', NULL, NULL);
69INSERT INTO `addressbook` VALUES (62, 1, '45', 'sdsds', 'fgdf', 'vbv', 'jhgjhgjhh', 'jnjklj', '', '', '', '', '0', 'sds@ghg.ca', '', '0', '', '', '0', '0', 'shipper', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', NULL, NULL);
70INSERT INTO `addressbook` VALUES (63, 1, '32', 'avik', '', 'dd', 'madox', 'i-navi', '', '', '', '', '0', 'iii@hhdgj.kol', '', '0', '', '', '0', '0', 'broker', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', NULL, NULL);
71INSERT INTO `addressbook` VALUES (64, 1, '33', 'auparva', '', 'mondal', 'kolkata', 'disha comm', '', '', '', '', '0', 'dddd@nsdh.dhffg', '', '0', '', '', '0', '0', 'shipper', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', NULL, NULL);
72
73-- --------------------------------------------------------
74
75--
76-- Table structure for table `category`
77--
78
79DROP TABLE IF EXISTS `category`;
80CREATE TABLE `category` (
81 `cat_id` int(11) NOT NULL auto_increment,
82 `c_name` varchar(24) default '0',
83 PRIMARY KEY (`cat_id`)
84) ENGINE=MyISAM AUTO_INCREMENT=60 ;
85
86--
87-- Dumping data for table `category`
88--
89
90INSERT INTO `category` VALUES (1, 'shipper');
91INSERT INTO `category` VALUES (2, 'broker');
92INSERT INTO `category` VALUES (45, 'recevier');
93INSERT INTO `category` VALUES (46, 'customer');
94INSERT INTO `category` VALUES (54, 'raghu');
95INSERT INTO `category` VALUES (59, 'expoter');
96
97-- --------------------------------------------------------
98
99--
100-- Table structure for table `expense`
101--
102
103DROP TABLE IF EXISTS `expense`;
104CREATE TABLE `expense` (
105 `exp_id` int(10) NOT NULL auto_increment,
106 `profit_id` varchar(10) default NULL,
107 `id` int(10) NOT NULL default '0',
108 `ex_date` int(11) NOT NULL default '0',
109 `ex_payee` varchar(30) default NULL,
110 `ex_category` varchar(30) default NULL,
111 `ex_des` varchar(200) default NULL,
112 `ex_exp` float(10,2) NOT NULL default '0.00',
113 `ex_hour` float(4,2) NOT NULL default '0.00',
114 PRIMARY KEY (`exp_id`)
115) ENGINE=MyISAM AUTO_INCREMENT=21 ;
116
117--
118-- Dumping data for table `expense`
119--
120
121INSERT INTO `expense` VALUES (14, '7', 3, 1008133200, 'samik', 'Unloading Pay', 'aqdqwd', 250.00, 5.00);
122INSERT INTO `expense` VALUES (16, '7', 3, 1129093200, 'samik', 'Fuel', 'aqdqwd', 250.00, 5.00);
123INSERT INTO `expense` VALUES (12, '7', 1, 989035200, 'ewwe', 'Unloading Pay', 'dddd', 450.00, 0.00);
124INSERT INTO `expense` VALUES (17, '4', 1, -14462, 'samik cha', 'Insurance', 'sasadfsfsf', 5000.00, 4.25);
125INSERT INTO `expense` VALUES (18, '5', 1, 1104469200, 'sss', 'Oil', 'arawrawew', 200.00, 5.00);
126INSERT INTO `expense` VALUES (19, '5', 1, 347086800, 'frt', 'Oil', 'regerte', 4587.00, 4.25);
127INSERT INTO `expense` VALUES (20, '5', 1, 976597200, 'wefrwer', 'Tolls', 'ewrwer', 5000.00, 0.00);
128
129-- --------------------------------------------------------
130
131--
132-- Table structure for table `income`
133--
134
135DROP TABLE IF EXISTS `income`;
136CREATE TABLE `income` (
137 `exp_id` int(10) NOT NULL auto_increment,
138 `profit_id` varchar(10) default NULL,
139 `id` int(10) NOT NULL default '0',
140 `ex_date` int(11) NOT NULL default '0',
141 `ex_payee` varchar(30) default NULL,
142 `ex_category` varchar(30) default NULL,
143 `income` float(10,2) NOT NULL default '0.00',
144 `ex_des` varchar(200) default NULL,
145 PRIMARY KEY (`exp_id`)
146) ENGINE=MyISAM AUTO_INCREMENT=8 ;
147
148--
149-- Dumping data for table `income`
150--
151
152INSERT INTO `income` VALUES (1, '7', 1, 1, 'sam', 'Unloading Pay', 58968.00, 'fghfghfh');
153INSERT INTO `income` VALUES (2, '7', 1, 1, 'sam', 'Unloading Pay', 58968.00, 'fghfghfh');
154INSERT INTO `income` VALUES (3, '4', 1, -14462, 'sasdas', 'Repairs', 4000.00, 'awdasdadad');
155INSERT INTO `income` VALUES (4, '5', 1, 10, 'sam', 'Advance', 500.00, 'ewrwrwrwrwrwr');
156INSERT INTO `income` VALUES (5, '5', 1, 2, 'sai', 'Truck Payment', 5000.00, 'strewtreterte');
157INSERT INTO `income` VALUES (6, '5', 1, 10, 'fdsf', 'Tires', 500.00, 'sdfdsfsf');
158INSERT INTO `income` VALUES (7, '5', 1, 978325200, 'awerwqer', 'Fuel', 80000.00, 'ewrwer');
159
160-- --------------------------------------------------------
161
162--
163-- Table structure for table `regions`
164--
165
166DROP TABLE IF EXISTS `regions`;
167CREATE TABLE `regions` (
168 `region_id` int(11) NOT NULL auto_increment,
169 `region` text,
170 PRIMARY KEY (`region_id`)
171) ENGINE=MyISAM AUTO_INCREMENT=108 ;
172
173--
174-- Dumping data for table `regions`
175--
176
177INSERT INTO `regions` VALUES (1, 'Alabama');
178INSERT INTO `regions` VALUES (2, 'Alaska');
179INSERT INTO `regions` VALUES (3, 'Arizona');
180INSERT INTO `regions` VALUES (4, 'Arkansas');
181INSERT INTO `regions` VALUES (5, 'California');
182INSERT INTO `regions` VALUES (6, 'Colorado');
183INSERT INTO `regions` VALUES (7, 'Connecticut');
184INSERT INTO `regions` VALUES (8, 'Delaware');
185INSERT INTO `regions` VALUES (9, 'Washington');
186INSERT INTO `regions` VALUES (10, 'Florida');
187INSERT INTO `regions` VALUES (11, 'Georgia');
188INSERT INTO `regions` VALUES (12, 'Hawaii');
189INSERT INTO `regions` VALUES (13, 'Idaho');
190INSERT INTO `regions` VALUES (14, 'Illinois');
191INSERT INTO `regions` VALUES (15, 'Indiana');
192INSERT INTO `regions` VALUES (16, 'Iowa');
193INSERT INTO `regions` VALUES (17, 'Kansas');
194INSERT INTO `regions` VALUES (18, 'Kentucky');
195INSERT INTO `regions` VALUES (19, 'Louisiana');
196INSERT INTO `regions` VALUES (20, 'Maine');
197INSERT INTO `regions` VALUES (21, 'Maryland');
198INSERT INTO `regions` VALUES (22, 'Massachusetts');
199INSERT INTO `regions` VALUES (23, 'Michigan');
200INSERT INTO `regions` VALUES (24, 'Minnesota');
201INSERT INTO `regions` VALUES (25, 'Mississippi');
202INSERT INTO `regions` VALUES (26, 'Missouri');
203INSERT INTO `regions` VALUES (27, 'Montana');
204INSERT INTO `regions` VALUES (28, 'Nebraska');
205INSERT INTO `regions` VALUES (29, 'Nevada');
206INSERT INTO `regions` VALUES (30, 'New Hampshire');
207INSERT INTO `regions` VALUES (31, 'New Jersey');
208INSERT INTO `regions` VALUES (32, 'New Mexico');
209INSERT INTO `regions` VALUES (33, 'New York');
210INSERT INTO `regions` VALUES (34, 'North Carolina');
211INSERT INTO `regions` VALUES (35, 'North Dakota');
212INSERT INTO `regions` VALUES (36, 'Ohio');
213INSERT INTO `regions` VALUES (37, 'Oklahoma');
214INSERT INTO `regions` VALUES (38, 'Oregon');
215INSERT INTO `regions` VALUES (39, 'Pennsylvania');
216INSERT INTO `regions` VALUES (40, 'Rhode Island');
217INSERT INTO `regions` VALUES (41, 'South Carolina');
218INSERT INTO `regions` VALUES (42, 'South Dakota');
219INSERT INTO `regions` VALUES (43, 'Tennessee');
220INSERT INTO `regions` VALUES (44, 'Texas');
221INSERT INTO `regions` VALUES (45, 'Utah');
222INSERT INTO `regions` VALUES (46, 'Vermont');
223INSERT INTO `regions` VALUES (47, 'Virginia');
224INSERT INTO `regions` VALUES (48, 'Washington');
225INSERT INTO `regions` VALUES (49, 'West Virginia');
226INSERT INTO `regions` VALUES (50, 'Wisconsin');
227INSERT INTO `regions` VALUES (51, 'Wyoming');
228INSERT INTO `regions` VALUES (52, 'Ontario');
229INSERT INTO `regions` VALUES (53, 'Alberta');
230INSERT INTO `regions` VALUES (54, 'Prince Edward');
231INSERT INTO `regions` VALUES (55, 'Newfoundland');
232INSERT INTO `regions` VALUES (56, 'British Columbia');
233INSERT INTO `regions` VALUES (57, 'Nunavut');
234INSERT INTO `regions` VALUES (58, 'Manitoba');
235INSERT INTO `regions` VALUES (59, 'Nova Scotia');
236INSERT INTO `regions` VALUES (60, 'New Brunswick');
237INSERT INTO `regions` VALUES (61, 'Saskatchewan');
238INSERT INTO `regions` VALUES (62, 'Quebec');
239INSERT INTO `regions` VALUES (63, 'Yukon');
240INSERT INTO `regions` VALUES (64, 'Home Counties');
241INSERT INTO `regions` VALUES (65, 'London');
242INSERT INTO `regions` VALUES (66, 'Midlands');
243INSERT INTO `regions` VALUES (67, 'Northeast');
244INSERT INTO `regions` VALUES (68, 'Northern Ireland');
245INSERT INTO `regions` VALUES (69, 'Northwest');
246INSERT INTO `regions` VALUES (70, 'Scotland');
247INSERT INTO `regions` VALUES (71, 'Southwest');
248INSERT INTO `regions` VALUES (72, 'Wales');
249INSERT INTO `regions` VALUES (73, 'Australian Capital Territory');
250INSERT INTO `regions` VALUES (74, 'New South Wales');
251INSERT INTO `regions` VALUES (75, 'Northern \r\n Territory');
252INSERT INTO `regions` VALUES (76, 'Queensland');
253INSERT INTO `regions` VALUES (77, 'South Australia');
254INSERT INTO `regions` VALUES (78, 'Tasmania');
255INSERT INTO `regions` VALUES (79, 'Vctoria');
256INSERT INTO `regions` VALUES (80, 'Western Australia');
257INSERT INTO `regions` VALUES (81, 'Guernsey');
258INSERT INTO `regions` VALUES (82, 'Isle Of Man');
259INSERT INTO `regions` VALUES (83, 'Jersey');
260INSERT INTO `regions` VALUES (84, 'Shetland');
261INSERT INTO `regions` VALUES (85, 'Central And \r\n Western');
262INSERT INTO `regions` VALUES (86, 'Eastern');
263INSERT INTO `regions` VALUES (87, 'Islands');
264INSERT INTO `regions` VALUES (88, 'Kowloon City');
265INSERT INTO `regions` VALUES (89, 'Kwai Tsing');
266INSERT INTO `regions` VALUES (90, 'Kwun Tong');
267INSERT INTO `regions` VALUES (91, 'North');
268INSERT INTO `regions` VALUES (92, 'Sai Kung');
269INSERT INTO `regions` VALUES (93, 'Sha Tin');
270INSERT INTO `regions` VALUES (94, 'Sham Shui Po');
271INSERT INTO `regions` VALUES (95, 'Southern');
272INSERT INTO `regions` VALUES (96, 'Tai Po');
273INSERT INTO `regions` VALUES (97, 'Tsuen Wan');
274INSERT INTO `regions` VALUES (98, 'Tuen Mun');
275INSERT INTO `regions` VALUES (99, 'Wan Chai');
276INSERT INTO `regions` VALUES (100, 'Wong Tai Sin');
277INSERT INTO `regions` VALUES (101, 'Yau Tsim Mong');
278INSERT INTO `regions` VALUES (102, 'Yuen Long');
279INSERT INTO `regions` VALUES (103, 'East');
280INSERT INTO `regions` VALUES (104, 'North');
281INSERT INTO `regions` VALUES (105, 'South');
282INSERT INTO `regions` VALUES (106, 'West');
283INSERT INTO `regions` VALUES (107, 'Victoria');
284
285-- --------------------------------------------------------
286
287--
288-- Table structure for table `state`
289--
290
291DROP TABLE IF EXISTS `state`;
292CREATE TABLE `state` (
293 `id` int(11) NOT NULL auto_increment,
294 `s_name` varchar(25) default NULL,
295 `statefueltax` varchar(45) default '0',
296 `sur_fuel_tax` varchar(45) default '0',
297 PRIMARY KEY (`id`)
298) ENGINE=MyISAM AUTO_INCREMENT=79 ;
299
300--
301-- Dumping data for table `state`
302--
303
304INSERT INTO `state` VALUES (1, 'Alabama', '0', '0');
305INSERT INTO `state` VALUES (2, 'Alaska', '0', '0');
306INSERT INTO `state` VALUES (3, 'Alberta', '0', '0');
307INSERT INTO `state` VALUES (4, 'American Samoa', '0', '0');
308INSERT INTO `state` VALUES (5, 'AriZona', '0', '0');
309INSERT INTO `state` VALUES (6, 'Arkansas', '0', '0');
310INSERT INTO `state` VALUES (7, 'Armed Forces Americas', '0', '0');
311INSERT INTO `state` VALUES (8, 'Armed Forces Europe', '0', '0');
312INSERT INTO `state` VALUES (9, 'Armed Forces Pacific', '0', '0');
313INSERT INTO `state` VALUES (10, 'British Columbia', '0', '0');
314INSERT INTO `state` VALUES (11, 'California', '0', '0');
315INSERT INTO `state` VALUES (12, 'Canada', '0', '0');
316INSERT INTO `state` VALUES (13, 'Colorado', '0', '0');
317INSERT INTO `state` VALUES (14, 'Connecticut', '0', '0');
318INSERT INTO `state` VALUES (15, 'Delaware', '0', '0');
319INSERT INTO `state` VALUES (16, 'District of Columbia', '0', '0');
320INSERT INTO `state` VALUES (17, 'Florida', '0', '0');
321INSERT INTO `state` VALUES (18, 'Georgia', '0', '0');
322INSERT INTO `state` VALUES (19, 'Guam', '0', '0');
323INSERT INTO `state` VALUES (20, 'Hawaii', '0', '0');
324INSERT INTO `state` VALUES (21, 'Idaho', '0', '0');
325INSERT INTO `state` VALUES (22, 'Illinois', '0', '0');
326INSERT INTO `state` VALUES (23, 'Indiana', '0', '0');
327INSERT INTO `state` VALUES (24, 'Iowa', '0', '0');
328INSERT INTO `state` VALUES (25, 'Kansas', '0', '0');
329INSERT INTO `state` VALUES (26, 'Kentucky', '0', '0');
330INSERT INTO `state` VALUES (27, 'Louisiana', '0', '0');
331INSERT INTO `state` VALUES (28, 'Maine', '0', '0');
332INSERT INTO `state` VALUES (29, 'Manitoba', '0', '0');
333INSERT INTO `state` VALUES (30, 'Maryland', '0', '0');
334INSERT INTO `state` VALUES (31, 'Massachusetts', '0', '0');
335INSERT INTO `state` VALUES (32, 'Michigan', '0', '0');
336INSERT INTO `state` VALUES (33, 'Minnesota', '0', '0');
337INSERT INTO `state` VALUES (34, 'Mississippi', '0', '0');
338INSERT INTO `state` VALUES (35, 'Missouri', '0', '0');
339INSERT INTO `state` VALUES (36, 'Montana', '0', '0');
340INSERT INTO `state` VALUES (37, 'Nebraska', '0', '0');
341INSERT INTO `state` VALUES (38, 'Nevada', '0', '0');
342INSERT INTO `state` VALUES (39, 'New HampShire', '0', '0');
343INSERT INTO `state` VALUES (40, 'New Jersey', '0', '0');
344INSERT INTO `state` VALUES (41, 'New Mexico', '0', '0');
345INSERT INTO `state` VALUES (42, 'New York', '0', '0');
346INSERT INTO `state` VALUES (43, 'Newfoundland', '0', '0');
347INSERT INTO `state` VALUES (44, 'North Carolina', '0', '0');
348INSERT INTO `state` VALUES (45, 'North Dakota', '0', '0');
349INSERT INTO `state` VALUES (46, 'Northern Mariana Is', '0', '0');
350INSERT INTO `state` VALUES (47, 'Northwest Territories', '0', '0');
351INSERT INTO `state` VALUES (48, 'Nova Scotia', '0', '0');
352INSERT INTO `state` VALUES (49, 'Ohio', '0', '0');
353INSERT INTO `state` VALUES (50, 'Oklahoma', '0', '0');
354INSERT INTO `state` VALUES (51, 'Ontario', '0', '0');
355INSERT INTO `state` VALUES (52, 'Oregon', '0', '0');
356INSERT INTO `state` VALUES (53, 'Palau', '0', '0');
357INSERT INTO `state` VALUES (54, 'Pennsylvania', '0', '0');
358INSERT INTO `state` VALUES (55, 'Prince Edward Island', '0', '0');
359INSERT INTO `state` VALUES (56, 'Province du Quebec', '0', '0');
360INSERT INTO `state` VALUES (57, 'Puerto Rico', '0', '0');
361INSERT INTO `state` VALUES (58, 'Rhode Island', '0', '0');
362INSERT INTO `state` VALUES (59, 'Saskatchewan', '0', '0');
363INSERT INTO `state` VALUES (60, 'South Carolina', '0', '0');
364INSERT INTO `state` VALUES (61, 'South Dakota', '0', '0');
365INSERT INTO `state` VALUES (62, 'Tennessee', '0', '0');
366INSERT INTO `state` VALUES (63, 'Texas', '0', '0');
367INSERT INTO `state` VALUES (64, 'Utah', '0', '0');
368INSERT INTO `state` VALUES (65, 'Vermont', '0', '0');
369INSERT INTO `state` VALUES (66, 'Virgin Islands', '0', '0');
370INSERT INTO `state` VALUES (67, 'Virginia', '0', '0');
371INSERT INTO `state` VALUES (68, 'Washington', '0', '0');
372INSERT INTO `state` VALUES (69, 'West Virginia', '0', '0');
373INSERT INTO `state` VALUES (70, 'Wisconsin', '0', '0');
374INSERT INTO `state` VALUES (71, 'Wyoming', '0', '0');
375INSERT INTO `state` VALUES (72, 'Yukon Territory', '0', '0');
376INSERT INTO `state` VALUES (73, 'A.F. Africa', '.345', '.345');
377INSERT INTO `state` VALUES (74, 'A.F. Americas', '0', '0');
378INSERT INTO `state` VALUES (75, 'A.F. Canada', '0', '0');
379INSERT INTO `state` VALUES (76, 'A.F. Europe', '0', '0');
380INSERT INTO `state` VALUES (77, 'A.F. Middle East', '0', '0');
381INSERT INTO `state` VALUES (78, 'Not Listed', '0', '0');
382
383-- --------------------------------------------------------
384
385--
386-- Table structure for table `tripentry`
387--
388
389DROP TABLE IF EXISTS `tripentry`;
390CREATE TABLE `tripentry` (
391 `trip_id` int(11) NOT NULL auto_increment,
392 `id` int(11) default '0',
393 `truck_no` int(15) default '0',
394 `invoice_no` int(20) default '0',
395 `company_name` varchar(45) default NULL,
396 `roadtravelled` varchar(20) default NULL,
397 `beginingmileage` varchar(22) default '0',
398 `endingmileage` varchar(22) default '0',
399 `milesstate` varchar(22) default '0',
400 `nontaxmiles` varchar(22) default '0',
401 `totalmiles` varchar(22) default '0',
402 `gallonpurchased` varchar(22) default '0',
403 `fuelcost` varchar(22) default '0',
404 `costpergallon` varchar(22) default '0',
405 `city` varchar(25) default NULL,
406 `dt` int(15) default '0',
407 `state` varchar(23) NOT NULL default '',
408 `fuelstop` varchar(45) default '0',
409 PRIMARY KEY (`trip_id`)
410) ENGINE=MyISAM AUTO_INCREMENT=134 ;
411
412--
413-- Dumping data for table `tripentry`
414--
415
416INSERT INTO `tripentry` VALUES (127, 1, 15, 213214, 'ezone', 'dfdsfg', '43434', '354325435', '', '', '354368869', '34532', '46', '750.69565217391', 'MUMBAI', 1129380358, 'AriZona', '2435');
417INSERT INTO `tripentry` VALUES (129, 1, 1111, 234343, 'ezone', 'dfdsfg', '234', '246', '', '', '480', '2334444', '23', '101497.56521739', 'kolkata', 1128603060, 'Louisiana', '2435');
418INSERT INTO `tripentry` VALUES (130, 1, 11, 232324, 'ezone', 'dfdsf', '22323', '2334', '44444', '444', '44888', '2132134', '3434', '620.88934187536', 'kolkata', 1128691680, 'Manitoba', '2435');
419INSERT INTO `tripentry` VALUES (131, 1, 11, 13242314, 'ezone', 'asddcsafcd', '245', '23', '', '', '268', '2345', '34', '68.970588235294', 'kolkata', 1128877680, 'Alabama', '2435');
420INSERT INTO `tripentry` VALUES (132, 1, 1111, 43435, 'ezone', 'efwerfwe', '2345', '3456', '', '30', '1141', '2345', '34', '68.970588235294', 'kolkata', 1128535920, 'Florida', '2435');
421INSERT INTO `tripentry` VALUES (133, 1, 15, 5154, 'asdasd', 'rtyrtyrtyry', '1457', '22222', '', '', '20765', '4587', '40', '114.675', '242', 1130230860, 'Illinois', '1');
422
423-- --------------------------------------------------------
424
425--
426-- Table structure for table `truck_adminj`
427--
428
429DROP TABLE IF EXISTS `truck_adminj`;
430CREATE TABLE `truck_adminj` (
431 `id` int(10) NOT NULL auto_increment,
432 `name` varchar(20) default NULL,
433 `password` varchar(20) default NULL,
434 `fname` varchar(30) default NULL,
435 `lname` varchar(30) default NULL,
436 `company` varchar(30) default NULL,
437 `address` varchar(100) default NULL,
438 `city` varchar(20) default NULL,
439 `state` varchar(20) default NULL,
440 `zip` varchar(10) default NULL,
441 `phone` varchar(10) default NULL,
442 `email` varchar(50) default NULL,
443 `ifta_id` int(10) NOT NULL default '0',
444 PRIMARY KEY (`id`)
445) ENGINE=MyISAM AUTO_INCREMENT=9 ;
446
447--
448-- Dumping data for table `truck_adminj`
449--
450
451INSERT INTO `truck_adminj` VALUES (1, 'admin', 'admin', 'saurav', 'Ganguly', 'ezone', 'KOLKATA', 'kolkata', 'west-bengal', '700032', '86787678', 'debnath@jhghg.com', 401);
452INSERT INTO `truck_adminj` VALUES (2, 'saurav', 'saurav', 'saurav sanyal', 'dddd', 'xxxxx', ' ', '', '', '', '', '', 0);
453INSERT INTO `truck_adminj` VALUES (3, 'samik', 'letmein', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
454INSERT INTO `truck_adminj` VALUES (6, 'gunjan', 'gunjan', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
455INSERT INTO `truck_adminj` VALUES (7, 's', 's', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
456INSERT INTO `truck_adminj` VALUES (8, 'samikc', 'letmein', 'saikat', 'haldar', 'mem creation', 'asdasdadad', 'kolkata', '587', '1236566', '67890', 'anjay@yahoo.com', 125);
457
458-- --------------------------------------------------------
459
460--
461-- Table structure for table `truck_details`
462--
463
464DROP TABLE IF EXISTS `truck_details`;
465CREATE TABLE `truck_details` (
466 `truck_id` int(10) NOT NULL auto_increment,
467 `id` int(10) NOT NULL default '0',
468 `truck_no` int(10) default NULL,
469 `truck_driver` varchar(20) default NULL,
470 `des` text,
471 `truck_vin` varchar(30) default NULL,
472 `truck_lic_no` varchar(30) default NULL,
473 `state` varchar(30) default NULL,
474 `truck_weg` int(10) NOT NULL default '0',
475 `trailer_vin` varchar(30) default NULL,
476 `trailer_no` varchar(30) default NULL,
477 `tralier_lic_state` varchar(30) default NULL,
478 `tralier_weg` int(10) NOT NULL default '0',
479 `tralier_lic_no` varchar(30) default NULL,
480 `total_weg` int(10) NOT NULL default '0',
481 PRIMARY KEY (`truck_id`)
482) ENGINE=MyISAM AUTO_INCREMENT=24 ;
483
484--
485-- Dumping data for table `truck_details`
486--
487
488INSERT INTO `truck_details` VALUES (16, 3, 11, 'sam,', 'hy', NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, 0);
489INSERT INTO `truck_details` VALUES (21, 2, 1111, 'samik', 'sam', NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, 0);
490INSERT INTO `truck_details` VALUES (19, 1, 45, 'Henry', 'good', '', '', '', 0, 'drgrdgdg', 'dfgdgdgdg', '', 0, '', 0);
491INSERT INTO `truck_details` VALUES (20, 1, 15, 'viru', 'tire is not good', '', '', '', 1547, '', '12547', '', 0, '', 0);
492INSERT INTO `truck_details` VALUES (22, 8, 1254, 'avik', 'own truck', '', '', '', 0, '123654', 'tr10', '', 0, '', 0);
493INSERT INTO `truck_details` VALUES (23, 1, 2588, 'frtyt', 'trrrr', NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, 0);
494
495-- --------------------------------------------------------
496
497--
498-- Table structure for table `truck_profitpermile`
499--
500
501DROP TABLE IF EXISTS `truck_profitpermile`;
502CREATE TABLE `truck_profitpermile` (
503 `profit_id` int(10) NOT NULL auto_increment,
504 `id` int(10) NOT NULL default '0',
505 `infoid_shiper` varchar(20) default NULL,
506 `infoid_recive` varchar(20) default NULL,
507 `truck_no` int(10) NOT NULL default '0',
508 `trip_date` int(11) NOT NULL default '0',
509 `deliver_dt` int(11) NOT NULL default '0',
510 `pickup_dt` int(11) NOT NULL default '0',
511 `loded_miles` int(20) NOT NULL default '0',
512 `empty_miles` int(20) NOT NULL default '0',
513 `trip_miles` int(25) NOT NULL default '0',
514 `load_stat` varchar(15) default NULL,
515 `pro_no` varchar(20) default NULL,
516 `trip_no` varchar(20) default NULL,
517 `load_des` text NOT NULL,
518 `load_weg` int(20) NOT NULL default '0',
519 `bil_lading` varchar(20) default NULL,
520 `seal_no` varchar(20) default NULL,
521 `notes` text NOT NULL,
522 `ex_totals` float(10,2) NOT NULL default '0.00',
523 `in_totals` float(10,2) NOT NULL default '0.00',
524 `rev_per_mile` float(10,3) NOT NULL default '0.000',
525 `advance` float(10,2) NOT NULL default '0.00',
526 `term` varchar(20) default NULL,
527 `claim` char(3) default NULL,
528 `invoice_dt` int(11) NOT NULL default '0',
529 `counter` int(10) NOT NULL default '0',
530 PRIMARY KEY (`profit_id`)
531) ENGINE=MyISAM AUTO_INCREMENT=10 ;
532
533--
534-- Dumping data for table `truck_profitpermile`
535--
536
537INSERT INTO `truck_profitpermile` VALUES (2, 1, '2435', '2435', 12, 1108011600, -1, 1008003600, 400, 400, 800, '', '5', '41', 'sam', 1254, '1254', '1254', 'samxdfdfsdfsf', 0.00, 0.00, 0.000, 0.00, NULL, NULL, 0, 4);
538INSERT INTO `truck_profitpermile` VALUES (3, 2, '-', '', 1111, 1128229200, 989070720, 1002879720, 0, 0, 0, '', '', '', '', 0, '', '', '', 0.00, 0.00, 0.000, 0.00, NULL, NULL, 0, 4);
539INSERT INTO `truck_profitpermile` VALUES (4, 8, '-', '', 1254, -1, -1, -1, 0, 0, 0, 'called_in', '1', '1215', 'sdfsdf', 147, 'sdfsd', 'sdfs', 'sdfsdfsf', 0.00, 0.00, 0.000, 0.00, NULL, NULL, 0, 4);
540INSERT INTO `truck_profitpermile` VALUES (5, 1, '2435', '2435', 15, 1133931600, 60973200, 48186000, 547, 4557, 5104, 'Delivered', '525', '02', 'mamu', 4587, 'sdfsdfg', 'sdfdsfsf', 'tretertretetet', 9787.00, 86000.00, 16.850, 500.00, '', 'Yes', -1, 4);
541INSERT INTO `truck_profitpermile` VALUES (6, 1, '2435', '2435', 2588, 1107320400, 48153480, 48153480, 258, 258, 516, 'loded', '587', NULL, 'eeetettetetertrtrtrtttreertereererrerer', 546565, 'sdfsf', 'sff577', 'sdfsfsfsfsfsfsfsdf', 0.00, 0.00, 0.000, 0.00, 'Net 30', '', -1, 4);
542INSERT INTO `truck_profitpermile` VALUES (7, 1, '32', '2435', 45, 1107320400, 1134372780, 1129098720, 23645, 6584, 30229, 'called_in', '25', NULL, 'ygaysguyg', 2568, '64jgy', '64kuguo', 'ieieieieieieiei', 450.00, 117936.00, 3.901, 0.00, NULL, NULL, 0, 4);
543INSERT INTO `truck_profitpermile` VALUES (8, 1, '-', '', 0, 1108011600, 48167940, 1007980380, 0, 0, 0, '', '', NULL, '', 0, '', '', '', 0.00, 0.00, 0.000, 0.00, NULL, NULL, 0, 4);
544INSERT INTO `truck_profitpermile` VALUES (9, 1, '45', '12', 45, 1107320400, 1134372720, 336061380, 0, 0, 0, '', '', NULL, 'drtertertertert', 0, '', '', '', 0.00, 0.00, 0.000, 0.00, NULL, NULL, 0, 4);