forked from pmanousis/Hecataeus
-
Notifications
You must be signed in to change notification settings - Fork 0
/
HecataeusDB.log
150 lines (150 loc) · 51.3 KB
/
HecataeusDB.log
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
CREATE USER SA PASSWORD "" ADMIN
CREATE TABLE BIODATABASE ( \u000a\u0009 BIODATABASE_ID INTEGER, \u000a\u0009 NAME VARCHAR ( 128 ) NOT NULL, \u000a\u0009 AUTHORITY VARCHAR ( 128 ) , \u000a\u0009 DESCRIPTION VARCHAR (30000),\u000a\u0009 PRIMARY KEY (BIODATABASE_ID)\u000a)
CREATE TABLE TAXON ( \u000a\u0009 TAXON_ID INTEGER, \u000a\u0009 NCBI_TAXON_ID INTEGER NOT NULL, \u000a\u0009 PARENT_TAXON_ID INTEGER , \u000a\u0009 NODE_RANK VARCHAR ( 32 ) , \u000a\u0009 GENETIC_CODE SMALLINT , \u000a\u0009 MITO_GENETIC_CODE SMALLINT , \u000a\u0009 LEFT_VALUE INTEGER NOT NULL , \u000a\u0009 RIGHT_VALUE INTEGER NOT NULL ,\u000a\u0009 PRIMARY KEY (TAXON_ID )\u000a )
CREATE TABLE TAXON_NAME ( \u000a\u0009 TAXON_ID INTEGER NOT NULL , \u000a\u0009 NAME VARCHAR ( 255 ) NOT NULL , \u000a\u0009 NAME_CLASS VARCHAR ( 32 ) NOT NULL\u000a \u000a)
CREATE TABLE ONTOLOGY ( \u000a\u0009 ONTOLOGY_ID INTEGER, \u000a\u0009 NAME VARCHAR ( 32 ) NOT NULL, \u000a\u0009 DEFINITION VARCHAR (30000) , \u000a\u0009 PRIMARY KEY (ONTOLOGY_ID )\u000a\u0009 \u000a)
CREATE TABLE TERM ( \u000a\u0009 TERM_ID INTEGER PRIMARY KEY , \u000a\u0009 NAME VARCHAR ( 255 ) NOT NULL , \u000a\u0009 DEFINITION VARCHAR(30000) , \u000a\u0009 IDENTIFIER VARCHAR ( 40 ) NOT NULL, \u000a\u0009 IS_OBSOLETE CHAR ( 1 ) NOT NULL,\u000a\u0009 ONTOLOGY_ID INTEGER NOT NULL\u000a)
CREATE TABLE TERM_SYNONYM (\u000a\u0009 SYNONYM VARCHAR(255) NOT NULL,\u000a\u0009 TERM_ID INTEGER NOT NULL,\u000a \u0009 PRIMARY KEY ( TERM_ID , SYNONYM ) )
CREATE TABLE TERM_DBXREF ( \u000a\u0009 TERM_ID INTEGER NOT NULL , \u000a\u0009 DBXREF_ID INTEGER NOT NULL , \u000a\u0009 RANK INTEGER , \u000a\u0009 PRIMARY KEY ( TERM_ID , DBXREF_ID ) )
CREATE TABLE TERM_RELATIONSHIP ( \u000a\u0009 TERM_RELATIONSHIP_ID INTEGER PRIMARY KEY , \u000a\u0009 SUBJECT_TERM_ID INTEGER NOT NULL , \u000a\u0009 PREDICATE_TERM_ID INTEGER NOT NULL , \u000a\u0009 OBJECT_TERM_ID INTEGER NOT NULL , \u000a\u0009 ONTOLOGY_ID INTEGER NOT NULL \u000a\u0009 )
CREATE TABLE TERM_RELATIONSHIP_TERM (\u000a TERM_RELATIONSHIP_ID INTEGER NOT NULL PRIMARY KEY ,\u000a TERM_ID INTEGER NOT NULL \u000a)
CREATE TABLE TERM_PATH ( \u000a TERM_PATH_ID INTEGER PRIMARY KEY ,\u000a\u0009 SUBJECT_TERM_ID INTEGER NOT NULL , \u000a\u0009 PREDICATE_TERM_ID INTEGER NOT NULL , \u000a\u0009 OBJECT_TERM_ID INTEGER NOT NULL , \u000a\u0009 ONTOLOGY_ID INTEGER NOT NULL , \u000a\u0009 DISTANCE INTEGER NOT NULL\u000a\u0009\u000a\u0009 )
CREATE TABLE BIOENTRY ( \u000a\u0009 BIOENTRY_ID INTEGER PRIMARY KEY , \u000a\u0009 BIODATABASE_ID INTEGER NOT NULL , \u000a\u0009 TAXON_ID INTEGER , \u000a\u0009 NAME VARCHAR ( 40 ) NOT NULL , \u000a\u0009 ACCESSION VARCHAR ( 128 ) NOT NULL , \u000a\u0009 IDENTIFIER VARCHAR ( 40 ) NOT NULL, \u000a\u0009 DIVISION VARCHAR ( 6 ) , \u000a\u0009 DESCRIPTION VARCHAR( 4096 ) , \u000a\u0009 VERSION INTEGER NOT NULL \u000a\u0009\u000a)
CREATE TABLE BIOENTRY_RELATIONSHIP ( \u000a\u0009 BIOENTRY_RELATIONSHIP_ID INTEGER PRIMARY KEY , \u000a\u0009 OBJECT_BIOENTRY_ID INTEGER NOT NULL , \u000a\u0009 SUBJECT_BIOENTRY_ID INTEGER NOT NULL , \u000a\u0009 TERM_ID INTEGER NOT NULL , \u000a\u0009 RANK INTEGER\u000a)
CREATE TABLE BIOENTRY_PATH ( \u000a\u0009 OBJECT_BIOENTRY_ID INTEGER NOT NULL , \u000a\u0009 SUBJECT_BIOENTRY_ID INTEGER NOT NULL , \u000a\u0009 TERM_ID INTEGER NOT NULL , \u000a\u0009 DISTANCE INTEGER NOT NULL\u000a\u0009 )
CREATE TABLE BIOSEQUENCE ( \u000a\u0009 BIOENTRY_ID INTEGER PRIMARY KEY , \u000a\u0009 VERSION INTEGER , \u000a\u0009 LENGTH INTEGER , \u000a\u0009 ALPHABET VARCHAR ( 10 ) , \u000a\u0009 SEQ VARCHAR(255) \u000a)
CREATE TABLE DBXREF ( \u000a\u0009 DBXREF_ID INTEGER PRIMARY KEY , \u000a\u0009 DBNAME VARCHAR ( 40 ) NOT NULL , \u000a\u0009 ACCESSION VARCHAR ( 128 ) NOT NULL , \u000a\u0009 VERSION INTEGER NOT NULL)
CREATE TABLE DBXREF_QUALIFIER_VALUE ( \u000a\u0009 DBXREF_ID INTEGER NOT NULL , \u000a\u0009 TERM_ID INTEGER NOT NULL , \u000a\u0009 RANK INTEGER NOT NULL, \u000a\u0009 VALUE VARCHAR (30000) , \u000a\u0009 PRIMARY KEY ( DBXREF_ID , TERM_ID , RANK ) )
CREATE TABLE BIOENTRY_DBXREF ( \u000a\u0009 BIOENTRY_ID INTEGER NOT NULL , \u000a\u0009 DBXREF_ID INTEGER NOT NULL , \u000a\u0009 RANK INTEGER , \u000a\u0009 PRIMARY KEY ( BIOENTRY_ID , DBXREF_ID ) )
CREATE TABLE REFERENCE ( \u000a\u0009 REFERENCE_ID INTEGER PRIMARY KEY , \u000a\u0009 DBXREF_ID INTEGER NOT NULL ,\u000a\u0009 LOCATION VARCHAR (30000) NOT NULL , \u000a\u0009 TITLE VARCHAR (30000) , \u000a\u0009 AUTHORS VARCHAR (30000) , \u000a\u0009 CRC VARCHAR ( 32 ) NOT NULL\u000a)
CREATE TABLE BIOENTRY_REFERENCE ( \u000a\u0009 BIOENTRY_ID INTEGER NOT NULL , \u000a\u0009 REFERENCE_ID INTEGER NOT NULL , \u000a\u0009 START_POS INTEGER , \u000a\u0009 END_POS INTEGER , \u000a\u0009 RANK INTEGER NOT NULL , \u000a\u0009 PRIMARY KEY ( BIOENTRY_ID , REFERENCE_ID , RANK ) )
CREATE TABLE COMMENT ( \u000a\u0009 COMMENT_ID INTEGER PRIMARY KEY, \u000a\u0009 BIOENTRY_ID INTEGER NOT NULL , \u000a\u0009 COMMENT_TEXT VARCHAR (30000) NOT NULL , \u000a\u0009 RANK INTEGER NOT NULL)
CREATE TABLE BIOENTRY_QUALIFIER_VALUE ( \u000a\u0009 BIOENTRY_ID INTEGER NOT NULL , \u000a\u0009 TERM_ID INTEGER NOT NULL , \u000a\u0009 VALUE VARCHAR (30000) , \u000a\u0009 RANK INTEGER NOT NULL )
CREATE TABLE SEQFEATURE ( \u000a\u0009 SEQFEATURE_ID INTEGER PRIMARY KEY , \u000a\u0009 BIOENTRY_ID INTEGER NOT NULL , \u000a\u0009 TYPE_TERM_ID INTEGER NOT NULL , \u000a\u0009 SOURCE_TERM_ID INTEGER NOT NULL , \u000a\u0009 DISPLAY_NAME VARCHAR ( 64 ) , \u000a\u0009 RANK INTEGER NOT NULL)
CREATE TABLE SEQFEATURE_RELATIONSHIP ( \u000a\u0009 SEQFEATURE_RELATIONSHIP_ID INTEGER PRIMARY KEY , \u000a\u0009 OBJECT_SEQFEATURE_ID INTEGER NOT NULL , \u000a\u0009 SUBJECT_SEQFEATURE_ID INTEGER NOT NULL , \u000a\u0009 TERM_ID INTEGER NOT NULL , \u000a\u0009 RANK INTEGER )
CREATE TABLE SEQFEATURE_PATH ( \u000a\u0009 OBJECT_SEQFEATURE_ID INTEGER NOT NULL , \u000a\u0009 SUBJECT_SEQFEATURE_ID INTEGER NOT NULL , \u000a\u0009 TERM_ID INTEGER NOT NULL , \u000a\u0009 DISTANCE INTEGER NOT NULL )
CREATE TABLE SEQFEATURE_QUALIFIER_VALUE ( \u000a\u0009 SEQFEATURE_ID INTEGER NOT NULL , \u000a\u0009 TERM_ID INTEGER NOT NULL , \u000a\u0009 RANK INTEGER NOT NULL , \u000a\u0009 VALUE VARCHAR (1024) NOT NULL )
CREATE TABLE SEQFEATURE_DBXREF ( \u000a\u0009 SEQFEATURE_ID INTEGER NOT NULL , \u000a\u0009 DBXREF_ID INTEGER NOT NULL , \u000a\u0009 RANK INTEGER )
CREATE TABLE LOCATION ( \u000a\u0009 LOCATION_ID INTEGER PRIMARY KEY , \u000a\u0009 SEQFEATURE_ID INTEGER NOT NULL , \u000a\u0009 DBXREF_ID INTEGER , \u000a\u0009 TERM_ID INTEGER , \u000a\u0009 START_POS INTEGER , \u000a\u0009 END_POS INTEGER , \u000a\u0009 STRAND INTEGER NOT NULL , \u000a\u0009 RANK INTEGER NOT NULL )
CREATE TABLE LOCATION_QUALIFIER_VALUE ( \u000a\u0009 LOCATION_ID INTEGER NOT NULL , \u000a\u0009 TERM_ID INTEGER NOT NULL , \u000a\u0009 VALUE VARCHAR ( 255 ) NOT NULL , \u000a\u0009 INT_VALUE INTEGER , \u000a\u0009 PRIMARY KEY ( LOCATION_ID , TERM_ID ) )
CREATE TABLE SEQFEATURE_KEY_V (SEQFEATURE_ID integer(1), BIOENTRY_ID integer(1), TYPE_TERM_ID integer(1), SOURCE_TERM_ID integer(1), DISPLAY_NAME integer(1), RANK integer(1), KEY_NAME integer(1) )
CREATE TABLE GFF (FREF integer(1), FSTART integer(1), FEND integer(1), TYPE integer(1), FSCORE integer(1), FSTRAND integer(1), FPHASE integer(1), GID integer(1) )
CREATE TABLE FASTA (HEADER integer(1), RESIDUES integer(1) )
CREATE TABLE FASTA_WITHLEN (HEADER integer(1), RESIDUES integer(1) )
CREATE TABLE EMBL_FT (FLOC integer(1), FTYPE integer(1), QTERM integer(1), QVAL integer(1) )
CREATE TABLE EMBL (ID integer(1), AC integer(1), SV integer(1) )
CREATE TABLE F_SOURCE (SEQFEATURE_ID integer(1), BIOENTRY_ID integer(1), TYPE_TERM_ID integer(1), SOURCE_TERM_ID integer(1), DISPLAY_NAME integer(1), RANK integer(1), KEY_NAME integer(1) )
CREATE TABLE F_MISC_FEATURE (SEQFEATURE_ID integer(1), BIOENTRY_ID integer(1), TYPE_TERM_ID integer(1), SOURCE_TERM_ID integer(1), DISPLAY_NAME integer(1), RANK integer(1), KEY_NAME integer(1) )
CREATE TABLE F_SIG_PEPTIDE (SEQFEATURE_ID integer(1), BIOENTRY_ID integer(1), TYPE_TERM_ID integer(1), SOURCE_TERM_ID integer(1), DISPLAY_NAME integer(1), RANK integer(1), KEY_NAME integer(1) )
CREATE TABLE F_CDS (SEQFEATURE_ID integer(1), BIOENTRY_ID integer(1), TYPE_TERM_ID integer(1), SOURCE_TERM_ID integer(1), DISPLAY_NAME integer(1), RANK integer(1), KEY_NAME integer(1) )
CREATE TABLE F_GENE (SEQFEATURE_ID integer(1), BIOENTRY_ID integer(1), TYPE_TERM_ID integer(1), SOURCE_TERM_ID integer(1), DISPLAY_NAME integer(1), RANK integer(1), KEY_NAME integer(1) )
CREATE TABLE F_MAT_PEPTIDE (SEQFEATURE_ID integer(1), BIOENTRY_ID integer(1), TYPE_TERM_ID integer(1), SOURCE_TERM_ID integer(1), DISPLAY_NAME integer(1), RANK integer(1), KEY_NAME integer(1) )
CREATE TABLE F_VARIATION (SEQFEATURE_ID integer(1), BIOENTRY_ID integer(1), TYPE_TERM_ID integer(1), SOURCE_TERM_ID integer(1), DISPLAY_NAME integer(1), RANK integer(1), KEY_NAME integer(1) )
CREATE TABLE F_EXON (SEQFEATURE_ID integer(1), BIOENTRY_ID integer(1), TYPE_TERM_ID integer(1), SOURCE_TERM_ID integer(1), DISPLAY_NAME integer(1), RANK integer(1), KEY_NAME integer(1) )
CREATE TABLE F_INTRON (SEQFEATURE_ID integer(1), BIOENTRY_ID integer(1), TYPE_TERM_ID integer(1), SOURCE_TERM_ID integer(1), DISPLAY_NAME integer(1), RANK integer(1), KEY_NAME integer(1) )
CREATE TABLE UPGRADE_EXCEPTIONS (\u000a UPGRADE_EXCEPTION_ID INT(5) NOT NULL ,\u000a SQL_FILE VARCHAR(50) ,\u000a REASON VARCHAR(200) ,\u000a ERRORDATE DATETIME , \u000a SQLSTATEMENT VARCHAR(200),\u000a PRIMARY KEY (UPGRADE_EXCEPTION_ID)\u000a)
CREATE TABLE ADDRESS_BOOK (\u000a ADDRESS_BOOK_ID INT(11) NOT NULL ,\u000a CUSTOMERS_ID INT(11) NOT NULL ,\u000a ENTRY_GENDER CHAR(1) NOT NULL ,\u000a ENTRY_COMPANY VARCHAR(64) ,\u000a ENTRY_FIRSTNAME VARCHAR(32) NOT NULL ,\u000a ENTRY_LASTNAME VARCHAR(32) NOT NULL ,\u000a ENTRY_STREET_ADDRESS VARCHAR(64) NOT NULL ,\u000a ENTRY_SUBURB VARCHAR(32) ,\u000a ENTRY_POSTCODE VARCHAR(10) NOT NULL ,\u000a ENTRY_CITY VARCHAR(32) NOT NULL ,\u000a ENTRY_STATE VARCHAR(32) ,\u000a ENTRY_COUNTRY_ID INT(11) NOT NULL ,\u000a ENTRY_ZONE_ID INT(11) NOT NULL ,\u000a PRIMARY KEY (ADDRESS_BOOK_ID)\u000a)
CREATE TABLE ADDRESS_FORMAT (\u000a ADDRESS_FORMAT_ID INT(11) NOT NULL ,\u000a ADDRESS_FORMAT VARCHAR(128) NOT NULL ,\u000a ADDRESS_SUMMARY VARCHAR(48) NOT NULL ,\u000a PRIMARY KEY (ADDRESS_FORMAT_ID)\u000a)
CREATE TABLE ADMIN (\u000a ADMIN_ID INT(11) NOT NULL ,\u000a ADMIN_NAME VARCHAR(32) NOT NULL ,\u000a ADMIN_EMAIL VARCHAR(96) NOT NULL ,\u000a ADMIN_PROFILE INT(11) NOT NULL ,\u000a ADMIN_PASS VARCHAR(40) NOT NULL ,\u000a PREV_PASS1 VARCHAR(40) NOT NULL ,\u000a PREV_PASS2 VARCHAR(40) NOT NULL ,\u000a PREV_PASS3 VARCHAR(40) NOT NULL ,\u000a PWD_LAST_CHANGE_DATE DATETIME NOT NULL , \u000a RESET_TOKEN VARCHAR(60) NOT NULL ,\u000a LAST_MODIFIED DATETIME NOT NULL , \u000a LAST_LOGIN_DATE DATETIME NOT NULL , \u000a LAST_LOGIN_IP VARCHAR(45) NOT NULL ,\u000a FAILED_LOGINS INT(4) NOT NULL ,\u000a LOCKOUT_EXPIRES INT(11) NOT NULL ,\u000a LAST_FAILED_ATTEMPT DATETIME NOT NULL , \u000a LAST_FAILED_IP VARCHAR(45) NOT NULL ,\u000a PRIMARY KEY (ADMIN_ID)\u000a)
CREATE TABLE ADMIN_ACTIVITY_LOG (\u000a LOG_ID INT(15) NOT NULL ,\u000a ACCESS_DATE DATETIME NOT NULL , \u000a ADMIN_ID INT(11) NOT NULL ,\u000a PAGE_ACCESSED VARCHAR(80) NOT NULL ,\u000a PAGE_PARAMETERS VARCHAR(45),\u000a IP_ADDRESS VARCHAR(45) NOT NULL ,\u000a FLAGGED INT NOT NULL ,\u000a ATTENTION VARCHAR(255) NOT NULL ,\u000a GZPOST VARCHAR(255),\u000a PRIMARY KEY (LOG_ID)\u000a)
CREATE TABLE ADMIN_MENUS (\u000a MENU_KEY VARCHAR(32) NOT NULL ,\u000a LANGUAGE_KEY VARCHAR(255) NOT NULL ,\u000a SORT_ORDER INT(11) NOT NULL \u000a)
CREATE TABLE ADMIN_PAGES (\u000a PAGE_KEY VARCHAR(32) NOT NULL ,\u000a LANGUAGE_KEY VARCHAR(255) NOT NULL ,\u000a MAIN_PAGE VARCHAR(64) NOT NULL ,\u000a PAGE_PARAMS VARCHAR(64) NOT NULL ,\u000a MENU_KEY VARCHAR(32) NOT NULL ,\u000a DISPLAY_ON_MENU CHAR(1) NOT NULL ,\u000a SORT_ORDER INT(11) NOT NULL\u000a)
CREATE TABLE ADMIN_PROFILES (\u000a PROFILE_ID INT(11) NOT NULL ,\u000a PROFILE_NAME VARCHAR(64) NOT NULL ,\u000a PRIMARY KEY (PROFILE_ID)\u000a)
CREATE TABLE ADMIN_PAGES_TO_PROFILES (\u000a PROFILE_ID INT(11) NOT NULL ,\u000a PAGE_KEY VARCHAR(32) NOT NULL \u000a)
CREATE TABLE AUTHORIZENET (\u000a ID INT(11) NOT NULL ,\u000a CUSTOMER_ID INT(11) NOT NULL ,\u000a ORDER_ID INT(11) NOT NULL ,\u000a RESPONSE_CODE INT(1) NOT NULL ,\u000a RESPONSE_TEXT VARCHAR(255) NOT NULL ,\u000a AUTHORIZATION_TYPE VARCHAR(50) NOT NULL ,\u000a TRANSACTION_ID INT(20) ,\u000a SENT VARCHAR(50) NOT NULL,\u000a RECEIVED VARCHAR(50) NOT NULL,\u000a TIME VARCHAR(50) NOT NULL ,\u000a SESSION_ID VARCHAR(255) NOT NULL ,\u000a PRIMARY KEY (ID)\u000a)
CREATE TABLE BANNERS (\u000a BANNERS_ID INT(11) NOT NULL ,\u000a BANNERS_TITLE VARCHAR(64) NOT NULL ,\u000a BANNERS_URL VARCHAR(255) NOT NULL ,\u000a BANNERS_IMAGE VARCHAR(64) NOT NULL ,\u000a BANNERS_GROUP VARCHAR(15) NOT NULL ,\u000a BANNERS_HTML_TEXT VARCHAR(255),\u000a EXPIRES_IMPRESSIONS INT(7) ,\u000a EXPIRES_DATE DATETIME ,\u000a DATE_SCHEDULED DATETIME ,\u000a DATE_ADDED DATETIME NOT NULL , \u000a DATE_STATUS_CHANGE DATETIME ,\u000a STATUS INT(1) NOT NULL ,\u000a BANNERS_OPEN_NEW_WINDOWS INT(1) NOT NULL ,\u000a BANNERS_ON_SSL INT(1) NOT NULL ,\u000a BANNERS_SORT_ORDER INT(11) NOT NULL ,\u000a PRIMARY KEY (BANNERS_ID)\u000a)
CREATE TABLE BANNERS_HISTORY (\u000a BANNERS_HISTORY_ID INT(11) NOT NULL ,\u000a BANNERS_ID INT(11) NOT NULL ,\u000a BANNERS_SHOWN INT(5) NOT NULL ,\u000a BANNERS_CLICKED INT(5) NOT NULL ,\u000a BANNERS_HISTORY_DATE DATETIME NOT NULL , \u000a PRIMARY KEY (BANNERS_HISTORY_ID)\u000a)
CREATE TABLE CATEGORIES (\u000a CATEGORIES_ID INT(11) NOT NULL ,\u000a CATEGORIES_IMAGE VARCHAR(64) ,\u000a PARENT_ID INT(11) NOT NULL ,\u000a SORT_ORDER INT(3) ,\u000a DATE_ADDED DATETIME ,\u000a LAST_MODIFIED DATETIME ,\u000a CATEGORIES_STATUS INT(1) NOT NULL ,\u000a PRIMARY KEY (CATEGORIES_ID)\u000a)
CREATE TABLE CATEGORIES_DESCRIPTION (\u000a CATEGORIES_ID INT(11) NOT NULL ,\u000a LANGUAGE_ID INT(11) NOT NULL ,\u000a CATEGORIES_NAME VARCHAR(32) NOT NULL ,\u000a CATEGORIES_DESCRIPTION VARCHAR(32) NOT NULL,\u000a PRIMARY KEY (CATEGORIES_ID,LANGUAGE_ID)\u000a)
CREATE TABLE CONFIGURATION (\u000a CONFIGURATION_ID INT(11) NOT NULL ,\u000a CONFIGURATION_TITLE VARCHAR(255) NOT NULL,\u000a CONFIGURATION_KEY VARCHAR(255) NOT NULL ,\u000a CONFIGURATION_VALUE VARCHAR(255) NOT NULL,\u000a CONFIGURATION_DESCRIPTION VARCHAR(255) NOT NULL,\u000a CONFIGURATION_GROUP_ID INT(11) NOT NULL ,\u000a SORT_ORDER INT(5) ,\u000a LAST_MODIFIED DATETIME ,\u000a DATE_ADDED DATETIME NOT NULL ,\u000a USE_FUNCTION VARCHAR(255) ,\u000a SET_FUNCTION VARCHAR(255) ,\u000a PRIMARY KEY (CONFIGURATION_ID)\u000a)
CREATE TABLE CONFIGURATION_GROUP (\u000a CONFIGURATION_GROUP_ID INT(11) NOT NULL ,\u000a CONFIGURATION_GROUP_TITLE VARCHAR(64) NOT NULL ,\u000a CONFIGURATION_GROUP_DESCRIPTION VARCHAR(255) NOT NULL ,\u000a SORT_ORDER INT(5) ,\u000a VISIBLE INT(1) ,\u000a PRIMARY KEY (CONFIGURATION_GROUP_ID)\u000a)
CREATE TABLE COUNTER (\u000a STARTDATE CHAR(8) ,\u000a COUNTER INT(12) \u000a)
CREATE TABLE COUNTER_HISTORY (\u000a STARTDATE CHAR(8) ,\u000a COUNTER INT(12) ,\u000a SESSION_COUNTER INT(12) ,\u000a PRIMARY KEY (STARTDATE)\u000a)
CREATE TABLE COUNTRIES (\u000a COUNTRIES_ID INT(11) NOT NULL ,\u000a COUNTRIES_NAME VARCHAR(64) NOT NULL ,\u000a COUNTRIES_ISO_CODE_2 CHAR(2) NOT NULL ,\u000a COUNTRIES_ISO_CODE_3 CHAR(3) NOT NULL ,\u000a ADDRESS_FORMAT_ID INT(11) NOT NULL ,\u000a PRIMARY KEY (COUNTRIES_ID)\u000a)
CREATE TABLE COUPON_EMAIL_TRACK (\u000a UNIQUE_ID INT(11) NOT NULL ,\u000a COUPON_ID INT(11) NOT NULL ,\u000a CUSTOMER_ID_SENT INT(11) NOT NULL ,\u000a SENT_FIRSTNAME VARCHAR(32) ,\u000a SENT_LASTNAME VARCHAR(32) ,\u000a EMAILED_TO VARCHAR(32) ,\u000a DATE_SENT DATETIME NOT NULL ,\u000a PRIMARY KEY (UNIQUE_ID)\u000a)
CREATE TABLE COUPON_GV_CUSTOMER (\u000a CUSTOMER_ID INT(5) NOT NULL ,\u000a AMOUNT DECIMAL(15,4) NOT NULL ,\u000a PRIMARY KEY (CUSTOMER_ID)\u000a)
CREATE TABLE COUPON_GV_QUEUE (\u000a UNIQUE_ID INT(5) NOT NULL ,\u000a CUSTOMER_ID INT(5) NOT NULL ,\u000a ORDER_ID INT(5) NOT NULL ,\u000a AMOUNT DECIMAL(15,4) NOT NULL ,\u000a DATE_CREATED DATETIME NOT NULL , \u000a IPADDR VARCHAR(45) NOT NULL ,\u000a RELEASE_FLAG CHAR(1) NOT NULL ,\u000a PRIMARY KEY (UNIQUE_ID)\u000a)
CREATE TABLE COUPON_REDEEM_TRACK (\u000a UNIQUE_ID INT(11) NOT NULL ,\u000a COUPON_ID INT(11) NOT NULL ,\u000a CUSTOMER_ID INT(11) NOT NULL ,\u000a REDEEM_DATE DATETIME NOT NULL , \u000a REDEEM_IP VARCHAR(45) NOT NULL ,\u000a ORDER_ID INT(11) NOT NULL ,\u000a PRIMARY KEY (UNIQUE_ID)\u000a)
CREATE TABLE COUPON_RESTRICT (\u000a RESTRICT_ID INT(11) NOT NULL ,\u000a COUPON_ID INT(11) NOT NULL ,\u000a PRODUCT_ID INT(11) NOT NULL ,\u000a CATEGORY_ID INT(11) NOT NULL ,\u000a COUPON_RESTRICT CHAR(1) NOT NULL ,\u000a PRIMARY KEY (RESTRICT_ID)\u000a)
CREATE TABLE COUPONS (\u000a COUPON_ID INT(11) NOT NULL ,\u000a COUPON_TYPE CHAR(1) NOT NULL , \u000a COUPON_CODE VARCHAR(32) NOT NULL ,\u000a COUPON_AMOUNT DECIMAL(15,4) NOT NULL , \u000a COUPON_MINIMUM_ORDER DECIMAL(15,4) NOT NULL , \u000a COUPON_START_DATE DATETIME NOT NULL ,\u000a COUPON_EXPIRE_DATE DATETIME NOT NULL , \u000a USES_PER_COUPON INT(5) NOT NULL ,\u000a USES_PER_USER INT(5) NOT NULL ,\u000a RESTRICT_TO_PRODUCTS VARCHAR(255) ,\u000a RESTRICT_TO_CATEGORIES VARCHAR(255) ,\u000a RESTRICT_TO_CUSTOMERS VARCHAR(255),\u000a COUPON_ACTIVE CHAR(1) NOT NULL , \u000a DATE_CREATED DATETIME NOT NULL , \u000a DATE_MODIFIED DATETIME NOT NULL , \u000a COUPON_ZONE_RESTRICTION INT(11) NOT NULL ,\u000a PRIMARY KEY (COUPON_ID)\u000a)
CREATE TABLE COUPONS_DESCRIPTION (\u000a COUPON_ID INT(11) NOT NULL ,\u000a LANGUAGE_ID INT(11) NOT NULL ,\u000a COUPON_NAME VARCHAR(32) NOT NULL ,\u000a COUPON_DESCRIPTION VARCHAR(32),\u000a PRIMARY KEY (COUPON_ID,LANGUAGE_ID)\u000a)
CREATE TABLE CURRENCIES (\u000a CURRENCIES_ID INT(11) NOT NULL ,\u000a TITLE VARCHAR(32) NOT NULL ,\u000a CODE CHAR(3) NOT NULL ,\u000a SYMBOL_LEFT VARCHAR(24) ,\u000a SYMBOL_RIGHT VARCHAR(24) ,\u000a DECIMAL_POINT CHAR(1) ,\u000a THOUSANDS_POINT CHAR(1) ,\u000a DECIMAL_PLACES CHAR(1) ,\u000a VALUE FLOAT(13,8) ,\u000a LAST_UPDATED DATETIME ,\u000a PRIMARY KEY (CURRENCIES_ID)\u000a)
CREATE TABLE CUSTOMERS (\u000a CUSTOMERS_ID INT(11) NOT NULL ,\u000a CUSTOMERS_GENDER CHAR(1) NOT NULL ,\u000a CUSTOMERS_FIRSTNAME VARCHAR(32) NOT NULL ,\u000a CUSTOMERS_LASTNAME VARCHAR(32) NOT NULL ,\u000a CUSTOMERS_DOB DATETIME NOT NULL , \u000a CUSTOMERS_EMAIL_ADDRESS VARCHAR(96) NOT NULL ,\u000a CUSTOMERS_NICK VARCHAR(96) NOT NULL ,\u000a CUSTOMERS_DEFAULT_ADDRESS_ID INT(11) NOT NULL ,\u000a CUSTOMERS_TELEPHONE VARCHAR(32) NOT NULL ,\u000a CUSTOMERS_FAX VARCHAR(32) ,\u000a CUSTOMERS_PASSWORD VARCHAR(40) NOT NULL ,\u000a CUSTOMERS_NEWSLETTER CHAR(1) ,\u000a CUSTOMERS_GROUP_PRICING INT(11) NOT NULL ,\u000a CUSTOMERS_EMAIL_FORMAT VARCHAR(4) NOT NULL , \u000a CUSTOMERS_AUTHORIZATION INT(1) NOT NULL ,\u000a CUSTOMERS_REFERRAL VARCHAR(32) NOT NULL ,\u000a CUSTOMERS_PAYPAL_PAYERID VARCHAR(20) NOT NULL ,\u000a CUSTOMERS_PAYPAL_EC INT(1) NOT NULL,\u000a PRIMARY KEY (CUSTOMERS_ID)\u000a)
CREATE TABLE CUSTOMERS_BASKET (\u000a CUSTOMERS_BASKET_ID INT(11) NOT NULL ,\u000a CUSTOMERS_ID INT(11) NOT NULL ,\u000a PRODUCTS_ID VARCHAR(8)NOT NULL,\u000a CUSTOMERS_BASKET_QUANTITY FLOAT NOT NULL ,\u000a FINAL_PRICE DECIMAL(15,4) NOT NULL , \u000a CUSTOMERS_BASKET_DATE_ADDED VARCHAR(8) ,\u000a PRIMARY KEY (CUSTOMERS_BASKET_ID)\u000a)
CREATE TABLE CUSTOMERS_BASKET_ATTRIBUTES (\u000a CUSTOMERS_BASKET_ATTRIBUTES_ID INT(11) NOT NULL ,\u000a CUSTOMERS_ID INT(11) NOT NULL ,\u000a PRODUCTS_ID VARCHAR(64) NOT NULL,\u000a PRODUCTS_OPTIONS_ID VARCHAR(64) NOT NULL ,\u000a PRODUCTS_OPTIONS_VALUE_ID INT(11) NOT NULL ,\u000a PRODUCTS_OPTIONS_VALUE_TEXT INT NULL,\u000a PRODUCTS_OPTIONS_SORT_ORDER VARCHAR(64) NOT NULL,\u000a PRIMARY KEY (CUSTOMERS_BASKET_ATTRIBUTES_ID)\u000a)
CREATE TABLE CUSTOMERS_INFO (\u000a CUSTOMERS_INFO_ID INT(11) NOT NULL ,\u000a CUSTOMERS_INFO_DATE_OF_LAST_LOGON DATETIME ,\u000a CUSTOMERS_INFO_NUMBER_OF_LOGONS INT(5) ,\u000a CUSTOMERS_INFO_DATE_ACCOUNT_CREATED DATETIME ,\u000a CUSTOMERS_INFO_DATE_ACCOUNT_LAST_MODIFIED DATETIME ,\u000a GLOBAL_PRODUCT_NOTIFICATIONS INT(1) ,\u000a PRIMARY KEY (CUSTOMERS_INFO_ID)\u000a)
CREATE TABLE DB_CACHE (\u000a CACHE_ENTRY_NAME VARCHAR(64) NOT NULL ,\u000a CACHE_DATA VARCHAR(64),\u000a CACHE_ENTRY_CREATED INT(15) ,\u000a PRIMARY KEY (CACHE_ENTRY_NAME)\u000a)
CREATE TABLE EMAIL_ARCHIVE (\u000a ARCHIVE_ID INT(11) NOT NULL ,\u000a EMAIL_TO_NAME VARCHAR(96) NOT NULL ,\u000a EMAIL_TO_ADDRESS VARCHAR(96) NOT NULL ,\u000a EMAIL_FROM_NAME VARCHAR(96) NOT NULL ,\u000a EMAIL_FROM_ADDRESS VARCHAR(96) NOT NULL ,\u000a EMAIL_SUBJECT VARCHAR(255) NOT NULL ,\u000a EMAIL_HTML VARCHAR(255) NOT NULL,\u000a EMAIL_TEXT VARCHAR(255) NOT NULL,\u000a DATE_SENT DATETIME NOT NULL , \u000a MODULE VARCHAR(64) NOT NULL ,\u000a PRIMARY KEY (ARCHIVE_ID)\u000a)
CREATE TABLE EZPAGES (\u000a PAGES_ID INT(11) NOT NULL ,\u000a LANGUAGES_ID INT(11) NOT NULL ,\u000a PAGES_TITLE VARCHAR(64) NOT NULL ,\u000a ALT_URL VARCHAR(255) NOT NULL ,\u000a ALT_URL_EXTERNAL VARCHAR(255) NOT NULL ,\u000a PAGES_HTML_TEXT VARCHAR(32),\u000a STATUS_HEADER INT(1) NOT NULL ,\u000a STATUS_SIDEBOX INT(1) NOT NULL ,\u000a STATUS_FOOTER INT(1) NOT NULL ,\u000a STATUS_TOC INT(1) NOT NULL ,\u000a HEADER_SORT_ORDER INT(3) NOT NULL ,\u000a SIDEBOX_SORT_ORDER INT(3) NOT NULL ,\u000a FOOTER_SORT_ORDER INT(3) NOT NULL ,\u000a TOC_SORT_ORDER INT(3) NOT NULL ,\u000a PAGE_OPEN_NEW_WINDOW INT(1) NOT NULL ,\u000a PAGE_IS_SSL INT(1) NOT NULL ,\u000a TOC_CHAPTER INT(11) NOT NULL ,\u000a PRIMARY KEY (PAGES_ID)\u000a)
CREATE TABLE FEATURED (\u000a FEATURED_ID INT(11) NOT NULL ,\u000a PRODUCTS_ID INT(11) NOT NULL ,\u000a FEATURED_DATE_ADDED DATETIME ,\u000a FEATURED_LAST_MODIFIED DATETIME ,\u000a EXPIRES_DATE DATE NOT NULL , \u000a DATE_STATUS_CHANGE DATETIME ,\u000a STATUS INT(1) NOT NULL ,\u000a FEATURED_DATE_AVAILABLE DATE NOT NULL , \u000a PRIMARY KEY (FEATURED_ID)\u000a)
CREATE TABLE FILES_UPLOADED (\u000a FILES_UPLOADED_ID INT(11) NOT NULL ,\u000a SESSKEY VARCHAR(32) ,\u000a CUSTOMERS_ID INT(11) ,\u000a FILES_UPLOADED_NAME VARCHAR(64) NOT NULL ,\u000a PRIMARY KEY (FILES_UPLOADED_ID)\u000a)
CREATE TABLE GEO_ZONES (\u000a GEO_ZONE_ID INT(11) NOT NULL ,\u000a GEO_ZONE_NAME VARCHAR(32) NOT NULL ,\u000a GEO_ZONE_DESCRIPTION VARCHAR(255) NOT NULL ,\u000a LAST_MODIFIED DATETIME ,\u000a DATE_ADDED DATETIME NOT NULL , \u000a PRIMARY KEY (GEO_ZONE_ID)\u000a)
CREATE TABLE GET_TERMS_TO_FILTER (\u000a GET_TERM_NAME VARCHAR(255) NOT NULL ,\u000a GET_TERM_TABLE VARCHAR(64) NOT NULL,\u000a GET_TERM_NAME_FIELD VARCHAR(64) NOT NULL,\u000a PRIMARY KEY (GET_TERM_NAME)\u000a)
CREATE TABLE GROUP_PRICING (\u000a GROUP_ID INT(11) NOT NULL ,\u000a GROUP_NAME VARCHAR(32) NOT NULL ,\u000a GROUP_PERCENTAGE DECIMAL(5,2) NOT NULL , \u000a LAST_MODIFIED DATETIME ,\u000a DATE_ADDED DATETIME NOT NULL , \u000a PRIMARY KEY (GROUP_ID)\u000a)
CREATE TABLE LANGUAGES (\u000a LANGUAGES_ID INT(11) NOT NULL ,\u000a NAME VARCHAR(32) NOT NULL ,\u000a CODE CHAR(2) NOT NULL ,\u000a IMAGE VARCHAR(64) ,\u000a DIRECTORY VARCHAR(32) ,\u000a SORT_ORDER INT(3) ,\u000a PRIMARY KEY (LANGUAGES_ID)\u000a)
CREATE TABLE LAYOUT_BOXES (\u000a LAYOUT_ID INT(11) NOT NULL ,\u000a LAYOUT_TEMPLATE VARCHAR(64) NOT NULL ,\u000a LAYOUT_BOX_NAME VARCHAR(64) NOT NULL ,\u000a LAYOUT_BOX_STATUS INT(1) NOT NULL ,\u000a LAYOUT_BOX_LOCATION INT(1) NOT NULL ,\u000a LAYOUT_BOX_SORT_ORDER INT(11) NOT NULL ,\u000a LAYOUT_BOX_SORT_ORDER_SINGLE INT(11) NOT NULL ,\u000a LAYOUT_BOX_STATUS_SINGLE INT(4) NOT NULL ,\u000a PRIMARY KEY (LAYOUT_ID)\u000a)
CREATE TABLE MANUFACTURERS (\u000a MANUFACTURERS_ID INT(11) NOT NULL ,\u000a MANUFACTURERS_NAME VARCHAR(32) NOT NULL ,\u000a MANUFACTURERS_IMAGE VARCHAR(64) ,\u000a DATE_ADDED DATETIME ,\u000a LAST_MODIFIED DATETIME ,\u000a PRIMARY KEY (MANUFACTURERS_ID)\u000a)
CREATE TABLE MANUFACTURERS_INFO (\u000a MANUFACTURERS_ID INT(11) NOT NULL ,\u000a LANGUAGES_ID INT(11) NOT NULL ,\u000a MANUFACTURERS_URL VARCHAR(255) NOT NULL ,\u000a URL_CLICKED INT(5) NOT NULL ,\u000a DATE_LAST_CLICK DATETIME ,\u000a PRIMARY KEY (MANUFACTURERS_ID,LANGUAGES_ID)\u000a)
CREATE TABLE MEDIA_CLIPS (\u000a CLIP_ID INT(11) NOT NULL ,\u000a MEDIA_ID INT(11) NOT NULL ,\u000a CLIP_TYPE INT(6) NOT NULL ,\u000a CLIP_FILENAME VARCHAR(255) NOT NULL,\u000a DATE_ADDED DATETIME NOT NULL , \u000a LAST_MODIFIED DATETIME NOT NULL ,\u000a PRIMARY KEY (CLIP_ID)\u000a)
CREATE TABLE MEDIA_MANAGER (\u000a MEDIA_ID INT(11) NOT NULL ,\u000a MEDIA_NAME VARCHAR(255) NOT NULL ,\u000a LAST_MODIFIED DATETIME NOT NULL , \u000a DATE_ADDED DATETIME NOT NULL , \u000a PRIMARY KEY (MEDIA_ID)\u000a)
CREATE TABLE MEDIA_TO_PRODUCTS (\u000a MEDIA_ID INT(11) NOT NULL ,\u000a PRODUCT_ID INT(11) NOT NULL\u000a)
CREATE TABLE MEDIA_TYPES (\u000a TYPE_ID INT(11) NOT NULL ,\u000a TYPE_NAME VARCHAR(64) NOT NULL ,\u000a TYPE_EXT VARCHAR(8) NOT NULL ,\u000a PRIMARY KEY (TYPE_ID)\u000a)
CREATE TABLE META_TAGS_CATEGORIES_DESCRIPTION (\u000a CATEGORIES_ID INT(11) NOT NULL,\u000a LANGUAGE_ID INT(11) NOT NULL ,\u000a METATAGS_TITLE VARCHAR(255) NOT NULL ,\u000a METATAGS_KEYWORDS VARCHAR(255),\u000a METATAGS_DESCRIPTION VARCHAR(255),\u000a PRIMARY KEY (CATEGORIES_ID,LANGUAGE_ID)\u000a)
CREATE TABLE META_TAGS_PRODUCTS_DESCRIPTION (\u000a PRODUCTS_ID INT(11) NOT NULL,\u000a LANGUAGE_ID INT(11) NOT NULL ,\u000a METATAGS_TITLE VARCHAR(255) NOT NULL ,\u000a METATAGS_KEYWORDS VARCHAR(255),\u000a METATAGS_DESCRIPTION VARCHAR(255),\u000a PRIMARY KEY (PRODUCTS_ID,LANGUAGE_ID)\u000a)
CREATE TABLE MUSIC_GENRE (\u000a MUSIC_GENRE_ID INT(11) NOT NULL ,\u000a MUSIC_GENRE_NAME VARCHAR(32) NOT NULL ,\u000a DATE_ADDED DATETIME ,\u000a LAST_MODIFIED DATETIME ,\u000a PRIMARY KEY (MUSIC_GENRE_ID)\u000a)
CREATE TABLE NEWSLETTERS (\u000a NEWSLETTERS_ID INT(11) NOT NULL ,\u000a TITLE VARCHAR(255) NOT NULL ,\u000a CONTENT VARCHAR(255) NOT NULL,\u000a CONTENT_HTML VARCHAR(255) NOT NULL,\u000a MODULE VARCHAR(255) NOT NULL ,\u000a DATE_ADDED DATETIME NOT NULL , \u000a DATE_SENT DATETIME ,\u000a STATUS INT(1) ,\u000a LOCKED INT(1) ,\u000a PRIMARY KEY (NEWSLETTERS_ID)\u000a)
CREATE TABLE ORDERS (\u000a ORDERS_ID INT(11) NOT NULL ,\u000a CUSTOMERS_ID INT(11) NOT NULL ,\u000a CUSTOMERS_NAME VARCHAR(64) NOT NULL ,\u000a CUSTOMERS_COMPANY VARCHAR(64) ,\u000a CUSTOMERS_STREET_ADDRESS VARCHAR(64) NOT NULL ,\u000a CUSTOMERS_SUBURB VARCHAR(32) ,\u000a CUSTOMERS_CITY VARCHAR(32) NOT NULL ,\u000a CUSTOMERS_POSTCODE VARCHAR(10) NOT NULL ,\u000a CUSTOMERS_STATE VARCHAR(32) ,\u000a CUSTOMERS_COUNTRY VARCHAR(32) NOT NULL ,\u000a CUSTOMERS_TELEPHONE VARCHAR(32) NOT NULL ,\u000a CUSTOMERS_EMAIL_ADDRESS VARCHAR(96) NOT NULL ,\u000a CUSTOMERS_ADDRESS_FORMAT_ID INT(5) NOT NULL ,\u000a DELIVERY_NAME VARCHAR(64) NOT NULL ,\u000a DELIVERY_COMPANY VARCHAR(64) ,\u000a DELIVERY_STREET_ADDRESS VARCHAR(64) NOT NULL ,\u000a DELIVERY_SUBURB VARCHAR(32) ,\u000a DELIVERY_CITY VARCHAR(32) NOT NULL ,\u000a DELIVERY_POSTCODE VARCHAR(10) NOT NULL ,\u000a DELIVERY_STATE VARCHAR(32) ,\u000a DELIVERY_COUNTRY VARCHAR(32) NOT NULL ,\u000a DELIVERY_ADDRESS_FORMAT_ID INT(5) NOT NULL ,\u000a BILLING_NAME VARCHAR(64) NOT NULL ,\u000a BILLING_COMPANY VARCHAR(64) ,\u000a BILLING_STREET_ADDRESS VARCHAR(64) NOT NULL ,\u000a BILLING_SUBURB VARCHAR(32) ,\u000a BILLING_CITY VARCHAR(32) NOT NULL ,\u000a BILLING_POSTCODE VARCHAR(10) NOT NULL ,\u000a BILLING_STATE VARCHAR(32) ,\u000a BILLING_COUNTRY VARCHAR(32) NOT NULL ,\u000a BILLING_ADDRESS_FORMAT_ID INT(5) NOT NULL ,\u000a PAYMENT_METHOD VARCHAR(128) NOT NULL ,\u000a PAYMENT_MODULE_CODE VARCHAR(32) NOT NULL ,\u000a SHIPPING_METHOD VARCHAR(128) NOT NULL ,\u000a SHIPPING_MODULE_CODE VARCHAR(32) NOT NULL ,\u000a COUPON_CODE VARCHAR(32) NOT NULL ,\u000a CC_TYPE VARCHAR(20) ,\u000a CC_OWNER VARCHAR(64) ,\u000a CC_NUMBER VARCHAR(32) ,\u000a CC_EXPIRES VARCHAR(4) ,\u000a CC_CVV VARCHAR(4),\u000a LAST_MODIFIED DATETIME ,\u000a DATE_PURCHASED DATETIME ,\u000a ORDERS_STATUS INT(5) NOT NULL ,\u000a ORDERS_DATE_FINISHED DATETIME ,\u000a CURRENCY CHAR(3) ,\u000a CURRENCY_VALUE DECIMAL(14,6) ,\u000a ORDER_TOTAL DECIMAL(14,2) ,\u000a ORDER_TAX DECIMAL(14,2) ,\u000a PAYPAL_IPN_ID INT(11) NOT NULL ,\u000a IP_ADDRESS VARCHAR(96) NOT NULL ,\u000a PRIMARY KEY (ORDERS_ID)\u000a)
CREATE TABLE ORDERS_PRODUCTS (\u000a ORDERS_PRODUCTS_ID INT(11) NOT NULL ,\u000a ORDERS_ID INT(11) NOT NULL ,\u000a PRODUCTS_ID INT(11) NOT NULL ,\u000a PRODUCTS_MODEL VARCHAR(32) ,\u000a PRODUCTS_NAME VARCHAR(64) NOT NULL ,\u000a PRODUCTS_PRICE DECIMAL(15,4) NOT NULL , \u000a FINAL_PRICE DECIMAL(15,4) NOT NULL , \u000a PRODUCTS_TAX DECIMAL(7,4) NOT NULL , \u000a PRODUCTS_QUANTITY FLOAT NOT NULL ,\u000a ONETIME_CHARGES DECIMAL(15,4) NOT NULL ,\u000a PRODUCTS_PRICED_BY_ATTRIBUTE INT(1) NOT NULL ,\u000a PRODUCT_IS_FREE INT(1) NOT NULL ,\u000a PRODUCTS_DISCOUNT_TYPE INT(1) NOT NULL ,\u000a PRODUCTS_DISCOUNT_TYPE_FROM INT(1) NOT NULL ,\u000a PRODUCTS_PRID VARCHAR(64) NOT NULL,\u000a PRIMARY KEY (ORDERS_PRODUCTS_ID)\u000a)
CREATE TABLE ORDERS_PRODUCTS_ATTRIBUTES (\u000a ORDERS_PRODUCTS_ATTRIBUTES_ID INT(11) NOT NULL ,\u000a ORDERS_ID INT(11) NOT NULL ,\u000a ORDERS_PRODUCTS_ID INT(11) NOT NULL ,\u000a PRODUCTS_OPTIONS VARCHAR(32) NOT NULL ,\u000a PRODUCTS_OPTIONS_VALUES VARCHAR(32) NOT NULL,\u000a OPTIONS_VALUES_PRICE DECIMAL(15,4) NOT NULL ,\u000a PRICE_PREFIX CHAR(1) NOT NULL ,\u000a PRODUCT_ATTRIBUTE_IS_FREE INT(1) NOT NULL ,\u000a PRODUCTS_ATTRIBUTES_WEIGHT FLOAT NOT NULL ,\u000a PRODUCTS_ATTRIBUTES_WEIGHT_PREFIX CHAR(1) NOT NULL ,\u000a ATTRIBUTES_DISCOUNTED INT(1) NOT NULL ,\u000a ATTRIBUTES_PRICE_BASE_INCLUDED INT(1) NOT NULL ,\u000a ATTRIBUTES_PRICE_ONETIME DECIMAL(15,4) NOT NULL , \u000a ATTRIBUTES_PRICE_FACTOR DECIMAL(15,4) NOT NULL , \u000a ATTRIBUTES_PRICE_FACTOR_OFFSET DECIMAL(15,4) NOT NULL , \u000a ATTRIBUTES_PRICE_FACTOR_ONETIME DECIMAL(15,4) NOT NULL ,\u000a ATTRIBUTES_PRICE_FACTOR_ONETIME_OFFSET DECIMAL(15,4) NOT NULL , \u000a ATTRIBUTES_QTY_PRICES VARCHAR(32),\u000a ATTRIBUTES_QTY_PRICES_ONETIME VARCHAR(32),\u000a ATTRIBUTES_PRICE_WORDS DECIMAL(15,4) NOT NULL , \u000a ATTRIBUTES_PRICE_WORDS_FREE INT(4) NOT NULL ,\u000a ATTRIBUTES_PRICE_LETTERS DECIMAL(15,4) NOT NULL , \u000a ATTRIBUTES_PRICE_LETTERS_FREE INT(4) NOT NULL ,\u000a PRODUCTS_OPTIONS_ID INT(11) NOT NULL ,\u000a PRODUCTS_OPTIONS_VALUES_ID INT(11) NOT NULL ,\u000a PRODUCTS_PRID VARCHAR(32) NOT NULL,\u000a PRIMARY KEY (ORDERS_PRODUCTS_ATTRIBUTES_ID)\u000a)
CREATE TABLE ORDERS_PRODUCTS_DOWNLOAD (\u000a ORDERS_PRODUCTS_DOWNLOAD_ID INT(11) NOT NULL ,\u000a ORDERS_ID INT(11) NOT NULL ,\u000a ORDERS_PRODUCTS_ID INT(11) NOT NULL ,\u000a ORDERS_PRODUCTS_FILENAME VARCHAR(255) NOT NULL ,\u000a DOWNLOAD_MAXDAYS INT(2) NOT NULL ,\u000a DOWNLOAD_COUNT INT(2) NOT NULL ,\u000a PRODUCTS_PRID VARCHAR(32) NOT NULL,\u000a PRIMARY KEY (ORDERS_PRODUCTS_DOWNLOAD_ID)\u000a)
CREATE TABLE ORDERS_STATUS (\u000a ORDERS_STATUS_ID INT(11) NOT NULL ,\u000a LANGUAGE_ID INT(11) NOT NULL ,\u000a ORDERS_STATUS_NAME VARCHAR(32) NOT NULL ,\u000a PRIMARY KEY (ORDERS_STATUS_ID,LANGUAGE_ID)\u000a)
CREATE TABLE ORDERS_STATUS_HISTORY (\u000a ORDERS_STATUS_HISTORY_ID INT(11) NOT NULL ,\u000a ORDERS_ID INT(11) NOT NULL ,\u000a ORDERS_STATUS_ID INT(5) NOT NULL ,\u000a DATE_ADDED DATETIME NOT NULL , \u000a CUSTOMER_NOTIFIED INT(1) ,\u000a COMMENTS VARCHAR(32),\u000a PRIMARY KEY (ORDERS_STATUS_HISTORY_ID)\u000a)
CREATE TABLE ORDERS_TOTAL (\u000a ORDERS_TOTAL_ID INT(10) NOT NULL ,\u000a ORDERS_ID INT(11) NOT NULL ,\u000a TITLE VARCHAR(255) NOT NULL ,\u000a TEXT VARCHAR(255) NOT NULL ,\u000a VALUE DECIMAL(15,4) NOT NULL , \u000a CLASS VARCHAR(32) NOT NULL ,\u000a SORT_ORDER INT(11) NOT NULL ,\u000a PRIMARY KEY (ORDERS_TOTAL_ID)\u000a)
CREATE TABLE PAYPAL (\u000a PAYPAL_IPN_ID INT(11) NOT NULL ,\u000a ORDER_ID INT(11) NOT NULL ,\u000a TXN_TYPE VARCHAR(40) NOT NULL ,\u000a MODULE_NAME VARCHAR(40) NOT NULL ,\u000a MODULE_MODE VARCHAR(40) NOT NULL ,\u000a REASON_CODE VARCHAR(40) ,\u000a PAYMENT_TYPE VARCHAR(40) NOT NULL ,\u000a PAYMENT_STATUS VARCHAR(32) NOT NULL ,\u000a PENDING_REASON VARCHAR(32) ,\u000a INVOICE VARCHAR(128) ,\u000a MC_CURRENCY CHAR(3) NOT NULL ,\u000a FIRST_NAME VARCHAR(32) NOT NULL ,\u000a LAST_NAME VARCHAR(32) NOT NULL ,\u000a PAYER_BUSINESS_NAME VARCHAR(128) ,\u000a ADDRESS_NAME VARCHAR(64) ,\u000a ADDRESS_STREET VARCHAR(254) ,\u000a ADDRESS_CITY VARCHAR(120) ,\u000a ADDRESS_STATE VARCHAR(120) ,\u000a ADDRESS_ZIP VARCHAR(10) ,\u000a ADDRESS_COUNTRY VARCHAR(64) ,\u000a ADDRESS_STATUS VARCHAR(11) ,\u000a PAYER_EMAIL VARCHAR(128) NOT NULL ,\u000a PAYER_ID VARCHAR(32) NOT NULL ,\u000a PAYER_STATUS VARCHAR(10) NOT NULL ,\u000a PAYMENT_DATE DATETIME NOT NULL , \u000a BUSINESS VARCHAR(128) NOT NULL ,\u000a RECEIVER_EMAIL VARCHAR(128) NOT NULL ,\u000a RECEIVER_ID VARCHAR(32) NOT NULL ,\u000a TXN_ID VARCHAR(20) NOT NULL ,\u000a PARENT_TXN_ID VARCHAR(20) ,\u000a NUM_CART_ITEMS INT(4) NOT NULL ,\u000a MC_GROSS DECIMAL(7,2) NOT NULL , \u000a MC_FEE DECIMAL(7,2) NOT NULL , \u000a PAYMENT_GROSS DECIMAL(7,2) ,\u000a PAYMENT_FEE DECIMAL(7,2) ,\u000a SETTLE_AMOUNT DECIMAL(7,2) ,\u000a SETTLE_CURRENCY CHAR(3) ,\u000a EXCHANGE_RATE DECIMAL(4,2) ,\u000a NOTIFY_VERSION VARCHAR(6) NOT NULL ,\u000a VERIFY_SIGN VARCHAR(128) NOT NULL ,\u000a LAST_MODIFIED DATETIME NOT NULL , \u000a DATE_ADDED DATETIME NOT NULL , \u000a MEMO VARCHAR(32),\u000a PRIMARY KEY (PAYPAL_IPN_ID,TXN_ID)\u000a)
CREATE TABLE PAYPAL_PAYMENT_STATUS (\u000a PAYMENT_STATUS_ID INT(11) NOT NULL ,\u000a PAYMENT_STATUS_NAME VARCHAR(64) NOT NULL ,\u000a PRIMARY KEY (PAYMENT_STATUS_ID)\u000a)
CREATE TABLE PAYPAL_PAYMENT_STATUS_HISTORY (\u000a PAYMENT_STATUS_HISTORY_ID INT(11) NOT NULL ,\u000a PAYPAL_IPN_ID INT(11) NOT NULL ,\u000a TXN_ID VARCHAR(64) NOT NULL ,\u000a PARENT_TXN_ID VARCHAR(64) NOT NULL ,\u000a PAYMENT_STATUS VARCHAR(17) NOT NULL ,\u000a PENDING_REASON VARCHAR(14) ,\u000a DATE_ADDED DATETIME NOT NULL , \u000a PRIMARY KEY (PAYMENT_STATUS_HISTORY_ID)\u000a)
CREATE TABLE PAYPAL_SESSION (\u000a UNIQUE_ID INT(11) NOT NULL ,\u000a SESSION_ID VARCHAR(32) NOT NULL,\u000a SAVED_SESSION VARCHAR(4) NOT NULL,\u000a EXPIRY INT(17) NOT NULL ,\u000a PRIMARY KEY (UNIQUE_ID)\u000a)
CREATE TABLE PAYPAL_TESTING (\u000a PAYPAL_IPN_ID INT(11) NOT NULL ,\u000a ORDER_ID INT(11) NOT NULL ,\u000a CUSTOM VARCHAR(255) NOT NULL ,\u000a TXN_TYPE VARCHAR(40) NOT NULL ,\u000a MODULE_NAME VARCHAR(40) NOT NULL ,\u000a MODULE_MODE VARCHAR(40) NOT NULL ,\u000a REASON_CODE VARCHAR(40) ,\u000a PAYMENT_TYPE VARCHAR(40) NOT NULL ,\u000a PAYMENT_STATUS VARCHAR(32) NOT NULL ,\u000a PENDING_REASON VARCHAR(32) ,\u000a INVOICE VARCHAR(128) ,\u000a MC_CURRENCY CHAR(3) NOT NULL ,\u000a FIRST_NAME VARCHAR(32) NOT NULL ,\u000a LAST_NAME VARCHAR(32) NOT NULL ,\u000a PAYER_BUSINESS_NAME VARCHAR(128) ,\u000a ADDRESS_NAME VARCHAR(64) ,\u000a ADDRESS_STREET VARCHAR(254) ,\u000a ADDRESS_CITY VARCHAR(120) ,\u000a ADDRESS_STATE VARCHAR(120) ,\u000a ADDRESS_ZIP VARCHAR(10) ,\u000a ADDRESS_COUNTRY VARCHAR(64) ,\u000a ADDRESS_STATUS VARCHAR(11) ,\u000a PAYER_EMAIL VARCHAR(128) NOT NULL ,\u000a PAYER_ID VARCHAR(32) NOT NULL ,\u000a PAYER_STATUS VARCHAR(10) NOT NULL ,\u000a PAYMENT_DATE DATETIME NOT NULL , \u000a BUSINESS VARCHAR(128) NOT NULL ,\u000a RECEIVER_EMAIL VARCHAR(128) NOT NULL ,\u000a RECEIVER_ID VARCHAR(32) NOT NULL ,\u000a TXN_ID VARCHAR(20) NOT NULL ,\u000a PARENT_TXN_ID VARCHAR(20) ,\u000a NUM_CART_ITEMS INT(4) NOT NULL ,\u000a MC_GROSS DECIMAL(7,2) NOT NULL , \u000a MC_FEE DECIMAL(7,2) NOT NULL , \u000a PAYMENT_GROSS DECIMAL(7,2) ,\u000a PAYMENT_FEE DECIMAL(7,2) ,\u000a SETTLE_AMOUNT DECIMAL(7,2) ,\u000a SETTLE_CURRENCY CHAR(3) ,\u000a EXCHANGE_RATE DECIMAL(4,2) ,\u000a NOTIFY_VERSION DECIMAL(2,1) NOT NULL , \u000a VERIFY_SIGN VARCHAR(128) NOT NULL ,\u000a LAST_MODIFIED DATETIME NOT NULL , \u000a DATE_ADDED DATETIME NOT NULL , \u000a MEMO VARCHAR(32),\u000a PRIMARY KEY (PAYPAL_IPN_ID,TXN_ID)\u000a)
CREATE TABLE PRODUCT_MUSIC_EXTRA (\u000a PRODUCTS_ID INT(11) NOT NULL ,\u000a ARTISTS_ID INT(11) NOT NULL ,\u000a RECORD_COMPANY_ID INT(11) NOT NULL ,\u000a MUSIC_GENRE_ID INT(11) NOT NULL ,\u000a PRIMARY KEY (PRODUCTS_ID)\u000a)
CREATE TABLE PRODUCT_TYPE_LAYOUT (\u000a CONFIGURATION_ID INT(11) NOT NULL ,\u000a CONFIGURATION_TITLE VARCHAR(32) NOT NULL,\u000a CONFIGURATION_KEY VARCHAR(255) NOT NULL ,\u000a CONFIGURATION_VALUE VARCHAR(32) NOT NULL,\u000a CONFIGURATION_DESCRIPTION VARCHAR(32) NOT NULL,\u000a PRODUCT_TYPE_ID INT(11) NOT NULL ,\u000a SORT_ORDER INT(5) ,\u000a LAST_MODIFIED DATETIME ,\u000a DATE_ADDED DATETIME NOT NULL ,\u000a USE_FUNCTION VARCHAR(255) ,\u000a SET_FUNCTION VARCHAR(255) ,\u000a PRIMARY KEY (CONFIGURATION_ID)\u000a)
CREATE TABLE PRODUCT_TYPES (\u000a TYPE_ID INT(11) NOT NULL ,\u000a TYPE_NAME VARCHAR(255) NOT NULL ,\u000a TYPE_HANDLER VARCHAR(255) NOT NULL ,\u000a TYPE_MASTER_TYPE INT(11) NOT NULL ,\u000a ALLOW_ADD_TO_CART CHAR(1) NOT NULL ,\u000a DEFAULT_IMAGE VARCHAR(255) NOT NULL ,\u000a DATE_ADDED DATETIME NOT NULL , \u000a LAST_MODIFIED DATETIME NOT NULL ,\u000a PRIMARY KEY (TYPE_ID)\u000a)
CREATE TABLE PRODUCT_TYPES_TO_CATEGORY (\u000a PRODUCT_TYPE_ID INT(11) NOT NULL ,\u000a CATEGORY_ID INT(11) NOT NULL \u000a)
CREATE TABLE PRODUCTS (\u000a PRODUCTS_ID INT(11) NOT NULL ,\u000a PRODUCTS_TYPE INT(11) NOT NULL ,\u000a PRODUCTS_QUANTITY FLOAT NOT NULL ,\u000a PRODUCTS_MODEL VARCHAR(32) ,\u000a PRODUCTS_IMAGE VARCHAR(64) ,\u000a PRODUCTS_PRICE DECIMAL(15,4) NOT NULL ,\u000a PRODUCTS_VIRTUAL INT(1) NOT NULL ,\u000a PRODUCTS_DATE_ADDED DATETIME NOT NULL , \u000a PRODUCTS_LAST_MODIFIED DATETIME ,\u000a PRODUCTS_DATE_AVAILABLE DATETIME ,\u000a PRODUCTS_WEIGHT FLOAT NOT NULL ,\u000a PRODUCTS_STATUS INT(1) NOT NULL ,\u000a PRODUCTS_TAX_CLASS_ID INT(11) NOT NULL ,\u000a MANUFACTURERS_ID INT(11) ,\u000a PRODUCTS_ORDERED FLOAT NOT NULL ,\u000a PRODUCTS_QUANTITY_ORDER_MIN FLOAT NOT NULL ,\u000a PRODUCTS_QUANTITY_ORDER_UNITS FLOAT NOT NULL ,\u000a PRODUCTS_PRICED_BY_ATTRIBUTE INT(1) NOT NULL ,\u000a PRODUCT_IS_FREE INT(1) NOT NULL ,\u000a PRODUCT_IS_CALL INT(1) NOT NULL ,\u000a PRODUCTS_QUANTITY_MIXED INT(1) NOT NULL ,\u000a PRODUCT_IS_ALWAYS_FREE_SHIPPING INT(1) NOT NULL ,\u000a PRODUCTS_QTY_BOX_STATUS INT(1) NOT NULL ,\u000a PRODUCTS_QUANTITY_ORDER_MAX FLOAT NOT NULL ,\u000a PRODUCTS_SORT_ORDER INT(11) NOT NULL ,\u000a PRODUCTS_DISCOUNT_TYPE INT(1) NOT NULL ,\u000a PRODUCTS_DISCOUNT_TYPE_FROM INT(1) NOT NULL ,\u000a PRODUCTS_PRICE_SORTER DECIMAL(15,4) NOT NULL ,\u000a MASTER_CATEGORIES_ID INT(11) NOT NULL ,\u000a PRODUCTS_MIXED_DISCOUNT_QUANTITY INT(1) NOT NULL ,\u000a METATAGS_TITLE_STATUS INT(1) NOT NULL ,\u000a METATAGS_PRODUCTS_NAME_STATUS INT(1) NOT NULL ,\u000a METATAGS_MODEL_STATUS INT(1) NOT NULL ,\u000a METATAGS_PRICE_STATUS INT(1) NOT NULL ,\u000a METATAGS_TITLE_TAGLINE_STATUS INT(1) NOT NULL ,\u000a PRIMARY KEY (PRODUCTS_ID)\u000a)
CREATE TABLE PRODUCTS_ATTRIBUTES (\u000a PRODUCTS_ATTRIBUTES_ID INT(11) NOT NULL ,\u000a PRODUCTS_ID INT(11) NOT NULL ,\u000a OPTIONS_ID INT(11) NOT NULL ,\u000a OPTIONS_VALUES_ID INT(11) NOT NULL ,\u000a OPTIONS_VALUES_PRICE DECIMAL(15,4) NOT NULL , \u000a PRICE_PREFIX CHAR(1) NOT NULL ,\u000a PRODUCTS_OPTIONS_SORT_ORDER INT(11) NOT NULL ,\u000a PRODUCT_ATTRIBUTE_IS_FREE INT(1) NOT NULL ,\u000a PRODUCTS_ATTRIBUTES_WEIGHT FLOAT NOT NULL ,\u000a PRODUCTS_ATTRIBUTES_WEIGHT_PREFIX CHAR(1) NOT NULL ,\u000a ATTRIBUTES_DISPLAY_ONLY INT(1) NOT NULL ,\u000a ATTRIBUTES_DEFAULT INT(1) NOT NULL ,\u000a ATTRIBUTES_DISCOUNTED INT(1) NOT NULL ,\u000a ATTRIBUTES_IMAGE VARCHAR(64) ,\u000a ATTRIBUTES_PRICE_BASE_INCLUDED INT(1) NOT NULL ,\u000a ATTRIBUTES_PRICE_ONETIME DECIMAL(15,4) NOT NULL , \u000a ATTRIBUTES_PRICE_FACTOR DECIMAL(15,4) NOT NULL , \u000a ATTRIBUTES_PRICE_FACTOR_OFFSET DECIMAL(15,4) NOT NULL , \u000a ATTRIBUTES_PRICE_FACTOR_ONETIME DECIMAL(15,4) NOT NULL , \u000a ATTRIBUTES_PRICE_FACTOR_ONETIME_OFFSET DECIMAL(15,4) NOT NULL , \u000a ATTRIBUTES_QTY_PRICES VARCHAR(32),\u000a ATTRIBUTES_QTY_PRICES_ONETIME VARCHAR(32),\u000a ATTRIBUTES_PRICE_WORDS DECIMAL(15,4) NOT NULL , \u000a ATTRIBUTES_PRICE_WORDS_FREE INT(4) NOT NULL ,\u000a ATTRIBUTES_PRICE_LETTERS DECIMAL(15,4) NOT NULL , \u000a ATTRIBUTES_PRICE_LETTERS_FREE INT(4) NOT NULL ,\u000a ATTRIBUTES_REQUIRED INT(1) NOT NULL ,\u000a PRIMARY KEY (PRODUCTS_ATTRIBUTES_ID)\u000a)
CREATE TABLE PRODUCTS_ATTRIBUTES_DOWNLOAD (\u000a PRODUCTS_ATTRIBUTES_ID INT(11) NOT NULL ,\u000a PRODUCTS_ATTRIBUTES_FILENAME VARCHAR(255) NOT NULL ,\u000a PRODUCTS_ATTRIBUTES_MAXDAYS INT(2) ,\u000a PRODUCTS_ATTRIBUTES_MAXCOUNT INT(2) ,\u000a PRIMARY KEY (PRODUCTS_ATTRIBUTES_ID)\u000a)
CREATE TABLE PRODUCTS_DESCRIPTION (\u000a PRODUCTS_ID INT(11) NOT NULL ,\u000a LANGUAGE_ID INT(11) NOT NULL ,\u000a PRODUCTS_NAME VARCHAR(64) NOT NULL ,\u000a PRODUCTS_DESCRIPTION VARCHAR(32),\u000a PRODUCTS_URL VARCHAR(255) ,\u000a PRODUCTS_VIEWED INT(5) ,\u000a PRIMARY KEY (PRODUCTS_ID,LANGUAGE_ID)\u000a)
CREATE TABLE PRODUCTS_DISCOUNT_QUANTITY (\u000a DISCOUNT_ID INT(4) NOT NULL ,\u000a PRODUCTS_ID INT(11) NOT NULL ,\u000a DISCOUNT_QTY FLOAT NOT NULL ,\u000a DISCOUNT_PRICE DECIMAL(15,4) NOT NULL\u000a)
CREATE TABLE PRODUCTS_NOTIFICATIONS (\u000a PRODUCTS_ID INT(11) NOT NULL ,\u000a CUSTOMERS_ID INT(11) NOT NULL ,\u000a DATE_ADDED DATETIME NOT NULL , \u000a PRIMARY KEY (PRODUCTS_ID,CUSTOMERS_ID)\u000a)
CREATE TABLE PRODUCTS_OPTIONS (\u000a PRODUCTS_OPTIONS_ID INT(11) NOT NULL ,\u000a LANGUAGE_ID INT(11) NOT NULL ,\u000a PRODUCTS_OPTIONS_NAME VARCHAR(32) NOT NULL ,\u000a PRODUCTS_OPTIONS_SORT_ORDER INT(11) NOT NULL ,\u000a PRODUCTS_OPTIONS_TYPE INT(5) NOT NULL ,\u000a PRODUCTS_OPTIONS_LENGTH SMALLINT(2) NOT NULL ,\u000a PRODUCTS_OPTIONS_COMMENT VARCHAR(64) ,\u000a PRODUCTS_OPTIONS_SIZE SMALLINT(2) NOT NULL , \u000a PRODUCTS_OPTIONS_IMAGES_PER_ROW INT(2) , \u000a PRODUCTS_OPTIONS_IMAGES_STYLE INT(1) ,\u000a PRODUCTS_OPTIONS_ROWS SMALLINT(2) NOT NULL ,\u000a PRIMARY KEY (PRODUCTS_OPTIONS_ID,LANGUAGE_ID)\u000a)
CREATE TABLE PRODUCTS_OPTIONS_TYPES (\u000a PRODUCTS_OPTIONS_TYPES_ID INT(11) NOT NULL ,\u000a PRODUCTS_OPTIONS_TYPES_NAME VARCHAR(32) ,\u000a PRIMARY KEY (PRODUCTS_OPTIONS_TYPES_ID)\u000a)
CREATE TABLE PRODUCTS_OPTIONS_VALUES (\u000a PRODUCTS_OPTIONS_VALUES_ID INT(11) NOT NULL ,\u000a LANGUAGE_ID INT(11) NOT NULL ,\u000a PRODUCTS_OPTIONS_VALUES_NAME VARCHAR(64) NOT NULL ,\u000a PRODUCTS_OPTIONS_VALUES_SORT_ORDER INT(11) NOT NULL ,\u000a PRIMARY KEY (PRODUCTS_OPTIONS_VALUES_ID,LANGUAGE_ID)\u000a)
CREATE TABLE PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS (\u000a PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS_ID INT(11) NOT NULL ,\u000a PRODUCTS_OPTIONS_ID INT(11) NOT NULL ,\u000a PRODUCTS_OPTIONS_VALUES_ID INT(11) NOT NULL ,\u000a PRIMARY KEY (PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS_ID)\u000a)
CREATE TABLE PRODUCTS_TO_CATEGORIES (\u000a PRODUCTS_ID INT(11) NOT NULL ,\u000a CATEGORIES_ID INT(11) NOT NULL ,\u000a PRIMARY KEY (PRODUCTS_ID,CATEGORIES_ID)\u000a)
CREATE TABLE PROJECT_VERSION (\u000a PROJECT_VERSION_ID INT(3) NOT NULL ,\u000a PROJECT_VERSION_KEY VARCHAR(40) NOT NULL ,\u000a PROJECT_VERSION_MAJOR VARCHAR(20) NOT NULL ,\u000a PROJECT_VERSION_MINOR VARCHAR(20) NOT NULL ,\u000a PROJECT_VERSION_PATCH1 VARCHAR(20) NOT NULL ,\u000a PROJECT_VERSION_PATCH2 VARCHAR(20) NOT NULL ,\u000a PROJECT_VERSION_PATCH1_SOURCE VARCHAR(20) NOT NULL ,\u000a PROJECT_VERSION_PATCH2_SOURCE VARCHAR(20) NOT NULL ,\u000a PROJECT_VERSION_COMMENT VARCHAR(250) NOT NULL ,\u000a PROJECT_VERSION_DATE_APPLIED DATETIME NOT NULL , \u000a PRIMARY KEY (PROJECT_VERSION_ID)\u000a)
CREATE TABLE PROJECT_VERSION_HISTORY (\u000a PROJECT_VERSION_ID INT(3) NOT NULL ,\u000a PROJECT_VERSION_KEY VARCHAR(40) NOT NULL ,\u000a PROJECT_VERSION_MAJOR VARCHAR(20) NOT NULL ,\u000a PROJECT_VERSION_MINOR VARCHAR(20) NOT NULL ,\u000a PROJECT_VERSION_PATCH VARCHAR(20) NOT NULL ,\u000a PROJECT_VERSION_COMMENT VARCHAR(250) NOT NULL ,\u000a PROJECT_VERSION_DATE_APPLIED DATETIME NOT NULL , \u000a PRIMARY KEY (PROJECT_VERSION_ID)\u000a)
CREATE TABLE QUERY_BUILDER (\u000a QUERY_ID INT(11) NOT NULL ,\u000a QUERY_CATEGORY VARCHAR(40) NOT NULL ,\u000a QUERY_NAME VARCHAR(80) NOT NULL ,\u000a QUERY_DESCRIPTION VARCHAR(32) NOT NULL,\u000a QUERY_STRING VARCHAR(32) NOT NULL,\u000a QUERY_KEYS_LIST VARCHAR(32) NOT NULL,\u000a PRIMARY KEY (QUERY_ID)\u000a)
CREATE TABLE RECORD_ARTISTS (\u000a ARTISTS_ID INT(11) NOT NULL ,\u000a ARTISTS_NAME VARCHAR(32) NOT NULL ,\u000a ARTISTS_IMAGE VARCHAR(64) ,\u000a DATE_ADDED DATETIME ,\u000a LAST_MODIFIED DATETIME ,\u000a PRIMARY KEY (ARTISTS_ID)\u000a)
CREATE TABLE RECORD_ARTISTS_INFO (\u000a ARTISTS_ID INT(11) NOT NULL ,\u000a LANGUAGES_ID INT(11) NOT NULL ,\u000a ARTISTS_URL VARCHAR(255) NOT NULL ,\u000a URL_CLICKED INT(5) NOT NULL ,\u000a DATE_LAST_CLICK DATETIME ,\u000a PRIMARY KEY (ARTISTS_ID,LANGUAGES_ID)\u000a)
CREATE TABLE RECORD_COMPANY (\u000a RECORD_COMPANY_ID INT(11) NOT NULL ,\u000a RECORD_COMPANY_NAME VARCHAR(32) NOT NULL ,\u000a RECORD_COMPANY_IMAGE VARCHAR(64) ,\u000a DATE_ADDED DATETIME ,\u000a LAST_MODIFIED DATETIME ,\u000a PRIMARY KEY (RECORD_COMPANY_ID)\u000a)
CREATE TABLE RECORD_COMPANY_INFO (\u000a RECORD_COMPANY_ID INT(11) NOT NULL ,\u000a LANGUAGES_ID INT(11) NOT NULL ,\u000a RECORD_COMPANY_URL VARCHAR(255) NOT NULL ,\u000a URL_CLICKED INT(5) NOT NULL ,\u000a DATE_LAST_CLICK DATETIME ,\u000a PRIMARY KEY (RECORD_COMPANY_ID,LANGUAGES_ID)\u000a)
CREATE TABLE REVIEWS (\u000a REVIEWS_ID INT(11) NOT NULL ,\u000a PRODUCTS_ID INT(11) NOT NULL ,\u000a CUSTOMERS_ID INT(11) ,\u000a CUSTOMERS_NAME VARCHAR(64) NOT NULL ,\u000a REVIEWS_RATING INT(1) ,\u000a DATE_ADDED DATETIME ,\u000a LAST_MODIFIED DATETIME ,\u000a REVIEWS_READ INT(5) NOT NULL ,\u000a STATUS INT(1) NOT NULL ,\u000a PRIMARY KEY (REVIEWS_ID)\u000a)
CREATE TABLE REVIEWS_DESCRIPTION (\u000a REVIEWS_ID INT(11) NOT NULL ,\u000a LANGUAGES_ID INT(11) NOT NULL ,\u000a REVIEWS_TEXT VARCHAR(32) NOT NULL,\u000a PRIMARY KEY (REVIEWS_ID,LANGUAGES_ID)\u000a)
CREATE TABLE SALEMAKER_SALES (\u000a SALE_ID INT(11) NOT NULL ,\u000a SALE_STATUS INT(4) NOT NULL ,\u000a SALE_NAME VARCHAR(30) NOT NULL ,\u000a SALE_DEDUCTION_VALUE DECIMAL(15,4) NOT NULL , \u000a SALE_DEDUCTION_TYPE INT(4) NOT NULL ,\u000a SALE_PRICERANGE_FROM DECIMAL(15,4) NOT NULL , \u000a SALE_PRICERANGE_TO DECIMAL(15,4) NOT NULL , \u000a SALE_SPECIALS_CONDITION INT(4) NOT NULL ,\u000a SALE_CATEGORIES_SELECTED VARCHAR(32),\u000a SALE_CATEGORIES_ALL VARCHAR(32),\u000a SALE_DATE_START DATE NOT NULL , \u000a SALE_DATE_END DATE NOT NULL , \u000a SALE_DATE_ADDED DATE NOT NULL , \u000a SALE_DATE_LAST_MODIFIED DATE NOT NULL , \u000a SALE_DATE_STATUS_CHANGE DATE NOT NULL , \u000a PRIMARY KEY (SALE_ID)\u000a)
CREATE TABLE SESSIONS (\u000a SESSKEY VARCHAR(64) NOT NULL ,\u000a EXPIRY INT(11) NOT NULL ,\u000a VALUE INT NOT NULL,\u000a PRIMARY KEY (SESSKEY)\u000a)
CREATE TABLE SPECIALS (\u000a SPECIALS_ID INT(11) NOT NULL ,\u000a PRODUCTS_ID INT(11) NOT NULL ,\u000a SPECIALS_NEW_PRODUCTS_PRICE DECIMAL(15,4) NOT NULL , \u000a SPECIALS_DATE_ADDED DATETIME ,\u000a SPECIALS_LAST_MODIFIED DATETIME ,\u000a EXPIRES_DATE DATE NOT NULL , \u000a DATE_STATUS_CHANGE DATETIME ,\u000a STATUS INT(1) NOT NULL ,\u000a SPECIALS_DATE_AVAILABLE DATE NOT NULL , \u000a PRIMARY KEY (SPECIALS_ID)\u000a)
CREATE TABLE TAX_CLASS (\u000a TAX_CLASS_ID INT(11) NOT NULL ,\u000a TAX_CLASS_TITLE VARCHAR(32) NOT NULL ,\u000a TAX_CLASS_DESCRIPTION VARCHAR(255) NOT NULL ,\u000a LAST_MODIFIED DATETIME ,\u000a DATE_ADDED DATETIME NOT NULL ,\u000a PRIMARY KEY (TAX_CLASS_ID)\u000a)
CREATE TABLE TEMPLATE_SELECT (\u000a TEMPLATE_ID INT(11) NOT NULL ,\u000a TEMPLATE_DIR VARCHAR(64) NOT NULL ,\u000a TEMPLATE_LANGUAGE VARCHAR(64) NOT NULL ,\u000a PRIMARY KEY (TEMPLATE_ID)\u000a)
CREATE TABLE WHOS_ONLINE (\u000a CUSTOMER_ID INT(11) ,\u000a FULL_NAME VARCHAR(64) NOT NULL ,\u000a SESSION_ID VARCHAR(128) NOT NULL ,\u000a IP_ADDRESS VARCHAR(45) NOT NULL ,\u000a TIME_ENTRY VARCHAR(14) NOT NULL ,\u000a TIME_LAST_CLICK VARCHAR(14) NOT NULL ,\u000a LAST_PAGE_URL VARCHAR(255) NOT NULL ,\u000a HOST_ADDRESS VARCHAR(32) NOT NULL,\u000a USER_AGENT VARCHAR(255) NOT NULL \u000a)
CREATE TABLE ZONES (\u000a ZONE_ID INT(11) NOT NULL ,\u000a ZONE_COUNTRY_ID INT(11) NOT NULL ,\u000a ZONE_CODE VARCHAR(32) NOT NULL ,\u000a ZONE_NAME VARCHAR(32) NOT NULL ,\u000a PRIMARY KEY (ZONE_ID)\u000a)
CREATE TABLE ZONES_TO_GEO_ZONES (\u000a ASSOCIATION_ID INT(11) NOT NULL ,\u000a ZONE_COUNTRY_ID INT(11) NOT NULL ,\u000a ZONE_ID INT(11) ,\u000a GEO_ZONE_ID INT(11) ,\u000a LAST_MODIFIED DATETIME ,\u000a DATE_ADDED DATETIME NOT NULL ,\u000a PRIMARY KEY (ASSOCIATION_ID)\u000a)
CREATE TABLE CUSTOMERS_WISHLIST (\u000a PRODUCTS_ID INT(13) NOT NULL ,\u000a CUSTOMERS_ID INT(13) NOT NULL ,\u000a PRODUCTS_MODEL VARCHAR(13) ,\u000a PRODUCTS_NAME VARCHAR(64) NOT NULL ,\u000a PRODUCTS_PRICE DECIMAL(8,2) NOT NULL ,\u000a FINAL_PRICE DECIMAL(8,2) NOT NULL , \u000a PRODUCTS_QUANTITY INT(2) NOT NULL ,\u000a WISHLIST_NAME VARCHAR(64) NOT NULL\u000a)
CREATE TABLE PAYPAL_IPN (\u000a PAYPAL_IPN_ID INT(10) NOT NULL ,\u000a TXN_TYPE INT(10) NOT NULL ,\u000a REASON_CODE INT(11) ,\u000a PAYMENT_TYPE INT(11) NOT NULL ,\u000a PAYMENT_STATUS INT(11) NOT NULL ,\u000a PENDING_REASON INT(11) ,\u000a INVOICE VARCHAR(64) ,\u000a MC_CURRENCY INT(11) NOT NULL ,\u000a FIRST_NAME VARCHAR(32) NOT NULL ,\u000a LAST_NAME VARCHAR(32) NOT NULL ,\u000a PAYER_BUSINESS_NAME VARCHAR(32) ,\u000a ADDRESS_NAME VARCHAR(32) NOT NULL ,\u000a ADDRESS_STREET VARCHAR(64) NOT NULL ,\u000a ADDRESS_CITY VARCHAR(32) NOT NULL ,\u000a ADDRESS_STATE VARCHAR(32) NOT NULL ,\u000a ADDRESS_ZIP VARCHAR(64) NOT NULL ,\u000a ADDRESS_COUNTRY VARCHAR(32) NOT NULL ,\u000a ADDRESS_STATUS VARCHAR(64) NOT NULL ,\u000a ADDRESS_OWNER VARCHAR(64) NOT NULL ,\u000a PAYER_EMAIL VARCHAR(96) NOT NULL ,\u000a EBAY_ADDRESS_ID VARCHAR(96) ,\u000a PAYER_ID VARCHAR(32) NOT NULL ,\u000a PAYER_STATUS VARCHAR(32) NOT NULL ,\u000a PAYMENT_DATE VARCHAR(32) NOT NULL ,\u000a BUSINESS VARCHAR(32) NOT NULL ,\u000a RECEIVER_EMAIL VARCHAR(96) NOT NULL ,\u000a RECEIVER_ID VARCHAR(32) NOT NULL ,\u000a PAYPAL_ADDRESS_ID VARCHAR(64) NOT NULL ,\u000a TXN_ID VARCHAR(17) NOT NULL ,\u000a NOTIFY_VERSION VARCHAR(17) NOT NULL ,\u000a VERIFY_SIGN VARCHAR(64) NOT NULL ,\u000a DATE_ADDED DATETIME NOT NULL , \u000a PRIMARY KEY (PAYPAL_IPN_ID,TXN_ID)\u000a)
CREATE TABLE PAYPAL_IPN_ADDRESS_STATUS (\u000a ADDRESS_STATUS_ID INT(11) NOT NULL ,\u000a LANGUAGE_ID INT(11) NOT NULL ,\u000a ADDRESS_STATUS_NAME VARCHAR(64) NOT NULL ,\u000a PRIMARY KEY (ADDRESS_STATUS_ID,LANGUAGE_ID)\u000a)
CREATE TABLE PAYPAL_IPN_MC_CURRENCY (\u000a MC_CURRENCY_ID INT(11) NOT NULL ,\u000a LANGUAGE_ID INT(11) NOT NULL ,\u000a MC_CURRENCY_NAME VARCHAR(64) NOT NULL ,\u000a PRIMARY KEY (MC_CURRENCY_ID,LANGUAGE_ID)\u000a)
CREATE TABLE PAYPAL_IPN_ORDERS (\u000a PAYPAL_IPN_ORDERS_ID INT(11) NOT NULL ,\u000a PAYPAL_IPN_ID INT(11) NOT NULL ,\u000a NUM_CART_ITEMS INT(4) NOT NULL ,\u000a MC_GROSS DECIMAL(7,2) NOT NULL , \u000a MC_FEE DECIMAL(7,2) NOT NULL , \u000a PAYMENT_GROSS DECIMAL(7,2) NOT NULL , \u000a PAYMENT_FEE DECIMAL(7,2) NOT NULL , \u000a SETTLE_AMOUNT DECIMAL(7,2) NOT NULL , \u000a SETTLE_CURRENCY DECIMAL(7,2) NOT NULL , \u000a EXCHANGE_RATE DECIMAL(7,2) , \u000a PRIMARY KEY (PAYPAL_IPN_ORDERS_ID,PAYPAL_IPN_ID)\u000a)
CREATE TABLE PAYPAL_IPN_ORDERS_MEMO (\u000a ORDERS_MEMO_ID INT(11) NOT NULL ,\u000a PAYPAL_IPN_ID INT(11) NOT NULL ,\u000a MEMO VARCHAR(32),\u000a PRIMARY KEY (ORDERS_MEMO_ID,PAYPAL_IPN_ID)\u000a)
CREATE TABLE PAYPAL_IPN_PAYMENT_STATUS (\u000a PAYMENT_STATUS_ID INT(11) NOT NULL ,\u000a LANGUAGE_ID INT(11) NOT NULL ,\u000a PAYMENT_STATUS_NAME VARCHAR(64) NOT NULL ,\u000a PRIMARY KEY (PAYMENT_STATUS_ID,LANGUAGE_ID)\u000a)
CREATE TABLE PAYPAL_IPN_PAYMENT_TYPE (\u000a PAYMENT_TYPE_ID INT(11) NOT NULL ,\u000a LANGUAGE_ID INT(11) NOT NULL ,\u000a PAYMENT_TYPE_NAME VARCHAR(64) NOT NULL ,\u000a PRIMARY KEY (PAYMENT_TYPE_ID,LANGUAGE_ID)\u000a)
CREATE TABLE PAYPAL_IPN_PENDING_REASON (\u000a PENDING_REASON_ID INT(11) NOT NULL ,\u000a LANGUAGE_ID INT(11) NOT NULL ,\u000a PENDING_REASON_NAME VARCHAR(64) NOT NULL ,\u000a PRIMARY KEY (PENDING_REASON_ID,LANGUAGE_ID)\u000a)
CREATE TABLE PAYPAL_IPN_REASON_CODE (\u000a REASON_CODE_ID INT(11) NOT NULL ,\u000a LANGUAGE_ID INT(11) NOT NULL ,\u000a REASON_CODE_NAME VARCHAR(64) NOT NULL ,\u000a PRIMARY KEY (REASON_CODE_ID,LANGUAGE_ID)\u000a)
CREATE TABLE PAYPAL_IPN_TXN_TYPE (\u000a TXN_TYPE_ID INT(11) NOT NULL ,\u000a LANGUAGE_ID INT(11) NOT NULL , \u000a TXN_TYPE_NAME VARCHAR(64) NOT NULL ,\u000a PRIMARY KEY (TXN_TYPE_ID,LANGUAGE_ID)\u000a)