PHP Classes

File: SQL File

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

Contents

Class file image Download 
-- Add owner_id to files table for tracking file ownership

ALTER TABLE files ADD COLUMN owner_id INTEGER REFERENCES users(id) ON DELETE SET NULL;

-- Add index for querying files by owner
CREATE INDEX idx_files_owner_id ON files(owner_id);

COMMENT ON COLUMN files.owner_id IS 'User who uploaded the file (NULL for TIC files or system uploads)';