PHP Classes

File: SQL File

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

Contents

Class file image Download 
-- Migration: 1.9.3.4 - Add referral tracking to pending users
ALTER TABLE pending_users
ADD COLUMN IF NOT EXISTS referral_code VARCHAR(50),
ADD COLUMN IF NOT EXISTS referrer_id INT REFERENCES users(id) ON DELETE SET NULL;

CREATE INDEX IF NOT EXISTS idx_pending_users_referrer_id ON pending_users(referrer_id);