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 ;

USERS vedi modello generale

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