-- Table structure for table `avm_abstractor_contacts`
--

CREATE TABLE `avm_abstractor_contacts` (
  `id` int(11) NOT NULL,
  `abstractor_master_id` int(11) NOT NULL,
  `first_name` varchar(80) NOT NULL,
  `last_name` varchar(80) DEFAULT NULL,
  `contact` varchar(80) NOT NULL,
  `email` varchar(80) NOT NULL,
  `description` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `avm_abstractor_contacts`
--

INSERT INTO `avm_abstractor_contacts` (`id`, `abstractor_master_id`, `first_name`, `last_name`, `contact`, `email`, `description`) VALUES
(1, 3, 'Aadya', NULL, '0987654321', 'aadya@gmail.com', 'ouytresdfglkjhgfds'),
(2, 1, 'ASD', NULL, '9087654321', 'asd@gmail.com', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `avm_abstractor_masters`
--

CREATE TABLE `avm_abstractor_masters` (
  `id` int(11) NOT NULL,
  `abstractor_unique_id` varchar(80) CHARACTER SET latin1 NOT NULL,
  `abstractor_name` varchar(80) NOT NULL,
  `address` text CHARACTER SET latin1 DEFAULT NULL,
  `city` varchar(80) CHARACTER SET latin1 DEFAULT NULL,
  `state` varchar(80) CHARACTER SET latin1 DEFAULT NULL,
  `zip` int(11) DEFAULT NULL,
  `contact_no` varchar(80) CHARACTER SET latin1 DEFAULT NULL,
  `email_id` varchar(80) CHARACTER SET latin1 DEFAULT NULL,
  `is_active` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `avm_abstractor_masters`
--

INSERT INTO `avm_abstractor_masters` (`id`, `abstractor_unique_id`, `abstractor_name`, `address`, `city`, `state`, `zip`, `contact_no`, `email_id`, `is_active`) VALUES
(1, 'STEAB-0001', 'A. R. C. Document Research Inc', NULL, 'BN', NULL, NULL, NULL, NULL, 1),
(2, 'STEAB-0002', 'Accurate Title Solutions of Georgia LLC', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(3, 'STEAB-0003', 'Bay Area Title Search and Abstract Services', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(4, 'STEAB-0004', 'Bradley R. Tyer & Associates, Inc. dba BRTLaw', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(5, 'STEAB-0005', 'Corning Abstract & Closing Services', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(6, 'STEAB-0006', 'Dependable Search', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(7, 'STEAB-0007', 'Fee Favor, Inc- Nationwide', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(8, 'STEAB-0008', 'FLORIDA LANDSEARCH LLC', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(9, 'STEAB-0009', 'FUSION TITLE SEARCH', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(10, 'STEAB-0010', 'Hawaii Real Property Research', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(11, 'STEAB-0011', 'HUDSON SEARCH LLC', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(12, 'STEAB-0012', 'Laurel Mountain Title, LLC', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(13, 'STEAB-0013', 'Lighthouse Search Team, Inc.', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(14, 'STEAB-0014', 'M&M NATIONAL ABSTRACTING CO', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(15, 'STEAB-0015', 'Megaquest, Inc', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(16, 'STEAB-0016', 'Pure Title', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(17, 'STEAB-0017', 'Real Title Services - Nationwide', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(18, 'STEAB-0018', 'Zook Search', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(19, 'STEAB-0019', 'ARIZONA Research / Retrieval Pricing', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(20, 'STEAB-0020', 'A/V Collaboration Technologies', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(21, 'STEAB-0021', 'DB Title', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(22, 'STEAB-0022', 'Los Angeles County Document', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(23, 'STEAB-0023', 'MEGHAN HEBARD', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(24, 'STEAB-0024', 'Adit Research, Inc', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(25, 'STEAB-0025', 'Real estate experts', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(26, 'STEAB-0026', 'Venture Title Inc', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(27, 'STEAB-0027', 'JJ Abstracting', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(28, 'STEAB-0028', 'Land star title LLC', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(29, 'STEAB-0029', 'Green Mountain Paralegals', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(30, 'STEAB-0030', 'Morgan Title Services', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(31, 'STEAB-0031', 'Oleander Abstractor\'s INC', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(32, 'STEAB-0032', 'Title Wave Research, Inc', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(33, 'STEAB-0033', 'All American Document Services, LLC', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(34, 'STEAB-0034', 'Eastern Sky Title Inc', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(35, 'STEAB-0035', 'Phoenix Document Service, LLC', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(37, 'STEAB-0037', 'Gateway Title Research, Inc', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(38, 'STEAB-0038', 'O\'Connor Title Companies', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(39, 'STEAB-0039', 'Integrated Search Technologies, LLC', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(40, 'STEAB-0040', 'Historical Abstracting, LLC', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(41, 'STEAB-0041', 'CARTERET TITLE LLC (NATIONWIDE)', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(42, 'STEAB-0042', 'CARTERET TITLE LLC', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(43, 'STEAB-0043', 'Olde Virginia Records Research, Inc.', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(44, 'STEAB-0044', 'Security American Title, LLC (STATEWIDE)', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(45, 'STEAB-0045', 'Security American Title, LLC', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(46, 'STEAB-0046', 'Coosa Valley Abstracting (NATONWIDE)', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(47, 'STEAB-0047', 'Coosa Valley Abstracting', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(48, 'STEAB-0048', 'Indepth Solution (Nationwide)', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(49, 'STEAB-0049', 'Indepth Solution', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(50, 'STEAB-0050', 'SOUTHERN LAND TITLE LLC', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(51, 'STEAB-0051', 'PARASEC', NULL, NULL, NULL, NULL, NULL, NULL, 1),
(52, 'STEAB-0052', 'DOCS HUNTERS', NULL, NULL, NULL, NULL, NULL, NULL, 1);

-- --------------------------------------------------------

--
-- Table structure for table `avm_category`
--

CREATE TABLE `avm_category` (
  `id` int(11) NOT NULL,
  `category_name` varchar(80) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `avm_category`
--

INSERT INTO `avm_category` (`id`, `category_name`) VALUES
(1, 'Abstractor'),
(2, 'Internal');

-- --------------------------------------------------------

--
-- Table structure for table `avm_client`
--

CREATE TABLE `avm_client` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `client_unique_id` varchar(80) DEFAULT NULL,
  `client_name` varchar(80) NOT NULL,
  `address` text DEFAULT NULL,
  `city` varchar(80) DEFAULT NULL,
  `state` varchar(80) DEFAULT NULL,
  `zip` int(11) DEFAULT NULL,
  `email_id` varchar(80) NOT NULL,
  `phone_no` varchar(80) DEFAULT NULL,
  `logo` blob DEFAULT NULL,
  `logo_type` varchar(80) DEFAULT NULL,
  `is_active` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `avm_client`
--

INSERT INTO `avm_client` (`id`, `company_id`, `client_unique_id`, `client_name`, `address`, `city`, `state`, `zip`, `email_id`, `phone_no`, `logo`, `logo_type`, `is_active`) VALUES
(1, 1, 'CLI001', 'Client', NULL, NULL, NULL, NULL, 'raju@gmail.com', NULL, NULL, NULL, 0),
(2, 1, 'CLI-0002', 'APPtek', 'AP', 'Pune', 'AP', 654567, 'Apptek@gmail.com', '0987654321', NULL, NULL, 0),
(3, 17, 'CLI-0002', 'Shilpa R', NULL, NULL, NULL, NULL, 'shilpa.r@gmail.com', NULL, NULL, NULL, 1),
(4, 18, 'CLI-0002', 'Edison ML', NULL, NULL, NULL, NULL, 'Edison.ML@gmail.com', NULL, NULL, NULL, 1);

-- --------------------------------------------------------

--
-- Table structure for table `avm_company`
--

CREATE TABLE `avm_company` (
  `id` int(11) NOT NULL,
  `company_name` varchar(80) NOT NULL,
  `address` text DEFAULT NULL,
  `city` varchar(80) DEFAULT NULL,
  `state` varchar(80) DEFAULT NULL,
  `contact_no` varchar(80) DEFAULT NULL,
  `zip` int(11) DEFAULT NULL,
  `logo` blob DEFAULT NULL,
  `logo_type` varchar(80) DEFAULT NULL,
  `email_id` varchar(80) DEFAULT NULL,
  `is_active` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `avm_company`
--

INSERT INTO `avm_company` (`id`, `company_name`, `address`, `city`, `state`, `contact_no`, `zip`, `logo`, `logo_type`, `email_id`, `is_active`) VALUES
(17, 'Stellar', NULL, 'Banglore', 'KA', NULL, NULL, NULL, NULL, NULL, 1),
(18, 'ABC & Company Ltd', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(19, 'Testry', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fre@gmail.com', 1);

-- --------------------------------------------------------

--
-- Table structure for table `avm_customers`
--

CREATE TABLE `avm_customers` (
  `id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `customer_unique_id` varchar(80) DEFAULT NULL,
  `customer_name` varchar(80) NOT NULL,
  `address` text DEFAULT NULL,
  `city` varchar(80) DEFAULT NULL,
  `state` varchar(80) DEFAULT NULL,
  `zip` int(11) DEFAULT NULL,
  `email_id` varchar(80) DEFAULT NULL,
  `phone_no` varchar(80) DEFAULT NULL,
  `abstractor_master_ids` text DEFAULT NULL,
  `logo` blob DEFAULT NULL,
  `logo_type` varchar(80) DEFAULT NULL,
  `is_active` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `avm_customers`
--

INSERT INTO `avm_customers` (`id`, `company_id`, `customer_unique_id`, `customer_name`, `address`, `city`, `state`, `zip`, `email_id`, `phone_no`, `abstractor_master_ids`, `logo`, `logo_type`, `is_active`) VALUES
(8, 17, 'STECU-0001', 'Raj Sharma', NULL, NULL, NULL, NULL, 'raj.sharma@gmail.com', NULL, NULL, NULL, NULL, 1),
(9, 17, 'STECU-0002', 'Pawan Patil', NULL, NULL, NULL, NULL, 'pawan.patil@gmail.com', NULL, NULL, NULL, NULL, 1),
(10, 17, 'STECU-0003', 'Rijo Paul', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(11, 18, 'STECU-0004', 'Divya Kumar', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1),
(12, 19, 'STECU-0005', 'Sharad Gandhi', NULL, NULL, NULL, NULL, 'sharad.gandhi@gmail.com', NULL, NULL, NULL, NULL, 1);

-- --------------------------------------------------------

--
-- Table structure for table `avm_orders_audit`
--

CREATE TABLE `avm_orders_audit` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `status_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `comments` text NOT NULL,
  `date_time` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `avm_orders_audit`
--

INSERT INTO `avm_orders_audit` (`id`, `order_id`, `status_id`, `user_id`, `comments`, `date_time`) VALUES
(1, 1, 1, 2, 'New Order Created ,Status(Open)', '2022-10-06 06:39:03'),
(2, 2, 1, 2, 'New Order Created ,Status(Open)', '2022-10-06 06:41:51'),
(3, 2, 1, 6, 'processor Changed( -Manali )', '2022-10-06 08:27:44'),
(4, 2, 1, 3, 'processor Changed( -Manali )Assigned to abstractor (A. R. C. Document Research Inc )', '2022-10-06 08:31:01'),
(5, 2, 2, 1, 'Order Accepted By Abstractor (Abstractor User) ', '2022-10-06 08:31:26'),
(6, 2, 2, 1, 'Document Submitted Abstractor (Abstractor User) ', '2022-10-06 08:45:50'),
(7, 2, 8, 3, 'Status Changed( In Progress-Processing Completed )processor Changed( -Manali )', '2022-10-06 08:46:29'),
(8, 2, 3, 3, 'Status Changed( Processing Completed-Clarification )processor Changed( -Manali )', '2022-10-06 08:46:57'),
(9, 3, 1, 3, 'New Order Created ,Status(Open)', '2022-10-06 08:48:57'),
(10, 4, 1, 2, 'New Order Created ,Status(Open)', '2022-10-06 09:45:42'),
(11, 4, 1, 2, 'processor Changed( -Manali )Assigned to abstractor (A. R. C. Document Research Inc )', '2022-10-06 10:40:18'),
(12, 4, 1, 2, 'processor Changed( -Manali )', '2022-10-06 10:41:18'),
(13, 5, 1, 2, 'New Order Created ,Status(Open)', '2022-10-06 12:41:25'),
(14, 6, 1, 2, 'New Order Created ,Status(Open)', '2022-10-06 12:42:10'),
(15, 4, 1, 2, 'processor Changed( -Manali )Assigned to abstractor (A. R. C. Document Research Inc )', '2022-10-06 12:45:51'),
(16, 7, 1, 2, 'New Order Created ,Status(Open)', '2022-10-06 13:17:30'),
(17, 7, 1, 6, 'processor Changed( -Manali )', '2022-10-06 13:24:50'),
(18, 7, 1, 2, 'processor Changed( -Manali )Assigned to abstractor (A. R. C. Document Research Inc )', '2022-10-06 13:28:38'),
(19, 7, 2, 2, 'Order Accepted By Abstractor (Test Abstractor ) ', '2022-10-06 13:29:39'),
(20, 4, 2, 2, 'Order Accepted By Abstractor (Test Abstractor ) ', '2022-10-11 05:57:05');

-- --------------------------------------------------------

--
-- Table structure for table `avm_order_comments`
--

CREATE TABLE `avm_order_comments` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `comments` text NOT NULL,
  `user_id` int(11) NOT NULL,
  `date_time` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `avm_order_comments`
--

INSERT INTO `avm_order_comments` (`id`, `order_id`, `comments`, `user_id`, `date_time`) VALUES
(1, 2, 'changed Type', 6, '2022-10-06 08:27:44'),
(2, 2, 'assigned to absrtactor', 3, '2022-10-06 08:31:01'),
(3, 2, 'test upload', 1, '2022-10-06 08:45:50'),
(4, 2, 'completed', 3, '2022-10-06 08:46:29'),
(5, 2, 'test', 3, '2022-10-06 08:46:57'),
(6, 4, 'test', 2, '2022-10-06 10:40:18'),
(7, 4, 'test', 2, '2022-10-06 10:41:18'),
(8, 4, 'test', 2, '2022-10-06 12:45:51'),
(9, 7, 'test', 6, '2022-10-06 13:24:50'),
(10, 7, 'test', 2, '2022-10-06 13:28:38');

-- --------------------------------------------------------

--
-- Table structure for table `avm_product_names`
--

CREATE TABLE `avm_product_names` (
  `id` int(11) NOT NULL,
  `product_uniqueid` varchar(80) CHARACTER SET latin1 NOT NULL,
  `product_name` varchar(80) CHARACTER SET latin1 NOT NULL,
  `description` text CHARACTER SET latin1 DEFAULT NULL,
  `requirements` longtext CHARACTER SET latin1 DEFAULT NULL,
  `is_active` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `avm_product_names`
--

INSERT INTO `avm_product_names` (`id`, `product_uniqueid`, `product_name`, `description`, `requirements`, `is_active`) VALUES
(1, 'STEAP001', 'Current Owner', 'Current Owner', '<p>Testing Requirement</p>', 1),
(2, 'STEAP002', 'Two Owner', 'Two Owner', NULL, 1),
(3, 'STEAP003', 'Full Search', 'Full Search', NULL, 1),
(4, 'STEAP004', 'Full Search (30 Years)', 'Full Search (30 Years)', NULL, 1),
(5, 'STEAP005', 'Full Search (40 Years)', 'Full Search (40 Years)', NULL, 1),
(6, 'STEAP006', 'Update', 'Update', NULL, 1),
(7, 'STEAP007', 'Doc Retrieval (fee is per individual address)', 'Doc Retrieval (fee is per individual address)', NULL, 1),
(8, 'STEAP008', 'Copies Per-page', 'Copies Per-page', NULL, 1),
(9, 'STEAP009', 'Foreclosure (REO) ', 'Foreclosure (REO) ', NULL, 1),
(10, 'STEAP010', 'Commercial Quotes Start', 'Commercial Quotes Start', NULL, 1),
(11, 'STEAP011', 'Cell Quotes Start', 'Cell Quotes Start', NULL, 1),
(12, 'STEAP012', 'Open Mort Search', 'Open Mort Search', NULL, 1),
(13, 'STEAP013', 'Legal & Vesting Search', 'Legal & Vesting Search', NULL, 1),
(14, 'STEAP014', 'Assignment Search', 'Assignment Search', NULL, 1),
(15, 'STEAP015', 'Lien/Judgment   Search (per name)', 'Lien/Judgment   Search (per name)', NULL, 1),
(16, 'STEAP016', 'Tax Report (Nationwide)', 'Tax Report (Nationwide)', NULL, 1),
(17, 'STEAP017', 'Lien/Judgment Retrieval (w/ case # provided)', 'Lien/Judgment Retrieval (w/ case # provided)', NULL, 1),
(18, 'STEAP018', 'Municipal Lien Search', 'Municipal Lien Search', NULL, 1),
(19, 'STEAP019', 'Update Municipal Lien Search', 'Update Municipal Lien Search', NULL, 1),
(20, 'STEAP020', 'UCC Search', 'UCC Search', NULL, 1),
(21, 'STEAP021', 'Certified Copies (Texas)', 'Certified Copies (Texas)', NULL, 1),
(22, 'STEAP022', 'Doc Recordings (Ohio & Texas)', 'Doc Recordings (Ohio & Texas)', NULL, 1),
(23, 'STEAP023', 'Doc Recording & Update (Ohio)', 'Doc Recording & Update (Ohio)', NULL, 1),
(24, 'STEAP024', 'Attorney Certification (NC, SC, and WV)', 'Attorney Certification (NC, SC, and WV)', NULL, 1),
(25, 'STEAP025', 'Tideland Search (NJ)', 'Tideland Search (NJ)', NULL, 1),
(26, 'STEAP026', 'Upper Court (Charles Jones Search) Per-name (NJ)', 'Upper Court (Charles Jones Search) Per-name (NJ)', NULL, 1),
(27, 'STEAP027', 'Trip Fee (NM)', 'Trip Fee (NM)', NULL, 1),
(28, 'STEAP028', 'Divorce Decree  (AZ)', 'Divorce Decree  (AZ)', NULL, 1),
(29, 'STEAP029', 'Divorce Decree copies 1.50 (AZ)', 'Divorce Decree copies 1.50 (AZ)', NULL, 1);

-- --------------------------------------------------------

--
-- Table structure for table `avm_status`
--

CREATE TABLE `avm_status` (
  `id` int(11) NOT NULL,
  `status_name` varchar(80) NOT NULL,
  `display_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `avm_status`
--

INSERT INTO `avm_status` (`id`, `status_name`, `display_id`) VALUES
(1, 'Open', 1),
(2, 'In Progress', 2),
(3, 'Clarification', 3),
(4, 'Pricing Confirmation', 4),
(5, 'On hold', 6),
(6, 'Reject', 7),
(7, 'Cancel', 8),
(8, 'Processing Completed', 9),
(9, 'Qc Completed', 10),
(10, 'Closed', 11),
(11, 'Pricing Confirmed', 5);

-- --------------------------------------------------------

--
-- Table structure for table `avm_supporting_docs`
--

CREATE TABLE `avm_supporting_docs` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `doc_name` varchar(80) NOT NULL,
  `doc` longblob DEFAULT NULL,
  `document_type` varchar(80) DEFAULT NULL,
  `added_by` int(11) NOT NULL,
  `added_datetime` datetime DEFAULT NULL,
  `is_active` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `avm_supporting_docs`
--

INSERT INTO `avm_supporting_docs` (`id`, `order_id`, `doc_name`, `doc`, `document_type`, `added_by`, `added_datetime`, `is_active`) VALUES
(2, 1, 'Tes doc', 0x[BLOB], 'application/pdf', 2, '2022-09-18 02:14:15', 1);
INSERT INTO `avm_supporting_docs` (`id`, `order_id`, `doc_name`, `doc`, `document_type`, `added_by`, `added_datetime`, `is_active`) VALUES
(3, 2, 'test', 0x[BLOB]