Advertisement
Guest User

Untitled

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