# phpMyAdmin SQL Dump
# version 2.5.5-pl1
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Mar 05, 2005 at 12:34 PM
# Server version: 4.0.17
# PHP Version: 4.3.4
# 
# Database : `clientexec_stable`
# 

# --------------------------------------------------------

#
# Table structure for table `announcement`
#

CREATE TABLE `announcement` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(125) NOT NULL default '',
  `excerpt` text NOT NULL,
  `post` longtext NOT NULL,
  `postdate` datetime NOT NULL default '0000-00-00',
  `publish` tinyint(4) NOT NULL default '0',
  `authorid` int(11) NOT NULL default '0',
  `recipient` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;


# --------------------------------------------------------

#
# Table structure for table `announcement_recipient`
#

CREATE TABLE `announcement_recipient` (
`ann_id` INT NOT NULL ,
`recipient_id` INT NOT NULL ,
PRIMARY KEY ( `ann_id` , `recipient_id` )
) ENGINE=MYISAM ;

# --------------------------------------------------------

#
# Table structure for table `altuseremail`
#

CREATE TABLE `altuseremail` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(11) NOT NULL default '0',
  `email` varchar(50) NOT NULL default '',
  `sendnotifications` tinyint(4) NOT NULL default '1',
  `sendinvoice` tinyint(4) NOT NULL default '1',
  `support` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

#
# Dumping data for table `altuseremail`
#

# --------------------------------------------------------

#
# Table structure for table `services_log`
#

CREATE TABLE `services_log` (
  `id` int(11) NOT NULL auto_increment,
  `plugin` varchar(50) NOT NULL default '',
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `manually_executed` smallint(6) NOT NULL default '0',
  `results` text NOT NULL,
  `errors` text NOT NULL,
  `status` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `billingtype`
#

CREATE TABLE `billingtype` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(25) NOT NULL default '',
  `description` text NOT NULL,
  `detail` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 ;

# --------------------------------------------------------

#
# Table structure for table `cache`
#

CREATE TABLE `cache` (
  `cachekey` varchar(50) NOT NULL default '',
  `lastupdated` datetime NOT NULL default '0000-00-00 00:00:00',
  `content` mediumblob NOT NULL,
  PRIMARY KEY  (`cachekey`)
) ENGINE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `country`
#

CREATE TABLE `country` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(80) NOT NULL default '',
  `iso` char(2) NOT NULL default '',
  `phone_code` varchar(10) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `by_name` (`name`,`iso`),
  KEY `by_iso` (`iso`,`name`)
);

# --------------------------------------------------------

#
# Table structure for table `coupons`
#

CREATE TABLE `coupons` (
  `coupons_id` int(11) NOT NULL auto_increment,
  `coupons_name` varchar(50) NOT NULL default '',
  `coupons_description` text NOT NULL,
  `coupons_code` varchar(50) NOT NULL default '',
  `coupons_quantity` int(11) NOT NULL default '0',
  `coupons_type` tinyint(4) NOT NULL default '0',
  `coupons_discount` float NOT NULL default '0',
  `coupons_start` date NOT NULL default '0000-00-00',
  `coupons_expires` date NOT NULL default '0000-00-00',
  `coupons_recurring` tinyint(4) NOT NULL default '0',
  `coupons_billingcycles` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`coupons_id`)
) ENGINE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `coupons_packages`
#

CREATE TABLE `coupons_packages` (
  `id` int(11) NOT NULL auto_increment,
  `coupons_id` int(11) NOT NULL default '0',
  `promotion_id` int(11) NOT NULL default '0',
  `package_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `currency`
#

CREATE TABLE `currency` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(250) NOT NULL default '',
  `symbol` char(3) NOT NULL default '',
  `abrv` varchar(4) NOT NULL default '',
  KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 ;

# --------------------------------------------------------

#
# Table structure for table `customdomainfields`
#

CREATE TABLE `customdomainfields` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL default '',
  `type` tinyint(4) NOT NULL default '0',
  `isrequired` tinyint(4) NOT NULL default '0',
  `isChangable` tinyint(4) NOT NULL default '1',
  `isAdminOnly` tinyint(4) NOT NULL default '0',
  `width` tinyint(4) NOT NULL default '20',
  `myOrder` int(11) NOT NULL default '0',
  `showcustomer` tinyint(4) NOT NULL default '0',
  `showadmin` tinyint(4) NOT NULL default '0',
  `dropdownoptions` longtext NOT NULL,
  `inSettings` tinyint(4) NOT NULL default '1',
  `InSignup` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 ;

# --------------------------------------------------------

#
# Table structure for table `customuserfields`
#

CREATE TABLE `customuserfields` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL default '',
  `type` tinyint(4) NOT NULL default '0',
  `isrequired` tinyint(4) NOT NULL default '0',
  `isChangable` tinyint(4) NOT NULL default '1',
  `isAdminOnly` tinyint(4) NOT NULL default '0',
  `width` tinyint(4) NOT NULL default '20',
  `myOrder` int(11) NOT NULL default '0',
  `showcustomer` tinyint(4) NOT NULL default '1',
  `showadmin` tinyint(4) NOT NULL default '1',
  `InSignup` tinyint(1) NOT NULL default '0',
  `inSettings` smallint(6) NOT NULL default '1',
  `dropdownoptions` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=25 ;

# --------------------------------------------------------

#
# Table structure for table `domain_customdomainfields`
#

CREATE TABLE `domain_customdomainfields` (
  `userid` int(11) NOT NULL default '0',
  `customid` int(11) NOT NULL default '0',
  `value` text,
  PRIMARY KEY  (`userid`,`customid`)
) ENGINE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `domain_packageaddon_prices` 
#

CREATE TABLE `domain_packageaddon_prices` (
    `domain_id` int(11) NOT NULL default '0',
    `packageaddon_prices_id` int(11) NOT NULL default '0',
    `billing_cycle` tinyint(4) NOT NULL default '0',
    PRIMARY KEY  (`domain_id`,`packageaddon_prices_id`)
) ENGINE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `domains`
#

CREATE TABLE `domains` (
  `id` int(11) NOT NULL auto_increment,
  `DomainName` text,
  `CustomerID` int(11) default NULL,
  `UserName` text,
  `password` varchar(25) NOT NULL default '',
  `recurring` tinyint(4) default NULL,
  `registration_years` tinyint(4) NOT NULL default '0',
  `Comments` mediumtext,
  `current` tinyint(4) NOT NULL default '1',
  `billsent` tinyint(1) NOT NULL default '0',
  `registrar_orderid` varchar(50) NOT NULL default '0',
  `status` tinyint(1) NOT NULL default '0',
  `Plan` int(11) NOT NULL default '0',
  `dateActivated` date default NULL,
  `controlpanel` int(11) NOT NULL default '0',
  `serverid` int(11) NOT NULL default '0',
  `server_acct_properties` TEXT default NULL,
  `domain_extra_attr` TEXT default NULL,
  `shared` tinyint(4) NOT NULL default '1',
  `nextbilldate` date default NULL,
  `paymentterm` tinyint(4) default NULL,
  `promotionid` int(11) NOT NULL default '0',
  `register` TINYINT NOT NULL DEFAULT '0',
  `signup` TINYINT NOT NULL DEFAULT '0',
  PRIMARY KEY  (`id`),
  KEY `CustomerID` (`CustomerID`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `email_queue`
#

CREATE TABLE `email_queue` (
  `id` int(11) NOT NULL auto_increment,
  `subject` varchar(255) NOT NULL default '',
  `from` varchar(50) NOT NULL default '',
  `from_name` varchar(50) NOT NULL default '',
  `userid` text NOT NULL,
  `bcc` varchar(50) NOT NULL default '',
  `priority` tinyint(4) NOT NULL default '0',
  `confirmreceipt` tinyint(4) NOT NULL default '0',
  `emailtype` varchar(50) NOT NULL default '',
  `body` text NOT NULL,
  `striptags` tinyint(4) NOT NULL default '0',
  `nl2br` tinyint(4) NOT NULL default '0',
  `dfilename` varchar(50) NOT NULL default '',
  `attachment` longtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `files`
#

CREATE TABLE `files` (
  `id_file` int(11) NOT NULL auto_increment,
  `id_cat` int(11) default NULL,
  `name` varchar(50) NOT NULL default '',
  `description` varchar(100) NOT NULL default '',
  `hash` varchar(16) NOT NULL default '',
  `visible` int(11) NOT NULL default '0',
  `size` int(11) NOT NULL default '0',
  `added` date NOT NULL default '0000-00-00',
  `downloads` int(11) NOT NULL default '0',
  `lastip` varchar(15) NOT NULL default '',
  `notes` TEXT NOT NULL,
   `user_status` SET('-3', '-2', '-1', '0', '1') NOT NULL,
  PRIMARY KEY  (`id_file`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `files_cats`
#

CREATE TABLE `files_cats` (
  `id_cat` int(11) NOT NULL auto_increment,
  `id_parent` int(11) default NULL,
  `name` varchar(50) NOT NULL default '',
  `visible` int(11) NOT NULL default '0',
  `user_status` SET('-3', '-2', '-1', '0', '1') NOT NULL,
  PRIMARY KEY  (`id_cat`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `files_cats_clienttypes`
#

CREATE TABLE `files_cats_clienttypes` (
  `id_cat` int(11) NOT NULL default '0',
  `id_clienttype` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id_cat`,`id_clienttype`)
) ENGINE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `files_cats_servers`
#

CREATE TABLE `files_cats_servers` (
  `id_cat` int(11) NOT NULL default '0',
  `id_server` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id_cat`,`id_server`)
) ENGINE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `files_cats_users`
#

CREATE TABLE `files_cats_users` (
  `id_cat` int(11) NOT NULL default '0',
  `id_user` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id_cat`,`id_user`)
) ENGINE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `files_clienttypes`
#

CREATE TABLE `files_clienttypes` (
  `id_file` int(11) NOT NULL default '0',
  `id_clienttype` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id_file`,`id_clienttype`)
) ENGINE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `files_servers`
#

CREATE TABLE `files_servers` (
  `id_file` int(11) NOT NULL default '0',
  `id_server` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id_file`,`id_server`)
) ENGINE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `files_users`
#

CREATE TABLE `files_users` (
  `id_file` int(11) NOT NULL default '0',
  `id_user` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id_file`,`id_user`)
) ENGINE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `groups`
#

CREATE TABLE `groups` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL default '',
  `deletable` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `id_2` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 ;

# --------------------------------------------------------

#
# Table structure for table `help`
#

CREATE TABLE `help` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(40) NOT NULL default '',
  `detail` text NOT NULL,
  `linkwords` varchar(40) NOT NULL default 'Click to view available tags',
  `width` int(3) NOT NULL default '240',
  `height` int(3) NOT NULL default '320',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `id_2` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 ;

# --------------------------------------------------------

#
# Table structure for table `invoice`
#

CREATE TABLE `invoice` (
  `id` int(11) NOT NULL auto_increment,
  `customerid` int(11) NOT NULL default '0',
  `billdate` date NOT NULL default '0000-00-00',
  `description` varchar(50) NOT NULL default '',
  `amount` float NOT NULL default '0',
  `sent` tinyint(4) NOT NULL default '0',
  `paid` tinyint(1) NOT NULL default '0',
  `archive` tinyint(4) NOT NULL default '0',
  `sentdate` date default NULL,
  `datepaid` date default NULL,
  `tax` float NOT NULL default '0',
  `processorid` varchar(255) NOT NULL default '',
  `pluginused` VARCHAR( 15 ) DEFAULT 'none' NOT NULL,
  `checknum` VARCHAR( 10 ) NOT NULL ,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`),
  INDEX ( `customerid` )
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `invoiceentry`
#

CREATE TABLE `invoiceentry` (
  `id` int(11) NOT NULL auto_increment,
  `customerid` int(11) NOT NULL default '0',
  `description` varchar(95) NOT NULL default '',
  `detail` text NOT NULL,
  `invoiceid` int(11) NOT NULL default '0',
  `date` date NOT NULL default '0000-00-00',
  `billingtypeid` int(11) NOT NULL default '0',
  `price` float NOT NULL default '0',
  `recurring` int(11) NOT NULL default '0',
  `appliestoid` int(11) NOT NULL default '0',
  `includenextpayment` tinyint(4) NOT NULL default '0',
  `paymentterm` tinyint(4) NOT NULL default '0',
  `setup` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM COMMENT='Maintain information of work completed for customer' AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `invoicetransaction`
#

CREATE TABLE `invoicetransaction` (
  `id` int(11) NOT NULL auto_increment,
  `invoiceid` int(11) NOT NULL default '0',
  `accepted` tinyint(4) NOT NULL default '0',
  `response` text NOT NULL,
  `transactiondate` datetime NOT NULL default '0000-00-00 00:00:00',
  `transactionid` VARCHAR( 25 ) DEFAULT 'NA' NOT NULL,
  `action` VARCHAR( 10 ) DEFAULT 'none' NOT NULL,
  `last4` VARCHAR( 5 ) DEFAULT '0000' NOT NULL,
  `amount` FLOAT DEFAULT '0.0' NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `module`
#

CREATE TABLE `module` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(25) NOT NULL default '',
  `description` text,
  `moduleorder` int(11) NOT NULL default '0',
  `deletable` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `id_2` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 ;

# --------------------------------------------------------

#
# Table structure for table `module_group`
#

CREATE TABLE `module_group` (
  `moduleid` int(11) NOT NULL default '0',
  `groupid` int(11) NOT NULL default '0',
  `viewable` tinyint(4) NOT NULL default '1',
  `viewall` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`moduleid`,`groupid`)
) ENGINE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `nameserver`
#

CREATE TABLE `nameserver` (
  `id` int(11) NOT NULL auto_increment,
  `serverid` int(11) NOT NULL default '0',
  `ip` varchar(50) NOT NULL default '',
  `hostname` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `package`
#

CREATE TABLE `package` (
  `id` int(11) NOT NULL auto_increment,
  `planname` varchar(45) NOT NULL default '',
  `description` text NOT NULL,
  `planid` int(11) NOT NULL default '0',
  `price` float NOT NULL default '0',
  `showpackage` smallint(6) NOT NULL default '1',
  `price3` float NOT NULL default '0',
  `price6` float NOT NULL default '0',
  `price12` float NOT NULL default '0',
  `price1included` tinyint(4) NOT NULL default '1',
  `price3included` tinyint(4) NOT NULL default '1',
  `price6included` tinyint(4) NOT NULL default '1',
  `price12included` tinyint(4) NOT NULL default '1',
  `setup` float NOT NULL default '0',
  `usedefaultwelcome` tinyint(4) NOT NULL default '1',
  `welcomeemail` text,
  `taxable` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `id_2` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 ;

# --------------------------------------------------------

#
# Table structure for table `package_variable`
#

CREATE TABLE `package_variable` (
  `packageid` int(11) NOT NULL default '0',
  `varname` varchar(50) NOT NULL default '',
  `value` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`packageid`,`varname`)
) ENGINE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `packageaddon`
#

CREATE TABLE `packageaddon` (
    `id` INT NOT NULL AUTO_INCREMENT ,
    `package_id` INT NOT NULL ,
    `description` VARCHAR( 50 ) NOT NULL ,
    `plugin_var` VARCHAR( 50 ) NOT NULL ,
    `order` int(11) NOT NULL default '0',
    PRIMARY KEY ( `id` )
) ENGINE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `packageaddon_prices`
#

CREATE TABLE `packageaddon_prices` (
    `id` int(11) NOT NULL auto_increment,
    `packageaddon_id` int(11) NOT NULL default '0',
    `sortkey` int(11) NOT NULL default '0',
    `detail` varchar(50) NOT NULL default '',
    `plugin_var_value` varchar(50) NOT NULL default '',
    `price0` float NOT NULL default '-1',
    `price1` float NOT NULL default '-1',
    `price1_force` smallint(6) NOT NULL default '0',
    `price3` float NOT NULL default '-1',
    `price3_force` smallint(6) NOT NULL default '0',
    `price6` float NOT NULL default '-1',
    `price6_force` tinyint(4) NOT NULL default '0',
    `price12` float NOT NULL default '-1',
    `price12_force` tinyint(4) NOT NULL default '0',
    PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `package_server`
#

CREATE TABLE `package_server` (
  `id` int(11) NOT NULL auto_increment,
  `package_id` int(11) NOT NULL default '0',
  `server_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `promotion`
#

CREATE TABLE `promotion` (
  `id` int(11) NOT NULL auto_increment,
  `code` varchar(20) NOT NULL default '',
  `description` text NOT NULL,
  `active` tinyint(4) NOT NULL default '1',
  `showuser` tinyint(4) NOT NULL default '1',
  `welcomeemail` text NOT NULL,
  `isdefault` smallint(1) NOT NULL default '0',
  `name` varchar(50) NOT NULL default '',
  `regdomain` smallint(1) NOT NULL default '1',
  `issub` tinyint(4) NOT NULL default '0',
  `maindomain` varchar(50) NOT NULL default 'yourdomain.com',
  `allowreg` tinyint(4) NOT NULL default '1',
  `allowtransfer` tinyint(4) NOT NULL default '0',
  `allowselfmanage` tinyint(4) NOT NULL default '1',
  `promorder` int(11) NOT NULL ,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 ;

# --------------------------------------------------------

#
# Table structure for table `recurringfee`
#

CREATE TABLE `recurringfee` (
  `id` int(11) NOT NULL auto_increment,
  `customerid` int(11) NOT NULL default '0',
  `billingtypeid` int(11) NOT NULL default '0',
  `packageaddon_prices_id` int(11) NOT NULL default '0',
  `description` text default NULL,
  `detail` text default NULL,
  `amount` float NOT NULL default '0',
  `appliestoid` int(11) NOT NULL default '0',
  `nextbilldate` date default NULL,
  `paymentterm` tinyint(4) default NULL,
  `disablegenerate` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `id_2` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `registrars`
#

CREATE TABLE `registrars` (
    `plugin` VARCHAR( 20 ) NOT NULL ,
    `tld` VARCHAR( 10 ) NOT NULL ,
    `extra_attributes` TEXT NOT NULL ,
    PRIMARY KEY ( `plugin` , `tld` )
);

# --------------------------------------------------------

#
# Table structure for table `report`
#

CREATE TABLE `report` (
    `name` VARCHAR( 80 ) NOT NULL ,
    `public` TINYINT DEFAULT '0' NOT NULL ,
    `quickgraph` TINYINT DEFAULT '0' NOT NULL ,
    PRIMARY KEY ( `name` )
);

# --------------------------------------------------------

#
# Table structure for table `server`
#

CREATE TABLE `server` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(25) NOT NULL default '',
  `hostname` varchar(50) NOT NULL default '',
  `sharedip` varchar(50) NOT NULL default '',
  `isdefault` tinyint(1) NOT NULL default '0',
  `plugin` varchar(25) NOT NULL default '',
  `last_utilization` datetime NOT NULL default '0000-00-00 00:00:00',
  `domains_quota` int(11) NOT NULL default '0',
  `statsurl` VARCHAR( 225 ) NOT NULL ,
  `statsviewable` TINYINT DEFAULT '0' NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `serverip`
#

CREATE TABLE `serverip` (
  `serverid` int(11) NOT NULL default '0',
  `ip` varchar(50) NOT NULL default ''
) ENGINE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `serverplugin_options`
#

CREATE TABLE `serverplugin_options` (
  `serverid` int(11) NOT NULL default '0',
  `optionname` varchar(125) NOT NULL default '',
  `value` longtext NOT NULL,
  PRIMARY KEY  (`serverid`,`optionname`)
) ENGINE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `setting`
#

CREATE TABLE `setting` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) default NULL,
  `value` text NOT NULL,
  `description` text NOT NULL,
  `type` tinyint(4) NOT NULL default '0',
  `isrequired` tinyint(4) NOT NULL default '1',
  `istruefalse` tinyint(4) NOT NULL default '0',
  `istextarea` tinyint(4) NOT NULL default '0',
  `isfromoptions` tinyint(4) NOT NULL default '0',
  `myorder` int(11) NOT NULL default '0',
  `helpid` int(3) default '0',
  `plugin` tinyint(4) NOT NULL default '0',
  `ispassword` tinyint(4) NOT NULL default '0',
  `ishidden` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `id_2` (`id`),
  KEY `plugin` (`plugin`)
) ENGINE=MyISAM AUTO_INCREMENT=133 ;

# --------------------------------------------------------

#
# Table structure for table `setting_options`
#

CREATE TABLE `setting_options` (
  `id` int(11) NOT NULL auto_increment,
  `settingid` int(11) NOT NULL default '0',
  `name` varchar(50) NOT NULL default '',
  `value` text,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `id_2` (`id`)
) ENGINE=MyISAM COMMENT='Contains all the available options for a giving setting' AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `taxrule`
#

CREATE TABLE `taxrule` (
  `countrycode` varchar(5) NOT NULL default '',
  `state` varchar(20) NOT NULL default '',
  `tax` float NOT NULL default '0',
  PRIMARY KEY  (`countrycode`,`state`)
) ENGINE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `tld`
#

CREATE TABLE `tld` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(15) NOT NULL default '',
  `period` int(11) NOT NULL default '1',
  `price` float NOT NULL default '9.95',
  `transferprice` float NOT NULL default '9.95',
  `package` int(11) NOT NULL default '0',
  `billingcycle` int(11) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 ;

# --------------------------------------------------------

#
# Table structure for table `troubleticket`
#

CREATE TABLE `troubleticket` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(11) NOT NULL default '0',
  `subject` text NOT NULL,
  `priority` int(2) NOT NULL default '3',
  `datesubmitted` datetime NOT NULL default '0000-00-00 00:00:00',
  `status` int(2) NOT NULL default '0',
  `messagetype` varchar(40) NOT NULL default 'Other',
  `assignedtoid` int(11) NOT NULL default '0',
  `lastlog_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

# --------------------------------------------------------

# 
# Table structure for table `troubleticket_files`
# 

CREATE TABLE `troubleticket_files` (
  `id` int(11) NOT NULL auto_increment,
  `ticketid` int(11) NOT NULL,
  `filename` varchar(50) NOT NULL,
  `dateadded` datetime NOT NULL,
  `filekey` varchar(16) NOT NULL,
  `userid` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `filekey` (`filekey`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `troubleticket_log`
#

CREATE TABLE `troubleticket_log` (
  `id` int(11) NOT NULL auto_increment,
  `troubleticketid` int(11) NOT NULL default '0',
  `message` text NOT NULL,
  `userid` int(11) NOT NULL default '0',
  `mydatetime` datetime NOT NULL default '0000-00-00 00:00:00',
  `logaction` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `message` (`message`),
  FULLTEXT KEY `message_2` (`message`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `troubleticket_type`
#

CREATE TABLE `troubleticket_type` (
  `name` varchar(40) NOT NULL default '',
  `myorder` int(2) NOT NULL default '0',
  PRIMARY KEY  (`name`)
) ENGINE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `user_customuserfields`
#

CREATE TABLE `user_customuserfields` (
  `userid` int(11) NOT NULL default '0',
  `customid` int(11) NOT NULL default '0',
  `value` text,
  PRIMARY KEY  (`userid`,`customid`)
) ENGINE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `users`
#

CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `current` tinyint(1) default '1',
  `comments` mediumtext,
  `paymenttype` varchar(30) NOT NULL default '0',
  `clienttype` tinyint(4) NOT NULL default '0',
  `groupid` int(10) unsigned default '1',
  `password` varchar(45) default NULL,
  `dateActivated` date default NULL,
  `signature` text default NULL,
  `lastseen` datetime default NULL,
  `isOrganization` tinyint(4) default '0',
  `active` smallint(6) NOT NULL default '1',
  `recurring` tinyint(4) default '1',
  `currency` varchar(5) default '0',
  `data1` text default NULL,
  `autopayment` smallint(1) NOT NULL default '0',
  `ccmonth` varchar(4) NOT NULL default '0',
  `ccyear` varchar(4) NOT NULL default '0',
  `cclastfour` varchar(5) NOT NULL default '',
  `data2` text default NULL,
  `data3` text default NULL,
  `passphrased` smallint(1) NOT NULL default '0',
  `updating` tinyint(4) NOT NULL default '0',
  `taxable` tinyint(4) NOT NULL default '0',
  `status` tinyint(4) NOT NULL default '0',
  `firstname` varchar(25) NOT NULL default '',
  `lastname` varchar(25) NOT NULL default '',
  `email` varchar(60) NOT NULL default '',
  `organization` varchar(60) NOT NULL default '',
  `usernotes` longtext default NULL,
  `usernotespos` varchar(75) NOT NULL default '',
  `warningmask` int(11) NOT NULL default '0',
  `balance` FLOAT DEFAULT '0' NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=101 ;
