PHP Classes

File: SQL File

Recommend this page to a friend!
  Packages of Matthew Asham   Binkterm PHP   database/migrations/v1.11.0.22_file_subfolder.sql   Download  
File: database/migrations/v1.11.0.22_file_subfolder.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: Binkterm PHP
Bulletin board system based on the Web
Author: By
Last change:
Date: 5 days ago
Size: 440 bytes
 

Contents

Class file image Download 
-- Migration: v1.11.0.22 - Add subfolder support to files table
-- Allows files to be organized in virtual subfolders within a file area.
-- NULL means the file lives at the root of the area; a non-null value (e.g. 'incoming')
-- places the file in that named subfolder.

ALTER TABLE files ADD COLUMN IF NOT EXISTS subfolder VARCHAR(255) DEFAULT NULL;

CREATE INDEX IF NOT EXISTS idx_files_area_subfolder ON files(file_area_id, subfolder);