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;

indietro - avanti