m2u-upass-admin / DBScript / create_table.sql @ 150:394c7bd4fa4e
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 |