Database Table: ratelog

From Dreamwidth Notes
Jump to: navigation, search

This is a clustered table.

Definition

CREATE TABLE ratelog (
    userid   INT UNSIGNED NOT NULL,
    rlid  TINYINT UNSIGNED NOT NULL,
    evttime  INT UNSIGNED NOT NULL,
    ip       INT UNSIGNED NOT NULL,
    INDEX (userid, rlid, evttime),
    quantity SMALLINT UNSIGNED NOT NULL
)

Relationships