CREATE TABLE IF NOT EXISTS facebook_cache ( fb_type VARCHAR(64) NOT NULL, -- Facebook data type (uid, nid, etc.) cached fb_key VARCHAR(64) NOT NULL, -- Facebook data key value_str VARCHAR(512), -- cached string value value_num BIGINT, -- cached numerical value stamp DATETIME NOT NULL, -- cache entry creation time stamp PRIMARY KEY pk_facebook_cache (fb_type, fb_key), INDEX ik_facebook_cache_1 (stamp) ) ENGINE=MyISAM;