- Timestamp:
- 2013/03/09 18:40:25 (11 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/camp/camp-2_13-tax/html/install/sql/create_table_pgsql.sql
r22619 r22637 74 74 zip01 text, 75 75 zip02 text, 76 country_id int, 76 77 pref smallint, 77 78 addr01 text, … … 88 89 law_zip01 text, 89 90 law_zip02 text, 91 law_country_id int, 90 92 law_pref smallint, 91 93 law_addr01 text, … … 485 487 zip01 text, 486 488 zip02 text, 489 country_id int, 487 490 pref smallint, 488 491 addr01 text, … … 538 541 order_zip01 text, 539 542 order_zip02 text, 543 order_country_id int, 540 544 order_pref smallint, 541 545 order_addr01 text, … … 597 601 order_zip01 text, 598 602 order_zip02 text, 603 order_country_id int, 599 604 order_pref smallint, 600 605 order_addr01 text, … … 655 660 shipping_fax02 text, 656 661 shipping_fax03 text, 662 shipping_country_id int, 657 663 shipping_pref smallint, 658 664 shipping_zip01 text, … … 694 700 zip01 text, 695 701 zip02 text, 702 country_id int, 696 703 pref smallint, 697 704 addr01 text, … … 1100 1107 name text, 1101 1108 rank smallint NOT NULL, 1109 PRIMARY KEY (id) 1110 ); 1111 1112 CREATE TABLE mtb_country ( 1113 id int, 1114 name text, 1115 rank int NOT NULL, 1102 1116 PRIMARY KEY (id) 1103 1117 );
Note: See TracChangeset
for help on using the changeset viewer.