/*
SQLyog v4.0
Host - localhost : Database - psa
**************************************************************
Server version 4.0.20a-nt
*/
create database if not exists `psa`;
use `psa`;
/*
Table structure for subdomains
*/
drop table if exists `subdomains`;
CREATE TABLE `subdomains` (
`id` int(10) unsigned NOT NULL auto_increment,
`dom_id` int(10) unsigned NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`sys_user_type` enum('main','native') NOT NULL default 'main',
`sys_user_id` int(10) unsigned NOT NULL default '0',
`ssi` enum('false','true','partial') NOT NULL default 'false',
`php` enum('false','true') NOT NULL default 'false',
`cgi` enum('false','true') NOT NULL default 'false',
`perl` enum('false','true') NOT NULL default 'false',
`python` enum('false','true') NOT NULL default 'false',
`coldfusion` enum('false','true') NOT NULL default 'false',
`asp` enum('false','true') NOT NULL default 'false',
`asp_dot_net` enum('false','true') NOT NULL default 'false',
`fp` enum('false','true') NOT NULL default 'false',
`fp_enable` enum('false','true') NOT NULL default 'false',
PRIMARY KEY (`id`),
UNIQUE KEY `dom_id` (`dom_id`,`name`)
) TYPE=InnoDB;
/*
Table data for psa.subdomains
*/