Changeset 20246 for branches/version-2_5-dev/html

Timestamp:

2011/02/20 12:03:00 (12 years ago)

Author:

kotani

Message:

#976 ([管理画面]プラグイン)

• プラグインアップロード機能追加
• リファクタリング開発
• SC_CheckError 拡張子チェックメソッドFILE_EXT_CHECK() を、判定拡張子にピリオドが複数ある場合にも対応するよう修正

Location:

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

Files:

• create_table_mysql.sql (modified) (1 diff)
• create_table_pgsql.sql (modified) (1 diff)
• insert_data.sql (modified) (1 diff)

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

@@ -1232 +1232 @@
 CREATE TABLE dtb_plugin (
     plugin_id int NOT NULL,
-    plugin_name varchar(255) NOT NULL,
+    plugin_name varchar(255) NOT NULL DEFAULT '',
+    plugin_code varchar(255) NOT NULL,
+    author varchar(255) NOT NULL DEFAULT '',
+    plugin_site_url varchar(255) NOT NULL DEFAULT '',
+    plugin_version varchar(255) NOT NULL DEFAULT '',
+    plugin_description varchar(255) NOT NULL DEFAULT '',
+    plugin_setting_path varchar(255) NOT NULL DEFAULT '',
+    class_name varchar(255) NOT NULL DEFAULT '',
+    status smallint NOT NULL DEFAULT 0,
     enable smallint NOT NULL DEFAULT 0,
     del_flg smallint NOT NULL DEFAULT 0,
-    class_name varchar(255) NOT NULL,
     create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
     update_date timestamp NOT NULL,

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

@@ -1232 +1232 @@
 CREATE TABLE dtb_plugin (
     plugin_id int NOT NULL,
-    plugin_name text NOT NULL,
+    plugin_name text NOT NULL DEFAULT '',
+    plugin_code text NOT NULL,
+    author text NOT NULL DEFAULT '',
+    plugin_site_url text NOT NULL DEFAULT '',
+    plugin_version text NOT NULL DEFAULT '',
+    plugin_description text NOT NULL DEFAULT '',
+    plugin_setting_path text NOT NULL DEFAULT '',
+    class_name text NOT NULL DEFAULT '',
+    status smallint NOT NULL DEFAULT 0,
     enable smallint NOT NULL DEFAULT 0,
     del_flg smallint NOT NULL DEFAULT 0,
-    class_name text NOT NULL,
     create_date timestamp NOT NULL DEFAULT now(),
     update_date timestamp NOT NULL,

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

@@ -1271 +1271 @@
 INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('ECCUBE_INFO', 'true', 1218, ' EC-CUBE更新情報取得 (true:取得する false:取得しない)');
 INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('HTTP_REQUEST_TIMEOUT', '"5"', 1219, '外部サイトHTTP取得タイムアウト時間(秒)');
+INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('PLUGIN_STATUS_UPLOADED', '"1"', 1220, 'プラグインの状態：アップロード済み');
+INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('PLUGIN_STATUS_INSTALLED', '"2"', 1221, 'プラグインの状態：インストール済み');
+INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('PLUGIN_ENABLE_TRUE', '"1"', 1222, 'プラグイン有効/無効：有効');
+INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('PLUGIN_ENABLE_FALSE', '"2"', 1223, 'プラグイン有効/無効：無効');
 
 INSERT INTO dtb_index_list (table_name, column_name, recommend_flg, recommend_comment) VALUES ('dtb_customer', 'email_mobile', 0, '会員数増加時のログイン処理速度を向上させたいときに試してみてください');