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
    (8, 2106, 'document_status', 'vtiger_notescf', 2, '16', 'document_status', 'Document Status', 1, 2, 'New', 100, 16, 17, 1, 'V~O', 1, 0, 'BAS', 1, '', 0, 0, 0);

ALTER TABLE vtiger_notescf ADD COLUMN document_status VARCHAR(255)

INSERT INTO `vtiger_def_org_field` (`tabid`, `fieldid`, `visible`, `readonly`)
VALUES
    (8, 2106, 0, 0);

INSERT INTO `vtiger_profile2field` (`profileid`, `tabid`, `fieldid`, `visible`, `readonly`)
VALUES
    (1, 8, 2106, 0, 0),
    (6, 8, 2106, 0, 0),
    (7, 8, 2106, 0, 0),
    (9, 8, 2106, 0, 0),
    (10, 8, 2106, 0, 0),
    (11, 8, 2106, 0, 0),
    (12, 8, 2106, 0, 0),
    (13, 8, 2106, 0, 0),
    (14, 8, 2106, 0, 0),
    (15, 8, 2106, 0, 0),
    (16, 8, 2106, 0, 0),
    (17, 8, 2106, 0, 0),
    (18, 8, 2106, 0, 0),
    (19, 8, 2106, 0, 0),
    (20, 8, 2106, 0, 0),
    (21, 8, 2106, 0, 0),
    (24, 8, 2106, 0, 0),
    (25, 8, 2106, 0, 0),
    (26, 8, 2106, 0, 0),
    (27, 8, 2106, 0, 0);

CREATE TABLE `vtiger_document_status` (
  `document_statusid` int(11) NOT NULL AUTO_INCREMENT,
  `document_status` varchar(200) NOT NULL DEFAULT '',
  `sortorderid` int(11) DEFAULT NULL,
  `presence` int(11) NOT NULL DEFAULT 1,
  `color` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`document_statusid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

INSERT INTO `vtiger_document_status` (`document_statusid`, `document_status`, `sortorderid`, `presence`, `color`)
VALUES
    (1, 'Approved', 0, 1, NULL),
    (2, 'Rejected', 1, 1, NULL),
    (3, 'New', 2, 1, NULL);

CREATE TABLE `vtiger_document_status_seq` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `vtiger_document_status_seq` (`id`)
VALUES
    (3);