1#2009-04-16 lphuberdeau 2CREATE TABLE IF NOT EXISTS tiki_plugin_security ( 3 fingerprint VARCHAR(200) NOT NULL PRIMARY KEY, 4 status VARCHAR(10) NOT NULL, 5 approval_by VARCHAR(200) NULL, 6 last_update TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, 7 last_objectType VARCHAR(20) NOT NULL, 8 last_objectId VARCHAR(200) NOT NULL, 9 KEY last_object (last_objectType, last_objectId) 10) ENGINE=MyISAM; 11 12