Queste sono le differenze tra la revisione selezionata e la versione attuale della pagina.
Both sides previous revision Previous revision | Next revision Both sides next revision | ||
il_meeting_online [05/08/2010 11:39] |
il_meeting_online [05/08/2010 12:42] |
||
---|---|---|---|
Linea 8: | Linea 8: | ||
\\ | \\ | ||
\\ | \\ | ||
- | CREATE TABLE `meetings` ( | + | CREATE TABLE IF NOT EXISTS `meetings` ( |
- | `id` int(11) NOT NULL auto_increment, | + | `id` int(11) NOT NULL auto_increment, |
- | `title` text NOT NULL, | + | `title` text NOT NULL, |
- | `main_motion` int(11) NOT NULL, | + | `main_motion` int(11) NOT NULL, |
+ | `floor_timer` int(11) NOT NULL, | ||
+ | `id_oob` int(11) NOT NULL, | ||
+ | `suspend` int(11) NOT NULL, | ||
+ | `quorum` int(11) NOT NULL, | ||
PRIMARY KEY (`id`) | PRIMARY KEY (`id`) | ||
- | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; | + | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
\\ | \\ | ||
- | CREATE TABLE `meeting_odg` ( | + | CREATE TABLE IF NOT EXISTS `meeting_odg` ( |
- | `id` INT NOT NULL , | + | `id` int(11) NOT NULL auto_increment, |
- | `meeting_id` INT NOT NULL , | + | `meeting_id` int(11) NOT NULL, |
- | `timestamp` TIMESTAMP NOT NULL , | + | `timestamp` datetime NOT NULL, |
- | `description` TEXT NOT NULL | + | `description` text NOT NULL, |
- | ) ENGINE = MYISAM ; | + | PRIMARY KEY (`id`) |
+ | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | ||
\\ | \\ | ||
USERS vedi [[il modello generale | modello generale]] | USERS vedi [[il modello generale | modello generale]] | ||
\\ | \\ | ||
- | CREATE TABLE `meeting_messages` ( | + | CREATE TABLE IF NOT EXISTS `meeting_messages` ( |
- | `id_messaggio` int(11) NOT NULL, | + | `id` int(10) unsigned NOT NULL auto_increment, |
- | `testo` text NOT NULL, | + | `text` text NOT NULL, |
- | `autore` int(11) NOT NULL, | + | `user_id` int(10) unsigned NOT NULL, |
- | `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP | + | `motion_id` int(10) unsigned NOT NULL, |
- | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | + | `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | ||
\\ | \\ | ||
- | CREATE TABLE `meeting_rules` ( | + | CREATE TABLE IF NOT EXISTS `meeting_rules` ( |
- | `description` text NOT NULL, | + | `description` text NOT NULL, |
- | `rank` int(11) NOT NULL, | + | `id` int(11) NOT NULL, |
- | `interrupt` tinyint(1) NOT NULL, | + | `interrupt` tinyint(1) NOT NULL, |
- | `secondable` tinyint(1) NOT NULL, | + | `secondable` tinyint(1) NOT NULL, |
- | `debateable` tinyint(1) NOT NULL, | + | `debateable` tinyint(1) NOT NULL, |
- | `vote` int(11) NOT NULL, | + | `vote` int(11) NOT NULL, |
- | `amendable` tinyint(1) NOT NULL, | + | `amendable` tinyint(1) NOT NULL, |
- | PRIMARY KEY (`rank`) | + | PRIMARY KEY (`id`) |
- | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | + | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
\\ | \\ | ||
- | CREATE TABLE `meeting_messages` ( | + | CREATE TABLE IF NOT EXISTS `meeting_motions` ( |
- | `id_messaggio` int(11) NOT NULL, | + | `id` int(11) NOT NULL auto_increment, |
- | `testo` text NOT NULL, | + | `testo` text NOT NULL, |
- | `autore` int(11) NOT NULL, | + | `user_id` int(11) NOT NULL, |
- | `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP | + | `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP, |
- | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | + | `meeting_id` int(11) NOT NULL, |
+ | `rule_id` int(11) NOT NULL, | ||
+ | `main_motion` int(11) NOT NULL, | ||
+ | `seconded` int(11) NOT NULL, | ||
+ | `debated` int(11) NOT NULL, | ||
+ | `vote` int(11) NOT NULL, | ||
+ | `closed` tinyint(1) NOT NULL, | ||
+ | `oob_id` int(11) NOT NULL, | ||
+ | PRIMARY KEY (`id`) | ||
+ | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | ||
\\ | \\ | ||
\\ | \\ |