VPS 4 Builder
20 lines
751 B
SQL
20 lines
751 B
SQL
-- leads plugin: add user_id and lead_type columns for classification
|
|
|
|
SET @col_exists = (SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS
|
|
WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'leads' AND COLUMN_NAME = 'user_id');
|
|
SET @sql = IF(@col_exists = 0,
|
|
'ALTER TABLE leads ADD COLUMN user_id INT NULL',
|
|
'SELECT 1');
|
|
PREPARE stmt FROM @sql;
|
|
EXECUTE stmt;
|
|
DEALLOCATE PREPARE stmt;
|
|
|
|
SET @col_exists = (SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS
|
|
WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'leads' AND COLUMN_NAME = 'lead_type');
|
|
SET @sql = IF(@col_exists = 0,
|
|
'ALTER TABLE leads ADD COLUMN lead_type ENUM(\'cold\',\'member\') NOT NULL DEFAULT ''cold''',
|
|
'SELECT 1');
|
|
PREPARE stmt FROM @sql;
|
|
EXECUTE stmt;
|
|
DEALLOCATE PREPARE stmt;
|