9 lines
331 B
SQL
9 lines
331 B
SQL
-- Create superadmins table that links to the users table
|
|
CREATE TABLE superadmins (
|
|
user_id UUID PRIMARY KEY REFERENCES users(id) ON DELETE CASCADE,
|
|
created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
|
|
description TEXT
|
|
);
|
|
|
|
-- Create index for faster lookups
|
|
CREATE INDEX idx_superadmins_user_id ON superadmins(user_id);
|