wiki:Database
Last modified 11 years ago Last modified on 11/10/08 01:44:16 PM
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `gep`
--

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

--
-- Table structure for table `depends`
--

CREATE TABLE IF NOT EXISTS `depends` (
  `id` int(11) NOT NULL default '0',
  `profile_id` int(11) NOT NULL,
  `package` varchar(255) NOT NULL,
  `version` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `hosts`
--

CREATE TABLE IF NOT EXISTS `hosts` (
  `id` int(11) NOT NULL,
  `profile_id` int(11) NOT NULL,
  `hostname` varchar(255) NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `packages`
--

CREATE TABLE IF NOT EXISTS `packages` (
  `id` int(11) NOT NULL auto_increment,
  `profile_id` int(11) NOT NULL,
  `package` varchar(255) NOT NULL,
  `useflags` text NOT NULL,
  `useflags_version` varchar(255) NOT NULL,
  `keyword_version` varchar(255) NOT NULL,
  `mask` varchar(255) NOT NULL,
  `mask_version` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `profies`
--

CREATE TABLE IF NOT EXISTS `profies` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `useflags` text NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;