-- phpMyAdmin SQL Dump
-- version 2.11.3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 02, 2008 at 06:44 PM
-- Server version: 5.1.22
-- PHP Version: 5.2.4

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `httpd`
--
CREATE DATABASE `httpd` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
USE `httpd`;

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

--
-- Table structure for table `aliases`
--

DROP TABLE IF EXISTS `aliases`;
CREATE TABLE IF NOT EXISTS `aliases` (
  `id` int(11) NOT NULL COMMENT 'hosts id (see hosts table)',
  `alias` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'alias for host',
  UNIQUE KEY `alias` (`alias`),
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `configuration`
--

DROP TABLE IF EXISTS `configuration`;
CREATE TABLE IF NOT EXISTS `configuration` (
  `id` int(11) NOT NULL COMMENT 'hosts id (see hosts table)',
  `configuration` text COLLATE utf8_unicode_ci NOT NULL COMMENT 'aditional configuration directives for host',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

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

DROP TABLE IF EXISTS `hosts`;
CREATE TABLE IF NOT EXISTS `hosts` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'hosts unique id',
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'hosts domain name',
  `enabled` tinyint(1) NOT NULL default '1' COMMENT 'enable host',
  `webdav` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'enable webdav server',
  `ftp` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'enable ftp server',
  `cgi` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'enable cgi',
  `ssi` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'enable server side include',
  `php` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'enable php',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
  `id` tinyint(4) NOT NULL AUTO_INCREMENT COMMENT 'unique user id',
  `host` tinyint(4) NOT NULL COMMENT 'host id',
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'name of user',
  `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'password of user',
  `groups` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'groups (comma seperated)',
  PRIMARY KEY (`id`),
  KEY `host` (`host`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

ApacheVirtualHostMysql/database (last edited 2009-09-20 22:13:30 by localhost)