File: upgrade_kalkun_0.8.3.sql

package info (click to toggle)
kalkun 0.8.3.2-2
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 7,340 kB
  • sloc: php: 30,659; javascript: 30,443; sql: 961; sh: 766; xml: 105; makefile: 41
file content (17 lines) | stat: -rw-r--r-- 755 bytes parent folder | download | duplicates (2) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
 
-- --------------------------------------------------------

--
-- Upgrade plugins table to conform to the new CI3 plugin system
--

BEGIN;
ALTER TABLE "plugins" RENAME COLUMN "plugin_system_name" TO "system_name";
ALTER TABLE "plugins" RENAME COLUMN "plugin_name" TO "name";
ALTER TABLE "plugins" RENAME COLUMN "plugin_uri" TO "uri";
ALTER TABLE "plugins" RENAME COLUMN "plugin_version" TO "version";
ALTER TABLE "plugins" RENAME COLUMN "plugin_description" TO "description";
ALTER TABLE "plugins" RENAME COLUMN "plugin_author" TO "author";
ALTER TABLE "plugins" RENAME COLUMN "plugin_author_uri" TO "author_uri";
ALTER TABLE "plugins" RENAME COLUMN "plugin_data" TO "data";
ALTER TABLE "plugins" ADD COLUMN "status" smallint NOT NULL DEFAULT 1;
COMMIT;