psa.subdomains

[morrisqueto]

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.

 

[morrisqueto]

/*
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
*/