User:WhiteWizard/SQL FB Authentication

From Tapestries MUCK

Revision as of 07:18, 7 March 2008 (view source) WhiteWizard (Talk | contribs) ← Older edit		Revision as of 07:18, 7 March 2008 (view source) WhiteWizard (Talk | contribs) (→Character Table) Newer edit →
Line 6:		Line 6:
	id              SERIAL UNIQUE NOT NULL,		id              SERIAL UNIQUE NOT NULL,
	player_id      INTEGER,		player_id      INTEGER,
-		+
	-- Stuff that must match up with the Muck		-- Stuff that must match up with the Muck
	name            VARCHAR(30) NOT NULL,		name            VARCHAR(30) NOT NULL,
	dbref          INTEGER,		dbref          INTEGER,
	created        BIGINT,		created        BIGINT,
-		+
	-- Administrative information		-- Administrative information
	suspended      BIGINT,  -- NULL = active, 0 = Suspended indefinably, > 0 = time_t when available again.		suspended      BIGINT,  -- NULL = active, 0 = Suspended indefinably, > 0 = time_t when available again.

---

Revision as of 07:18, 7 March 2008

Character Table

CREATE TABLE muck_characters (
    id              SERIAL UNIQUE NOT NULL,
    player_id       INTEGER,

    -- Stuff that must match up with the Muck
    name            VARCHAR(30) NOT NULL,
    dbref           INTEGER,
    created         BIGINT,

    -- Administrative information
    suspended       BIGINT,  -- NULL = active, 0 = Suspended indefinably, > 0 = time_t when available again.
    toaded          BOOLEAN
);

CREATE TABLE character_log (
    time            BIGINT,
    player_id       INTEGER,
    character_id    INTEGER,
    ipaddr          inet,
    type            text,  -- LOGIN, LOGOUT, MCREATED, CREATED, TOADED, MREJECT, etc. etc.
    info            text
);