1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    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...