bugs/install/db_install/00_tables/r_issue_user_needinfo.sql

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

--
-- Table structure for table `r_issue_user_needinfo`
--
-- Creation: Sep 11, 2015 at 11:31 AM
--

DROP TABLE IF EXISTS `r_issue_user_needinfo`;
CREATE TABLE IF NOT EXISTS `r_issue_user_needinfo` (
  `i_id` int(10) NOT NULL,
  `u_id` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- RELATIONS FOR TABLE `r_issue_user_needinfo`:
--   `i_id`
--       `issues` -> `id`
--   `u_id`
--       `users` -> `id`
--

--
-- Indexes for table `r_issue_user_needinfo`
--
ALTER TABLE `r_issue_user_needinfo`
  ADD UNIQUE KEY `i_id` (`i_id`,`u_id`),
  ADD KEY `u_id` (`u_id`);