View file sql.sql

File size: 942B
CREATE TABLE `abuse` (
  `id` int(10) NOT NULL auto_increment,
  `file` int(10) NOT NULL,
  `text` text NOT NULL,
  `ip` varchar(20) NOT NULL,
  `active` set('0','1') NOT NULL default '1',
  `time` int(10) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;

-- --------------------------------------------------------

-- 
-- Структура таблицы `files`
-- 

CREATE TABLE `files` (
  `id` int(10) NOT NULL auto_increment,
  `name` varchar(128) default NULL,
  `description` text NOT NULL,
  `file` varchar(40) NOT NULL,
  `count` int(10) NOT NULL,
  `password` varchar(32) NOT NULL,
  `hash` varchar(32) NOT NULL,
  `ip` varchar(20) NOT NULL,
  `time` int(10) NOT NULL,
  `last_load` int(10) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=cp1251 COMMENT='Таблица Файлов' AUTO_INCREMENT=0 ;