Pastoid

CREATE TABLE {rateit_log} (
  id INT NOT NULL AUTOINCREMENT PRIMARY KEY,
  post_id INT NOT NULL,
  rating TINYINT NOT NULL,
  timestamp DATETIME NOT NULL,
  ip INT( 10 ) NOT NULL,
);
 
CREATE UNIQUE INDEX IF NOT EXISTS post_id_ip ON {rateit_log}( post_id, ip );

CREATE TABLE {rateit_log} (
  id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  post_id INT NOT NULL,
  rating TINYINT NOT NULL,
  timestamp DATETIME NOT NULL,
  ip INT( 10 ) NOT NULL,
  INDEX ( post_id , ip )
);
 
 

       private function install_db()
        {
                DB::register_table( 'rateit_log' );
 
                return DB::dbdelta( $this->get_db_schema() );
        }