Changeset 11727

Timestamp:

2007/03/09 22:50:36 (17 years ago)

Author:

uehara

Message:

 

Location:

branches/dev/html/install/sql

Files:

• create_table_mysql.sql (modified) (4 diffs)
• create_table_pgsql.sql (modified) (3 diffs)

branches/dev/html/install/sql/create_table_mysql.sql

@@ -159 +159 @@
     payment_image text,
     upper_rule numeric,
-    charge_flg int2 DEFAULT 1,
-    rule_min numeric,
-    upper_rule_max numeric,
+    charge_flg int2 DEFAULT 1,
+    rule_min numeric,
+    upper_rule_max numeric,
     module_id int4,
     module_path text,
@@ -518 +518 @@
     cell02 text,
     cell03 text,
-    mobile_phone_id text
+    mobile_phone_id text,
+    mailmaga_flg smallint
 ) TYPE=InnoDB ;
 
@@ -692 +693 @@
     cell02 text,
     cell03 text,
-    order_id int4,
+    order_id int4,
     memo01 text,
     memo02 text,
@@ -902 +903 @@
 CREATE TABLE dtb_templates 
 (
-    template_code       varchar(50) NOT NULL UNIQUE ,
-    template_name       text            ,
-    create_date     datetime        NOT NULL    ,
-    update_date     datetime        NOT NULL    
+    template_code        varchar(50) NOT NULL UNIQUE    ,
+    template_name        text            ,
+    create_date        datetime        NOT NULL    ,
+    update_date        datetime        NOT NULL    
 ) TYPE=InnoDB ;
 
 CREATE TABLE dtb_table_comment
 (
-    id  int auto_increment primary key,
-    table_name  text,
-    column_name text,
-    description text
-) TYPE=InnoDB ;
+    id    int auto_increment primary key,
+    table_name    text,
+    column_name    text,
+    description    text
+) TYPE=InnoDB ;
+

branches/dev/html/install/sql/create_table_pgsql.sql

@@ -159 +159 @@
     payment_image text,
     upper_rule numeric,
-    charge_flg int2 DEFAULT 1,
-    rule_min numeric,
-    upper_rule_max numeric,
+    charge_flg int2 DEFAULT 1,
+    rule_min numeric,
+    upper_rule_max numeric,
     module_id int4,
     module_path text,
@@ -518 +518 @@
     cell02 text,
     cell03 text,
-    mobile_phone_id text
+    mobile_phone_id text,
+    mailmaga_flg int2
 );
 
@@ -903 +904 @@
 create table dtb_templates 
 (
-template_code       text        NOT NULL UNIQUE ,
-template_name       text            ,
-create_date     timestamp       NOT NULL    default now(),
-update_date     timestamp       NOT NULL    default now()
+template_code        text        NOT NULL UNIQUE    ,
+template_name        text            ,
+create_date        timestamp        NOT NULL    default now(),
+update_date        timestamp        NOT NULL    default now()
 );
 
 create table dtb_table_comment
 (
-id  serial,
-table_name  text,
-column_name text,
-description text
-);
+id    serial,
+table_name    text,
+column_name    text,
+description    text
+);
+