9 lines
272 B
SQL
9 lines
272 B
SQL
CREATE TABLE IF NOT EXISTS maplepress.sites_by_tenant (
|
|
tenant_id UUID,
|
|
created_at TIMESTAMP,
|
|
id UUID,
|
|
domain TEXT,
|
|
status TEXT,
|
|
is_verified BOOLEAN,
|
|
PRIMARY KEY (tenant_id, created_at, id)
|
|
) WITH CLUSTERING ORDER BY (created_at DESC, id ASC);
|