View file fk/fk/SQL.txt

CREATE TABLE IF NOT EXISTS `fk` (
  `id` int(11)  NOT NULL AUTO_INCREMENT,
  `name` varchar(111),
  `rules` varchar(1111),
  `id_user` int(11)  NOT NULL,
  `start_time` int(11)  NOT NULL,
  `end_time` int(11)  NOT NULL,
  `kol_vo` int(11)  NOT NULL,
  `active` int(11)  NOT NULL,
  `pobeda` int(11)  NOT NULL,
  `uchastie` int(11)  NOT NULL,
  `golosue` int(11)  NOT NULL,
  `images` varchar(111),
   PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8  AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `fk_foto` (
  `id` int(11)  NOT NULL AUTO_INCREMENT,
  `id_fk` int(11)  NOT NULL,
  `id_user` int(11)  NOT NULL,
  `golosov` int(11)  NOT NULL,
  `active` int(11)  NOT NULL,
  `time` int(11)  NOT NULL,
  `images` varchar(111),
   PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8  AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `fk_golos` (
  `id_foto` int(11)  NOT NULL,
  `id_fk` int(11)  NOT NULL,
  `id_user` int(11)  NOT NULL ,
  `time` int(11)  NOT NULL 
) ENGINE=MyISAM DEFAULT CHARSET=utf8  AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `fk_discus` (
`id` int(11) NOT NULL auto_increment,
`id_fk` int(11) NOT NULL,
`id_user` int(11) NOT NULL,
`time` int(11) NOT NULL,
`msg` varchar(1024) NOT NULL,
PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;