21 lines
764 B
SQL
21 lines
764 B
SQL
-- IPVarch used-networks schema (IPAM registry).
|
|
--
|
|
-- This file is the single source of truth for the UsedNetworks table.
|
|
-- It is compiled into the ipvarch binary at build time by the Makefile
|
|
-- (it becomes the generated schema_sql.c), which keeps the shipped
|
|
-- binary self-contained. To change the schema: edit this file and
|
|
-- rebuild.
|
|
--
|
|
-- The table is created with "IF NOT EXISTS", so opening an already
|
|
-- initialised database is a no-op.
|
|
|
|
CREATE TABLE IF NOT EXISTS UsedNetworks (
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
cidr TEXT NOT NULL UNIQUE,
|
|
prefix INTEGER NOT NULL,
|
|
start_hi INTEGER NOT NULL,
|
|
start_lo INTEGER NOT NULL,
|
|
end_hi INTEGER NOT NULL,
|
|
end_lo INTEGER NOT NULL,
|
|
label TEXT NOT NULL,
|
|
created_at DATETIME DEFAULT CURRENT_TIMESTAMP)
|