User:WhiteWizard/SQL FB Authentication
From Tapestries MUCK
(Difference between revisions)
WhiteWizard (Talk | contribs) (→Character Table) |
WhiteWizard (Talk | contribs) (→Character Table) |
||
Line 16: | Line 16: | ||
toaded BOOLEAN | toaded BOOLEAN | ||
); | ); | ||
+ | CREATE INDEX muck_characters_player_id ON muck_characters (player_id); | ||
+ | CREATE INDEX muck_characters_name ON muck_characters (name); | ||
CREATE TABLE character_log ( | CREATE TABLE character_log ( | ||
Line 25: | Line 27: | ||
info text | info text | ||
); | ); | ||
+ | CREATE INDEX character_log_player_id ON character_log (player_id); | ||
+ | CREATE INDEX character_log_character_id ON character_log (character_id); | ||
+ | CREATE INDEX character_log_ipaddr ON character_log (ipaddr); |
Revision as of 07:36, 7 March 2008
Character Table
CREATE TABLE muck_characters ( id SERIAL PRIMARY KEY, 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 INDEX muck_characters_player_id ON muck_characters (player_id); CREATE INDEX muck_characters_name ON muck_characters (name);
CREATE TABLE character_log ( time BIGINT PRIMARY KEY, player_id INTEGER, character_id INTEGER, ipaddr inet, type text, -- LOGIN, LOGOUT, MCREATED, CREATED, TOADED, MREJECT, etc. etc. info text ); CREATE INDEX character_log_player_id ON character_log (player_id); CREATE INDEX character_log_character_id ON character_log (character_id); CREATE INDEX character_log_ipaddr ON character_log (ipaddr);