ysql]CREATE TABLE sed_modcp_reasons (

  reason_id int(11) unsigned NOT NULL auto_increment,

  reason_title varchar(255) default NULL,

  reason_order smallint(5) unsigned NOT NULL default '0',

  PRIMARY KEY  (reason_id)

) ENGINE=MyISAM;



INSERT INTO sed_modcp_reasons VALUES (1, 'Spammed Advertisements', 1);

INSERT INTO sed_modcp_reasons VALUES (2, 'Insulted Other Member(s)', 2);

INSERT INTO sed_modcp_reasons VALUES (3, 'Inappropriate Language', 3);

INSERT INTO sed_modcp_reasons VALUES (4, 'Illegal materials, warez talk', 4);

INSERT INTO sed_modcp_reasons VALUES (5, 'Broken Link', 5);

INSERT INTO sed_modcp_reasons VALUES (6, 'Other, please add a description', 6);





CREATE TABLE sed_modcp_reports (

  report_id int(11) unsigned NOT NULL auto_increment,

  report_closed tinyint(1) default '0',

  report_date int(11) unsigned NOT NULL default '0',

  report_text text,

  reported_id int(11) unsigned NOT NULL default '0',

  reported_type enum('post','page','comment','user') NOT NULL default 'post',

  reported_data mediumblob NOT NULL,

  reason_id int(11) unsigned NOT NULL default '0',

  reporter_id int(11) unsigned NOT NULL default '0',

  PRIMARY KEY  (report_id)

) ENGINE=MyISAM;





CREATE TABLE sed_modcp_warnings (

  warning_id int(11) unsigned NOT NULL auto_increment,

  warning_archived tinyint(1) NOT NULL default '0',

  reason_id int(11) unsigned NOT NULL default '0',

  custom_reason varchar(255) NOT NULL default '',

  warned_userid int(11) unsigned NOT NULL default '0',

  mod_userid int(11) unsigned NOT NULL default '0',

  warning_log text NOT NULL,

  reported_id int(11) unsigned NOT NULL default '0',

  reported_type enum('post','page','comment','user') NOT NULL default 'post',

  issue_date int(11) unsigned NOT NULL default '0',

  PRIMARY KEY  (warning_id)

) ENGINE=MyISAM;



ALTER TABLE sed_users ADD COLUMN user_warningcount int(11) unsigned NOT NULL default '0';

ALTER TABLE sed_users ADD COLUMN user_warningarchive int(11) unsigned NOT NULL default '0';