maintenance/boardvote.sql

   1 -- Board of Trustees vote
   2
   3 CREATE TABLE log (
   4         log_id int(5) not null auto_increment,
   5         log_user int(5) not null default 0,
   6         log_user_text varchar(255) binary not null default '',
   7         log_user_key varchar(255) binary not null default '',
   8         log_wiki char(32) not null default '',
   9         log_edits int(5) not null default 0,
  10         log_days int(5) not null default 0,
  11         log_record blob not null default '',
  12         log_ip char(16) not null default '',
  13         log_xff varchar(255) not null default '',
  14         log_ua varchar(255) not null default '',
  15         log_timestamp char(14) not null default '',
  16         log_current tinyint(1) not null default 0,
  17         unique index log_id (log_id),
  18         index log_user_key (log_user_key)
  19 );
  20
  21