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

Revision 18825, 29.3 KB checked in by eccuore, 16 years ago (diff)

#792(ダウンロード販売機能) product_class_id対応（規格構成変更と並行作業中なので、作業途中の部分有）
  • 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  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  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  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  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  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  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_send_history (
231    send_id int  NOT NULL,
232    mail_method smallint,
233    subject text,
234    body text,
235    send_count int,
236    complete_count int NOT NULL DEFAULT 0,
237    start_date datetime,
238    end_date datetime,
239    search_data text,
240    del_flg smallint NOT NULL DEFAULT 0,
241    creator_id int NOT NULL,
242    create_date datetime NOT NULL,
243    update_date datetime NOT NULL,
244    PRIMARY KEY (send_id)
245) TYPE=InnoDB;
246
247CREATE TABLE dtb_send_customer (
248    customer_id int,
249    send_id int NOT NULL,
250    email text,
251    name text,
252    send_flag smallint,
253    PRIMARY KEY (send_id, customer_id)
254) TYPE=InnoDB;
255
256CREATE TABLE dtb_products (
257    product_id int  NOT NULL,
258    name text NOT NULL,
259    maker_id int,
260    rank int,
261    status smallint NOT NULL DEFAULT 2,
262    comment1 text,
263    comment2 text,
264    comment3 mediumtext,
265    comment4 text,
266    comment5 text,
267    comment6 text,
268    note text,
269    file1 text,
270    file2 text,
271    file3 text,
272    file4 text,
273    file5 text,
274    file6 text,
275    main_list_comment text,
276    main_list_image text,
277    main_comment mediumtext,
278    main_image text,
279    main_large_image text,
280    sub_title1 text,
281    sub_comment1 mediumtext,
282    sub_image1 text,
283    sub_large_image1 text,
284    sub_title2 text,
285    sub_comment2 mediumtext,
286    sub_image2 text,
287    sub_large_image2 text,
288    sub_title3 text,
289    sub_comment3 mediumtext,
290    sub_image3 text,
291    sub_large_image3 text,
292    sub_title4 text,
293    sub_comment4 mediumtext,
294    sub_image4 text,
295    sub_large_image4 text,
296    sub_title5 text,
297    sub_comment5 mediumtext,
298    sub_image5 text,
299    sub_large_image5 text,
300    sub_title6 text,
301    sub_comment6 mediumtext,
302    sub_image6 text,
303    sub_large_image6 text,
304    del_flg smallint NOT NULL DEFAULT 0,
305    creator_id int NOT NULL,
306    create_date datetime NOT NULL,
307    update_date datetime,
308    deliv_date_id int,
309    PRIMARY KEY (product_id)
310) TYPE=InnoDB;
311
312CREATE TABLE dtb_products_class (
313    product_class_id int  NOT NULL,
314    product_id int NOT NULL,
315    class_combination_id int,
316    product_code text,
317    stock numeric,
318    stock_unlimited smallint NOT NULL DEFAULT 0,
319    sale_limit numeric,
320    price01 numeric,
321    price02 numeric,
322    deliv_fee numeric,
323    point_rate numeric,
324    status smallint,
325    creator_id int NOT NULL,
326    create_date datetime NOT NULL,
327    update_date datetime,
328    down smallint NOT NULL ,
329    down_filename text,
330    down_realfilename text,
331    del_flg smallint NOT NULL DEFAULT 0,
332    PRIMARY KEY (product_class_id)
333) TYPE=InnoDB;
334
335CREATE TABLE dtb_class (
336    class_id int  NOT NULL,
337    name text,
338    status smallint,
339    rank int,
340    creator_id int NOT NULL,
341    create_date datetime NOT NULL,
342    update_date datetime,
343    del_flg smallint NOT NULL DEFAULT 0,
344    PRIMARY KEY (class_id)
345) TYPE=InnoDB;
346
347CREATE TABLE dtb_classcategory (
348    classcategory_id int  NOT NULL,
349    name text,
350    class_id int NOT NULL,
351    status smallint,
352    rank int,
353    creator_id int NOT NULL,
354    create_date datetime NOT NULL,
355    update_date datetime,
356    del_flg smallint NOT NULL DEFAULT 0,
357    PRIMARY KEY (classcategory_id)
358) TYPE=InnoDB;
359
360CREATE TABLE dtb_class_combination (
361    class_combination_id int NOT NULL,
362    parent_class_combination_id int,
363    classcategory_id int NOT NULL,
364    level int,
365    PRIMARY KEY(class_combination_id)
366) TYPE=InnoDB;
367
368CREATE TABLE dtb_category (
369    category_id int  NOT NULL,
370    category_name text,
371    parent_category_id int NOT NULL DEFAULT 0,
372    level int NOT NULL,
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    PRIMARY KEY (category_id)
379) TYPE=InnoDB;
380
381CREATE TABLE dtb_product_categories (
382    product_id int NOT NULL,
383    category_id int NOT NULL,
384    rank int NOT NULL,
385    PRIMARY KEY(product_id, category_id)
386) TYPE=InnoDB;
387
388CREATE TABLE dtb_product_status (
389    product_status_id smallint NOT NULL,
390    product_id int NOT NULL,
391    creator_id int NOT NULL,
392    create_date datetime NOT NULL,
393    update_date datetime,
394    del_flg smallint NOT NULL DEFAULT 0,
395    PRIMARY KEY(product_status_id, product_id)
396) TYPE=InnoDB;
397
398CREATE TABLE dtb_bat_order_daily (
399    total_order numeric NOT NULL DEFAULT 0,
400    member numeric NOT NULL DEFAULT 0,
401    nonmember numeric NOT NULL DEFAULT 0,
402    men numeric NOT NULL DEFAULT 0,
403    women numeric NOT NULL DEFAULT 0,
404    men_member numeric NOT NULL DEFAULT 0,
405    men_nonmember numeric NOT NULL DEFAULT 0,
406    women_member numeric NOT NULL DEFAULT 0,
407    women_nonmember numeric NOT NULL DEFAULT 0,
408    total numeric NOT NULL DEFAULT 0,
409    total_average numeric NOT NULL DEFAULT 0,
410    order_date datetime NOT NULL,
411    create_date datetime NOT NULL,
412    year smallint NOT NULL,
413    month smallint NOT NULL,
414    day smallint NOT NULL,
415    wday smallint NOT NULL,
416    key_day text NOT NULL,
417    key_month text NOT NULL,
418    key_year text NOT NULL,
419    key_wday text NOT NULL
420) TYPE=InnoDB;
421
422CREATE TABLE dtb_bat_order_daily_hour (
423    total_order numeric NOT NULL DEFAULT 0,
424    member numeric NOT NULL DEFAULT 0,
425    nonmember numeric NOT NULL DEFAULT 0,
426    men numeric NOT NULL DEFAULT 0,
427    women numeric NOT NULL DEFAULT 0,
428    men_member numeric NOT NULL DEFAULT 0,
429    men_nonmember numeric NOT NULL DEFAULT 0,
430    women_member numeric NOT NULL DEFAULT 0,
431    women_nonmember numeric NOT NULL DEFAULT 0,
432    total numeric NOT NULL DEFAULT 0,
433    total_average numeric NOT NULL DEFAULT 0,
434    hour smallint NOT NULL DEFAULT 0,
435    order_date datetime,
436    create_date datetime NOT NULL
437) TYPE=InnoDB;
438
439CREATE TABLE dtb_recommend_products (
440    product_id int NOT NULL,
441    recommend_product_id int NOT NULL,
442    rank int NOT NULL,
443    comment text,
444    status smallint NOT NULL DEFAULT 0,
445    creator_id int NOT NULL,
446    create_date datetime NOT NULL,
447    update_date datetime NOT NULL
448) TYPE=InnoDB;
449
450CREATE TABLE dtb_review (
451    review_id int  NOT NULL,
452    product_id int NOT NULL,
453    reviewer_name text NOT NULL,
454    reviewer_url text,
455    sex smallint,
456    customer_id int,
457    recommend_level smallint NOT NULL,
458    title text NOT NULL,
459    comment text NOT NULL,
460    status smallint DEFAULT 2,
461    creator_id int NOT NULL,
462    create_date datetime,
463    update_date datetime,
464    del_flg smallint NOT NULL DEFAULT 0,
465    PRIMARY KEY (review_id)
466) TYPE=InnoDB;
467
468CREATE TABLE dtb_customer_reading (
469    reading_product_id int NOT NULL,
470    customer_id int NOT NULL,
471    create_date datetime NOT NULL,
472    update_date datetime NOT NULL
473) TYPE=InnoDB;
474
475CREATE TABLE dtb_customer_favorite_products (
476    customer_id int NOT NULL,
477    product_id int NOT NULL,
478    create_date datetime NOT NULL,
479    update_date datetime NOT NULL
480) TYPE=InnoDB;
481
482CREATE TABLE dtb_category_count (
483    category_id int NOT NULL,
484    product_count int NOT NULL,
485    create_date datetime NOT NULL
486) TYPE=InnoDB;
487
488CREATE TABLE dtb_category_total_count (
489    category_id int NOT NULL,
490    product_count int,
491    create_date datetime NOT NULL
492) TYPE=InnoDB;
493
494CREATE TABLE dtb_news (
495    news_id int  NOT NULL,
496    news_date datetime,
497    rank int,
498    news_title text NOT NULL,
499    news_comment text,
500    news_url text,
501    news_select smallint NOT NULL DEFAULT 0,
502    link_method text,
503    creator_id int NOT NULL,
504    create_date datetime NOT NULL,
505    update_date datetime,
506    del_flg smallint NOT NULL DEFAULT 0,
507    PRIMARY KEY (news_id)
508) TYPE=InnoDB;
509
510CREATE TABLE dtb_best_products (
511    best_id int  NOT NULL,
512    category_id int NOT NULL,
513    rank int NOT NULL DEFAULT 0,
514    product_id int NOT NULL,
515    title text,
516    comment text,
517    creator_id int NOT NULL,
518    create_date datetime NOT NULL,
519    update_date datetime,
520    del_flg smallint NOT NULL DEFAULT 0,
521    PRIMARY KEY (best_id)
522) TYPE=InnoDB;
523
524CREATE TABLE dtb_mail_history (
525    send_id int  NOT NULL,
526    order_id int NOT NULL,
527    send_date datetime,
528    template_id int,
529    creator_id int NOT NULL,
530    subject text,
531    mail_body text,
532    PRIMARY KEY (send_id)
533) TYPE=InnoDB;
534
535CREATE TABLE dtb_customer (
536    customer_id int  NOT NULL,
537    name01 text NOT NULL,
538    name02 text NOT NULL,
539    kana01 text NOT NULL,
540    kana02 text NOT NULL,
541    zip01 text,
542    zip02 text,
543    pref smallint,
544    addr01 text,
545    addr02 text,
546    email text NOT NULL,
547    email_mobile text,
548    tel01 text,
549    tel02 text,
550    tel03 text,
551    fax01 text,
552    fax02 text,
553    fax03 text,
554    sex smallint,
555    job smallint,
556    birth datetime,
557    password text,
558    reminder smallint,
559    reminder_answer text,
560    secret_key varchar(50) NOT NULL UNIQUE,
561    first_buy_date datetime,
562    last_buy_date datetime,
563    buy_times numeric DEFAULT 0,
564    buy_total numeric DEFAULT 0,
565    point numeric DEFAULT 0,
566    note text,
567    status smallint NOT NULL DEFAULT 1,
568    create_date datetime NOT NULL,
569    update_date datetime,
570    del_flg smallint NOT NULL DEFAULT 0,
571    cell01 text,
572    cell02 text,
573    cell03 text,
574    mobile_phone_id text,
575    mailmaga_flg smallint,
576    PRIMARY KEY (customer_id)
577) TYPE=InnoDB;
578
579CREATE TABLE dtb_order (
580    order_id int  NOT NULL,
581    order_temp_id text,
582    customer_id int NOT NULL,
583    message text,
584    order_name01 text,
585    order_name02 text,
586    order_kana01 text,
587    order_kana02 text,
588    order_email text,
589    order_tel01 text,
590    order_tel02 text,
591    order_tel03 text,
592    order_fax01 text,
593    order_fax02 text,
594    order_fax03 text,
595    order_zip01 text,
596    order_zip02 text,
597    order_pref smallint,
598    order_addr01 text,
599    order_addr02 text,
600    order_sex smallint,
601    order_birth datetime,
602    order_job int,
603    deliv_name01 text,
604    deliv_name02 text,
605    deliv_kana01 text,
606    deliv_kana02 text,
607    deliv_tel01 text,
608    deliv_tel02 text,
609    deliv_tel03 text,
610    deliv_fax01 text,
611    deliv_fax02 text,
612    deliv_fax03 text,
613    deliv_zip01 text,
614    deliv_zip02 text,
615    deliv_pref smallint,
616    deliv_addr01 text,
617    deliv_addr02 text,
618    subtotal numeric,
619    discount numeric,
620    deliv_fee numeric,
621    charge numeric,
622    use_point numeric,
623    add_point numeric,
624    birth_point numeric DEFAULT 0,
625    tax numeric,
626    total numeric,
627    payment_total numeric,
628    payment_id int,
629    payment_method text,
630    deliv_id int,
631    deliv_time_id int,
632    deliv_time text,
633    deliv_no text,
634    note text,
635    status smallint,
636    create_date datetime NOT NULL,
637    loan_result text,
638    credit_result text,
639    credit_msg text,
640    update_date datetime,
641    commit_date datetime,
642    del_flg smallint NOT NULL DEFAULT 0,
643    deliv_date text,
644    conveni_data text,
645    cell01 text,
646    cell02 text,
647    cell03 text,
648    memo01 text,
649    memo02 text,
650    memo03 text,
651    memo04 text,
652    memo05 text,
653    memo06 text,
654    memo07 text,
655    memo08 text,
656    memo09 text,
657    memo10 text,
658    payment_date timestamp,
659    PRIMARY KEY (order_id)
660) TYPE=InnoDB;
661
662CREATE TABLE dtb_order_temp (
663    order_temp_id text NOT NULL,
664    customer_id int NOT NULL,
665    message text,
666    order_name01 text,
667    order_name02 text,
668    order_kana01 text,
669    order_kana02 text,
670    order_email text,
671    order_tel01 text,
672    order_tel02 text,
673    order_tel03 text,
674    order_fax01 text,
675    order_fax02 text,
676    order_fax03 text,
677    order_zip01 text,
678    order_zip02 text,
679    order_pref smallint,
680    order_addr01 text,
681    order_addr02 text,
682    order_sex smallint,
683    order_birth datetime,
684    order_job int,
685    deliv_name01 text,
686    deliv_name02 text,
687    deliv_kana01 text,
688    deliv_kana02 text,
689    deliv_tel01 text,
690    deliv_tel02 text,
691    deliv_tel03 text,
692    deliv_fax01 text,
693    deliv_fax02 text,
694    deliv_fax03 text,
695    deliv_zip01 text,
696    deliv_zip02 text,
697    deliv_pref smallint,
698    deliv_addr01 text,
699    deliv_addr02 text,
700    subtotal numeric,
701    discount numeric,
702    deliv_fee numeric,
703    charge numeric,
704    use_point numeric,
705    add_point numeric,
706    birth_point numeric DEFAULT 0,
707    tax numeric,
708    total numeric,
709    payment_total numeric,
710    payment_id int,
711    payment_method text,
712    deliv_id int,
713    deliv_time_id int,
714    deliv_time text,
715    deliv_no text,
716    note text,
717    mail_flag smallint,
718    status smallint,
719    deliv_check smallint,
720    point_check smallint,
721    loan_result text,
722    credit_result text,
723    credit_msg text,
724    create_date datetime NOT NULL,
725    update_date datetime,
726    del_flg smallint NOT NULL DEFAULT 0,
727    deliv_date text,
728    conveni_data text,
729    cell01 text,
730    cell02 text,
731    cell03 text,
732    order_id int,
733    memo01 text,
734    memo02 text,
735    memo03 text,
736    memo04 text,
737    memo05 text,
738    memo06 text,
739    memo07 text,
740    memo08 text,
741    memo09 text,
742    memo10 text,
743    session text
744) TYPE=InnoDB;
745
746CREATE TABLE dtb_other_deliv (
747    other_deliv_id int  NOT NULL,
748    customer_id int NOT NULL,
749    name01 text,
750    name02 text,
751    kana01 text,
752    kana02 text,
753    zip01 text,
754    zip02 text,
755    pref smallint,
756    addr01 text,
757    addr02 text,
758    tel01 text,
759    tel02 text,
760    tel03 text,
761    PRIMARY KEY (other_deliv_id)
762) TYPE=InnoDB;
763
764CREATE TABLE dtb_order_detail (
765    order_id int NOT NULL,
766    product_id int NOT NULL,
767    product_class_id int NOT NULL,
768    classcategory_id1 int NOT NULL,
769    classcategory_id2 int NOT NULL,
770    product_name text NOT NULL,
771    product_code text,
772    classcategory_name1 text,
773    classcategory_name2 text,
774    price numeric,
775    quantity numeric,
776    point_rate numeric
777) TYPE=InnoDB;
778
779CREATE TABLE mtb_pref (
780    pref_id smallint NOT NULL,
781    pref_name text,
782    rank smallint NOT NULL DEFAULT 0,
783    PRIMARY KEY (pref_id)
784) TYPE=InnoDB;
785
786CREATE TABLE dtb_member (
787    member_id int  NOT NULL,
788    name text,
789    department text,
790    login_id text NOT NULL,
791    password text NOT NULL,
792    authority smallint NOT NULL,
793    rank int NOT NULL DEFAULT 0,
794    work smallint NOT NULL DEFAULT 1,
795    del_flg smallint NOT NULL DEFAULT 0,
796    creator_id int NOT NULL,
797    update_date datetime,
798    create_date datetime NOT NULL,
799    login_date datetime,
800    PRIMARY KEY (member_id)
801) TYPE=InnoDB;
802
803CREATE TABLE dtb_bat_relate_products (
804    product_id int,
805    relate_product_id int,
806    customer_id int,
807    create_date datetime
808) TYPE=InnoDB;
809
810CREATE TABLE dtb_pagelayout (
811    page_id int  NOT NULL,
812    page_name text,
813    url text NOT NULL,
814    php_dir text,
815    tpl_dir text,
816    filename text,
817    header_chk smallint DEFAULT 1,
818    footer_chk smallint DEFAULT 1,
819    edit_flg smallint DEFAULT 1,
820    author text,
821    description text,
822    keyword text,
823    update_url text,
824    create_date datetime NOT NULL,
825    update_date datetime NOT NULL,
826    PRIMARY KEY (page_id)
827) TYPE=InnoDB;
828
829CREATE TABLE dtb_bloc (
830    bloc_id int  NOT NULL,
831    bloc_name text,
832    tpl_path text,
833    filename varchar(50) NOT NULL UNIQUE,
834    create_date datetime NOT NULL,
835    update_date datetime NOT NULL,
836    php_path text,
837    del_flg smallint NOT NULL DEFAULT 0,
838    PRIMARY KEY (bloc_id)
839) TYPE=InnoDB;
840
841CREATE TABLE dtb_blocposition (
842    page_id int NOT NULL,
843    target_id int,
844    bloc_id int,
845    bloc_row int,
846    filename text,
847    anywhere int DEFAULT 0 NOT NULL
848) TYPE=InnoDB;
849
850CREATE TABLE dtb_csv (
851    no int ,
852    csv_id int NOT NULL,
853    col text,
854    disp_name text,
855    rank int,
856    status smallint NOT NULL DEFAULT 1,
857    create_date datetime NOT NULL,
858    update_date datetime NOT NULL,
859    mb_convert_kana_option text,
860    PRIMARY KEY (no)
861) TYPE=InnoDB;
862
863CREATE TABLE dtb_csv_sql (
864    sql_id int ,
865    sql_name text NOT NULL,
866    csv_sql text,
867    update_date datetime NOT NULL,
868    create_date datetime NOT NULL,
869    PRIMARY KEY (sql_id)
870) TYPE=InnoDB;
871
872CREATE TABLE dtb_templates
873(
874    template_code varchar(50) NOT NULL,
875    template_name text,
876    create_date datetime NOT NULL,
877    update_date datetime NOT NULL,
878    PRIMARY KEY (template_code)
879) TYPE=InnoDB;
880
881CREATE TABLE dtb_table_comment
882(
883    id int ,
884    table_name text,
885    column_name text,
886    description text,
887    PRIMARY KEY (id)
888) TYPE=InnoDB;
889
890CREATE TABLE dtb_maker (
891    maker_id int ,
892    name text NOT NULL,
893    rank int NOT NULL DEFAULT 0,
894    creator_id int NOT NULL,
895    create_date datetime NOT NULL,
896    update_date datetime NOT NULL,
897    del_flg smallint NOT NULL DEFAULT 0,
898    PRIMARY KEY (maker_id)
899) TYPE=InnoDB;
900
901CREATE TABLE dtb_maker_count (
902    maker_id int NOT NULL,
903    product_count int NOT NULL,
904    create_date datetime NOT NULL
905) TYPE=InnoDB;
906
907
908CREATE TABLE mtb_permission (
909    id text,
910    name text,
911    rank smallint NOT NULL DEFAULT 0,
912    PRIMARY KEY (id(32))
913) TYPE=InnoDB;
914
915CREATE TABLE mtb_disable_logout (
916    id smallint,
917    name text,
918    rank smallint NOT NULL DEFAULT 0,
919    PRIMARY KEY (id)
920) TYPE=InnoDB;
921
922CREATE TABLE mtb_authority (
923    id smallint,
924    name text,
925    rank smallint NOT NULL DEFAULT 0,
926    PRIMARY KEY (id)
927) TYPE=InnoDB;
928
929CREATE TABLE mtb_work (
930    id smallint,
931    name text,
932    rank smallint NOT NULL DEFAULT 0,
933    PRIMARY KEY (id)
934) TYPE=InnoDB;
935
936CREATE TABLE mtb_disp (
937    id smallint,
938    name text,
939    rank smallint NOT NULL DEFAULT 0,
940    PRIMARY KEY (id)
941) TYPE=InnoDB;
942
943CREATE TABLE mtb_class (
944    id smallint,
945    name text,
946    rank smallint NOT NULL DEFAULT 0,
947    PRIMARY KEY (id)
948) TYPE=InnoDB;
949
950CREATE TABLE mtb_status (
951    id smallint,
952    name text,
953    rank smallint NOT NULL DEFAULT 0,
954    PRIMARY KEY (id)
955) TYPE=InnoDB;
956
957CREATE TABLE mtb_status_image (
958    id smallint,
959    name text,
960    rank smallint NOT NULL DEFAULT 0,
961    PRIMARY KEY (id)
962) TYPE=InnoDB;
963
964CREATE TABLE mtb_allowed_tag (
965    id smallint,
966    name text,
967    rank smallint NOT NULL DEFAULT 0,
968    PRIMARY KEY (id)
969) TYPE=InnoDB;
970
971CREATE TABLE mtb_page_max (
972    id smallint,
973    name text,
974    rank smallint NOT NULL DEFAULT 0,
975    PRIMARY KEY (id)
976) TYPE=InnoDB;
977
978CREATE TABLE mtb_magazine_type (
979    id smallint,
980    name text,
981    rank smallint NOT NULL DEFAULT 0,
982    PRIMARY KEY (id)
983) TYPE=InnoDB;
984
985CREATE TABLE mtb_mail_magazine_type (
986    id smallint,
987    name text,
988    rank smallint NOT NULL DEFAULT 0,
989    PRIMARY KEY (id)
990) TYPE=InnoDB;
991
992CREATE TABLE mtb_recommend (
993    id smallint,
994    name text,
995    rank smallint NOT NULL DEFAULT 0,
996    PRIMARY KEY (id)
997) TYPE=InnoDB;
998
999CREATE TABLE mtb_taxrule (
1000    id smallint,
1001    name text,
1002    rank smallint NOT NULL DEFAULT 0,
1003    PRIMARY KEY (id)
1004) TYPE=InnoDB;
1005
1006CREATE TABLE mtb_mail_template (
1007    id smallint,
1008    name text,
1009    rank smallint NOT NULL DEFAULT 0,
1010    PRIMARY KEY (id)
1011) TYPE=InnoDB;
1012
1013CREATE TABLE mtb_mail_tpl_path (
1014    id smallint,
1015    name text,
1016    rank smallint NOT NULL DEFAULT 0,
1017    PRIMARY KEY (id)
1018) TYPE=InnoDB;
1019
1020CREATE TABLE mtb_job (
1021    id smallint,
1022    name text,
1023    rank smallint NOT NULL DEFAULT 0,
1024    PRIMARY KEY (id)
1025) TYPE=InnoDB;
1026
1027CREATE TABLE mtb_reminder (
1028    id smallint,
1029    name text,
1030    rank smallint NOT NULL DEFAULT 0,
1031    PRIMARY KEY (id)
1032) TYPE=InnoDB;
1033
1034CREATE TABLE mtb_sex (
1035    id smallint,
1036    name text,
1037    rank smallint NOT NULL DEFAULT 0,
1038    PRIMARY KEY (id)
1039) TYPE=InnoDB;
1040
1041CREATE TABLE mtb_page_rows (
1042    id smallint,
1043    name text,
1044    rank smallint NOT NULL DEFAULT 0,
1045    PRIMARY KEY (id)
1046) TYPE=InnoDB;
1047
1048CREATE TABLE mtb_mail_type (
1049    id smallint,
1050    name text,
1051    rank smallint NOT NULL DEFAULT 0,
1052    PRIMARY KEY (id)
1053) TYPE=InnoDB;
1054
1055CREATE TABLE mtb_order_status (
1056    id smallint,
1057    name text,
1058    rank smallint NOT NULL DEFAULT 0,
1059    PRIMARY KEY (id)
1060) TYPE=InnoDB;
1061
1062CREATE TABLE mtb_product_status_color (
1063    id smallint,
1064    name text,
1065    rank smallint NOT NULL DEFAULT 0,
1066    PRIMARY KEY (id)
1067) TYPE=InnoDB;
1068
1069CREATE TABLE mtb_order_status_color (
1070    id smallint,
1071    name text,
1072    rank smallint NOT NULL DEFAULT 0,
1073    PRIMARY KEY (id)
1074) TYPE=InnoDB;
1075
1076CREATE TABLE mtb_wday (
1077    id smallint,
1078    name text,
1079    rank smallint NOT NULL DEFAULT 0,
1080    PRIMARY KEY (id)
1081) TYPE=InnoDB;
1082
1083CREATE TABLE mtb_delivery_date (
1084    id smallint,
1085    name text,
1086    rank smallint NOT NULL DEFAULT 0,
1087    PRIMARY KEY (id)
1088) TYPE=InnoDB;
1089
1090CREATE TABLE mtb_product_list_max (
1091    id smallint,
1092    name text,
1093    rank smallint NOT NULL DEFAULT 0,
1094    PRIMARY KEY (id)
1095) TYPE=InnoDB;
1096
1097CREATE TABLE mtb_convenience (
1098    id smallint,
1099    name text,
1100    rank smallint NOT NULL DEFAULT 0,
1101    PRIMARY KEY (id)
1102) TYPE=InnoDB;
1103
1104CREATE TABLE mtb_conveni_message (
1105    id smallint,
1106    name text,
1107    rank smallint NOT NULL DEFAULT 0,
1108    PRIMARY KEY (id)
1109) TYPE=InnoDB;
1110
1111CREATE TABLE mtb_db (
1112    id smallint,
1113    name text,
1114    rank smallint NOT NULL DEFAULT 0,
1115    PRIMARY KEY (id)
1116) TYPE=InnoDB;
1117
1118CREATE TABLE mtb_target (
1119    id smallint,
1120    name text,
1121    rank smallint NOT NULL DEFAULT 0,
1122    PRIMARY KEY (id)
1123) TYPE=InnoDB;
1124
1125CREATE TABLE mtb_review_deny_url (
1126    id smallint,
1127    name text,
1128    rank smallint NOT NULL DEFAULT 0,
1129    PRIMARY KEY (id)
1130) TYPE=InnoDB;
1131
1132CREATE TABLE mtb_track_back_status (
1133    id smallint,
1134    name text,
1135    rank smallint NOT NULL DEFAULT 0,
1136    PRIMARY KEY (id)
1137) TYPE=InnoDB;
1138
1139CREATE TABLE mtb_site_control_track_back (
1140    id smallint,
1141    name text,
1142    rank smallint NOT NULL DEFAULT 0,
1143    PRIMARY KEY (id)
1144) TYPE=InnoDB;
1145
1146CREATE TABLE mtb_site_control_affiliate (
1147    id smallint,
1148    name text,
1149    rank smallint NOT NULL DEFAULT 0,
1150    PRIMARY KEY (id)
1151) TYPE=InnoDB;
1152
1153CREATE TABLE mtb_mobile_domain (
1154    id smallint,
1155    name text,
1156    rank smallint NOT NULL DEFAULT 0,
1157    PRIMARY KEY (id)
1158) TYPE=InnoDB;
1159
1160CREATE TABLE mtb_ownersstore_err (
1161    id smallint,
1162    name text,
1163    rank smallint NOT NULL DEFAULT 0,
1164    PRIMARY KEY (id)
1165) TYPE=InnoDB;
1166
1167CREATE TABLE mtb_ownersstore_ips (
1168    id smallint,
1169    name text,
1170    rank smallint NOT NULL DEFAULT 0,
1171    PRIMARY KEY (id)
1172) TYPE=InnoDB;
1173
1174CREATE TABLE mtb_constants (
1175    id text,
1176    name text,
1177    rank smallint NOT NULL DEFAULT 0,
1178    remarks text,
1179    PRIMARY KEY (id(64))
1180) TYPE=InnoDB;
1181
1182CREATE TABLE mtb_down (
1183    id int2,
1184    name text,
1185    rank int2 NOT NULL,
1186    PRIMARY KEY (id)
1187) TYPE=InnoDB;
1188
1189CREATE TABLE dtb_mobile_ext_session_id (
1190    session_id text NOT NULL,
1191    param_key text,
1192    param_value text,
1193    url text,
1194    create_date timestamp NOT NULL DEFAULT now()
1195);
1196
1197CREATE TABLE dtb_mobile_kara_mail (
1198    kara_mail_id serial PRIMARY KEY,
1199    session_id text NOT NULL,
1200    token text NOT NULL,
1201    next_url text NOT NULL,
1202    create_date timestamp NOT NULL DEFAULT now(),
1203    email text,
1204    receive_date timestamp
1205);
1206
1207CREATE TABLE dtb_module (
1208    module_id int NOT NULL UNIQUE,
1209    module_code text NOT NULL,
1210    module_name text NOT NULL,
1211    sub_data text,
1212    auto_update_flg smallint NOT NULL DEFAULT 0,
1213    del_flg smallint NOT NULL DEFAULT 0,
1214    create_date datetime NOT NULL ,
1215    update_date datetime NOT NULL
1216) TYPE=InnoDB;
1217
1218CREATE TABLE dtb_session (
1219    sess_id varchar(50) NOT NULL,
1220    sess_data text,
1221    create_date datetime NOT NULL,
1222    update_date datetime NOT NULL,
1223    PRIMARY KEY (sess_id)
1224) TYPE=InnoDB;
1225
1226CREATE TABLE dtb_site_control (
1227    control_id int  NOT NULL,
1228    control_title varchar(255) ,
1229    control_text text ,
1230    control_flg int NOT NULL DEFAULT 2,
1231    del_flg int NOT NULL DEFAULT 0,
1232    memo text ,
1233    create_date datetime NOT NULL,
1234    update_date datetime NOT NULL,
1235    PRIMARY KEY  (control_id)
1236) TYPE=InnoDB;
1237
1238CREATE TABLE dtb_trackback (
1239    trackback_id int  NOT NULL,
1240    product_id int NOT NULL,
1241    blog_name varchar(255) NOT NULL DEFAULT '',
1242    title varchar(255) NOT NULL DEFAULT '',
1243    excerpt text NOT NULL ,
1244    url text NOT NULL ,
1245    status int NOT NULL DEFAULT 2,
1246    del_flg int NOT NULL DEFAULT 0,
1247    create_date datetime NOT NULL,
1248    update_date datetime NOT NULL,
1249    PRIMARY KEY (trackback_id)
1250) TYPE=InnoDB;
1251
1252CREATE TABLE dtb_bkup (
1253    bkup_name varchar(50),
1254    bkup_memo text,
1255    create_date datetime,
1256    PRIMARY KEY (bkup_name)
1257) TYPE=InnoDB;
1258
1259CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id(64));
1260CREATE INDEX dtb_products_class_product_id_key ON dtb_products_class(product_id);
1261CREATE INDEX dtb_order_detail_product_id_key ON dtb_order_detail(product_id);
1262CREATE INDEX dtb_send_customer_customer_id_key ON dtb_send_customer(customer_id);
1263CREATE INDEX dtb_mobile_ext_session_id_param_key_key ON dtb_mobile_ext_session_id (param_key(64));
1264CREATE INDEX dtb_mobile_ext_session_id_param_value_key ON dtb_mobile_ext_session_id (param_value(64));
1265CREATE INDEX dtb_mobile_ext_session_id_url_key ON dtb_mobile_ext_session_id (url(64));
1266CREATE INDEX dtb_mobile_ext_session_id_create_date_key ON dtb_mobile_ext_session_id (create_date);
1267CREATE INDEX dtb_mobile_kara_mail_token_key ON dtb_mobile_kara_mail (token(64));
1268CREATE INDEX dtb_mobile_kara_mail_create_date_key ON dtb_mobile_kara_mail (create_date);
1269CREATE INDEX dtb_mobile_kara_mail_receive_date_key ON dtb_mobile_kara_mail (receive_date);
Note: See TracBrowser for help on using the repository browser.