Changeset 20058

Timestamp:

2011/01/31 16:08:12 (12 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:

• docs/eccube-diagram.jude (modified) (previous)
• html/install/sql/create_table_mysql.sql (modified) (2 diffs)
• html/install/sql/create_table_pgsql.sql (modified) (2 diffs)

branches/version-2_5-dev/html/install/sql/create_table_mysql.sql

@@ -1144 +1144 @@
 ) ENGINE=InnoDB;
 
-CREATE TABLE mtb_track_back_status (
-    id smallint,
-    name text,
-    rank smallint NOT NULL DEFAULT 0,
-    PRIMARY KEY (id)
-) ENGINE=InnoDB;
-
-CREATE TABLE mtb_site_control_track_back (
-    id smallint,
-    name text,
-    rank smallint NOT NULL DEFAULT 0,
-    PRIMARY KEY (id)
-) ENGINE=InnoDB;
-
-CREATE TABLE mtb_site_control_affiliate (
-    id smallint,
-    name text,
-    rank smallint NOT NULL DEFAULT 0,
-    PRIMARY KEY (id)
-) ENGINE=InnoDB;
-
 CREATE TABLE mtb_mobile_domain (
     id smallint,
@@ -1243 +1222 @@
     update_date timestamp NOT NULL,
     PRIMARY KEY (sess_id)
-) ENGINE=InnoDB;
-
-CREATE TABLE dtb_site_control (
-    control_id int NOT NULL,
-    control_title varchar(255),
-    control_text text,
-    control_flg smallint NOT NULL DEFAULT 2,
-    del_flg smallint NOT NULL DEFAULT 0,
-    memo text,
-    create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
-    update_date timestamp NOT NULL,
-    PRIMARY KEY (control_id)
-) ENGINE=InnoDB;
-
-CREATE TABLE dtb_trackback (
-    trackback_id int  NOT NULL,
-    product_id int NOT NULL,
-    blog_name varchar(255) NOT NULL,
-    title varchar(255) NOT NULL,
-    excerpt text NOT NULL,
-    url text NOT NULL,
-    status smallint NOT NULL DEFAULT 2,
-    del_flg smallint NOT NULL DEFAULT 0,
-    create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
-    update_date timestamp NOT NULL,
-    PRIMARY KEY (trackback_id)
 ) ENGINE=InnoDB;
 

branches/version-2_5-dev/html/install/sql/create_table_pgsql.sql

@@ -1144 +1144 @@
 );
 
-CREATE TABLE mtb_track_back_status (
-    id smallint,
-    name text,
-    rank smallint NOT NULL DEFAULT 0,
-    PRIMARY KEY (id)
-);
-
-CREATE TABLE mtb_site_control_track_back (
-    id smallint,
-    name text,
-    rank smallint NOT NULL DEFAULT 0,
-    PRIMARY KEY (id)
-);
-
-CREATE TABLE mtb_site_control_affiliate (
-    id smallint,
-    name text,
-    rank smallint NOT NULL DEFAULT 0,
-    PRIMARY KEY (id)
-);
-
 CREATE TABLE mtb_mobile_domain (
     id smallint,
@@ -1243 +1222 @@
     update_date timestamp NOT NULL,
     PRIMARY KEY (sess_id)
-);
-
-CREATE TABLE dtb_site_control (
-    control_id int NOT NULL,
-    control_title text,
-    control_text text,
-    control_flg smallint NOT NULL DEFAULT 2,
-    del_flg smallint NOT NULL DEFAULT 0,
-    memo text,
-    create_date timestamp NOT NULL DEFAULT now(),
-    update_date timestamp NOT NULL,
-    PRIMARY KEY (control_id)
-);
-
-CREATE TABLE dtb_trackback (
-    trackback_id int NOT NULL,
-    product_id int NOT NULL,
-    blog_name text NOT NULL,
-    title text NOT NULL,
-    excerpt text NOT NULL,
-    url text NOT NULL,
-    status smallint NOT NULL DEFAULT 2,
-    del_flg smallint NOT NULL DEFAULT 0,
-    create_date timestamp NOT NULL DEFAULT now(),
-    update_date timestamp NOT NULL,
-    PRIMARY KEY (trackback_id)
 );