--
-- Host: 127.0.0.1    Database: portfolio
-- ------------------------------------------------------


--
-- Table structure for table `portfolio_category`
--

USE wdpf36_shafiq;

CREATE TABLE `portfolio_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) NOT NULL,
  `description` varchar(255) NOT NULL,
  `user_id` int(11) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `active` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `portfolio_category`
--

INSERT INTO `portfolio_category` VALUES (1,'General Blog','This is my general blog descriptions.',19,'2018-11-20 06:29:41',1),(2,'About me','Here is the about me.',1,'2018-11-20 06:29:41',1),(3,'Service','Here is the some service I provide about you.',1,'2018-11-20 06:29:41',1),(4,'About me','&lt;hello&gt; I\'am shafiq &lt;/hello&gt;',19,'2018-11-20 06:29:41',1),(5,'My skills','this i smy skill &lt;h1',19,'2018-11-20 06:29:41',1),(6,'Blogs','hello i\'m shafiqul islam. @copy me #contact with me..',19,'2018-11-20 06:29:41',1),(9,'Service blog','this is service blog',19,'2018-11-20 06:30:05',1);

--
-- Table structure for table `portfolio_menu`
--

CREATE TABLE `portfolio_menu` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(45) NOT NULL,
  `menuattr` varchar(255) NOT NULL,
  `menu_url` varchar(255) NOT NULL,
  `order_by` int(10) unsigned NOT NULL,
  `description` longtext NOT NULL,
  `active` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `portfolio_menu`
--

INSERT INTO `portfolio_menu` VALUES (1,'Home','class=\"nav-link\"  id=\"menu\"','http://sumon.de/CodeIgniter/portfolio/',1,'This is home page',1,19,'2018-11-19 06:30:03'),(3,'Blog','class=\"nav-link dropdown-toggle\" href=\"#\" data-toggle=\"dropdown\"','',2,'blog description.',1,19,'2018-11-18 03:31:08'),(4,'Service','class=\"nav-link dropdown-toggle\" href=\"#\" data-toggle=\"dropdown\"','http://service.com/home',3,'desc',1,19,'2018-11-18 03:30:18'),(5,'Skill','id=\"nav\" class=\"nav-link\"','http://something.org',4,'bla bla',1,19,'2018-11-18 03:28:56'),(6,'product','class=\"nav-link dropdown-toggle\" href=\"#\" data-toggle=\"dropdown\"','',5,'',1,19,'2018-11-19 07:30:10');

--
-- Table structure for table `portfolio_options`
--

CREATE TABLE `portfolio_options` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `option_name` varchar(191) NOT NULL,
  `option_value` longtext NOT NULL,
  `auto_load` varchar(20) NOT NULL,
  `user_id` int(11) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `portfolio_options`
--

INSERT INTO `portfolio_options` VALUES (1,'site_url','http://sumon.de/CodeIgniter/portfolio/','1',19,'2018-11-19 07:25:26'),(2,'port_name','Shafiqul Islam','1',19,'2018-11-24 12:13:57'),(3,'port_description','This is the descriptions descriptions','1',19,'2018-11-12 14:11:18'),(4,'port_tags','Tags, tags, and tags','1',19,'2018-11-12 14:12:55'),(5,'port_thumb','source/uploads/1542032152.jpg','1',19,'2018-11-12 14:15:52'),(6,'footer_text','copyright 2018 - Developed by Shafiqul Islam Sumon','1',19,'2018-11-12 14:50:16'),(7,'facebook_url','https://www.facebook.com/','1',19,'2018-11-12 16:46:18'),(8,'linkedin_url','LinkedIn','1',19,'2018-11-12 16:46:18'),(9,'twitter_url','Twitter','1',19,'2018-11-12 16:46:18'),(10,'youtube_url','YouTube','1',19,'2018-11-12 16:46:18'),(11,'github_url','Github','1',19,'2018-11-12 16:46:18'),(12,'stackover_url','Stackoverflow','1',19,'2018-11-12 16:46:18'),(13,'vcampus_url','url','',19,'2018-11-24 16:18:55'),(14,'smtp_host','ssl://smtp.googlemail.com','1',19,'2018-11-24 17:57:53'),(15,'smtp_port','465','1',19,'2018-11-12 16:44:41'),(16,'smtp_user','sumon.wdpf@gmail.com','1',19,'2018-11-24 17:57:53'),(17,'smtp_pass','SpectoPetronum4sumon','1',19,'2018-11-24 17:57:53'),(18,'email_subject','Portfolio-','1',19,'2018-11-24 17:57:53');

--
-- Table structure for table `portfolio_post`
--

CREATE TABLE `portfolio_post` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text NOT NULL,
  `content` longtext,
  `status` varchar(45) NOT NULL,
  `media` varchar(45) NOT NULL,
  `section_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `portfolio_post`
--

INSERT INTO `portfolio_post` VALUES (5,'Hello world','&lt;p&gt;This is another hello world.&lt;/p&gt;','publish','image',3,19,'2018-11-24 13:39:05'),(7,'Graphic design','&lt;p&gt;Lorem Ipsum is simply dummy text of the printing and typesetting industry.sunt in anim id est laborum. Allamco laboris nisi ut aliquip ex ea commodo consequat.&lt;br&gt;&lt;/p&gt;','publish','icon',3,19,'2018-11-24 15:03:31'),(8,'Seo Optimaize','&lt;p&gt;Lorem Ipsum is simply dummy text of the printing and typesetting industry.sunt in anim id est laborum. Allamco laboris nisi ut aliquip ex ea commodo consequat.&lt;br&gt;&lt;/p&gt;','publish','icon',3,19,'2018-11-24 14:57:38'),(9,'Web Development','&lt;p&gt;Lorem Ipsum is simply dummy text of the printing and typesetting industry.sunt in anim id est laborum. Allamco laboris nisi ut aliquip ex ea commodo consequat.&lt;br&gt;&lt;/p&gt;','publish','icon',3,19,'2018-11-24 14:36:48'),(10,'Mohammad Towhidul Islam','&lt;p&gt;Lorem ipsum dolor sit amet, consectetur adipisicing elit. Reprehenderit nemo a sint aliquam perspiciatis, ea voluptas maxime dolorem eveniet omnis, reiciendis nobis commodi, laboriosam eos, tempore odio dignissimos molestiae nostrum.&lt;br&gt;&lt;/p&gt;','publish','image',6,19,'2018-11-24 16:14:39'),(11,'Moshaidul Islam','&lt;p&gt;Lorem ipsum dolor sit amet, consectetur adipisicing elit. Reprehenderit nemo a sint aliquam perspiciatis, ea voluptas maxime dolorem eveniet omnis, reiciendis nobis commodi, laboriosam eos, tempore odio dignissimos molestiae nostrum.&lt;br&gt;&lt;/p&gt;','publish','image',6,19,'2018-11-24 16:15:08');

--
-- Table structure for table `portfolio_postsection`
--

CREATE TABLE `portfolio_postsection` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(45) NOT NULL,
  `description` varchar(255) NOT NULL,
  `active` int(10) unsigned NOT NULL,
  `order_by` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `portfolio_postsection`
--

INSERT INTO `portfolio_postsection` VALUES (1,'Description','Product Description',1,1,19,'2018-11-19 04:50:37'),(2,'Benefits','Product Benefits',1,2,19,'2018-11-19 04:50:37'),(3,'Documents','Product Documents',0,3,19,'2018-11-19 06:26:18');

--
-- Table structure for table `portfolio_procategory`
--

CREATE TABLE `portfolio_procategory` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(45) NOT NULL,
  `description` varchar(45) DEFAULT NULL,
  `per_page` int(10) unsigned DEFAULT NULL,
  `active` int(11) NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `portfolio_procategory`
--

INSERT INTO `portfolio_procategory` VALUES (1,'ERP','ERP- Enterprise Resource Planning.',10,1,19,'2018-11-19 04:19:29'),(2,'POS','POS - Point Of Sale',10,1,19,'2018-11-19 04:19:50');

--
-- Table structure for table `portfolio_product`
--

CREATE TABLE `portfolio_product` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `description` longtext NOT NULL,
  `image` varchar(255) NOT NULL,
  `active` int(10) unsigned NOT NULL,
  `cat_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `portfolio_product`
--

INSERT INTO `portfolio_product` VALUES (1,'ERP - Real Estate','Backed by some of the biggest names in the industry, Firefox OS is an open platform that fosters greater','source/uploads/1542603166.png',1,1,19,'2018-11-19 04:52:46'),(2,'ERP - Textile','The Intellect ERP (enterprise resource planning) software solutions - seek to integrate the business processes involving eight critical areas in the textile production planning which includes raw material, finance, payroll, inventory, quality, sales and plant maintenance. it manages to cut costs in processing. Increasingly complex product mixes and longer processing sequences are intensifying the need for IT infrastructure. In composite mills (spinning, weaving, garmenting, retailing), these are becoming inevitable.','source/uploads/manufacturing.png',1,1,19,'2018-11-19 04:56:45'),(3,'ERP - Merchandising','Merchandising, CONTROL Retail Management System and POS also takes care of Retail CRM, Inventory Management, online trading, Sales &amp; Profit Analysis, Order Entry &amp; Invoicing, Replenishment, and Other special merchandising features (i.e. style/colour/size (and sub-size) facilities; serial number facilities for warranty, stock tracking or recall; and much more..','source/uploads/1542603546.png',1,1,19,'2018-11-19 04:59:06'),(4,'ERP - Hospital','Intellect Hospital Management Software is a comprehensive and integrated hospital management software, designed to manage all aspects of hospital operations.(i.e. Outpatient and Inpatient management, Patient Registration, Doctor Appointment, Medical Billing,pharmacy management,Labrotory management, Radioloy Reporting Management, Finance &amp; Accounts, HR/Payroll etc.)','source/uploads/1542603638.png',1,1,19,'2018-11-19 05:00:38');

--
-- Table structure for table `portfolio_relations`
--

CREATE TABLE `portfolio_relations` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `post_id` int(10) unsigned NOT NULL,
  `meta_key` varchar(255) NOT NULL,
  `meta_value` longtext,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `portfolio_relations`
--

INSERT INTO `portfolio_relations` VALUES (6,5,'category','2'),(7,5,'section','2'),(8,5,'post_tags','tags,tags,and tags'),(9,5,'thumb_icon','&lt;i class=&quot;fa fa-bags&quot; &gt;&lt;/i&gt;'),(10,5,'thumb_img','source/uploads/1542979496.png'),(15,7,'category','3'),(16,7,'section','2'),(17,7,'post_tags',''),(18,7,'thumb_img','1'),(19,8,'category','3'),(20,8,'section','2'),(21,8,'post_tags',''),(22,8,'thumb_img','source/uploads/1543067283.jpg'),(23,9,'category','3'),(24,9,'post_tags',''),(25,9,'thumb_icon','&lt;i class=&quot;fa fa-code fa-5x&quot; aria-hidden=&quot;true&quot;&gt;&lt;/i&gt;'),(26,9,'thumb_img','1'),(27,10,'category','5'),(28,10,'post_tags',''),(29,10,'thumb_icon',''),(30,10,'thumb_img','source/uploads/1543076078.jpg'),(31,11,'category',''),(32,11,'post_tags',''),(33,11,'thumb_icon',''),(34,11,'thumb_img','source/uploads/1543076108.png');

--
-- Table structure for table `portfolio_section`
--

CREATE TABLE `portfolio_section` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `sec_slug` text NOT NULL,
  `description` longtext NOT NULL,
  `per_page` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `active` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `portfolio_section`
--

INSERT INTO `portfolio_section` VALUES (1,'Home','home','This is the home section and this post is the top of the page.',1,19,'2018-11-23 19:15:39',1),(2,'About me','about','I\'m john Doe, Web Designer &amp; Developer . have long experience for more than seven years.',1,19,'2018-11-23 19:23:44',1),(3,'My Services','service','I am offering My Customers very Special Services and Solutions and Here are My main Services.',8,19,'2018-11-24 14:01:11',1),(4,'My Creative Work','portfolio','Here\'s Some of My Awesome Previous Work in Web Designing.',6,19,'2018-11-24 15:43:50',1),(5,'My Skills','skills','Here I explain the skill of mine.',8,19,'2018-11-23 19:15:39',1),(6,'What Our Clients Say','testimonials','',3,19,'2018-11-24 15:51:52',1),(7,'My Blogs','blogs','Here is my latest Blog',4,19,'2018-11-23 19:15:39',1),(8,'Contact Us','comtact','If you have anything to say . please feel free to contact us.',1,19,'2018-11-23 19:15:39',1);

--
-- Table structure for table `portfolio_sectionrelation`
--

CREATE TABLE `portfolio_sectionrelation` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` int(10) unsigned NOT NULL,
  `section_id` int(10) unsigned NOT NULL,
  `section_desc` longtext NOT NULL,
  `active` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `portfolio_sectionrelation`
--

INSERT INTO `portfolio_sectionrelation` VALUES (1,1,1,'Platino is our POS (Point of Sale) solution for gas stations and convenience stores. Integrated with our forecourt controllers, they solve all your billing needs offering total site control, improving your customer loyalty.\r\n\r\nThe Plaino POS solution has different modules that interact according to your business´s needs:\r\n\r\nSite Master: It´s the site server containing the database and all your site´s configuration; performing statistic reports, and site management.\r\nPlatino POS High End : Full functionality POS with an outstanding Graphic User Interface. \r\nPlatino POS Mid Range: EFTPOS terminal based POS. Provides basic POS functionality through countertop terminals.\r\nPlatino SPOT: Integrated Pay@Pump solutions\r\n  Features:\r\n\r\nFull wet &amp; dry product sales.\r\nOnline connection with fuel pumps.\r\nSimpified process for Shift and End of day Closure\r\nElectronic Payment integration capacity\r\nCashier events registration\r\nProven product delivered peace of mind\r\nFeatures designed for lower cost of ownership\r\nEasy to use touch-screen reduces user errors, speeds transactions\r\nImproved standardization through multi-lingual capability\r\nRich promotional functionality increases sales\r\nFeatures like fiscal receipt printers help you comply with regulations\r\nSite Master:\r\n\r\nSite setup\r\nWet &amp; dry product management\r\nPricebook, price list and promotions\r\nProduct categories and bar codes\r\nCutomer &amp; payable account management\r\nUsers, cashiers and attendants management\r\nSecurity, passwords, roles.\r\nTaxes\r\nIssue of a wide range of reports and statistic information\r\nPlatino POS High End :\r\n\r\nTouch-screen GUI\r\nWet &amp; Dry billing\r\nSales receipt, sales refund and returns\r\nOnline connection with fuel pumps\r\nMultiple tender options\r\nPaid In / Paid Out\r\nShift, day and month closures (Billing emission complement).\r\nPrepay – preset fuel sales\r\nStock management\r\nPlatino POS Mid Range :\r\n\r\nWet &amp; Dry billing\r\nSales receipt, sales refund and returns\r\nOnline connection with fuel pumps\r\nMultiple tender options\r\nShift, day and month closures (Billing emission complement).\r\nPlatino SPOT\r\n\r\n  Platino SPOT provides the easiest and most integrated solution for Self-Service operation and electronic payment. It allows integration with cash payment. This system provides a modular approach to EMV and PCI compliance. It increases throughput and convenience with easy to use pay@pump and pay@terminal solutions. Fully-integrated technology.',1),(2,1,2,'Low maintenance cost\r\nIntuitive graphical interface that reduces the learning curve.\r\nIntegration with other operative areas (office and services) in a single billing point. Native integration with our forecourt controllers (Pump Controller)\r\nThird pary BackOffice integration – HeadOffice integration. ERP integration.\r\nEasy use: it can be used through any of its flexible platforms (Island Terminals, dataphones, administrator PCs configuration and site control)\r\nPlatino consolidates service and maintenance expenses, thanks to a single supplier',1),(3,1,3,'Documents in Spanish:\r\n\r\nPlatino - Punto de Venta Brochure\r\nDocuments in English:\r\n\r\nPlatino® Point of Sale (POS) System Brochure',1),(4,2,1,'Platino is our POS (Point of Sale) solution for gas stations and convenience stores. Integrated with our forecourt controllers, they solve all your billing needs offering total site control, improving your customer loyalty.\r\n\r\nThe Plaino POS solution has different modules that interact according to your business´s needs:\r\n\r\nSite Master: It´s the site server containing the database and all your site´s configuration; performing statistic reports, and site management.\r\nPlatino POS High End : Full functionality POS with an outstanding Graphic User Interface. \r\nPlatino POS Mid Range: EFTPOS terminal based POS. Provides basic POS functionality through countertop terminals.\r\nPlatino SPOT: Integrated Pay@Pump solutions\r\n  Features:\r\n\r\nFull wet &amp; dry product sales.\r\nOnline connection with fuel pumps.\r\nSimpified process for Shift and End of day Closure\r\nElectronic Payment integration capacity\r\nCashier events registration\r\nProven product delivered peace of mind\r\nFeatures designed for lower cost of ownership\r\nEasy to use touch-screen reduces user errors, speeds transactions\r\nImproved standardization through multi-lingual capability\r\nRich promotional functionality increases sales\r\nFeatures like fiscal receipt printers help you comply with regulations\r\nSite Master:\r\n\r\nSite setup\r\nWet &amp; dry product management\r\nPricebook, price list and promotions\r\nProduct categories and bar codes\r\nCutomer &amp; payable account management\r\nUsers, cashiers and attendants management\r\nSecurity, passwords, roles.\r\nTaxes\r\nIssue of a wide range of reports and statistic information\r\nPlatino POS High End :\r\n\r\nTouch-screen GUI\r\nWet &amp; Dry billing\r\nSales receipt, sales refund and returns\r\nOnline connection with fuel pumps\r\nMultiple tender options\r\nPaid In / Paid Out\r\nShift, day and month closures (Billing emission complement).\r\nPrepay – preset fuel sales\r\nStock management\r\nPlatino POS Mid Range :\r\n\r\nWet &amp; Dry billing\r\nSales receipt, sales refund and returns\r\nOnline connection with fuel pumps\r\nMultiple tender options\r\nShift, day and month closures (Billing emission complement).\r\nPlatino SPOT\r\n\r\n  Platino SPOT provides the easiest and most integrated solution for Self-Service operation and electronic payment. It allows integration with cash payment. This system provides a modular approach to EMV and PCI compliance. It increases throughput and convenience with easy to use pay@pump and pay@terminal solutions. Fully-integrated technology.',1),(5,2,2,'Low maintenance cost\r\nIntuitive graphical interface that reduces the learning curve.\r\nIntegration with other operative areas (office and services) in a single billing point. Native integration with our forecourt controllers (Pump Controller)\r\nThird pary BackOffice integration – HeadOffice integration. ERP integration.\r\nEasy use: it can be used through any of its flexible platforms (Island Terminals, dataphones, administrator PCs configuration and site control)\r\nPlatino consolidates service and maintenance expenses, thanks to a single supplier',1),(6,2,3,'Documents in Spanish:\r\n\r\nPlatino - Punto de Venta Brochure\r\nDocuments in English:\r\n\r\nPlatino® Point of Sale (POS) System Brochure',1),(7,3,1,'Platino is our POS (Point of Sale) solution for gas stations and convenience stores. Integrated with our forecourt controllers, they solve all your billing needs offering total site control, improving your customer loyalty.\r\n\r\nThe Plaino POS solution has different modules that interact according to your business´s needs:\r\n\r\nSite Master: It´s the site server containing the database and all your site´s configuration; performing statistic reports, and site management.\r\nPlatino POS High End : Full functionality POS with an outstanding Graphic User Interface. \r\nPlatino POS Mid Range: EFTPOS terminal based POS. Provides basic POS functionality through countertop terminals.\r\nPlatino SPOT: Integrated Pay@Pump solutions\r\n  Features:\r\n\r\nFull wet &amp; dry product sales.\r\nOnline connection with fuel pumps.\r\nSimpified process for Shift and End of day Closure\r\nElectronic Payment integration capacity\r\nCashier events registration\r\nProven product delivered peace of mind\r\nFeatures designed for lower cost of ownership\r\nEasy to use touch-screen reduces user errors, speeds transactions\r\nImproved standardization through multi-lingual capability\r\nRich promotional functionality increases sales\r\nFeatures like fiscal receipt printers help you comply with regulations\r\nSite Master:\r\n\r\nSite setup\r\nWet &amp; dry product management\r\nPricebook, price list and promotions\r\nProduct categories and bar codes\r\nCutomer &amp; payable account management\r\nUsers, cashiers and attendants management\r\nSecurity, passwords, roles.\r\nTaxes\r\nIssue of a wide range of reports and statistic information\r\nPlatino POS High End :\r\n\r\nTouch-screen GUI\r\nWet &amp; Dry billing\r\nSales receipt, sales refund and returns\r\nOnline connection with fuel pumps\r\nMultiple tender options\r\nPaid In / Paid Out\r\nShift, day and month closures (Billing emission complement).\r\nPrepay – preset fuel sales\r\nStock management\r\nPlatino POS Mid Range :\r\n\r\nWet &amp; Dry billing\r\nSales receipt, sales refund and returns\r\nOnline connection with fuel pumps\r\nMultiple tender options\r\nShift, day and month closures (Billing emission complement).\r\nPlatino SPOT\r\n\r\n  Platino SPOT provides the easiest and most integrated solution for Self-Service operation and electronic payment. It allows integration with cash payment. This system provides a modular approach to EMV and PCI compliance. It increases throughput and convenience with easy to use pay@pump and pay@terminal solutions. Fully-integrated technology.',1),(8,3,2,'Low maintenance cost\r\nIntuitive graphical interface that reduces the learning curve.\r\nIntegration with other operative areas (office and services) in a single billing point. Native integration with our forecourt controllers (Pump Controller)\r\nThird pary BackOffice integration – HeadOffice integration. ERP integration.\r\nEasy use: it can be used through any of its flexible platforms (Island Terminals, dataphones, administrator PCs configuration and site control)\r\nPlatino consolidates service and maintenance expenses, thanks to a single supplier',1),(9,3,3,'Documents in Spanish:\r\n\r\nPlatino - Punto de Venta Brochure\r\nDocuments in English:\r\n\r\nPlatino® Point of Sale (POS) System Brochure',1),(10,4,1,'Platino is our POS (Point of Sale) solution for gas stations and convenience stores. Integrated with our forecourt controllers, they solve all your billing needs offering total site control, improving your customer loyalty.\r\n\r\nThe Plaino POS solution has different modules that interact according to your business´s needs:\r\n\r\nSite Master: It´s the site server containing the database and all your site´s configuration; performing statistic reports, and site management.\r\nPlatino POS High End : Full functionality POS with an outstanding Graphic User Interface. \r\nPlatino POS Mid Range: EFTPOS terminal based POS. Provides basic POS functionality through countertop terminals.\r\nPlatino SPOT: Integrated Pay@Pump solutions\r\n  Features:\r\n\r\nFull wet &amp; dry product sales.\r\nOnline connection with fuel pumps.\r\nSimpified process for Shift and End of day Closure\r\nElectronic Payment integration capacity\r\nCashier events registration\r\nProven product delivered peace of mind\r\nFeatures designed for lower cost of ownership\r\nEasy to use touch-screen reduces user errors, speeds transactions\r\nImproved standardization through multi-lingual capability\r\nRich promotional functionality increases sales\r\nFeatures like fiscal receipt printers help you comply with regulations\r\nSite Master:\r\n\r\nSite setup\r\nWet &amp; dry product management\r\nPricebook, price list and promotions\r\nProduct categories and bar codes\r\nCutomer &amp; payable account management\r\nUsers, cashiers and attendants management\r\nSecurity, passwords, roles.\r\nTaxes\r\nIssue of a wide range of reports and statistic information\r\nPlatino POS High End :\r\n\r\nTouch-screen GUI\r\nWet &amp; Dry billing\r\nSales receipt, sales refund and returns\r\nOnline connection with fuel pumps\r\nMultiple tender options\r\nPaid In / Paid Out\r\nShift, day and month closures (Billing emission complement).\r\nPrepay – preset fuel sales\r\nStock management\r\nPlatino POS Mid Range :\r\n\r\nWet &amp; Dry billing\r\nSales receipt, sales refund and returns\r\nOnline connection with fuel pumps\r\nMultiple tender options\r\nShift, day and month closures (Billing emission complement).\r\nPlatino SPOT\r\n\r\n  Platino SPOT provides the easiest and most integrated solution for Self-Service operation and electronic payment. It allows integration with cash payment. This system provides a modular approach to EMV and PCI compliance. It increases throughput and convenience with easy to use pay@pump and pay@terminal solutions. Fully-integrated technology.',1),(11,4,2,'Low maintenance cost\r\nIntuitive graphical interface that reduces the learning curve.\r\nIntegration with other operative areas (office and services) in a single billing point. Native integration with our forecourt controllers (Pump Controller)\r\nThird pary BackOffice integration – HeadOffice integration. ERP integration.\r\nEasy use: it can be used through any of its flexible platforms (Island Terminals, dataphones, administrator PCs configuration and site control)\r\nPlatino consolidates service and maintenance expenses, thanks to a single supplier',1),(12,4,3,'Documents in Spanish:\r\n\r\nPlatino - Punto de Venta Brochure\r\nDocuments in English:\r\n\r\nPlatino® Point of Sale (POS) System Brochure',1);

--
-- Table structure for table `portfolio_submenu`
--

CREATE TABLE `portfolio_submenu` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(45) NOT NULL,
  `parent_id` int(10) unsigned NOT NULL,
  `menuattr` varchar(255) NOT NULL,
  `menu_url` varchar(255) NOT NULL,
  `order_by` int(10) unsigned NOT NULL,
  `description` longtext NOT NULL,
  `active` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `portfolio_submenu`
--

INSERT INTO `portfolio_submenu` VALUES (1,'Blog sub 1',2,'id=&quot;submenu&quot; class=&quot;submenu&quot;','http://blog.com/blogsub',1,'this is submenu category.',1,19,'2018-11-17 20:54:58'),(3,'Blog sub 2',3,'id=\"blog\" class=\"dropdown-item\"','http://blog.com/blogsub2/',2,'sub blog desc',1,19,'2018-11-18 03:28:00'),(4,'sub ',3,'id=\"menu\"  class=\"dropdown-item\"','http://something.org',1,'da',1,19,'2018-11-18 03:28:06'),(5,'Skill',4,'id=\"blog\" class=\"dropdown-item\"','http://something.org',4,'asdfsf',1,19,'2018-11-18 03:29:31'),(6,'service 1',4,'id=\"menu\" class=\"dropdown-item\"','http://hsdafsdf.com',3,'',1,19,'2018-11-19 07:28:42'),(7,'single product',6,'id=\"blog\" class=\"dropdown-item','',1,'',1,19,'2018-11-19 07:28:12');

--
-- Table structure for table `portfolio_upload`
--

CREATE TABLE `portfolio_upload` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(45) NOT NULL,
  `value` text NOT NULL,
  `user_id` int(11) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `portfolio_upload`
--



