Server IP : 213.176.29.180 / Your IP : 18.227.134.115 Web Server : Apache System : Linux 213.176.29.180.hostiran.name 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64 User : webtaragh ( 1001) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home/webtaragh/public_html/whmcs/resources/sql/install/ |
[ Home ] | [ C0mmand ] | [ Upload File ] |
---|
/*!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 `tblcontacts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tblcontacts` ( `id` int(10) NOT NULL AUTO_INCREMENT, `userid` int(10) NOT NULL, `firstname` text COLLATE utf8_unicode_ci NOT NULL, `lastname` text COLLATE utf8_unicode_ci NOT NULL, `companyname` text COLLATE utf8_unicode_ci NOT NULL, `email` text COLLATE utf8_unicode_ci NOT NULL, `address1` text COLLATE utf8_unicode_ci NOT NULL, `address2` text COLLATE utf8_unicode_ci NOT NULL, `city` text COLLATE utf8_unicode_ci NOT NULL, `state` text COLLATE utf8_unicode_ci NOT NULL, `postcode` text COLLATE utf8_unicode_ci NOT NULL, `country` text COLLATE utf8_unicode_ci NOT NULL, `phonenumber` text COLLATE utf8_unicode_ci NOT NULL, `tax_id` VARCHAR(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `subaccount` int(1) NOT NULL DEFAULT '0', `password` text COLLATE utf8_unicode_ci NOT NULL, `permissions` text COLLATE utf8_unicode_ci NOT NULL, `domainemails` int(1) NOT NULL, `generalemails` int(1) NOT NULL, `invoiceemails` int(1) NOT NULL, `productemails` int(1) NOT NULL, `supportemails` int(1) NOT NULL, `affiliateemails` int(1) NOT NULL, `pwresetkey` 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', `pwresetexpiry` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`), KEY `userid_firstname_lastname` (`userid`,`firstname`(32),`lastname`(32)), KEY `email` (`email`(64)) ) 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 */;