Changeset 23475 for branches/version-2_13-dev/html/install/sql

Timestamp:

2014/05/30 16:56:25 (12 years ago)

Author:

shutta

Message:

#2488 mtb_ownersstore_ipsの削除
mtb_ownersstore_ipsマスターに関連する部分を全て削除。

Location:

branches/version-2_13-dev/html/install/sql

Files:

• comment_set_pgsql_2.13.sql (modified) (1 diff)
• create_table_pgsql.sql (modified) (1 diff)
• drop_table.sql (modified) (1 diff)
• insert_data.sql (modified) (2 diffs)

branches/version-2_13-dev/html/install/sql/comment_set_pgsql_2.13.sql

@@ -64 +64 @@
 COMMENT ON COLUMN dtb_other_deliv.fax02 IS 'FAX（市内局番）';
 COMMENT ON COLUMN dtb_other_deliv.fax03 IS 'FAX（局番）';
-
-COMMENT ON TABLE mtb_ownersstore_ips IS 'オーナーズストアIPアドレス';
-COMMENT ON COLUMN mtb_ownersstore_ips.id IS 'ID';
-COMMENT ON COLUMN mtb_ownersstore_ips.name IS '名称';
-COMMENT ON COLUMN mtb_ownersstore_ips.rank IS '表示順';
 
 COMMENT ON TABLE mtb_ownersstore_err IS 'オーナーズストアエラー種別';

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

@@ -1087 +1087 @@
 );
 
-CREATE TABLE mtb_ownersstore_ips (
-    id smallint,
-    name text,
-    rank smallint NOT NULL DEFAULT 0,
-    PRIMARY KEY (id)
-);
-
 CREATE TABLE mtb_constants (
     id text,

branches/version-2_13-dev/html/install/sql/drop_table.sql

@@ -77 +77 @@
 DROP TABLE mtb_allowed_tag;
 DROP TABLE mtb_ownersstore_err;
-DROP TABLE mtb_ownersstore_ips;
 DROP TABLE dtb_maker;
 DROP TABLE dtb_maker_count;

branches/version-2_13-dev/html/install/sql/insert_data.sql

@@ -12 +12 @@
 INSERT INTO dtb_bloc (device_type_id, bloc_id, bloc_name, tpl_path, filename, create_date, update_date, php_path, deletable_flg) VALUES (1, 3, 'おすすめ商品', 'recommend.tpl', 'recommend', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'frontparts/bloc/recommend.php', 0);
 INSERT INTO dtb_bloc (device_type_id, bloc_id, bloc_name, tpl_path, filename, create_date, update_date, php_path, deletable_flg) VALUES (1, 4, 'カテゴリ', 'category.tpl', 'category', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'frontparts/bloc/category.php', 0);
+INSERT INTO dtb_bloc (device_type_id, bloc_id, bloc_name, tpl_path, filename, create_date, update_date, php_path, deletable_flg) VALUES (1, 5, 'ログイン', 'login.tpl', 'login', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'frontparts/bloc/login.php', 0);
+INSERT INTO dtb_bloc (device_type_id, bloc_id, bloc_name, tpl_path, filename, create_date, update_date, php_path, deletable_flg) VALUES (1, 6, '【ヘッダー】ログイン', 'login_header.tpl', 'login_header', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'frontparts/bloc/login_header.php', 0);
 INSERT INTO dtb_bloc (device_type_id, bloc_id, bloc_name, tpl_path, filename, create_date, update_date, php_path, deletable_flg) VALUES (2, 1, '新着情報', 'news.tpl', 'news', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'frontparts/bloc/news.php', 0);
 INSERT INTO dtb_bloc (device_type_id, bloc_id, bloc_name, tpl_path, filename, create_date, update_date, php_path, deletable_flg) VALUES (2, 2, 'ログイン', 'login.tpl', 'login', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'frontparts/bloc/login.php', 0);
@@ -877 +879 @@
 INSERT INTO mtb_ownersstore_err (id, name, rank) VALUES ('2009', 'ファイルの書き込みに失敗しました。<br />・書き込み権限が正しく設定されていません。<br />・data/downloads/tmpディレクトリに書き込み権限があるかどうか確認してください', 16);
 INSERT INTO mtb_ownersstore_err (id, name, rank) VALUES ('2010', 'ファイルの書き込みに失敗しました。<br />・「ログ管理」で詳細を確認してください。', 17);
-
-INSERT INTO mtb_ownersstore_ips (id, name, rank) VALUES ('0', '210.188.195.143', 0);
 
 INSERT INTO mtb_page_max (id, name, rank) VALUES (10, '10', 0);