1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice

psa.subdomains

Discussion in 'Plesk for Windows - 8.x and Older' started by morrisqueto, May 18, 2005.

  1. morrisqueto

    morrisqueto Guest

    0
     
    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.
     
  2. morrisqueto

    morrisqueto Guest

    0
     
    /*
    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
    */
     
Loading...