diff options
author | Rob Austein <sra@hactrn.net> | 2008-04-29 19:54:33 +0000 |
---|---|---|
committer | Rob Austein <sra@hactrn.net> | 2008-04-29 19:54:33 +0000 |
commit | 245dba96f918cd17873029a6209479b4ec03f75e (patch) | |
tree | 9b7ce1926160f8d68fc8febf5aab463fbd3aa3d7 /docs/sample-irdb.sql | |
parent | 62182b421f39a94f7a6222d6d8ac60b1270edcbc (diff) |
Clean up old silliness of having the .sql files in the docs/ directory.
svn path=/docs/Makefile; revision=1721
Diffstat (limited to 'docs/sample-irdb.sql')
-rw-r--r-- | docs/sample-irdb.sql | 54 |
1 files changed, 0 insertions, 54 deletions
diff --git a/docs/sample-irdb.sql b/docs/sample-irdb.sql deleted file mode 100644 index f5c8c970..00000000 --- a/docs/sample-irdb.sql +++ /dev/null @@ -1,54 +0,0 @@ --- $Id$ - --- Copyright (C) 2007-2008 American Registry for Internet Numbers ("ARIN") --- --- Permission to use, copy, modify, and distribute this software for any --- purpose with or without fee is hereby granted, provided that the above --- copyright notice and this permission notice appear in all copies. --- --- THE SOFTWARE IS PROVIDED "AS IS" AND ARIN DISCLAIMS ALL WARRANTIES WITH --- REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF MERCHANTABILITY --- AND FITNESS. IN NO EVENT SHALL ARIN BE LIABLE FOR ANY SPECIAL, DIRECT, --- INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING FROM --- LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE --- OR OTHER TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION WITH THE USE OR --- PERFORMANCE OF THIS SOFTWARE. - -DROP TABLE IF EXISTS registrant; - -CREATE TABLE registrant ( - registrant_id SERIAL NOT NULL, - IRBE_mapped_id TEXT, - subject_name TEXT, - rpki_self_id BIGINT unsigned, - rpki_child_id BIGINT unsigned, - valid_until DATETIME NOT NULL, - PRIMARY KEY (registrant_id) -); - -DROP TABLE IF EXISTS asn; - -CREATE TABLE asn ( - asn_id SERIAL NOT NULL, - start_as BIGINT unsigned NOT NULL, - end_as BIGINT unsigned NOT NULL, - registrant_id BIGINT unsigned NOT NULL, - PRIMARY KEY (asn_id), - FOREIGN KEY (registrant_id) REFERENCES registrant ON DELETE SET NULL ON UPDATE SET NULL -); - -DROP TABLE IF EXISTS net; - -CREATE TABLE net ( - net_id SERIAL NOT NULL, - start_ip VARCHAR(40) NOT NULL, - end_ip VARCHAR(40) NOT NULL, - version TINYINT unsigned NOT NULL, - registrant_id BIGINT unsigned NOT NULL, - PRIMARY KEY (net_id), - FOREIGN KEY (registrant_id) REFERENCES registrant ON DELETE SET NULL ON UPDATE SET NULL -); - --- Local Variables: --- indent-tabs-mode: nil --- End: |