prime:/home/cyberorg/Desktop # diff -u vtigercrm502_1.sql vtigercrm502_1\(2\).sql --- vtigercrm502_1.sql 2007-02-12 21:29:32.000000000 +0530 +++ vtigercrm502_1(2).sql 2007-02-12 21:32:32.000000000 +0530 @@ -3,7 +3,7 @@ -- http://www.phpmyadmin.net -- -- Host: localhost --- Generation Time: Feb 12, 2007 at 09:29 PM +-- Generation Time: Feb 12, 2007 at 09:32 PM -- Server version: 5.0.18 -- PHP Version: 5.1.2 -- @@ -5559,7 +5559,14 @@ (4888, 1, 'Accounts', 'AccountsAjax', '', '2007-02-12 21:26:31'), (4889, 1, 'Reports', 'index', '', '2007-02-12 21:26:44'), (4890, 1, 'Reports', 'SaveAndRun', '25', '2007-02-12 21:27:16'), -(4891, 1, 'Reports', 'index', '', '2007-02-12 21:27:26'); +(4891, 1, 'Reports', 'index', '', '2007-02-12 21:27:26'), +(4892, 1, 'Home', 'index', '', '2007-02-12 21:30:04'), +(4893, 1, 'Dashboard', 'DashboardAjax', '', '2007-02-12 21:30:08'), +(4894, 1, 'Reports', 'index', '', '2007-02-12 21:30:10'), +(4895, 1, 'Reports', 'ReportsAjax', '', '2007-02-12 21:30:27'), +(4896, 1, 'Reports', 'ReportsAjax', '', '2007-02-12 21:30:53'), +(4897, 1, 'Reports', 'Save', '', '2007-02-12 21:31:51'), +(4898, 1, 'Reports', 'index', '', '2007-02-12 21:31:53'); -- -------------------------------------------------------- @@ -5576,7 +5583,7 @@ -- INSERT INTO `vtiger_audit_trial_seq` (`id`) VALUES -(4891); +(4898); -- -------------------------------------------------------- @@ -15251,7 +15258,12 @@ (34, 1, '', '', ''), (34, 2, '', '', ''), (34, 3, '', '', ''), -(34, 4, '', '', ''); +(34, 4, '', '', ''), +(38, 0, 'vtiger_accountSalesOrder:accountname:SalesOrder_Account_Name:account_id:I', 'e', 'VRG'), +(38, 1, '', '', ''), +(38, 2, '', '', ''), +(38, 3, '', '', ''), +(38, 4, '', '', ''); -- -------------------------------------------------------- @@ -15304,7 +15316,8 @@ (25, 12, 'Bennet', 'Bennet Monthly', 'summary', 25, 'CUSTOM', 1, 1), (27, 12, 'OSCAR', 'Oscar Monthly', 'summary', 27, 'CUSTOM', 1, 1), (28, 12, 'ALEMBIC PHARMA', 'Alembic Monthly', 'summary', 28, 'CUSTOM', 1, 1), -(34, 12, 'CYBERORG INFO', 'Monthly Billing', 'summary', 34, 'CUSTOM', 1, 1); +(34, 12, 'CYBERORG INFO', 'Monthly Billing', 'summary', 34, 'CUSTOM', 1, 1), +(38, 12, 'VRG', 'VRG Billing', 'summary', 38, 'CUSTOM', 1, 1); -- -------------------------------------------------------- @@ -15335,7 +15348,8 @@ (25, 'vtiger_crmentitySalesOrder:createdtime:SalesOrder_Created_Time', 'thisfy', '2007-01-01', '2007-12-31'), (27, 'vtiger_salesorder:duedate:SalesOrder_Due_Date', 'thisfy', '2007-01-01', '2007-12-31'), (28, 'vtiger_salesorder:duedate:SalesOrder_Due_Date', 'custom', '0000-00-00', '0000-00-00'), -(34, 'vtiger_salesorder:duedate:SalesOrder_Due_Date', 'custom', '0000-00-00', '0000-00-00'); +(34, 'vtiger_salesorder:duedate:SalesOrder_Due_Date', 'custom', '0000-00-00', '0000-00-00'), +(38, 'vtiger_salesorder:duedate:SalesOrder_Due_Date', 'custom', '0000-00-00', '0000-00-00'); -- -------------------------------------------------------- @@ -15412,7 +15426,8 @@ (25, 'SalesOrder', ''), (27, 'SalesOrder', ''), (28, 'SalesOrder', ''), -(34, 'SalesOrder', ''); +(34, 'SalesOrder', ''), +(38, 'SalesOrder', ''); -- -------------------------------------------------------- @@ -15445,6 +15460,7 @@ (1, 27, 'vtiger_accountSalesOrder:accountname:SalesOrder_Account_Name:account_id:I', 'Ascending'), (1, 28, 'vtiger_accountSalesOrder:accountname:SalesOrder_Account_Name:account_id:I', 'Ascending'), (1, 34, 'vtiger_accountSalesOrder:accountname:SalesOrder_Account_Name:account_id:I', 'Ascending'), +(1, 38, 'vtiger_accountSalesOrder:accountname:SalesOrder_Account_Name:account_id:I', 'Ascending'), (2, 19, 'vtiger_invoice:invoicedate:Invoice_Invoice_Date:invoicedate:D', 'Ascending'), (2, 20, 'none', 'Ascending'), (2, 24, 'none', 'Ascending'), @@ -15452,13 +15468,15 @@ (2, 27, 'none', 'Ascending'), (2, 28, 'vtiger_crmentitySalesOrder:createdtime:SalesOrder_Created_Time:createdtime:T', 'Ascending'), (2, 34, 'none', 'Ascending'), +(2, 38, 'none', 'Ascending'), (3, 19, 'none', 'Ascending'), (3, 20, 'none', 'Ascending'), (3, 24, 'none', 'Ascending'), (3, 25, 'none', 'Ascending'), (3, 27, 'none', 'Ascending'), (3, 28, 'none', 'Ascending'), -(3, 34, 'none', 'Ascending'); +(3, 34, 'none', 'Ascending'), +(3, 38, 'none', 'Ascending'); -- -------------------------------------------------------- @@ -15482,7 +15500,8 @@ (25, 0, 'cb:vtiger_salesordercf:cf_543:Bill_Amount_SUM:2'), (27, 0, 'cb:vtiger_salesordercf:cf_543:Bill_Amount_SUM:2'), (28, 0, 'cb:vtiger_salesordercf:cf_543:Bill_Amount_SUM:2'), -(34, 0, 'cb:vtiger_salesordercf:cf_543:Bill_Amount_SUM:2'); +(34, 0, 'cb:vtiger_salesordercf:cf_543:Bill_Amount_SUM:2'), +(38, 0, 'cb:vtiger_salesordercf:cf_543:Bill_Amount_SUM:2'); -- -------------------------------------------------------- @@ -16106,7 +16125,13 @@ (34, 2, 'vtiger_salesorder:customerno:SalesOrder_Customer_No:customerno:V'), (34, 3, 'vtiger_crmentitySalesOrder:createdtime:SalesOrder_Created_Time:createdtime:T'), (34, 4, 'vtiger_salesordercf:cf_537:SalesOrder_Tests_Conducted:cf_537:V'), -(34, 5, 'vtiger_salesordercf:cf_543:SalesOrder_Bill_Amount:cf_543:N'); +(34, 5, 'vtiger_salesordercf:cf_543:SalesOrder_Bill_Amount:cf_543:N'), +(38, 0, 'vtiger_accountSalesOrder:accountname:SalesOrder_Account_Name:account_id:I'), +(38, 1, 'vtiger_salesorder:subject:SalesOrder_Subject:subject:V'), +(38, 2, 'vtiger_salesorder:customerno:SalesOrder_Customer_No:customerno:V'), +(38, 3, 'vtiger_crmentitySalesOrder:createdtime:SalesOrder_Created_Time:createdtime:T'), +(38, 4, 'vtiger_salesordercf:cf_537:SalesOrder_Tests_Conducted:cf_537:V'), +(38, 5, 'vtiger_salesordercf:cf_543:SalesOrder_Bill_Amount:cf_543:N'); -- -------------------------------------------------------- @@ -16152,7 +16177,8 @@ (25, 0, 0), (27, 0, 0), (28, 0, 0), -(34, 0, 0); +(34, 0, 0), +(38, 0, 0); -- -------------------------------------------------------- @@ -16169,7 +16195,7 @@ -- INSERT INTO `vtiger_selectquery_seq` (`id`) VALUES -(37); +(38); -- --------------------------------------------------------