File: mysql_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 (6 lines) | stat: -rw-r--r-- 456 bytes parent folder | download 
1
2
3
4
5
6
 
ALTER TABLE dc_post_media ADD COLUMN link_type VARCHAR(32) NOT NULL DEFAULT 'attachment';
ALTER TABLE dc_post_media DROP PRIMARY KEY, ADD PRIMARY KEY(media_id,post_id,link_type);
ALTER TABLE dc_post_media ADD INDEX dc_idx_post_media_media_id USING btree (media_id);
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';