IP : 3.145.62.14Hostname : host45.registrar-servers.comKernel : Linux host45.registrar-servers.com 4.18.0-513.18.1.lve.2.el8.x86_64 #1 SMP Sat Mar 30 15:36:11 UTC 2024 x86_64Disable Function : None :) OS : Linux
PATH:
/
home/
../
var/
./
softaculous/
wp53/
../
glpi/
./
../
ricar/
../
vtiger/
vtiger.sql/
/
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00";
/*!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 */;
-- -- Table structure for table `com_vtiger_workflowtasks` --
CREATE TABLE `com_vtiger_workflowtasks` ( `task_id` int(11) NOT NULL AUTO_INCREMENT, `workflow_id` int(11) DEFAULT NULL, `summary` varchar(400) NOT NULL, `task` text NOT NULL, PRIMARY KEY (`task_id`), UNIQUE KEY `com_vtiger_workflowtasks_idx` (`task_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=29 ;
-- -- Dumping data for table `com_vtiger_workflowtasks` --
INSERT INTO `com_vtiger_workflowtasks` VALUES (1, 1, '', 'O:18:"VTEntityMethodTask":6:{s:18:"executeImmediately";b:1;s:10:"workflowId";i:1;s:7:"summary";s:0:"";s:6:"active";b:1;s:10:"methodName";s:15:"UpdateInventory";s:2:"id";i:1;}'), (2, 2, 'An account has been created ', 'O:11:"VTEmailTask":9:{s:18:"executeImmediately";s:0:"";s:10:"workflowId";s:1:"2";s:7:"summary";s:28:"An account has been created ";s:6:"active";s:1:"1";s:10:"methodName";s:11:"NotifyOwner";s:9:"recepient";s:36:"$(assigned_user_id : (Users) email1)";s:7:"subject";s:26:"Regarding Account Creation";s:7:"content";s:301:"An Account has been assigned to you on vtigerCRM<br>Details of account are :<br><br>AccountId:<b>$account_no</b><br>AccountName:<b>$accountname</b><br>Rating:<b>$rating</b><br>Industry:<b>$industry</b><br>AccountType:<b>$accounttype</b><br>Description:<b>$description</b><br><br><br>Thank You<br>Admin";s:2:"id";s:1:"2";}'), (3, 3, 'An contact has been created ', 'O:11:"VTEmailTask":9:{s:18:"executeImmediately";s:0:"";s:10:"workflowId";s:1:"3";s:7:"summary";s:28:"An contact has been created ";s:6:"active";s:1:"1";s:10:"methodName";s:11:"NotifyOwner";s:9:"recepient";s:36:"$(assigned_user_id : (Users) email1)";s:7:"subject";s:26:"Regarding Contact Creation";s:7:"content";s:305:"An Contact has been assigned to you on vtigerCRM<br>Details of Contact are :<br><br>Contact Id:<b>$contact_no</b><br>LastName:<b>$lastname</b><br>FirstName:<b>$firstname</b><br>Lead Source:<b>$leadsource</b><br>Department:<b>$department</b><br>Description:<b>$description</b><br><br><br>Thank You<br>Admin";s:2:"id";s:1:"3";}'), (4, 4, 'Email Customer Portal Login Details', 'O:18:"VTEntityMethodTask":6:{s:18:"executeImmediately";b:1;s:10:"workflowId";i:4;s:7:"summary";s:35:"Email Customer Portal Login Details";s:6:"active";b:1;s:10:"methodName";s:22:"SendPortalLoginDetails";s:2:"id";i:4;}'), (5, 5, 'An Potential has been created ', 'O:11:"VTEmailTask":8:{s:18:"executeImmediately";s:0:"";s:10:"workflowId";s:1:"5";s:7:"summary";s:30:"An Potential has been created ";s:6:"active";s:1:"1";s:9:"recepient";s:36:"$(assigned_user_id : (Users) email1)";s:7:"subject";s:30:"Regarding Potential Assignment";s:7:"content";s:342:"An Potential has been assigned to you on vtigerCRM<br>Details of Potential are :<br><br>Potential No:<b>$potential_no</b><br>Potential Name:<b>$potentialname</b><br>Amount:<b>$amount</b><br>Expected Close Date:<b>$closingdate ($_DATE_FORMAT_)</b><br>Type:<b>$opportunity_type</b><br><br><br>Description :$description<br><br>Thank You<br>Admin";s:2:"id";s:1:"5";}'), (6, 6, 'An contact has been created ', 'O:11:"VTEmailTask":8:{s:18:"executeImmediately";s:0:"";s:10:"workflowId";s:1:"6";s:7:"summary";s:28:"An contact has been created ";s:6:"active";s:1:"1";s:9:"recepient";s:36:"$(assigned_user_id : (Users) email1)";s:7:"subject";s:28:"Regarding Contact Assignment";s:7:"content";s:384:"An Contact has been assigned to you on vtigerCRM<br>Details of Contact are :<br><br>Contact Id:<b>$contact_no</b><br>LastName:<b>$lastname</b><br>FirstName:<b>$firstname</b><br>Lead Source:<b>$leadsource</b><br>Department:<b>$department</b><br>Description:<b>$description</b><br><br><br>And <b>CustomerPortal Login Details</b> is sent to the EmailID :-$email<br><br>Thank You<br>Admin";s:2:"id";s:1:"6";}'), (7, 7, 'Notify Related Contact when Ticket is created from Portal', 'O:11:"VTEmailTask":9:{s:18:"executeImmediately";s:1:"0";s:7:"summary";s:57:"Notify Related Contact when Ticket is created from Portal";s:6:"active";s:1:"1";s:2:"id";s:1:"7";s:10:"workflowId";s:1:"7";s:9:"fromEmail";s:93:"$(general : (__VtigerMeta__) supportName)<$(general : (__VtigerMeta__) supportEmailId)>";s:9:"recepient";s:33:",$(contact_id : (Contacts) email)";s:7:"subject";s:93:"[From Portal] $ticket_no [ Ticket Id : $(general : (__VtigerMeta__) recordId) ] $ticket_title";s:7:"content";s:158:"Ticket No : $ticket_no<br>\n Ticket ID : $(general : (__VtigerMeta__) recordId)<br>\n Ticket Title : $ticket_title<br><br>\n $description";}'), (10, 9, 'Send Email to Contact on Ticket Update', 'O:11:"VTEmailTask":9:{s:18:"executeImmediately";s:1:"0";s:7:"summary";s:38:"Send Email to Contact on Ticket Update";s:6:"active";s:1:"1";s:2:"id";s:2:"10";s:9:"fromEmail";s:93:"$(general : (__VtigerMeta__) supportName)<$(general : (__VtigerMeta__) supportEmailId)>";s:9:"recepient";s:33:",$(contact_id : (Contacts) email)";s:7:"subject";s:79:"$ticket_no [ Ticket Id : $(general : (__VtigerMeta__) recordId) ] $ticket_title";s:7:"content";s:624:"Ticket ID : $(general : (__VtigerMeta__) recordId)<br>Ticket Title : $ticket_title<br><br>\n Dear $(contact_id : (Contacts) lastname) $(contact_id : (Contacts) firstname),<br><br>\n The Ticket is replied the details are :<br><br>\n Ticket No : $ticket_no<br>\n Status : $ticketstatus<br>\n Category : $ticketcategories<br>\n Severity : $ticketseverities<br>\n Priority : $ticketpriorities<br><br>\n Description : <br>$description<br><br>\n Solution : <br>$solution<br>\n The comments are : <br>\n $allComments<br><br>\n Regards<br>Support Administrator";s:10:"workflowId";s:1:"9";}'), (13, 12, 'update forecast amount', 'O:18:"VTUpdateFieldsTask":7:{s:18:"executeImmediately";b:1;s:43:"\0VTUpdateFieldsTask\0referenceFieldFocusList";a:0:{}s:10:"workflowId";i:12;s:7:"summary";s:22:"update forecast amount";s:6:"active";b:1;s:19:"field_value_mapping";s:95:"[{"fieldname":"forecast_amount","valuetype":"expression","value":"amount * probability / 100"}]";s:2:"id";i:13;}'), (14, 13, 'Send Notification Email to Record Owner', 'O:11:"VTEmailTask":8:{s:18:"executeImmediately";s:0:"";s:10:"workflowId";s:2:"13";s:7:"summary";s:39:"Send Notification Email to Record Owner";s:6:"active";s:1:"1";s:9:"recepient";s:36:"$(assigned_user_id : (Users) email1)";s:7:"subject";s:17:"Event : $subject";s:7:"content";s:771:"$(assigned_user_id : (Users) last_name) $(assigned_user_id : (Users) first_name) ,<br/><b>Activity Notification Details:</b><br/>Subject : $subject<br/>Start date and time : $date_start ($(general : (__VtigerMeta__) usertimezone))<br/>End date and time : $due_date ($(general : (__VtigerMeta__) usertimezone)) <br/>Status : $eventstatus <br/>Priority : $taskpriority <br/>Related To : $(parent_id : (Leads) lastname) $(parent_id : (Leads) firstname) $(parent_id : (Accounts) accountname) $(parent_id : (Potentials) potentialname) $(parent_id : (HelpDesk) ticket_title) $(parent_id : (Campaigns) campaignname) <br/>Contacts List : $contact_id <br/>Location : $location <br/>Description : $description";s:2:"id";s:2:"14";}'), (15, 14, 'Send Notification Email to Record Owner', 'O:11:"VTEmailTask":8:{s:18:"executeImmediately";s:0:"";s:10:"workflowId";s:2:"14";s:7:"summary";s:39:"Send Notification Email to Record Owner";s:6:"active";s:1:"1";s:9:"recepient";s:36:"$(assigned_user_id : (Users) email1)";s:7:"subject";s:16:"Task : $subject";s:7:"content";s:689:"$(assigned_user_id : (Users) last_name) $(assigned_user_id : (Users) first_name) ,<br/><b>Task Notification Details:</b><br/>Subject : $subject<br/>Start date and time : $date_start ($(general : (__VtigerMeta__) usertimezone))<br/>End date and time : $due_date ($_DATE_FORMAT_) <br/>Status : $taskstatus <br/>Priority : $taskpriority <br/>Related To : $(parent_id : (Leads) lastname) $(parent_id : (Leads) firstname) $(parent_id : (Accounts) accountname) $(parent_id : (Potentials) potentialname) $(parent_id : (HelpDesk) ticket_title) $(parent_id : (Campaigns) campaignname) <br/>Contacts List : $contact_id <br/>Description : $description";s:2:"id";s:2:"15";}'), (18, 16, 'Update Inventory Products', 'O:18:"VTEntityMethodTask":6:{s:18:"executeImmediately";b:1;s:10:"workflowId";i:16;s:7:"summary";s:25:"Update Inventory Products";s:6:"active";b:1;s:10:"methodName";s:15:"UpdateInventory";s:2:"id";i:18;}'), (19, 17, 'Comment Added From Portal : Send Email to Record Owner', 'O:11:"VTEmailTask":9:{s:18:"executeImmediately";s:1:"0";s:7:"summary";s:54:"Comment Added From Portal : Send Email to Record Owner";s:6:"active";s:1:"1";s:2:"id";s:2:"19";s:10:"workflowId";s:2:"17";s:9:"fromEmail";s:112:"$(contact_id : (Contacts) lastname) $(contact_id : (Contacts) firstname)<$(contact_id : (Contacts) email)>";s:9:"recepient";s:37:",$(assigned_user_id : (Users) email1)";s:7:"subject";s:92:"Respond to Ticket ID## $(general : (__VtigerMeta__) recordId) ## in Customer Portal - URGENT";s:7:"content";s:325:"Dear $(assigned_user_id : (Users) last_name) $(assigned_user_id : (Users) first_name),<br><br>\n Customer has provided the following additional information to your reply:<br><br>\n <b>$lastComment</b><br><br>\n Kindly respond to above ticket at the earliest.<br><br>\n Regards<br>Support Administrator";}'), (20, 18, 'Comment Added From CRM : Send Email to Contact, where Contact is not a Portal User', 'O:11:"VTEmailTask":9:{s:18:"executeImmediately";s:1:"0";s:7:"summary";s:82:"Comment Added From CRM : Send Email to Contact, where Contact is not a Portal User";s:6:"active";s:1:"1";s:2:"id";s:2:"20";s:10:"workflowId";s:2:"18";s:9:"fromEmail";s:93:"$(general : (__VtigerMeta__) supportName)<$(general : (__VtigerMeta__) supportEmailId)>";s:9:"recepient";s:33:",$(contact_id : (Contacts) email)";s:7:"subject";s:79:"$ticket_no [ Ticket Id : $(general : (__VtigerMeta__) recordId) ] $ticket_title";s:7:"content";s:514:"Dear $(contact_id : (Contacts) lastname) $(contact_id : (Contacts) firstname),<br><br>\n The Ticket is replied the details are :<br><br>\n Ticket No : $ticket_no<br>\n Status : $ticketstatus<br>\n Category : $ticketcategories<br>\n Severity : $ticketseverities<br>\n Priority : $ticketpriorities<br><br>\n Description : <br>$description<br><br>\n Solution : <br>$solution<br>\n The comments are : <br>\n $allComments<br><br>\n Regards<br>Support Administrator";}'), (21, 19, 'Comment Added From CRM : Send Email to Contact, where Contact is Portal User', 'O:11:"VTEmailTask":9:{s:18:"executeImmediately";s:1:"0";s:7:"summary";s:76:"Comment Added From CRM : Send Email to Contact, where Contact is Portal User";s:6:"active";s:1:"1";s:2:"id";s:2:"21";s:10:"workflowId";s:2:"19";s:9:"fromEmail";s:93:"$(general : (__VtigerMeta__) supportName)<$(general : (__VtigerMeta__) supportEmailId)>";s:9:"recepient";s:33:",$(contact_id : (Contacts) email)";s:7:"subject";s:79:"$ticket_no [ Ticket Id : $(general : (__VtigerMeta__) recordId) ] $ticket_title";s:7:"content";s:547:"Ticket No : $ticket_no<br>\n Ticket Id : $(general : (__VtigerMeta__) recordId)<br>\n Subject : $ticket_title<br><br>\n Dear $(contact_id : (Contacts) lastname) $(contact_id : (Contacts) firstname),<br><br>\n There is a reply to <b>$ticket_title</b> in the "Customer Portal" at VTiger.\n You can use the following link to view the replies made:<br>\n <a href="$(general : (__VtigerMeta__) portaldetailviewurl)">Ticket Details</a><br><br>\n Thanks<br>$(general : (__VtigerMeta__) supportName)";}'), (22, 15, 'Comment Added From CRM : Send Email to Organization', 'O:11:"VTEmailTask":9:{s:18:"executeImmediately";s:1:"0";s:7:"summary";s:51:"Comment Added From CRM : Send Email to Organization";s:6:"active";s:1:"1";s:2:"id";s:2:"22";s:10:"workflowId";s:2:"15";s:9:"fromEmail";s:93:"$(general : (__VtigerMeta__) supportName)<$(general : (__VtigerMeta__) supportEmailId)>";s:9:"recepient";s:34:",$(parent_id : (Accounts) email1),";s:7:"subject";s:79:"$ticket_no [ Ticket Id : $(general : (__VtigerMeta__) recordId) ] $ticket_title";s:7:"content";s:589:"Ticket ID : $(general : (__VtigerMeta__) recordId)<br>Ticket Title : $ticket_title<br><br>\n Dear $(parent_id : (Accounts) accountname),<br><br>\n The Ticket is replied the details are :<br><br>\n Ticket No : $ticket_no<br>\n Status : $ticketstatus<br>\n Category : $ticketcategories<br>\n Severity : $ticketseverities<br>\n Priority : $ticketpriorities<br><br>\n Description : <br>$description<br><br>\n Solution : <br>$solution<br>\n The comments are : <br>\n $allComments<br><br>\n Regards<br>Support Administrator";}'), (23, 7, 'Notify Record Owner when Ticket is created from Portal', 'O:11:"VTEmailTask":9:{s:18:"executeImmediately";s:1:"0";s:7:"summary";s:54:"Notify Record Owner when Ticket is created from Portal";s:6:"active";s:1:"1";s:2:"id";s:2:"23";s:10:"workflowId";s:1:"7";s:9:"fromEmail";s:124:"$(contact_id : (Contacts) lastname) $(contact_id : (Contacts) firstname)<$(general : (__VtigerMeta__) supportEmailId)>";s:9:"recepient";s:37:",$(assigned_user_id : (Users) email1)";s:7:"subject";s:93:"[From Portal] $ticket_no [ Ticket Id : $(general : (__VtigerMeta__) recordId) ] $ticket_title";s:7:"content";s:158:"Ticket No : $ticket_no<br>\n Ticket ID : $(general : (__VtigerMeta__) recordId)<br>\n Ticket Title : $ticket_title<br><br>\n $description";}'), (24, 20, 'Send Email to Record Owner on Ticket Update', 'O:11:"VTEmailTask":9:{s:18:"executeImmediately";s:1:"0";s:7:"summary";s:43:"Send Email to Record Owner on Ticket Update";s:6:"active";s:1:"1";s:2:"id";s:2:"24";s:10:"workflowId";s:2:"20";s:9:"fromEmail";s:93:"$(general : (__VtigerMeta__) supportName)<$(general : (__VtigerMeta__) supportEmailId)>";s:9:"recepient";s:37:",$(assigned_user_id : (Users) email1)";s:7:"subject";s:40:"Ticket Number : $ticket_no $ticket_title";s:7:"content";s:596:"Ticket ID : $(general : (__VtigerMeta__) recordId)<br>Ticket Title : $ticket_title<br><br>\n Dear $(assigned_user_id : (Users) last_name) $(assigned_user_id : (Users) first_name),<br><br>\n The Ticket is replied the details are :<br><br>\n Ticket No : $ticket_no<br>\n Status : $ticketstatus<br>\n Category : $ticketcategories<br>\n Severity : $ticketseverities<br>\n Priority : $ticketpriorities<br><br>\n Description : <br>$description<br><br>\n Solution : <br>$solution\n $allComments<br><br>\n Regards<br>Support Administrator";}'), (25, 21, 'Ticket Creation From CRM : Send Email to Record Owner', 'O:11:"VTEmailTask":9:{s:18:"executeImmediately";s:1:"0";s:7:"summary";s:53:"Ticket Creation From CRM : Send Email to Record Owner";s:6:"active";s:1:"1";s:2:"id";s:2:"25";s:10:"workflowId";s:2:"21";s:9:"fromEmail";s:93:"$(general : (__VtigerMeta__) supportName)<$(general : (__VtigerMeta__) supportEmailId)>";s:9:"recepient";s:37:",$(assigned_user_id : (Users) email1)";s:7:"subject";s:40:"Ticket Number : $ticket_no $ticket_title";s:7:"content";s:596:"Ticket ID : $(general : (__VtigerMeta__) recordId)<br>Ticket Title : $ticket_title<br><br>\n Dear $(assigned_user_id : (Users) last_name) $(assigned_user_id : (Users) first_name),<br><br>\n The Ticket is replied the details are :<br><br>\n Ticket No : $ticket_no<br>\n Status : $ticketstatus<br>\n Category : $ticketcategories<br>\n Severity : $ticketseverities<br>\n Priority : $ticketpriorities<br><br>\n Description : <br>$description<br><br>\n Solution : <br>$solution\n $allComments<br><br>\n Regards<br>Support Administrator";}'), (26, 22, 'Send Email to Organization on Ticket Update', 'O:11:"VTEmailTask":9:{s:18:"executeImmediately";s:1:"0";s:7:"summary";s:43:"Send Email to Organization on Ticket Update";s:6:"active";s:1:"1";s:2:"id";s:2:"26";s:9:"fromEmail";s:93:"$(general : (__VtigerMeta__) supportName)<$(general : (__VtigerMeta__) supportEmailId)>";s:9:"recepient";s:33:",$(parent_id : (Accounts) email1)";s:7:"subject";s:79:"$ticket_no [ Ticket Id : $(general : (__VtigerMeta__) recordId) ] $ticket_title";s:7:"content";s:589:"Ticket ID : $(general : (__VtigerMeta__) recordId)<br>Ticket Title : $ticket_title<br><br>\n Dear $(parent_id : (Accounts) accountname),<br><br>\n The Ticket is replied the details are :<br><br>\n Ticket No : $ticket_no<br>\n Status : $ticketstatus<br>\n Category : $ticketcategories<br>\n Severity : $ticketseverities<br>\n Priority : $ticketpriorities<br><br>\n Description : <br>$description<br><br>\n Solution : <br>$solution<br>\n The comments are : <br>\n $allComments<br><br>\n Regards<br>Support Administrator";s:10:"workflowId";s:2:"22";}'), (27, 23, 'Ticket Creation From CRM : Send Email to Organization', 'O:11:"VTEmailTask":9:{s:18:"executeImmediately";s:1:"0";s:7:"summary";s:53:"Ticket Creation From CRM : Send Email to Organization";s:6:"active";s:1:"1";s:2:"id";s:2:"27";s:9:"fromEmail";s:93:"$(general : (__VtigerMeta__) supportName)<$(general : (__VtigerMeta__) supportEmailId)>";s:9:"recepient";s:33:",$(parent_id : (Accounts) email1)";s:7:"subject";s:79:"$ticket_no [ Ticket Id : $(general : (__VtigerMeta__) recordId) ] $ticket_title";s:7:"content";s:589:"Ticket ID : $(general : (__VtigerMeta__) recordId)<br>Ticket Title : $ticket_title<br><br>\n Dear $(parent_id : (Accounts) accountname),<br><br>\n The Ticket is replied the details are :<br><br>\n Ticket No : $ticket_no<br>\n Status : $ticketstatus<br>\n Category : $ticketcategories<br>\n Severity : $ticketseverities<br>\n Priority : $ticketpriorities<br><br>\n Description : <br>$description<br><br>\n Solution : <br>$solution<br>\n The comments are : <br>\n $allComments<br><br>\n Regards<br>Support Administrator";s:10:"workflowId";s:2:"23";}'), (28, 24, 'Ticket Creation From CRM : Send Email to Contact', 'O:11:"VTEmailTask":9:{s:18:"executeImmediately";s:1:"0";s:7:"summary";s:48:"Ticket Creation From CRM : Send Email to Contact";s:6:"active";s:1:"1";s:2:"id";s:2:"28";s:9:"fromEmail";s:93:"$(general : (__VtigerMeta__) supportName)<$(general : (__VtigerMeta__) supportEmailId)>";s:9:"recepient";s:33:",$(contact_id : (Contacts) email)";s:7:"subject";s:79:"$ticket_no [ Ticket Id : $(general : (__VtigerMeta__) recordId) ] $ticket_title";s:7:"content";s:624:"Ticket ID : $(general : (__VtigerMeta__) recordId)<br>Ticket Title : $ticket_title<br><br>\n Dear $(contact_id : (Contacts) lastname) $(contact_id : (Contacts) firstname),<br><br>\n The Ticket is replied the details are :<br><br>\n Ticket No : $ticket_no<br>\n Status : $ticketstatus<br>\n Category : $ticketcategories<br>\n Severity : $ticketseverities<br>\n Priority : $ticketpriorities<br><br>\n Description : <br>$description<br><br>\n Solution : <br>$solution<br>\n The comments are : <br>\n $allComments<br><br>\n Regards<br>Support Administrator";s:10:"workflowId";s:2:"24";}');
-- -- Table structure for table `vtiger_emaildetails` --
CREATE TABLE `vtiger_emaildetails` ( `emailid` int(19) NOT NULL, `from_email` varchar(50) NOT NULL DEFAULT '', `to_email` text NOT NULL, `cc_email` text NOT NULL, `bcc_email` text NOT NULL, `assigned_user_email` varchar(50) NOT NULL DEFAULT '', `idlists` text NOT NULL, `email_flag` varchar(50) NOT NULL DEFAULT '', PRIMARY KEY (`emailid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `vtiger_groups` VALUES (2, 'Team Selling', 'Group Related to Sales'), (3, 'Marketing Group', 'Group Related to Marketing Activities'), (4, 'Support Group', 'Group Related to providing Support to Customers');
-- -- Dumping data for table `vtiger_inventorynotification` --
INSERT INTO `vtiger_inventorynotification` VALUES (1, 'InvoiceNotification', '{PRODUCTNAME} Stock Level is Low', 'Dear {HANDLER},\n\nThe current stock of {PRODUCTNAME} in our warehouse is {CURRENTSTOCK}. Kindly procure required number of units as the stock level is below reorder level {REORDERLEVELVALUE}.\n\nPlease treat this information as Urgent as the invoice is already sent to the customer.\n\nSeverity: Critical\n\nThanks,\n{CURRENTUSER} ', 'InvoiceNotificationDescription', NULL), (2, 'QuoteNotification', 'Quote given for {PRODUCTNAME}', 'Dear {HANDLER},\n\nQuote is generated for {QUOTEQUANTITY} units of {PRODUCTNAME}. The current stock of {PRODUCTNAME} in our warehouse is {CURRENTSTOCK}.\n\nSeverity: Minor\n\nThanks,\n{CURRENTUSER} ', 'QuoteNotificationDescription', NULL), (3, 'SalesOrderNotification', 'Sales Order generated for {PRODUCTNAME}', 'Dear {HANDLER},\n\nSalesOrder is generated for {SOQUANTITY} units of {PRODUCTNAME}. The current stock of {PRODUCTNAME} in our warehouse is {CURRENTSTOCK}.\n\nPlease treat this information with priority as the sales order is already generated.\n\nSeverity: Major\n\nThanks,\n{CURRENTUSER} ', 'SalesOrderNotificationDescription', NULL);
-- -- Dumping data for table `vtiger_inventory_tandc` --
INSERT INTO `vtiger_inventory_tandc` VALUES (2, 'Invoice', '\n - Unless otherwise agreed in writing by the supplier all invoices are payable within thirty (30) days of the date of invoice, in the currency of the invoice, drawn on a bank based in India or by such other method as is agreed in advance by the Supplier.\n\n - All prices are not inclusive of VAT which shall be payable in addition by the Customer at the applicable rate.'), (3, 'Quotes', '\n - Unless otherwise agreed in writing by the supplier all invoices are payable within thirty (30) days of the date of invoice, in the currency of the invoice, drawn on a bank based in India or by such other method as is agreed in advance by the Supplier.\n\n - All prices are not inclusive of VAT which shall be payable in addition by the Customer at the applicable rate.'), (4, 'PurchaseOrder', '\n - Unless otherwise agreed in writing by the supplier all invoices are payable within thirty (30) days of the date of invoice, in the currency of the invoice, drawn on a bank based in India or by such other method as is agreed in advance by the Supplier.\n\n - All prices are not inclusive of VAT which shall be payable in addition by the Customer at the applicable rate.'), (5, 'SalesOrder', '\n - Unless otherwise agreed in writing by the supplier all invoices are payable within thirty (30) days of the date of invoice, in the currency of the invoice, drawn on a bank based in India or by such other method as is agreed in advance by the Supplier.\n\n - All prices are not inclusive of VAT which shall be payable in addition by the Customer at the applicable rate.');
INSERT INTO `vtiger_profile` VALUES (1, 'Administrator', 'Admin Profile', 0), (2, 'Sales Profile', 'Profile Related to Sales', 0), (3, 'Support Profile', 'Profile Related to Support', 0), (4, 'Guest Profile', 'Guest Profile for Test Users', 0);
-- -- Table structure for table `vtiger_ws_userauthtoken` --
CREATE TABLE `vtiger_ws_userauthtoken` ( `userid` int(19) NOT NULL, `token` varchar(36) NOT NULL, `expiretime` int(19) NOT NULL, PRIMARY KEY (`userid`,`expiretime`), UNIQUE KEY `userid_idx` (`userid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- -- Constraints for dumped tables --
-- -- Constraints for table `vtiger_account` -- ALTER TABLE `vtiger_account` ADD CONSTRAINT `fk_1_vtiger_account` FOREIGN KEY (`accountid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_accountbillads` -- ALTER TABLE `vtiger_accountbillads` ADD CONSTRAINT `fk_1_vtiger_accountbillads` FOREIGN KEY (`accountaddressid`) REFERENCES `vtiger_account` (`accountid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_accountscf` -- ALTER TABLE `vtiger_accountscf` ADD CONSTRAINT `fk_1_vtiger_accountscf` FOREIGN KEY (`accountid`) REFERENCES `vtiger_account` (`accountid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_accountshipads` -- ALTER TABLE `vtiger_accountshipads` ADD CONSTRAINT `fk_1_vtiger_accountshipads` FOREIGN KEY (`accountaddressid`) REFERENCES `vtiger_account` (`accountid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_activity` -- ALTER TABLE `vtiger_activity` ADD CONSTRAINT `fk_1_vtiger_activity` FOREIGN KEY (`activityid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_activitycf` -- ALTER TABLE `vtiger_activitycf` ADD CONSTRAINT `fk_activityid_vtiger_activitycf` FOREIGN KEY (`activityid`) REFERENCES `vtiger_activity` (`activityid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_activityproductrel` -- ALTER TABLE `vtiger_activityproductrel` ADD CONSTRAINT `fk_2_vtiger_activityproductrel` FOREIGN KEY (`productid`) REFERENCES `vtiger_products` (`productid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_activity_reminder` -- ALTER TABLE `vtiger_activity_reminder` ADD CONSTRAINT `fk_activityid_vtiger_activity_reminder` FOREIGN KEY (`activity_id`) REFERENCES `vtiger_activity` (`activityid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_app2tab` -- ALTER TABLE `vtiger_app2tab` ADD CONSTRAINT `vtiger_app2tab_fk_tab` FOREIGN KEY (`tabid`) REFERENCES `vtiger_tab` (`tabid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_assets` -- ALTER TABLE `vtiger_assets` ADD CONSTRAINT `fk_1_vtiger_assets` FOREIGN KEY (`assetsid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_assetscf` -- ALTER TABLE `vtiger_assetscf` ADD CONSTRAINT `fk_assetsid_vtiger_assetscf` FOREIGN KEY (`assetsid`) REFERENCES `vtiger_assets` (`assetsid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_attachments` -- ALTER TABLE `vtiger_attachments` ADD CONSTRAINT `fk_1_vtiger_attachments` FOREIGN KEY (`attachmentsid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_blocks` -- ALTER TABLE `vtiger_blocks` ADD CONSTRAINT `fk_1_vtiger_blocks` FOREIGN KEY (`tabid`) REFERENCES `vtiger_tab` (`tabid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_campaign` -- ALTER TABLE `vtiger_campaign` ADD CONSTRAINT `fk_crmid_vtiger_campaign` FOREIGN KEY (`campaignid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_campaigncontrel` -- ALTER TABLE `vtiger_campaigncontrel` ADD CONSTRAINT `fk_2_vtiger_campaigncontrel` FOREIGN KEY (`contactid`) REFERENCES `vtiger_contactdetails` (`contactid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_campaignleadrel` -- ALTER TABLE `vtiger_campaignleadrel` ADD CONSTRAINT `fk_2_vtiger_campaignleadrel` FOREIGN KEY (`leadid`) REFERENCES `vtiger_leaddetails` (`leadid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_campaignscf` -- ALTER TABLE `vtiger_campaignscf` ADD CONSTRAINT `fk_1_vtiger_campaignscf` FOREIGN KEY (`campaignid`) REFERENCES `vtiger_campaign` (`campaignid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_cntactivityrel` -- ALTER TABLE `vtiger_cntactivityrel` ADD CONSTRAINT `fk_2_vtiger_cntactivityrel` FOREIGN KEY (`contactid`) REFERENCES `vtiger_contactdetails` (`contactid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_contactaddress` -- ALTER TABLE `vtiger_contactaddress` ADD CONSTRAINT `fk_1_vtiger_contactaddress` FOREIGN KEY (`contactaddressid`) REFERENCES `vtiger_contactdetails` (`contactid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_contactdetails` -- ALTER TABLE `vtiger_contactdetails` ADD CONSTRAINT `fk_1_vtiger_contactdetails` FOREIGN KEY (`contactid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_contactscf` -- ALTER TABLE `vtiger_contactscf` ADD CONSTRAINT `fk_1_vtiger_contactscf` FOREIGN KEY (`contactid`) REFERENCES `vtiger_contactdetails` (`contactid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_contactsubdetails` -- ALTER TABLE `vtiger_contactsubdetails` ADD CONSTRAINT `fk_1_vtiger_contactsubdetails` FOREIGN KEY (`contactsubscriptionid`) REFERENCES `vtiger_contactdetails` (`contactid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_contpotentialrel` -- ALTER TABLE `vtiger_contpotentialrel` ADD CONSTRAINT `fk_2_vtiger_contpotentialrel` FOREIGN KEY (`potentialid`) REFERENCES `vtiger_potential` (`potentialid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_crmentity_user_field` -- ALTER TABLE `vtiger_crmentity_user_field` ADD CONSTRAINT `fk_vtiger_crmentity_user_field_recordid` FOREIGN KEY (`recordid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_customaction` -- ALTER TABLE `vtiger_customaction` ADD CONSTRAINT `fk_1_vtiger_customaction` FOREIGN KEY (`cvid`) REFERENCES `vtiger_customview` (`cvid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_customerdetails` -- ALTER TABLE `vtiger_customerdetails` ADD CONSTRAINT `fk_1_vtiger_customerdetails` FOREIGN KEY (`customerid`) REFERENCES `vtiger_contactdetails` (`contactid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_customview` -- ALTER TABLE `vtiger_customview` ADD CONSTRAINT `fk_1_vtiger_customview` FOREIGN KEY (`entitytype`) REFERENCES `vtiger_tab` (`name`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_cv2group` -- ALTER TABLE `vtiger_cv2group` ADD CONSTRAINT `vtiger_customview_ibfk_2` FOREIGN KEY (`cvid`) REFERENCES `vtiger_customview` (`cvid`) ON DELETE CASCADE, ADD CONSTRAINT `vtiger_groups_ibfk_1` FOREIGN KEY (`groupid`) REFERENCES `vtiger_groups` (`groupid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_cv2role` -- ALTER TABLE `vtiger_cv2role` ADD CONSTRAINT `vtiger_customview_ibfk_3` FOREIGN KEY (`cvid`) REFERENCES `vtiger_customview` (`cvid`) ON DELETE CASCADE, ADD CONSTRAINT `vtiger_role_ibfk_1` FOREIGN KEY (`roleid`) REFERENCES `vtiger_role` (`roleid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_cv2rs` -- ALTER TABLE `vtiger_cv2rs` ADD CONSTRAINT `vtiger_customview_ibfk_4` FOREIGN KEY (`cvid`) REFERENCES `vtiger_customview` (`cvid`) ON DELETE CASCADE, ADD CONSTRAINT `vtiger_rolesd_ibfk_1` FOREIGN KEY (`rsid`) REFERENCES `vtiger_role` (`roleid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_cv2users` -- ALTER TABLE `vtiger_cv2users` ADD CONSTRAINT `vtiger_customview_ibfk_1` FOREIGN KEY (`cvid`) REFERENCES `vtiger_customview` (`cvid`) ON DELETE CASCADE, ADD CONSTRAINT `vtiger_users_ibfk_1` FOREIGN KEY (`userid`) REFERENCES `vtiger_users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_cvadvfilter` -- ALTER TABLE `vtiger_cvadvfilter` ADD CONSTRAINT `fk_1_vtiger_cvadvfilter` FOREIGN KEY (`cvid`) REFERENCES `vtiger_customview` (`cvid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_cvcolumnlist` -- ALTER TABLE `vtiger_cvcolumnlist` ADD CONSTRAINT `fk_1_vtiger_cvcolumnlist` FOREIGN KEY (`cvid`) REFERENCES `vtiger_customview` (`cvid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_cvstdfilter` -- ALTER TABLE `vtiger_cvstdfilter` ADD CONSTRAINT `fk_1_vtiger_cvstdfilter` FOREIGN KEY (`cvid`) REFERENCES `vtiger_customview` (`cvid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_dashboard_tabs` -- ALTER TABLE `vtiger_dashboard_tabs` ADD CONSTRAINT `vtiger_dashboard_tabs_ibfk_1` FOREIGN KEY (`userid`) REFERENCES `vtiger_users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_datashare_grp2grp` -- ALTER TABLE `vtiger_datashare_grp2grp` ADD CONSTRAINT `fk_3_vtiger_datashare_grp2grp` FOREIGN KEY (`to_groupid`) REFERENCES `vtiger_groups` (`groupid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_datashare_grp2role` -- ALTER TABLE `vtiger_datashare_grp2role` ADD CONSTRAINT `fk_3_vtiger_datashare_grp2role` FOREIGN KEY (`to_roleid`) REFERENCES `vtiger_role` (`roleid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_datashare_grp2rs` -- ALTER TABLE `vtiger_datashare_grp2rs` ADD CONSTRAINT `fk_3_vtiger_datashare_grp2rs` FOREIGN KEY (`to_roleandsubid`) REFERENCES `vtiger_role` (`roleid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_datashare_module_rel` -- ALTER TABLE `vtiger_datashare_module_rel` ADD CONSTRAINT `fk_1_vtiger_datashare_module_rel` FOREIGN KEY (`tabid`) REFERENCES `vtiger_tab` (`tabid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_datashare_relatedmodules` -- ALTER TABLE `vtiger_datashare_relatedmodules` ADD CONSTRAINT `fk_2_vtiger_datashare_relatedmodules` FOREIGN KEY (`tabid`) REFERENCES `vtiger_tab` (`tabid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_datashare_role2group` -- ALTER TABLE `vtiger_datashare_role2group` ADD CONSTRAINT `fk_3_vtiger_datashare_role2group` FOREIGN KEY (`share_roleid`) REFERENCES `vtiger_role` (`roleid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_datashare_role2role` -- ALTER TABLE `vtiger_datashare_role2role` ADD CONSTRAINT `fk_3_vtiger_datashare_role2role` FOREIGN KEY (`to_roleid`) REFERENCES `vtiger_role` (`roleid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_datashare_role2rs` -- ALTER TABLE `vtiger_datashare_role2rs` ADD CONSTRAINT `fk_3_vtiger_datashare_role2rs` FOREIGN KEY (`to_roleandsubid`) REFERENCES `vtiger_role` (`roleid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_datashare_rs2grp` -- ALTER TABLE `vtiger_datashare_rs2grp` ADD CONSTRAINT `fk_3_vtiger_datashare_rs2grp` FOREIGN KEY (`share_roleandsubid`) REFERENCES `vtiger_role` (`roleid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_datashare_rs2role` -- ALTER TABLE `vtiger_datashare_rs2role` ADD CONSTRAINT `fk_3_vtiger_datashare_rs2role` FOREIGN KEY (`to_roleid`) REFERENCES `vtiger_role` (`roleid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_datashare_rs2rs` -- ALTER TABLE `vtiger_datashare_rs2rs` ADD CONSTRAINT `fk_3_vtiger_datashare_rs2rs` FOREIGN KEY (`to_roleandsubid`) REFERENCES `vtiger_role` (`roleid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_defaultcv` -- ALTER TABLE `vtiger_defaultcv` ADD CONSTRAINT `fk_1_vtiger_defaultcv` FOREIGN KEY (`tabid`) REFERENCES `vtiger_tab` (`tabid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_def_org_share` -- ALTER TABLE `vtiger_def_org_share` ADD CONSTRAINT `fk_1_vtiger_def_org_share` FOREIGN KEY (`permission`) REFERENCES `vtiger_org_share_action_mapping` (`share_action_id`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_emailslookup` -- ALTER TABLE `vtiger_emailslookup` ADD CONSTRAINT `emailslookup_crmid_fk` FOREIGN KEY (`crmid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_entityname` -- ALTER TABLE `vtiger_entityname` ADD CONSTRAINT `fk_1_vtiger_entityname` FOREIGN KEY (`tabid`) REFERENCES `vtiger_tab` (`tabid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_faq` -- ALTER TABLE `vtiger_faq` ADD CONSTRAINT `fk_1_vtiger_faq` FOREIGN KEY (`id`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_faqcf` -- ALTER TABLE `vtiger_faqcf` ADD CONSTRAINT `fk_1_vtiger_faqcf` FOREIGN KEY (`faqid`) REFERENCES `vtiger_faq` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_faqcomments` -- ALTER TABLE `vtiger_faqcomments` ADD CONSTRAINT `fk_1_vtiger_faqcomments` FOREIGN KEY (`faqid`) REFERENCES `vtiger_faq` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_field` -- ALTER TABLE `vtiger_field` ADD CONSTRAINT `fk_1_vtiger_field` FOREIGN KEY (`tabid`) REFERENCES `vtiger_tab` (`tabid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_group2grouprel` -- ALTER TABLE `vtiger_group2grouprel` ADD CONSTRAINT `fk_2_vtiger_group2grouprel` FOREIGN KEY (`groupid`) REFERENCES `vtiger_groups` (`groupid`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `vtiger_group2role` -- ALTER TABLE `vtiger_group2role` ADD CONSTRAINT `fk_2_vtiger_group2role` FOREIGN KEY (`roleid`) REFERENCES `vtiger_role` (`roleid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_group2rs` -- ALTER TABLE `vtiger_group2rs` ADD CONSTRAINT `fk_2_vtiger_group2rs` FOREIGN KEY (`roleandsubid`) REFERENCES `vtiger_role` (`roleid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_homedashbd` -- ALTER TABLE `vtiger_homedashbd` ADD CONSTRAINT `fk_1_vtiger_homedashbd` FOREIGN KEY (`stuffid`) REFERENCES `vtiger_homestuff` (`stuffid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_homedefault` -- ALTER TABLE `vtiger_homedefault` ADD CONSTRAINT `fk_1_vtiger_homedefault` FOREIGN KEY (`stuffid`) REFERENCES `vtiger_homestuff` (`stuffid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_homemodule` -- ALTER TABLE `vtiger_homemodule` ADD CONSTRAINT `fk_1_vtiger_homemodule` FOREIGN KEY (`stuffid`) REFERENCES `vtiger_homestuff` (`stuffid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_homemoduleflds` -- ALTER TABLE `vtiger_homemoduleflds` ADD CONSTRAINT `fk_1_vtiger_homemoduleflds` FOREIGN KEY (`stuffid`) REFERENCES `vtiger_homemodule` (`stuffid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_homerss` -- ALTER TABLE `vtiger_homerss` ADD CONSTRAINT `fk_1_vtiger_homerss` FOREIGN KEY (`stuffid`) REFERENCES `vtiger_homestuff` (`stuffid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_homestuff` -- ALTER TABLE `vtiger_homestuff` ADD CONSTRAINT `fk_1_vtiger_homestuff` FOREIGN KEY (`userid`) REFERENCES `vtiger_users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_inventoryproductrel` -- ALTER TABLE `vtiger_inventoryproductrel` ADD CONSTRAINT `fk_crmid_vtiger_inventoryproductrel` FOREIGN KEY (`id`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_invoice` -- ALTER TABLE `vtiger_invoice` ADD CONSTRAINT `fk_2_vtiger_invoice` FOREIGN KEY (`salesorderid`) REFERENCES `vtiger_salesorder` (`salesorderid`) ON DELETE CASCADE, ADD CONSTRAINT `fk_crmid_vtiger_invoice` FOREIGN KEY (`invoiceid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_invoicebillads` -- ALTER TABLE `vtiger_invoicebillads` ADD CONSTRAINT `fk_1_vtiger_invoicebillads` FOREIGN KEY (`invoicebilladdressid`) REFERENCES `vtiger_invoice` (`invoiceid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_invoicecf` -- ALTER TABLE `vtiger_invoicecf` ADD CONSTRAINT `fk_1_vtiger_invoicecf` FOREIGN KEY (`invoiceid`) REFERENCES `vtiger_invoice` (`invoiceid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_invoiceshipads` -- ALTER TABLE `vtiger_invoiceshipads` ADD CONSTRAINT `fk_1_vtiger_invoiceshipads` FOREIGN KEY (`invoiceshipaddressid`) REFERENCES `vtiger_invoice` (`invoiceid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_invoicestatushistory` -- ALTER TABLE `vtiger_invoicestatushistory` ADD CONSTRAINT `fk_1_vtiger_invoicestatushistory` FOREIGN KEY (`invoiceid`) REFERENCES `vtiger_invoice` (`invoiceid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_invoice_recurring_info` -- ALTER TABLE `vtiger_invoice_recurring_info` ADD CONSTRAINT `fk_salesorderid_vtiger_invoice_recurring_info` FOREIGN KEY (`salesorderid`) REFERENCES `vtiger_salesorder` (`salesorderid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_leadaddress` -- ALTER TABLE `vtiger_leadaddress` ADD CONSTRAINT `fk_1_vtiger_leadaddress` FOREIGN KEY (`leadaddressid`) REFERENCES `vtiger_leaddetails` (`leadid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_leaddetails` -- ALTER TABLE `vtiger_leaddetails` ADD CONSTRAINT `fk_1_vtiger_leaddetails` FOREIGN KEY (`leadid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_leadscf` -- ALTER TABLE `vtiger_leadscf` ADD CONSTRAINT `fk_1_vtiger_leadscf` FOREIGN KEY (`leadid`) REFERENCES `vtiger_leaddetails` (`leadid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_leadsubdetails` -- ALTER TABLE `vtiger_leadsubdetails` ADD CONSTRAINT `fk_1_vtiger_leadsubdetails` FOREIGN KEY (`leadsubscriptionid`) REFERENCES `vtiger_leaddetails` (`leadid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_modcomments` -- ALTER TABLE `vtiger_modcomments` ADD CONSTRAINT `fk_crmid_vtiger_modcomments` FOREIGN KEY (`modcommentsid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_modcommentscf` -- ALTER TABLE `vtiger_modcommentscf` ADD CONSTRAINT `fk_modcommentsid_vtiger_modcommentscf` FOREIGN KEY (`modcommentsid`) REFERENCES `vtiger_modcomments` (`modcommentsid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_module_dashboard_widgets` -- ALTER TABLE `vtiger_module_dashboard_widgets` ADD CONSTRAINT `vtiger_module_dashboard_widgets_ibfk_1` FOREIGN KEY (`dashboardtabid`) REFERENCES `vtiger_dashboard_tabs` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_notes` -- ALTER TABLE `vtiger_notes` ADD CONSTRAINT `fk_1_vtiger_notes` FOREIGN KEY (`notesid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_notescf` -- ALTER TABLE `vtiger_notescf` ADD CONSTRAINT `fk_notesid_vtiger_notescf` FOREIGN KEY (`notesid`) REFERENCES `vtiger_notes` (`notesid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_org_share_action2tab` -- ALTER TABLE `vtiger_org_share_action2tab` ADD CONSTRAINT `fk_2_vtiger_org_share_action2tab` FOREIGN KEY (`tabid`) REFERENCES `vtiger_tab` (`tabid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_parenttabrel` -- ALTER TABLE `vtiger_parenttabrel` ADD CONSTRAINT `fk_1_vtiger_parenttabrel` FOREIGN KEY (`tabid`) REFERENCES `vtiger_tab` (`tabid`) ON DELETE CASCADE, ADD CONSTRAINT `fk_2_vtiger_parenttabrel` FOREIGN KEY (`parenttabid`) REFERENCES `vtiger_parenttab` (`parenttabid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_pbxmanager` -- ALTER TABLE `vtiger_pbxmanager` ADD CONSTRAINT `fk_crmid_vtiger_pbxmanager` FOREIGN KEY (`pbxmanagerid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_pbxmanagercf` -- ALTER TABLE `vtiger_pbxmanagercf` ADD CONSTRAINT `fk_pbxmanagerid_vtiger_pbxmanagercf` FOREIGN KEY (`pbxmanagerid`) REFERENCES `vtiger_pbxmanager` (`pbxmanagerid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_pbxmanager_phonelookup` -- ALTER TABLE `vtiger_pbxmanager_phonelookup` ADD CONSTRAINT `vtiger_pbxmanager_phonelookup_ibfk_1` FOREIGN KEY (`crmid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_pobillads` -- ALTER TABLE `vtiger_pobillads` ADD CONSTRAINT `fk_1_vtiger_pobillads` FOREIGN KEY (`pobilladdressid`) REFERENCES `vtiger_purchaseorder` (`purchaseorderid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_portalinfo` -- ALTER TABLE `vtiger_portalinfo` ADD CONSTRAINT `fk_1_vtiger_portalinfo` FOREIGN KEY (`id`) REFERENCES `vtiger_contactdetails` (`contactid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_poshipads` -- ALTER TABLE `vtiger_poshipads` ADD CONSTRAINT `fk_1_vtiger_poshipads` FOREIGN KEY (`poshipaddressid`) REFERENCES `vtiger_purchaseorder` (`purchaseorderid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_postatushistory` -- ALTER TABLE `vtiger_postatushistory` ADD CONSTRAINT `fk_1_vtiger_postatushistory` FOREIGN KEY (`purchaseorderid`) REFERENCES `vtiger_purchaseorder` (`purchaseorderid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_potential` -- ALTER TABLE `vtiger_potential` ADD CONSTRAINT `fk_1_vtiger_potential` FOREIGN KEY (`potentialid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_potentialscf` -- ALTER TABLE `vtiger_potentialscf` ADD CONSTRAINT `fk_1_vtiger_potentialscf` FOREIGN KEY (`potentialid`) REFERENCES `vtiger_potential` (`potentialid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_potstagehistory` -- ALTER TABLE `vtiger_potstagehistory` ADD CONSTRAINT `fk_1_vtiger_potstagehistory` FOREIGN KEY (`potentialid`) REFERENCES `vtiger_potential` (`potentialid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_pricebook` -- ALTER TABLE `vtiger_pricebook` ADD CONSTRAINT `fk_1_vtiger_pricebook` FOREIGN KEY (`pricebookid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_pricebookcf` -- ALTER TABLE `vtiger_pricebookcf` ADD CONSTRAINT `fk_1_vtiger_pricebookcf` FOREIGN KEY (`pricebookid`) REFERENCES `vtiger_pricebook` (`pricebookid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_pricebookproductrel` -- ALTER TABLE `vtiger_pricebookproductrel` ADD CONSTRAINT `fk_1_vtiger_pricebookproductrel` FOREIGN KEY (`pricebookid`) REFERENCES `vtiger_pricebook` (`pricebookid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_productcf` -- ALTER TABLE `vtiger_productcf` ADD CONSTRAINT `fk_1_vtiger_productcf` FOREIGN KEY (`productid`) REFERENCES `vtiger_products` (`productid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_products` -- ALTER TABLE `vtiger_products` ADD CONSTRAINT `fk_1_vtiger_products` FOREIGN KEY (`productid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_producttaxrel` -- ALTER TABLE `vtiger_producttaxrel` ADD CONSTRAINT `fk_crmid_vtiger_producttaxrel` FOREIGN KEY (`productid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_profile2globalpermissions` -- ALTER TABLE `vtiger_profile2globalpermissions` ADD CONSTRAINT `fk_1_vtiger_profile2globalpermissions` FOREIGN KEY (`profileid`) REFERENCES `vtiger_profile` (`profileid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_project` -- ALTER TABLE `vtiger_project` ADD CONSTRAINT `fk_crmid_vtiger_project` FOREIGN KEY (`projectid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_projectcf` -- ALTER TABLE `vtiger_projectcf` ADD CONSTRAINT `fk_projectid_vtiger_projectcf` FOREIGN KEY (`projectid`) REFERENCES `vtiger_project` (`projectid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_projectmilestone` -- ALTER TABLE `vtiger_projectmilestone` ADD CONSTRAINT `fk_crmid_vtiger_projectmilestone` FOREIGN KEY (`projectmilestoneid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_projectmilestonecf` -- ALTER TABLE `vtiger_projectmilestonecf` ADD CONSTRAINT `fk_projectmilestoneid_vtiger_projectmilestonecf` FOREIGN KEY (`projectmilestoneid`) REFERENCES `vtiger_projectmilestone` (`projectmilestoneid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_projecttask` -- ALTER TABLE `vtiger_projecttask` ADD CONSTRAINT `fk_crmid_vtiger_projecttask` FOREIGN KEY (`projecttaskid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_projecttaskcf` -- ALTER TABLE `vtiger_projecttaskcf` ADD CONSTRAINT `fk_projecttaskid_vtiger_projecttaskcf` FOREIGN KEY (`projecttaskid`) REFERENCES `vtiger_projecttask` (`projecttaskid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_purchaseorder` -- ALTER TABLE `vtiger_purchaseorder` ADD CONSTRAINT `fk_4_vtiger_purchaseorder` FOREIGN KEY (`vendorid`) REFERENCES `vtiger_vendor` (`vendorid`) ON DELETE CASCADE, ADD CONSTRAINT `fk_crmid_vtiger_purchaseorder` FOREIGN KEY (`purchaseorderid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_purchaseordercf` -- ALTER TABLE `vtiger_purchaseordercf` ADD CONSTRAINT `fk_1_vtiger_purchaseordercf` FOREIGN KEY (`purchaseorderid`) REFERENCES `vtiger_purchaseorder` (`purchaseorderid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_quotes` -- ALTER TABLE `vtiger_quotes` ADD CONSTRAINT `fk_3_vtiger_quotes` FOREIGN KEY (`potentialid`) REFERENCES `vtiger_potential` (`potentialid`) ON DELETE CASCADE, ADD CONSTRAINT `fk_crmid_vtiger_quotes` FOREIGN KEY (`quoteid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_quotesbillads` -- ALTER TABLE `vtiger_quotesbillads` ADD CONSTRAINT `fk_1_vtiger_quotesbillads` FOREIGN KEY (`quotebilladdressid`) REFERENCES `vtiger_quotes` (`quoteid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_quotescf` -- ALTER TABLE `vtiger_quotescf` ADD CONSTRAINT `fk_1_vtiger_quotescf` FOREIGN KEY (`quoteid`) REFERENCES `vtiger_quotes` (`quoteid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_quotesshipads` -- ALTER TABLE `vtiger_quotesshipads` ADD CONSTRAINT `fk_1_vtiger_quotesshipads` FOREIGN KEY (`quoteshipaddressid`) REFERENCES `vtiger_quotes` (`quoteid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_quotestagehistory` -- ALTER TABLE `vtiger_quotestagehistory` ADD CONSTRAINT `fk_1_vtiger_quotestagehistory` FOREIGN KEY (`quoteid`) REFERENCES `vtiger_quotes` (`quoteid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_recurringevents` -- ALTER TABLE `vtiger_recurringevents` ADD CONSTRAINT `fk_1_vtiger_recurringevents` FOREIGN KEY (`activityid`) REFERENCES `vtiger_activity` (`activityid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_relcriteria` -- ALTER TABLE `vtiger_relcriteria` ADD CONSTRAINT `fk_1_vtiger_relcriteria` FOREIGN KEY (`queryid`) REFERENCES `vtiger_selectquery` (`queryid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_report` -- ALTER TABLE `vtiger_report` ADD CONSTRAINT `fk_2_vtiger_report` FOREIGN KEY (`queryid`) REFERENCES `vtiger_selectquery` (`queryid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_reportdatefilter` -- ALTER TABLE `vtiger_reportdatefilter` ADD CONSTRAINT `fk_1_vtiger_reportdatefilter` FOREIGN KEY (`datefilterid`) REFERENCES `vtiger_report` (`reportid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_reportgroupbycolumn` -- ALTER TABLE `vtiger_reportgroupbycolumn` ADD CONSTRAINT `fk_1_vtiger_reportgroupbycolumn` FOREIGN KEY (`reportid`) REFERENCES `vtiger_report` (`reportid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_reportmodules` -- ALTER TABLE `vtiger_reportmodules` ADD CONSTRAINT `fk_1_vtiger_reportmodules` FOREIGN KEY (`reportmodulesid`) REFERENCES `vtiger_report` (`reportid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_reportsortcol` -- ALTER TABLE `vtiger_reportsortcol` ADD CONSTRAINT `fk_1_vtiger_reportsortcol` FOREIGN KEY (`reportid`) REFERENCES `vtiger_report` (`reportid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_reportsummary` -- ALTER TABLE `vtiger_reportsummary` ADD CONSTRAINT `fk_1_vtiger_reportsummary` FOREIGN KEY (`reportsummaryid`) REFERENCES `vtiger_report` (`reportid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_reporttype` -- ALTER TABLE `vtiger_reporttype` ADD CONSTRAINT `fk_1_vtiger_reporttype` FOREIGN KEY (`reportid`) REFERENCES `vtiger_report` (`reportid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_report_sharegroups` -- ALTER TABLE `vtiger_report_sharegroups` ADD CONSTRAINT `vtiger_groups_groupid_ibfk_1` FOREIGN KEY (`groupid`) REFERENCES `vtiger_groups` (`groupid`) ON DELETE CASCADE, ADD CONSTRAINT `vtiger_report_reportid_ibfk_2` FOREIGN KEY (`reportid`) REFERENCES `vtiger_report` (`reportid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_report_sharerole` -- ALTER TABLE `vtiger_report_sharerole` ADD CONSTRAINT `vtiger_report_reportid_ibfk_3` FOREIGN KEY (`reportid`) REFERENCES `vtiger_report` (`reportid`) ON DELETE CASCADE, ADD CONSTRAINT `vtiger_role_roleid_ibfk_1` FOREIGN KEY (`roleid`) REFERENCES `vtiger_role` (`roleid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_report_sharers` -- ALTER TABLE `vtiger_report_sharers` ADD CONSTRAINT `vtiger_report_reportid_ibfk_4` FOREIGN KEY (`reportid`) REFERENCES `vtiger_report` (`reportid`) ON DELETE CASCADE, ADD CONSTRAINT `vtiger_rolesd_rsid_ibfk_1` FOREIGN KEY (`rsid`) REFERENCES `vtiger_role` (`roleid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_report_shareusers` -- ALTER TABLE `vtiger_report_shareusers` ADD CONSTRAINT `vtiger_reports_reportid_ibfk_1` FOREIGN KEY (`reportid`) REFERENCES `vtiger_report` (`reportid`) ON DELETE CASCADE, ADD CONSTRAINT `vtiger_users_userid_ibfk_1` FOREIGN KEY (`userid`) REFERENCES `vtiger_users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_role2picklist` -- ALTER TABLE `vtiger_role2picklist` ADD CONSTRAINT `fk_1_vtiger_role2picklist` FOREIGN KEY (`roleid`) REFERENCES `vtiger_role` (`roleid`) ON DELETE CASCADE, ADD CONSTRAINT `fk_2_vtiger_role2picklist` FOREIGN KEY (`picklistid`) REFERENCES `vtiger_picklist` (`picklistid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_salesmanactivityrel` -- ALTER TABLE `vtiger_salesmanactivityrel` ADD CONSTRAINT `fk_2_vtiger_salesmanactivityrel` FOREIGN KEY (`smid`) REFERENCES `vtiger_users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_salesmanattachmentsrel` -- ALTER TABLE `vtiger_salesmanattachmentsrel` ADD CONSTRAINT `fk_2_vtiger_salesmanattachmentsrel` FOREIGN KEY (`attachmentsid`) REFERENCES `vtiger_attachments` (`attachmentsid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_salesmanticketrel` -- ALTER TABLE `vtiger_salesmanticketrel` ADD CONSTRAINT `fk_2_vtiger_salesmanticketrel` FOREIGN KEY (`smid`) REFERENCES `vtiger_users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_salesorder` -- ALTER TABLE `vtiger_salesorder` ADD CONSTRAINT `fk_3_vtiger_salesorder` FOREIGN KEY (`vendorid`) REFERENCES `vtiger_vendor` (`vendorid`) ON DELETE CASCADE, ADD CONSTRAINT `fk_crmid_vtiger_salesorder` FOREIGN KEY (`salesorderid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_salesordercf` -- ALTER TABLE `vtiger_salesordercf` ADD CONSTRAINT `fk_1_vtiger_salesordercf` FOREIGN KEY (`salesorderid`) REFERENCES `vtiger_salesorder` (`salesorderid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_seactivityrel` -- ALTER TABLE `vtiger_seactivityrel` ADD CONSTRAINT `fk_2_vtiger_seactivityrel` FOREIGN KEY (`crmid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_seattachmentsrel` -- ALTER TABLE `vtiger_seattachmentsrel` ADD CONSTRAINT `fk_2_vtiger_seattachmentsrel` FOREIGN KEY (`crmid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_selectcolumn` -- ALTER TABLE `vtiger_selectcolumn` ADD CONSTRAINT `fk_1_vtiger_selectcolumn` FOREIGN KEY (`queryid`) REFERENCES `vtiger_selectquery` (`queryid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_senotesrel` -- ALTER TABLE `vtiger_senotesrel` ADD CONSTRAINT `fk1_crmid` FOREIGN KEY (`crmid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE, ADD CONSTRAINT `fk_2_vtiger_senotesrel` FOREIGN KEY (`notesid`) REFERENCES `vtiger_notes` (`notesid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_seproductsrel` -- ALTER TABLE `vtiger_seproductsrel` ADD CONSTRAINT `fk_2_vtiger_seproductsrel` FOREIGN KEY (`productid`) REFERENCES `vtiger_products` (`productid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_service` -- ALTER TABLE `vtiger_service` ADD CONSTRAINT `fk_1_vtiger_service` FOREIGN KEY (`serviceid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_servicecf` -- ALTER TABLE `vtiger_servicecf` ADD CONSTRAINT `fk_serviceid_vtiger_servicecf` FOREIGN KEY (`serviceid`) REFERENCES `vtiger_service` (`serviceid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_servicecontracts` -- ALTER TABLE `vtiger_servicecontracts` ADD CONSTRAINT `fk_crmid_vtiger_servicecontracts` FOREIGN KEY (`servicecontractsid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_servicecontractscf` -- ALTER TABLE `vtiger_servicecontractscf` ADD CONSTRAINT `fk_servicecontractsid_vtiger_servicecontractscf` FOREIGN KEY (`servicecontractsid`) REFERENCES `vtiger_servicecontracts` (`servicecontractsid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_seticketsrel` -- ALTER TABLE `vtiger_seticketsrel` ADD CONSTRAINT `fk_2_vtiger_seticketsrel` FOREIGN KEY (`ticketid`) REFERENCES `vtiger_troubletickets` (`ticketid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_settings_field` -- ALTER TABLE `vtiger_settings_field` ADD CONSTRAINT `fk_1_vtiger_settings_field` FOREIGN KEY (`blockid`) REFERENCES `vtiger_settings_blocks` (`blockid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_smsnotifier` -- ALTER TABLE `vtiger_smsnotifier` ADD CONSTRAINT `fk_crmid_vtiger_smsnotifier` FOREIGN KEY (`smsnotifierid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_smsnotifiercf` -- ALTER TABLE `vtiger_smsnotifiercf` ADD CONSTRAINT `fk_smsnotifierid_vtiger_smsnotifiercf` FOREIGN KEY (`smsnotifierid`) REFERENCES `vtiger_smsnotifier` (`smsnotifierid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_sobillads` -- ALTER TABLE `vtiger_sobillads` ADD CONSTRAINT `fk_1_vtiger_sobillads` FOREIGN KEY (`sobilladdressid`) REFERENCES `vtiger_salesorder` (`salesorderid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_soshipads` -- ALTER TABLE `vtiger_soshipads` ADD CONSTRAINT `fk_1_vtiger_soshipads` FOREIGN KEY (`soshipaddressid`) REFERENCES `vtiger_salesorder` (`salesorderid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_sostatushistory` -- ALTER TABLE `vtiger_sostatushistory` ADD CONSTRAINT `fk_1_vtiger_sostatushistory` FOREIGN KEY (`salesorderid`) REFERENCES `vtiger_salesorder` (`salesorderid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_tab_info` -- ALTER TABLE `vtiger_tab_info` ADD CONSTRAINT `fk_1_vtiger_tab_info` FOREIGN KEY (`tabid`) REFERENCES `vtiger_tab` (`tabid`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `vtiger_ticketcf` -- ALTER TABLE `vtiger_ticketcf` ADD CONSTRAINT `fk_1_vtiger_ticketcf` FOREIGN KEY (`ticketid`) REFERENCES `vtiger_troubletickets` (`ticketid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_ticketcomments` -- ALTER TABLE `vtiger_ticketcomments` ADD CONSTRAINT `fk_1_vtiger_ticketcomments` FOREIGN KEY (`ticketid`) REFERENCES `vtiger_troubletickets` (`ticketid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_tmp_read_group_rel_sharing_per` -- ALTER TABLE `vtiger_tmp_read_group_rel_sharing_per` ADD CONSTRAINT `fk_4_vtiger_tmp_read_group_rel_sharing_per` FOREIGN KEY (`userid`) REFERENCES `vtiger_users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_tmp_read_group_sharing_per` -- ALTER TABLE `vtiger_tmp_read_group_sharing_per` ADD CONSTRAINT `fk_3_vtiger_tmp_read_group_sharing_per` FOREIGN KEY (`userid`) REFERENCES `vtiger_users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_tmp_read_user_rel_sharing_per` -- ALTER TABLE `vtiger_tmp_read_user_rel_sharing_per` ADD CONSTRAINT `fk_4_vtiger_tmp_read_user_rel_sharing_per` FOREIGN KEY (`userid`) REFERENCES `vtiger_users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_tmp_read_user_sharing_per` -- ALTER TABLE `vtiger_tmp_read_user_sharing_per` ADD CONSTRAINT `fk_3_vtiger_tmp_read_user_sharing_per` FOREIGN KEY (`userid`) REFERENCES `vtiger_users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_tmp_write_group_rel_sharing_per` -- ALTER TABLE `vtiger_tmp_write_group_rel_sharing_per` ADD CONSTRAINT `fk_4_vtiger_tmp_write_group_rel_sharing_per` FOREIGN KEY (`userid`) REFERENCES `vtiger_users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_tmp_write_group_sharing_per` -- ALTER TABLE `vtiger_tmp_write_group_sharing_per` ADD CONSTRAINT `fk_3_vtiger_tmp_write_group_sharing_per` FOREIGN KEY (`userid`) REFERENCES `vtiger_users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_tmp_write_user_rel_sharing_per` -- ALTER TABLE `vtiger_tmp_write_user_rel_sharing_per` ADD CONSTRAINT `fk_4_vtiger_tmp_write_user_rel_sharing_per` FOREIGN KEY (`userid`) REFERENCES `vtiger_users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_tmp_write_user_sharing_per` -- ALTER TABLE `vtiger_tmp_write_user_sharing_per` ADD CONSTRAINT `fk_3_vtiger_tmp_write_user_sharing_per` FOREIGN KEY (`userid`) REFERENCES `vtiger_users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_troubletickets` -- ALTER TABLE `vtiger_troubletickets` ADD CONSTRAINT `fk_1_vtiger_troubletickets` FOREIGN KEY (`ticketid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_user2role` -- ALTER TABLE `vtiger_user2role` ADD CONSTRAINT `fk_2_vtiger_user2role` FOREIGN KEY (`userid`) REFERENCES `vtiger_users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_users2group` -- ALTER TABLE `vtiger_users2group` ADD CONSTRAINT `fk_2_vtiger_users2group` FOREIGN KEY (`userid`) REFERENCES `vtiger_users` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_user_module_preferences` -- ALTER TABLE `vtiger_user_module_preferences` ADD CONSTRAINT `fk_2_vtiger_user_module_preferences` FOREIGN KEY (`tabid`) REFERENCES `vtiger_tab` (`tabid`) ON DELETE CASCADE ON UPDATE CASCADE;
-- -- Constraints for table `vtiger_vendor` -- ALTER TABLE `vtiger_vendor` ADD CONSTRAINT `fk_1_vtiger_vendor` FOREIGN KEY (`vendorid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_vendorcf` -- ALTER TABLE `vtiger_vendorcf` ADD CONSTRAINT `fk_1_vtiger_vendorcf` FOREIGN KEY (`vendorid`) REFERENCES `vtiger_vendor` (`vendorid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_vendorcontactrel` -- ALTER TABLE `vtiger_vendorcontactrel` ADD CONSTRAINT `fk_2_vtiger_vendorcontactrel` FOREIGN KEY (`vendorid`) REFERENCES `vtiger_vendor` (`vendorid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_webforms_field` -- ALTER TABLE `vtiger_webforms_field` ADD CONSTRAINT `fk_1_vtiger_webforms_field` FOREIGN KEY (`webformid`) REFERENCES `vtiger_webforms` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `fk_3_vtiger_webforms_field` FOREIGN KEY (`fieldname`) REFERENCES `vtiger_field` (`fieldname`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_webform_file_fields` -- ALTER TABLE `vtiger_webform_file_fields` ADD CONSTRAINT `fk_vtiger_webforms` FOREIGN KEY (`webformid`) REFERENCES `vtiger_webforms` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_wsapp_logs_details` -- ALTER TABLE `vtiger_wsapp_logs_details` ADD CONSTRAINT `vtiger_wsapp_logs_basic_ibfk_1` FOREIGN KEY (`id`) REFERENCES `vtiger_wsapp_logs_basic` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_ws_entity_referencetype` -- ALTER TABLE `vtiger_ws_entity_referencetype` ADD CONSTRAINT `vtiger_fk_1_actors_referencetype` FOREIGN KEY (`fieldtypeid`) REFERENCES `vtiger_ws_entity_fieldtype` (`fieldtypeid`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_ws_entity_tables` -- ALTER TABLE `vtiger_ws_entity_tables` ADD CONSTRAINT `fk_1_vtiger_ws_actor_tables` FOREIGN KEY (`webservice_entity_id`) REFERENCES `vtiger_ws_entity` (`id`) ON DELETE CASCADE;
-- -- Constraints for table `vtiger_ws_referencetype` -- ALTER TABLE `vtiger_ws_referencetype` ADD CONSTRAINT `fk_1_vtiger_referencetype` FOREIGN KEY (`fieldtypeid`) REFERENCES `vtiger_ws_fieldtype` (`fieldtypeid`) ON DELETE CASCADE;
/*!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 */;