CREATE TABLE `files` ( `path` varchar(300) NOT NULL,
`engname` char(200) NOT NULL, `russname` char(200) NOT NULL,
`id` int(20) NOT NULL auto_increment,
`yes` varchar(20) NOT NULL, `no` varchar(20) NOT NULL, `name` varchar(200) NOT NULL,
`infolder` char(200) NOT NULL, `ext` char(200) NOT NULL,
time int(30) NOT NULL,
`opis` varchar(800) NOT NULL,
`size` int(20) NOT NULL,
`prosmotr` char(200) NOT NULL, `dir` char(200) NOT NULL,
`timeupload` DATETIME NOT NULL,
`loads` int(20) NOT NULL, `timeload` int(20) NOT NULL,
`posload` char(200) NOT NULL, PRIMARY KEY(`id`));
CREATE TABLE `com` ( `id` int(20) NOT NULL auto_increment, `name` char(40) NOT NULL, `msg` varchar(400) NOT NULL, `ip` char(30) NOT NULL, `br` char(60) NOT NULL, `date` DATETIME NOT NULL, `file_id` int(20) NOT NULL, PRIMARY KEY(`id`));
CREATE TABLE `options` ( `onpage` int(20) NOT NULL, `newfile` varchar(200) NOT NULL, `title` varchar(200) NOT NULL, `image` varchar(20) NOT NULL, `marker` varchar(20) NOT NULL, `naroff` varchar(20) NOT NULL, `nar` varchar(20) NOT NULL, `ok` varchar(20) NOT NULL, `kom` varchar(20) NOT NULL, `top` varchar(20) NOT NULL, `ziponpage` int(20) NOT NULL, `soff` varchar(20) NOT NULL, `zipoff` varchar(20) NOT NULL, zip varchar(20) NOT NULL, size int(20) NOT NULL, text varchar(200) NOT NULL, color char(40) NOT NULL);
CREATE TABLE `admin` ( `pass` char(30) NOT NULL);
CREATE TABLE `table` ( `id` int(20) NOT NULL auto_increment, `zakaz` varchar(900) NOT NULL, `status` char(40) NOT NULL, PRIMARY KEY(`id`));