sql/create_node_access.sql

   1 CREATE TABLE node_access (
   2   node_id int(13) NOT NULL default '0',
   3   user_id int(13) NOT NULL default '0',
   4   node_bookmark enum('yes','no') default 'no',
   5   node_permission enum('master','op','access','silence','ban') default NULL,
   6   node_user_subchild_count int(13) default NULL,
   7   node_user_subchild_types set('forum','submission','user','journaux','special','news','poll') default '',
   8   last_visit datetime default NULL,
   9   visits int(6) default 0,
  10   bookmark_category int(11) default NULL
  11 ) TYPE=MyIsam