Просмотр файла install.sql

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

CREATE TABLE `lib_file` (
  `id` int(11) NOT NULL auto_increment,
  `fid` int(11) NOT NULL,
  `name` text NOT NULL,
  `file` text NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;



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

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

CREATE TABLE `lib_kom` (
  `id` int(11) NOT NULL auto_increment,
  `fid` int(11) NOT NULL,
  `user` int(11) NOT NULL,
  `text` text NOT NULL,
  `ip` varchar(17) NOT NULL,
  `soft` text NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY  (`id`,`fid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;


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

CREATE TABLE `lib_settings` (
  `key` tinytext NOT NULL,
  `val` text NOT NULL,
  PRIMARY KEY  (`key`(30))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Дамп данных таблицы `lib_settings`
-- 

INSERT INTO `lib_settings` VALUES ('kol_file', '10');
INSERT INTO `lib_settings` VALUES ('new_fil', '10');
INSERT INTO `lib_settings` VALUES ('simvol', '2000');
INSERT INTO `lib_settings` VALUES ('dos_load', '1');

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

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

CREATE TABLE `lib_zak` (
  `id` int(11) NOT NULL auto_increment,
  `user` int(11) NOT NULL,
  `text` text NOT NULL,
  `time` int(11) NOT NULL,
  `type` smallint(6) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;

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

CREATE TABLE `library` (
  `id` int(11) NOT NULL auto_increment,
  `fid` int(11) NOT NULL,
  `path` text NOT NULL,
  `file` text NOT NULL,
  `type` text NOT NULL,
  `type2` tinytext NOT NULL,
  `name` text NOT NULL,
  `opis` text NOT NULL,
  `text` longtext,
  `ip` varchar(25) default NULL,
  `soft` text NOT NULL,
  `time` int(11) NOT NULL,
  `count` int(11) NOT NULL,
  `id_avtor` int(11) NOT NULL,
  `rating` text NOT NULL,
  `moder` tinyint(4) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;