-- MySQL dump 10.13 Distrib 5.7.29, for Linux (x86_64) -- -- Host: localhost Database: aerion -- ------------------------------------------------------ -- Server version 5.7.29-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 utf8 */; /*!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 */; -- -- Dumping data for table `feature` -- LOCK TABLES `feature` WRITE; /*!40000 ALTER TABLE `feature` DISABLE KEYS */; INSERT INTO `feature` VALUES (1,1,'Login History View',' Login History View',1),(2,2,'Login History Delete','Login History Delete',2),(3,3,'Login History Print','Login History Print',3),(4,4,'Login History export','Login History export',4),(5,5,'Login History Archive','To Archive / Deleted records',5),(6,6,'Login History Restore','To restore Archive / Deleted Records',6),(7,7,'Login History Delete Forever','To Delete records forever',7),(8,151,'Network Log View','Network Log View',151),(11,301,'Employee View','Employee View',301),(12,302,'Employee Edit','Employee Edit',302),(13,303,'Employee Add','Employee Add',303),(14,304,'Employee Delete','Employee Delete',304),(15,321,'Emp Attration View','Emp Report View',321),(16,322,'Emp Attration Execute','Emp Report Execute',322),(17,331,'Employee Values View','Emp Values View',331),(18,332,'Employee Values Edit','Emp Values Edit',332),(19,11,'My Login History View','My Login History View',11),(20,451,'Storage Files View','Storage Files View',451),(21,452,'Storage Uploads','Storage Uploads',452),(22,453,'Storage Delete','Storage Delete',453),(23,461,'Storage Attachment View','Storage Folder View',461),(24,462,'Storage Attachment Edit','Storage Folder Edit',462),(25,463,'Storage Attachment Add','Storage Folder Add',463),(26,464,'Storage Attachment Delete','Storage Folder Delete',464),(27,471,'Storage Tags View','Storage Values View',471),(28,472,'Storage Tags Edit','Storage Values Edit',472),(29,473,'Storage Tags Add','Storage Values Add',473),(30,474,'Storage Tags Delete','Storage Values Delete',474),(33,601,'Company View','Company View',601),(34,602,'Company Edit','Company Edit',602),(35,603,'Company Add','Company Add',603),(36,611,'Company Contracts View','Company Contracts View',611),(37,612,'Company Contracts Edit','Company Contracts Edit',612),(38,613,'Company Contracts Add','Company Contracts Add',613),(39,621,'Budget View','Budget View',621),(40,622,'Budget Edit','Budget Edit',622),(41,623,'Budget Add','Budget Add',623),(42,631,'Client Listing View','Client Listing View',631),(43,632,'Client Listing Edit','Client Listing Edit',632),(44,633,'Client Listing Add','Client Listing Add',633),(45,641,'Festival Edit','Festival Edit',641),(46,651,'Company Product View','Company Product View',651),(47,652,'Company Product Edit','Company Product Edit',652),(48,653,'Company Product Add','Company Product Add',653),(49,654,'Company Product Delete','Company Product Delete',654),(331,2558,'Legal Restore','Legal Restore',2558),(330,2557,'Legal Archive','Legal Archive',2557),(52,751,'Hours Forecast View','Bill Cycle View',751),(53,752,'Hours Forecast Edit','Bill Cycle Edit',752),(54,753,'Hours Forecast Execute','Bill Cycle Execute',753),(55,761,'Hours View','Hours View',761),(56,762,'Hours Edit','Hours Edit',762),(57,763,'Hours Add','Hours Add',763),(58,771,'My Hours Edit','My Hours Edit',771),(59,781,'Hours Approve Edit','Hours Approve Edit',781),(60,791,'Hours Pending Process Edit','Hours Pending Process Edit',791),(61,801,'Timesheet View','Timesheet View',801),(62,802,'Timesheet Edit','Timesheet Edit',802),(63,804,'Timesheet Delete','Timesheet Delete',803),(66,901,'Asset View','Asset View',901),(67,902,'Asset Edit','Asset Add/Edit',902),(68,903,'Asset Add','Asset Delete',903),(71,1051,'Inventory View','Inventory View',1051),(72,1052,'Inventory Edit','Inventory Edit',1052),(73,1053,'Inventory Add','Inventory Add',1053),(76,1201,'Invoice View','Invoice View',1201),(77,1202,'Invoice Edit','Invoice Edit',1202),(78,1203,'Invoice Add','Invoice Add',1203),(79,1211,'Self Invoice View','Self Invoice View',1211),(80,1212,'Self Invoice Edit','Self Invoice Edit',1212),(81,1213,'Self Invoice Add','Self Invoice Add',1213),(84,1351,'Sales All Rights','Sales All Rights',1351),(85,1352,'Consultant Tags View Recruite','Consultant view',1352),(86,1353,'Consultant Tags Edit Recruite','Consultant Edit Recruite Tags',1353),(87,1354,'Consultant Tags Add Recruite','Consultant Add Recruite Tags',1354),(88,1355,'Consultant Tags Delete Recruite','Consultant Delete Recruite',1355),(89,1356,'Consult Recruite Tags Execute','Consult Recruite Tags Execute',1356),(90,1357,'Consult Recruite Tags Print','Consult Recruite Tags Print / Export / CSV',1357),(91,1361,'Consultant Log View','Consultant Log View',1361),(92,1362,'Consultant Log Delete','Tag Employee Add/Edit',1362),(93,1371,'Tag Employee Edit','Tag Employee Edit',1371),(94,1381,'Consultant Conversion','Consultant Conversion',1381),(95,1391,'Leads View','Leads View',1391),(96,1392,'Leads Edit','Leads Edit',1392),(97,1393,'Leads Add','Leads Add',1393),(98,1394,'Leads Delete','Leads Delete',1394),(99,1401,'My Leads Edit','My Leads Edit',1401),(100,1411,'Virtual Leads View','Virtual Leads View',1411),(329,2556,'Legal Export','Legal Export',2556),(328,2555,'Legal Print','Legal Print',2555),(103,1501,'Mkt Company View','Mkt Company View',1501),(104,1511,'Mkt Reqs View','Mkt Reqs View',1511),(105,1521,'Mkt Reqs Log View','Mkt Reqs Log View',1521),(106,1522,'Mkt Reqs Log Delete','Mkt Reqs Log Delete',1522),(107,1531,'Mkt Marketing View','Mkt Marketing View',1531),(108,1541,'Mkt My Marketing Edit','Mkt My Marketing Edit',1541),(111,1651,'IT Apex View','IT Applications View',1651),(112,1652,'IT Apex Edit','IT Application Edit',1652),(113,1653,'IT Apex Add','IT Application Add',1653),(114,1655,'IT Apex Print','IT Application Print',1654),(115,1656,'IT Apex Export/CSV','IT Application Export/CSV',1656),(116,1657,'IT Apex Archive','IT Application Archive',1657),(117,1658,'IT Apex Restore','IT Application Restore',1658),(118,1659,'IT Apex Delete Forever','IT Application Delete Forever',1659),(119,1661,'IT Glacier View','IT Work Order View',1661),(270,1703,'IT Credence Add','IT Req Acceptance Add',1703),(120,1662,'IT Glacier Edit','IT Work Order Edit',1662),(121,1663,'IT Glacier Add','IT Work Order Add',1663),(122,1671,'IT Virtual Glacier View','IT Virtual Work Order View',1671),(123,1681,'IT Cubes View','IT Reqs View',1681),(124,1682,'IT Cubes Edit','IT Reqs Edit',1682),(125,1683,'IT Cubes Add','IT Reqs Add',1683),(126,1691,'IT Virtual Cubes View','IT Virtual Reqs View',1691),(127,1701,'IT Credence View','IT Req Acceptance View',1701),(128,1702,'IT Credence Edit','IT Req Acceptance Add / Edit',1702),(129,1711,'IT Glance View','IT Glance View',1711),(130,1712,'IT Glance Execute','IT Glance Execute',1712),(131,1721,'IT Virtual Glance View','IT Virtual Glance View',1721),(132,1731,'IT Burning View','IT Burning View',1731),(133,1732,'IT Burning Print','IT Burning Print',1732),(134,1741,'IT My Burning Archive','IT My Burning Archive',1741),(135,1751,'IT Quotes View','IT Quotes View',1751),(136,1752,'IT Quotes Edit','IT Quotes Edit',1752),(137,1753,'IT Quotes Add','IT Quotes Add',1753),(138,1754,'IT Quotes Delete','IT Quotes Delete',1754),(139,1755,'IT Quotes Print','IT Quotes Print',1755),(140,1756,'IT Quotes Export to CSV','IT Quotes Export to CSV',1756),(141,1757,'IT Quotes Archive','IT Quotes Archive',1757),(142,1758,'IT Quotes Restore','IT Quotes Restore',1758),(143,1759,'IT Quotes Delete Forever','IT Quotes Delete Forever',1759),(144,1735,'IT Burning Archive Print','IT Burning Archive Print',1735),(145,1762,'IT My Quotes Edit','IT My Quotes Edit',1762),(146,1763,'IT My Quotes Add','IT My Quotes Add',1763),(147,1764,'IT My Quotes Delete','IT My Quotes Delete',1764),(148,1765,'IT My Quotes Archive','IT My Quotes Archive',1765),(149,1771,'IT Access View','IT Access View',1771),(150,1772,'IT Access Edit','IT Access Edit',1772),(151,1773,'IT Access Add','IT Access Add',1773),(152,1774,'IT Access Delete','IT Access Delete',1774),(153,1781,'IT Label View','IT Label View',1781),(154,1782,'IT Label Edit','IT Label Edit',1782),(155,2551,'Legal View','Immigration View',2551),(156,2552,'Legal Edit','Immigration Add/Edit',2552),(157,2554,'Legal Delete','Immigration Delete',2554),(332,2559,'Legal Delete Forever','Legal Delete Forever',2559),(160,1951,'Features View','Features View',1951),(161,1952,'Features Edit','Features Edit',1952),(162,1953,'Features Add','Features Add',1953),(163,1961,'Feature Group View','Feature Group View',1961),(164,1962,'Feature Group Edit','Feature Group Edit',1962),(165,1963,'Feature Group Add','Feature Group Add',1963),(166,1964,'Feature Group Delete','Feature Group Delete',1964),(167,1965,'Feature Group Execute','Feature Group Execute',1965),(168,604,'Company Delete','Company Delete',604),(169,614,'Company Contracts Delete','Company Contracts Delete',614),(170,624,'Budget Delete','Budget Delete',624),(171,634,'Client Listing Delete','Client Listing Delete',634),(172,642,'Festival Add','Festival Add',642),(173,305,'Employee Archive','Employee Archive',305),(174,306,'Employee Restore','Employee Restore',306),(175,307,'Employee Delete Forever','Employee Deleteforever',307),(176,465,'Storage Attachment Archive','Storage Folder Archive',465),(177,466,'Storage Attachment Restore','Storage Folder Restore',466),(178,467,'Storage Attachment Delete Forever','Storage Folder Delete forever',467),(179,764,'Hours Delete','Hours Delete',764),(180,772,'My Hours Add','My Hours Add',772),(181,782,'Hours Approve Add','Hours Approve Add',782),(182,792,'Hours Pending Process Add','Hours Pending Process Add',792),(183,803,'Timesheet Add','Timesheet Add',803),(184,904,'Asset Delete','Asset Delete',904),(185,1054,'Inventory Delete','Inventory Delete',1054),(186,1204,'Invoice Delete','Invoice Delete',1204),(187,1214,'Self Invoice Delete','Self Invoice Delete',1214),(188,1358,'Consult Recruite Tags Export/CSV','Consult Recruite Tags Export/CSV',1358),(189,1372,'Tag Employee Add','Tag Employee Add',1372),(190,811,'My Timesheet Edit','My Timesheet Edit',811),(191,812,'My Timesheet Add','My Timesheet Add',812),(192,1402,'My Leads Add','My Leads Add',1402),(193,1502,'Mkt Company Edit','Mkt Company Edit',1502),(194,1503,'Mkt Company Add','Mkt Company Add',1503),(195,1512,'Mkt Reqs Edit','Mkt Reqs Edit',1512),(196,1513,'Mkt Reqs Add','Mkt Reqs Add',1513),(197,1532,'Mkt Marketing Edit','Mkt Marketing Edit',1532),(198,1533,'Mkt Marketing Add','Mkt Marketing Add',1533),(199,1542,'Mkt My Marketing Add','Mkt My Marketing Add',1542),(200,1654,'IT Apex Delete','IT Application Delete',1654),(201,1664,'IT Glacier Delete','IT Work Order Delete',1664),(202,1684,'IT Cubes Delete','IT Reqs Delete',1684),(203,1971,'Audit View','Feature Group Log View',1971),(204,1972,'Audit Delete','Feature Group Log Delete',1972),(205,1981,'Menu Header View','Menu Header View',1981),(206,1991,'Menu View','Menu View',1991),(207,1992,'Menu Edit','Menu Edit',1992),(208,1993,'Menu Add','Menu Add',1993),(209,1994,'Menu Delete','Menu Delete',1994),(210,2001,'Menu Feature View','Menu Feature View',2001),(211,2002,'Menu Feature Edit','Menu Feature Edit',2002),(212,2003,'Menu Feature Add','Menu Feature Add',2003),(213,2004,'Menu Feature Delete','Menu Feature Delete',2004),(214,2011,'Addresses View','Addresses View',2011),(215,2012,'Addresses Edit','Addresses Edit',2012),(216,2013,'Addresses Add','Addresses Add',2013),(217,2014,'Addresses Delete','Addresses Delete',2014),(218,2021,'Config Value View','Config Value View',2021),(219,2022,'Config Value Edit','Config Value Edit',2022),(220,2023,'Config Value Add','Config Value Add',2023),(221,2024,'Config Value Delete','Config Value Delete',2024),(222,2031,'Config Label View','Config Label View',2031),(223,2032,'Config Label Edit','Config Label Edit',2031),(224,2041,'Global Audit View','Config Audit View',2041),(225,2042,'Global Audit Delete','Config Audit Delete',2042),(226,2101,'Recruite View','Recruite View',2101),(227,2102,'Recruite Edit','Recruite Edit',2102),(228,2103,'Recruite Add','Recruite Add',2103),(229,2104,'Recruite Delete','Recruite Delete',2104),(230,2111,'Recruite Values View','Recruite Values View',2111),(231,2112,'Recruite Values Edit','Recruite Values Edit',2112),(232,2113,'Recruite Values Add','Recruite Values Add',2113),(233,2114,'Recruite Values Delete','Recruite Values Delete',2114),(234,2121,'Recruite Tags View','Recruite Tags View',2121),(235,2122,'Recruite Tags Edit','Recruite Tags Edit',2122),(236,2123,'Recruite Tags Add','Recruite Tags Add',2123),(237,2124,'Recruite Tags Delete','Recruite Tags Delete',2124),(238,2131,'Review View','Review View',2131),(239,2132,'Review Edit','Review Edit',2132),(240,2133,'Review Add','Review Add',2133),(241,2134,'Review Delete','Review Delete',2134),(242,2141,'Review Values View','Review Values View',2141),(243,2142,'Review Values Edit','Review Values Edit',2142),(244,2143,'Review Values Add','Review Values Add',2143),(245,2144,'Review Values Delete','Review Values Delete',2144),(246,2151,'Review Tags View','Review Tags View',2151),(247,2152,'Review Tags Edit','Review Tags Edit',2152),(248,2153,'Review Tags Add','Review Tags Add',2153),(249,2154,'Review Tags Delete','Review Tags Delete',2154),(250,2161,'HR Policies View','HR Policies View',2161),(251,2162,'HR Policies Edit','HR Policies Edit',2162),(252,2163,'HR Policies Add','HR Policies Add',2163),(253,2164,'HR Policies Delete','HR Policies Delete',2164),(256,2251,'Bank Account View','Bank Account View',2251),(257,2252,'Bank Account Edit','Bank Account Edit',2252),(258,2253,'Bank Account Add','Bank Account Add',2253),(259,2254,'Bank Account Delete','Bank Account Delete',2254),(260,2261,'Bank Record View','Bank Record View',2261),(261,2262,'Bank Record Edit','Bank Record Edit',2262),(262,2263,'Bank Record Add','Bank Record Add',2263),(263,2264,'Bank Record Delete','Bank Record Delete',2264),(264,2271,'Bank Labels View','Bank Labels View',2271),(265,2272,'Bank Labels Edit','Bank Labels Edit',2272),(266,311,'Emp Access View','Emp Access View',311),(267,312,'Emp Access Edit','Emp Access Edit',312),(268,313,'Emp Access Add','Emp Access Add',313),(269,314,'Emp Access Delete','Emp Access Delete',314),(271,2553,'Legal Add','Legal Add/Edit',2553),(272,1660,'IT Apex Execute','IT Apex Execute',1660),(273,1733,'IT Burning Export','IT Burning Export',1733),(274,1734,'IT Burning Archive','IT Burning Archive',1734),(275,1736,'IT Burning Archive Export','IT Burning Archive Export',1736),(276,911,'Asset Values View','Asset Values View',921),(277,912,'Asset Values Edit','Asset Values Edit',922),(278,913,'Asset Values Add','Asset Values Add',923),(279,914,'Asset Values Delete','Asset Values Delete',924),(280,1685,'IT Cubes Print','IT Cubes Print',1685),(281,1686,'IT Cubes Export','IT Cubes Export',1686),(282,1687,'IT Cubes Archive','IT Cubes Archive',1687),(283,1688,'IT Cubes Restore','IT Cubes Restore',1688),(284,1689,'IT Cubes Delete Forever','IT Cubes Delete Forever',1689),(285,1690,'IT Cubes Execute','IT Cubes Execute',1690),(286,1504,'Mkt Company Delete','Mkt Company Delete',1504),(287,1505,'Mkt Company Print','Mkt Company Print',1505),(288,1506,'Mkt Company Export','Mkt Company Export',1506),(289,1507,'Mkt Company Archive','Mkt Company Archive',1507),(290,1508,'Mkt Company Restore','Mkt Company Restore',1508),(291,1509,'Mkt Company Delete Forever','Mkt Company Delete Forever',1509),(292,1510,'Mkt Company Execute','Mkt Company Execute',1510),(293,2181,'HR Meeting Edit','HR Meeting Edit',2181),(294,2182,'HR Meeting Add','HR Meeting Add',2182),(295,2183,'HR Meeting Delete','HR Meeting Delete',2183),(296,2184,'HR Meeting Print','HR Meeting Print',2184),(297,2185,'HR Meeting Export','HR Meeting Export',2185),(298,1403,'My Leads Delete','My Leads Delete',1403),(299,1405,'My Leads Export','My Leads Export',1405),(300,1404,'My Leads Print','My Leads Print',1404),(301,1406,'My Leads Archive','My Leads Archive',1406),(302,1407,'My Leads Restore','My Leads Restore',1407),(303,1408,'My Leads Delete Forever','My Leads Delete Forever',1408),(304,1791,'IT Values View',' IT Values View',1791),(305,1792,'IT Values Edit',' IT Values Edit',1792),(306,1793,'IT Values Add',' IT Values Add',1793),(307,1794,'IT Values Delete',' IT Values Delete',1794),(308,1801,'IT Workflow View',' \n \n ',NULL),(309,1802,'IT Workflow Edit',' ',NULL),(310,1803,'IT Workflow Add',' ',NULL),(311,1804,'IT Workflow Delete',' IT Workflow Delete',NULL),(312,491,'Storage Values View','Storage Values View',491),(313,492,'Storage Values Edit','Storage Values Edit',492),(314,493,'Storage Values Add','Storage Values Add',493),(315,494,'Storage Values Delete','Storage Values Delete',494),(316,468,'Storage Attachment Toggle','Storage Attachment Toggle',468),(317,1395,'Leads Print','Leads Print',1395),(318,1396,'Leads Export','Leads Export',1396),(319,1397,'Leads Archive','Leads Archive',1397),(320,1398,'Leads Restore','Leads Restore',1398),(321,1399,'Leads Delete Forever','Leads Delete Forever',1399),(322,12,'My Login History Print','My Login History Print',12),(323,13,'My Login History Export','My Login History Export',13),(324,333,'Employee Values Delete','Emp Values View',333),(325,1409,'My Leads Toggle view','My Leads Toggle view',1409),(326,1400,'My Leads Toggle view','My Leads Toggle view',1400),(327,308,'Employee Execute','Employee Execute',308); /*!40000 ALTER TABLE `feature` 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 2020-07-22 20:27:52