-- 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 ;