13 lines
407 B
SQL
13 lines
407 B
SQL
CREATE TABLE IF NOT EXISTS maplepress.tenants_by_id (
|
|
id UUID PRIMARY KEY,
|
|
name TEXT,
|
|
slug TEXT,
|
|
status TEXT,
|
|
created_at TIMESTAMP,
|
|
updated_at TIMESTAMP,
|
|
-- CWE-359: IP address tracking for GDPR compliance (90-day retention)
|
|
created_from_ip_address TEXT,
|
|
created_from_ip_timestamp TIMESTAMP,
|
|
modified_from_ip_address TEXT,
|
|
modified_from_ip_timestamp TIMESTAMP
|
|
);
|