Advertisement
Guest User

Untitled

a guest
Oct 9th, 2019
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.49 KB | None | 0 0
  1. DELETE FROM vtiger_field WHERE fieldlabel = 'Created Date User'
  2.  
  3. INSERT INTO vtiger_field (tabid, fieldid, columnname, tablename, generatedtype, uitype, fieldname, fieldlabel, readonly, presence, defaultvalue, maximumlength, sequence, block, displaytype, typeofdata, quickcreate, quickcreatesequence, info_type, masseditable, helpinfo, summaryfield, headerfield, isunique)
  4. VALUES
  5. (56, 2098, 'cf_2097', 'vtiger_paymentscf', 2, '5', 'cf_2097', 'Created Date User', 1, 2, '', 100, 14, 205, 1, 'D~O', 1, 0, 'BAS', 1, '', 0, 0, 0);
  6.  
  7. DELETE FROM vtiger_field WHERE fieldlabel = 'Last Comment Date'
  8.  
  9. INSERT INTO vtiger_field (tabid, fieldid, columnname, tablename, generatedtype, uitype, fieldname, fieldlabel, readonly, presence, defaultvalue, maximumlength, sequence, block, displaytype, typeofdata, quickcreate, quickcreatesequence, info_type, masseditable, helpinfo, summaryfield, headerfield, isunique)
  10. VALUES
  11. (7, 2102, 'cf_2101', 'vtiger_leadscf', 2, '5', 'cf_2101', 'Last Comment Date', 1, 2, '', 100, 29, 13, 1, 'D~O', 1, 0, 'BAS', 1, '', 1, 0, 0);
  12.  
  13. INSERT INTO vtiger_field (tabid, fieldid, columnname, tablename, generatedtype, uitype, fieldname, fieldlabel, readonly, presence, defaultvalue, maximumlength, sequence, block, displaytype, typeofdata, quickcreate, quickcreatesequence, info_type, masseditable, helpinfo, summaryfield, headerfield, isunique)
  14. VALUES
  15. (7, 2074, 'cf_2073', 'vtiger_leadscf', 2, '1', 'cf_2073', 'Last comment', 1, 2, '', 100, 28, 13, 1, 'V~O~LE~255', 2, 0, 'BAS', 1, '', 1, 0, 0);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement