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