Changeset 17263 for branches/comu-ver2/html/install/sql/create_table_pgsql.sql

Timestamp:

2008/04/16 20:13:17 (16 years ago)

Author:

Yammy

Message:

メーカー検索機能
http://svn.ec-cube.net/open_trac/ticket/273
実装

File:

• branches/comu-ver2/html/install/sql/create_table_pgsql.sql (modified) (2 diffs)

branches/comu-ver2/html/install/sql/create_table_pgsql.sql

@@ -275 +275 @@
     sale_unlimited int2 DEFAULT 0,
     category_id int4,
+    maker_id int4,
     rank int4,
     status int2 NOT NULL DEFAULT 2,
@@ -953 +954 @@
 );
 
+CREATE TABLE dtb_maker (
+    maker_id serial NOT NULL,
+    name text NOT NULL,
+    rank int4 NOT NULL DEFAULT 0,
+    creator_id int4 NOT NULL,
+    create_date timestamp NOT NULL DEFAULT now(),
+    update_date timestamp NOT NULL,
+    del_flg  int2 NOT NULL DEFAULT 0
+);
+
+CREATE TABLE dtb_maker_count (
+    maker_id int4 NOT NULL,
+    product_count int4 NOT NULL,
+    create_date timestamp NOT NULL DEFAULT Now()
+);
+
 CREATE TABLE mtb_permission (
     id text,