CREATE TABLE `Rubrique` (
  `RubriqueID` smallint(6) NOT NULL auto_increment,
  `RubriqueName` varchar(80) NOT NULL,
  `RubriqueDesc` tinytext,
  `Date` date default NULL,
  `Time` time default NULL,
  PRIMARY KEY  (`RubriqueID`)
);

CREATE TABLE `Image` (
  `ImageID` smallint(6) NOT NULL auto_increment,
  `RubriqueID` smallint(6) NOT NULL,
  `ImageName` varchar(80) NOT NULL,
  `ImageDesc` tinytext,
  `ImageRes` varchar(20) default NULL,
  `ImageSize` smallint(6) default NULL,
  `Date` date default NULL,
  `Time` time default NULL,
  PRIMARY KEY  (`ImageID`)
);