[h2] Re: Potential never ending loop?

[Seb N/A]

Hello,

Sorry I have taken so long to respond, I was otherwise occupied.
Find attached the schema for tables involved.

Kind regards,
Seb

-- 
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 h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
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 
   ) ;