source: trunk/cgi-bin/ipdb-3.0-3.1.sql@ 935

Last change on this file since 935 was 915, checked in by Kris Deugau, 7 years ago

/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 size: 203 bytes
RevLine 
[915]1-- Add new table for allocation notices
2CREATE TABLE blocknotices (
3 alloc_id integer NOT NULL,
4 ipflag boolean NOT NULL DEFAULT 'n',
5 notice text NOT NULL DEFAULT '',
6 PRIMARY KEY (alloc_id, ipflag)
7);
Note: See TracBrowser for help on using the repository browser.