N981PdGx

1/*
2Navicat MySQL Data Transfer
3
4Source Server         : SANDBOX FA
5Source Server Version : 50154
6Source Host           : freightaccess.com:3306
7Source Database       : sandbox_main
8
9Target Server Type    : MYSQL
10Target Server Version : 50154
11File Encoding         : 65001
12
13Date: 2011-03-17 22:20:53
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17-- ----------------------------
18-- Table structure for `lnk_pricing_policies_accessorials`
19-- ----------------------------
20DROP TABLE IF EXISTS `lnk_pricing_policies_accessorials`;
21CREATE TABLE `lnk_pricing_policies_accessorials` (
22  `id` int(11) NOT NULL AUTO_INCREMENT,
23  `uid` int(11) DEFAULT NULL,
24  `cid` int(11) DEFAULT NULL,
25  `policy_id` int(11) DEFAULT NULL,
26  `accessorials_id` int(11) DEFAULT NULL,
27  PRIMARY KEY (`id`)
28) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
29
30-- ----------------------------
31-- Records of lnk_pricing_policies_accessorials
32-- ----------------------------
33INSERT INTO `lnk_pricing_policies_accessorials` VALUES ('1', '3', '3', '1', '2');
34INSERT INTO `lnk_pricing_policies_accessorials` VALUES ('2', '3', '3', '1', '1');
35
36-- ----------------------------
37-- Table structure for `lnk_pricing_policies_account_types`
38-- ----------------------------
39DROP TABLE IF EXISTS `lnk_pricing_policies_account_types`;
40CREATE TABLE `lnk_pricing_policies_account_types` (
41  `id` int(11) NOT NULL AUTO_INCREMENT,
42  `uid` int(11) DEFAULT NULL,
43  `cid` int(11) DEFAULT NULL,
44  `policy_id` int(11) DEFAULT NULL,
45  `account_types_id` int(11) DEFAULT NULL,
46  PRIMARY KEY (`id`)
47) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
48
49-- ----------------------------
50-- Records of lnk_pricing_policies_account_types
51-- ----------------------------
52INSERT INTO `lnk_pricing_policies_account_types` VALUES ('1', '3', '3', '1', '1');
53INSERT INTO `lnk_pricing_policies_account_types` VALUES ('2', '3', '3', '1', '2');
54INSERT INTO `lnk_pricing_policies_account_types` VALUES ('3', '3', '3', '1', '3');
55
56-- ----------------------------
57-- Table structure for `lnk_pricing_policies_company_trucks`
58-- ----------------------------
59DROP TABLE IF EXISTS `lnk_pricing_policies_company_trucks`;
60CREATE TABLE `lnk_pricing_policies_company_trucks` (
61  `id` int(11) NOT NULL AUTO_INCREMENT,
62  `company_trucks_id` int(11) DEFAULT NULL,
63  PRIMARY KEY (`id`)
64) ENGINE=MyISAM DEFAULT CHARSET=latin1;
65
66-- ----------------------------
67-- Records of lnk_pricing_policies_company_trucks
68-- ----------------------------
69
70-- ----------------------------
71-- Table structure for `lnk_pricing_policies_equipment`
72-- ----------------------------
73DROP TABLE IF EXISTS `lnk_pricing_policies_equipment`;
74CREATE TABLE `lnk_pricing_policies_equipment` (
75  `id` int(11) NOT NULL AUTO_INCREMENT,
76  `uid` int(11) DEFAULT NULL,
77  `cid` int(11) DEFAULT NULL,
78  `policy_id` int(11) DEFAULT NULL,
79  `equipment_id` int(11) DEFAULT NULL,
80  PRIMARY KEY (`id`)
81) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
82
83-- ----------------------------
84-- Records of lnk_pricing_policies_equipment
85-- ----------------------------
86INSERT INTO `lnk_pricing_policies_equipment` VALUES ('1', '3', '3', '1', '6');
87
88-- ----------------------------
89-- Table structure for `lnk_pricing_policies_rules`
90-- ----------------------------
91DROP TABLE IF EXISTS `lnk_pricing_policies_rules`;
92CREATE TABLE `lnk_pricing_policies_rules` (
93  `id` int(11) NOT NULL AUTO_INCREMENT,
94  `uid` int(11) DEFAULT NULL,
95  `cid` int(11) DEFAULT NULL,
96  `policy_id` int(11) DEFAULT NULL,
97  `rules_id` int(11) DEFAULT NULL,
98  PRIMARY KEY (`id`)
99) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=latin1;
100
101-- ----------------------------
102-- Records of lnk_pricing_policies_rules
103-- ----------------------------
104INSERT INTO `lnk_pricing_policies_rules` VALUES ('1', '3', '3', '1', '1');
105
106-- ----------------------------
107-- Table structure for `lnk_pricing_policies_shipment_types`
108-- ----------------------------
109DROP TABLE IF EXISTS `lnk_pricing_policies_shipment_types`;
110CREATE TABLE `lnk_pricing_policies_shipment_types` (
111  `id` int(11) NOT NULL AUTO_INCREMENT,
112  `uid` int(11) DEFAULT NULL,
113  `cid` int(11) DEFAULT NULL,
114  `policy_id` int(11) DEFAULT NULL,
115  `shipment_types_id` int(11) DEFAULT NULL,
116  PRIMARY KEY (`id`)
117) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
118
119-- ----------------------------
120-- Records of lnk_pricing_policies_shipment_types
121-- ----------------------------
122INSERT INTO `lnk_pricing_policies_shipment_types` VALUES ('1', '3', '3', '1', '2');
123
124-- ----------------------------
125-- Table structure for `pricing_policies`
126-- ----------------------------
127DROP TABLE IF EXISTS `pricing_policies`;
128CREATE TABLE `pricing_policies` (
129  `id` int(11) NOT NULL AUTO_INCREMENT,
130  `uid` int(11) DEFAULT NULL,
131  `cid` int(11) DEFAULT NULL,
132  `name` varchar(55) DEFAULT NULL,
133  `lnk_rules_id` int(11) DEFAULT NULL,
134  `lnk_shipment_types_id` int(11) DEFAULT NULL,
135  `lnk_account_types_id` int(11) DEFAULT NULL,
136  `lnk_trucks_id` int(11) DEFAULT NULL,
137  `lnk_equipment_id` int(11) DEFAULT NULL,
138  `lnk_accessorials_id` int(11) DEFAULT NULL,
139  `weight_limit_start` float DEFAULT NULL,
140  `weight_limit_end` float DEFAULT NULL,
141  `length_limit_start` float DEFAULT NULL,
142  `length_limit_end` float DEFAULT NULL,
143  `flag` tinyint(4) DEFAULT NULL,
144  PRIMARY KEY (`id`)
145) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
146
147-- ----------------------------
148-- Records of pricing_policies
149-- ----------------------------
150INSERT INTO `pricing_policies` VALUES ('1', '3', '3', 'MY Policy Name', '1', '1', '1', '1', '1', '1', '20', '60', '2', '35', '1');
151
152-- ----------------------------
153-- Table structure for `pricing_rules`
154-- ----------------------------
155DROP TABLE IF EXISTS `pricing_rules`;
156CREATE TABLE `pricing_rules` (
157  `id` int(11) NOT NULL AUTO_INCREMENT,
158  `uid` int(11) DEFAULT NULL,
159  `cid` int(11) DEFAULT NULL,
160  `policy_id` int(11) DEFAULT NULL,
161  `method` tinyint(4) DEFAULT NULL,
162  `pickup_zip_range_start` varchar(15) DEFAULT NULL,
163  `pickup_zip_range_end` varchar(15) DEFAULT NULL,
164  `delivery_zip_range_start` varchar(15) DEFAULT NULL,
165  `delivery_zip_range_end` varchar(15) DEFAULT NULL,
166  `pickup_location` varchar(75) DEFAULT NULL,
167  `pickup_radius` tinyint(4) DEFAULT NULL,
168  `delivery_location` varchar(75) DEFAULT NULL,
169  `delivery_radius` tinyint(4) DEFAULT NULL,
170  `pickup_states` varchar(300) DEFAULT NULL,
171  `delivery_states` varchar(300) DEFAULT NULL,
172  `flag` tinyint(4) DEFAULT NULL,
173  PRIMARY KEY (`id`)
174) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
175
176-- ----------------------------
177-- Records of pricing_rules
178-- ----------------------------
179INSERT INTO `pricing_rules` VALUES ('1', '3', '3', '1', '1', '49548', '49600', '12345', '54321', null, null, null, null, null, null, '1');