Location: PHPKode > projects > Content*Builder > contentbuilder/plugins/poll/pollTable.php
<?php
include("../../system/inc/db.php");

$insert = mysql_query("CREATE TABLE ".TABLE."_pollsanswer (
  id bigint(20) unsigned NOT NULL auto_increment,
  poll bigint(20) unsigned NOT NULL default '0',
  answer varchar(255) NOT NULL default '',
  type enum('default','writein') NOT NULL default 'default',
  count bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY poll (poll),
  KEY type (type)
) TYPE=MyISAM;");

$insert = mysql_query("CREATE TABLE ".TABLE."_pollsquery (
  id bigint(20) unsigned NOT NULL auto_increment,
  query text NOT NULL,
  description text NOT NULL,
  valid_from datetime NOT NULL default '0000-00-00 00:00:00',
  valid_until datetime NOT NULL default '0000-00-00 00:00:00',
  type enum('checkbox','option') NOT NULL default 'checkbox',
  param varchar(20) NOT NULL default '',
  options set('order_query','order_result','allow_write_ins') NOT NULL default '',
  displayed bigint(20) unsigned NOT NULL default '0',
  users bigint(20) unsigned NOT NULL default '0',
  active enum('yes','no') NOT NULL default 'yes',
  PRIMARY KEY  (id),
  KEY valid_from (valid_from),
  KEY valid_until (valid_until),
  KEY active (active)
) TYPE=MyISAM;");
?>
Return current item: Content*Builder