Add new columns and tables for IP address billing support:

- machine table gets an account_number column.

- subnet table gets a status column.

- add an accountnumbers table containing all valid account numbers that
  can be billed.

diff --git a/db/schema.sql b/db/schema.sql
index 5a5ed49a640e2315d70d697bb73e81aa12a71658..e6d31299293f1b69538bb3b9a00ccff3241f6c75 100644 (file)
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -64,6 +64,7 @@ create table machine
        location        VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
        contact         VARCHAR(32)     DEFAULT CHR(0)  NOT NULL,
        billing_contact VARCHAR(32)     DEFAULT CHR(0)  NOT NULL,
+       account_number  VARCHAR(10)     DEFAULT CHR(0)  NOT NULL,       
        use             INTEGER         DEFAULT 0       NOT NULL,
        status          INTEGER         DEFAULT 0       NOT NULL,
        statuschange    DATE            DEFAULT SYSDATE NOT NULL,
@@ -92,6 +93,7 @@ create table subnet
 (
        name            VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
        snet_id         INTEGER         DEFAULT 0       NOT NULL,
+       status          INTEGER         DEFAULT 0       NOT NULL,
        description     VARCHAR(48)     DEFAULT CHR(0)  NOT NULL,
        saddr           INTEGER         DEFAULT 0       NOT NULL,
        mask            INTEGER         DEFAULT 0       NOT NULL,
@@ -417,3 +419,8 @@ create table mcntmap
        mach_id         INTEGER         DEFAULT 0       NOT NULL,
        cnt_id          INTEGER         DEFAULT 0       NOT NULL
 );
+
+create table accountnumbers
+(
+       account_number  VARCHAR(10)     DEFAULT CHR(0)  NOT NULL
+);

diff --git a/db/unschema.sql b/db/unschema.sql
index 5d90174a6a323be1a6b1893d3f29a9cefb7f21e3..3a7bab58a417bc1b46a75d5cde8bae1fbc133b41 100644 (file)
--- a/db/unschema.sql
+++ b/db/unschema.sql
@@ -30,3 +30,4 @@ drop table usersids;
 drop table listsids;
 drop table containers;
 drop table mcntmap;
+drop table accountnumbers;