CREATE TABLE cp_v4p_sites (
  site_id int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  address text NOT NULL,
  points int(10) UNSIGNED NOT NULL DEFAULT 0,
  blocking_time int(10) UNSIGNED NOT NULL DEFAULT 0,
  banner blob DEFAULT NULL,
  banner_url text DEFAULT NULL,
  site_name varchar(50) NOT NULL,
  banner_file_type varchar(30) NOT NULL,
  PRIMARY KEY (site_id)
);

CREATE TABLE cp_v4p_valid (
  rtid int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  f_site_id int(10) UNSIGNED NOT NULL,
  account_id int(10) UNSIGNED NOT NULL,
  ip_address varchar(100) DEFAULT '0',
  PRIMARY KEY (rtid)
);

CREATE TABLE cp_v4p_votelogs (
  rtid int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  f_site_id int(10) UNSIGNED NOT NULL,
  unblock_time datetime NOT NULL,
  account_id int(10) UNSIGNED NOT NULL,
  valid tinyint(1) DEFAULT 0,
  ip_address varchar(100) NOT NULL DEFAULT '0',
  PRIMARY KEY (rtid)
);

CREATE TABLE cp_v4p_voters (
  account_id int(10) UNSIGNED NOT NULL,
  points int(10) UNSIGNED NOT NULL,
  PRIMARY KEY (account_id)
);