source: branches/feature-module-update/html/install/sql/add/mtb_tables_oracle.sql @ 15528

Revision 15528, 4.9 KB checked in by nanasess, 13 years ago (diff)

FIXME 暫定 commit

Line 
1CREATE TABLE mtb_permission (
2    id varchar2(128),
3    name varchar2(4000),
4    disp_order number(4) NOT NULL,
5    PRIMARY KEY (id)
6);
7
8CREATE TABLE mtb_disable_logout (
9    id number(4),
10    name varchar2(4000),
11    disp_order number(4) NOT NULL ,
12    PRIMARY KEY (id)
13);
14
15CREATE TABLE mtb_authority (
16    id number(4),
17    name varchar2(4000),
18    disp_order number(4) NOT NULL ,
19    PRIMARY KEY (id)
20);
21
22CREATE TABLE mtb_work (
23    id number(4),
24    name varchar2(4000),
25    disp_order number(4) NOT NULL ,
26    PRIMARY KEY (id)
27);
28
29CREATE TABLE mtb_disp (
30    id number(4),
31    name varchar2(4000),
32    disp_order number(4) NOT NULL ,
33    PRIMARY KEY (id)
34);
35
36CREATE TABLE mtb_class (
37    id number(4),
38    name varchar2(4000),
39    disp_order number(4) NOT NULL ,
40    PRIMARY KEY (id)
41);
42
43CREATE TABLE mtb_sdisp_order (
44    id number(4),
45    name varchar2(4000),
46    disp_order number(4) NOT NULL ,
47    PRIMARY KEY (id)
48);
49
50CREATE TABLE mtb_status (
51    id number(4),
52    name varchar2(4000),
53    disp_order number(4) NOT NULL ,
54    PRIMARY KEY (id)
55);
56
57CREATE TABLE mtb_status_image (
58    id number(4),
59    name varchar2(4000),
60    disp_order number(4) NOT NULL ,
61    PRIMARY KEY (id)
62);
63
64CREATE TABLE mtb_allowed_tag (
65    id number(4),
66    name varchar2(4000),
67    disp_order number(4) NOT NULL ,
68    PRIMARY KEY (id)
69);
70
71CREATE TABLE mtb_page_max (
72    id number(4),
73    name varchar2(4000),
74    disp_order number(4) NOT NULL ,
75    PRIMARY KEY (id)
76);
77
78CREATE TABLE mtb_magazine_type (
79    id number(4),
80    name varchar2(4000),
81    disp_order number(4) NOT NULL ,
82    PRIMARY KEY (id)
83);
84
85CREATE TABLE mtb_mail_magazine_type (
86    id number(4),
87    name varchar2(4000),
88    disp_order number(4) NOT NULL ,
89    PRIMARY KEY (id)
90);
91
92CREATE TABLE mtb_recommend (
93    id number(4),
94    name varchar2(4000),
95    disp_order number(4) NOT NULL ,
96    PRIMARY KEY (id)
97);
98
99CREATE TABLE mtb_taxrule (
100    id number(4),
101    name varchar2(4000),
102    disp_order number(4) NOT NULL ,
103    PRIMARY KEY (id)
104);
105
106CREATE TABLE mtb_mail_template (
107    id number(4),
108    name varchar2(4000),
109    disp_order number(4) NOT NULL ,
110    PRIMARY KEY (id)
111);
112
113CREATE TABLE mtb_mail_tpl_path (
114    id number(4),
115    name varchar2(4000),
116    disp_order number(4) NOT NULL ,
117    PRIMARY KEY (id)
118);
119
120CREATE TABLE mtb_job (
121    id number(4),
122    name varchar2(4000),
123    disp_order number(4) NOT NULL ,
124    PRIMARY KEY (id)
125);
126
127CREATE TABLE mtb_reminder (
128    id number(4),
129    name varchar2(4000),
130    disp_order number(4) NOT NULL ,
131    PRIMARY KEY (id)
132);
133
134CREATE TABLE mtb_sex (
135    id number(4),
136    name varchar2(4000),
137    disp_order number(4) NOT NULL ,
138    PRIMARY KEY (id)
139);
140
141CREATE TABLE mtb_page_rows (
142    id number(4),
143    name varchar2(4000),
144    disp_order number(4) NOT NULL ,
145    PRIMARY KEY (id)
146);
147
148CREATE TABLE mtb_mail_type (
149    id number(4),
150    name varchar2(4000),
151    disp_order number(4) NOT NULL ,
152    PRIMARY KEY (id)
153);
154
155CREATE TABLE mtb_order_status (
156    id number(4),
157    name varchar2(4000),
158    disp_order number(4) NOT NULL ,
159    PRIMARY KEY (id)
160);
161
162CREATE TABLE mtb_product_status_color (
163    id number(4),
164    name varchar2(4000),
165    disp_order number(4) NOT NULL ,
166    PRIMARY KEY (id)
167);
168
169CREATE TABLE mtb_order_status_color (
170    id number(4),
171    name varchar2(4000),
172    disp_order number(4) NOT NULL ,
173    PRIMARY KEY (id)
174);
175
176CREATE TABLE mtb_wday (
177    id number(4),
178    name varchar2(4000),
179    disp_order number(4) NOT NULL ,
180    PRIMARY KEY (id)
181);
182
183CREATE TABLE mtb_delivery_date (
184    id number(4),
185    name varchar2(4000),
186    disp_order number(4) NOT NULL ,
187    PRIMARY KEY (id)
188);
189
190CREATE TABLE mtb_product_list_max (
191    id number(4),
192    name varchar2(4000),
193    disp_order number(4) NOT NULL ,
194    PRIMARY KEY (id)
195);
196
197CREATE TABLE mtb_convenience (
198    id number(4),
199    name varchar2(4000),
200    disp_order number(4) NOT NULL ,
201    PRIMARY KEY (id)
202);
203
204CREATE TABLE mtb_conveni_message (
205    id number(4),
206    name varchar2(4000),
207    disp_order number(4) NOT NULL ,
208    PRIMARY KEY (id)
209);
210
211CREATE TABLE mtb_db (
212    id number(4),
213    name varchar2(4000),
214    disp_order number(4) NOT NULL ,
215    PRIMARY KEY (id)
216);
217
218CREATE TABLE mtb_target (
219    id number(4),
220    name varchar2(4000),
221    disp_order number(4) NOT NULL ,
222    PRIMARY KEY (id)
223);
224
225CREATE TABLE mtb_review_deny_url (
226    id number(4),
227    name varchar2(4000),
228    disp_order number(4) NOT NULL ,
229    PRIMARY KEY (id)
230);
231
232CREATE TABLE mtb_track_back_status (
233    id number(4),
234    name varchar2(4000),
235    disp_order number(4) NOT NULL ,
236    PRIMARY KEY (id)
237);
238
239CREATE TABLE mtb_site_control_track_back (
240    id number(4),
241    name varchar2(4000),
242    disp_order number(4) NOT NULL ,
243    PRIMARY KEY (id)
244);
245
246CREATE TABLE mtb_site_control_affiliate (
247    id number(4),
248    name varchar2(4000),
249    disp_order number(4) NOT NULL ,
250    PRIMARY KEY (id)
251);
252
253CREATE TABLE mtb_constants (
254    id varchar(64),
255    name varchar2(4000),
256    disp_order number(4) NOT NULL ,
257    remarks varchar2(4000),
258    PRIMARY KEY (id)
259);
Note: See TracBrowser for help on using the repository browser.