[Osdldbt-svn] SF.net SVN: osdldbt: [1803] trunk/dbt5/scripts/pgsql/create-indexes.in

[<ma...@us...>]

Revision: 1803
          http://svn.sourceforge.net/osdldbt/?rev=1803&view=rev
Author:   markwkm
Date:     2007-02-03 17:43:42 -0800 (Sat, 03 Feb 2007)

Log Message:
-----------
Reformatted to fix 80 column terminals.

Modified Paths:
--------------
    trunk/dbt5/scripts/pgsql/create-indexes.in

Modified: trunk/dbt5/scripts/pgsql/create-indexes.in
===================================================================
--- trunk/dbt5/scripts/pgsql/create-indexes.in	2007-02-04 01:29:22 UTC (rev 1802)
+++ trunk/dbt5/scripts/pgsql/create-indexes.in	2007-02-04 01:43:42 UTC (rev 1803)
@@ -134,40 +134,108 @@
 	#
 	# Don't need to '|| exit 1' in case the tablespaces already exist.
 	#
-	${PSQL} -e -d ${DBNAME} -c "CREATE ${TS_PK_ACCOUNT_PERMISSION} LOCATION '${TS_PK_ACCOUNT_PERMISSION_DIR}';"
-	${PSQL} -e -d ${DBNAME} -c "CREATE ${TS_PK_CUSTOMER} LOCATION '${TS_PK_CUSTOMER_DIR}';"
-	${PSQL} -e -d ${DBNAME} -c "CREATE ${TS_PK_CUSTOMER_ACCOUNT} LOCATION '${TS_PK_CUSTOMER_ACCOUNT_DIR}';"
-	${PSQL} -e -d ${DBNAME} -c "CREATE ${TS_PK_CUSTOMER_TAXRATE} LOCATION '${TS_PK_CUSTOMER_TAXRATE_DIR}';"
-	${PSQL} -e -d ${DBNAME} -c "CREATE ${TS_PK_HOLDING} LOCATION '${TS_PK_HOLDING_DIR}';"
-	${PSQL} -e -d ${DBNAME} -c "CREATE ${TS_PK_HOLDING_HISTORY} LOCATION '${TS_PK_HOLDING_HISTORY_DIR}';"
-	${PSQL} -e -d ${DBNAME} -c "CREATE ${TS_PK_HOLDING_SUMMARY} LOCATION '${TS_PK_HOLDING_SUMMARY_DIR}';"
-	${PSQL} -e -d ${DBNAME} -c "CREATE ${TS_PK_WATCH_ITEM} LOCATION '${TS_PK_WATCH_ITEM_DIR}';"
-	${PSQL} -e -d ${DBNAME} -c "CREATE ${TS_PK_WATCH_LIST} LOCATION '${TS_PK_WATCH_LIST_DIR}';"
-	${PSQL} -e -d ${DBNAME} -c "CREATE ${TS_PK_BROKER} LOCATION '${TS_PK_BROKER_DIR}';"
-	${PSQL} -e -d ${DBNAME} -c "CREATE ${TS_PK_CASH_TRANSACTION} LOCATION '${TS_PK_CASH_TRANSACTION_DIR}';"
-	${PSQL} -e -d ${DBNAME} -c "CREATE ${TS_PK_CHARGE} LOCATION '${TS_PK_CHARGE_DIR}';"
-	${PSQL} -e -d ${DBNAME} -c "CREATE ${TS_PK_COMMISSION_RATE} LOCATION '${TS_PK_COMMISSION_RATE_DIR}';"
-	${PSQL} -e -d ${DBNAME} -c "CREATE ${TS_PK_SETTLEMENT} LOCATION '${TS_PK_SETTLEMENT_DIR}';"
-	${PSQL} -e -d ${DBNAME} -c "CREATE ${TS_PK_TRADE} LOCATION '${TS_PK_TRADE_DIR}';"
-	${PSQL} -e -d ${DBNAME} -c "CREATE ${TS_PK_TRADE_HISTORY} LOCATION '${TS_PK_TRADE_HISTORY_DIR}';"
-	${PSQL} -e -d ${DBNAME} -c "CREATE ${TS_PK_TRADE_REQUEST} LOCATION '${TS_PK_TRADE_REQUEST_DIR}';"
-	${PSQL} -e -d ${DBNAME} -c "CREATE ${TS_PK_TRADE_TYPE} LOCATION '${TS_PK_TRADE_TYPE_DIR}';"
-	${PSQL} -e -d ${DBNAME} -c "CREATE ${TS_PK_COMPANY} LOCATION '${TS_PK_COMPANY_DIR}';"
-	${PSQL} -e -d ${DBNAME} -c "CREATE ${TS_PK_COMPANY_COMPETITOR} LOCATION '${TS_PK_COMPANY_COMPETITOR_DIR}';"
-	${PSQL} -e -d ${DBNAME} -c "CREATE ${TS_PK_DAILY_MARKET} LOCATION '${TS_PK_DAILY_MARKET_DIR}';"
-	${PSQL} -e -d ${DBNAME} -c "CREATE ${TS_PK_EXCHANGE} LOCATION '${TS_PK_EXCHANGE_DIR}';"
-	${PSQL} -e -d ${DBNAME} -c "CREATE ${TS_PK_FINANCIAL} LOCATION '${TS_PK_FINANCIAL_DIR}';"
-	${PSQL} -e -d ${DBNAME} -c "CREATE ${TS_PK_INDUSTRY} LOCATION '${TS_PK_INDUSTRY_DIR}';"
-	${PSQL} -e -d ${DBNAME} -c "CREATE ${TS_PK_LAST_TRADE} LOCATION '${TS_PK_LAST_TRADE_DIR}';"
-	${PSQL} -e -d ${DBNAME} -c "CREATE ${TS_PK_NEWS_ITEM} LOCATION '${TS_PK_NEWS_ITEM_DIR}';"
-	${PSQL} -e -d ${DBNAME} -c "CREATE ${TS_PK_NEWS_XREF} LOCATION '${TS_PK_NEWS_XREF_DIR}';"
-	${PSQL} -e -d ${DBNAME} -c "CREATE ${TS_PK_SECTOR} LOCATION '${TS_PK_SECTOR_DIR}';"
-	${PSQL} -e -d ${DBNAME} -c "CREATE ${TS_PK_SECURITY} LOCATION '${TS_PK_SECURITY_DIR}';"
-	${PSQL} -e -d ${DBNAME} -c "CREATE ${TS_PK_ADDRESS} LOCATION '${TS_PK_ADDRESS_DIR}';"
-	${PSQL} -e -d ${DBNAME} -c "CREATE ${TS_PK_STATUS_TYPE} LOCATION '${TS_PK_STATUS_TYPE_DIR}';"
-	${PSQL} -e -d ${DBNAME} -c "CREATE ${TS_PK_TAXRATE} LOCATION '${TS_PK_TAXRATE_DIR}';"
-	${PSQL} -e -d ${DBNAME} -c "CREATE ${TS_PK_ZIP_CODE} LOCATION '${TS_PK_ZIP_CODE_DIR}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_PK_ACCOUNT_PERMISSION}
+			    LOCATION '${TS_PK_ACCOUNT_PERMISSION_DIR}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_PK_CUSTOMER} LOCATION '${TS_PK_CUSTOMER_DIR}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_PK_CUSTOMER_ACCOUNT}
+			    LOCATION '${TS_PK_CUSTOMER_ACCOUNT_DIR}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_PK_CUSTOMER_TAXRATE}
+			    LOCATION '${TS_PK_CUSTOMER_TAXRATE_DIR}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_PK_HOLDING} LOCATION '${TS_PK_HOLDING_DIR}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_PK_HOLDING_HISTORY}
+			    LOCATION '${TS_PK_HOLDING_HISTORY_DIR}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_PK_HOLDING_SUMMARY}
+			    LOCATION '${TS_PK_HOLDING_SUMMARY_DIR}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_PK_WATCH_ITEM} LOCATION '${TS_PK_WATCH_ITEM_DIR}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_PK_WATCH_LIST} LOCATION '${TS_PK_WATCH_LIST_DIR}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_PK_BROKER} LOCATION '${TS_PK_BROKER_DIR}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_PK_CASH_TRANSACTION}
+			    LOCATION '${TS_PK_CASH_TRANSACTION_DIR}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_PK_CHARGE} LOCATION '${TS_PK_CHARGE_DIR}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_PK_COMMISSION_RATE}
+			    LOCATION '${TS_PK_COMMISSION_RATE_DIR}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_PK_SETTLEMENT} LOCATION '${TS_PK_SETTLEMENT_DIR}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_PK_TRADE} LOCATION '${TS_PK_TRADE_DIR}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_PK_TRADE_HISTORY}
+			    LOCATION '${TS_PK_TRADE_HISTORY_DIR}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_PK_TRADE_REQUEST}
+			    LOCATION '${TS_PK_TRADE_REQUEST_DIR}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_PK_TRADE_TYPE} LOCATION '${TS_PK_TRADE_TYPE_DIR}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_PK_COMPANY} LOCATION '${TS_PK_COMPANY_DIR}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_PK_COMPANY_COMPETITOR}
+			    LOCATION '${TS_PK_COMPANY_COMPETITOR_DIR}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_PK_DAILY_MARKET}
+			    LOCATION '${TS_PK_DAILY_MARKET_DIR}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_PK_EXCHANGE} LOCATION '${TS_PK_EXCHANGE_DIR}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_PK_FINANCIAL} LOCATION '${TS_PK_FINANCIAL_DIR}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_PK_INDUSTRY} LOCATION '${TS_PK_INDUSTRY_DIR}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_PK_LAST_TRADE} LOCATION '${TS_PK_LAST_TRADE_DIR}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_PK_NEWS_ITEM} LOCATION '${TS_PK_NEWS_ITEM_DIR}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_PK_NEWS_XREF} LOCATION '${TS_PK_NEWS_XREF_DIR}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_PK_SECTOR} LOCATION '${TS_PK_SECTOR_DIR}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_PK_SECURITY} LOCATION '${TS_PK_SECURITY_DIR}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_PK_ADDRESS} LOCATION '${TS_PK_ADDRESS_DIR}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_PK_STATUS_TYPE}
+			    LOCATION '${TS_PK_STATUS_TYPE_DIR}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_PK_TAXRATE} LOCATION '${TS_PK_TAXRATE_DIR}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_PK_ZIP_CODE} LOCATION '${TS_PK_ZIP_CODE_DIR}';"
 
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_I_C_TAX_ID} LOCATION '${TS_I_C_TAX_ID}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_I_CA_C_ID} LOCATION '${TS_I_CA_C_ID}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_I_WL_C_ID} LOCATION '${TS_I_WL_C_ID}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_I_DM_S_SYMB} LOCATION '${TS_I_DM_S_SYMB}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_I_TR_S_SYMB} LOCATION '${TS_I_TR_S_SYMB}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_I_T_ST_ID} LOCATION '${TS_I_T_ST_ID}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_I_T_CA_ID} LOCATION '${TS_I_T_CA_ID}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_I_CO_NAME} LOCATION '${TS_I_CO_NAME}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_I_SECURITY} LOCATION '${TS_I_SECURITY}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_I_HOLDING} LOCATION '${TS_I_HOLDING}';"
+	${PSQL} -e -d ${DBNAME} \
+			-c "CREATE ${TS_I_CHARGE} LOCATION '${TS_I_CHARGE}';"
+
 	#
 	# Rewrite these variables for the actualy index creation.
 	#
@@ -212,203 +280,262 @@
 # Clause 2.2.5.1
 ${PSQL} -e -d ${DBNAME} -c "
 ALTER TABLE account_permission
-ADD CONSTRAINT pk_account_permission PRIMARY KEY (ap_ca_id, ap_tax_id) ${TS_PK_ACCOUNT_PERMISSION};
+ADD CONSTRAINT pk_account_permission
+PRIMARY KEY (ap_ca_id, ap_tax_id)
+${TS_PK_ACCOUNT_PERMISSION};
 " || exit 1 &
 
 # Clause 2.2.5.2
 ${PSQL} -e -d ${DBNAME} -c "
 ALTER TABLE customer
-ADD CONSTRAINT pk_customer PRIMARY KEY (c_id) ${TS_PK_CUSTOMER};
+ADD CONSTRAINT pk_customer
+PRIMARY KEY (c_id)
+${TS_PK_CUSTOMER};
 " || exit 1 &
 
 # Clause 2.2.5.3
 ${PSQL} -e -d ${DBNAME} -c "
 ALTER TABLE customer_account
-ADD CONSTRAINT pk_customer_account PRIMARY KEY (ca_id) ${TS_PK_CUSTOMER_ACCOUNT};
+ADD CONSTRAINT pk_customer_account
+PRIMARY KEY (ca_id)
+${TS_PK_CUSTOMER_ACCOUNT};
 " || exit 1 &
 
 # Clause 2.2.5.4
 ${PSQL} -e -d ${DBNAME} -c "
 ALTER TABLE customer_taxrate
-ADD CONSTRAINT pk_customer_taxrate PRIMARY KEY (cx_tx_id, cx_c_id) ${TS_PK_CUSTOMER_TAXRATE};
+ADD CONSTRAINT pk_customer_taxrate
+PRIMARY KEY (cx_tx_id, cx_c_id)
+${TS_PK_CUSTOMER_TAXRATE};
 " || exit 1 &
 
 # Clause 2.2.5.5
 ${PSQL} -e -d ${DBNAME} -c "
 ALTER TABLE holding
-ADD CONSTRAINT pk_holding PRIMARY KEY (h_t_id) ${TS_PK_HOLDING};
+ADD CONSTRAINT pk_holding
+PRIMARY KEY (h_t_id)
+${TS_PK_HOLDING};
 " || exit 1 &
 
 # Clause 2.2.5.6
 ${PSQL} -e -d ${DBNAME} -c "
 ALTER TABLE holding_history
-ADD CONSTRAINT pk_holding_history PRIMARY KEY (hh_h_t_id, hh_t_id) ${TS_PK_HOLDING_HISTORY};
+ADD CONSTRAINT pk_holding_history
+PRIMARY KEY (hh_h_t_id, hh_t_id)
+${TS_PK_HOLDING_HISTORY};
 " || exit 1 &
 
 # Clause 2.2.5.7
 ${PSQL} -e -d ${DBNAME} -c "
 ALTER TABLE holding_summary
-ADD CONSTRAINT pk_holding_summary PRIMARY KEY (hs_ca_id, hs_s_symb) ${TS_PK_HOLDING_SUMMARY};
+ADD CONSTRAINT pk_holding_summary
+PRIMARY KEY (hs_ca_id, hs_s_symb)
+${TS_PK_HOLDING_SUMMARY};
 " || exit 1 &
 
 # Clause 2.2.5.8
 ${PSQL} -e -d ${DBNAME} -c "
 ALTER TABLE watch_item
 ADD CONSTRAINT pk_watch_item 
-PRIMARY KEY (wi_wl_id, wi_s_symb) ${TS_PK_WATCH_ITEM};
+PRIMARY KEY (wi_wl_id, wi_s_symb)
+${TS_PK_WATCH_ITEM};
 " || exit 1 &
 
 # Clause 2.2.5.9
 ${PSQL} -e -d ${DBNAME} -c "
 ALTER TABLE watch_list
-ADD CONSTRAINT pk_watch_list PRIMARY KEY (wl_id) ${TS_PK_WATCH_LIST};
+ADD CONSTRAINT pk_watch_list
+PRIMARY KEY (wl_id)
+${TS_PK_WATCH_LIST};
 " || exit 1 &
 
 # Clause 2.2.6.1
 ${PSQL} -e -d ${DBNAME} -c "
 ALTER TABLE broker
-ADD CONSTRAINT pk_broker PRIMARY KEY (b_id) ${TS_PK_BROKER};
+ADD CONSTRAINT pk_broker
+PRIMARY KEY (b_id)
+${TS_PK_BROKER};
 " || exit 1 &
 
 # Clause 2.2.6.2
 ${PSQL} -e -d ${DBNAME} -c "
 ALTER TABLE cash_transaction
-ADD CONSTRAINT pk_cash_transaction PRIMARY KEY (ct_t_id) ${TS_PK_CASH_TRANSACTION};
+ADD CONSTRAINT pk_cash_transaction
+PRIMARY KEY (ct_t_id)
+${TS_PK_CASH_TRANSACTION};
 " || exit 1 &
 
 # Clause 2.2.6.3
 ${PSQL} -e -d ${DBNAME} -c "
 ALTER TABLE charge
 ADD CONSTRAINT pk_charge 
-PRIMARY KEY (ch_tt_id, ch_c_tier) ${TS_PK_CHARGE};
+PRIMARY KEY (ch_tt_id, ch_c_tier)
+${TS_PK_CHARGE};
 " || exit 1 &
 
 # Clause 2.2.6.4
 ${PSQL} -e -d ${DBNAME} -c "
 ALTER TABLE commission_rate
 ADD CONSTRAINT pk_commission_rate 
-PRIMARY KEY (cr_c_tier, cr_tt_id, cr_ex_id, cr_from_qty) ${TS_PK_COMMISSION_RATE};
+PRIMARY KEY (cr_c_tier, cr_tt_id, cr_ex_id, cr_from_qty)
+${TS_PK_COMMISSION_RATE};
 " || exit 1 &
 
 # Clause 2.2.6.5
 ${PSQL} -e -d ${DBNAME} -c "
 ALTER TABLE settlement
-ADD CONSTRAINT pk_settlement PRIMARY KEY (se_t_id) ${TS_PK_SETTLEMENT};
+ADD CONSTRAINT pk_settlement PRIMARY KEY (se_t_id)
+${TS_PK_SETTLEMENT};
 " || exit 1 &
 
 # Clause 2.2.6.6
 ${PSQL} -e -d ${DBNAME} -c "
 ALTER TABLE trade
-ADD CONSTRAINT pk_trade PRIMARY KEY (t_id) ${TS_PK_TRADE};
+ADD CONSTRAINT pk_trade PRIMARY KEY (t_id)
+${TS_PK_TRADE};
 " || exit 1 &
 
 # Clause 2.2.6.7
 ${PSQL} -e -d ${DBNAME} -c "
 ALTER TABLE trade_history
-ADD CONSTRAINT pk_trade_history PRIMARY KEY (th_t_id, th_st_id) ${TS_PK_TRADE_HISTORY};
+ADD CONSTRAINT pk_trade_history
+PRIMARY KEY (th_t_id, th_st_id)
+${TS_PK_TRADE_HISTORY};
 " || exit 1 &
 
 # Clause 2.2.6.8
 ${PSQL} -e -d ${DBNAME} -c "
 ALTER TABLE trade_request
-ADD CONSTRAINT pk_trade_request PRIMARY KEY (tr_t_id) ${TS_PK_TRADE_REQUEST};
+ADD CONSTRAINT pk_trade_request
+PRIMARY KEY (tr_t_id)
+${TS_PK_TRADE_REQUEST};
 " || exit 1 &
 
 # Clause 2.2.6.9
 ${PSQL} -e -d ${DBNAME} -c "
 ALTER TABLE trade_type
-ADD CONSTRAINT pk_trade_type PRIMARY KEY (tt_id) ${TS_PK_TRADE_TYPE};
+ADD CONSTRAINT pk_trade_type
+PRIMARY KEY (tt_id)
+${TS_PK_TRADE_TYPE};
 " || exit 1 &
 
 # Clause 2.2.7.1
 ${PSQL} -e -d ${DBNAME} -c "
 ALTER TABLE company
-ADD CONSTRAINT pk_company PRIMARY KEY (co_id) ${TS_PK_COMPANY};
+ADD CONSTRAINT pk_company
+PRIMARY KEY (co_id)
+${TS_PK_COMPANY};
 " || exit 1 &
 
 # Clause 2.2.7.2
 ${PSQL} -e -d ${DBNAME} -c "
 ALTER TABLE company_competitor
 ADD CONSTRAINT pk_company_competitor 
-PRIMARY KEY (cp_co_id, cp_comp_co_id, cp_in_id) ${TS_PK_COMPANY_COMPETITOR};
+PRIMARY KEY (cp_co_id, cp_comp_co_id, cp_in_id)
+${TS_PK_COMPANY_COMPETITOR};
 " || exit 1 &
 
 # Clause 2.2.7.3
 ${PSQL} -e -d ${DBNAME} -c "
 ALTER TABLE daily_market
-ADD CONSTRAINT pk_daily_market PRIMARY KEY (dm_date, dm_s_symb) ${TS_PK_DAILY_MARKET};
+ADD CONSTRAINT pk_daily_market
+PRIMARY KEY (dm_date, dm_s_symb)
+${TS_PK_DAILY_MARKET};
 " || exit 1 &
 
 # Clause 2.2.7.4
 ${PSQL} -e -d ${DBNAME} -c "
 ALTER TABLE exchange
-ADD CONSTRAINT pk_exchange PRIMARY KEY (ex_id) ${TS_PK_EXCHANGE};
+ADD CONSTRAINT pk_exchange
+PRIMARY KEY (ex_id)
+${TS_PK_EXCHANGE};
 " || exit 1 &
 
 # Clause 2.2.7.5
 ${PSQL} -e -d ${DBNAME} -c "
 ALTER TABLE financial
-ADD CONSTRAINT pk_financial PRIMARY KEY (fi_co_id, fi_year, fi_qtr) ${TS_PK_FINANCIAL};
+ADD CONSTRAINT pk_financial
+PRIMARY KEY (fi_co_id, fi_year, fi_qtr)
+${TS_PK_FINANCIAL};
 " || exit 1 &
 
 # Clause 2.2.7.6
 ${PSQL} -e -d ${DBNAME} -c "
 ALTER TABLE industry
-ADD CONSTRAINT pk_industry PRIMARY KEY (in_id) ${TS_PK_INDUSTRY};
+ADD CONSTRAINT pk_industry
+PRIMARY KEY (in_id)
+${TS_PK_INDUSTRY};
 " || exit 1 &
 
 # Clause 2.2.7.7
 ${PSQL} -e -d ${DBNAME} -c "
 ALTER TABLE last_trade
-ADD CONSTRAINT pk_last_trade PRIMARY KEY (lt_s_symb) ${TS_PK_LAST_TRADE};
+ADD CONSTRAINT pk_last_trade
+PRIMARY KEY (lt_s_symb)
+${TS_PK_LAST_TRADE};
 " || exit 1 &
 
 # Clause 2.2.7.8
 ${PSQL} -e -d ${DBNAME} -c "
 ALTER TABLE news_item
-ADD CONSTRAINT pk_news_item PRIMARY KEY (ni_id) ${TS_PK_NEWS_ITEM};
+ADD CONSTRAINT pk_news_item
+PRIMARY KEY (ni_id)
+${TS_PK_NEWS_ITEM};
 " || exit 1 &
 
 # Clause 2.2.7.9
 ${PSQL} -e -d ${DBNAME} -c "
 ALTER TABLE news_xref
-ADD CONSTRAINT pk_news_xref PRIMARY KEY (nx_ni_id, nx_co_id) ${TS_PK_NEWS_XREF};
+ADD CONSTRAINT pk_news_xref
+PRIMARY KEY (nx_ni_id, nx_co_id)
+${TS_PK_NEWS_XREF};
 " || exit 1 &
 
 # Clause 2.2.7.10
 ${PSQL} -e -d ${DBNAME} -c "
 ALTER TABLE sector
-ADD CONSTRAINT pk_sector PRIMARY KEY (sc_id) ${TS_PK_SECTOR};
+ADD CONSTRAINT pk_sector
+PRIMARY KEY (sc_id)
+${TS_PK_SECTOR};
 " || exit 1 &
 
 # Clause 2.2.7.11
 ${PSQL} -e -d ${DBNAME} -c "
 ALTER TABLE security
-ADD CONSTRAINT pk_security PRIMARY KEY (s_symb) ${TS_PK_SECURITY};
+ADD CONSTRAINT pk_security
+PRIMARY KEY (s_symb)
+${TS_PK_SECURITY};
 " || exit 1 &
 
 # Clause 2.2.8.1
 ${PSQL} -e -d ${DBNAME} -c "
 ALTER TABLE address
-ADD CONSTRAINT pk_address PRIMARY KEY (ad_id) ${TS_PK_ADDRESS};
+ADD CONSTRAINT pk_address
+PRIMARY KEY (ad_id) ${TS_PK_ADDRESS};
 " || exit 1 &
 
 # Clause 2.2.8.2
 ${PSQL} -e -d ${DBNAME} -c "
 ALTER TABLE status_type
-ADD CONSTRAINT pk_status_type PRIMARY KEY (st_id) ${TS_PK_STATUS_TYPE};
+ADD CONSTRAINT pk_status_type
+PRIMARY KEY (st_id)
+${TS_PK_STATUS_TYPE};
 " || exit 1 &
 
 # Clause 2.2.8.3
 ${PSQL} -e -d ${DBNAME} -c "
 ALTER TABLE taxrate
-ADD CONSTRAINT pk_taxrate PRIMARY KEY (tx_id) ${TS_PK_TAXRATE};
+ADD CONSTRAINT pk_taxrate
+PRIMARY KEY (tx_id)
+${TS_PK_TAXRATE};
 " || exit 1 &
 
 # Clause 2.2.8.4
 ${PSQL} -e -d ${DBNAME} -c "
 ALTER TABLE zip_code
-ADD CONSTRAINT pk_zip_code PRIMARY KEY (zc_code) ${TS_PK_ZIP_CODE};
+ADD CONSTRAINT pk_zip_code
+PRIMARY KEY (zc_code)
+${TS_PK_ZIP_CODE};
 " || exit 1 &
 
 sleep 1


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.