Changeset 20058


Ignore:
Timestamp:
2011/01/31 16:08:12 (11 years ago)
Author:
nanasess
bzr:base-revision:
svn-v4:1e3b908f-19a9-db11-a64c-001125224ba8:branches/version-2_5-dev:20057
bzr:committer:
Kentaro Ohkouchi <ohkouchi@loop-az.jp>
bzr:file-ids:

docs/eccube-diagram.jude eccubediagram.jude-20101102081620-jpq1fqmox6ocmuj3-2
html/install/sql/create_table_mysql.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Fcreate_table_mysql.sql
html/install/sql/create_table_pgsql.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Fcreate_table_pgsql.sql
bzr:mapping-version:
v4
bzr:merge:

ohkouchi@loop-az.jp-20110131070215-0efa3nufe1gf4vo8
bzr:repository-uuid:
1e3b908f-19a9-db11-a64c-001125224ba8
bzr:revision-id:
ohkouchi@loop-az.jp-20110131070806-32yejvf8rpfwqkkf
bzr:revno:
2786
bzr:revprop:branch-nick:
branches/version-2_5-dev
bzr:root:
branches/version-2_5-dev
bzr:text-revisions:

docs/eccube-diagram.jude ohkouchi@loop-az.jp-20110131070215-0efa3nufe1gf4vo8
html/install/sql/create_table_mysql.sql ohkouchi@loop-az.jp-20110131070215-0efa3nufe1gf4vo8
html/install/sql/create_table_pgsql.sql ohkouchi@loop-az.jp-20110131070215-0efa3nufe1gf4vo8
bzr:timestamp:
2011-01-31 16:08:06.019999981 +0900
bzr:user-agent:
bzr2.2.1+bzr-svn1.0.4
svn:original-date:
2011-01-31T07:08:06.020000Z
Message:

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

  • トラックバック関連のテーブルを削除
Location:
branches/version-2_5-dev
Files:
3 edited

Legend:

Unmodified
Added
Removed
  • branches/version-2_5-dev/html/install/sql/create_table_mysql.sql

    r20057 r20058  
    11441144) ENGINE=InnoDB; 
    11451145 
    1146 CREATE TABLE mtb_track_back_status ( 
    1147     id smallint, 
    1148     name text, 
    1149     rank smallint NOT NULL DEFAULT 0, 
    1150     PRIMARY KEY (id) 
    1151 ) ENGINE=InnoDB; 
    1152  
    1153 CREATE TABLE mtb_site_control_track_back ( 
    1154     id smallint, 
    1155     name text, 
    1156     rank smallint NOT NULL DEFAULT 0, 
    1157     PRIMARY KEY (id) 
    1158 ) ENGINE=InnoDB; 
    1159  
    1160 CREATE TABLE mtb_site_control_affiliate ( 
    1161     id smallint, 
    1162     name text, 
    1163     rank smallint NOT NULL DEFAULT 0, 
    1164     PRIMARY KEY (id) 
    1165 ) ENGINE=InnoDB; 
    1166  
    11671146CREATE TABLE mtb_mobile_domain ( 
    11681147    id smallint, 
     
    12431222    update_date timestamp NOT NULL, 
    12441223    PRIMARY KEY (sess_id) 
    1245 ) ENGINE=InnoDB; 
    1246  
    1247 CREATE TABLE dtb_site_control ( 
    1248     control_id int NOT NULL, 
    1249     control_title varchar(255), 
    1250     control_text text, 
    1251     control_flg smallint NOT NULL DEFAULT 2, 
    1252     del_flg smallint NOT NULL DEFAULT 0, 
    1253     memo text, 
    1254     create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 
    1255     update_date timestamp NOT NULL, 
    1256     PRIMARY KEY (control_id) 
    1257 ) ENGINE=InnoDB; 
    1258  
    1259 CREATE TABLE dtb_trackback ( 
    1260     trackback_id int  NOT NULL, 
    1261     product_id int NOT NULL, 
    1262     blog_name varchar(255) NOT NULL, 
    1263     title varchar(255) NOT NULL, 
    1264     excerpt text NOT NULL, 
    1265     url text NOT NULL, 
    1266     status smallint NOT NULL DEFAULT 2, 
    1267     del_flg smallint NOT NULL DEFAULT 0, 
    1268     create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 
    1269     update_date timestamp NOT NULL, 
    1270     PRIMARY KEY (trackback_id) 
    12711224) ENGINE=InnoDB; 
    12721225 
  • branches/version-2_5-dev/html/install/sql/create_table_pgsql.sql

    r20057 r20058  
    11441144); 
    11451145 
    1146 CREATE TABLE mtb_track_back_status ( 
    1147     id smallint, 
    1148     name text, 
    1149     rank smallint NOT NULL DEFAULT 0, 
    1150     PRIMARY KEY (id) 
    1151 ); 
    1152  
    1153 CREATE TABLE mtb_site_control_track_back ( 
    1154     id smallint, 
    1155     name text, 
    1156     rank smallint NOT NULL DEFAULT 0, 
    1157     PRIMARY KEY (id) 
    1158 ); 
    1159  
    1160 CREATE TABLE mtb_site_control_affiliate ( 
    1161     id smallint, 
    1162     name text, 
    1163     rank smallint NOT NULL DEFAULT 0, 
    1164     PRIMARY KEY (id) 
    1165 ); 
    1166  
    11671146CREATE TABLE mtb_mobile_domain ( 
    11681147    id smallint, 
     
    12431222    update_date timestamp NOT NULL, 
    12441223    PRIMARY KEY (sess_id) 
    1245 ); 
    1246  
    1247 CREATE TABLE dtb_site_control ( 
    1248     control_id int NOT NULL, 
    1249     control_title text, 
    1250     control_text text, 
    1251     control_flg smallint NOT NULL DEFAULT 2, 
    1252     del_flg smallint NOT NULL DEFAULT 0, 
    1253     memo text, 
    1254     create_date timestamp NOT NULL DEFAULT now(), 
    1255     update_date timestamp NOT NULL, 
    1256     PRIMARY KEY (control_id) 
    1257 ); 
    1258  
    1259 CREATE TABLE dtb_trackback ( 
    1260     trackback_id int NOT NULL, 
    1261     product_id int NOT NULL, 
    1262     blog_name text NOT NULL, 
    1263     title text NOT NULL, 
    1264     excerpt text NOT NULL, 
    1265     url text NOT NULL, 
    1266     status smallint NOT NULL DEFAULT 2, 
    1267     del_flg smallint NOT NULL DEFAULT 0, 
    1268     create_date timestamp NOT NULL DEFAULT now(), 
    1269     update_date timestamp NOT NULL, 
    1270     PRIMARY KEY (trackback_id) 
    12711224); 
    12721225 
Note: See TracChangeset for help on using the changeset viewer.