PHP Classes

File: SQL File

Recommend this page to a friend!
  Packages of Matthew Asham   Binkterm PHP   database/migrations/v1.11.0.33_public_file_areas.sql   Download  
File: database/migrations/v1.11.0.33_public_file_areas.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: 479 bytes
 

Contents

Class file image Download 
-- Migration: v1.11.0.33 - Add is_public flag to file areas
-- Allows individual file areas to be accessible to unauthenticated visitors.
-- Requires a valid license to enable (enforced in PHP).

ALTER TABLE file_areas ADD COLUMN IF NOT EXISTS is_public BOOLEAN NOT NULL DEFAULT FALSE;

-- Partial index for efficient lookup of public areas (sparse - most areas are not public)
CREATE INDEX IF NOT EXISTS idx_file_areas_is_public ON file_areas(is_public) WHERE is_public = TRUE;