Questa è una vecchia versione del documento!
SQL delle tabelle:
CREATE TABLE `meetings` ( `id` int(11) NOT NULL auto_increment, `title` text NOT NULL, `main_motion` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE `meeting_odg` ( `id` INT NOT NULL , `meeting_id` INT NOT NULL , `timestamp` TIMESTAMP NOT NULL , `description` TEXT NOT NULL ) 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
CREATE TABLE `meeting_messages` ( `id_messaggio` int(11) NOT NULL, `testo` text NOT NULL, `autore` int(11) NOT NULL, `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `meeting_rules` ( `description` text NOT NULL, `rank` int(11) NOT NULL, `interrupt` tinyint(1) NOT NULL, `secondable` tinyint(1) NOT NULL, `debateable` tinyint(1) NOT NULL, `vote` int(11) NOT NULL, `amendable` tinyint(1) NOT NULL, PRIMARY KEY (`rank`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `meeting_messages` ( `id_messaggio` int(11) NOT NULL, `testo` text NOT NULL, `autore` int(11) NOT NULL, `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP ) ENGINE=MyISAM DEFAULT CHARSET=latin1;