source: branches/feature-module-update/html/install/sql/add/mtb_tables_mysql.sql @ 15165

Revision 15165, 4.7 KB checked in by nanasess, 17 years ago (diff)

新規追加

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