106 lines
3.9 KiB
PHP
106 lines
3.9 KiB
PHP
<?php
|
|
|
|
$sql = array();
|
|
|
|
$sql[] = 'CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'inpostship` (
|
|
`id_pack` int(11) NOT NULL AUTO_INCREMENT,
|
|
`id_order` int(11),
|
|
`sendtype` varchar(20),
|
|
`status` varchar(30),
|
|
`status_date` datetime,
|
|
`packcode` varchar(30),
|
|
`offer_id` int(16),
|
|
`receiver_email` varchar(255),
|
|
`receiver_mobile` varchar(255),
|
|
`receiver_machine` char(10),
|
|
`packtype` varchar(10),
|
|
`sizes` varchar(11),
|
|
`reference_number` varchar(40),
|
|
`insurance` double,
|
|
`executes` tinyint(1),
|
|
`cod` tinyint(1),
|
|
`cod_value` double,
|
|
`dispatch_id` int(11),
|
|
`statue` varchar(255),
|
|
`date_add` datetime,
|
|
`date_upd` datetime,
|
|
PRIMARY KEY (`id_pack`)
|
|
) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=UTF8;';
|
|
|
|
$sql[] = 'CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'inpostship_cart` (
|
|
`id_cart` int(11) NOT NULL,
|
|
`id_carrier` int(11) NOT NULL,
|
|
`send_type` tinyint(1),
|
|
`receiver_machine` char(10),
|
|
`receiver_machine_cod` char(10),
|
|
`cod` tinyint(1),
|
|
`week` tinyint(1),
|
|
`created` tinyint(1),
|
|
`date_add` datetime,
|
|
`date_upd` datetime,
|
|
PRIMARY KEY (`id_cart`)
|
|
) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=UTF8;';
|
|
|
|
$sql[] = 'CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'inpostship_customer` (
|
|
`id_customer_point` int(11) NOT NULL AUTO_INCREMENT,
|
|
`point_code` char(10),
|
|
`id_customer` int(11),
|
|
`date_add` datetime,
|
|
`date_upd` datetime,
|
|
PRIMARY KEY (`id_customer_point`)
|
|
) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=UTF8;';
|
|
|
|
$sql[] = 'CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'inpostship_points` (
|
|
`id_point` int(11) NOT NULL AUTO_INCREMENT,
|
|
`point_code` varchar(255),
|
|
`point_address1` varchar(255),
|
|
`point_address2` varchar(255),
|
|
`point_lat` varchar(255),
|
|
`point_lng` varchar(255),
|
|
`point_desc` varchar(255),
|
|
`point_payment` tinyint(1),
|
|
`point_cod` int(11),
|
|
`point_type` varchar(100),
|
|
PRIMARY KEY (`id_point`)
|
|
) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=UTF8;
|
|
';
|
|
|
|
$sql[] = 'CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'inpostship_points_pop` (
|
|
`id_point` int(11) NOT NULL AUTO_INCREMENT,
|
|
`point_code` varchar(255),
|
|
`point_address1` varchar(255),
|
|
`point_address2` varchar(255),
|
|
`point_lat` varchar(255),
|
|
`point_lng` varchar(255),
|
|
`point_desc` varchar(255),
|
|
`point_payment` tinyint(1),
|
|
`point_cod` int(11),
|
|
`point_type` varchar(100),
|
|
PRIMARY KEY (`id_point`)
|
|
) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=UTF8;';
|
|
|
|
$sql[] = 'CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'inpostship_pack_state` (
|
|
`id_state` int(11) NOT NULL AUTO_INCREMENT,
|
|
`id_pack` int(11),
|
|
`state` varchar(255),
|
|
`state_id` int(11),
|
|
`date_state` datetime,
|
|
`date_add` datetime,
|
|
PRIMARY KEY (`id_state`)
|
|
) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=UTF8;';
|
|
|
|
$sql[] = 'CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.'inpostship_user_point` (
|
|
`id_user_point` int(11) NOT NULL AUTO_INCREMENT,
|
|
`id_customer` int(11),
|
|
`point` varchar(10),
|
|
`date_add` datetime,
|
|
`date_upd` datetime,
|
|
PRIMARY KEY (`id_user_point`)
|
|
) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=UTF8;';
|
|
|
|
foreach ($sql as $query) {
|
|
if (Db::getInstance()->execute($query) == false) {
|
|
return false;
|
|
}
|
|
}
|