Code:
SQL Error DB function failed with error number 1064
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';ALTER TABLE `mos_session` ADD `domain` LONGTEXT;DROP TABLE IF SQL=ALTER TABLE `mos_session` ADD `order` LONGTEXT;ALTER TABLE `mos_session` ADD `domain` LONGTEXT;DROP TABLE IF EXISTS `mos_moshost_accounts`CREATE TABLE `mos_moshost_accounts` ( `user` int(11) NOT NULL default '0', `domain` int(11) NOT NULL default '0', `active` tinyint(4) NOT NULL default '0', KEY `domain` (`domain`), KEY `user` (`user`) ) TYPE=MyISAM COMMENT='web hosting account information'; DROP TABLE IF EXISTS `mos_moshost_binterval`CREATE TABLE `mos_moshost_binterval` ( `id` int(11) NOT NULL auto_increment, `name` varchar(25) NOT NULL default '', `evaluate` varchar(25) NOT NULL default '', `active` tinyint(4) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='billing intervals'; DROP TABLE IF EXISTS `mos_moshost_domains`CREATE TABLE `mos_moshost_domains` ( `id` int(11) NOT NULL auto_increment, `customer` int(11) NOT NULL default '0', `domain` varchar(50) NOT NULL default 'domain.com', `creationDate` int(11) NOT NULL default '0', `package` int(11) default NULL, `billingDate` int(20) default NULL, `billingInterval` int(4) default '1', `billingRate` float default NULL, `contactEmail` varchar(50) NOT NULL default 'user@domain.com', `options` text, `active` tinyint(4) NOT NULL default '0', `overdue` tinyint(4) NOT NULL default '0', PRIMARY KEY (`id`), KEY `domain` (`domain`), KEY `customer` (`customer`) ) TYPE=MyISAM COMMENT='web hosting account information'; DROP TABLE IF EXISTS `mos_moshost_config`CREATE TABLE `mos_moshost_config` ( `id` tinyint(4) NOT NULL auto_increment, `cpanelKey` longtext NOT NULL, `sslServer` varchar(50) NOT NULL default '', `domainRegistrar` int(11) NOT NULL default '0', `active` tinyint(4) NOT NULL default '0', `report` tinyint(4) NOT NULL default '0', `reportEmail` varchar(50) NOT NULL default '', `sync` tinyint(4) NOT NULL default '0', `process` tinyint(4) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='MOSHost Configuration Table'; INSERT INTO `mos_moshost_config` ( `id` , `cpanelKey` , `sslServer` , `domainRegistrar` , `active` , `report` , `reportEmail` , `sync` , `process` ) VALUES ('', '', '', '0', '0', '0', '', '0', '0')DROP TABLE IF EXISTS `mos_moshost_invoices`CREATE TABLE `mos_moshost_invoices` ( `id` int(11) NOT NULL auto_increment, `domain` int(11) NOT NULL default '0', `dueDate` int(20) NOT NULL default '0', `amountDue` float NOT NULL default '0', `paid` tinyint(4) NOT NULL default '0', PRIMARY KEY (`id`), KEY `domain` (`domain`) ) TYPE=MyISAM COMMENT='mosHost billing invoices'; DROP TABLE IF EXISTS `mos_moshost_options`CREATE TABLE `mos_moshost_options` ( `id` int(11) NOT NULL auto_increment, `name` varchar(20) NOT NULL default '', `price` float NOT NULL default '0', `active` tinyint(4) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='package options'; DROP TABLE IF EXISTS `mos_moshost_packages`CREATE TABLE `mos_moshost_packages` ( `id` int(11) NOT NULL auto_increment, `name` varchar(15) NOT NULL default '', `space` varchar(50) default NULL, `bandwidth` varchar(50) default NULL, `active` tinyint(4) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM COMMENT='hosting packages'; DROP TABLE IF EXISTS `mos_moshost_rate`CREATE TABLE `mos_moshost_rate` ( `id` int(11) NOT NULL auto_increment, `package` tinyint(4) NOT NULL default '0', `interval` tinyint(4) NOT NULL default '0', `rate` float NOT NULL default '0', PRIMARY KEY (`id`), KEY `package` (`package`,`interval`) ) TYPE=MyISAM COMMENT='moshost hosting rates';
SQL =
ALTER TABLE `mos_session` ADD `order` LONGTEXT;ALTER TABLE `mos_session` ADD `domain` LONGTEXT;DROP TABLE IF EXISTS `mos_moshost_accounts`CREATE TABLE `mos_moshost_accounts` (
`user` int(11) NOT NULL default '0',
`domain` int(11) NOT NULL default '0',
`active` tinyint(4) NOT NULL default '0',
KEY `domain` (`domain`),
KEY `user` (`user`)
) TYPE=MyISAM COMMENT='web hosting account information';
DROP TABLE IF EXISTS `mos_moshost_binterval`CREATE TABLE `mos_moshost_binterval` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(25) NOT NULL default '',
`evaluate` varchar(25) NOT NULL default '',
`active` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='billing intervals';
DROP TABLE IF EXISTS `mos_moshost_domains`CREATE TABLE `mos_moshost_domains` (
`id` int(11) NOT NULL auto_increment,
`customer` int(11) NOT NULL default '0',
`domain` varchar(50) NOT NULL default 'domain.com',
`creationDate` int(11) NOT NULL default '0',
`package` int(11) default NULL,
`billingDate` int(20) default NULL,
`billingInterval` int(4) default '1',
`billingRate` float default NULL,
`contactEmail` varchar(50) NOT NULL default 'user@domain.com',
`options` text,
`active` tinyint(4) NOT NULL default '0',
`overdue` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `domain` (`domain`),
KEY `customer` (`customer`)
) TYPE=MyISAM COMMENT='web hosting account information';
DROP TABLE IF EXISTS `mos_moshost_config`CREATE TABLE `mos_moshost_config` (
`id` tinyint(4) NOT NULL auto_increment,
`cpanelKey` longtext NOT NULL,
`sslServer` varchar(50) NOT NULL default '',
`domainRegistrar` int(11) NOT NULL default '0',
`active` tinyint(4) NOT NULL default '0',
`report` tinyint(4) NOT NULL default '0',
`reportEmail` varchar(50) NOT NULL default '',
`sync` tinyint(4) NOT NULL default '0',
`process` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='MOSHost Configuration Table';
INSERT INTO `mos_moshost_config` ( `id` , `cpanelKey` , `sslServer` , `domainRegistrar` , `active` , `report` , `reportEmail` , `sync` , `process` ) VALUES ('', '', '', '0', '0', '0', '', '0', '0')DROP TABLE IF EXISTS `mos_moshost_invoices`CREATE TABLE `mos_moshost_invoices` (
`id` int(11) NOT NULL auto_increment,
`domain` int(11) NOT NULL default '0',
`dueDate` int(20) NOT NULL default '0',
`amountDue` float NOT NULL default '0',
`paid` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `domain` (`domain`)
) TYPE=MyISAM COMMENT='mosHost billing invoices';
DROP TABLE IF EXISTS `mos_moshost_options`CREATE TABLE `mos_moshost_options` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(20) NOT NULL default '',
`price` float NOT NULL default '0',
`active` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='package options';
DROP TABLE IF EXISTS `mos_moshost_packages`CREATE TABLE `mos_moshost_packages` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(15) NOT NULL default '',
`space` varchar(50) default NULL,
`bandwidth` varchar(50) default NULL,
`active` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM COMMENT='hosting packages';
DROP TABLE IF EXISTS `mos_moshost_rate`CREATE TABLE `mos_moshost_rate` (
`id` int(11) NOT NULL auto_increment,
`package` tinyint(4) NOT NULL default '0',
`interval` tinyint(4) NOT NULL default '0',
`rate` float NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `package` (`package`,`interval`)
) TYPE=MyISAM COMMENT='moshost hosting rates';