-- Table structure for table `project_phase`
--

CREATE TABLE `project_phase` (
  `phase_id` tinyint(3) UNSIGNED NOT NULL,
  `phase_name` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `project_phase`
--

INSERT INTO `project_phase` (`phase_id`, `phase_name`) VALUES
(1, ''),
(2, 'Concept/Schematic'),
(3, 'Design Development'),
(4, 'Construction Documentation'),
(5, 'Bidding'),
(6, 'Construction'),
(7, 'Inspection'),
(8, 'Commissioning'),
(9, 'Post-occupancy Evaluation'),
(10, 'On hold');

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

--
-- Table structure for table `project_type`
--

CREATE TABLE `project_type` (
  `type_id` tinyint(3) UNSIGNED NOT NULL,
  `type_name` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `project_type`
--

INSERT INTO `project_type` (`type_id`, `type_name`) VALUES
(1, ''),
(2, 'Commercial'),
(3, 'Residential'),
(4, 'Hospitality'),
(5, 'Healthcare'),
(6, 'Education'),
(7, 'Retail'),
(8, 'Museums, Art galleries, Exhibitions'),
(9, 'Theater'),
(10, 'Entertainment'),
(11, 'Sports'),
(12, 'Industrial'),
(13, 'Façade'),
(14, 'Landscape, Hardscape, Fountains'),
(15, 'Roadways, Infrastructure'),
(16, 'Parking, Garage'),
(17, 'Urban'),
(18, 'Art installations'),
(19, 'Other');

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

--
-- Table structure for table `qcm_fam_cnt`
--

CREATE TABLE `qcm_fam_cnt` (
  `qry_hash` binary(20) NOT NULL,
  `res` mediumblob NOT NULL,
  `manf_id` int(10) UNSIGNED NOT NULL,
  `qp` blob NOT NULL,
  `processed` tinyint(3) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `qcm_fam_opts`
--

CREATE TABLE `qcm_fam_opts` (
  `qry_hash` binary(20) NOT NULL,
  `res` mediumblob NOT NULL,
  `manf_id` int(10) UNSIGNED NOT NULL,
  `qp` blob NOT NULL,
  `processed` tinyint(3) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `qcm_manufacturers`
--

CREATE TABLE `qcm_manufacturers` (
  `manf_id` int(10) UNSIGNED NOT NULL,
  `is_cached` tinyint(3) UNSIGNED NOT NULL,
  `date_cached` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `qcm_manufacturers`
--

INSERT INTO `qcm_manufacturers` (`manf_id`, `is_cached`, `date_cached`) VALUES
(18, 0, '2019-03-06 00:20:46'),
(23, 0, '2019-03-06 00:20:46'),
(41, 0, '2019-03-06 00:20:46'),
(61, 0, '2019-03-06 00:20:46'),
(76, 0, '2019-03-06 00:20:46'),
(82, 0, '2019-03-06 00:20:46'),
(89, 0, '2019-03-06 00:20:46'),
(98, 0, '2019-03-06 00:20:46'),
(99, 0, '2019-03-06 00:20:46'),
(106, 0, '2019-03-06 00:20:46'),
(118, 0, '2019-03-06 00:20:46'),
(120, 0, '2019-03-06 00:20:46'),
(146, 0, '2019-03-06 00:20:46'),
(169, 0, '2019-03-06 00:20:46'),
(229, 0, '2019-03-06 00:20:46'),
(238, 0, '2019-03-06 00:20:46'),
(252, 0, '2019-03-06 00:20:46'),
(389, 0, '2019-03-06 00:20:46'),
(392, 0, '2019-03-06 00:20:46'),
(396, 0, '2019-03-06 00:20:46');

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

--
-- Table structure for table `qcm_tot_cnt`
--

CREATE TABLE `qcm_tot_cnt` (
  `qry_hash` binary(20) NOT NULL,
  `res` mediumblob NOT NULL,
  `manf_id` int(10) UNSIGNED NOT NULL,
  `qp` blob NOT NULL,
  `processed` tinyint(3) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `qc_fam_cnt`
--

CREATE TABLE `qc_fam_cnt` (
  `qry_hash` binary(20) NOT NULL,
  `res` mediumblob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `qc_fam_cnt`
--

INSERT INTO `qc_fam_cnt` (`qry_hash`, `res`) VALUES
(0x0224f642d2ae43b43c5258e90bc3eec37aab0ad2, 0x[encoded data, 9334 characters]),
(0x0c88c37ee176de2b3025665420e4238bb493cbfd, 0x[encoded data, 14100 characters]),
(0x0dbf7651ec52c9220cb8dff86e72be81218b1a53, 0x[encoded data, 9270 characters]),
(0x1149143ad23afe3d744c035f139421861f3fc4ca, 0x61000000789cab562a2e4d4e4e2d2e56b22a292a4dd551ca2d4e57b25252d251ca280e4e4d2c4acef02f2829762c2a52b28a8e050a96e4e680047c328b4b20caf2813ce7bc12a874b17b517e69813f4cacbab616004a63214a),
(0x1c4ccde7ce08fcd1c9c8c712c568133fe484d704, 0x[encoded data, 7464 characters]),
(0x232440531f23dfe0cd19aabba84b627101c932f7, 0x72040000789c4554b96e5b410cfc97ad552cb9e41eaf3352a409e022a5e1c2108438801d1bef4995a17f0f877bb8d2883b3c6648e92b1cb7f3f9721c61bbeeb7cb29bc1f7fc216c229bc1ebf2f2ffbf9f5f1f37a3cec7bd89e9e2d787d7f43e0d7dfe3da691ff6edc73ffbf215284a0c1b733a05d614b65c0d1484a20291216a403c68526bd8880a5033a496a194c356d842a5582829505dc86815a0c5c55fb4661d8815312488f7d7f1caab1ca3484795266a79d4e35616aa0b5986d898292214090845c4e64c1417b272d574a5c4c84482cc394995e76bea222c246613aa251f3d03a17d715427121d9952075fa8039534bc54294011686ab1a9a673f09cc06bd6b25a517201c46069194528eb185c1b0a538649a31ae661028ba6454475a1b940dbc0c8a4b45ed37a155f8375609e6790e23a8832e5586e9df07bd9ac40d9976d39e2fb6ffd5e94ed4d229e520724302edbc9a9e791a0028f0aacb0295b66bf1b978f9040832b84fa04472a7afb2a05995d83abb121b1229365bcd21ca14884429700cf537fe36c81862972eba008b898351b12e340176e18e72a82a302055760530a6171500c0530d57bc35cd7cbc92398c07f54a5d752d20e7036b039f50ff50faac9e9cc3ddc46d86f1d0df3a0c35f6ccb6ab993b00d571cfd7ce03246ad680c0beef813f9b97fdc3e1fd79fc4fdfe1f6db3e45b);
INSERT INTO `qc_fam_cnt` (`qry_hash`, `res`) VALUES
(0x40c8f295b43bad58a7d8543a8889eaf3edf0ffb1, 0x[encoded data, 21202 characters]),
(0x4e057939663655fa627b6b8ed5ef1c42008c16ce, 0x[encoded data, 6494 characters]),
(0x4feef271c8bb29287483ac90b59d3e081e8ab568, 0x[encoded data, 17622 characters]);
INSERT INTO `qc_fam_cnt` (`qry_hash`, `res`) VALUES
(0x5404e36c50ea7b3dfcb07bfb097b40d8a1d93bdb, 0x[encoded data, 19986 characters]),
(0x639cf492898f7f956162b8be451f2c52b7e18500, 0x[encoded data, 14262 characters]),
(0x64fb38bb142f09eca70cb871c678553b26d8d65a, 0x82080000789c3d96bb6e9c470c85dfe5af550c39e45cb60b52b809e022659022108c38401c1b5aa932f4eee147ceaafab933bc9e7386d89fd7fdedf9f9cbfd7edd5e5fdebe3c5ddfee7f5fb7eb7ababede7ffff2d7cbf3d7cf3f5eefbfbcbc5cb73ffe8cc3d76fff72f0db3ff7d772fb1ebf7efd2f7efcbca44fbd6e3efad3a57386d567587b84e586358fe52ad74d34ad8890ae71dbc2cff6d365bbc7d18c24964954b0565cd6d9be6e9dc4bd47a8799c756b141b94dd5811a14b8825f18ab3492d09435d0888d0e14fd7eae7ca3ade8e45bb2d33d02de93124b28f4d877125cda3891d8122b438146b7d5834315a586ed76daf3066e4b7c825542485e2249bf40cdea9d8454f6d9b4671226db793571d8bd8f96130242027f013f0464de61a194634edf420ced0382f80037d630e8d6e122d8f78c0ea8c18517bd5572ce603590159994c009c9146f5d4d41e15cc98043237835b9f304c675ee5730e6d8625146b301265d4b0a803649dc06c72e557e96447038caa00a260bfc0d9077c221dbacd1ad900d66a87590d439024de3dae362366222a315ae24ac211a97d93903c999a0ed19d82a7b69d9020d0418a41e501eea022c43a8a08b4b84d1399078b677819b3b81303bf99604183a0301d912f5f436aada1c2c548cc16cdcd141ffce1dc479116095a79bb59712206b261f8a207505f67929072204add31284ba70b9260046a24750a1ff02056f5c54ccf1d62c3595bf4bd7aea1c99240e6128474cc2d3ed38f9c0d825258741f4a222e5e300904f0765f7d4c82cb634a3b286975685ada0a9cd361308dbd1e3025cc466495b2ff939cb0482ba30226d48ab0e7b56e7a924c49c24a0f483227a0c3da4c08be15bc9afb331384018094bee32de5012c457cf375ca192ee785a68855016cb4864ac3a51464bd949b51fd9b5ba955c8680063339a23cf8944c1bbeedf8a21938977c60308c6871564a3190b86413de663d676f8727ef56410ee2c8ca33316f085cd2d9b51aec29af7ae8233908c37208a7c114cea8a1469194fb380436f263282e777281e3d093e723cf7bf7022ddf38b3598947f52103832485fd75fad5f100ad1da51a7b5dd369174bacf79c1639e40a923a60e39296bd430e3621da42877c7ac1df0effce396f2099a243804c9072535273d56c7252ebce54d178958cad74a0239924ef561ada55555749a8e786a52a23668e7944851e138dde1e72d8476e07d1c739dc4568be1e1ef8999b2d981cf77497a5951054b96fed7c8f7fd31357f7561d5add3e40dce5a48972be54f6da3b7f2a3ebd7c7ffbf1f9e34fc3fbfbff93a2a509),
(0x6f67db7e8d4795c306e7fe7f70274880597368b6, 0x[encoded data, 9402 characters]);
INSERT INTO `qc_fam_cnt` (`qry_hash`, `res`) VALUES
(0x6fbee831a7f63eaa335cade5d499a2bdce347259, 0x[encoded data, 27700 characters]),
(0x746f0e14d29486e4a6a783fa9b1bdffe1c4e1a09, 0x[encoded data, 12786 characters]),
(0x75ab4781c2f85dfee831689909ea56ec5bbc38e2, 0xd7040000789c3d543d6f1c4108fd2f536f3130301fdb4529d2447291d272119d4e71a438b66eef2aebfe7b78c0a58261e0cde3c1ee67396ea7d3f938ca7ebddcce5b793b7e95bd94adbc1e3fce3f2fa7d7a78febf1e57229fbf38b05af6f7f10f8fefbb846dabb9dbefeb5c367a1d66bd9bb6e4549cdd9ca5c656f5b2185c35b61588bab48d949b6d21a4545132efb44469e61510a4705ce4a47a663d1b052cbe46a8f92055ae5ac25731a6d4546f3f7750e4b9da8658b903aee886c99e23832d519e8304b206db80ca737274d48a08aee7ad9072a568029cd485542646d658c7c46c48a1434a7e550f39001b70ac2166ace7c457da3bcead65b433d521c88d17e45b9a5c8823332a7e3b101255a1094612d7586ce165110931e55b22826c035ba658a49508f11c902084a981f4e4ba1c5d59425debe729c693cf431cbde214a3b32351fd39078718c8a17663611a9f1884031b65c768720188523239593852650ddfd615e23c64be2bdc8ec6e69e6140433c67be2e283338dc0d2ee435ed311155a6210d85b14a80fdf1658fc9eb051ec2a49b2ab60874921112d61fbd83156ea062591b2920ef5d85cef1982b598818ce58232360f16b4f1714890e0b1929d3869adc1565bae779338d79976e5bd86a59ae79e780f9c9e718e2f6a8ed495fc9e677c098d28ee7be2d5b0b402b761cb70aeb95b50bbe3e38e3901ce61396d4b9bfb23d1be7d18339cc1b98ad927e774567ef89ad718ea1d7faa6f97f7dbc7d3ff3fd1fdfe0f6da9f526);
INSERT INTO `qc_fam_cnt` (`qry_hash`, `res`) VALUES
(0x7f01bfd163d9a00699192990e8628a68c5a9bb0b, 0x[encoded data, 16074 characters]),
(0x85233f0648186312d3f76581a9c33ad42793fbff, 0x[encoded data, 9360 characters]),
(0x8f8c33e92e4dd699a8942aa015c3e3d6ae7b647d, 0x[encoded data, 19030 characters]);
INSERT INTO `qc_fam_cnt` (`qry_hash`, `res`) VALUES
(0xa98e922e3fd72af38a50ebdbe328155311f426fb, 0x[encoded data, 13550 characters]),
(0xa9c9d23a51bb305b10e00b538e2f3b8db0d17e81, 0x[encoded data, 9246 characters]),
(0xaa5504f2b84fbe1f884ca7e340a71e498612577c, 0x[encoded data, 8716 characters]),
(0xaee06ed6b0b04399b1982659f1ed1dba4c515204, 0x[encoded data, 11450 characters]);
INSERT INTO `qc_fam_cnt` (`qry_hash`, `res`) VALUES
(0xaf50f838d555199b4515e52bcb4c203b122c47d2, 0x[encoded data, 18912 characters]),
(0xb1cdadf076a9650aa3f8c4d0776345055499986d, 0x[encoded data, 12724 characters]),
(0xb7545c6b0c1207cb15d37c519e1165e6e451d4f4, 0x16070000789c3d95316f1b310c85ffcbcd1e44513c49de8a0e5d0a64e858742882a029d0b481ed4c41fe7bf9913a4f475314f9f8f828bf6fd7b7c7c7a7eb753bdf2e6f4fa7ede5fa6b3b6fdb697bbe7e7bfa79797c7e78bd5d3f5d2edbf9fb0f77de5efee0f8fafb7acbb07ffeebf35ffff1be49d1ba9d45cb696bd32daba7cd646ee72e6ed4b29db5fb51ef1e54156bb8251e5ee7be2ed6d9ef16a76560798edd93d56e872b9288604d7cf3b469a987255e6b1f189286355d69ad51aa80a8f595cdec7e333aa8bb5bad6091443d6e140c47d4bd0509e461cce6058816323482bcd2705725e94e23bb07ebc470a886a77b6e530cf08541b05f97dd13567363809856d53d1606d7a9ba6b54afea741889cdd3b430fc44c9b7476f6e8c6322c49eb6eec9f8392dcf450ebe45c6dd9a8755090b38f41e740830d26a33b1d60a7a63a2edb8d97af0d722ac1c20066aa8e8830975f4e1f5bb618c3c0a9248ca3895a90307fe4c185d9471cf10d24872d3268defc84c56309850591dee994ca67885186d994997d9d2a4b6d09a323e4962b4d5836d47a8a8841a31083bc6674e4f758890333d2153847e6071450439ed4147465a211bea4327150680c5a536a0a9e199d9b9a163083626cdad0a4b95b95698266630407a413813e15886c8581a9031971183084342b6424be920c4d3f005950435214827bd4108bd0ce0b5d4bcb41a4b0572afd450f1c801d5b160aab49c82b20dcc4576e079a5dc60af080fac190aa581d01792831889091c4d174df55ad993578b7dc5a37bf22125240ff2a28bd05874cf3c9700626ba92dc5f2447859104224c681229841834ea436f6e4393aa260cbfd541e145a743eee97d91be6cf12404c69f195ae419d691266bc4f214d8d78250e61c5e3c3635902563f9a0b81b95b565ac93e6a741f0d694eb682c02311bf30873d6786b462bcf91cd4901adba21127f578376cb52947fbe3283532d29600bdd9929e995784c73c0fdcc19a81c9bb9ba9d491e15a12a1e430dd9f1054338da279d2f02090be2140de03e4cc77aedfa120bec7c5acaf6de1e98b83b6c24ab46ed1c8077f745f2effde5e1fee7f641f1fff01597f604a),
(0xcb6bc589818daeb352998235286928b273727fd0, 0x[encoded data, 14312 characters]);
INSERT INTO `qc_fam_cnt` (`qry_hash`, `res`) VALUES
(0xcd3bcb2cbeba5aab2eec777a4c6dfb314387ef7c, 0x[encoded data, 11258 characters]),
(0xd215b771193d5de6bdf68630c2dea604469ce589, 0x[encoded data, 8018 characters]),
(0xd6f2507465fef36d94d1c548c2b193214c9aee1b, 0x[encoded data, 11228 characters]),
(0xdbbde806e369fa11f87f480c121e8a91da5fd19e, 0x[encoded data, 16282 characters]),
(0xde92eaaea9b6f2148dbbc49a62fde1dd60b6ab92, 0x43060000789c3d55bb6e1c310cfc17d557882f3dae0b52a409e022659022308c38401c1bb77795e17f0f87e4a5d248a4c8e190da7d6fc7edf1f1e938daf97ab93d9ddacbf1ab9d5b3bb5e7e3dbd3cfcbe3f3c3dbf5f874b9b4f3f71f7e787df98383afbf8f6bbabdfaeef35fdfbc37ea22ed3ce8d468ef76563e35ebd3417720e6609d9a4e3f3105580e3a803bcb86336eb9893abb4d0690f444d6716488e4496401a8030458ee33b1523b7b7653f73078e82860ec913d8510670a21bfcc7ec21de1b08e5cc949b047137157f384a23dab12750a0a0aa6598c4dcfc8ce8ea32a84dbe30eee27282f00e8a569a504a4933310ea8549a0c0a98d52048ee232125530a275071595d8a342298125c02ea00e3c360d971e7574674d21b8d45d59ab1aa6bbe7997a260aa528bd8ddc4221fc0899056df295ad47661e2bf2305847c13d6f32d42102f032c9eb60290a8c5804b9d119a4ab61981a5dd8163a1063452dc815602002b232272de90e646242b24eebc993a1552463f4ba23dc4c806eb9075a845088c00ba15c188ac6f0c83484290051c1fc4d1080c59d3174609a33476be7316d49d531083090d59a7bee94bc49318bf0043da883478394d342125a56b44117acd64c3d69e698f83bc9a175b003441b054d1bb5ce3aa7daafda7344308c1161efacf15eb98786ba35ed982e68cae9afbbe20667ecadfca4ecb3ec96c434a9f398a9029e109e284a59f1be33c1d254b7977a43e2987b4fd548f2de9d67cf3931a93aea1197d8f52120f40c3a8d7bd695b74b35cee209e4502464c5945a3da99ddc7c1ab4e2593848cf5e1ade08264f729e96c43de9d572c570c73daa6a561938cbd16515a8e45ca3d659e756fb55328c20403365b1996dd2ea0a540401a90254a4003e30f16a32a050069845d0b4be9c55a86aafb14ebd35c6fb037f852f97d7dbdbc3ffaffec7c73f33e8388c),
(0xeeea8597de4190bc186e852750204ef1f352873f, 0x61000000789cab562a2e4d4e4e2d2e56b22a292a4dd551ca2d4e57b25252d251ca280e4e4d2c4acef02f2829762c2a52b28a8e050a96e4e680047c328b4b20caf2813ce7bc12a874b17b517e69813f4cacbab616004a63214a);
INSERT INTO `qc_fam_cnt` (`qry_hash`, `res`) VALUES
(0xfba6720567ee44c1c92b6f6fb379cea03464f4a6, 0x[encoded data, 29578 characters]),
(0xfe0a1f69d7fca8038f713e83791ffbf47f582f06, 0x[encoded data, 11760 characters]);

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

--
