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;
USERS vedi modello generale
indietro - avanti