Questa è una vecchia versione del documento!
SQL delle tabelle:
CREATE TABLE `polls` ( `id` int(10) unsigned NOT NULL auto_increment, `title` varchar(255) collate latin1_general_ci NOT NULL, `description` text collate latin1_general_ci NOT NULL, `status` tinyint(3) unsigned NOT NULL, `start` datetime NOT NULL, `end` datetime NOT NULL, `created` datetime NOT NULL, `modified` datetime NOT NULL, `registrar` text collate latin1_general_ci NOT NULL, `forwarder` text collate latin1_general_ci NOT NULL, `collector` text collate latin1_general_ci NOT NULL, `agentname` varchar(255) collate latin1_general_ci NOT NULL, `agenturl` varchar(255) collate latin1_general_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM;
CREATE TABLE `questions` ( `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, `title` TINYTEXT NOT NULL, `description` TINYTEXT NOT NULL, `type` VARCHAR(45) NOT NULL, `data` TEXT NOT NULL, `weight` TINYINT UNSIGNED NOT NULL, `poll_id` INTEGER UNSIGNED NOT NULL, PRIMARY KEY (`id`) ) ENGINE = MyISAM;
CREATE TABLE `question_items` ( `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, `title` TINYTEXT NOT NULL, `help_text` TINYTEXT NOT NULL, `weight` TINYINT UNSIGNED NOT NULL, `question_id` INTEGER UNSIGNED NOT NULL, PRIMARY KEY (`id`) ) ENGINE = MyISAM;
CREATE TABLE `users` ( `id` int(11) NOT NULL auto_increment, `username` varchar(255) NOT NULL default '', `password` varchar(36) NOT NULL default '', `first_name` varchar(255) default '', `last_name` varchar(255) default '', `email` varchar(255) NOT NULL default '', `showemail` tinyint(1) NOT NULL default '0', `admin` tinyint(1) NOT NULL default '0', `active` tinyint(1) NOT NULL default '0', `created` datetime default NULL, `modified` datetime default NULL, PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`), UNIQUE KEY `email` (`email`) ) ENGINE=MyISAM