Просмотр архива Магазин скриптов. Без дыр и прочей фигни

CREATE TABLE `mag_shop_files` (
  `id` int(11) NOT NULL auto_increment,
 
`id_user` int(11) NOT NULL,
  `id_dir` int(11) NOT NULL,
  `name`
varchar(128) NOT NULL,
  `ras` varchar(36) NOT NULL,
  `type` varchar(64)
NOT NULL,
  `time` int(11) NOT NULL,
  `time_last` int(11) NOT NULL,
 
`size` int(11) NOT NULL,
  `k_loads` int(11) default '0',
  `nazva` text
NOT NULL,
  `skidka` text NOT NULL,
  `procent` varchar(128) NOT NULL,
 
`summa` varchar(128) NOT NULL,
  `opis` text NOT NULL,
  `cena`
varchar(128) NOT NULL,
  `blok` enum('0','1') NOT NULL DEFAULT '0',
 
PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE
`mag_shop_dir` (
  `id` int(11) NOT NULL auto_increment,
  `num` int(11)
default '0',
  `name` varchar(64) NOT NULL,
  `ras` varchar(128) NOT
NULL,
  `maxfilesize` int(11) NOT NULL,
  `dir` varchar(512) NOT NULL
default '/',
  `dir_osn` varchar(512) default '/',
  `upload`
set('1','0') NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `num`
(`num`),
  KEY `dir` (`dir`(333))
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;

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

CREATE TABLE `vvod_list` (
  `id` int(11) NOT NULL
auto_increment,
  `id_user` int(11) NOT NULL,
  `summa` varchar(12)
DEFAULT NULL,
  `ok` set('0','1') NOT NULL DEFAULT '0',
  `time` int(11)
NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT
CHARSET=cp1251 AUTO_INCREMENT=1 ;

CREATE TABLE `vivod_list` (
  `id`
int(11) NOT NULL auto_increment,
  `id_user` int(11) NOT NULL,
  `summa`
varchar(12) DEFAULT NULL,
  `ok` set('0','1') NOT NULL DEFAULT '0',
 
`time` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=1 DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

CREATE TABLE
`my_vvod` (
  `id` int(11) NOT NULL auto_increment,
  `id_user` int(11)
NOT NULL,
  `summa` varchar(12) DEFAULT NULL,
  `ok` set('0','1') NOT
NULL DEFAULT '0',
  `time` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
)
ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1
;

CREATE TABLE `my_vivod` (
  `id` int(11) NOT NULL auto_increment,
 
`id_user` int(11) NOT NULL,
  `summa` varchar(12) DEFAULT NULL,
  `ok`
set('0','1') NOT NULL DEFAULT '0',
  `time` int(11) NOT NULL,
  PRIMARY
KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=cp1251
AUTO_INCREMENT=1 ;