Parašė Karolis· 2009 Rugp. 21 21:08:27
#3
Užklausa.
create table fusion_ip_polls (
poll_id smallint(5) unsigned NOT NULL auto_increment,
poll_title varchar(200) NOT NULL default '',
poll_opt_0 varchar(200) NOT NULL default '',
poll_opt_1 varchar(200) NOT NULL default '',
poll_opt_2 varchar(200) NOT NULL default '',
poll_opt_3 varchar(200) NOT NULL default '',
poll_opt_4 varchar(200) NOT NULL default '',
poll_opt_5 varchar(200) NOT NULL default '',
poll_opt_6 varchar(200) NOT NULL default '',
poll_opt_7 varchar(200) NOT NULL default '',
poll_opt_8 varchar(200) NOT NULL default '',
poll_opt_9 varchar(200) NOT NULL default '',
poll_votes_0 smallint(5) unsigned NOT NULL NULL default '0',
poll_votes_1 smallint(5) unsigned NOT NULL NULL default '0',
poll_votes_2 smallint(5) unsigned NOT NULL NULL default '0',
poll_votes_3 smallint(5) unsigned NOT NULL NULL default '0',
poll_votes_4 smallint(5) unsigned NOT NULL NULL default '0',
poll_votes_5 smallint(5) unsigned NOT NULL NULL default '0',
poll_votes_6 smallint(5) unsigned NOT NULL NULL default '0',
poll_votes_7 smallint(5) unsigned NOT NULL NULL default '0',
poll_votes_8 smallint(5) unsigned NOT NULL NULL default '0',
poll_votes_9 smallint(5) unsigned NOT NULL NULL default '0',
poll_ips text NOT NULL default '',
poll_started int(10) unsigned NOT NULL default '0',
poll_ended int(10) unsigned NOT NULL default '0',
PRIMARY KEY (poll_id)
) TYPE=MyISAM;