Хранилища Subversion ant

Сравнить редакции

Не учитывать пробелы Редакция 326 → Редакция 327

/branches/ant-ng/sql/generator-structure.sql
3,7 → 3,7
-- http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время создания: Окт 14 2009 г., 17:08
-- Время создания: Окт 16 2009 г., 19:12
-- Версия сервера: 5.1.37
-- Версия PHP: 5.2.11-1
 
82,34 → 82,6
-- --------------------------------------------------------
 
--
-- Структура таблицы `g_host2net`
--
 
DROP TABLE IF EXISTS `g_host2net`;
CREATE TABLE IF NOT EXISTS `g_host2net` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`rhost_id` int(3) NOT NULL,
`nb_id` int(2) NOT NULL,
PRIMARY KEY (`id`),
KEY `rhost_id` (`rhost_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository hosts into network block' AUTO_INCREMENT=3 ;
 
-- --------------------------------------------------------
 
--
-- Структура таблицы `g_netblock`
--
 
DROP TABLE IF EXISTS `g_netblock`;
CREATE TABLE IF NOT EXISTS `g_netblock` (
`nb_id` int(2) NOT NULL AUTO_INCREMENT,
`netblock` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`nb_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Network blocks' AUTO_INCREMENT=3 ;
 
-- --------------------------------------------------------
 
--
-- Структура таблицы `g_protos`
--
 
147,7 → 119,7
`rhost` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`rhost_id`),
KEY `proto_id` (`rhost`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository hosts' AUTO_INCREMENT=3 ;
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository hosts' AUTO_INCREMENT=4 ;
 
-- --------------------------------------------------------
 
164,6 → 136,7
`version` int(5) NOT NULL,
`rtype_id` int(2) NOT NULL,
`scheme_id` int(2) NOT NULL,
`repname` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
`repinfo` text COLLATE utf8_unicode_ci NOT NULL,
`repkey` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`rep_id`),
173,7 → 146,7
KEY `version` (`version`),
KEY `rtype_id` (`rtype_id`),
KEY `scheme_id` (`scheme_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository' AUTO_INCREMENT=1 ;
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Repository' AUTO_INCREMENT=2 ;
 
-- --------------------------------------------------------
 
215,7 → 188,7
`rep_id` int(5) NOT NULL,
PRIMARY KEY (`id`),
KEY `sect_id` (`sect_id`,`rep_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Sections in repositories' AUTO_INCREMENT=1 ;
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Sections in repositories' AUTO_INCREMENT=4 ;
 
-- --------------------------------------------------------