· 7 years ago · Oct 08, 2018, 12:46 AM
1-- phpMyAdmin SQL Dump
2-- version 3.5.5
3-- http://www.phpmyadmin.net
4--
5-- Host: <redacted>
6-- Generation Time: Jan 20, 2013 at 06:20 AM
7-- Server version: 5.0.85
8-- PHP Version: 5.3.10-1ubuntu3.4
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13<-- SNIP -->
14
15-- --------------------------------------------------------
16
17--
18-- Table structure for table `ORDERS_V3`
19--
20
21CREATE TABLE IF NOT EXISTS `ORDERS_V3` (
22 `ID` int(11) NOT NULL auto_increment,
23 `ORDER_NOTICE_SECRET` text collate utf8_unicode_ci NOT NULL,
24 `ORDER_NOTICE_URL` text collate utf8_unicode_ci NOT NULL,
25 `ENTRY_DATE` timestamp NOT NULL default CURRENT_TIMESTAMP,
26 `PUBLISHER_ID` varchar(128) collate utf8_unicode_ci NOT NULL,
27 `PUBLISHER` varchar(128) collate utf8_unicode_ci NOT NULL,
28 `CUSTOMER_IP` varchar(128) collate utf8_unicode_ci NOT NULL,
29 `ORDER_NUMBER` varchar(128) collate utf8_unicode_ci NOT NULL,
30 `STATUS` varchar(128) collate utf8_unicode_ci NOT NULL,
31 `TRAN_DATE` varchar(25) collate utf8_unicode_ci NOT NULL,
32 `FIRST_NAME` varchar(128) collate utf8_unicode_ci NOT NULL,
33 `LAST_NAME` varchar(128) collate utf8_unicode_ci NOT NULL,
34 `COMPANY` varchar(128) collate utf8_unicode_ci NOT NULL,
35 `ADDRESS1` varchar(128) collate utf8_unicode_ci NOT NULL,
36 `ADDRESS2` varchar(128) collate utf8_unicode_ci NOT NULL,
37 `CITY` varchar(128) collate utf8_unicode_ci NOT NULL,
38 `STATE` varchar(128) collate utf8_unicode_ci NOT NULL,
39 `POSTAL` varchar(128) collate utf8_unicode_ci NOT NULL,
40 `COUNTRY` varchar(128) collate utf8_unicode_ci NOT NULL,
41 `PHONE` varchar(128) collate utf8_unicode_ci NOT NULL,
42 `EMAIL` varchar(128) collate utf8_unicode_ci NOT NULL,
43 `SHIP_FIRST_NAME` varchar(128) collate utf8_unicode_ci NOT NULL,
44 `SHIP_LAST_NAME` varchar(128) collate utf8_unicode_ci NOT NULL,
45 `SHIP_COMPANY` varchar(128) collate utf8_unicode_ci NOT NULL,
46 `SHIP_ADDRESS1` varchar(128) collate utf8_unicode_ci NOT NULL,
47 `SHIP_ADDRESS2` varchar(128) collate utf8_unicode_ci NOT NULL,
48 `SHIP_CITY` varchar(128) collate utf8_unicode_ci NOT NULL,
49 `SHIP_STATE` varchar(128) collate utf8_unicode_ci NOT NULL,
50 `SHIP_POSTAL` varchar(128) collate utf8_unicode_ci NOT NULL,
51 `SHIP_COUNTRY` varchar(128) collate utf8_unicode_ci NOT NULL,
52 `CONTACT_ME` varchar(128) collate utf8_unicode_ci NOT NULL,
53 `ORDER_DISCOUNT` varchar(128) character set latin1 NOT NULL,
54 `SHIP_WEIGHT` varchar(128) character set latin1 NOT NULL,
55 `SHIP_METHOD` varchar(128) character set latin1 NOT NULL,
56 `SHIP_AMOUNT` varchar(128) character set latin1 NOT NULL,
57 `ESELLER_ID` varchar(128) character set latin1 NOT NULL,
58 `ESELLER_NAME` varchar(128) character set latin1 NOT NULL,
59 `METHOD` varchar(128) character set latin1 NOT NULL,
60 `SUB_METHOD` varchar(128) character set latin1 NOT NULL,
61 `COUPON_ID` varchar(128) character set latin1 NOT NULL,
62 `TRACKING_ID` varchar(128) character set latin1 NOT NULL,
63 `VAT_COUNTRY` varchar(128) character set latin1 NOT NULL,
64 `CURRENCY_CODE` varchar(128) character set latin1 NOT NULL,
65 `AFFILIATE_ID` varchar(128) character set latin1 NOT NULL,
66 `AFFILIATE_NAME` varchar(128) character set latin1 NOT NULL,
67 `CUSTOM_0` varchar(128) collate utf8_unicode_ci NOT NULL,
68 `CUSTOM_1` varchar(128) collate utf8_unicode_ci NOT NULL,
69 `CUSTOM_2` varchar(128) collate utf8_unicode_ci NOT NULL,
70 `CUSTOM_3` varchar(128) collate utf8_unicode_ci NOT NULL,
71 `CUSTOM_4` varchar(128) collate utf8_unicode_ci NOT NULL,
72 `CUSTOM_5` varchar(128) collate utf8_unicode_ci NOT NULL,
73 `CUSTOM_6` varchar(128) character set latin1 NOT NULL,
74 `CUSTOM_7` varchar(128) character set latin1 NOT NULL,
75 `CUSTOM_8` varchar(128) character set latin1 NOT NULL,
76 `CUSTOM_9` varchar(128) character set latin1 NOT NULL,
77 `CUSTOM_10` varchar(128) character set latin1 NOT NULL,
78 `CUSTOM_11` varchar(128) character set latin1 NOT NULL,
79 `CUSTOM_12` varchar(128) character set latin1 NOT NULL,
80 `CUSTOM_13` varchar(128) character set latin1 NOT NULL,
81 `CUSTOM_14` varchar(128) character set latin1 NOT NULL,
82 `CUSTOM_15` varchar(128) character set latin1 NOT NULL,
83 `CUSTOM_16` varchar(128) character set latin1 NOT NULL,
84 `CUSTOM_17` varchar(128) collate utf8_unicode_ci NOT NULL,
85 `CUSTOM_18` varchar(128) collate utf8_unicode_ci NOT NULL,
86 `CUSTOM_19` varchar(128) collate utf8_unicode_ci NOT NULL,
87 `UPGRADED` tinyint(4) default '0',
88 `NOTES` text collate utf8_unicode_ci,
89 PRIMARY KEY (`ID`),
90 KEY `UPGRADED` (`UPGRADED`)
91) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=14207 ;