geronimo-scm mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From cjbly...@apache.org
Subject svn commit: r557771 - in /geronimo/daytrader/trunk/bin/dbscripts: db2/Table.ddl oracle/Table.ddl
Date Thu, 19 Jul 2007 21:04:05 GMT
Author: cjblythe
Date: Thu Jul 19 14:04:04 2007
New Revision: 557771

URL: http://svn.apache.org/viewvc?view=rev&rev=557771
Log:
Updated DB2 and Oracle ddls to match Derby ddl and ddls located in war

Modified:
    geronimo/daytrader/trunk/bin/dbscripts/db2/Table.ddl
    geronimo/daytrader/trunk/bin/dbscripts/oracle/Table.ddl

Modified: geronimo/daytrader/trunk/bin/dbscripts/db2/Table.ddl
URL: http://svn.apache.org/viewvc/geronimo/daytrader/trunk/bin/dbscripts/db2/Table.ddl?view=diff&rev=557771&r1=557770&r2=557771
==============================================================================
--- geronimo/daytrader/trunk/bin/dbscripts/db2/Table.ddl (original)
+++ geronimo/daytrader/trunk/bin/dbscripts/db2/Table.ddl Thu Jul 19 14:04:04 2007
@@ -22,7 +22,7 @@
 DROP TABLE ORDEREJB;
 
 CREATE TABLE HOLDINGEJB
-  (PURCHASEPRICE DECIMAL(10, 2),
+  (PURCHASEPRICE DECIMAL(14, 2),
    HOLDINGID INTEGER NOT NULL,
    QUANTITY DOUBLE NOT NULL,
    PURCHASEDATE TIMESTAMP,
@@ -44,11 +44,11 @@
   ADD CONSTRAINT PK_ACCOUNTPROFILE2 PRIMARY KEY (USERID);
 
 CREATE TABLE QUOTEEJB
-  (LOW DECIMAL(10, 2),
-   OPEN1 DECIMAL(10, 2),
+  (LOW DECIMAL(14, 2),
+   OPEN1 DECIMAL(14, 2),
    VOLUME DOUBLE NOT NULL,
-   PRICE DECIMAL(10, 2),
-   HIGH DECIMAL(10, 2),
+   PRICE DECIMAL(14, 2),
+   HIGH DECIMAL(14, 2),
    COMPANYNAME VARCHAR(250),
    SYMBOL VARCHAR(250) NOT NULL,
    CHANGE1 DOUBLE NOT NULL);
@@ -65,9 +65,9 @@
 
 CREATE TABLE ACCOUNTEJB
   (CREATIONDATE TIMESTAMP,
-   OPENBALANCE DECIMAL(10, 2),
+   OPENBALANCE DECIMAL(14, 2),
    LOGOUTCOUNT INTEGER NOT NULL,
-   BALANCE DECIMAL(10, 2),
+   BALANCE DECIMAL(14, 2),
    ACCOUNTID INTEGER NOT NULL,
    LASTLOGIN TIMESTAMP,
    LOGINCOUNT INTEGER NOT NULL,
@@ -77,11 +77,11 @@
   ADD CONSTRAINT PK_ACCOUNTEJB PRIMARY KEY (ACCOUNTID);
 
 CREATE TABLE ORDEREJB
-  (ORDERFEE DECIMAL(10, 2),
+  (ORDERFEE DECIMAL(14, 2),
    COMPLETIONDATE TIMESTAMP,
    ORDERTYPE VARCHAR(250),
    ORDERSTATUS VARCHAR(250),
-   PRICE DECIMAL(10, 2),
+   PRICE DECIMAL(14, 2),
    QUANTITY DOUBLE NOT NULL,
    OPENDATE TIMESTAMP,
    ORDERID INTEGER NOT NULL,
@@ -98,11 +98,10 @@
 ALTER TABLE KEYGENEJB VOLATILE;
 ALTER TABLE ACCOUNTEJB VOLATILE;
 ALTER TABLE ORDEREJB VOLATILE;
-    
-CREATE INDEX a.profile_userid on accountejb(profile_userid);
-CREATE INDEX h.account_accountid on holdingejb(account_accountid);
-CREATE INDEX o.account_accountid on orderejb(account_accountid);
-CREATE INDEX o.holding_holdingid on orderejb(holding_holdingid);
-CREATE INDEX o.orderstatus on orderejb(orderstatus);
-CREATE INDEX o.ordertype on orderejb(ordertype);
+
+CREATE INDEX ACCOUNT_USERID ON ACCOUNTEJB(PROFILE_USERID);
+CREATE INDEX HOLDING_ACCOUNTID ON HOLDINGEJB(ACCOUNT_ACCOUNTID);
+CREATE INDEX ORDER_ACCOUNTID ON ORDEREJB(ACCOUNT_ACCOUNTID);
+CREATE INDEX ORDER_HOLDINGID ON ORDEREJB(HOLDING_HOLDINGID);
+CREATE INDEX CLOSED_ORDERS ON ORDEREJB(ACCOUNT_ACCOUNTID,ORDERSTATUS);
   

Modified: geronimo/daytrader/trunk/bin/dbscripts/oracle/Table.ddl
URL: http://svn.apache.org/viewvc/geronimo/daytrader/trunk/bin/dbscripts/oracle/Table.ddl?view=diff&rev=557771&r1=557770&r2=557771
==============================================================================
--- geronimo/daytrader/trunk/bin/dbscripts/oracle/Table.ddl (original)
+++ geronimo/daytrader/trunk/bin/dbscripts/oracle/Table.ddl Thu Jul 19 14:04:04 2007
@@ -20,9 +20,8 @@
 DROP TABLE ACCOUNTEJB cascade constraints;
 DROP TABLE ORDEREJB cascade constraints;
 
-
 CREATE TABLE HOLDINGEJB
-  (PURCHASEPRICE DECIMAL(10, 2) NULL,
+  (PURCHASEPRICE DECIMAL(14, 2) NULL,
    HOLDINGID INTEGER NOT NULL,
    QUANTITY NUMBER NOT NULL,
    PURCHASEDATE DATE NULL,
@@ -44,11 +43,11 @@
   ADD CONSTRAINT PK_ACCOUNTPROFILEEJB PRIMARY KEY (USERID);
 
 CREATE TABLE QUOTEEJB
-  (LOW DECIMAL(10, 2) NULL,
-   OPEN1 DECIMAL(10, 2) NULL,
+  (LOW DECIMAL(14, 2) NULL,
+   OPEN1 DECIMAL(14, 2) NULL,
    VOLUME NUMBER NOT NULL,
-   PRICE DECIMAL(10, 2) NULL,
-   HIGH DECIMAL(10, 2) NULL,
+   PRICE DECIMAL(14, 2) NULL,
+   HIGH DECIMAL(14, 2) NULL,
    COMPANYNAME VARCHAR2(250) NULL,
    SYMBOL VARCHAR2(250) NOT NULL,
    CHANGE1 NUMBER NOT NULL);
@@ -65,9 +64,9 @@
 
 CREATE TABLE ACCOUNTEJB
   (CREATIONDATE DATE NULL,
-   OPENBALANCE DECIMAL(10, 2) NULL,
+   OPENBALANCE DECIMAL(14, 2) NULL,
    LOGOUTCOUNT INTEGER NOT NULL,
-   BALANCE DECIMAL(10, 2) NULL,
+   BALANCE DECIMAL(14, 2) NULL,
    ACCOUNTID INTEGER NOT NULL,
    LASTLOGIN DATE NULL,
    LOGINCOUNT INTEGER NOT NULL,
@@ -77,11 +76,11 @@
   ADD CONSTRAINT PK_ACCOUNTEJB PRIMARY KEY (ACCOUNTID);
 
 CREATE TABLE ORDEREJB
-  (ORDERFEE DECIMAL(10, 2) NULL,
+  (ORDERFEE DECIMAL(14, 2) NULL,
    COMPLETIONDATE DATE NULL,
    ORDERTYPE VARCHAR2(250) NULL,
    ORDERSTATUS VARCHAR2(250) NULL,
-   PRICE DECIMAL(10, 2) NULL,
+   PRICE DECIMAL(14, 2) NULL,
    QUANTITY NUMBER NOT NULL,
    OPENDATE DATE NULL,
    ORDERID INTEGER NOT NULL,
@@ -92,10 +91,9 @@
 ALTER TABLE ORDEREJB
   ADD CONSTRAINT PK_ORDEREJB PRIMARY KEY (ORDERID);
 
-CREATE INDEX a_profile_userid on accountejb(profile_userid);
-CREATE INDEX h_account_accountid on holdingejb(account_accountid);
-CREATE INDEX o_account_accountid on orderejb(account_accountid);
-CREATE INDEX o_holding_holdingid on orderejb(holding_holdingid);
-CREATE INDEX o_orderstatus on orderejb(orderstatus);
-CREATE INDEX o_ordertype on orderejb(ordertype);
+CREATE INDEX ACCOUNT_USERID ON ACCOUNTEJB(PROFILE_USERID);
+CREATE INDEX HOLDING_ACCOUNTID ON HOLDINGEJB(ACCOUNT_ACCOUNTID);
+CREATE INDEX ORDER_ACCOUNTID ON ORDEREJB(ACCOUNT_ACCOUNTID);
+CREATE INDEX ORDER_HOLDINGID ON ORDEREJB(HOLDING_HOLDINGID);
+CREATE INDEX CLOSED_ORDERS ON ORDEREJB(ACCOUNT_ACCOUNTID,ORDERSTATUS);
   



Mime
View raw message