source: branches/version-2_5-dev/html/install/sql/create_table_pgsql.sql @ 18786

Revision 18786, 25.9 KB checked in by nanasess, 14 years ago (diff)

非推奨機能の削除(#793)

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