Файл: football/sql.sql
Строк: 36
CREATE TABLE IF NOT EXISTS `football` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`football` text NOT NULL,
`pods` text NOT NULL,
`img` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=0;
create table `my_football`(
`id` int not
null auto_increment primary key,
`id_user` int not null,
`id_football`
int not null,
`otvet` int not null
)engine=myisam default
charset=utf8;
create table `football_settings`(
`id` int not null
auto_increment primary key,
`pods` int not null,
`propusk` int not
null,
`otvet` int not null
)engine=myisam default charset=utf8;
INSERT
INTO `football_settings` (`id`, `pods`, `propusk`, `otvet`) VALUES
(1,
100, 100, 100);