Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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`)
- VALUES
- (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);
- ALTER TABLE vtiger_leadscf ADD COLUMN client_id VARCHAR(255)
- INSERT INTO `vtiger_def_org_field` (`tabid`, `fieldid`, `visible`, `readonly`)
- VALUES
- (7, 2112, 0, 0);
- INSERT INTO `vtiger_profile2field` (`profileid`, `tabid`, `fieldid`, `visible`, `readonly`)
- VALUES
- (1, 7, 2112, 0, 0),
- (6, 7, 2112, 0, 0),
- (7, 7, 2112, 0, 0),
- (9, 7, 2112, 0, 0),
- (10, 7, 2112, 0, 0),
- (11, 7, 2112, 0, 0),
- (12, 7, 2112, 0, 0),
- (13, 7, 2112, 0, 0),
- (14, 7, 2112, 0, 0),
- (15, 7, 2112, 0, 0),
- (16, 7, 2112, 0, 0),
- (17, 7, 2112, 0, 0),
- (18, 7, 2112, 0, 0),
- (19, 7, 2112, 0, 0),
- (20, 7, 2112, 0, 0),
- (21, 7, 2112, 0, 0),
- (24, 7, 2112, 0, 0),
- (25, 7, 2112, 0, 0),
- (26, 7, 2112, 0, 0),
- (27, 7, 2112, 0, 0);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement