pub(super) fn get_mysql_table_creation_queries() -> Vec<&'static str> {
vec![
r#"
CREATE TABLE IF NOT EXISTS zones (
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(255) UNIQUE NOT NULL,
primary_ns VARCHAR(255) NOT NULL,
admin_email VARCHAR(255) NOT NULL,
ttl INT NOT NULL,
serial INT NOT NULL,
refresh INT NOT NULL DEFAULT 86400,
retry INT NOT NULL DEFAULT 7200,
expire INT NOT NULL DEFAULT 3600000,
minimum_ttl INT NOT NULL DEFAULT 86400,
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
);
"#,
r#"
CREATE TABLE IF NOT EXISTS records (
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(255) NOT NULL,
record_type VARCHAR(50) NOT NULL,
value TEXT NOT NULL,
ttl INT,
priority INT,
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
zone_id INT NOT NULL,
FOREIGN KEY (zone_id) REFERENCES zones(id) ON DELETE CASCADE
);
"#,
r#"
CREATE TABLE IF NOT EXISTS zone_changes (
id INT PRIMARY KEY AUTO_INCREMENT,
zone_id INT NOT NULL,
serial INT NOT NULL,
operation VARCHAR(10) NOT NULL,
record_name VARCHAR(255) NOT NULL,
record_type VARCHAR(50) NOT NULL,
record_value TEXT NOT NULL,
record_ttl INT,
record_priority INT,
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (zone_id) REFERENCES zones(id) ON DELETE CASCADE,
INDEX idx_zone_serial (zone_id, serial)
);
"#,
r#"
CREATE TABLE IF NOT EXISTS zone_soa_history (
id INT PRIMARY KEY AUTO_INCREMENT,
zone_id INT NOT NULL,
serial INT NOT NULL,
primary_ns TEXT NOT NULL,
admin_email TEXT NOT NULL,
ttl INT NOT NULL,
refresh INT NOT NULL,
retry INT NOT NULL,
expire INT NOT NULL,
minimum_ttl INT NOT NULL,
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
UNIQUE KEY uq_zone_serial (zone_id, serial),
FOREIGN KEY (zone_id) REFERENCES zones(id) ON DELETE CASCADE
);
"#,
r#"
CREATE TABLE IF NOT EXISTS api_tokens (
id INT PRIMARY KEY AUTO_INCREMENT,
token VARCHAR(64) UNIQUE NOT NULL,
description VARCHAR(255),
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
expires_at DATETIME,
last_used_at DATETIME
);
"#,
r#"
CREATE TABLE IF NOT EXISTS catalog_zone_state (
name VARCHAR(255) PRIMARY KEY,
signature VARCHAR(64) NOT NULL,
serial INT NOT NULL,
updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);
"#,
]
}
pub(super) fn get_postgres_table_creation_queries() -> Vec<&'static str> {
vec![
r#"
CREATE TABLE IF NOT EXISTS zones (
id SERIAL PRIMARY KEY,
name VARCHAR(255) UNIQUE NOT NULL,
primary_ns VARCHAR(255) NOT NULL,
admin_email VARCHAR(255) NOT NULL,
ttl INTEGER NOT NULL,
serial INTEGER NOT NULL,
refresh INTEGER NOT NULL DEFAULT 86400,
retry INTEGER NOT NULL DEFAULT 7200,
expire INTEGER NOT NULL DEFAULT 3600000,
minimum_ttl INTEGER NOT NULL DEFAULT 86400,
created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
);
"#,
r#"
CREATE TABLE IF NOT EXISTS records (
id SERIAL PRIMARY KEY,
name VARCHAR(255) NOT NULL,
record_type VARCHAR(50) NOT NULL,
value TEXT NOT NULL,
ttl INTEGER,
priority INTEGER,
created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
zone_id INTEGER NOT NULL,
FOREIGN KEY (zone_id) REFERENCES zones(id) ON DELETE CASCADE
);
"#,
r#"
CREATE TABLE IF NOT EXISTS zone_changes (
id SERIAL PRIMARY KEY,
zone_id INTEGER NOT NULL,
serial INTEGER NOT NULL,
operation VARCHAR(10) NOT NULL,
record_name VARCHAR(255) NOT NULL,
record_type VARCHAR(50) NOT NULL,
record_value TEXT NOT NULL,
record_ttl INTEGER,
record_priority INTEGER,
created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (zone_id) REFERENCES zones(id) ON DELETE CASCADE
);
"#,
r#"
CREATE INDEX IF NOT EXISTS idx_zone_serial ON zone_changes(zone_id, serial);
"#,
r#"
CREATE TABLE IF NOT EXISTS zone_soa_history (
id SERIAL PRIMARY KEY,
zone_id INTEGER NOT NULL,
serial INTEGER NOT NULL,
primary_ns TEXT NOT NULL,
admin_email TEXT NOT NULL,
ttl INTEGER NOT NULL,
refresh INTEGER NOT NULL,
retry INTEGER NOT NULL,
expire INTEGER NOT NULL,
minimum_ttl INTEGER NOT NULL,
created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
UNIQUE(zone_id, serial),
FOREIGN KEY (zone_id) REFERENCES zones(id) ON DELETE CASCADE
);
"#,
r#"
CREATE TABLE IF NOT EXISTS api_tokens (
id SERIAL PRIMARY KEY,
token VARCHAR(64) UNIQUE NOT NULL,
description VARCHAR(255),
created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
expires_at TIMESTAMP,
last_used_at TIMESTAMP
);
"#,
r#"
CREATE TABLE IF NOT EXISTS catalog_zone_state (
name VARCHAR(255) PRIMARY KEY,
signature VARCHAR(64) NOT NULL,
serial INTEGER NOT NULL,
updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
);
"#,
]
}
pub(super) fn get_sqlite_table_creation_queries() -> Vec<&'static str> {
vec![
r#"
CREATE TABLE IF NOT EXISTS zones (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT UNIQUE NOT NULL,
primary_ns TEXT NOT NULL,
admin_email TEXT NOT NULL,
ttl INTEGER NOT NULL,
serial INTEGER NOT NULL,
refresh INTEGER NOT NULL DEFAULT 86400,
retry INTEGER NOT NULL DEFAULT 7200,
expire INTEGER NOT NULL DEFAULT 3600000,
minimum_ttl INTEGER NOT NULL DEFAULT 86400,
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
);
"#,
r#"
CREATE TABLE IF NOT EXISTS records (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
record_type TEXT NOT NULL,
value TEXT NOT NULL,
ttl INTEGER,
priority INTEGER,
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
zone_id INTEGER NOT NULL,
FOREIGN KEY (zone_id) REFERENCES zones(id) ON DELETE CASCADE
);
"#,
r#"
CREATE TABLE IF NOT EXISTS zone_changes (
id INTEGER PRIMARY KEY AUTOINCREMENT,
zone_id INTEGER NOT NULL,
serial INTEGER NOT NULL,
operation TEXT NOT NULL,
record_name TEXT NOT NULL,
record_type TEXT NOT NULL,
record_value TEXT NOT NULL,
record_ttl INTEGER,
record_priority INTEGER,
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (zone_id) REFERENCES zones(id) ON DELETE CASCADE
);
"#,
r#"
CREATE INDEX IF NOT EXISTS idx_zone_serial ON zone_changes(zone_id, serial);
"#,
r#"
CREATE TABLE IF NOT EXISTS zone_soa_history (
id INTEGER PRIMARY KEY AUTOINCREMENT,
zone_id INTEGER NOT NULL,
serial INTEGER NOT NULL,
primary_ns TEXT NOT NULL,
admin_email TEXT NOT NULL,
ttl INTEGER NOT NULL,
refresh INTEGER NOT NULL,
retry INTEGER NOT NULL,
expire INTEGER NOT NULL,
minimum_ttl INTEGER NOT NULL,
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
UNIQUE(zone_id, serial),
FOREIGN KEY (zone_id) REFERENCES zones(id) ON DELETE CASCADE
);
"#,
r#"
CREATE TABLE IF NOT EXISTS api_tokens (
id INTEGER PRIMARY KEY AUTOINCREMENT,
token TEXT UNIQUE NOT NULL,
description TEXT,
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
expires_at DATETIME,
last_used_at DATETIME
);
"#,
r#"
CREATE TABLE IF NOT EXISTS catalog_zone_state (
name TEXT PRIMARY KEY,
signature TEXT NOT NULL,
serial INTEGER NOT NULL,
updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
);
"#,
]
}