trucks :-(

CREATE SCHEMA `lhubbar4_truck`;
USE `lhubbar4_truck`;
-- phpMyAdmin SQL Dump
-- version 2.6.3-pl1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 17, 2005 at 09:59 AM
-- Server version: 4.0.25
-- PHP Version: 4.3.11
--
-- Database: `lhubbar4_truck`
--

-- --------------------------------------------------------

--
-- Table structure for table `addressbook`
--

DROP TABLE IF EXISTS `addressbook`;
CREATE TABLE `addressbook` (
  `company_id` int(11) NOT NULL auto_increment,
  `id` int(11) default '0',
  `info_id` varchar(20) default '0',
  `fname` varchar(25) default '0',
  `mlname` varchar(25) default '0',
  `lname` varchar(25) default '0',
  `address` varchar(45) default '0',
  `company_name` varchar(25) default '0',
  `city` varchar(25) default '0',
  `businesshour` varchar(25) default '0',
  `from_show` varchar(45) default '0',
  `state` varchar(25) default '0',
  `zip` varchar(25) default '0',
  `email` varchar(25) default '0',
  `workpone` varchar(25) default '0',
  `phone` varchar(25) default '0',
  `fax` varchar(25) default '0',
  `website` varchar(25) default '0',
  `home` varchar(25) default '0',
  `from` varchar(45) default '0',
  `category` varchar(23) default '0',
  `bday` varchar(23) default '0',
  `aday` varchar(23) default '0',
  `wname` varchar(45) default '0',
  `truck_no` varchar(23) default '0',
  `drivlinc` varchar(45) default '0',
  `dthired` varchar(23) default '0',
  `dtterm` varchar(23) default '0',
  `diexp` varchar(24) default '0',
  `createdt` varchar(23) default '0',
  `modifydt` varchar(23) default '0',
  `terms` varchar(45) default '0',
  `ss` varchar(25) default '0',
  `notes` longtext,
  `direction` longtext,
  PRIMARY KEY  (`company_id`)
) ENGINE = MYISAM AUTO_INCREMENT=66 ;

--
-- Dumping data for table `addressbook`
--

INSERT 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');
INSERT 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');
INSERT 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);
INSERT 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);
INSERT 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);
INSERT 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);
INSERT 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);
INSERT 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);

-- --------------------------------------------------------

--
-- Table structure for table `category`
--

DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
  `cat_id` int(11) NOT NULL auto_increment,
  `c_name` varchar(24) default '0',
  PRIMARY KEY  (`cat_id`)
) ENGINE = MYISAM AUTO_INCREMENT=60 ;

--
-- Dumping data for table `category`
--

INSERT INTO `category` VALUES (1, 'shipper');
INSERT INTO `category` VALUES (2, 'broker');
INSERT INTO `category` VALUES (45, 'recevier');
INSERT INTO `category` VALUES (46, 'customer');
INSERT INTO `category` VALUES (54, 'raghu');
INSERT INTO `category` VALUES (59, 'expoter');

-- --------------------------------------------------------

--
-- Table structure for table `expense`
--

DROP TABLE IF EXISTS `expense`;
CREATE TABLE `expense` (
  `exp_id` int(10) NOT NULL auto_increment,
  `profit_id` varchar(10) default NULL,
  `id` int(10) NOT NULL default '0',
  `ex_date` int(11) NOT NULL default '0',
  `ex_payee` varchar(30) default NULL,
  `ex_category` varchar(30) default NULL,
  `ex_des` varchar(200) default NULL,
  `ex_exp` float(10,2) NOT NULL default '0.00',
  `ex_hour` float(4,2) NOT NULL default '0.00',
  PRIMARY KEY  (`exp_id`)
) ENGINE = MYISAM AUTO_INCREMENT=21 ;

--
-- Dumping data for table `expense`
--

INSERT INTO `expense` VALUES (14, '7', 3, 1008133200, 'samik', 'Unloading Pay', 'aqdqwd', 250.00, 5.00);
INSERT INTO `expense` VALUES (16, '7', 3, 1129093200, 'samik', 'Fuel', 'aqdqwd', 250.00, 5.00);
INSERT INTO `expense` VALUES (12, '7', 1, 989035200, 'ewwe', 'Unloading Pay', 'dddd', 450.00, 0.00);
INSERT INTO `expense` VALUES (17, '4', 1, -14462, 'samik cha', 'Insurance', 'sasadfsfsf', 5000.00, 4.25);
INSERT INTO `expense` VALUES (18, '5', 1, 1104469200, 'sss', 'Oil', 'arawrawew', 200.00, 5.00);
INSERT INTO `expense` VALUES (19, '5', 1, 347086800, 'frt', 'Oil', 'regerte', 4587.00, 4.25);
INSERT INTO `expense` VALUES (20, '5', 1, 976597200, 'wefrwer', 'Tolls', 'ewrwer', 5000.00, 0.00);

-- --------------------------------------------------------

--
-- Table structure for table `income`
--

DROP TABLE IF EXISTS `income`;
CREATE TABLE `income` (
  `exp_id` int(10) NOT NULL auto_increment,
  `profit_id` varchar(10) default NULL,
  `id` int(10) NOT NULL default '0',
  `ex_date` int(11) NOT NULL default '0',
  `ex_payee` varchar(30) default NULL,
  `ex_category` varchar(30) default NULL,
  `income` float(10,2) NOT NULL default '0.00',
  `ex_des` varchar(200) default NULL,
  PRIMARY KEY  (`exp_id`)
) ENGINE = MYISAM AUTO_INCREMENT=8 ;

--
-- Dumping data for table `income`
--

INSERT INTO `income` VALUES (1, '7', 1, 1, 'sam', 'Unloading Pay', 58968.00, 'fghfghfh');
INSERT INTO `income` VALUES (2, '7', 1, 1, 'sam', 'Unloading Pay', 58968.00, 'fghfghfh');
INSERT INTO `income` VALUES (3, '4', 1, -14462, 'sasdas', 'Repairs', 4000.00, 'awdasdadad');
INSERT INTO `income` VALUES (4, '5', 1, 10, 'sam', 'Advance', 500.00, 'ewrwrwrwrwrwr');
INSERT INTO `income` VALUES (5, '5', 1, 2, 'sai', 'Truck Payment', 5000.00, 'strewtreterte');
INSERT INTO `income` VALUES (6, '5', 1, 10, 'fdsf', 'Tires', 500.00, 'sdfdsfsf');
INSERT INTO `income` VALUES (7, '5', 1, 978325200, 'awerwqer', 'Fuel', 80000.00, 'ewrwer');

-- --------------------------------------------------------

--
-- Table structure for table `regions`
--

DROP TABLE IF EXISTS `regions`;
CREATE TABLE `regions` (
  `region_id` int(11) NOT NULL auto_increment,
  `region` text,
  PRIMARY KEY  (`region_id`)
) ENGINE = MYISAM AUTO_INCREMENT=108 ;

--
-- Dumping data for table `regions`
--

INSERT INTO `regions` VALUES (1, 'Alabama');
INSERT INTO `regions` VALUES (2, 'Alaska');
INSERT INTO `regions` VALUES (3, 'Arizona');
INSERT INTO `regions` VALUES (4, 'Arkansas');
INSERT INTO `regions` VALUES (5, 'California');
INSERT INTO `regions` VALUES (6, 'Colorado');
INSERT INTO `regions` VALUES (7, 'Connecticut');
INSERT INTO `regions` VALUES (8, 'Delaware');
INSERT INTO `regions` VALUES (9, 'Washington');
INSERT INTO `regions` VALUES (10, 'Florida');
INSERT INTO `regions` VALUES (11, 'Georgia');
INSERT INTO `regions` VALUES (12, 'Hawaii');
INSERT INTO `regions` VALUES (13, 'Idaho');
INSERT INTO `regions` VALUES (14, 'Illinois');
INSERT INTO `regions` VALUES (15, 'Indiana');
INSERT INTO `regions` VALUES (16, 'Iowa');
INSERT INTO `regions` VALUES (17, 'Kansas');
INSERT INTO `regions` VALUES (18, 'Kentucky');
INSERT INTO `regions` VALUES (19, 'Louisiana');
INSERT INTO `regions` VALUES (20, 'Maine');
INSERT INTO `regions` VALUES (21, 'Maryland');
INSERT INTO `regions` VALUES (22, 'Massachusetts');
INSERT INTO `regions` VALUES (23, 'Michigan');
INSERT INTO `regions` VALUES (24, 'Minnesota');
INSERT INTO `regions` VALUES (25, 'Mississippi');
INSERT INTO `regions` VALUES (26, 'Missouri');
INSERT INTO `regions` VALUES (27, 'Montana');
INSERT INTO `regions` VALUES (28, 'Nebraska');
INSERT INTO `regions` VALUES (29, 'Nevada');
INSERT INTO `regions` VALUES (30, 'New Hampshire');
INSERT INTO `regions` VALUES (31, 'New Jersey');
INSERT INTO `regions` VALUES (32, 'New Mexico');
INSERT INTO `regions` VALUES (33, 'New York');
INSERT INTO `regions` VALUES (34, 'North Carolina');
INSERT INTO `regions` VALUES (35, 'North Dakota');
INSERT INTO `regions` VALUES (36, 'Ohio');
INSERT INTO `regions` VALUES (37, 'Oklahoma');
INSERT INTO `regions` VALUES (38, 'Oregon');
INSERT INTO `regions` VALUES (39, 'Pennsylvania');
INSERT INTO `regions` VALUES (40, 'Rhode Island');
INSERT INTO `regions` VALUES (41, 'South Carolina');
INSERT INTO `regions` VALUES (42, 'South Dakota');
INSERT INTO `regions` VALUES (43, 'Tennessee');
INSERT INTO `regions` VALUES (44, 'Texas');
INSERT INTO `regions` VALUES (45, 'Utah');
INSERT INTO `regions` VALUES (46, 'Vermont');
INSERT INTO `regions` VALUES (47, 'Virginia');
INSERT INTO `regions` VALUES (48, 'Washington');
INSERT INTO `regions` VALUES (49, 'West Virginia');
INSERT INTO `regions` VALUES (50, 'Wisconsin');
INSERT INTO `regions` VALUES (51, 'Wyoming');
INSERT INTO `regions` VALUES (52, 'Ontario');
INSERT INTO `regions` VALUES (53, 'Alberta');
INSERT INTO `regions` VALUES (54, 'Prince Edward');
INSERT INTO `regions` VALUES (55, 'Newfoundland');
INSERT INTO `regions` VALUES (56, 'British Columbia');
INSERT INTO `regions` VALUES (57, 'Nunavut');
INSERT INTO `regions` VALUES (58, 'Manitoba');
INSERT INTO `regions` VALUES (59, 'Nova Scotia');
INSERT INTO `regions` VALUES (60, 'New Brunswick');
INSERT INTO `regions` VALUES (61, 'Saskatchewan');
INSERT INTO `regions` VALUES (62, 'Quebec');
INSERT INTO `regions` VALUES (63, 'Yukon');
INSERT INTO `regions` VALUES (64, 'Home Counties');
INSERT INTO `regions` VALUES (65, 'London');
INSERT INTO `regions` VALUES (66, 'Midlands');
INSERT INTO `regions` VALUES (67, 'Northeast');
INSERT INTO `regions` VALUES (68, 'Northern Ireland');
INSERT INTO `regions` VALUES (69, 'Northwest');
INSERT INTO `regions` VALUES (70, 'Scotland');
INSERT INTO `regions` VALUES (71, 'Southwest');
INSERT INTO `regions` VALUES (72, 'Wales');
INSERT INTO `regions` VALUES (73, 'Australian Capital Territory');
INSERT INTO `regions` VALUES (74, 'New South Wales');
INSERT INTO `regions` VALUES (75, 'Northern \r\n                          Territory');
INSERT INTO `regions` VALUES (76, 'Queensland');
INSERT INTO `regions` VALUES (77, 'South Australia');
INSERT INTO `regions` VALUES (78, 'Tasmania');
INSERT INTO `regions` VALUES (79, 'Vctoria');
INSERT INTO `regions` VALUES (80, 'Western Australia');
INSERT INTO `regions` VALUES (81, 'Guernsey');
INSERT INTO `regions` VALUES (82, 'Isle Of Man');
INSERT INTO `regions` VALUES (83, 'Jersey');
INSERT INTO `regions` VALUES (84, 'Shetland');
INSERT INTO `regions` VALUES (85, 'Central And \r\n                          Western');
INSERT INTO `regions` VALUES (86, 'Eastern');
INSERT INTO `regions` VALUES (87, 'Islands');
INSERT INTO `regions` VALUES (88, 'Kowloon City');
INSERT INTO `regions` VALUES (89, 'Kwai Tsing');
INSERT INTO `regions` VALUES (90, 'Kwun Tong');
INSERT INTO `regions` VALUES (91, 'North');
INSERT INTO `regions` VALUES (92, 'Sai Kung');
INSERT INTO `regions` VALUES (93, 'Sha Tin');
INSERT INTO `regions` VALUES (94, 'Sham Shui Po');
INSERT INTO `regions` VALUES (95, 'Southern');
INSERT INTO `regions` VALUES (96, 'Tai Po');
INSERT INTO `regions` VALUES (97, 'Tsuen Wan');
INSERT INTO `regions` VALUES (98, 'Tuen Mun');
INSERT INTO `regions` VALUES (99, 'Wan Chai');
INSERT INTO `regions` VALUES (100, 'Wong Tai Sin');
INSERT INTO `regions` VALUES (101, 'Yau Tsim Mong');
INSERT INTO `regions` VALUES (102, 'Yuen Long');
INSERT INTO `regions` VALUES (103, 'East');
INSERT INTO `regions` VALUES (104, 'North');
INSERT INTO `regions` VALUES (105, 'South');
INSERT INTO `regions` VALUES (106, 'West');
INSERT INTO `regions` VALUES (107, 'Victoria');

-- --------------------------------------------------------

--
-- Table structure for table `state`
--

DROP TABLE IF EXISTS `state`;
CREATE TABLE `state` (
  `id` int(11) NOT NULL auto_increment,
  `s_name` varchar(25) default NULL,
  `statefueltax` varchar(45) default '0',
  `sur_fuel_tax` varchar(45) default '0',
  PRIMARY KEY  (`id`)
) ENGINE = MYISAM AUTO_INCREMENT=79 ;

--
-- Dumping data for table `state`
--

INSERT INTO `state` VALUES (1, 'Alabama', '0', '0');
INSERT INTO `state` VALUES (2, 'Alaska', '0', '0');
INSERT INTO `state` VALUES (3, 'Alberta', '0', '0');
INSERT INTO `state` VALUES (4, 'American Samoa', '0', '0');
INSERT INTO `state` VALUES (5, 'AriZona', '0', '0');
INSERT INTO `state` VALUES (6, 'Arkansas', '0', '0');
INSERT INTO `state` VALUES (7, 'Armed Forces Americas', '0', '0');
INSERT INTO `state` VALUES (8, 'Armed Forces Europe', '0', '0');
INSERT INTO `state` VALUES (9, 'Armed Forces Pacific', '0', '0');
INSERT INTO `state` VALUES (10, 'British Columbia', '0', '0');
INSERT INTO `state` VALUES (11, 'California', '0', '0');
INSERT INTO `state` VALUES (12, 'Canada', '0', '0');
INSERT INTO `state` VALUES (13, 'Colorado', '0', '0');
INSERT INTO `state` VALUES (14, 'Connecticut', '0', '0');
INSERT INTO `state` VALUES (15, 'Delaware', '0', '0');
INSERT INTO `state` VALUES (16, 'District of Columbia', '0', '0');
INSERT INTO `state` VALUES (17, 'Florida', '0', '0');
INSERT INTO `state` VALUES (18, 'Georgia', '0', '0');
INSERT INTO `state` VALUES (19, 'Guam', '0', '0');
INSERT INTO `state` VALUES (20, 'Hawaii', '0', '0');
INSERT INTO `state` VALUES (21, 'Idaho', '0', '0');
INSERT INTO `state` VALUES (22, 'Illinois', '0', '0');
INSERT INTO `state` VALUES (23, 'Indiana', '0', '0');
INSERT INTO `state` VALUES (24, 'Iowa', '0', '0');
INSERT INTO `state` VALUES (25, 'Kansas', '0', '0');
INSERT INTO `state` VALUES (26, 'Kentucky', '0', '0');
INSERT INTO `state` VALUES (27, 'Louisiana', '0', '0');
INSERT INTO `state` VALUES (28, 'Maine', '0', '0');
INSERT INTO `state` VALUES (29, 'Manitoba', '0', '0');
INSERT INTO `state` VALUES (30, 'Maryland', '0', '0');
INSERT INTO `state` VALUES (31, 'Massachusetts', '0', '0');
INSERT INTO `state` VALUES (32, 'Michigan', '0', '0');
INSERT INTO `state` VALUES (33, 'Minnesota', '0', '0');
INSERT INTO `state` VALUES (34, 'Mississippi', '0', '0');
INSERT INTO `state` VALUES (35, 'Missouri', '0', '0');
INSERT INTO `state` VALUES (36, 'Montana', '0', '0');
INSERT INTO `state` VALUES (37, 'Nebraska', '0', '0');
INSERT INTO `state` VALUES (38, 'Nevada', '0', '0');
INSERT INTO `state` VALUES (39, 'New HampShire', '0', '0');
INSERT INTO `state` VALUES (40, 'New Jersey', '0', '0');
INSERT INTO `state` VALUES (41, 'New Mexico', '0', '0');
INSERT INTO `state` VALUES (42, 'New York', '0', '0');
INSERT INTO `state` VALUES (43, 'Newfoundland', '0', '0');
INSERT INTO `state` VALUES (44, 'North Carolina', '0', '0');
INSERT INTO `state` VALUES (45, 'North Dakota', '0', '0');
INSERT INTO `state` VALUES (46, 'Northern Mariana Is', '0', '0');
INSERT INTO `state` VALUES (47, 'Northwest Territories', '0', '0');
INSERT INTO `state` VALUES (48, 'Nova Scotia', '0', '0');
INSERT INTO `state` VALUES (49, 'Ohio', '0', '0');
INSERT INTO `state` VALUES (50, 'Oklahoma', '0', '0');
INSERT INTO `state` VALUES (51, 'Ontario', '0', '0');
INSERT INTO `state` VALUES (52, 'Oregon', '0', '0');
INSERT INTO `state` VALUES (53, 'Palau', '0', '0');
INSERT INTO `state` VALUES (54, 'Pennsylvania', '0', '0');
INSERT INTO `state` VALUES (55, 'Prince Edward Island', '0', '0');
INSERT INTO `state` VALUES (56, 'Province du Quebec', '0', '0');
INSERT INTO `state` VALUES (57, 'Puerto Rico', '0', '0');
INSERT INTO `state` VALUES (58, 'Rhode Island', '0', '0');
INSERT INTO `state` VALUES (59, 'Saskatchewan', '0', '0');
INSERT INTO `state` VALUES (60, 'South Carolina', '0', '0');
INSERT INTO `state` VALUES (61, 'South Dakota', '0', '0');
INSERT INTO `state` VALUES (62, 'Tennessee', '0', '0');
INSERT INTO `state` VALUES (63, 'Texas', '0', '0');
INSERT INTO `state` VALUES (64, 'Utah', '0', '0');
INSERT INTO `state` VALUES (65, 'Vermont', '0', '0');
INSERT INTO `state` VALUES (66, 'Virgin Islands', '0', '0');
INSERT INTO `state` VALUES (67, 'Virginia', '0', '0');
INSERT INTO `state` VALUES (68, 'Washington', '0', '0');
INSERT INTO `state` VALUES (69, 'West Virginia', '0', '0');
INSERT INTO `state` VALUES (70, 'Wisconsin', '0', '0');
INSERT INTO `state` VALUES (71, 'Wyoming', '0', '0');
INSERT INTO `state` VALUES (72, 'Yukon Territory', '0', '0');
INSERT INTO `state` VALUES (73, 'A.F. Africa', '.345', '.345');
INSERT INTO `state` VALUES (74, 'A.F. Americas', '0', '0');
INSERT INTO `state` VALUES (75, 'A.F. Canada', '0', '0');
INSERT INTO `state` VALUES (76, 'A.F. Europe', '0', '0');
INSERT INTO `state` VALUES (77, 'A.F. Middle East', '0', '0');
INSERT INTO `state` VALUES (78, 'Not Listed', '0', '0');

-- --------------------------------------------------------

--
-- Table structure for table `tripentry`
--

DROP TABLE IF EXISTS `tripentry`;
CREATE TABLE `tripentry` (
  `trip_id` int(11) NOT NULL auto_increment,
  `id` int(11) default '0',
  `truck_no` int(15) default '0',
  `invoice_no` int(20) default '0',
  `company_name` varchar(45) default NULL,
  `roadtravelled` varchar(20) default NULL,
  `beginingmileage` varchar(22) default '0',
  `endingmileage` varchar(22) default '0',
  `milesstate` varchar(22) default '0',
  `nontaxmiles` varchar(22) default '0',
  `totalmiles` varchar(22) default '0',
  `gallonpurchased` varchar(22) default '0',
  `fuelcost` varchar(22) default '0',
  `costpergallon` varchar(22) default '0',
  `city` varchar(25) default NULL,
  `dt` int(15) default '0',
  `state` varchar(23) NOT NULL default '',
  `fuelstop` varchar(45) default '0',
  PRIMARY KEY  (`trip_id`)
) ENGINE = MYISAM AUTO_INCREMENT=134 ;

--
-- Dumping data for table `tripentry`
--

INSERT INTO `tripentry` VALUES (127, 1, 15, 213214, 'ezone', 'dfdsfg', '43434', '354325435', '', '', '354368869', '34532', '46', '750.69565217391', 'MUMBAI', 1129380358, 'AriZona', '2435');
INSERT INTO `tripentry` VALUES (129, 1, 1111, 234343, 'ezone', 'dfdsfg', '234', '246', '', '', '480', '2334444', '23', '101497.56521739', 'kolkata', 1128603060, 'Louisiana', '2435');
INSERT INTO `tripentry` VALUES (130, 1, 11, 232324, 'ezone', 'dfdsf', '22323', '2334', '44444', '444', '44888', '2132134', '3434', '620.88934187536', 'kolkata', 1128691680, 'Manitoba', '2435');
INSERT INTO `tripentry` VALUES (131, 1, 11, 13242314, 'ezone', 'asddcsafcd', '245', '23', '', '', '268', '2345', '34', '68.970588235294', 'kolkata', 1128877680, 'Alabama', '2435');
INSERT INTO `tripentry` VALUES (132, 1, 1111, 43435, 'ezone', 'efwerfwe', '2345', '3456', '', '30', '1141', '2345', '34', '68.970588235294', 'kolkata', 1128535920, 'Florida', '2435');
INSERT INTO `tripentry` VALUES (133, 1, 15, 5154, 'asdasd', 'rtyrtyrtyry', '1457', '22222', '', '', '20765', '4587', '40', '114.675', '242', 1130230860, 'Illinois', '1');

-- --------------------------------------------------------

--
-- Table structure for table `truck_adminj`
--

DROP TABLE IF EXISTS `truck_adminj`;
CREATE TABLE `truck_adminj` (
  `id` int(10) NOT NULL auto_increment,
  `name` varchar(20) default NULL,
  `password` varchar(20) default NULL,
  `fname` varchar(30) default NULL,
  `lname` varchar(30) default NULL,
  `company` varchar(30) default NULL,
  `address` varchar(100) default NULL,
  `city` varchar(20) default NULL,
  `state` varchar(20) default NULL,
  `zip` varchar(10) default NULL,
  `phone` varchar(10) default NULL,
  `email` varchar(50) default NULL,
  `ifta_id` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE = MYISAM AUTO_INCREMENT=9 ;

--
-- Dumping data for table `truck_adminj`
--

INSERT INTO `truck_adminj` VALUES (1, 'admin', 'admin', 'saurav', 'Ganguly', 'ezone', 'KOLKATA', 'kolkata', 'west-bengal', '700032', '86787678', 'debnath@jhghg.com', 401);
INSERT INTO `truck_adminj` VALUES (2, 'saurav', 'saurav', 'saurav sanyal', 'dddd', 'xxxxx', '                       ', '', '', '', '', '', 0);
INSERT INTO `truck_adminj` VALUES (3, 'samik', 'letmein', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `truck_adminj` VALUES (6, 'gunjan', 'gunjan', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `truck_adminj` VALUES (7, 's', 's', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0);
INSERT INTO `truck_adminj` VALUES (8, 'samikc', 'letmein', 'saikat', 'haldar', 'mem creation', 'asdasdadad', 'kolkata', '587', '1236566', '67890', 'anjay@yahoo.com', 125);

-- --------------------------------------------------------

--
-- Table structure for table `truck_details`
--

DROP TABLE IF EXISTS `truck_details`;
CREATE TABLE `truck_details` (
  `truck_id` int(10) NOT NULL auto_increment,
  `id` int(10) NOT NULL default '0',
  `truck_no` int(10) default NULL,
  `truck_driver` varchar(20) default NULL,
  `des` text,
  `truck_vin` varchar(30) default NULL,
  `truck_lic_no` varchar(30) default NULL,
  `state` varchar(30) default NULL,
  `truck_weg` int(10) NOT NULL default '0',
  `trailer_vin` varchar(30) default NULL,
  `trailer_no` varchar(30) default NULL,
  `tralier_lic_state` varchar(30) default NULL,
  `tralier_weg` int(10) NOT NULL default '0',
  `tralier_lic_no` varchar(30) default NULL,
  `total_weg` int(10) NOT NULL default '0',
  PRIMARY KEY  (`truck_id`)
) ENGINE = MYISAM AUTO_INCREMENT=24 ;

--
-- Dumping data for table `truck_details`
--

INSERT INTO `truck_details` VALUES (16, 3, 11, 'sam,', 'hy', NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, 0);
INSERT INTO `truck_details` VALUES (21, 2, 1111, 'samik', 'sam', NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, 0);
INSERT INTO `truck_details` VALUES (19, 1, 45, 'Henry', 'good', '', '', '', 0, 'drgrdgdg', 'dfgdgdgdg', '', 0, '', 0);
INSERT INTO `truck_details` VALUES (20, 1, 15, 'viru', 'tire is not good', '', '', '', 1547, '', '12547', '', 0, '', 0);
INSERT INTO `truck_details` VALUES (22, 8, 1254, 'avik', 'own truck', '', '', '', 0, '123654', 'tr10', '', 0, '', 0);
INSERT INTO `truck_details` VALUES (23, 1, 2588, 'frtyt', 'trrrr', NULL, NULL, NULL, 0, NULL, NULL, NULL, 0, NULL, 0);

-- --------------------------------------------------------

--
-- Table structure for table `truck_profitpermile`
--

DROP TABLE IF EXISTS `truck_profitpermile`;
CREATE TABLE `truck_profitpermile` (
  `profit_id` int(10) NOT NULL auto_increment,
  `id` int(10) NOT NULL default '0',
  `infoid_shiper` varchar(20) default NULL,
  `infoid_recive` varchar(20) default NULL,
  `truck_no` int(10) NOT NULL default '0',
  `trip_date` int(11) NOT NULL default '0',
  `deliver_dt` int(11) NOT NULL default '0',
  `pickup_dt` int(11) NOT NULL default '0',
  `loded_miles` int(20) NOT NULL default '0',
  `empty_miles` int(20) NOT NULL default '0',
  `trip_miles` int(25) NOT NULL default '0',
  `load_stat` varchar(15) default NULL,
  `pro_no` varchar(20) default NULL,
  `trip_no` varchar(20) default NULL,
  `load_des` text NOT NULL,
  `load_weg` int(20) NOT NULL default '0',
  `bil_lading` varchar(20) default NULL,
  `seal_no` varchar(20) default NULL,
  `notes` text NOT NULL,
  `ex_totals` float(10,2) NOT NULL default '0.00',
  `in_totals` float(10,2) NOT NULL default '0.00',
  `rev_per_mile` float(10,3) NOT NULL default '0.000',
  `advance` float(10,2) NOT NULL default '0.00',
  `term` varchar(20) default NULL,
  `claim` char(3) default NULL,
  `invoice_dt` int(11) NOT NULL default '0',
  `counter` int(10) NOT NULL default '0',
  PRIMARY KEY  (`profit_id`)
) ENGINE = MYISAM AUTO_INCREMENT=10 ;

--
-- Dumping data for table `truck_profitpermile`
--

INSERT 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);
INSERT 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);
INSERT 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);
INSERT 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);
INSERT 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);
INSERT 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);
INSERT 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);
INSERT 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);