Changeset 21455 for branches/version-2_12-dev/html/install

Timestamp:

2012/02/08 13:55:06 (14 years ago)

Author:

h_yoshimoto

Message:

#1603 #1632 プラグインの管理画面を作成しました。それに伴うエンジン部分の修正。

Location:

branches/version-2_12-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_12-dev/html/install/sql/create_table_mysql.sql

@@ -1139 +1139 @@
     plugin_code varchar(255) NOT NULL,
     author varchar(255),
+    author_site_url varchar(255),
     plugin_site_url varchar(255),
     plugin_version varchar(255),
+    compliant_version varchar(255),
     plugin_description varchar(255),
-    plugin_setting_path varchar(255),
-    class_name varchar(255) NOT NULL,
     rank int NOT NULL DEFAULT 0,
-    status smallint NOT NULL DEFAULT 0,
     enable smallint NOT NULL DEFAULT 0,
-    del_flg smallint NOT NULL DEFAULT 0,
     create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
     update_date timestamp NOT NULL,
     PRIMARY KEY (plugin_id)
+) ENGINE=InnoDB;
+
+CREATE TABLE dtb_plugin_hookpoint (
+    plugin_id int NOT NULL,
+    hook_point varchar(255) NOT NULL,
+    create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    update_date timestamp NOT NULL
 ) ENGINE=InnoDB;
 

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

@@ -1139 +1139 @@
     plugin_code text NOT NULL,
     author text,
+    author_site_url text,
     plugin_site_url text,
     plugin_version text,
+    compliant_version text,    
     plugin_description text,
-    plugin_setting_path text,
-    class_name text NOT NULL,
     rank int NOT NULL DEFAULT 0,
-    status smallint NOT NULL DEFAULT 0,
     enable smallint NOT NULL DEFAULT 0,
-    del_flg smallint NOT NULL DEFAULT 0,
     create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
     update_date timestamp NOT NULL,
     PRIMARY KEY (plugin_id)
 );
+
+CREATE TABLE dtb_plugin_hookpoint (
+    plugin_id int NOT NULL,
+    hook_point text NOT NULL,
+    create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    update_date timestamp NOT NULL
+);
+
 
 CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id);

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

@@ -1275 +1275 @@
 INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('PLUGIN_TMPL_CACHE_REALDIR', 'PLUGIN_UPLOAD_REALDIR . "templates_cache/"', 606, 'プラグイン・テンプレートキャッシュ保存先');
 INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('PLUGIN_DIR_PERMISSION', '0777', 607, 'プラグイン・ディレクトリパーミッション');
+INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('PLUGIN_TEMP_REALDIR', 'HTML_REALDIR . "upload/temp_plugin/"', 608, 'プラグインファイル一時保存先');
+INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('DOWNLOADS_TEMP_DIR', 'DATA_REALDIR . "downloads/tmp/"', 609, 'アップロード一時ディレクトリ');
+INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('PLUGIN_HTML_URL', 'USER_URL . PLUGIN_DIR', 610, 'プラグイン 外部ファイルURL');
 INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('DOWNLOAD_DAYS_LEN', '3', 700, '日数桁数');
 INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('DOWNLOAD_EXTENSION', '"zip,lzh,jpg,jpeg,gif,png,mp3,pdf,csv"', 701, 'ダウンロードファイル登録可能拡張子(カンマ区切り)"');