Return to db.sql CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / bmon / xtra

Annotation of embedaddon/bmon/xtra/db.sql, revision 1.1

1.1     ! misho       1: CREATE TABLE IF NOT EXISTS nodes (
        !             2:        id INT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE,
        !             3:        name TEXT NOT NULL,
        !             4:        source TEXT,
        !             5:        PRIMARY KEY (id)
        !             6: );
        !             7: 
        !             8: CREATE TABLE IF NOT EXISTS items (
        !             9:        id INT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE,
        !            10:        name TEXT NOT NULL,
        !            11:        description TEXT,
        !            12:        node INT UNSIGNED NOT NULL,
        !            13:        handle INT UNSIGNED,
        !            14:        parent INT UNSIGNED,
        !            15:        indent INT UNSIGNED,
        !            16:        rx_usage SMALLINT NOT NULL,
        !            17:        tx_usage SMALLINT NOT NULL,
        !            18:        PRIMARY KEY (id),
        !            19:        FOREIGN KEY (node) REFERENCES nodes(id),
        !            20:        FOREIGN KEY (parent) REFERENCES items(id)
        !            21: );
        !            22: 
        !            23: CREATE TABLE IF NOT EXISTS attrs (
        !            24:        id INT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE,
        !            25:        name CHAR(15) NOT NULL,
        !            26:        item INT UNSIGNED NOT NULL,
        !            27:        rx_rate INT UNSIGNED,
        !            28:        tx_rate INT UNSIGNED,
        !            29:        rx_counter BIGINT UNSIGNED NOT NULL,
        !            30:        tx_counter BIGINT UNSIGNED NOT NULL,
        !            31:        PRIMARY KEY (id),
        !            32:        FOREIGN KEY (item) REFERENCES items(id)
        !            33: );
        !            34: 
        !            35: CREATE TABLE IF NOT EXISTS attr_desc (
        !            36:        id CHAR(15) NOT NULL UNIQUE,
        !            37:        is_num SMALLINT UNSIGNED NOT NULL,
        !            38:        txt TEXT NOT NULL,
        !            39:        PRIMARY KEY(id)
        !            40: );
        !            41: 
        !            42: CREATE TABLE IF NOT EXISTS hist_r (
        !            43:        attr INT UNSIGNED NOT NULL,
        !            44:        ts INT UNSIGNED NOT NULL,
        !            45:        offset INT UNSIGNED NOT NULL,
        !            46:        rx_rate INT UNSIGNED NOT NULL,
        !            47:        tx_rate INT UNSIGNED NOT NULL,
        !            48:        PRIMARY KEY (attr, ts, offset),
        !            49:        FOREIGN KEY (attr) REFERENCES attrs(id)
        !            50: );
        !            51: 
        !            52: CREATE TABLE IF NOT EXISTS hist_s (
        !            53:        attr INT UNSIGNED NOT NULL,
        !            54:        ts INT UNSIGNED NOT NULL,
        !            55:        offset INT UNSIGNED NOT NULL,
        !            56:        rx_rate INT UNSIGNED NOT NULL,
        !            57:        tx_rate INT UNSIGNED NOT NULL,
        !            58:        PRIMARY KEY (attr, ts, offset),
        !            59:        FOREIGN KEY (attr) REFERENCES attrs(id)
        !            60: );
        !            61: 
        !            62: CREATE TABLE IF NOT EXISTS hist_m (
        !            63:        attr INT UNSIGNED NOT NULL,
        !            64:        ts INT UNSIGNED NOT NULL,
        !            65:        offset INT UNSIGNED NOT NULL,
        !            66:        rx_rate INT UNSIGNED NOT NULL,
        !            67:        tx_rate INT UNSIGNED NOT NULL,
        !            68:        PRIMARY KEY (attr, ts, offset),
        !            69:        FOREIGN KEY (attr) REFERENCES attrs(id)
        !            70: );
        !            71: 
        !            72: CREATE TABLE IF NOT EXISTS hist_h (
        !            73:        attr INT UNSIGNED NOT NULL,
        !            74:        ts INT UNSIGNED NOT NULL,
        !            75:        offset INT UNSIGNED NOT NULL,
        !            76:        rx_rate INT UNSIGNED NOT NULL,
        !            77:        tx_rate INT UNSIGNED NOT NULL,
        !            78:        PRIMARY KEY (attr, ts, offset),
        !            79:        FOREIGN KEY (attr) REFERENCES attrs(id)
        !            80: );
        !            81: 
        !            82: CREATE TABLE IF NOT EXISTS hist_d (
        !            83:        attr INT UNSIGNED NOT NULL,
        !            84:        ts INT UNSIGNED NOT NULL,
        !            85:        offset INT UNSIGNED NOT NULL,
        !            86:        rx_rate INT UNSIGNED NOT NULL,
        !            87:        tx_rate INT UNSIGNED NOT NULL,
        !            88:        PRIMARY KEY (attr, ts, offset),
        !            89:        FOREIGN KEY (attr) REFERENCES attrs(id)
        !            90: );