Postby rcampion » Fri Feb 14, 2014 9:20 am
Here are the tables that cannot be created in MySQL via the exported DDL of HSQL ...
//---------------------------
CREATE TABLE BLC_SC_FLD (
SC_FLD_ID BIGINT NOT NULL,
CREATED_BY BIGINT,
DATE_CREATED TIMESTAMP,
DATE_UPDATED TIMESTAMP,
UPDATED_BY BIGINT,
FLD_KEY VARCHAR(255),
LOB_VALUE null,
VALUE VARCHAR(255),
SC_ID BIGINT
)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null,
VALUE VARCHAR(255),
SC_ID BIGINT
)' at line 8
Elapsed Time: 0 hr, 0 min, 0 sec, 0 ms.
//---------------------------
CREATE TABLE BLC_ORDER_PAYMENT (
PAYMENT_ID BIGINT NOT NULL,
AMOUNT NUMERIC(19 , 5),
CUSTOMER_IP_ADDRESS VARCHAR(255),
REFERENCE_NUMBER VARCHAR(255),
PAYMENT_TYPE VARCHAR(255) NOT NULL,
ADDRESS_ID BIGINT,
CUSTOMER_PAYMENT_ID BIGINT,
ORDER_ID BIGINT NOT NULL,
PHONE_ID BIGINT
)
Table 'BLC_ORDER_PAYMENT' already exists
Elapsed Time: 0 hr, 0 min, 0 sec, 0 ms.
//---------------------------
CREATE TABLE BLC_SKU_FEE (
SKU_FEE_ID BIGINT NOT NULL,
AMOUNT NUMERIC(19 , 5) NOT NULL,
DESCRIPTION VARCHAR(255),
EXPRESSION null,
FEE_TYPE VARCHAR(255),
NAME VARCHAR(255),
TAXABLE BOOLEAN,
CURRENCY_CODE VARCHAR(255)
)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null,
FEE_TYPE VARCHAR(255),
NAME VARCHAR(255),
TAXABLE BOOLEAN,
CURRENC' at line 5
Elapsed Time: 0 hr, 0 min, 0 sec, 0 ms.
//---------------------------
CREATE TABLE BLC_PAGE_FLD (
PAGE_FLD_ID BIGINT NOT NULL,
CREATED_BY BIGINT,
DATE_CREATED TIMESTAMP,
DATE_UPDATED TIMESTAMP,
UPDATED_BY BIGINT,
FLD_KEY VARCHAR(255),
LOB_VALUE null,
VALUE VARCHAR(255),
PAGE_ID BIGINT
)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null,
VALUE VARCHAR(255),
PAGE_ID BIGINT
)' at line 8
Elapsed Time: 0 hr, 0 min, 0 sec, 0 ms.
//---------------------------
CREATE TABLE BLC_TRANSLATION (
TRANSLATION_ID BIGINT NOT NULL,
ENTITY_ID VARCHAR(255),
ENTITY_TYPE VARCHAR(255),
FIELD_NAME VARCHAR(255),
LOCALE_CODE VARCHAR(255),
TRANSLATED_VALUE null
)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null
)' at line 7
Elapsed Time: 0 hr, 0 min, 0 sec, 0 ms.
//---------------------------
CREATE TABLE BLC_SC_ITEM_CRITERIA (
SC_ITEM_CRITERIA_ID BIGINT NOT NULL,
ORDER_ITEM_MATCH_RULE null,
QUANTITY INTEGER NOT NULL
)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null,
QUANTITY INTEGER NOT NULL
)' at line 3
Elapsed Time: 0 hr, 0 min, 0 sec, 0 ms.
//---------------------------
CREATE TABLE BLC_CATEGORY (
CATEGORY_ID BIGINT NOT NULL,
ACTIVE_END_DATE TIMESTAMP,
ACTIVE_START_DATE TIMESTAMP,
ARCHIVED CHAR(255),
DESCRIPTION VARCHAR(255),
DISPLAY_TEMPLATE VARCHAR(255),
FULFILLMENT_TYPE VARCHAR(255),
INVENTORY_TYPE VARCHAR(255),
LONG_DESCRIPTION null,
NAME VARCHAR(255) NOT NULL,
TAX_CODE VARCHAR(255),
URL VARCHAR(255),
URL_KEY VARCHAR(255),
DEFAULT_PARENT_CATEGORY_ID BIGINT
)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null,
NAME VARCHAR(255) NOT NULL,
TAX_CODE VARCHAR(255),
URL VARCHAR(255),' at line 10
Elapsed Time: 0 hr, 0 min, 0 sec, 0 ms.
//---------------------------
CREATE TABLE BLC_PAGE_ITEM_CRITERIA (
PAGE_ITEM_CRITERIA_ID BIGINT NOT NULL,
ORDER_ITEM_MATCH_RULE null,
QUANTITY INTEGER NOT NULL
)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null,
QUANTITY INTEGER NOT NULL
)' at line 3
Elapsed Time: 0 hr, 0 min, 0 sec, 0 ms.
//---------------------------
CREATE TABLE BLC_FULFILLMENT_OPTION (
FULFILLMENT_OPTION_ID BIGINT NOT NULL,
FULFILLMENT_TYPE VARCHAR(255) NOT NULL,
LONG_DESCRIPTION null,
NAME VARCHAR(255),
TAX_CODE VARCHAR(255),
TAXABLE BOOLEAN,
USE_FLAT_RATES BOOLEAN
)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null,
NAME VARCHAR(255),
TAX_CODE VARCHAR(255),
TAXABLE BOOLEAN,
USE_FLA' at line 4
Elapsed Time: 0 hr, 0 min, 0 sec, 0 ms.
//---------------------------
CREATE TABLE BLC_OFFER (
OFFER_ID BIGINT NOT NULL,
APPLIES_WHEN_RULES null,
APPLIES_TO_RULES null,
APPLY_OFFER_TO_MARKED_ITEMS BOOLEAN,
APPLY_TO_SALE_PRICE BOOLEAN,
ARCHIVED CHAR(255),
AUTOMATICALLY_ADDED BOOLEAN,
COMBINABLE_WITH_OTHER_OFFERS BOOLEAN,
OFFER_DELIVERY_TYPE VARCHAR(255),
OFFER_DESCRIPTION VARCHAR(255),
OFFER_DISCOUNT_TYPE VARCHAR(255),
END_DATE TIMESTAMP,
MARKETING_MESSASGE VARCHAR(255),
MAX_USES_PER_CUSTOMER BIGINT,
MAX_USES INTEGER,
OFFER_NAME VARCHAR(255) NOT NULL,
OFFER_ITEM_QUALIFIER_RULE VARCHAR(255),
OFFER_ITEM_TARGET_RULE VARCHAR(255),
OFFER_PRIORITY INTEGER,
QUALIFYING_ITEM_MIN_TOTAL NUMERIC(19 , 5),
STACKABLE BOOLEAN,
START_DATE TIMESTAMP,
TARGET_SYSTEM VARCHAR(255),
TOTALITARIAN_OFFER BOOLEAN,
USE_NEW_FORMAT BOOLEAN,
OFFER_TYPE VARCHAR(255) NOT NULL,
USES INTEGER,
OFFER_VALUE NUMERIC(19 , 5) NOT NULL
)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null,
APPLIES_TO_RULES null,
APPLY_OFFER_TO_MARKED_ITEMS BOOLEAN,
APPLY_TO' at line 3
Elapsed Time: 0 hr, 0 min, 0 sec, 0 ms.
//---------------------------
CREATE TABLE BLC_OFFER_RULE (
OFFER_RULE_ID BIGINT NOT NULL,
MATCH_RULE null
)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null
)' at line 3
Elapsed Time: 0 hr, 0 min, 0 sec, 0 ms.
//---------------------------
CREATE TABLE BLC_SC_RULE (
SC_RULE_ID BIGINT NOT NULL,
MATCH_RULE null
)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null
)' at line 3
Elapsed Time: 0 hr, 0 min, 0 sec, 0 ms.
//---------------------------
Todo: Inspect the corresponding domain entities ...