Changeset 2842

Show
Ignore:
Timestamp:
01/08/12 07:13:35 (4 months ago)
Author:
paparazzia
Message:

see #650

Files:
1 modified

Legend:

Unmodified
Added
Removed

  • trunk/base/scripts/upgrade-v0.19.sql

    r2841 r2842  
    11#Creation de la table racespreview 
     2DROP TABLE IF EXISTS `racepreview`; 
    23CREATE TABLE `racespreview` ( 
    34  `idracespreview` int(11) NOT NULL auto_increment, 
     5  `idraces` int(11) NOT NULL, 
    46  `racename` varchar(255) NOT NULL default '', 
    57  `deptime` bigint(14) default NULL, 
    6   `boattype` varchar(255) default NULL, 
    78  `racetype` int(11) default NULL, 
    89  `comments` varchar(255) default NULL, 
    910  `admincomments` varchar(255) default NULL, 
    1011  `updated` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, 
    11   PRIMARY KEY  (`idracespreview`), 
    12   KEY `filter` (`deptime`,`closetime`) 
     12  PRIMARY KEY  (`idracespreview`) 
    1313) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='The races that could exist in the future'; 
    1414