18 lines
802 B
SQL
18 lines
802 B
SQL
-- Create domain_root table for IANA TLD data
|
|
CREATE TABLE IF NOT EXISTS domain_root (
|
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
root VARCHAR(63) NOT NULL UNIQUE,
|
|
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
|
|
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
|
INDEX idx_root (root)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
|
|
-- Create domain_suffix table for Public Suffix List data
|
|
CREATE TABLE IF NOT EXISTS domain_suffix (
|
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
suffix VARCHAR(255) NOT NULL UNIQUE,
|
|
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
|
|
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
|
INDEX idx_suffix (suffix)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|