source: branches/version-2_5-dev/html/install/sql/create_table_mysql.sql @ 18778

Revision 18778, 29.8 KB checked in by eccuore, 16 years ago (diff)

#792(ダウンロード販売機能) SQLミス
  • Property svn:eol-style set to LF
  • Property svn:mime-type set to text/plain; charset=utf-8
Line 
1create table dtb_module_update_logs(
2    log_id int auto_increment NOT NULL,
3    module_id int NOT NULL,
4    buckup_path text,
5    error_flg smallint DEFAULT 0,
6    error text,
7    ok text,
8    create_date datetime NOT NULL,
9    update_date datetime NOT NULL,
10    PRIMARY KEY (log_id)
11) TYPE=InnoDB;
12
13CREATE TABLE dtb_ownersstore_settings (
14    public_key text
15) TYPE=InnoDB;
16
17CREATE TABLE dtb_kiyaku (
18    kiyaku_id int auto_increment NOT NULL,
19    kiyaku_title text NOT NULL,
20    kiyaku_text text NOT NULL,
21    rank int NOT NULL DEFAULT 0,
22    creator_id int NOT NULL,
23    create_date datetime NOT NULL,
24    update_date datetime NOT NULL,
25    del_flg smallint NOT NULL DEFAULT 0,
26    PRIMARY KEY (kiyaku_id)
27) TYPE=InnoDB;
28
29CREATE TABLE dtb_holiday (
30    holiday_id int auto_increment NOT NULL,
31    title text NOT NULL,
32    month smallint NOT NULL,
33    day smallint NOT NULL,
34    rank int NOT NULL DEFAULT 0,
35    creator_id int NOT NULL,
36    create_date datetime NOT NULL,
37    update_date datetime NOT NULL,
38    del_flg smallint NOT NULL DEFAULT 0,
39    PRIMARY KEY (holiday_id)
40) TYPE=InnoDB;
41
42CREATE TABLE mtb_zip (
43    code text,
44    old_zipcode text,
45    zipcode text,
46    state_kana text,
47    city_kana text,
48    town_kana text,
49    state text,
50    city text,
51    town text,
52    flg1 text,
53    flg2 text,
54    flg3 text,
55    flg4 text,
56    flg5 text,
57    flg6 text
58) TYPE=InnoDB;
59
60CREATE TABLE dtb_bat_order_daily_age (
61    order_count numeric NOT NULL DEFAULT 0,
62    total numeric NOT NULL DEFAULT 0,
63    total_average numeric NOT NULL DEFAULT 0,
64    start_age smallint,
65    end_age smallint,
66    member smallint,
67    order_date datetime,
68    create_date datetime NOT NULL
69) TYPE=InnoDB;
70
71CREATE TABLE dtb_update (
72    module_id int NOT NULL,
73    module_name text NOT NULL,
74    now_version text,
75    latest_version text NOT NULL,
76    module_explain text,
77    main_php text NOT NULL,
78    extern_php text NOT NULL,
79    install_sql text,
80    uninstall_sql text,
81    other_files text,
82    del_flg smallint NOT NULL DEFAULT 0,
83    create_date datetime NOT NULL,
84    update_date datetime,
85    release_date datetime NOT NULL,
86    PRIMARY KEY (module_id)
87) TYPE=InnoDB;
88
89CREATE TABLE dtb_baseinfo (
90    company_name text,
91    company_kana text,
92    zip01 text,
93    zip02 text,
94    pref smallint,
95    addr01 text,
96    addr02 text,
97    tel01 text,
98    tel02 text,
99    tel03 text,
100    fax01 text,
101    fax02 text,
102    fax03 text,
103    business_hour text,
104    law_company text,
105    law_manager text,
106    law_zip01 text,
107    law_zip02 text,
108    law_pref smallint,
109    law_addr01 text,
110    law_addr02 text,
111    law_tel01 text,
112    law_tel02 text,
113    law_tel03 text,
114    law_fax01 text,
115    law_fax02 text,
116    law_fax03 text,
117    law_email text,
118    law_url text,
119    law_term01 text,
120    law_term02 text,
121    law_term03 text,
122    law_term04 text,
123    law_term05 text,
124    law_term06 text,
125    law_term07 text,
126    law_term08 text,
127    law_term09 text,
128    law_term10 text,
129    tax numeric NOT NULL DEFAULT 5,
130    tax_rule smallint NOT NULL DEFAULT 1,
131    email01 text,
132    email02 text,
133    email03 text,
134    email04 text,
135    email05 text,
136    free_rule numeric,
137    shop_name text,
138    shop_kana text,
139    shop_name_eng text,
140    point_rate numeric NOT NULL DEFAULT 0,
141    welcome_point numeric NOT NULL DEFAULT 0,
142    update_date datetime,
143    top_tpl text,
144    product_tpl text,
145    detail_tpl text,
146    mypage_tpl text,
147    good_traded text,
148    message text,
149    regular_holiday_ids text,
150    latitude text,
151    longitude text,
152    downloadable_days numeric DEFAULT 30,
153    downloadable_days_unlimited smallint
154) TYPE=InnoDB;
155
156CREATE TABLE dtb_deliv (
157    deliv_id int auto_increment NOT NULL,
158    name text,
159    service_name text,
160    confirm_url text,
161    rank int,
162    status smallint NOT NULL DEFAULT 1,
163    del_flg smallint NOT NULL DEFAULT 0,
164    creator_id int NOT NULL,
165    create_date datetime NOT NULL,
166    update_date datetime,
167    PRIMARY KEY (deliv_id)
168) TYPE=InnoDB;
169
170CREATE TABLE dtb_delivtime (
171    deliv_id int NOT NULL,
172    time_id int NOT NULL,
173    deliv_time text NOT NULL,
174    PRIMARY KEY (deliv_id, time_id)
175) TYPE=InnoDB;
176
177CREATE TABLE dtb_delivfee (
178    deliv_id int NOT NULL,
179    fee_id int auto_increment NOT NULL,
180    fee text NOT NULL,
181    pref smallint,
182    PRIMARY KEY (fee_id)
183) TYPE=InnoDB;
184
185CREATE TABLE dtb_payment (
186    payment_id int auto_increment NOT NULL,
187    payment_method text,
188    charge numeric,
189    rule numeric,
190    deliv_id int DEFAULT 0,
191    rank int,
192    note text,
193    fix smallint,
194    status smallint NOT NULL DEFAULT 1,
195    del_flg smallint NOT NULL DEFAULT 0,
196    creator_id int NOT NULL,
197    create_date datetime NOT NULL,
198    update_date datetime,
199    payment_image text,
200    upper_rule numeric,
201    charge_flg smallint DEFAULT 1,
202    rule_min numeric,
203    upper_rule_max numeric,
204    module_id int,
205    module_path text,
206    memo01 text,
207    memo02 text,
208    memo03 text,
209    memo04 text,
210    memo05 text,
211    memo06 text,
212    memo07 text,
213    memo08 text,
214    memo09 text,
215    memo10 text,
216    PRIMARY KEY (payment_id)
217) TYPE=InnoDB;
218
219CREATE TABLE dtb_mailtemplate (
220    template_id int NOT NULL,
221    subject text,
222    header text,
223    footer text,
224    creator_id int NOT NULL,
225    del_flg smallint NOT NULL DEFAULT 0,
226    create_date datetime NOT NULL,
227    update_date datetime NOT NULL
228) TYPE=InnoDB;
229
230CREATE TABLE dtb_mailmaga_template (
231    template_id int auto_increment NOT NULL,
232    subject text,
233    charge_image text,
234    mail_method int,
235    header text,
236    body text,
237    main_title text,
238    main_comment text,
239    main_product_id int,
240    sub_title text,
241    sub_comment text,
242    sub_product_id01 int,
243    sub_product_id02 int,
244    sub_product_id03 int,
245    sub_product_id04 int,
246    sub_product_id05 int,
247    sub_product_id06 int,
248    sub_product_id07 int,
249    sub_product_id08 int,
250    sub_product_id09 int,
251    sub_product_id10 int,
252    sub_product_id11 int,
253    sub_product_id12 int,
254    del_flg smallint NOT NULL DEFAULT 0,
255    creator_id int NOT NULL,
256    create_date datetime NOT NULL,
257    update_date datetime,
258    PRIMARY KEY (template_id)
259) TYPE=InnoDB;
260
261CREATE TABLE dtb_send_history (
262    send_id int auto_increment NOT NULL,
263    mail_method smallint,
264    subject text,
265    body text,
266    send_count int,
267    complete_count int NOT NULL DEFAULT 0,
268    start_date datetime,
269    end_date datetime,
270    search_data text,
271    del_flg smallint NOT NULL DEFAULT 0,
272    creator_id int NOT NULL,
273    create_date datetime NOT NULL,
274    update_date datetime NOT NULL,
275    PRIMARY KEY (send_id)
276) TYPE=InnoDB;
277
278CREATE TABLE dtb_send_customer (
279    customer_id int,
280    send_id int NOT NULL,
281    email text,
282    name text,
283    send_flag smallint,
284    PRIMARY KEY (send_id, customer_id)
285) TYPE=InnoDB;
286
287CREATE TABLE dtb_products (
288    product_id int auto_increment NOT NULL,
289    name text,
290    deliv_fee numeric,
291    sale_limit numeric,
292    category_id int,
293    maker_id int,
294    rank int,
295    status smallint NOT NULL DEFAULT 2,
296    product_flag text,
297    point_rate numeric,
298    comment1 text,
299    comment2 text,
300    comment3 mediumtext,
301    comment4 text,
302    comment5 text,
303    comment6 text,
304    note text,
305    file1 text,
306    file2 text,
307    file3 text,
308    file4 text,
309    file5 text,
310    file6 text,
311    main_list_comment text,
312    main_list_image text,
313    main_comment mediumtext,
314    main_image text,
315    main_large_image text,
316    sub_title1 text,
317    sub_comment1 mediumtext,
318    sub_image1 text,
319    sub_large_image1 text,
320    sub_title2 text,
321    sub_comment2 mediumtext,
322    sub_image2 text,
323    sub_large_image2 text,
324    sub_title3 text,
325    sub_comment3 mediumtext,
326    sub_image3 text,
327    sub_large_image3 text,
328    sub_title4 text,
329    sub_comment4 mediumtext,
330    sub_image4 text,
331    sub_large_image4 text,
332    sub_title5 text,
333    sub_comment5 mediumtext,
334    sub_image5 text,
335    sub_large_image5 text,
336    sub_title6 text,
337    sub_comment6 mediumtext,
338    sub_image6 text,
339    sub_large_image6 text,
340    del_flg smallint NOT NULL DEFAULT 0,
341    creator_id int NOT NULL,
342    create_date datetime NOT NULL,
343    update_date datetime,
344    deliv_date_id int,
345    down smallint NOT NULL ,
346    down_filename text,
347    down_realfilename text,
348    PRIMARY KEY (product_id)
349) TYPE=InnoDB;
350
351CREATE TABLE dtb_products_class (
352    product_class_id int auto_increment NOT NULL,
353    product_id int NOT NULL,
354    classcategory_id1 int NOT NULL DEFAULT 0,
355    classcategory_id2 int NOT NULL DEFAULT 0,
356    product_code text,
357    stock numeric,
358    stock_unlimited smallint NOT NULL DEFAULT 0,
359    sale_limit numeric,
360    price01 numeric,
361    price02 numeric,
362    status smallint,
363    creator_id int NOT NULL,
364    create_date datetime NOT NULL,
365    update_date datetime,
366    PRIMARY KEY (product_class_id)
367) TYPE=InnoDB;
368
369CREATE TABLE dtb_class (
370    class_id int auto_increment NOT NULL,
371    name text,
372    status smallint,
373    rank int,
374    creator_id int NOT NULL,
375    create_date datetime NOT NULL,
376    update_date datetime,
377    del_flg smallint NOT NULL DEFAULT 0,
378    product_id int,
379    PRIMARY KEY (class_id)
380) TYPE=InnoDB;
381
382CREATE TABLE dtb_classcategory (
383    classcategory_id int auto_increment NOT NULL,
384    name text,
385    class_id int NOT NULL,
386    status smallint,
387    rank int,
388    creator_id int NOT NULL,
389    create_date datetime NOT NULL,
390    update_date datetime,
391    del_flg smallint NOT NULL DEFAULT 0,
392    PRIMARY KEY (classcategory_id)
393) TYPE=InnoDB;
394
395CREATE TABLE dtb_category (
396    category_id int auto_increment NOT NULL,
397    category_name text,
398    parent_category_id int NOT NULL DEFAULT 0,
399    level int NOT NULL,
400    rank int,
401    creator_id int NOT NULL,
402    create_date datetime NOT NULL,
403    update_date datetime,
404    del_flg smallint NOT NULL DEFAULT 0,
405    PRIMARY KEY (category_id)
406) TYPE=InnoDB;
407
408CREATE TABLE dtb_product_categories (
409    product_id int NOT NULL,
410    category_id int NOT NULL,
411    rank int NOT NULL,
412    PRIMARY KEY(product_id, category_id)
413) TYPE=InnoDB;
414
415CREATE TABLE dtb_bat_order_daily (
416    total_order numeric NOT NULL DEFAULT 0,
417    member numeric NOT NULL DEFAULT 0,
418    nonmember numeric NOT NULL DEFAULT 0,
419    men numeric NOT NULL DEFAULT 0,
420    women numeric NOT NULL DEFAULT 0,
421    men_member numeric NOT NULL DEFAULT 0,
422    men_nonmember numeric NOT NULL DEFAULT 0,
423    women_member numeric NOT NULL DEFAULT 0,
424    women_nonmember numeric NOT NULL DEFAULT 0,
425    total numeric NOT NULL DEFAULT 0,
426    total_average numeric NOT NULL DEFAULT 0,
427    order_date datetime NOT NULL,
428    create_date datetime NOT NULL,
429    year smallint NOT NULL,
430    month smallint NOT NULL,
431    day smallint NOT NULL,
432    wday smallint NOT NULL,
433    key_day text NOT NULL,
434    key_month text NOT NULL,
435    key_year text NOT NULL,
436    key_wday text NOT NULL
437) TYPE=InnoDB;
438
439CREATE TABLE dtb_bat_order_daily_hour (
440    total_order numeric NOT NULL DEFAULT 0,
441    member numeric NOT NULL DEFAULT 0,
442    nonmember numeric NOT NULL DEFAULT 0,
443    men numeric NOT NULL DEFAULT 0,
444    women numeric NOT NULL DEFAULT 0,
445    men_member numeric NOT NULL DEFAULT 0,
446    men_nonmember numeric NOT NULL DEFAULT 0,
447    women_member numeric NOT NULL DEFAULT 0,
448    women_nonmember numeric NOT NULL DEFAULT 0,
449    total numeric NOT NULL DEFAULT 0,
450    total_average numeric NOT NULL DEFAULT 0,
451    hour smallint NOT NULL DEFAULT 0,
452    order_date datetime,
453    create_date datetime NOT NULL
454) TYPE=InnoDB;
455
456CREATE TABLE dtb_recommend_products (
457    product_id int NOT NULL,
458    recommend_product_id int NOT NULL,
459    rank int NOT NULL,
460    comment text,
461    status smallint NOT NULL DEFAULT 0,
462    creator_id int NOT NULL,
463    create_date datetime NOT NULL,
464    update_date datetime NOT NULL
465) TYPE=InnoDB;
466
467CREATE TABLE dtb_review (
468    review_id int auto_increment NOT NULL,
469    product_id int NOT NULL,
470    reviewer_name text NOT NULL,
471    reviewer_url text,
472    sex smallint,
473    customer_id int,
474    recommend_level smallint NOT NULL,
475    title text NOT NULL,
476    comment text NOT NULL,
477    status smallint DEFAULT 2,
478    creator_id int NOT NULL,
479    create_date datetime,
480    update_date datetime,
481    del_flg smallint NOT NULL DEFAULT 0,
482    PRIMARY KEY (review_id)
483) TYPE=InnoDB;
484
485CREATE TABLE dtb_customer_reading (
486    reading_product_id int NOT NULL,
487    customer_id int NOT NULL,
488    create_date datetime NOT NULL,
489    update_date datetime NOT NULL
490) TYPE=InnoDB;
491
492CREATE TABLE dtb_customer_favorite_products (
493    customer_id int NOT NULL,
494    product_id int NOT NULL,
495    create_date datetime NOT NULL,
496    update_date datetime NOT NULL
497) TYPE=InnoDB;
498
499CREATE TABLE dtb_category_count (
500    category_id int NOT NULL,
501    product_count int NOT NULL,
502    create_date datetime NOT NULL
503) TYPE=InnoDB;
504
505CREATE TABLE dtb_category_total_count (
506    category_id int NOT NULL,
507    product_count int,
508    create_date datetime NOT NULL
509) TYPE=InnoDB;
510
511CREATE TABLE dtb_news (
512    news_id int auto_increment NOT NULL,
513    news_date datetime,
514    rank int,
515    news_title text NOT NULL,
516    news_comment text,
517    news_url text,
518    news_select smallint NOT NULL DEFAULT 0,
519    link_method text,
520    creator_id int NOT NULL,
521    create_date datetime NOT NULL,
522    update_date datetime,
523    del_flg smallint NOT NULL DEFAULT 0,
524    PRIMARY KEY (news_id)
525) TYPE=InnoDB;
526
527CREATE TABLE dtb_best_products (
528    best_id int auto_increment NOT NULL,
529    category_id int NOT NULL,
530    rank int NOT NULL DEFAULT 0,
531    product_id int NOT NULL,
532    title text,
533    comment text,
534    creator_id int NOT NULL,
535    create_date datetime NOT NULL,
536    update_date datetime,
537    del_flg smallint NOT NULL DEFAULT 0,
538    PRIMARY KEY (best_id)
539) TYPE=InnoDB;
540
541CREATE TABLE dtb_mail_history (
542    send_id int auto_increment NOT NULL,
543    order_id int NOT NULL,
544    send_date datetime,
545    template_id int,
546    creator_id int NOT NULL,
547    subject text,
548    mail_body text,
549    PRIMARY KEY (send_id)
550) TYPE=InnoDB;
551
552CREATE TABLE dtb_customer (
553    customer_id int auto_increment NOT NULL,
554    name01 text NOT NULL,
555    name02 text NOT NULL,
556    kana01 text NOT NULL,
557    kana02 text NOT NULL,
558    zip01 text,
559    zip02 text,
560    pref smallint,
561    addr01 text,
562    addr02 text,
563    email text NOT NULL,
564    email_mobile text,
565    tel01 text,
566    tel02 text,
567    tel03 text,
568    fax01 text,
569    fax02 text,
570    fax03 text,
571    sex smallint,
572    job smallint,
573    birth datetime,
574    password text,
575    reminder smallint,
576    reminder_answer text,
577    secret_key varchar(50) NOT NULL UNIQUE,
578    first_buy_date datetime,
579    last_buy_date datetime,
580    buy_times numeric DEFAULT 0,
581    buy_total numeric DEFAULT 0,
582    point numeric DEFAULT 0,
583    note text,
584    status smallint NOT NULL DEFAULT 1,
585    create_date datetime NOT NULL,
586    update_date datetime,
587    del_flg smallint NOT NULL DEFAULT 0,
588    cell01 text,
589    cell02 text,
590    cell03 text,
591    mobile_phone_id text,
592    mailmaga_flg smallint,
593    PRIMARY KEY (customer_id)
594) TYPE=InnoDB;
595
596CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id(64));
597
598CREATE TABLE dtb_customer_mail_temp (
599    email varchar(50) NOT NULL UNIQUE,
600    mail_flag smallint,
601    temp_id varchar(50) NOT NULL,
602    end_flag smallint,
603    update_date datetime NOT NULL,
604    create_data datetime NOT NULL,
605    PRIMARY KEY (temp_id)
606) TYPE=InnoDB;
607
608CREATE TABLE dtb_order (
609    order_id int auto_increment NOT NULL,
610    order_temp_id text,
611    customer_id int NOT NULL,
612    message text,
613    order_name01 text,
614    order_name02 text,
615    order_kana01 text,
616    order_kana02 text,
617    order_email text,
618    order_tel01 text,
619    order_tel02 text,
620    order_tel03 text,
621    order_fax01 text,
622    order_fax02 text,
623    order_fax03 text,
624    order_zip01 text,
625    order_zip02 text,
626    order_pref smallint,
627    order_addr01 text,
628    order_addr02 text,
629    order_sex smallint,
630    order_birth datetime,
631    order_job int,
632    deliv_name01 text,
633    deliv_name02 text,
634    deliv_kana01 text,
635    deliv_kana02 text,
636    deliv_tel01 text,
637    deliv_tel02 text,
638    deliv_tel03 text,
639    deliv_fax01 text,
640    deliv_fax02 text,
641    deliv_fax03 text,
642    deliv_zip01 text,
643    deliv_zip02 text,
644    deliv_pref smallint,
645    deliv_addr01 text,
646    deliv_addr02 text,
647    subtotal numeric,
648    discount numeric,
649    deliv_fee numeric,
650    charge numeric,
651    use_point numeric,
652    add_point numeric,
653    birth_point numeric DEFAULT 0,
654    tax numeric,
655    total numeric,
656    payment_total numeric,
657    payment_id int,
658    payment_method text,
659    deliv_id int,
660    deliv_time_id int,
661    deliv_time text,
662    deliv_no text,
663    note text,
664    status smallint,
665    create_date datetime NOT NULL,
666    loan_result text,
667    credit_result text,
668    credit_msg text,
669    update_date datetime,
670    commit_date datetime,
671    del_flg smallint NOT NULL DEFAULT 0,
672    deliv_date text,
673    conveni_data text,
674    cell01 text,
675    cell02 text,
676    cell03 text,
677    memo01 text,
678    memo02 text,
679    memo03 text,
680    memo04 text,
681    memo05 text,
682    memo06 text,
683    memo07 text,
684    memo08 text,
685    memo09 text,
686    memo10 text,
687    campaign_id int,
688    PRIMARY KEY (order_id)
689) TYPE=InnoDB;
690
691CREATE TABLE dtb_order_temp (
692    order_temp_id text NOT NULL,
693    customer_id int NOT NULL,
694    message text,
695    order_name01 text,
696    order_name02 text,
697    order_kana01 text,
698    order_kana02 text,
699    order_email text,
700    order_tel01 text,
701    order_tel02 text,
702    order_tel03 text,
703    order_fax01 text,
704    order_fax02 text,
705    order_fax03 text,
706    order_zip01 text,
707    order_zip02 text,
708    order_pref smallint,
709    order_addr01 text,
710    order_addr02 text,
711    order_sex smallint,
712    order_birth datetime,
713    order_job int,
714    deliv_name01 text,
715    deliv_name02 text,
716    deliv_kana01 text,
717    deliv_kana02 text,
718    deliv_tel01 text,
719    deliv_tel02 text,
720    deliv_tel03 text,
721    deliv_fax01 text,
722    deliv_fax02 text,
723    deliv_fax03 text,
724    deliv_zip01 text,
725    deliv_zip02 text,
726    deliv_pref smallint,
727    deliv_addr01 text,
728    deliv_addr02 text,
729    subtotal numeric,
730    discount numeric,
731    deliv_fee numeric,
732    charge numeric,
733    use_point numeric,
734    add_point numeric,
735    birth_point numeric DEFAULT 0,
736    tax numeric,
737    total numeric,
738    payment_total numeric,
739    payment_id int,
740    payment_method text,
741    deliv_id int,
742    deliv_time_id int,
743    deliv_time text,
744    deliv_no text,
745    note text,
746    mail_flag smallint,
747    status smallint,
748    deliv_check smallint,
749    point_check smallint,
750    loan_result text,
751    credit_result text,
752    credit_msg text,
753    create_date datetime NOT NULL,
754    update_date datetime,
755    del_flg smallint NOT NULL DEFAULT 0,
756    deliv_date text,
757    conveni_data text,
758    cell01 text,
759    cell02 text,
760    cell03 text,
761    order_id int,
762    memo01 text,
763    memo02 text,
764    memo03 text,
765    memo04 text,
766    memo05 text,
767    memo06 text,
768    memo07 text,
769    memo08 text,
770    memo09 text,
771    memo10 text,
772    session text
773) TYPE=InnoDB;
774
775CREATE TABLE dtb_other_deliv (
776    other_deliv_id int auto_increment NOT NULL,
777    customer_id int NOT NULL,
778    name01 text,
779    name02 text,
780    kana01 text,
781    kana02 text,
782    zip01 text,
783    zip02 text,
784    pref smallint,
785    addr01 text,
786    addr02 text,
787    tel01 text,
788    tel02 text,
789    tel03 text,
790    PRIMARY KEY (other_deliv_id)
791) TYPE=InnoDB;
792
793CREATE TABLE dtb_order_detail (
794    order_id int NOT NULL,
795    product_id int NOT NULL,
796    classcategory_id1 int NOT NULL,
797    classcategory_id2 int NOT NULL,
798    product_name text NOT NULL,
799    product_code text,
800    classcategory_name1 text,
801    classcategory_name2 text,
802    price numeric,
803    quantity numeric,
804    point_rate numeric
805) TYPE=InnoDB;
806
807CREATE TABLE mtb_pref (
808    pref_id smallint NOT NULL,
809    pref_name text,
810    rank smallint NOT NULL DEFAULT 0,
811    PRIMARY KEY (pref_id)
812) TYPE=InnoDB;
813
814CREATE TABLE dtb_member (
815    member_id int auto_increment NOT NULL,
816    name text,
817    department text,
818    login_id text NOT NULL,
819    password text NOT NULL,
820    authority smallint NOT NULL,
821    rank int NOT NULL DEFAULT 0,
822    work smallint NOT NULL DEFAULT 1,
823    del_flg smallint NOT NULL DEFAULT 0,
824    creator_id int NOT NULL,
825    update_date datetime,
826    create_date datetime NOT NULL,
827    login_date datetime,
828    PRIMARY KEY (member_id)
829) TYPE=InnoDB;
830
831CREATE TABLE dtb_question (
832    question_id int auto_increment NOT NULL,
833    question_name text,
834    question text,
835    create_date datetime NOT NULL,
836    del_flg smallint NOT NULL DEFAULT 0,
837    PRIMARY KEY (question_id)
838) TYPE=InnoDB;
839
840CREATE TABLE dtb_question_result (
841    result_id int auto_increment NOT NULL,
842    question_id int NOT NULL,
843    question_date datetime,
844    question_name text,
845    name01 text,
846    name02 text,
847    kana01 text,
848    kana02 text,
849    zip01 text,
850    zip02 text,
851    pref smallint,
852    addr01 text,
853    addr02 text,
854    tel01 text,
855    tel02 text,
856    tel03 text,
857    mail01 text,
858    question01 text,
859    question02 text,
860    question03 text,
861    question04 text,
862    question05 text,
863    question06 text,
864    create_date datetime NOT NULL,
865    del_flg smallint NOT NULL DEFAULT 0,
866    PRIMARY KEY (result_id)
867) TYPE=InnoDB;
868
869CREATE TABLE dtb_bat_relate_products (
870    product_id int,
871    relate_product_id int,
872    customer_id int,
873    create_date datetime
874) TYPE=InnoDB;
875
876CREATE TABLE dtb_campaign (
877    campaign_id int auto_increment NOT NULL,
878    campaign_name text,
879    campaign_point_rate numeric NOT NULL,
880    campaign_point_type smallint,
881    start_date datetime NOT NULL,
882    end_date datetime NOT NULL,
883    directory_name text NOT NULL,
884    limit_count int NOT NULL DEFAULT 0,
885    total_count int NOT NULL DEFAULT 0,
886    orverlapping_flg smallint NOT NULL DEFAULT 0,
887    cart_flg smallint NOT NULL DEFAULT 0,
888    deliv_free_flg smallint NOT NULL DEFAULT 0,
889    search_condition text,
890    del_flg smallint NOT NULL DEFAULT 0,
891    create_date datetime NOT NULL,
892    update_date datetime NOT NULL,
893    PRIMARY KEY (campaign_id)
894) TYPE=InnoDB;
895
896CREATE TABLE dtb_campaign_detail (
897    campaign_id int NOT NULL,
898    product_id int NOT NULL,
899    campaign_point_rate numeric NOT NULL
900) TYPE=InnoDB;
901
902CREATE TABLE dtb_pagelayout (
903    page_id int auto_increment NOT NULL,
904    page_name text,
905    url text NOT NULL,
906    php_dir text,
907    tpl_dir text,
908    filename text,
909    header_chk smallint DEFAULT 1,
910    footer_chk smallint DEFAULT 1,
911    edit_flg smallint DEFAULT 1,
912    author text,
913    description text,
914    keyword text,
915    update_url text,
916    create_date datetime NOT NULL,
917    update_date datetime NOT NULL,
918    PRIMARY KEY (page_id)
919) TYPE=InnoDB;
920
921CREATE TABLE dtb_bloc (
922    bloc_id int auto_increment NOT NULL,
923    bloc_name text,
924    tpl_path text,
925    filename varchar(50) NOT NULL UNIQUE,
926    create_date datetime NOT NULL,
927    update_date datetime NOT NULL,
928    php_path text,
929    del_flg smallint NOT NULL DEFAULT 0,
930    PRIMARY KEY (bloc_id)
931) TYPE=InnoDB;
932
933CREATE TABLE dtb_blocposition (
934    page_id int NOT NULL,
935    target_id int,
936    bloc_id int,
937    bloc_row int,
938    filename text,
939    anywhere int DEFAULT 0 NOT NULL
940) TYPE=InnoDB;
941
942CREATE TABLE dtb_csv (
943    no int auto_increment,
944    csv_id int NOT NULL,
945    col text,
946    disp_name text,
947    rank int,
948    status smallint NOT NULL DEFAULT 1,
949    create_date datetime NOT NULL,
950    update_date datetime NOT NULL,
951    `convert` text,
952    PRIMARY KEY (no)
953) TYPE=InnoDB;
954
955CREATE TABLE dtb_csv_sql (
956    sql_id int auto_increment,
957    sql_name text NOT NULL,
958    csv_sql text,
959    update_date datetime NOT NULL,
960    create_date datetime NOT NULL,
961    PRIMARY KEY (sql_id)
962) TYPE=InnoDB;
963
964CREATE TABLE dtb_user_regist (
965    user_id int auto_increment NOT NULL,
966    org_name text,
967    post_name text,
968    name01 text,
969    name02 text,
970    kana01 text,
971    kana02 text,
972    email text NOT NULL,
973    url text,
974    note text,
975    secret_key varchar(50) NOT NULL UNIQUE,
976    status smallint NOT NULL,
977    del_flg smallint DEFAULT 0,
978    create_date datetime NOT NULL,
979    update_date datetime NOT NULL,
980    PRIMARY KEY (user_id)
981) TYPE=InnoDB;
982
983CREATE TABLE dtb_templates
984(
985    template_code varchar(50) NOT NULL,
986    template_name text,
987    create_date datetime NOT NULL,
988    update_date datetime NOT NULL,
989    PRIMARY KEY (template_code)
990) TYPE=InnoDB;
991
992CREATE TABLE dtb_table_comment
993(
994    id int auto_increment,
995    table_name text,
996    column_name text,
997    description text,
998    PRIMARY KEY (id)
999) TYPE=InnoDB;
1000
1001CREATE TABLE dtb_maker (
1002    maker_id int auto_increment,
1003    name text NOT NULL,
1004    rank int NOT NULL DEFAULT 0,
1005    creator_id int NOT NULL,
1006    create_date datetime NOT NULL,
1007    update_date datetime NOT NULL,
1008    del_flg smallint NOT NULL DEFAULT 0,
1009    PRIMARY KEY (maker_id)
1010) TYPE=InnoDB;
1011
1012CREATE TABLE dtb_maker_count (
1013    maker_id int NOT NULL,
1014    product_count int NOT NULL,
1015    create_date datetime NOT NULL
1016) TYPE=InnoDB;
1017
1018
1019CREATE TABLE mtb_permission (
1020    id text,
1021    name text,
1022    rank smallint NOT NULL DEFAULT 0,
1023    PRIMARY KEY (id(32))
1024) TYPE=InnoDB;
1025
1026CREATE TABLE mtb_disable_logout (
1027    id smallint,
1028    name text,
1029    rank smallint NOT NULL DEFAULT 0,
1030    PRIMARY KEY (id)
1031) TYPE=InnoDB;
1032
1033CREATE TABLE mtb_authority (
1034    id smallint,
1035    name text,
1036    rank smallint NOT NULL DEFAULT 0,
1037    PRIMARY KEY (id)
1038) TYPE=InnoDB;
1039
1040CREATE TABLE mtb_work (
1041    id smallint,
1042    name text,
1043    rank smallint NOT NULL DEFAULT 0,
1044    PRIMARY KEY (id)
1045) TYPE=InnoDB;
1046
1047CREATE TABLE mtb_disp (
1048    id smallint,
1049    name text,
1050    rank smallint NOT NULL DEFAULT 0,
1051    PRIMARY KEY (id)
1052) TYPE=InnoDB;
1053
1054CREATE TABLE mtb_class (
1055    id smallint,
1056    name text,
1057    rank smallint NOT NULL DEFAULT 0,
1058    PRIMARY KEY (id)
1059) TYPE=InnoDB;
1060
1061CREATE TABLE mtb_srank (
1062    id smallint,
1063    name text,
1064    rank smallint NOT NULL DEFAULT 0,
1065    PRIMARY KEY (id)
1066) TYPE=InnoDB;
1067
1068CREATE TABLE mtb_status (
1069    id smallint,
1070    name text,
1071    rank smallint NOT NULL DEFAULT 0,
1072    PRIMARY KEY (id)
1073) TYPE=InnoDB;
1074
1075CREATE TABLE mtb_status_image (
1076    id smallint,
1077    name text,
1078    rank smallint NOT NULL DEFAULT 0,
1079    PRIMARY KEY (id)
1080) TYPE=InnoDB;
1081
1082CREATE TABLE mtb_allowed_tag (
1083    id smallint,
1084    name text,
1085    rank smallint NOT NULL DEFAULT 0,
1086    PRIMARY KEY (id)
1087) TYPE=InnoDB;
1088
1089CREATE TABLE mtb_page_max (
1090    id smallint,
1091    name text,
1092    rank smallint NOT NULL DEFAULT 0,
1093    PRIMARY KEY (id)
1094) TYPE=InnoDB;
1095
1096CREATE TABLE mtb_magazine_type (
1097    id smallint,
1098    name text,
1099    rank smallint NOT NULL DEFAULT 0,
1100    PRIMARY KEY (id)
1101) TYPE=InnoDB;
1102
1103CREATE TABLE mtb_mail_magazine_type (
1104    id smallint,
1105    name text,
1106    rank smallint NOT NULL DEFAULT 0,
1107    PRIMARY KEY (id)
1108) TYPE=InnoDB;
1109
1110CREATE TABLE mtb_recommend (
1111    id smallint,
1112    name text,
1113    rank smallint NOT NULL DEFAULT 0,
1114    PRIMARY KEY (id)
1115) TYPE=InnoDB;
1116
1117CREATE TABLE mtb_taxrule (
1118    id smallint,
1119    name text,
1120    rank smallint NOT NULL DEFAULT 0,
1121    PRIMARY KEY (id)
1122) TYPE=InnoDB;
1123
1124CREATE TABLE mtb_mail_template (
1125    id smallint,
1126    name text,
1127    rank smallint NOT NULL DEFAULT 0,
1128    PRIMARY KEY (id)
1129) TYPE=InnoDB;
1130
1131CREATE TABLE mtb_mail_tpl_path (
1132    id smallint,
1133    name text,
1134    rank smallint NOT NULL DEFAULT 0,
1135    PRIMARY KEY (id)
1136) TYPE=InnoDB;
1137
1138CREATE TABLE mtb_job (
1139    id smallint,
1140    name text,
1141    rank smallint NOT NULL DEFAULT 0,
1142    PRIMARY KEY (id)
1143) TYPE=InnoDB;
1144
1145CREATE TABLE mtb_reminder (
1146    id smallint,
1147    name text,
1148    rank smallint NOT NULL DEFAULT 0,
1149    PRIMARY KEY (id)
1150) TYPE=InnoDB;
1151
1152CREATE TABLE mtb_sex (
1153    id smallint,
1154    name text,
1155    rank smallint NOT NULL DEFAULT 0,
1156    PRIMARY KEY (id)
1157) TYPE=InnoDB;
1158
1159CREATE TABLE mtb_page_rows (
1160    id smallint,
1161    name text,
1162    rank smallint NOT NULL DEFAULT 0,
1163    PRIMARY KEY (id)
1164) TYPE=InnoDB;
1165
1166CREATE TABLE mtb_mail_type (
1167    id smallint,
1168    name text,
1169    rank smallint NOT NULL DEFAULT 0,
1170    PRIMARY KEY (id)
1171) TYPE=InnoDB;
1172
1173CREATE TABLE mtb_order_status (
1174    id smallint,
1175    name text,
1176    rank smallint NOT NULL DEFAULT 0,
1177    PRIMARY KEY (id)
1178) TYPE=InnoDB;
1179
1180CREATE TABLE mtb_product_status_color (
1181    id smallint,
1182    name text,
1183    rank smallint NOT NULL DEFAULT 0,
1184    PRIMARY KEY (id)
1185) TYPE=InnoDB;
1186
1187CREATE TABLE mtb_order_status_color (
1188    id smallint,
1189    name text,
1190    rank smallint NOT NULL DEFAULT 0,
1191    PRIMARY KEY (id)
1192) TYPE=InnoDB;
1193
1194CREATE TABLE mtb_wday (
1195    id smallint,
1196    name text,
1197    rank smallint NOT NULL DEFAULT 0,
1198    PRIMARY KEY (id)
1199) TYPE=InnoDB;
1200
1201CREATE TABLE mtb_delivery_date (
1202    id smallint,
1203    name text,
1204    rank smallint NOT NULL DEFAULT 0,
1205    PRIMARY KEY (id)
1206) TYPE=InnoDB;
1207
1208CREATE TABLE mtb_product_list_max (
1209    id smallint,
1210    name text,
1211    rank smallint NOT NULL DEFAULT 0,
1212    PRIMARY KEY (id)
1213) TYPE=InnoDB;
1214
1215CREATE TABLE mtb_convenience (
1216    id smallint,
1217    name text,
1218    rank smallint NOT NULL DEFAULT 0,
1219    PRIMARY KEY (id)
1220) TYPE=InnoDB;
1221
1222CREATE TABLE mtb_conveni_message (
1223    id smallint,
1224    name text,
1225    rank smallint NOT NULL DEFAULT 0,
1226    PRIMARY KEY (id)
1227) TYPE=InnoDB;
1228
1229CREATE TABLE mtb_db (
1230    id smallint,
1231    name text,
1232    rank smallint NOT NULL DEFAULT 0,
1233    PRIMARY KEY (id)
1234) TYPE=InnoDB;
1235
1236CREATE TABLE mtb_target (
1237    id smallint,
1238    name text,
1239    rank smallint NOT NULL DEFAULT 0,
1240    PRIMARY KEY (id)
1241) TYPE=InnoDB;
1242
1243CREATE TABLE mtb_review_deny_url (
1244    id smallint,
1245    name text,
1246    rank smallint NOT NULL DEFAULT 0,
1247    PRIMARY KEY (id)
1248) TYPE=InnoDB;
1249
1250CREATE TABLE mtb_track_back_status (
1251    id smallint,
1252    name text,
1253    rank smallint NOT NULL DEFAULT 0,
1254    PRIMARY KEY (id)
1255) TYPE=InnoDB;
1256
1257CREATE TABLE mtb_site_control_track_back (
1258    id smallint,
1259    name text,
1260    rank smallint NOT NULL DEFAULT 0,
1261    PRIMARY KEY (id)
1262) TYPE=InnoDB;
1263
1264CREATE TABLE mtb_site_control_affiliate (
1265    id smallint,
1266    name text,
1267    rank smallint NOT NULL DEFAULT 0,
1268    PRIMARY KEY (id)
1269) TYPE=InnoDB;
1270
1271CREATE TABLE mtb_mobile_domain (
1272    id smallint,
1273    name text,
1274    rank smallint NOT NULL DEFAULT 0,
1275    PRIMARY KEY (id)
1276) TYPE=InnoDB;
1277
1278CREATE TABLE mtb_ownersstore_err (
1279    id smallint,
1280    name text,
1281    rank smallint NOT NULL DEFAULT 0,
1282    PRIMARY KEY (id)
1283) TYPE=InnoDB;
1284
1285CREATE TABLE mtb_ownersstore_ips (
1286    id smallint,
1287    name text,
1288    rank smallint NOT NULL DEFAULT 0,
1289    PRIMARY KEY (id)
1290) TYPE=InnoDB;
1291
1292CREATE TABLE mtb_constants (
1293    id text,
1294    name text,
1295    rank smallint NOT NULL DEFAULT 0,
1296    remarks text,
1297    PRIMARY KEY (id(64))
1298) TYPE=InnoDB;
1299
1300CREATE TABLE mtb_down (
1301    id int2,
1302    name text,
1303    rank int2 NOT NULL,
1304    PRIMARY KEY (id)
1305) TYPE=InnoDB;
Note: See TracBrowser for help on using the repository browser.