export dokumen

CREATE TABLE `sda_docs` (
  `id` bigint(20) NOT NULL,
  `group_id` bigint(20) NOT NULL,
  `files` varchar(255) NOT NULL,
  `file_header` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `sda_docs` (`id`, `group_id`, `files`, `file_header`) VALUES(1000353, 999, '20180713poffsagsagdcom.tmp', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
INSERT INTO `sda_docs` (`id`, `group_id`, `files`, `file_header`) VALUES(1000354, 999, '20180713poffsagsagdcom.tmp', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
INSERT INTO `sda_docs` (`id`, `group_id`, `files`, `file_header`) VALUES(1000355, 2, '20180713poffsagsagdcom.tmp', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
INSERT INTO `sda_docs` (`id`, `group_id`, `files`, `file_header`) VALUES(1000356, 1000294, '20180716doneffsagsagdcom.tmp', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
INSERT INTO `sda_docs` (`id`, `group_id`, `files`, `file_header`) VALUES(1000352, 1000294, '20180713potentffsagsagdcom.tmp', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');

CREATE TABLE `sda_group` (
  `id` bigint(20) NOT NULL,
  `code` char(30) NOT NULL,
  `title` varchar(150) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


INSERT INTO `sda_group` (`id`, `code`, `title`) VALUES(1000294, '563', 'ffsagsagdcom');
INSERT INTO `sda_group` (`id`, `code`, `title`) VALUES(1, 'xxx', 'zzz');
INSERT INTO `sda_group` (`id`, `code`, `title`) VALUES(2, 'xx3x', 'zz4z');


CREATE TABLE `sda_group_doc` (
  `id` bigint(20) NOT NULL,
  `group_id` bigint(20) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `detail` longtext NOT NULL COMMENT 'json'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


INSERT INTO `sda_group_doc` (`id`, `group_id`, `status`, `detail`) VALUES(5, 1, 1, '[]');
INSERT INTO `sda_group_doc` (`id`, `group_id`, `status`, `detail`) VALUES(6, 2, 1, '[]');
INSERT INTO `sda_group_doc` (`id`, `group_id`, `status`, `detail`) VALUES(7, 1000294, 0, '{"1":false,"2":"1000356","3":"1000352"}');