Sincere apologies, and point taken...
I extracted the DDL from code and I cut the commas while removing
double-quotes.
I have now fixed the DDL and loaded in a sandbox:
>>runscript from 'ddl.txt';
runscript from 'ddl.txt';
Update count: 25
(16 ms)
DDL.txt re-attached.
Once again, apologies for the concerns caused...
On Friday, 12 July 2013 15:32:39 UTC+1, Noel Grandin wrote:
>
>
> On 2013-07-12 14:56, Seb N/A wrote:
> >
> > Sorry I have taken so long to respond, I was otherwise occupied.
> > Find attached the schema for tables involved.
>
> Before sending it to us, you should try testing it first, since it has
> syntax errors in the second DDL statement.
>
>
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.
DROP TABLE IF EXISTS dm_liveorders_bmcsv_orderheader;
CREATE
TABLE dm_liveorders_bmcsv_orderheader
(
OrderNumber BIGINT NOT NULL ,
TotalOrder NUMBER NOT NULL ,
TotalTax NUMBER NOT NULL ,
TotalShipping NUMBER NOT NULL ,
TotalTaxShipping NUMBER NOT NULL ,
TotalAdjustment NUMBER NOT NULL ,
LastUpdate TIMESTAMP NOT NULL ,
STATUS VARCHAR2(1) NOT NULL,
CustomerNumber NUMBER(38) NOT NULL ,
Comments VARCHAR2(1024) ,
UpdatedBy NUMBER(38) NOT NULL,
Type VARCHAR2(3) NOT NULL,
Source VARCHAR2(3) NOT NULL,
BMOrderId NUMBER(38) NOT NULL,
);
CREATE PRIMARY KEY ON dm_liveorders_bmcsv_orderheader (BMOrderId);
CREATE UNIQUE INDEX OrderNumber_UNIQUE ON dm_liveorders_bmcsv_orderheader
(OrderNumber);
CREATE INDEX CustomerNumber_UNIQUE ON dm_liveorders_bmcsv_orderheader
(CustomerNumber);
DROP TABLE IF EXISTS dm_liveorders_wc_orders;
CREATE
TABLE dm_liveorders_wc_orders
(
ORDERS_ID NUMBER NOT NULL ,
MEMBER_ID NUMBER NOT NULL ,
EDITOR_ID NUMBER ,
FIELD2 NUMBER NOT NULL ,
ORMORDER VARCHAR2(30) ,
TOTALPRODUCT NUMBER(20, 5) ,
TOTALTAX NUMBER(20, 5) ,
TOTALSHIPPING NUMBER(20, 5) ,
TOTALTAXSHIPPING NUMBER(20, 5) ,
TOTALADJUSTMENT NUMBER(20, 5) ,
STOREENT_ID NUMBER(38) NOT NULL ,
LASTUPDATE TIMESTAMP ,
COMMENTS VARCHAR2(254) ,
TYPE VARCHAR2(3) ,
BUSCHN_ID NUMBER(38, 0) ,
FIELD3 VARCHAR2(254) ,
SUBMITTED_BY_CUSTOMER TIMESTAMP ,
EDPORDER_ID NUMBER NOT NULL ,
ORDER_ID NUMBER ,
STORE_ID NUMBER(38, 0) ,
TOTALAMOUNT NUMBER(20, 5) NOT NULL,
wc_shipslot TIMESTAMP ,
) ;
CREATE PRIMARY KEY ON dm_liveorders_wc_orders (ORDERS_ID);
CREATE
INDEX FIELD2_Index ON dm_liveorders_wc_orders
(
FIELD2
) ;
CREATE
INDEX TOTALAMOUNT_Index ON dm_liveorders_wc_orders
(
TOTALAMOUNT
) ;
DROP TABLE IF EXISTS dm_liveorders_bmcsv_orderlines;
CREATE
TABLE dm_liveorders_bmcsv_orderlines
(
OrderNumber BIGINT NOT NULL ,
PartNumber VARCHAR2(64) NOT NULL ,
StoreNumber NUMBER ,
CustomerNumber NUMBER(38) ,
Address NUMBER ,
Price NUMBER(20, 5) ,
BasePrice NUMBER(20, 5) ,
STATUS VARCHAR2(1) NOT NULL ,
LastCreate TIMESTAMP NOT NULL ,
LastModify TIMESTAMP NOT NULL ,
PromotionCode VARCHAR2(128) ,
TotalProduct NUMBER(20, 5) ,
Quantity NUMBER ,
TaxAmount NUMBER(20, 5) ,
TotalAdjustment NUMBER(20, 5) NOT NULL,
ShipTaxAmount NUMBER(20, 5) ,
SubstitutePreference CHAR(1) ,
OrderUnit VARCHAR(32) ,
) ;
CREATE PRIMARY KEY ON dm_liveorders_bmcsv_orderlines ( OrderNumber, PartNumber
);
CREATE
INDEX PartNumber_Index ON dm_liveorders_bmcsv_orderlines
(
PartNumber
) ;
CREATE
INDEX TotalProduct_Index ON dm_liveorders_bmcsv_orderlines
(
TotalProduct
) ;
CREATE
INDEX Quantity_Index ON dm_liveorders_bmcsv_orderlines
(
Quantity
) ;
DROP TABLE IF EXISTS dm_liveorders_wc_orderitems;
CREATE
TABLE dm_liveorders_wc_orderitems
(
ORDERITEMS_ID NUMBER NOT NULL ,
ORDERS_ID NUMBER NOT NULL ,
FFMCENTER_ID NUMBER(38) ,
MEMBER_ID NUMBER NOT NULL ,
BmAddressId NUMBER ,
STOREENT_ID NUMBER(38) NOT NULL,
PARTNUM VARCHAR2(64) ,
CATENTRY_ID NUMBER ,
ITEMSPC_ID NUMBER ,
OFFER_ID NUMBER ,
PRICE NUMBER(20, 5) ,
BASEPRICE NUMBER(20, 5) ,
LASTCREATE TIMESTAMP ,
LASTUPDATE TIMESTAMP ,
TOTALPRODUCT NUMBER(20, 5) ,
QUANTITY NUMBER NOT NULL ,
TAXAMOUNT NUMBER(20, 5) ,
TOTALADJUSTMENT NUMBER(20, 5) ,
SHIPTAXAMOUNT NUMBER(20, 5) ,
LINEITEMTYPE VARCHAR2(4) ,
br_no VARCHAR(64) ,
RegionName VARCHAR(128) ,
) ;
CREATE PRIMARY KEY ON dm_liveorders_wc_orderitems (ORDERITEMS_ID);
CREATE
INDEX ORDERS_ID_Index ON dm_liveorders_wc_orderitems
(
ORDERS_ID
) ;
CREATE
INDEX PARTNUM_Index ON dm_liveorders_wc_orderitems
(
PARTNUM
) ;
CREATE
INDEX QUANTITY_Index2 ON dm_liveorders_wc_orderitems
(
QUANTITY
) ;
CREATE
INDEX br_no_Index ON dm_liveorders_wc_orderitems
(
br_no
) ;
CREATE
INDEX TOTALPRODUCT_Index2 ON dm_liveorders_wc_orderitems
(
TOTALPRODUCT
) ;
