芝麻web文件管理V1.00

编辑当前文件:/home/pulsehostuk9/www/portal.pulsehost.co.uk/resources/sql/install/tblproducts.schema.sql
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; DROP TABLE IF EXISTS `tblproducts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblproducts` ( `id` int(10) NOT NULL AUTO_INCREMENT, `type` text COLLATE utf8_unicode_ci NOT NULL, `gid` int(10) NOT NULL, `name` text COLLATE utf8_unicode_ci NOT NULL, `slug` varchar(128) NOT NULL DEFAULT '', `description` text COLLATE utf8_unicode_ci NOT NULL, `hidden` tinyint(1) NOT NULL, `showdomainoptions` tinyint(1) NOT NULL, `welcomeemail` int(10) NOT NULL DEFAULT '0', `stockcontrol` tinyint(1) NOT NULL, `qty` int(10) NOT NULL DEFAULT '0', `proratabilling` tinyint(1) NOT NULL, `proratadate` int(2) NOT NULL, `proratachargenextmonth` int(2) NOT NULL, `paytype` text COLLATE utf8_unicode_ci NOT NULL, `allowqty` int(1) NOT NULL, `subdomain` text COLLATE utf8_unicode_ci NOT NULL, `autosetup` text COLLATE utf8_unicode_ci NOT NULL, `servertype` text COLLATE utf8_unicode_ci NOT NULL, `servergroup` int(10) NOT NULL, `configoption1` text COLLATE utf8_unicode_ci NOT NULL, `configoption2` text COLLATE utf8_unicode_ci NOT NULL, `configoption3` text COLLATE utf8_unicode_ci NOT NULL, `configoption4` text COLLATE utf8_unicode_ci NOT NULL, `configoption5` text COLLATE utf8_unicode_ci NOT NULL, `configoption6` text COLLATE utf8_unicode_ci NOT NULL, `configoption7` text COLLATE utf8_unicode_ci NOT NULL, `configoption8` text COLLATE utf8_unicode_ci NOT NULL, `configoption9` text COLLATE utf8_unicode_ci NOT NULL, `configoption10` text COLLATE utf8_unicode_ci NOT NULL, `configoption11` text COLLATE utf8_unicode_ci NOT NULL, `configoption12` text COLLATE utf8_unicode_ci NOT NULL, `configoption13` text COLLATE utf8_unicode_ci NOT NULL, `configoption14` text COLLATE utf8_unicode_ci NOT NULL, `configoption15` text COLLATE utf8_unicode_ci NOT NULL, `configoption16` text COLLATE utf8_unicode_ci NOT NULL, `configoption17` text COLLATE utf8_unicode_ci NOT NULL, `configoption18` text COLLATE utf8_unicode_ci NOT NULL, `configoption19` text COLLATE utf8_unicode_ci NOT NULL, `configoption20` text COLLATE utf8_unicode_ci NOT NULL, `configoption21` text COLLATE utf8_unicode_ci NOT NULL, `configoption22` text COLLATE utf8_unicode_ci NOT NULL, `configoption23` text COLLATE utf8_unicode_ci NOT NULL, `configoption24` text COLLATE utf8_unicode_ci NOT NULL, `freedomain` text COLLATE utf8_unicode_ci NOT NULL, `freedomainpaymentterms` text COLLATE utf8_unicode_ci NOT NULL, `freedomaintlds` text COLLATE utf8_unicode_ci NOT NULL, `recurringcycles` int(2) NOT NULL, `autoterminatedays` int(4) NOT NULL, `autoterminateemail` int(10) NOT NULL DEFAULT '0', `configoptionsupgrade` tinyint(1) NOT NULL, `billingcycleupgrade` text COLLATE utf8_unicode_ci NOT NULL, `upgradeemail` int(10) NOT NULL DEFAULT '0', `overagesenabled` varchar(10) COLLATE utf8_unicode_ci NOT NULL, `overagesdisklimit` int(10) NOT NULL, `overagesbwlimit` int(10) NOT NULL, `overagesdiskprice` decimal(6,4) NOT NULL, `overagesbwprice` decimal(6,4) NOT NULL, `tax` tinyint(1) NOT NULL, `affiliateonetime` tinyint(1) NOT NULL, `affiliatepaytype` text COLLATE utf8_unicode_ci NOT NULL, `affiliatepayamount` decimal(16,2) NOT NULL, `order` int(10) NOT NULL DEFAULT '0', `retired` tinyint(1) NOT NULL, `is_featured` tinyint(1) NOT NULL, `color` text COLLATE utf8_unicode_ci NOT NULL, `tagline` text COLLATE utf8_unicode_ci NOT NULL, `short_description` text COLLATE utf8_unicode_ci NOT NULL, `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`), KEY `gid` (`gid`), KEY `name` (`name`(64)), KEY `type` (`type`(4)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;