9 lines
385 B
SQL
9 lines
385 B
SQL
-- Migration: Create shop_perks table
|
|
CREATE TABLE IF NOT EXISTS shop_perks (
|
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
perk_type VARCHAR(50) NOT NULL, -- "pinned_message", "background"
|
|
perk_value TEXT NOT NULL, -- The message text or the image URL
|
|
user_name VARCHAR(255) NOT NULL,
|
|
expires_at TIMESTAMP NOT NULL,
|
|
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
|
|
); |