|
Server : Apache System : Linux iZ2vcgyutqttsd1p850kl8Z 3.10.0-1160.92.1.el7.x86_64 #1 SMP Tue Jun 20 11:48:01 UTC 2023 x86_64 User : www ( 1000) PHP Version : 5.6.40 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv Directory : /www/wwwroot/saimikebio.com/widget/bfw/bdata/510/ |
<?php
define('InEmpireBakData',TRUE);
require("../../inc/header.php");
/*
SoftName : EmpireBak Version 5.1
Author : wm_chief
Copyright: Powered by www.phome.net
*/
DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `ecs_order_info`;");
E_C("CREATE TABLE `ecs_order_info` (
`order_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`order_sn` varchar(20) NOT NULL DEFAULT '',
`user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`order_status` tinyint(1) unsigned NOT NULL DEFAULT '0',
`shipping_status` tinyint(1) unsigned NOT NULL DEFAULT '0',
`pay_status` tinyint(1) unsigned NOT NULL DEFAULT '0',
`consignee` varchar(60) NOT NULL DEFAULT '',
`country` smallint(5) unsigned NOT NULL DEFAULT '0',
`province` smallint(5) unsigned NOT NULL DEFAULT '0',
`city` smallint(5) unsigned NOT NULL DEFAULT '0',
`district` smallint(5) unsigned NOT NULL DEFAULT '0',
`address` varchar(255) NOT NULL DEFAULT '',
`zipcode` varchar(60) NOT NULL DEFAULT '',
`tel` varchar(60) NOT NULL DEFAULT '',
`mobile` varchar(60) NOT NULL DEFAULT '',
`email` varchar(60) NOT NULL DEFAULT '',
`best_time` varchar(120) NOT NULL DEFAULT '',
`sign_building` varchar(120) NOT NULL DEFAULT '',
`postscript` varchar(255) NOT NULL DEFAULT '',
`shipping_id` tinyint(3) NOT NULL DEFAULT '0',
`shipping_name` varchar(120) NOT NULL DEFAULT '',
`pay_id` tinyint(3) NOT NULL DEFAULT '0',
`pay_name` varchar(120) NOT NULL DEFAULT '',
`how_oos` varchar(120) NOT NULL DEFAULT '',
`how_surplus` varchar(120) NOT NULL DEFAULT '',
`pack_name` varchar(120) NOT NULL DEFAULT '',
`card_name` varchar(120) NOT NULL DEFAULT '',
`card_message` varchar(255) NOT NULL DEFAULT '',
`inv_payee` varchar(120) NOT NULL DEFAULT '',
`inv_content` varchar(120) NOT NULL DEFAULT '',
`goods_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
`shipping_fee` decimal(10,2) NOT NULL DEFAULT '0.00',
`insure_fee` decimal(10,2) NOT NULL DEFAULT '0.00',
`pay_fee` decimal(10,2) NOT NULL DEFAULT '0.00',
`pack_fee` decimal(10,2) NOT NULL DEFAULT '0.00',
`card_fee` decimal(10,2) NOT NULL DEFAULT '0.00',
`money_paid` decimal(10,2) NOT NULL DEFAULT '0.00',
`surplus` decimal(10,2) NOT NULL DEFAULT '0.00',
`integral` int(10) unsigned NOT NULL DEFAULT '0',
`integral_money` decimal(10,2) NOT NULL DEFAULT '0.00',
`bonus` decimal(10,2) NOT NULL DEFAULT '0.00',
`order_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
`from_ad` smallint(5) NOT NULL DEFAULT '0',
`referer` varchar(255) NOT NULL DEFAULT '',
`add_time` int(10) unsigned NOT NULL DEFAULT '0',
`confirm_time` int(10) unsigned NOT NULL DEFAULT '0',
`pay_time` int(10) unsigned NOT NULL DEFAULT '0',
`shipping_time` int(10) unsigned NOT NULL DEFAULT '0',
`pack_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
`card_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
`bonus_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`invoice_no` varchar(255) NOT NULL DEFAULT '',
`extension_code` varchar(30) NOT NULL DEFAULT '',
`extension_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`to_buyer` varchar(255) NOT NULL DEFAULT '',
`pay_note` varchar(255) NOT NULL DEFAULT '',
`agency_id` smallint(5) unsigned NOT NULL,
`inv_type` varchar(60) NOT NULL,
`tax` decimal(10,2) NOT NULL,
`is_separate` tinyint(1) NOT NULL DEFAULT '0',
`parent_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
`discount` decimal(10,2) NOT NULL,
`fencheng` varchar(255) DEFAULT NULL,
`shipping_time_end` int(10) DEFAULT '0',
PRIMARY KEY (`order_id`),
UNIQUE KEY `order_sn` (`order_sn`),
KEY `user_id` (`user_id`),
KEY `order_status` (`order_status`),
KEY `shipping_status` (`shipping_status`),
KEY `pay_status` (`pay_status`),
KEY `shipping_id` (`shipping_id`),
KEY `pay_id` (`pay_id`),
KEY `extension_code` (`extension_code`,`extension_id`),
KEY `agency_id` (`agency_id`)
) ENGINE=MyISAM AUTO_INCREMENT=198 DEFAULT CHARSET=utf8");
E_D("replace into `ecs_order_info` values('174',0x3233,'0','0','0','0','','0','0','0','0','','','','','','','','','0','','4','','','','','','','','','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0','0.00','0.00','1.00','0','','0','0','0','0','0','0','0','','','0','','','0','','0.00','0','0','0.00',NULL,'0');");
E_D("replace into `ecs_order_info` values('184',0x3330,'0','0','0','0','','0','0','0','0','','','','','','','','','0','','9','','','','','','','','','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0','0.00','0.00','8000.00','0','','0','0','0','0','0','0','0','','','0','','','0','','0.00','0','0','0.00',NULL,'0');");
E_D("replace into `ecs_order_info` values('185',0x3331,'0','0','0','0','','0','0','0','0','','','','','','','','','0','','4','','','','','','','','','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0','0.00','0.00','8000.00','0','','0','0','0','0','0','0','0','','','0','','','0','','0.00','0','0','0.00',NULL,'0');");
E_D("replace into `ecs_order_info` values('187',0x3333,'0','0','0','0','','0','0','0','0','','','','','','','','','0','','9','','','','','','','','','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0','0.00','0.00','8000.00','0','','0','0','0','0','0','0','0','','','0','','','0','','0.00','0','0','0.00',NULL,'0');");
E_D("replace into `ecs_order_info` values('188',0x3334,'0','0','0','0','','0','0','0','0','','','','','','','','','0','','9','','','','','','','','','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0','0.00','0.00','8000.00','0','','0','0','0','0','0','0','0','','','0','','','0','','0.00','0','0','0.00',NULL,'0');");
E_D("replace into `ecs_order_info` values('189',0x3335,'0','0','0','0','','0','0','0','0','','','','','','','','','0','','9','','','','','','','','','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0','0.00','0.00','8000.00','0','','0','0','0','0','0','0','0','','','0','','','0','','0.00','0','0','0.00',NULL,'0');");
E_D("replace into `ecs_order_info` values('190',0x3336,'0','0','0','0','','0','0','0','0','','','','','','','','','0','','9','','','','','','','','','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0','0.00','0.00','8000.00','0','','0','0','0','0','0','0','0','','','0','','','0','','0.00','0','0','0.00',NULL,'0');");
E_D("replace into `ecs_order_info` values('191',0x3337,'0','0','0','0','','0','0','0','0','','','','','','','','','0','','9','','','','','','','','','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0','0.00','0.00','8000.00','0','','0','0','0','0','0','0','0','','','0','','','0','','0.00','0','0','0.00',NULL,'0');");
E_D("replace into `ecs_order_info` values('193',0x3339,'0','0','0','0','','0','0','0','0','','','','','','','','','0','','9','','','','','','','','','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0','0.00','0.00','8000.00','0','','0','0','0','0','0','0','0','','','0','','','0','','0.00','0','0','0.00',NULL,'0');");
E_D("replace into `ecs_order_info` values('194',0x3430,'0','0','0','0','','0','0','0','0','','','','','','','','','0','','9','','','','','','','','','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0','0.00','0.00','8000.00','0','','0','0','0','0','0','0','0','','','0','','','0','','0.00','0','0','0.00',NULL,'0');");
E_D("replace into `ecs_order_info` values('195',0x3431,'0','0','0','0','','0','0','0','0','','','','','','','','','0','','9','','','','','','','','','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0','0.00','0.00','8000.00','0','','0','0','0','0','0','0','0','','','0','','','0','','0.00','0','0','0.00',NULL,'0');");
E_D("replace into `ecs_order_info` values('196',0x3432,'0','0','0','0','','0','0','0','0','','','','','','','','','0','','9','','','','','','','','','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0','0.00','0.00','8000.00','0','','0','0','0','0','0','0','0','','','0','','','0','','0.00','0','0','0.00',NULL,'0');");
E_D("replace into `ecs_order_info` values('197',0x3433,'0','0','0','0','','0','0','0','0','','','','','','','','','0','','9','','','','','','','','','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0','0.00','0.00','8000.00','0','','0','0','0','0','0','0','0','','','0','','','0','','0.00','0','0','0.00',NULL,'0');");
require("../../inc/footer.php");
?>