m2u-upass-admin / DBScript / create_table.sql @ 120:ae1d99468601
History | View | Annotate | Download (5.84 KB)
| 1 | 0:ea666cc7880e | hadi | set verify off
|
|---|---|---|---|
| 2 | spool create_mss_table_log.txt |
||
| 3 | |||
| 4 | |||
| 5 | PROMPT ******* CREATE ADMIN_AUDIT_LOG TABLE ******* |
||
| 6 | @/home/oracle/MPIFinalScript/admin_audit_log
|
||
| 7 | |||
| 8 | PROMPT ******* CREATE IB_USER TABLE ******* |
||
| 9 | @/home/oracle/MPIFinalScript/ib_user
|
||
| 10 | |||
| 11 | PROMPT ******* CREATE ADMIN_ROLE TABLE ******* |
||
| 12 | @/home/oracle/MPIFinalScript/admin_role
|
||
| 13 | |||
| 14 | PROMPT ******* CREATE ADMIN_GROUP TABLE ******* |
||
| 15 | @/home/oracle/MPIFinalScript/admin_group
|
||
| 16 | |||
| 17 | PROMPT ******* CREATE ADMIN_USER_PROFILE TABLE ******* |
||
| 18 | @/home/oracle/MPIFinalScript/admin_user_profile
|
||
| 19 | |||
| 20 | PROMPT ******* CREATE ADMIN_NAVIGATION TABLE ******* |
||
| 21 | @/home/oracle/MPIFinalScript/admin_navigation
|
||
| 22 | |||
| 23 | PROMPT ******* CREATE ADMIN_NAVIGATION_GROUP TABLE ******* |
||
| 24 | @/home/oracle/MPIFinalScript/admin_navigation_group
|
||
| 25 | |||
| 26 | PROMPT ******* CREATE ADMIN_USER_SECURITY TABLE ******* |
||
| 27 | @/home/oracle/MPIFinalScript/admin_user_security
|
||
| 28 | |||
| 29 | PROMPT ******* CREATE IB_ORGANIZATION TABLE ******* |
||
| 30 | @/home/oracle/MPIFinalScript/ib_organization
|
||
| 31 | |||
| 32 | PROMPT ******* CREATE IB_ROLE TABLE ******* |
||
| 33 | @/home/oracle/MPIFinalScript/ib_role
|
||
| 34 | |||
| 35 | PROMPT ******* CREATE IB_GROUP TABLE ******* |
||
| 36 | @/home/oracle/MPIFinalScript/ib_group
|
||
| 37 | |||
| 38 | PROMPT ******* CREATE IB_CUST_PROFILE TABLE ******* |
||
| 39 | @/home/oracle/MPIFinalScript/ib_cust_profile
|
||
| 40 | |||
| 41 | PROMPT ******* CREATE IB_CUST_ACCOUNTS TABLE ******* |
||
| 42 | @/home/oracle/MPIFinalScript/ib_cust_accounts
|
||
| 43 | |||
| 44 | PROMPT ******* CREATE IB_USER_SECURITY ******* |
||
| 45 | @/home/oracle/MPIFinalScript/ib_user_security
|
||
| 46 | |||
| 47 | PROMPT ******* CREATE IB_NAVIGATION TABLE ******* |
||
| 48 | @/home/oracle/MPIFinalScript/ib_navigation
|
||
| 49 | |||
| 50 | PROMPT ******* CREATE IB_NAVIGATION_GROUP TABLE ******* |
||
| 51 | @/home/oracle/MPIFinalScript/ib_navigation_group
|
||
| 52 | |||
| 53 | PROMPT ******* CREATE IB_USER_TRANSACTION_HISTORY TABLE ******* |
||
| 54 | @/home/oracle/MPIFinalScript/ib_user_transaction_history
|
||
| 55 | |||
| 56 | PROMPT ******* CREATE IB_USER_PRINT_RECEIPT TABLE ******* |
||
| 57 | @/home/oracle/MPIFinalScript/ib_user_print_receipt
|
||
| 58 | |||
| 59 | PROMPT ******* CREATE IB_LOGIN_HISTORY TABLE ******* |
||
| 60 | @/home/oracle/MPIFinalScript/ib_login_history
|
||
| 61 | |||
| 62 | PROMPT ******* CREATE IB_CONTENT_TYPE TABLE ******* |
||
| 63 | @/home/oracle/MPIFinalScript/ib_content_type
|
||
| 64 | |||
| 65 | PROMPT ******* CREATE IB_CONTENT_CATEGORY TABLE ******* |
||
| 66 | @/home/oracle/MPIFinalScript/ib_content_category
|
||
| 67 | |||
| 68 | PROMPT ******* CREATE IB_BANCNET_LIST TABLE ******* |
||
| 69 | @/home/oracle/MPIFinalScript/ib_bancnet_list
|
||
| 70 | |||
| 71 | PROMPT ******* CREATE IB_BANK_BRANCH TABLE ******* |
||
| 72 | @/home/oracle/MPIFinalScript/ib_bank_branch
|
||
| 73 | |||
| 74 | PROMPT ******* CREATE IB_CURRENCY_CODE TABLE ******* |
||
| 75 | @/home/oracle/MPIFinalScript/ib_currency_code
|
||
| 76 | |||
| 77 | PROMPT ******* CREATE IB_PAYEE TABLE ******* |
||
| 78 | @/home/oracle/MPIFinalScript/ib_payee
|
||
| 79 | |||
| 80 | PROMPT ******* CREATE IB_SERVICE_INFO TABLE ******* |
||
| 81 | @/home/oracle/MPIFinalScript/ib_service_info
|
||
| 82 | |||
| 83 | PROMPT ******* CREATE IB_PRODUCT_TYPE TABLE ******* |
||
| 84 | @/home/oracle/MPIFinalScript/ib_product_type
|
||
| 85 | |||
| 86 | PROMPT ******* CREATE IB_SERVICE_TYPE TABLE ******* |
||
| 87 | @/home/oracle/MPIFinalScript/ib_service_type
|
||
| 88 | |||
| 89 | PROMPT ******* CREATE IB_SERVICE_LIST TABLE ******* |
||
| 90 | @/home/oracle/MPIFinalScript/ib_service_list
|
||
| 91 | |||
| 92 | PROMPT ******* CREATE IB_TD_TERM TABLE ******* |
||
| 93 | @/home/oracle/MPIFinalScript/ib_td_term
|
||
| 94 | |||
| 95 | PROMPT ******* CREATE IB_TD_INFO TABLE ******* |
||
| 96 | @/home/oracle/MPIFinalScript/ib_td_info
|
||
| 97 | |||
| 98 | PROMPT ******* CREATE IB_ACCOUNT_TYPE TABLE ******* |
||
| 99 | @/home/oracle/MPIFinalScript/ib_account_type
|
||
| 100 | |||
| 101 | PROMPT ******* CREATE SEQUENCE TABLE ******* |
||
| 102 | @/home/oracle/MPIFinalScript/ib_sequence
|
||
| 103 | |||
| 104 | PROMPT ******* CREATE IB_AUTO_LOAN TABLE ******* |
||
| 105 | @/home/oracle/MPIFinalScript/ib_auto_loan
|
||
| 106 | |||
| 107 | PROMPT ******* CREATE IB_PERSONAL_LOAN TABLE ******* |
||
| 108 | @/home/oracle/MPIFinalScript/ib_personal_loan
|
||
| 109 | |||
| 110 | PROMPT ******* CREATE IB_ADAPT TABLE ******* |
||
| 111 | @/home/oracle/MPIFinalScript/ib_adapt
|
||
| 112 | |||
| 113 | PROMPT ******* INSERT_DATA FOR IB_USER ******* |
||
| 114 | @/home/oracle/MPIFinalScript/insert_ib_user
|
||
| 115 | |||
| 116 | PROMPT ******* INSERT_DATA FOR ADMIN_ROLE ******* |
||
| 117 | @/home/oracle/MPIFinalScript/insert_admin_role
|
||
| 118 | |||
| 119 | PROMPT ******* INSERT_DATA FOR ADMIN_GROUP ******* |
||
| 120 | @/home/oracle/MPIFinalScript/insert_admin_group
|
||
| 121 | |||
| 122 | PROMPT ******* INSERT_DATA FOR ADMIN_USER_PROFILE ******* |
||
| 123 | @/home/oracle/MPIFinalScript/insert_admin_user_profile
|
||
| 124 | |||
| 125 | PROMPT ******* INSERT_DATA FOR ADMIN_NAVIGATION ******* |
||
| 126 | @/home/oracle/MPIFinalScript/insert_admin_navigation
|
||
| 127 | |||
| 128 | PROMPT ******* INSERT_DATA FOR ADMIN_NAVIGATION_GROUP ******* |
||
| 129 | @/home/oracle/MPIFinalScript/insert_admin_navigation_group
|
||
| 130 | |||
| 131 | PROMPT ******* INSERT_DATA FOR ADMIN_USER_SECURITY ******* |
||
| 132 | @/home/oracle/MPIFinalScript/insert_admin_user_security
|
||
| 133 | |||
| 134 | PROMPT ******* INSERT_DATA FOR IB_ORGANIZATION ******* |
||
| 135 | @/home/oracle/MPIFinalScript/insert_ib_organization
|
||
| 136 | |||
| 137 | PROMPT ******* INSERT_DATA FOR IB_ROLE ******* |
||
| 138 | @/home/oracle/MPIFinalScript/insert_ib_role
|
||
| 139 | |||
| 140 | PROMPT ******* INSERT_DATA FOR IB_GROUP ******* |
||
| 141 | @/home/oracle/MPIFinalScript/insert_ib_group
|
||
| 142 | |||
| 143 | PROMPT ******* INSERT_DATA FOR IB_USER_SECURITY ******* |
||
| 144 | @/home/oracle/MPIFinalScript/insert_ib_user_security
|
||
| 145 | |||
| 146 | PROMPT ******* INSERT_DATA FOR IB_NAVIGATION ******* |
||
| 147 | @/home/oracle/MPIFinalScript/insert_ib_navigation
|
||
| 148 | |||
| 149 | PROMPT ******* INSERT_DATA FOR IB_NAVIGATION_GROUP ******* |
||
| 150 | @/home/oracle/MPIFinalScript/insert_ib_navigation_group
|
||
| 151 | |||
| 152 | PROMPT ******* INSERT_DATA FOR IB_CONTENT_TYPE ******* |
||
| 153 | @/home/oracle/MPIFinalScript/insert_ib_content_type
|
||
| 154 | |||
| 155 | PROMPT ******* INSERT_DATA FOR IB_CONTENT_CATEGORY ******* |
||
| 156 | @/home/oracle/MPIFinalScript/insert_ib_content_category
|
||
| 157 | |||
| 158 | PROMPT ******* INSERT_DATA FOR IB_BANCNET_LIST ******* |
||
| 159 | @/home/oracle/MPIFinalScript/insert_ib_bancnet_list
|
||
| 160 | |||
| 161 | PROMPT ******* INSERT_DATA FOR IB_PAYEE ******* |
||
| 162 | @/home/oracle/MPIFinalScript/insert_ib_payee
|
||
| 163 | |||
| 164 | PROMPT ******* INSERT_DATA FOR IB_SERVICE_INFO ******* |
||
| 165 | @/home/oracle/MPIFinalScript/insert_ib_service_info
|
||
| 166 | |||
| 167 | PROMPT ******* INSERT_DATA FOR IB_PRODUCT_TYPE ******* |
||
| 168 | @/home/oracle/MPIFinalScript/insert_ib_product_type
|
||
| 169 | |||
| 170 | PROMPT ******* INSERT_DATA FOR IB_SERVICE_TYPE ******* |
||
| 171 | @/home/oracle/MPIFinalScript/insert_ib_service_type
|
||
| 172 | |||
| 173 | PROMPT ******* INSERT_DATA FOR IB_SERVICE_LIST ******* |
||
| 174 | @/home/oracle/MPIFinalScript/insert_ib_service_list
|
||
| 175 | |||
| 176 | PROMPT ******* INSERT_DATA FOR IB_TD_INFO ******* |
||
| 177 | @/home/oracle/MPIFinalScript/insert_ib_td_info
|
||
| 178 | |||
| 179 | PROMPT ******* INSERT_DATA FOR IB_ACCOUNT_TYPE ******* |
||
| 180 | @/home/oracle/MPIFinalScript/insert_ib_account_type
|
||
| 181 | |||
| 182 | spool off |