Da

✏️ Editing: thaiddcc_vatlnwcpubypoy.sql

/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.5.26-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: thaiddcc_vatlnwcpubypoy
-- ------------------------------------------------------
-- Server version	10.5.26-MariaDB-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!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 */;

--
-- Current Database: `thaiddcc_vatlnwcpubypoy`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `thaiddcc_vatlnwcpubypoy` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;

USE `thaiddcc_vatlnwcpubypoy`;

--
-- Table structure for table `biller`
--

DROP TABLE IF EXISTS `biller`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `biller` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fullname` varchar(255) NOT NULL,
  `phone` varchar(30) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `website` varchar(255) NOT NULL DEFAULT '',
  `address` text DEFAULT NULL,
  `address2` text NOT NULL,
  `city` varchar(55) NOT NULL,
  `state` varchar(55) NOT NULL,
  `postal_code` varchar(8) NOT NULL,
  `country` varchar(55) NOT NULL,
  `company` varchar(255) NOT NULL,
  `vat_number` varchar(255) NOT NULL DEFAULT '',
  `user_id` int(11) unsigned DEFAULT NULL,
  `custom_field1` varchar(255) DEFAULT NULL,
  `custom_field2` varchar(255) DEFAULT NULL,
  `custom_field3` varchar(255) DEFAULT NULL,
  `custom_field4` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `biller_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `biller`
--

LOCK TABLES `biller` WRITE;
/*!40000 ALTER TABLE `biller` DISABLE KEYS */;
/*!40000 ALTER TABLE `biller` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `calendar`
--

DROP TABLE IF EXISTS `calendar`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `calendar` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date DEFAULT NULL,
  `repeat_type` int(5) NOT NULL,
  `repeat_days` varchar(50) DEFAULT NULL,
  `no_end` tinyint(1) DEFAULT NULL,
  `emails` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `additional_content` text NOT NULL,
  `attachments` text NOT NULL,
  `last_send` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `calendar`
--

LOCK TABLES `calendar` WRITE;
/*!40000 ALTER TABLE `calendar` DISABLE KEYS */;
/*!40000 ALTER TABLE `calendar` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `chat_attempts`
--

DROP TABLE IF EXISTS `chat_attempts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chat_attempts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned NOT NULL,
  `time` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `chat_attempts_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `chat_attempts`
--

LOCK TABLES `chat_attempts` WRITE;
/*!40000 ALTER TABLE `chat_attempts` DISABLE KEYS */;
/*!40000 ALTER TABLE `chat_attempts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `chat_messages`
--

DROP TABLE IF EXISTS `chat_messages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chat_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content` text NOT NULL,
  `from` int(11) unsigned NOT NULL,
  `to` int(11) unsigned NOT NULL,
  `read` int(1) NOT NULL DEFAULT 0,
  `date` datetime NOT NULL,
  `date_read` datetime DEFAULT NULL,
  `offline` int(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `to` (`to`),
  KEY `from` (`from`),
  CONSTRAINT `chat_messages_ibfk_1` FOREIGN KEY (`from`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `chat_messages_ibfk_2` FOREIGN KEY (`to`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `chat_messages`
--

LOCK TABLES `chat_messages` WRITE;
/*!40000 ALTER TABLE `chat_messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `chat_messages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ci_sessions`
--

DROP TABLE IF EXISTS `ci_sessions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ci_sessions` (
  `id` varchar(40) NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `timestamp` int(10) unsigned NOT NULL DEFAULT 0,
  `data` blob NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ci_sessions_timestamp` (`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ci_sessions`
--

LOCK TABLES `ci_sessions` WRITE;
/*!40000 ALTER TABLE `ci_sessions` DISABLE KEYS */;
INSERT INTO `ci_sessions` VALUES ('028072a6o22lgl7n5brsjb321j5tf971','18.246.254.186',1728374054,'__ci_last_regenerate|i:1728374054;lang|s:7:\"english\";'),('0kdkga0r4pgt7nc04lq7ngroo3sqi7ag','223.204.204.133',1718007668,'__ci_last_regenerate|i:1718007668;lang|s:7:\"english\";message|s:96:\"For the safety of program please delete the installation file \"install.php\" from the main folder\";__ci_vars|a:2:{s:7:\"message\";s:3:\"old\";s:15:\"success_message\";s:3:\"old\";}identity|s:8:\"adminpot\";username|s:8:\"adminpot\";email|s:15:\"admin@admin.com\";user_id|s:1:\"1\";old_last_login|s:10:\"1483117005\";first_name|s:5:\"Admin\";last_name|s:8:\"istrator\";success_message|s:44:\"The company settings is updated successfully\";'),('18ha5l64e4lt2iv5id99bbkbmsbv066v','35.84.183.237',1731488515,'__ci_last_regenerate|i:1731488514;lang|s:7:\"english\";'),('1m0ob4uc1h207tnr490efb8be9fkl877','35.80.6.66',1721133089,'__ci_last_regenerate|i:1721133088;lang|s:7:\"english\";'),('6v3aguqt9hlm6hdnaj2goefsc4v5o1qb','223.204.204.133',1718343185,'__ci_last_regenerate|i:1718343185;lang|s:7:\"english\";identity|s:8:\"adminpot\";username|s:8:\"adminpot\";email|s:15:\"admin@admin.com\";user_id|s:1:\"1\";old_last_login|s:10:\"1718002798\";first_name|s:5:\"Admin\";last_name|s:8:\"istrator\";success_message|s:53:\"The invoice template settings is updated successfully\";__ci_vars|a:1:{s:15:\"success_message\";s:3:\"old\";}'),('75sq4ue5941aekmomb19eor2scqhkg20','223.204.204.133',1718003122,'__ci_last_regenerate|i:1718003122;lang|s:7:\"english\";message|s:96:\"For the safety of program please delete the installation file \"install.php\" from the main folder\";__ci_vars|a:2:{s:7:\"message\";s:3:\"old\";s:15:\"success_message\";s:3:\"old\";}identity|s:8:\"adminpot\";username|s:8:\"adminpot\";email|s:15:\"admin@admin.com\";user_id|s:1:\"1\";old_last_login|s:10:\"1483117005\";first_name|s:5:\"Admin\";last_name|s:8:\"istrator\";success_message|s:29:\"Logged In Successfully\";'),('841tsv9gpsi95t2kpuddlpsvrfh0gca0','18.202.30.54',1718342776,'__ci_last_regenerate|i:1718342770;lang|s:7:\"english\";'),('a2dl0gu8api6d6n72gn251iidtu6ff22','34.245.223.70',1719422618,'__ci_last_regenerate|i:1719422615;lang|s:7:\"english\";'),('aqar2q2gu9fld4hdlud1ul6v06lh5c0c','54.74.202.187',1720770519,'__ci_last_regenerate|i:1720770517;lang|s:7:\"english\";'),('ar7ag84t1lbqi9g1338oabs6tpp827cs','223.204.204.133',1718344816,'__ci_last_regenerate|i:1718344816;lang|s:8:\"thailand\";identity|s:8:\"adminpot\";username|s:8:\"adminpot\";email|s:15:\"admin@admin.com\";user_id|s:1:\"1\";old_last_login|s:10:\"1718002798\";first_name|s:5:\"Admin\";last_name|s:8:\"istrator\";success_message|s:32:\"Language is changed successfully\";__ci_vars|a:1:{s:15:\"success_message\";s:3:\"old\";}'),('e4vf81b20o7ltcgsib6fk4i2h9hi1bib','51.81.46.212',1732677115,'__ci_last_regenerate|i:1732677114;lang|s:7:\"english\";'),('iimtcd9ee8j8k0c6r2acvaomthb5fd31','44.238.100.94',1726135981,'__ci_last_regenerate|i:1726135981;lang|s:7:\"english\";'),('jsau15vso96bfekbvf1fog2tf20q20s7','223.204.204.133',1718345626,'__ci_last_regenerate|i:1718345626;lang|s:8:\"thailand\";identity|s:8:\"adminpot\";username|s:8:\"adminpot\";email|s:15:\"admin@admin.com\";user_id|s:1:\"1\";old_last_login|s:10:\"1718002798\";first_name|s:5:\"Admin\";last_name|s:8:\"istrator\";success_message|s:32:\"Language is changed successfully\";__ci_vars|a:1:{s:15:\"success_message\";s:3:\"old\";}'),('kem32codgvnbqfa412vkoqi0jifu8ol8','223.204.204.133',1718007166,'__ci_last_regenerate|i:1718007166;lang|s:7:\"english\";message|s:96:\"For the safety of program please delete the installation file \"install.php\" from the main folder\";__ci_vars|a:2:{s:7:\"message\";s:3:\"old\";s:15:\"success_message\";s:3:\"old\";}identity|s:8:\"adminpot\";username|s:8:\"adminpot\";email|s:15:\"admin@admin.com\";user_id|s:1:\"1\";old_last_login|s:10:\"1483117005\";first_name|s:5:\"Admin\";last_name|s:8:\"istrator\";success_message|s:44:\"The company settings is updated successfully\";'),('mefvn3k89d7qqb1pn5u6im9d0ddstcg3','223.204.204.133',1718041737,'__ci_last_regenerate|i:1718007668;lang|s:7:\"english\";message|s:96:\"For the safety of program please delete the installation file \"install.php\" from the main folder\";__ci_vars|a:2:{s:7:\"message\";s:3:\"old\";s:15:\"success_message\";s:3:\"old\";}identity|s:8:\"adminpot\";username|s:8:\"adminpot\";email|s:15:\"admin@admin.com\";user_id|s:1:\"1\";old_last_login|s:10:\"1483117005\";first_name|s:5:\"Admin\";last_name|s:8:\"istrator\";success_message|s:44:\"The general settings is updated successfully\";'),('nnppufb0657u37u5t6b58n04nq90r6a4','223.204.204.133',1718357258,'__ci_last_regenerate|i:1718345626;lang|s:8:\"thailand\";identity|s:8:\"adminpot\";username|s:8:\"adminpot\";email|s:15:\"admin@admin.com\";user_id|s:1:\"1\";old_last_login|s:10:\"1718002798\";first_name|s:5:\"Admin\";last_name|s:8:\"istrator\";success_message|s:32:\"Language is changed successfully\";__ci_vars|a:1:{s:15:\"success_message\";s:3:\"old\";}'),('ntsume4fvqmmh3mbiakme980u4qv359e','223.204.204.133',1718343713,'__ci_last_regenerate|i:1718343713;lang|s:7:\"english\";identity|s:8:\"adminpot\";username|s:8:\"adminpot\";email|s:15:\"admin@admin.com\";user_id|s:1:\"1\";old_last_login|s:10:\"1718002798\";first_name|s:5:\"Admin\";last_name|s:8:\"istrator\";success_message|s:44:\"The general settings is updated successfully\";__ci_vars|a:1:{s:15:\"success_message\";s:3:\"old\";}'),('pjv4tldtj0s1nv6q4gjrk4duf2q6iptr','51.81.46.212',1732677116,'__ci_last_regenerate|i:1732677116;lang|s:7:\"english\";'),('pt2vc21s2qukl48p4g7jfpf9dg85ctmi','135.148.100.196',1731424277,'__ci_last_regenerate|i:1731424277;lang|s:7:\"english\";'),('qombcjrt5mj03hao9hjbekpbjrl75meh','223.204.204.133',1718344496,'__ci_last_regenerate|i:1718344496;lang|s:7:\"english\";identity|s:8:\"adminpot\";username|s:8:\"adminpot\";email|s:15:\"admin@admin.com\";user_id|s:1:\"1\";old_last_login|s:10:\"1718002798\";first_name|s:5:\"Admin\";last_name|s:8:\"istrator\";success_message|s:44:\"The general settings is updated successfully\";__ci_vars|a:1:{s:15:\"success_message\";s:3:\"old\";}'),('rl0fbp44ldmr70d5okk20tibj1jbbpmp','135.148.100.196',1731424276,'__ci_last_regenerate|i:1731424275;lang|s:7:\"english\";'),('t494m6vmb0ss5gtpb40l3ol0tq5qgdnr','223.204.204.133',1718345126,'__ci_last_regenerate|i:1718345126;lang|s:8:\"thailand\";identity|s:8:\"adminpot\";username|s:8:\"adminpot\";email|s:15:\"admin@admin.com\";user_id|s:1:\"1\";old_last_login|s:10:\"1718002798\";first_name|s:5:\"Admin\";last_name|s:8:\"istrator\";success_message|s:32:\"Language is changed successfully\";__ci_vars|a:1:{s:15:\"success_message\";s:3:\"old\";}'),('vk5l0304g82l714gqeumbper6dmgt840','223.204.204.133',1718003460,'__ci_last_regenerate|i:1718003460;lang|s:7:\"english\";message|s:96:\"For the safety of program please delete the installation file \"install.php\" from the main folder\";__ci_vars|a:2:{s:7:\"message\";s:3:\"old\";s:15:\"success_message\";s:3:\"old\";}identity|s:8:\"adminpot\";username|s:8:\"adminpot\";email|s:15:\"admin@admin.com\";user_id|s:1:\"1\";old_last_login|s:10:\"1483117005\";first_name|s:5:\"Admin\";last_name|s:8:\"istrator\";success_message|s:53:\"The invoice template settings is updated successfully\";');
/*!40000 ALTER TABLE `ci_sessions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `contracts`
--

DROP TABLE IF EXISTS `contracts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `contracts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subject` varchar(255) NOT NULL,
  `biller_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `date_due` date DEFAULT NULL,
  `type` varchar(255) NOT NULL,
  `amount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `currency` varchar(10) NOT NULL DEFAULT 'USD',
  `description` text NOT NULL,
  `reference` varchar(20) NOT NULL,
  `count` int(11) NOT NULL DEFAULT 0,
  `attachments` text NOT NULL,
  `user_id` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `biller_id` (`biller_id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `contracts_ibfk_1` FOREIGN KEY (`biller_id`) REFERENCES `biller` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `contracts_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `contracts`
--

LOCK TABLES `contracts` WRITE;
/*!40000 ALTER TABLE `contracts` DISABLE KEYS */;
/*!40000 ALTER TABLE `contracts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `email_templates`
--

DROP TABLE IF EXISTS `email_templates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `email_templates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `language` varchar(50) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `data` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `email_templates`
--

LOCK TABLES `email_templates` WRITE;
/*!40000 ALTER TABLE `email_templates` DISABLE KEYS */;
INSERT INTO `email_templates` VALUES (1,'send_invoices_to_customer.tpl','english','Invoice PDF from {{company_name}}','Greetings ! You have received an invoice from {{company_name}}. A PDF file is attached.','invoice|customer|company'),(2,'send_invoices_to_customer.tpl','french','Facture PDF de {{company_name}}','Salutations ! Vous avez reçu une facture de {{company_name}}. Un fichier PDF est attaché.','invoice|customer|company'),(3,'send_invoices_to_customer.tpl','spanish','Factura PDF de {{company_name}}','Saludos ! Ha recibido una factura de {{company_name}}. Se adjunta un archivo PDF.','invoice|customer|company'),(4,'send_invoices_to_customer.tpl','turkish','dan fatura paketi {{company_name}}','Selamlar ! adresinden bir fatura aldınız {{company_name}}. Bir PDF dosyası eklenmiştir.','invoice|customer|company'),(5,'send_invoices_to_customer.tpl','russian','Счёт-фактура из {{company_name}}','Приветствую! Вы получили счет-фактуру {{company_name}}. Файл PDF прилагается.','invoice|customer|company'),(6,'send_invoices_to_customer.tpl','romanian','Factura PDF din {{company_name}}','Bună! Ați primit o factură de la {{company_name}}. Un fișier PDF este atașat.','invoice|customer|company'),(7,'send_invoices_to_customer.tpl','german','Rechnung PDF ab {{company_name}}','Grüße! Sie haben eine Rechnung erhalten {{company_name}}. Eine PDF-Datei ist beigefügt.','invoice|customer|company'),(8,'send_invoices_to_customer.tpl','italian','Fattura PDF da {{company_name}}','Saluti ! Hai ricevuto una fattura da {{company_name}}. È allegato un file PDF.','invoice|customer|company'),(9,'send_invoices_to_customer.tpl','arabic','فاتورة بي دي أف من {{company_name}}','تحية طيبة ! لقد تلقيت فاتورة من {{company_name}}. ملف PDF مرفق.','invoice|customer|company'),(19,'send_estimates_to_customer.tpl','english','Estimate PDF from {{company_name}}','Greetings ! You have received an estimate from {{company_name}}. A PDF file is attached.','estimate|customer|company'),(20,'send_estimates_to_customer.tpl','french','Estimation PDF de{{company_name}}','Salutations! Vous avez reçu une estimation de {{company_name}} . Un fichier PDF est joint.','estimate|customer|company'),(21,'send_estimates_to_customer.tpl','spanish','Calcule el PDF de{{company_name}}','Saludos ! Ha recibido una estimación de {{company_name}} . Se adjunta un archivo PDF.','estimate|customer|company'),(22,'send_estimates_to_customer.tpl','turkish','&#39;den PDF tahmin edin','Selamlar ! tarafından bir tahmin aldınız. Bir PDF dosyası eklenmiştir.','estimate|customer|company'),(23,'send_estimates_to_customer.tpl','russian','Оценка PDF из{{company_name}}','Приветствую ! Вы получили оценку от {{company_name}} . Файл PDF прилагается.','estimate|customer|company'),(24,'send_estimates_to_customer.tpl','romanian','Proformă PDF din {{company_name}}','Bună ! Ați primit o proformă de la {{company_name}} . Un fișier PDF este atașat.','estimate|customer|company'),(25,'send_estimates_to_customer.tpl','german','Schätzen Sie PDF aus {{company_name}} ','Grüße! Sie haben eine Schätzung erhalten {{company_name}} . Eine PDF-Datei ist beigefügt.','estimate|customer|company'),(26,'send_estimates_to_customer.tpl','italian','Stima PDF da {{company_name}} ','Saluti ! Hai ricevuto una stima da {{company_name}} . È allegato un file PDF.','estimate|customer|company'),(27,'send_estimates_to_customer.tpl','arabic','ملف تقدير PDF من {{company_name}}','تحية طيبة ! لقد تلقيت تقديرا من {{company_name}} . يتم إرفاق ملف PDF .','estimate|customer|company'),(37,'send_contracts_to_customer.tpl','english','Contract PDF from {{company_name}}','Greetings ! You have received an contract from {{company_name}}. A PDF file is attached.','contract|customer|company'),(38,'send_contracts_to_customer.tpl','french','Contrat PDF à partir de {{company_name}} ','Salutations ! Vous avez reçu un contrat de {{company_name}} . Un fichier PDF est joint.','contract|customer|company'),(39,'send_contracts_to_customer.tpl','spanish','Contrato PDF de {{company_name}} ','Saludos ! Ha recibido un contrato de {{company_name}} . Se adjunta un archivo PDF.','contract|customer|company'),(40,'send_contracts_to_customer.tpl','turkish','Şuradan sözleşme PDF&#39;si {{company_name}} ','Selamlar ! Şuradan bir sözleşme aldınız: {{company_name}} . Bir PDF dosyası eklenmiştir.','contract|customer|company'),(41,'send_contracts_to_customer.tpl','russian','Договор PDF от {{company_name}} ','Приветствую ! Вы получили контракт от {{company_name}} , Файл PDF прилагается.','contract|customer|company'),(42,'send_contracts_to_customer.tpl','romanian','Contract PDF la {{company_name}}','Salutari ! Ați primit un contract de la {{company_name}} . Un fișier PDF este atașat.','contract|customer|company'),(43,'send_contracts_to_customer.tpl','german','Vertrag PDF ab {{company_name}} ','Grüße! Sie haben einen Vertrag von {{company_name}} . Eine PDF-Datei ist angehängt.','contract|customer|company'),(44,'send_contracts_to_customer.tpl','italian','Contratto PDF da {{company_name}} ','Saluti ! Hai ricevuto un contratto da {{company_name}} . È allegato un file PDF.','contract|customer|company'),(45,'send_contracts_to_customer.tpl','arabic','Pdf العقد من {{company_name}} ','تحية طيبة ! لقد تلقيت عقدا من {{company_name}} . يتم إرفاق ملف بدف.','contract|customer|company'),(46,'send_receipts_to_customer.tpl','english','Payment PDF from {{company_name}}','Greetings ! You have received an payment from {{company_name}}. A PDF file is attached.','receipt|customer|company'),(47,'send_receipts_to_customer.tpl','french','Paiement PDF de{{company_name}}','Salutations! Vous avez reçu un paiement de {{company_name}} . Un fichier PDF est joint.','receipt|customer|company'),(48,'send_receipts_to_customer.tpl','spanish','Pago PDF de{{company_name}}','Saludos ! Ha recibido un pago de {{company_name}} . Se adjunta un archivo PDF.','receipt|customer|company'),(49,'send_receipts_to_customer.tpl','turkish','Ödeme{{company_name}}&#39;den PDF','Selamlar ! /b> S&#39;dan bir ödeme aldınız. Bir PDF dosyası eklenmiştir.','receipt|customer|company'),(50,'send_receipts_to_customer.tpl','russian','Оплата PDF из{{company_name}}','Приветствую ! Вы получили платеж от {{company_name}} . Файл PDF прилагается.','receipt|customer|company'),(51,'send_receipts_to_customer.tpl','romanian','Plata PDF din{{company_name}}','Bună! Ați primit o plată de la {{company_name}} . Un fișier PDF este atașat.','receipt|customer|company'),(52,'send_receipts_to_customer.tpl','german','Zahlung PDF ab {{company_name}} ','Grüße! Sie haben eine Zahlung erhalten von {{company_name}} . Eine PDF-Datei ist beigefügt.','receipt|customer|company'),(53,'send_receipts_to_customer.tpl','italian','Pagamento PDF da {{company_name}} ','Saluti ! Hai ricevuto un pagamento da {{company_name}} . È allegato un file PDF.','receipt|customer|company'),(54,'send_receipts_to_customer.tpl','arabic','ملف PDF من {{company_name}}','تحية طيبة ! لقد تلقيت دفعة من {{company_name}} . يتم إرفاق ملف PDF .','receipt|customer|company'),(64,'send_rinvoices_to_customer.tpl','english','New Invoice from {{company_name}}','Greetings ! You have received an new unpaid invoice from {{company_name}}. <a href=\"{{invoice_link}}\" target=\"_blank\">Open</a>','invoice|customer|company'),(65,'send_rinvoices_to_customer.tpl','french','Nouvelle facture de {{company_name}} ','Salutations ! Vous avez reçu une nouvelle facture impayée de {{company_name}} . <a href=\"{{invoice_link}}\" target=\"_blank\">Ouvrir</a>','invoice|customer|company'),(66,'send_rinvoices_to_customer.tpl','spanish','Nueva factura de {{company_name}} ','Saludos ! Ha recibido una nueva factura no pagada de {{company_name}} . <a href=\"{{invoice_link}}\" target=\"_blank\">Abierto</a>','invoice|customer|company'),(67,'send_rinvoices_to_customer.tpl','turkish','Şuradan yeni fatura {{company_name}} ','Selamlar ! Şuradan yeni bir ödenmemiş fatura aldınız: {{company_name}} . <a href=\"{{invoice_link}}\" target=\"_blank\">Açık</a>','invoice|customer|company'),(68,'send_rinvoices_to_customer.tpl','russian','Новый счет-фактура {{company_name}} ','Приветствую! Вы получили новый неоплаченный счет {{company_name}} , <a href=\"{{invoice_link}}\" target=\"_blank\">открыто</a>','invoice|customer|company'),(69,'send_rinvoices_to_customer.tpl','romanian','Factura nouă de la {{company_name}}','Bună! Ați primit o nouă factură neachitată de la {{company_name}}. <a href=\"{{invoice_link}}\" target=\"_blank\">Deschis</a>','invoice|customer|company'),(70,'send_rinvoices_to_customer.tpl','german','Neue Rechnung ab {{company_name}} ','Grüße! Sie haben eine neue, unbezahlte Rechnung erhalten {{company_name}} . <a href=\"{{invoice_link}}\" target=\"_blank\">Öffnen</a>','invoice|customer|company'),(71,'send_rinvoices_to_customer.tpl','italian','Nuova fattura da {{company_name}} ','Saluti ! Hai ricevuto una nuova fattura non pagata da {{company_name}} . <a href=\"{{invoice_link}}\" target=\"_blank\">Aperto</a>','invoice|customer|company'),(72,'send_rinvoices_to_customer.tpl','arabic','فاتورة جديدة من {{company_name}} ','تحية طيبة ! لقد تلقيت فاتورة جديدة غير مدفوعة من {{company_name}} . <a href=\"{{invoice_link}}\" target=\"_blank\">فتح</a>','invoice|customer|company'),(73,'send_customer_reminder.tpl','english','You have unpaid invoices from {{company_name}}','Dear {{customer_fullname}}, You have {{count_invoices}} unpaid invoices. {{invoices_table}} <a href=\"https://vat.lnwcpu.com/index.php/invoices\" target=\"_blank\">Invoices</a>','invoice_reminder|customer|company'),(74,'send_customer_reminder.tpl','french','Vous avez des factures impayées de {{company_name}} ','cher {{customer_fullname}} , Tu as {{count_invoices}} factures impayées. {{invoices_table}} <a href=\"https://vat.lnwcpu.com/index.php/invoices\" target=\"_blank\">Factures</a>','invoice_reminder|customer|company'),(75,'send_customer_reminder.tpl','spanish','Tiene facturas pendientes de pago de {{company_name}} ','querido {{customer_fullname}} , Tienes {{count_invoices}} facturas pendientes de pago. {{invoices_table}} <a href=\"https://vat.lnwcpu.com/index.php/invoices\" target=\"_blank\">Facturas</a>','invoice_reminder|customer|company'),(76,'send_customer_reminder.tpl','turkish','Gönderdiğiniz ödenmemiş faturanız var {{company_name}} ','Sayın {{customer_fullname}} , Var {{count_invoices}} ödenmemiş faturalar. {{invoices_table}} <a href=\"https://vat.lnwcpu.com/index.php/invoices\" target=\"_blank\">Faturalar</a>','invoice_reminder|customer|company'),(77,'send_customer_reminder.tpl','russian','У вас есть неоплаченные счета-фактуры {{company_name}} ','Уважаемые {{customer_fullname}} , You have {{count_invoices}} unpaid invoices. {{invoices_table}} <a href=\"https://vat.lnwcpu.com/index.php/invoices\" target=\"_blank\">Счета-фактуры</a>','invoice_reminder|customer|company'),(78,'send_customer_reminder.tpl','romanian','Aveți facturi neachitate de la {{company_name}}','Bună {{customer_fullname}}, Aveți {{count_invoices}} facturi neachitate. {{invoices_table}} <a href=\"https://vat.lnwcpu.com/index.php/invoices\" target=\"_blank\">Facturi</a>','invoice_reminder|customer|company'),(79,'send_customer_reminder.tpl','german','Sie haben unbezahlte Rechnungen aus {{company_name}} ','sehr geehrter {{customer_fullname}} , Du hast {{count_invoices}} unbezahlte Rechnungen. {{invoices_table}} <a href=\"https://vat.lnwcpu.com/index.php/invoices\" target=\"_blank\">Rechnungen</a>','invoice_reminder|customer|company'),(80,'send_customer_reminder.tpl','italian','Hai fatture non pagate da {{company_name}} ','caro {{customer_fullname}} , Hai {{count_invoices}} fatture non pagate. {{invoices_table}} <a href=\"https://vat.lnwcpu.com/index.php/invoices\" target=\"_blank\">Fatture</a>','invoice_reminder|customer|company'),(81,'send_customer_reminder.tpl','arabic','لديك فواتير غير مدفوعة م','العزيز {{customer_fullname}} ، عندك {{count_invoices}} فواتير غير مدفوعة. {{invoices_table}} <a href=\"https://vat.lnwcpu.com/index.php/invoices\" target=\"_blank\">الفواتير</a>','invoice_reminder|customer|company'),(82,'send_overdue_reminder.tpl','english','You have unpaid invoices from {{company_name}}','Dear {{customer_fullname}}, You might have missed the payment date and the invoice is now overdue by {{invoice_overdue_days}} days. <table width=\'100%\'><tr><td>Reference : </td><th>{{invoice_reference}}</th></tr><tr><td>Date : </td><th>{{invoice_date}}</th></tr><tr><td>Due Date : </td><th>{{invoice_date_due}}</th></tr><tr><td>Total : </td><th>{{invoice_total}}</th></tr><tr><td>Payments : </td><th>{{invoice_total_payments}}</th></tr><tr><td>Total Due : </td><th>{{invoice_total_due}}</th></tr></table> <a href=\"{{invoice_link}}\" target=\"_blank\">Invoice</a>','invoice|customer|company'),(83,'send_overdue_reminder.tpl','french','Vous avez des factures impayées de {{company_name}} ','cher {{customer_fullname}} , Vous avez peut-être manqué la date de paiement et la facture est maintenant en retard {{invoice_overdue_days}} journées. <table width=\'100%\'><tr><td>Référence : </td><th>{{invoice_reference}}</th></tr><tr><td>Date : </td><th>{{invoice_date}}</th></tr><tr><td>Date d&#39;échéance : </td><th>{{invoice_date_due}}</th></tr><tr><td>Total : </td><th>{{invoice_total}}</th></tr><tr><td>Paiements : </td><th>{{invoice_total_payments}}</th></tr><tr><td>Total dû : </td><th>{{invoice_total_due}}</th></tr></table> <a href=\"{{invoice_link}}\" target=\"_blank\">Facture</a>','invoice|customer|company'),(84,'send_overdue_reminder.tpl','spanish','Tiene facturas pendientes de pago de {{company_name}} ','querido {{customer_fullname}} , Es posible que haya perdido la fecha de pago y la factura esté atrasada por {{invoice_overdue_days}} días. <table width=\'100%\'><tr><td>Referencia : </td><th>{{invoice_reference}}</th></tr><tr><td>Fecha : </td><th>{{invoice_date}}</th></tr><tr><td>Fecha de vencimiento : </td><th>{{invoice_date_due}}</th></tr><tr><td>Total : </td><th>{{invoice_total}}</th></tr><tr><td>Pagos : </td><th>{{invoice_total_payments}}</th></tr><tr><td>Total debido : </td><th>{{invoice_total_due}}</th></tr></table> <a href=\"{{invoice_link}}\" target=\"_blank\">Factura</a>','invoice|customer|company'),(85,'send_overdue_reminder.tpl','turkish','Gönderdiğiniz ödenmemiş faturanız var {{company_name}} ','Sayın {{customer_fullname}} , Ödeme tarihini kaçırmış olabilirsiniz ve fatura şimdi tarafından gecikmiştir. {{invoice_overdue_days}} günler. <table width=\'100%\'><tr><td>Referans : </td><th>{{invoice_reference}}</th></tr><tr><td>tarih : </td><th>{{invoice_date}}</th></tr><tr><td>Bitiş tarihi : </td><th>{{invoice_date_due}}</th></tr><tr><td>Genel Toplam : </td><th>{{invoice_total}}</th></tr><tr><td>Ödemeler : </td><th>{{invoice_total_payments}}</th></tr><tr><td>Vadesi gereken toplam : </td><th>{{invoice_total_due}}</th></tr></table> <a href=\"{{invoice_link}}\" target=\"_blank\">Fatura</a>','invoice|customer|company'),(86,'send_overdue_reminder.tpl','russian','У вас есть неоплаченные счета-фактуры {{company_name}} ','Уважаемые {{customer_fullname}} , Возможно, вы пропустили дату платежа, и счет теперь просрочен {{invoice_overdue_days}} дней. <table width=\'100%\'><tr><td>Справка : </td><th>{{invoice_reference}}</th></tr><tr><td>Дата : </td><th>{{invoice_date}}</th></tr><tr><td>Срок : </td><th>{{invoice_date_due}}</th></tr><tr><td>Всего : </td><th>{{invoice_total}}</th></tr><tr><td>платежи : </td><th>{{invoice_total_payments}}</th></tr><tr><td>Общая сумма : </td><th>{{invoice_total_due}}</th></tr></table> <a href=\"{{invoice_link}}\" target=\"_blank\">Выставленный счет</a>','invoice|customer|company'),(87,'send_overdue_reminder.tpl','romanian','Aveți facturi neachitate de la {{company_name}}','Bună {{customer_fullname}}, S-ar putea să fi întarziat data de plații, iar factura este acum depășită de {{invoice_overdue_days}} zile <table width=\'100%\'><tr><td>Referinţă : </td><th>{{invoice_reference}}</th></tr><tr><td>Data : </td><th>{{invoice_date}}</th></tr><tr><td>Data scadentă : </td><th>{{invoice_date_due}}</th></tr><tr><td>Total : </td><th>{{invoice_total}}</th></tr><tr><td>Plăţile : </td><th>{{invoice_total_payments}}</th></tr><tr><td>Total datorat : </td><th>{{invoice_total_due}}</th></tr></table> <a href=\"{{invoice_link}}\" target=\"_blank\">Factură</a>','invoice|customer|company'),(88,'send_overdue_reminder.tpl','german','Sie haben unbezahlte Rechnungen aus {{company_name}} ','sehr geehrter {{customer_fullname}} , Vielleicht haben Sie das Zahlungsdatum verpasst und die Rechnung ist jetzt überfällig {{invoice_overdue_days}} Tage. <table width=\'100%\'><tr><td>Referenz : </td><th>{{invoice_reference}}</th></tr><tr><td>Datum : </td><th>{{invoice_date}}</th></tr><tr><td>Geburtstermin : </td><th>{{invoice_date_due}}</th></tr><tr><td>Gesamt : </td><th>{{invoice_total}}</th></tr><tr><td>Zahlungen : </td><th>{{invoice_total_payments}}</th></tr><tr><td>Gesamt fällig : </td><th>{{invoice_total_due}}</th></tr></table> <a href=\"{{invoice_link}}\" target=\"_blank\">Rechnung</a>','invoice|customer|company'),(89,'send_overdue_reminder.tpl','italian','Hai fatture non pagate da {{company_name}} ','caro {{customer_fullname}} , Potresti aver perso la data di pagamento e la fattura è ormai scaduta {{invoice_overdue_days}} giorni. <table width=\'100%\'><tr><td>Riferimento : </td><th>{{invoice_reference}}</th></tr><tr><td>Data : </td><th>{{invoice_date}}</th></tr><tr><td>Scadenza : </td><th>{{invoice_date_due}}</th></tr><tr><td>Totale : </td><th>{{invoice_total}}</th></tr><tr><td>pagamenti : </td><th>{{invoice_total_payments}}</th></tr><tr><td>Totale dovuto : </td><th>{{invoice_total_due}}</th></tr></table> <a href=\"{{invoice_link}}\" target=\"_blank\">Fattura</a>','invoice|customer|company'),(90,'send_overdue_reminder.tpl','arabic','لديك فواتير غير مدفوعة م','العزيز {{customer_fullname}} ، قد تكون قد فاتك تاريخ الدفع إلى الفاتورة متأخرة الآن {{invoice_overdue_days}} أيام. <table width=\'100%\'><tr><td>الرقم المرجعي : </td><th>{{invoice_reference}}</th></tr><tr><td>التاريخ : </td><th>{{invoice_date}}</th></tr><tr><td>تاريخ الاستحقاق : </td><th>{{invoice_date_due}}</th></tr><tr><td>المجموع : </td><th>{{invoice_total}}</th></tr><tr><td>المدفوعات : </td><th>{{invoice_total_payments}}</th></tr><tr><td>الاجمالي المستحق : </td><th>{{invoice_total_due}}</th></tr></table> <a href=\"{{invoice_link}}\" target=\"_blank\">فاتورة</a>','invoice|customer|company'),(91,'send_forgotten_password.tpl','english','Forgotten Password Verification - {{company_name}}','Hi {{user_first_name}}, We have received a request to reset your password. Your username is {{user_username}}. <a href=\"{{user_forgotten_password_code}}\" target=\"_blank\">Reset Password</a>','user|company'),(92,'send_forgotten_password.tpl','french','Vérification du mot de passe oublié - {{company_name}}','Salut {{user_first_name}}, Nous avons reçu une demande pour réinitialiser votre mot de passe.. Votre nom d\'utilisateur est {{user_username}}. <a href=\"{{user_forgotten_password_code}}\" target=\"_blank\">Réinitialiser le mot de passe</a>','user|company'),(93,'send_forgotten_password.tpl','spanish','Verificación de la contraseña olvidada - {{company_name}}','Su, Hemos recibido una solicitud para restablecer su contraseña. Su nombre de usuario es {{user_username}} . <a href=\"{{user_forgotten_password_code}}\" target=\"_blank\">Restablecer la contraseña</a>','user|company'),(94,'send_forgotten_password.tpl','turkish','Unutulan Parola Doğrulaması - {{company_name}}','Merhaba{{user_first_name}}, Şifrenizi sıfırlama talebi aldık. Kullanıcı adınız {{user_username}} . <a href=\"{{user_forgotten_password_code}}\" target=\"_blank\">Şifreyi yenile</a>','user|company'),(95,'send_forgotten_password.tpl','russian','Проверка забытого пароля - {{company_name}}','Его, Мы получили запрос на сброс пароля. Ваше имя пользователя {{user_username}} . <a href=\"{{user_forgotten_password_code}}\" target=\"_blank\">Сброс пароля</a>','user|company'),(96,'send_forgotten_password.tpl','romanian','Verificarea parolei uitată - {{company_name}}','Bună {{user_first_name}}, Am primit o solicitare de resetare a parolei. Numele tău de utilizator este {{user_username}}. <a href=\"{{user_forgotten_password_code}}\" target=\"_blank\">Resetează parola</a>','user|company'),(97,'send_forgotten_password.tpl','german','Passwort vergessen - {{company_name}}','Hallo {{user_first_name}} , Wir haben eine Anfrage erhalten, um Ihr Passwort zurückzusetzen. Dein Benutzername ist {{user_username}} . <a href=\"{{user_forgotten_password_code}}\" target=\"_blank\">Passwort zurücksetzen</a>','user|company'),(98,'send_forgotten_password.tpl','italian','Dimenticata la verifica della password - {{company_name}}','Ciao {{user_first_name}} , Abbiamo ricevuto una richiesta di reimpostazione della password. Il tuo nome utente è {{user_username}} . <a href=\"{{user_forgotten_password_code}}\" target=\"_blank\">Resetta la password</a>','user|company'),(99,'send_forgotten_password.tpl','arabic','التحقق من كلمة المرور المنسية - {{company_name}}','مرحبا {{user_first_name}}, لقد تلقينا طلبا لإعادة تعيين كلمة المرور الخاصة بك. اسم المستخدم الخاص بك هو {{user_username}}. <a href=\"{{user_forgotten_password_code}}\" target=\"_blank\">إعادة تعيين كلمة المرور</a>','user|company'),(100,'send_activate.tpl','english','Account Activation - {{company_name}}','Congratulation ! Hi {{user_username}}, you have successfully registered on the {{company_name}}. To activate your account, please confirm your registration. <a href=\"{{user_activation_code}}\" target=\"_blank\">Confirm registration</a>','user|company'),(101,'send_activate.tpl','french','Activation du compte - {{company_name}}','Félicitation ! Salut {{user_username}}, Vous avez enregistré avec succès sur le {{company_name}}. Pour activer votre compte, veuillez confirmer votre inscription. <a href=\"{{user_activation_code}}\" target=\"_blank\">Confirmer l\'inscription</a>','user|company'),(102,'send_activate.tpl','spanish','activación de cuenta - {{company_name}}','Enhorabuena ! Hola {{user_username}} , has registrado correctamente en el {{company_name}} . Para activar su cuenta, confirme su registro. <a href=\"{{user_activation_code}}\" target=\"_blank\">Confirmar registro</a>','user|company'),(103,'send_activate.tpl','turkish','Hesap Aktivasyonu - {{company_name}}','Tebrikler! Merhaba, {{user_username}} , başarıyla {{company_name}} kayıt yaptın. Hesabınızı etkinleştirmek için lütfen kayıt işleminizi onaylayın. <a href=\"{{user_activation_code}}\" target=\"_blank\">Kaydı onayla</a>','user|company'),(104,'send_activate.tpl','russian','Активация аккаунта - {{company_name}}','Поздравляем! Привет {{user_username}} , вы успешно зарегистрировались на {{company_name}} . Чтобы активировать свою учетную запись, пожалуйста, подтвердите свою регистрацию. <a href=\"{{user_activation_code}}\" target=\"_blank\">Подтверждение регистрации</a>','user|company'),(105,'send_activate.tpl','romanian','Activare cont - {{company_name}}','Felicitari ! Bună {{user_username}}, v-ați înregistrat cu succes pe {{company_name}}. Pentru a vă activa contul, vă rugăm să confirmați înregistrarea. <a href=\"{{user_activation_code}}\" target=\"_blank\">Confirmați înregistrarea</a>','user|company'),(106,'send_activate.tpl','german','Account Aktivierung - {{company_name}}','Herzlichen Glückwunsch! Hallo {{user_username}} Du hast dich erfolgreich registriert <a href=\"{{user_activation_code}}\" target=\"_blank\">Registrierung bestätigen</a>','user|company'),(107,'send_activate.tpl','italian','attivazione dell&#39;account - {{company_name}}','Congratulazioni! Ciao {{user_username}} , sei stato registrato con successo nel sito <a href=\"{{user_activation_code}}\" target=\"_blank\">Conferma la registrazione</a>','user|company'),(108,'send_activate.tpl','arabic','تنشيط الحساب - {{company_name}}','تهنئة ! مرحبا {{user_username}}, لقد سجلت بنجاح على {{company_name}}. لتفعيل حسابك، يرجى تأكيد تسجيلك. <a href=\"{{user_activation_code}}\" target=\"_blank\">تأكيد التسجيل</a>','user|company'),(109,'send_activate_customer.tpl','english','Account Activation - {{company_name}}','Congratulation ! Hi {{user_username}}, you have successfully registered on the {{company_name}}. To activate your account, please confirm your registration. Username :{{user_username}} Password :{{user_password}} <a href=\"{{user_activation_code}}\" target=\"_blank\">Confirm registration</a>','user|company'),(110,'send_activate_customer.tpl','french','Activation du compte - {{company_name}}','Félicitation ! Salut {{user_username}}, Vous avez enregistré avec succès sur le {{company_name}}. Pour activer votre compte, veuillez confirmer votre inscription. Nom d\'utilisateur :{{user_username}} Mot de passe : :{{user_password}} <a href=\"{{user_activation_code}}\" target=\"_blank\">Confirmer l\'inscription</a>','user|company'),(111,'send_activate_customer.tpl','spanish','activación de cuenta - {{company_name}}','Enhorabuena ! Hola {{user_username}} , has registrado correctamente en el {{company_name}} . Para activar su cuenta, confirme su registro. Nombre de usuario :{{user_username}} Contraseña :{{user_password}} <a href=\"{{user_activation_code}}\" target=\"_blank\">Confirmar registro</a>','user|company'),(112,'send_activate_customer.tpl','turkish','Hesap Aktivasyonu - {{company_name}}','Tebrikler! Merhaba, {{user_username}} , başarıyla {{company_name}} kayıt yaptın. Hesabınızı etkinleştirmek için lütfen kayıt işleminizi onaylayın. Kullanıcı adı :{{user_username}} Parola :{{user_password}} <a href=\"{{user_activation_code}}\" target=\"_blank\">Kaydı onayla</a>','user|company'),(113,'send_activate_customer.tpl','russian','Активация аккаунта - {{company_name}}','Поздравляем! Привет {{user_username}} , вы успешно зарегистрировались на {{company_name}} . Чтобы активировать свою учетную запись, пожалуйста, подтвердите свою регистрацию. Имя пользователя :{{user_username}} пароль :{{user_password}} <a href=\"{{user_activation_code}}\" target=\"_blank\">Подтверждение регистрации</a>','user|company'),(114,'send_activate_customer.tpl','romanian','Activare cont - {{company_name}}','Felicitari ! Bună {{user_username}}, v-ați înregistrat cu succes pe {{company_name}}. Pentru a vă activa contul, vă rugăm să confirmați înregistrarea. Nume de utilizator :{{user_username}} Parola :{{user_password}} <a href=\"{{user_activation_code}}\" target=\"_blank\">Confirmați înregistrarea</a>','user|company'),(115,'send_activate_customer.tpl','german','Account Aktivierung - {{company_name}}','Herzlichen Glückwunsch! Hallo {{user_username}} Du hast dich erfolgreich registriert Benutzername :{{user_username}} Passwort :{{user_password}} <a href=\"{{user_activation_code}}\" target=\"_blank\">Registrierung bestätigen</a>','user|company'),(116,'send_activate_customer.tpl','italian','attivazione dell&#39;account - {{company_name}}','Congratulazioni! Ciao {{user_username}} , sei stato registrato con successo nel sito Nome utente :{{user_username}} Parola d&#39;ordine :{{user_password}} <a href=\"{{user_activation_code}}\" target=\"_blank\">Conferma la registrazione</a>','user|company'),(117,'send_activate_customer.tpl','arabic','تنشيط الحساب - {{company_name}}','تهنئة ! مرحبا {{user_username}}, لقد سجلت بنجاح على {{company_name}}. لتفعيل حسابك، يرجى تأكيد تسجيلك. إسم العضوية :{{user_username}} كلمه المرور: :{{user_password}} <a href=\"{{user_activation_code}}\" target=\"_blank\">تأكيد التسجيل</a>','user|company'),(118,'send_file.tpl','english','File from {{company_name}}','','file|company'),(119,'send_file.tpl','french','Fichier de {{company_name}} ','','file|company'),(120,'send_file.tpl','spanish','Archivo de {{company_name}} ','','file|company'),(121,'send_file.tpl','turkish','Dosyasından {{company_name}} ','','file|company'),(122,'send_file.tpl','russian','Файл из {{company_name}} ','','file|company'),(123,'send_file.tpl','romanian','Fișier la {{company_name}}','','file|company'),(124,'send_file.tpl','german','Datei von {{company_name}} ','','file|company'),(125,'send_file.tpl','italian','File da {{company_name}} ','','file|company'),(126,'send_file.tpl','arabic','ملف من {{company_name}} ','','file|company');
/*!40000 ALTER TABLE `email_templates` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `estimates`
--

DROP TABLE IF EXISTS `estimates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `estimates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `reference` varchar(20) NOT NULL,
  `date` date NOT NULL,
  `date_due` date DEFAULT NULL,
  `title` varchar(25) NOT NULL DEFAULT 'Invoice',
  `description` varchar(255) NOT NULL,
  `status` varchar(25) NOT NULL DEFAULT 'Draft',
  `bill_to_id` int(11) DEFAULT NULL,
  `note` text NOT NULL,
  `terms` text NOT NULL,
  `currency` varchar(10) NOT NULL DEFAULT 'USD',
  `discount_type` tinyint(1) NOT NULL DEFAULT 1,
  `subtotal` decimal(25,4) NOT NULL DEFAULT 0.0000,
  `global_discount` decimal(25,4) NOT NULL DEFAULT 0.0000,
  `shipping` decimal(10,2) NOT NULL DEFAULT 0.00,
  `total_discount` decimal(25,4) NOT NULL DEFAULT 0.0000,
  `total_tax` decimal(25,4) NOT NULL DEFAULT 0.0000,
  `total` decimal(25,4) NOT NULL DEFAULT 0.0000,
  `count` int(11) NOT NULL DEFAULT 0,
  `user_id` int(11) unsigned DEFAULT NULL,
  `custom_field1` varchar(255) NOT NULL,
  `custom_field2` varchar(255) NOT NULL,
  `custom_field3` varchar(255) NOT NULL,
  `custom_field4` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `bill_to_id` (`bill_to_id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `estimates_ibfk_1` FOREIGN KEY (`bill_to_id`) REFERENCES `biller` (`id`),
  CONSTRAINT `estimates_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `estimates`
--

LOCK TABLES `estimates` WRITE;
/*!40000 ALTER TABLE `estimates` DISABLE KEYS */;
/*!40000 ALTER TABLE `estimates` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `estimates_items`
--

DROP TABLE IF EXISTS `estimates_items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `estimates_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `estimate_id` int(11) DEFAULT NULL,
  `item_id` int(11) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `quantity` decimal(25,4) NOT NULL DEFAULT 0.0000,
  `unit_price` decimal(25,4) NOT NULL DEFAULT 0.0000,
  `tax_type` tinyint(1) NOT NULL DEFAULT 1,
  `tax` decimal(25,4) NOT NULL DEFAULT 0.0000,
  `discount_type` tinyint(1) NOT NULL DEFAULT 1,
  `discount` decimal(25,4) NOT NULL DEFAULT 0.0000,
  `total` decimal(25,4) NOT NULL DEFAULT 0.0000,
  PRIMARY KEY (`id`),
  KEY `estimates_items_ibfk_1` (`estimate_id`),
  KEY `item_id` (`item_id`),
  CONSTRAINT `estimates_items_ibfk_1` FOREIGN KEY (`estimate_id`) REFERENCES `estimates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `estimates_items_ibfk_2` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`) ON DELETE SET NULL ON UPDATE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `estimates_items`
--

LOCK TABLES `estimates_items` WRITE;
/*!40000 ALTER TABLE `estimates_items` DISABLE KEYS */;
/*!40000 ALTER TABLE `estimates_items` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `estimates_taxes`
--

DROP TABLE IF EXISTS `estimates_taxes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `estimates_taxes` (
  `estimate_id` int(11) NOT NULL,
  `tax_rate_id` int(11) DEFAULT NULL,
  `label` varchar(255) NOT NULL,
  `value` decimal(10,2) NOT NULL,
  `type` tinyint(1) NOT NULL,
  `is_conditional` tinyint(1) NOT NULL DEFAULT 0,
  KEY `estimate_id` (`estimate_id`),
  KEY `tax_rate_id` (`tax_rate_id`),
  CONSTRAINT `estimates_taxes_ibfk_1` FOREIGN KEY (`estimate_id`) REFERENCES `estimates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `estimates_taxes_ibfk_2` FOREIGN KEY (`tax_rate_id`) REFERENCES `tax_rates` (`id`) ON DELETE SET NULL ON UPDATE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `estimates_taxes`
--

LOCK TABLES `estimates_taxes` WRITE;
/*!40000 ALTER TABLE `estimates_taxes` DISABLE KEYS */;
/*!40000 ALTER TABLE `estimates_taxes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `expenses`
--

DROP TABLE IF EXISTS `expenses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `expenses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `number` int(11) NOT NULL,
  `reference` varchar(50) DEFAULT NULL,
  `category` varchar(255) NOT NULL,
  `date` date NOT NULL,
  `date_due` date DEFAULT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'unpaid',
  `amount` decimal(25,4) NOT NULL DEFAULT 0.0000,
  `tax_id` int(11) DEFAULT NULL,
  `tax_type` tinyint(1) NOT NULL DEFAULT 0,
  `tax_value` decimal(25,4) NOT NULL DEFAULT 0.0000,
  `tax_total` decimal(25,4) NOT NULL DEFAULT 0.0000,
  `total` decimal(25,4) NOT NULL DEFAULT 0.0000,
  `total_due` decimal(25,4) NOT NULL DEFAULT 0.0000,
  `payment_method` varchar(255) NOT NULL,
  `payment_date` date DEFAULT NULL,
  `details` text NOT NULL,
  `attachments` text NOT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `currency` varchar(10) NOT NULL DEFAULT 'USD',
  `user_id` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `expenses_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `expenses`
--

LOCK TABLES `expenses` WRITE;
/*!40000 ALTER TABLE `expenses` DISABLE KEYS */;
/*!40000 ALTER TABLE `expenses` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `expenses_categories`
--

DROP TABLE IF EXISTS `expenses_categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `expenses_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(255) NOT NULL,
  `label` varchar(255) NOT NULL,
  `is_default` int(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `expenses_categories`
--

LOCK TABLES `expenses_categories` WRITE;
/*!40000 ALTER TABLE `expenses_categories` DISABLE KEYS */;
INSERT INTO `expenses_categories` VALUES (1,'Utilities','Electricity',1),(2,'Utilities','Gas',0),(3,'Utilities','Water',0),(4,'Utilities','Phone',0),(5,'Utilities','Internet',0),(6,'Utilities','Other utilities',0),(7,'Supplies','Stationery',0),(8,'Supplies','Other consumables',0),(9,'Maintenance and repair','Repair and maintenance of headquarters',0),(10,'Maintenance and repair','Equipment repairs',0),(11,'Maintenance and repair','Other',0),(12,'Services','Accountancy',0),(13,'Services','Legally',0),(14,'Services','Consulting',0),(15,'Services','Fees',0),(16,'Services','Online service subscriptions',0),(17,'Services','Transport',0),(18,'Services','Other services',0),(19,'Services','Courier',0),(20,'Rents','Rental of buildings',0),(21,'Rents','Car leasing',0),(22,'Rents','Equipment rental',0),(23,'Rents','Other rents',0),(24,'Auto','Fuels',0),(25,'Auto','Auto parts',0),(26,'Auto','Car maintenance materials',0),(27,'Auto','Car repair services',0),(28,'Auto','Other',0),(29,'HR','Wages',0),(30,'HR','Tickets',0),(31,'HR','Salary contributions',0),(32,'HR','Other',0),(33,'Insurance','Insurance and social protection',0),(34,'Insurance','Life insurance',0),(35,'Insurance','Private pension',0),(36,'Insurance','RCA',0),(37,'Insurance','Casco',0),(38,'Insurance','Other insurance',0),(39,'Taxes','VAT',0),(40,'Taxes','Tax',0),(41,'Taxes','Bank fees',0),(42,'Taxes','Building tax',0),(43,'Taxes','Key maps',0),(44,'Taxes','Fines',0),(45,'Taxes','Other taxes',0),(46,'Advertisement','Commercials',0),(47,'Advertisement','Promotional materials',0),(48,'Advertisement','Announcements',0),(49,'Advertisement','Online ads',0),(50,'Advertisement','Other',0),(51,'Protocol','Organized tables',0),(52,'Protocol','Gifts',0),(53,'Protocol','Gifts',0),(54,'Protocol','Other protocol expenses',0),(55,'Inventory items','Telephones',0),(56,'Inventory items','Furniture',0),(57,'Inventory items','IT equipment',0),(58,'Inventory items','Other inventory items',0),(59,'Fixed assets','Buildings',0),(60,'Fixed assets','Lands',0),(61,'Fixed assets','Machinery',0),(62,'Fixed assets','Other fixed assets',0),(63,'Other expenses','Reparation',0),(64,'Other expenses','Raw materials',0),(65,'Other expenses','Other raw materials',0);
/*!40000 ALTER TABLE `expenses_categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `expenses_payments`
--

DROP TABLE IF EXISTS `expenses_payments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `expenses_payments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `expense_id` int(11) NOT NULL,
  `number` int(11) NOT NULL,
  `date` date NOT NULL,
  `amount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `method` varchar(20) DEFAULT 'cash',
  `details` text NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'released',
  PRIMARY KEY (`id`),
  KEY `expense_id` (`expense_id`),
  CONSTRAINT `expenses_payments_ibfk_1` FOREIGN KEY (`expense_id`) REFERENCES `expenses` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `expenses_payments`
--

LOCK TABLES `expenses_payments` WRITE;
/*!40000 ALTER TABLE `expenses_payments` DISABLE KEYS */;
/*!40000 ALTER TABLE `expenses_payments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `files`
--

DROP TABLE IF EXISTS `files`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `files` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `realpath` varchar(255) NOT NULL,
  `link` varchar(255) NOT NULL,
  `filename` varchar(255) NOT NULL,
  `extension` varchar(10) NOT NULL,
  `type` varchar(255) NOT NULL,
  `folder` varchar(255) NOT NULL,
  `date_upload` datetime NOT NULL,
  `thumb` varchar(255) NOT NULL,
  `size` decimal(25,4) NOT NULL,
  `user_id` int(11) NOT NULL,
  `trash` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `files`
--

LOCK TABLES `files` WRITE;
/*!40000 ALTER TABLE `files` DISABLE KEYS */;
/*!40000 ALTER TABLE `files` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `groups`
--

DROP TABLE IF EXISTS `groups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `groups` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `description` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `groups`
--

LOCK TABLES `groups` WRITE;
/*!40000 ALTER TABLE `groups` DISABLE KEYS */;
INSERT INTO `groups` VALUES (1,'admin','Administrator'),(2,'Members','General User'),(3,'customer','Client'),(4,'supplier','Supplier'),(5,'superadmin','Super Administrator');
/*!40000 ALTER TABLE `groups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `invoices`
--

DROP TABLE IF EXISTS `invoices`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `invoices` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `reference` varchar(20) NOT NULL,
  `date` date NOT NULL,
  `date_due` date DEFAULT NULL,
  `title` varchar(25) NOT NULL DEFAULT 'Invoice',
  `description` varchar(255) NOT NULL,
  `status` varchar(25) NOT NULL DEFAULT 'Draft',
  `bill_to_id` int(11) DEFAULT NULL,
  `note` text NOT NULL,
  `terms` text NOT NULL,
  `currency` varchar(10) NOT NULL DEFAULT 'USD',
  `discount_type` tinyint(1) NOT NULL DEFAULT 1,
  `subtotal` decimal(25,4) NOT NULL DEFAULT 0.0000,
  `global_discount` decimal(25,4) NOT NULL DEFAULT 0.0000,
  `shipping` decimal(10,2) NOT NULL DEFAULT 0.00,
  `total_discount` decimal(25,4) NOT NULL DEFAULT 0.0000,
  `total_tax` decimal(25,4) NOT NULL DEFAULT 0.0000,
  `total` decimal(25,4) NOT NULL DEFAULT 0.0000,
  `count` int(11) NOT NULL DEFAULT 0,
  `total_due` decimal(10,2) NOT NULL DEFAULT 0.00,
  `payment_date` date DEFAULT NULL,
  `estimate_id` int(11) DEFAULT NULL,
  `recurring_id` int(11) DEFAULT NULL,
  `double_currency` tinyint(1) NOT NULL DEFAULT 0,
  `rate` decimal(25,4) NOT NULL DEFAULT 0.0000,
  `user_id` int(11) unsigned DEFAULT NULL,
  `custom_field1` varchar(255) NOT NULL,
  `custom_field2` varchar(255) NOT NULL,
  `custom_field3` varchar(255) NOT NULL,
  `custom_field4` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `bill_to_id` (`bill_to_id`),
  KEY `estimate_id` (`estimate_id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `invoices_ibfk_1` FOREIGN KEY (`bill_to_id`) REFERENCES `biller` (`id`),
  CONSTRAINT `invoices_ibfk_2` FOREIGN KEY (`estimate_id`) REFERENCES `estimates` (`id`) ON DELETE SET NULL ON UPDATE SET NULL,
  CONSTRAINT `invoices_ibfk_3` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `invoices`
--

LOCK TABLES `invoices` WRITE;
/*!40000 ALTER TABLE `invoices` DISABLE KEYS */;
/*!40000 ALTER TABLE `invoices` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `invoices_items`
--

DROP TABLE IF EXISTS `invoices_items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `invoices_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) DEFAULT NULL,
  `item_id` int(11) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `quantity` decimal(25,4) NOT NULL DEFAULT 0.0000,
  `unit_price` decimal(25,4) NOT NULL DEFAULT 0.0000,
  `tax_type` tinyint(1) NOT NULL DEFAULT 1,
  `tax` decimal(25,4) NOT NULL DEFAULT 0.0000,
  `discount_type` tinyint(1) NOT NULL DEFAULT 1,
  `discount` decimal(25,4) NOT NULL DEFAULT 0.0000,
  `total` decimal(25,4) NOT NULL DEFAULT 0.0000,
  PRIMARY KEY (`id`),
  KEY `invoices_items_ibfk_1` (`invoice_id`),
  KEY `item_id` (`item_id`),
  CONSTRAINT `invoices_items_ibfk_1` FOREIGN KEY (`invoice_id`) REFERENCES `invoices` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `invoices_items_ibfk_2` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`) ON DELETE SET NULL ON UPDATE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `invoices_items`
--

LOCK TABLES `invoices_items` WRITE;
/*!40000 ALTER TABLE `invoices_items` DISABLE KEYS */;
/*!40000 ALTER TABLE `invoices_items` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `invoices_taxes`
--

DROP TABLE IF EXISTS `invoices_taxes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `invoices_taxes` (
  `invoice_id` int(11) NOT NULL,
  `tax_rate_id` int(11) DEFAULT NULL,
  `label` varchar(255) NOT NULL,
  `value` decimal(10,2) NOT NULL,
  `type` tinyint(1) NOT NULL,
  `is_conditional` tinyint(1) NOT NULL DEFAULT 0,
  KEY `invoice_id` (`invoice_id`),
  KEY `tax_rate_id` (`tax_rate_id`),
  CONSTRAINT `invoices_taxes_ibfk_1` FOREIGN KEY (`invoice_id`) REFERENCES `invoices` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `invoices_taxes_ibfk_2` FOREIGN KEY (`tax_rate_id`) REFERENCES `tax_rates` (`id`) ON DELETE SET NULL ON UPDATE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `invoices_taxes`
--

LOCK TABLES `invoices_taxes` WRITE;
/*!40000 ALTER TABLE `invoices_taxes` DISABLE KEYS */;
/*!40000 ALTER TABLE `invoices_taxes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `items`
--

DROP TABLE IF EXISTS `items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `discount_type` tinyint(1) NOT NULL DEFAULT 1,
  `discount` decimal(25,4) NOT NULL DEFAULT 0.0000,
  `tax_type` tinyint(1) NOT NULL DEFAULT 1,
  `tax` decimal(25,4) NOT NULL DEFAULT 0.0000,
  `category` int(11) DEFAULT NULL,
  `unit` varchar(25) NOT NULL DEFAULT 'U',
  `custom_field1` varchar(255) NOT NULL,
  `custom_field2` varchar(255) NOT NULL,
  `custom_field3` varchar(255) NOT NULL,
  `custom_field4` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `category` (`category`),
  CONSTRAINT `items_ibfk_1` FOREIGN KEY (`category`) REFERENCES `items_categories` (`id`) ON DELETE SET NULL ON UPDATE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `items`
--

LOCK TABLES `items` WRITE;
/*!40000 ALTER TABLE `items` DISABLE KEYS */;
/*!40000 ALTER TABLE `items` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `items_categories`
--

DROP TABLE IF EXISTS `items_categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `items_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `is_default` int(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `items_categories`
--

LOCK TABLES `items_categories` WRITE;
/*!40000 ALTER TABLE `items_categories` DISABLE KEYS */;
/*!40000 ALTER TABLE `items_categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `items_prices`
--

DROP TABLE IF EXISTS `items_prices`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `items_prices` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL,
  `price` decimal(25,4) NOT NULL DEFAULT 0.0000,
  `currency` varchar(10) NOT NULL DEFAULT 'USD',
  PRIMARY KEY (`id`),
  KEY `item_id` (`item_id`),
  CONSTRAINT `items_prices_ibfk_1` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `items_prices`
--

LOCK TABLES `items_prices` WRITE;
/*!40000 ALTER TABLE `items_prices` DISABLE KEYS */;
/*!40000 ALTER TABLE `items_prices` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `log`
--

DROP TABLE IF EXISTS `log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` datetime NOT NULL,
  `user_id` int(11) unsigned DEFAULT NULL,
  `username` varchar(100) DEFAULT NULL,
  `controller` varchar(255) DEFAULT NULL,
  `method` varchar(255) DEFAULT NULL,
  `param` varchar(255) DEFAULT NULL,
  `content` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `log_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log`
--

LOCK TABLES `log` WRITE;
/*!40000 ALTER TABLE `log` DISABLE KEYS */;
/*!40000 ALTER TABLE `log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `login_attempts`
--

DROP TABLE IF EXISTS `login_attempts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `login_attempts` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ip_address` varchar(15) NOT NULL,
  `login` varchar(100) NOT NULL,
  `time` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `login_attempts`
--

LOCK TABLES `login_attempts` WRITE;
/*!40000 ALTER TABLE `login_attempts` DISABLE KEYS */;
/*!40000 ALTER TABLE `login_attempts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `payments`
--

DROP TABLE IF EXISTS `payments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `payments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) NOT NULL,
  `number` int(11) NOT NULL,
  `date` date NOT NULL,
  `amount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `method` varchar(20) DEFAULT 'cash',
  `details` text NOT NULL,
  `credit_card` text DEFAULT NULL,
  `token` varchar(255) DEFAULT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'released',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `payments`
--

LOCK TABLES `payments` WRITE;
/*!40000 ALTER TABLE `payments` DISABLE KEYS */;
/*!40000 ALTER TABLE `payments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `projects`
--

DROP TABLE IF EXISTS `projects`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `projects` (
  `id` int(1) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `biller_id` int(11) NOT NULL,
  `progress` int(3) NOT NULL,
  `billing_type` varchar(255) NOT NULL,
  `rate` decimal(25,4) NOT NULL DEFAULT 0.0000,
  `currency` varchar(10) NOT NULL DEFAULT 'USD',
  `estimated_hours` int(11) NOT NULL DEFAULT 0,
  `status` varchar(255) NOT NULL DEFAULT 'progress',
  `date` date NOT NULL,
  `date_due` date DEFAULT NULL,
  `members` text NOT NULL,
  `description` text NOT NULL,
  `user_id` int(1) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `biller_id` (`biller_id`),
  CONSTRAINT `projects_ibfk_1` FOREIGN KEY (`biller_id`) REFERENCES `biller` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `projects_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `projects`
--

LOCK TABLES `projects` WRITE;
/*!40000 ALTER TABLE `projects` DISABLE KEYS */;
/*!40000 ALTER TABLE `projects` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `projects_tasks`
--

DROP TABLE IF EXISTS `projects_tasks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `projects_tasks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `project_id` int(111) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `hour_rate` decimal(25,4) NOT NULL,
  `date` date NOT NULL,
  `date_due` date DEFAULT NULL,
  `priority` int(1) NOT NULL,
  `description` text NOT NULL,
  `attachments` text NOT NULL,
  `status` varchar(255) NOT NULL,
  `user_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `project_id` (`project_id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `projects_tasks_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `projects_tasks_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `projects_tasks`
--

LOCK TABLES `projects_tasks` WRITE;
/*!40000 ALTER TABLE `projects_tasks` DISABLE KEYS */;
/*!40000 ALTER TABLE `projects_tasks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `receipts`
--

DROP TABLE IF EXISTS `receipts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `receipts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) NOT NULL,
  `biller_id` int(11) NOT NULL,
  `number` int(11) NOT NULL,
  `date` date NOT NULL,
  `amount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `method` varchar(20) DEFAULT 'cash',
  `details` text NOT NULL,
  `credit_card` text DEFAULT NULL,
  `token` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `receipts`
--

LOCK TABLES `receipts` WRITE;
/*!40000 ALTER TABLE `receipts` DISABLE KEYS */;
/*!40000 ALTER TABLE `receipts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `recurring_invoices`
--

DROP TABLE IF EXISTS `recurring_invoices`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `recurring_invoices` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `date` date NOT NULL,
  `next_date` date DEFAULT NULL,
  `type` varchar(255) NOT NULL,
  `frequency` varchar(10) NOT NULL,
  `number` varchar(255) NOT NULL,
  `occurence` int(4) NOT NULL,
  `status` varchar(255) NOT NULL,
  `data` text NOT NULL,
  `bill_to_id` int(11) DEFAULT NULL,
  `amount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `user_id` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `bill_to_id` (`bill_to_id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `recurring_invoices_ibfk_1` FOREIGN KEY (`bill_to_id`) REFERENCES `biller` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `recurring_invoices_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `recurring_invoices`
--

LOCK TABLES `recurring_invoices` WRITE;
/*!40000 ALTER TABLE `recurring_invoices` DISABLE KEYS */;
/*!40000 ALTER TABLE `recurring_invoices` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `recurring_invoices_items`
--

DROP TABLE IF EXISTS `recurring_invoices_items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `recurring_invoices_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) DEFAULT NULL,
  `recurring_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `skip` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `invoice_id` (`invoice_id`),
  KEY `recurring_id` (`recurring_id`),
  CONSTRAINT `recurring_invoices_items_ibfk_1` FOREIGN KEY (`invoice_id`) REFERENCES `invoices` (`id`) ON DELETE SET NULL ON UPDATE SET NULL,
  CONSTRAINT `recurring_invoices_items_ibfk_2` FOREIGN KEY (`recurring_id`) REFERENCES `recurring_invoices` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `recurring_invoices_items`
--

LOCK TABLES `recurring_invoices_items` WRITE;
/*!40000 ALTER TABLE `recurring_invoices_items` DISABLE KEYS */;
/*!40000 ALTER TABLE `recurring_invoices_items` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `settings`
--

DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(10) NOT NULL,
  `configuration` text NOT NULL,
  `controller` varchar(255) DEFAULT NULL,
  `method` varchar(255) DEFAULT NULL,
  `param` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `settings`
--

LOCK TABLES `settings` WRITE;
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
INSERT INTO `settings` VALUES (1,'COMPANY','{\"name\":\"\\u0e23\\u0e49\\u0e32\\u0e19\\u0e40\\u0e17\\u0e1e\\u0e0b\\u0e35\\u0e1e\\u0e35\\u0e22\\u0e39\",\"address\":\"99 \\u0e2b\\u0e21\\u0e39\\u0e48 2 \\u0e15\\u0e33\\u0e1a\\u0e25\\u0e19\\u0e32\\u0e2a\\u0e48\\u0e27\\u0e07\",\"city\":\"\\u0e2d\\u0e33\\u0e40\\u0e20\\u0e2d\\u0e40\\u0e14\\u0e0a\\u0e2d\\u0e38\\u0e14\\u0e21\",\"state\":\"\\u0e08\\u0e31\\u0e07\\u0e2b\\u0e27\\u0e31\\u0e14\\u0e2d\\u0e38\\u0e1a\\u0e25\\u0e23\\u0e32\\u0e0a\\u0e18\\u0e32\\u0e19\\u0e35\",\"postal_code\":\"\\u0e23\\u0e2b\\u0e31\\u0e2a\\u0e44\\u0e1b\\u0e29\\u0e13\\u0e35\\u0e22\\u0e4c 34160\",\"country\":\"\\u0e1b\\u0e23\\u0e30\\u0e40\\u0e17\\u0e28\\u0e44\\u0e17\\u0e22\",\"phone\":\"0954439307\",\"email\":\"thephuttiphan@gmail.com\",\"logo\":\"storage\\/71187593_117685839612708_3934838849485668352_n.jpg\",\"cfl1\":\"\\u0e2b\\u0e21\\u0e32\\u0e22\\u0e40\\u0e25\\u0e02\\u0e1b\\u0e23\\u0e30\\u0e08\\u0e33\\u0e15\\u0e31\\u0e27\\u0e1c\\u0e39\\u0e49\\u0e40\\u0e2a\\u0e35\\u0e22\\u0e20\\u0e32\\u0e29\\u0e35\",\"cfv1\":\"1349900984060\",\"cfl2\":\"\",\"cfv2\":\"\",\"cfl3\":\"\",\"cfv3\":\"\",\"cfl4\":\"\",\"cfv4\":\"\"}',NULL,NULL,NULL),(2,'SYSTEM','{\"language\":\"english\",\"dateformat\":\"4\",\"number_format\":\"3\",\"round_number\":\"0\",\"currency_format\":\"2\",\"currency_place\":\"right\",\"decimal_place\":\"2\",\"enable_register\":\"1\",\"default_group\":\"Members\",\"default_currency\":\"THB\",\"reference_type\":\"1\",\"prefix_invoice\":\"INV-\",\"estimate_prefix\":\"EST-\",\"receipt_prefix\":\"RCPT-\",\"expense_prefix\":\"EXP-\",\"invoice_next\":\"1\",\"estimate_next\":\"1\",\"receipt_next\":\"1\",\"contract_next\":\"1\",\"expense_next\":\"1\",\"shipping\":\"1\",\"item_tax\":\"1\",\"item_discount\":\"1\",\"default_status\":\"draft\",\"default_country\":\"TH\",\"show_status\":null,\"show_total_due\":null,\"show_payments_page\":null,\"customer_cf1\":\"\",\"customer_cf2\":\"\",\"customer_cf3\":\"\",\"customer_cf4\":\"\",\"supplier_cf1\":\"\",\"supplier_cf2\":\"\",\"supplier_cf3\":\"\",\"supplier_cf4\":\"\",\"item_cf1\":\"\",\"item_cf2\":\"\",\"item_cf3\":\"\",\"item_cf4\":\"\",\"invoice_cf1\":\"\\u0e17\\u0e14\\u0e2a\\u0e2d\\u0e1a\",\"invoice_cf2\":\"\",\"invoice_cf3\":\"\",\"invoice_cf4\":\"\",\"default_note\":\"\",\"default_terms\":\"\",\"note_terms_on_page\":null,\"enable_terms\":null,\"enable_contracts\":null,\"df_contract_desc\":\"\",\"contract_prefix\":\"CONT-\",\"enable_recurring\":null,\"enable_overdue_reminder\":null,\"overdue_first_time\":null,\"overdue_every\":null,\"amount_in_words\":null,\"description_inline\":\"1\",\"chat_enable\":null,\"chat_support_label\":\"Support\",\"chat_support_id\":\"1\",\"reminder_enable\":null,\"reminder_subject\":\"Smart Invoice System - Reminder\",\"reminder_content\":\"\",\"user_all_privileges\":\"1\",\"cus_payment_methods\":\"1\",\"tax_conditional\":{\"enable\":\"1\",\"tax_rate_id\":\"1\",\"condition\":\"<\",\"amount\":\"0\"},\"default_due_date\":\"null\",\"exchange_api_key\":\"\"}',NULL,NULL,NULL),(3,'INVOICE','{\"name\":\"LNWCPU\",\"invoice_default_layout\":\"portrait\",\"invoice_default_size\":\"A4\",\"auto_print\":\"2\",\"invoice_font\":\"Arial, Helvetica, sans-serif\",\"font_size\":\"12px\",\"margin\":\"0.5cm 0.5cm 0.5cm 0.5cm\",\"text_color\":\"#2e2e2e\",\"primary_color\":\"#009be1\",\"table_border\":\"1\",\"table_strip\":\"1\",\"table_line_th_height\":\"24\",\"table_line_td_height\":\"23\",\"table_line_th_bg\":\"#009be1\",\"table_line_th_color\":\"#ffffff\",\"logo_size\":\"100%\",\"logo_monocolor\":\"0\",\"logo_greyscale\":\"0\",\"background_color\":\"#ffffff\",\"background_image\":\"\",\"background_position\":\"center center\",\"background_fit\":\"initial\",\"background_opacity\":\"0.4\",\"show_header\":\"1\",\"header_bg_color\":\"#ffffff\",\"header_txt_color\":\"#000000\",\"header_model\":\"model1\",\"header_text\":\"<h4>[company_name]<\\/h4>\\r\\n[company_address], [company_city], [company_postal_code] [company_state], [company_country] Phone:<\\/strong> [company_phone] Email: <\\/strong>[company_email]<\\/p>\\r\\n\\u0e2b\\u0e21\\u0e32\\u0e22\\u0e40\\u0e25\\u0e02\\u0e1b\\u0e23\\u0e30\\u0e08\\u0e33\\u0e15\\u0e31\\u0e27\\u0e1c\\u0e39\\u0e49\\u0e40\\u0e2a\\u0e35\\u0e22\\u0e20\\u0e32\\u0e29\\u0e35 : 1349900984060<\\/p>\",\"show_footer\":\"1\",\"footer_bg_color\":\"#ffffff\",\"footer_txt_color\":\"#2e2e2e\",\"footer_text\":\"[company_name] &copy; 2017<\\/p>\",\"show_signature\":\"1\",\"signature_txt\":\"signature & stamp\",\"signature_stamp\":\"\"}',NULL,NULL,NULL);
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `suppliers`
--

DROP TABLE IF EXISTS `suppliers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `suppliers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fullname` varchar(255) NOT NULL,
  `phone` varchar(30) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `website` varchar(255) NOT NULL DEFAULT '',
  `address` text DEFAULT NULL,
  `address2` text NOT NULL,
  `city` varchar(55) NOT NULL,
  `state` varchar(55) NOT NULL,
  `postal_code` varchar(8) NOT NULL,
  `country` varchar(55) NOT NULL,
  `company` varchar(255) NOT NULL,
  `vat_number` varchar(255) NOT NULL DEFAULT '',
  `user_id` int(11) unsigned DEFAULT NULL,
  `custom_field1` varchar(255) DEFAULT NULL,
  `custom_field2` varchar(255) DEFAULT NULL,
  `custom_field3` varchar(255) DEFAULT NULL,
  `custom_field4` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `suppliers`
--

LOCK TABLES `suppliers` WRITE;
/*!40000 ALTER TABLE `suppliers` DISABLE KEYS */;
/*!40000 ALTER TABLE `suppliers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tax_rates`
--

DROP TABLE IF EXISTS `tax_rates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tax_rates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `label` varchar(255) NOT NULL,
  `value` decimal(10,2) NOT NULL,
  `type` tinyint(1) NOT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT 0,
  `can_delete` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tax_rates`
--

LOCK TABLES `tax_rates` WRITE;
/*!40000 ALTER TABLE `tax_rates` DISABLE KEYS */;
INSERT INTO `tax_rates` VALUES (1,'lang:no_tax',0.00,0,0,0),(2,'ภาษีมูลค่าเพิ่ม',7.00,0,1,1);
/*!40000 ALTER TABLE `tax_rates` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `todo`
--

DROP TABLE IF EXISTS `todo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `todo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subject` varchar(255) NOT NULL,
  `priority` int(1) NOT NULL,
  `complete` int(1) NOT NULL,
  `description` text NOT NULL,
  `date` date NOT NULL,
  `date_due` date DEFAULT NULL,
  `user_id` int(11) unsigned DEFAULT NULL,
  `attachments` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `todo_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `todo`
--

LOCK TABLES `todo` WRITE;
/*!40000 ALTER TABLE `todo` DISABLE KEYS */;
/*!40000 ALTER TABLE `todo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ip_address` varchar(45) NOT NULL,
  `username` varchar(100) DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `salt` varchar(255) DEFAULT NULL,
  `email` varchar(100) NOT NULL,
  `activation_code` varchar(40) DEFAULT NULL,
  `forgotten_password_code` varchar(40) DEFAULT NULL,
  `forgotten_password_time` int(11) unsigned DEFAULT NULL,
  `remember_code` varchar(40) DEFAULT NULL,
  `created_on` int(11) unsigned NOT NULL,
  `last_login` int(11) unsigned DEFAULT NULL,
  `active` tinyint(1) unsigned DEFAULT NULL,
  `first_name` varchar(50) DEFAULT NULL,
  `last_name` varchar(50) DEFAULT NULL,
  `company` varchar(100) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'127.0.0.1','adminpot','$2y$08$DFvocvd6omRe4C1O8FVG2.ESavpbVMxkS2KUKvVr9qHc0wbLU9kFi','','admin@admin.com','',NULL,NULL,'3o6rg9FOxhHe31KAtJaLG.',1268889823,1718342458,1,'Admin','istrator','ADMIN','0');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users_groups`
--

DROP TABLE IF EXISTS `users_groups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users_groups` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned NOT NULL,
  `group_id` mediumint(8) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uc_users_groups` (`user_id`,`group_id`),
  KEY `fk_users_groups_users1_idx` (`user_id`),
  KEY `fk_users_groups_groups1_idx` (`group_id`),
  CONSTRAINT `fk_users_groups_groups1` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `fk_users_groups_users1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users_groups`
--

LOCK TABLES `users_groups` WRITE;
/*!40000 ALTER TABLE `users_groups` DISABLE KEYS */;
INSERT INTO `users_groups` VALUES (1,1,1),(2,1,2),(3,1,5);
/*!40000 ALTER TABLE `users_groups` ENABLE KEYS */;
UNLOCK TABLES;
/*!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 */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2025-10-31 13:27:27

📁 Sid Gifari File Manager