CREATE TABLE IF NOT EXISTS magazin_file id int 11 NOT NULL AUTO_INCREM

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
CREATE TABLE IF NOT EXISTS `magazin_file` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_r` int(11) NOT NULL DEFAULT '0',
`id_pr` int(11) NOT NULL,
`name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`price` int(11) NOT NULL DEFAULT '0',
`user_id` int(11) NOT NULL,
`kopii` int(11) NOT NULL,
`opis` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`file` char(250) COLLATE utf8_unicode_ci NOT NULL,
`time` int(11) DEFAULT NULL,
`prava` int(11) NOT NULL DEFAULT '0',
`prodano` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;