• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

psa.subdomains

M

morrisqueto

Guest
psa.subdomains SQL (for creating the table)

Could someone give me the sql query for creating the subdomains table ???
It seems it is incomplete after a system upgrade... it is missing the 'fp' coumn, and maybe others.
 
/*
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
*/
 
Back
Top