Changeset 19188 for branches/camp/camp-2_5-E/data/class/pages

Timestamp:

2010/11/06 23:51:14 (16 years ago)

Author:

miningbrownie

Message:

 

File:

• branches/camp/camp-2_5-E/data/class/pages/admin/system/LC_Page_Admin_System_Plugin.php (modified) (1 diff)

branches/camp/camp-2_5-E/data/class/pages/admin/system/LC_Page_Admin_System_Plugin.php

@@ -70 +70 @@
     function process() {
         $query = new SC_Query();
-        $query->query("");
+        $sql = <<< SQL
+    DROP TABLE IF EXISTS "dtb_plugin";
+CREATE TABLE "dtb_plugin" (
+  "id" int4 NOT NULL DEFAULT NULL,
+  "name" text NOT NULL DEFAULT NULL,
+  "enable" int2 NOT NULL DEFAULT 0,
+  "del_flg" int2 NOT NULL DEFAULT 0,
+  "class_name" text NOT NULL DEFAULT NULL,
+  "create_date" timestamp(6) NOT NULL DEFAULT now(),
+  "update_date" timestamp(6) NOT NULL DEFAULT now()
+)
+WITH (OIDS=FALSE);
+ALTER TABLE "dtb_plugin" ADD CONSTRAINT "dtb_plugin_pkey" PRIMARY KEY ("id");    
+SQL;
+        $query->query();
+        
         exit;
         SC_Utils_Ex::sfIsSuccess(new SC_Session);