CREATE TABLE `crmdocuploadconfiguration` (
  `entity_id` bigint(20) NOT NULL,
  `parent_entity_id` int(11) NOT NULL,
  `orgid` int(11) NOT NULL,
  `dcnid` int(11) NOT NULL,
  `docdocument` varchar(100) DEFAULT NULL,
  `doctitile` varchar(100) DEFAULT NULL,
  `docdescription` varchar(256) DEFAULT NULL,
  `logged_date` datetime NOT NULL,
  `last_updated_date` datetime DEFAULT NULL,
  `logged_by` bigint(20) DEFAULT NULL,
  `last_updated_by` bigint(20) DEFAULT NULL,
  `rowstate` int(11) NOT NULL,
  `docowner` varchar(508) DEFAULT NULL,
  `moduleflag` varchar(254) DEFAULT NULL,
  `docentityId` bigint(20) DEFAULT NULL,
  `docccategory` varchar(25) DEFAULT NULL,
  `assignedowner` bigint(100) DEFAULT NULL,
  PRIMARY KEY (`entity_id`,`dcnid`),
  KEY `idx_moduleflag` (`moduleflag`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1