[swantonio]

-- phpMyAdmin SQL Dump
-- version 2.6.3-pl1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generato il: 18 Apr, 2006 at 10:16 AM
-- Versione MySQL: 3.23.58
-- Versione PHP: 5.0.4
--
-- Database: `IPB`
--

-- --------------------------------------------------------

--
-- Struttura della tabella `vb3_hkc_competitions`
--

CREATE TABLE `vb3_hkc_competitions` (
`competitionid` smallint(5) unsigned NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`description` mediumtext NOT NULL,
`type` enum('input','select','radio','textarea','checkbox ','select_multiple') NOT NULL default 'input',
`data` mediumtext NOT NULL,
`maxlength` smallint(6) NOT NULL default '250',
`size` smallint(6) NOT NULL default '25',
`height` smallint(6) NOT NULL default '0',
`optional` smallint(5) unsigned NOT NULL default '0',
`def` smallint(6) NOT NULL default '0',
`regex` varchar(255) NOT NULL default '',
`enddate` int(10) unsigned NOT NULL default '0',
`datestamp` int(10) unsigned NOT NULL default '0',
`correctanswer` mediumtext NOT NULL,
`entrycount` mediumint(8) unsigned NOT NULL default '0',
`maxentries` smallint(5) unsigned NOT NULL default '1',
`maxwinners` smallint(5) unsigned NOT NULL default '1',
`winnercount` smallint(5) unsigned NOT NULL default '0',
`enableguidelines` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`competitionid`),
KEY `enddate` (`enddate`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dump dei dati per la tabella `vb3_hkc_competitions`
--


-- --------------------------------------------------------

--
-- Struttura della tabella `vb3_hkc_entries`
--

CREATE TABLE `vb3_hkc_entries` (
`entryid` int(10) unsigned NOT NULL auto_increment,
`competitionid` smallint(5) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`answer` mediumtext NOT NULL,
`entrydate` int(11) NOT NULL default '0',
PRIMARY KEY (`entryid`),
KEY `competitionid_userid` (`competitionid`,`userid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dump dei dati per la tabella `vb3_hkc_entries`
--


-- --------------------------------------------------------

--
-- Struttura della tabella `vb3_hkc_winners`
--

CREATE TABLE `vb3_hkc_winners` (
`competitionid` smallint(5) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`competitionid`,`userid`)
) TYPE=MyISAM;

--
-- Dump dei dati per la tabella `vb3_hkc_winners`
--