Advertisement
Guest User

Untitled

a guest
Nov 14th, 2019
131
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.23 KB | None | 0 0
  1. 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`)
  2. VALUES
  3. (7, 2118, 'payments_type', 'vtiger_leadscf', 2, '1', 'payments_type', 'Payments Type', 1, 2, '', 100, 34, 13, 1, 'V~O~LE~255', 1, 0, 'BAS', 1, '', 0, 0, 0);
  4.  
  5. ALTER TABLE vtiger_leadscf ADD COLUMN payments_type VARCHAR(255)
  6.  
  7. INSERT INTO `vtiger_def_org_field` (`tabid`, `fieldid`, `visible`, `readonly`)
  8. VALUES
  9. (8, 2118, 0, 0);
  10.  
  11. INSERT INTO `vtiger_profile2field` (`profileid`, `tabid`, `fieldid`, `visible`, `readonly`)
  12. VALUES
  13. (1, 8, 2118, 0, 0),
  14. (6, 8, 2118, 0, 0),
  15. (7, 8, 2118, 0, 0),
  16. (9, 8, 2118, 0, 0),
  17. (10, 8, 2118, 0, 0),
  18. (11, 8, 2118, 0, 0),
  19. (12, 8, 2118, 0, 0),
  20. (13, 8, 2118, 0, 0),
  21. (14, 8, 2118, 0, 0),
  22. (15, 8, 2118, 0, 0),
  23. (16, 8, 2118, 0, 0),
  24. (17, 8, 2118, 0, 0),
  25. (18, 8, 2118, 0, 0),
  26. (19, 8, 2118, 0, 0),
  27. (20, 8, 2118, 0, 0),
  28. (21, 8, 2118, 0, 0),
  29. (24, 8, 2118, 0, 0),
  30. (25, 8, 2118, 0, 0),
  31. (26, 8, 2118, 0, 0),
  32. (27, 8, 2118, 0, 0);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement