rendered paste bodyprime:/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);
-- --------------------------------------------------------