File: pgsql_upgrade_2.4.0.sql

package info (click to toggle)
dotclear 2.6.4%2Bdfsg-1
  • links: PTS, VCS
  • area: main
  • in suites: jessie-kfreebsd
  • size: 8,420 kB
  • sloc: php: 54,270; sql: 1,290; sh: 213; xml: 173; makefile: 158
file content (5 lines) | stat: -rw-r--r-- 439 bytes parent folder | download 
1
2
3
4
5
 
ALTER TABLE dc_post_media ADD COLUMN link_type VARCHAR(32) NOT NULL DEFAULT 'attachment';
ALTER TABLE dc_post_media DROP CONSTRAINT dc_pk_post_media;
ALTER TABLE dc_post_media ADD CONSTRAINT dc_pk_post_media PRIMARY KEY (media_id,post_id,link_type);
UPDATE dc_setting SET setting_value = '/\.php$/i' WHERE setting_id = 'media_exclusion' AND setting_value = '';
UPDATE dc_version SET module = 'core', version = '2.4.0' WHERE module='core';