Changeset 915 for trunk/cgi-bin/ipdb.psql

Timestamp:

04/27/18 15:28:45 (6 years ago)

Author:

Kris Deugau

Message:

/trunk

Start adding a generalized in-your-face infonotice space to attach warnings
to a netblock. See #17 and #23, sort of.

• table to hold the notices, since they're likely to be far fewer than the overall allocation count
• show any notices for the parent chain for new allocations in the admin tools

File:

• trunk/cgi-bin/ipdb.psql (modified) (1 diff)

trunk/cgi-bin/ipdb.psql

@@ -116 +116 @@
 ALTER TABLE ONLY freeblocks
     ADD CONSTRAINT freeblocks_pkey PRIMARY KEY (cidr, parent_id);
+
+-- Table for arbitrary infonotices tagged to an allocation
+CREATE TABLE blocknotices (
+    alloc_id integer NOT NULL,
+    ipflag boolean DEFAULT false NOT NULL,
+    notice text DEFAULT ''::text NOT NULL
+);
+
+ALTER TABLE ONLY blocknotices
+    ADD CONSTRAINT blocknotices_pkey PRIMARY KEY (alloc_id, ipflag);
 
 -- Network nodes - allows finding customers affected by a broken <x> quickly