-- https://www.phpmyadmin.net/
--

START TRANSACTION;



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

--
-- Table structure for table `tbl_conferences`
--

CREATE TABLE `tbl_conferences` (
  `conf_id` varchar(10) NOT NULL,
  `conf_name` varchar(100) NOT NULL,
  `admin_email` varchar(50) NOT NULL,
  `conf_status` varchar(10) NOT NULL,
  `conf_submitdate` date NOT NULL,
  `conf_crsubmitdate` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_conferences`
--

INSERT INTO `tbl_conferences` (`conf_id`, `conf_name`, `admin_email`, `conf_status`, `conf_submitdate`, `conf_crsubmitdate`) VALUES
('NETAPPS22', 'International Conference on Internet Applications, Protocols and Services', 'netapps_admin@soc-conferences.com', 'active', '2022-07-14', '2022-02-09');

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

--
-- Table structure for table `tbl_fields`
--

CREATE TABLE `tbl_fields` (
  `field_id` int(5) NOT NULL,
  `conf_id` varchar(10) NOT NULL,
  `field_title` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_fields`
--

INSERT INTO `tbl_fields` (`field_id`, `conf_id`, `field_title`) VALUES
(2, 'NETAPPS22', 'Programming'),
(3, 'NETAPPS22', 'Internet'),
(4, 'NETAPPS22', 'Information System'),
(6, 'NETAPPS22', 'Artificial Intelligence'),
(7, 'NETAPPS22', 'Computer Network'),
(8, 'NETAPPS22', 'Computer Security'),
(9, 'NETAPPS22', 'Information Technology'),
(10, 'NETAPPS22', 'Knowledge Management'),
(11, 'NETAPPS22', 'Blockchain'),
(12, 'NETAPPS22', 'Geographic Information System'),
(13, 'NETAPPS22', 'Internet Of Things'),
(14, 'NETAPPS22', 'Cryptography');

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

--
-- Table structure for table `tbl_messages`
--

CREATE TABLE `tbl_messages` (
  `message_id` int(8) NOT NULL,
  `author_email` varchar(50) NOT NULL,
  `message_title` varchar(100) NOT NULL,
  `message_content` varchar(500) NOT NULL,
  `message_status` varchar(15) NOT NULL,
  `message_date` datetime(6) NOT NULL DEFAULT current_timestamp(6)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_messages`
--

INSERT INTO `tbl_messages` (`message_id`, `author_email`, `message_title`, `message_content`, `message_status`, `message_date`) VALUES
(4, 'yemoco6436@angeleslid.com', 'Need help regarding payment', 'Please check my payment', 'send', '2022-05-13 21:49:36.137045'),
(5, 'yemoco6436@angeleslid.com', 'This is my second message', 'Please check my paper id 1', 'Replied', '2022-05-13 22:06:41.292839');

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

--
-- Table structure for table `tbl_news`
--

CREATE TABLE `tbl_news` (
  `news_id` int(6) NOT NULL,
  `news_title` varchar(100) NOT NULL,
  `news_user` varchar(20) NOT NULL,
  `news_content` varchar(1200) NOT NULL,
  `conf_id` varchar(10) NOT NULL,
  `news_date` datetime(6) NOT NULL DEFAULT current_timestamp(6)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_news`
--

INSERT INTO `tbl_news` (`news_id`, `news_title`, `news_user`, `news_content`, `conf_id`, `news_date`) VALUES
(1, 'Fusce ullamcorper erat elit, blandit posuere nisi posuere nec.', 'all', 'Fusce ullamcorper erat elit, blandit posuere nisi posuere nec. Vivamus at egestas risus. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Proin accumsan vulputate nisi, ultricies fringilla tortor condimentum non. Maecenas tristique ipsum ac ex vestibulum, eget consectetur eros pulvinar. Maecenas quis nibh ornare arcu rhoncus varius non nec nisi. Curabitur at ligula finibus, tincidunt magna nec, mattis ex.', 'NETAPPS22', '2022-05-13 20:43:23.543394'),
(2, 'Nulla rhoncus bibendum mi, eget sagittis erat maximus sed', 'author', 'Suspendisse eu venenatis purus. Aenean ullamcorper augue molestie enim pretium, nec molestie enim maximus. Sed aliquet enim vitae justo rhoncus, vitae placerat metus maximus. Duis sit amet tempor enim. Fusce dictum sapien id vehicula faucibus. Sed vel dui ultricies, fermentum nisi non, dictum augue. Fusce sodales vitae sapien sit amet aliquam. Suspendisse aliquet maximus erat at imperdiet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec a velit et quam cursus convallis. Ut id scelerisque nulla. Nullam interdum diam eget ultricies malesuada. Morbi accumsan pellentesque pretium.', 'NETAPPS22', '2022-05-13 20:50:47.345755');

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

--
-- Table structure for table `tbl_papers`
--

CREATE TABLE `tbl_papers` (
  `paper_id` int(5) NOT NULL,
  `paper_title` varchar(250) NOT NULL,
  `paper_abstract` varchar(2000) NOT NULL,
  `paper_keywords` varchar(250) NOT NULL,
  `paper_fields` varchar(200) NOT NULL,
  `paper_name` varchar(20) NOT NULL,
  `author_email` varchar(50) NOT NULL,
  `conf_id` varchar(15) NOT NULL,
  `rev_id` varchar(20) NOT NULL,
  `paper_status` varchar(20) NOT NULL,
  `paper_remark` varchar(300) NOT NULL,
  `payment_id` varchar(20) NOT NULL,
  `paper_ready` varchar(30) NOT NULL,
  `paper_date` datetime(6) NOT NULL DEFAULT current_timestamp(6)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_papers`
--

INSERT INTO `tbl_papers` (`paper_id`, `paper_title`, `paper_abstract`, `paper_keywords`, `paper_fields`, `paper_name`, `author_email`, `conf_id`, `rev_id`, `paper_status`, `paper_remark`, `payment_id`, `paper_ready`, `paper_date`) VALUES
(2, 'Internet of Things in Industries: A Survey', 'Internet of Things (IoT) has provided a promising opportunity to build powerful industrial systems and applications by leveraging the growing ubiquity of radio-frequency identification (RFID), and wireless, mobile, and sensor devices. A wide range of industrial IoT applications have been developed and deployed in recent years. In an effort to understand the development of IoT in industries, this paper reviews the current research of IoT, key enabling technologies, major IoT applications in industries, and identifies research trends and challenges. A main contribution of this review paper is that it summarizes the current state-of-the-art IoT in industries systematically.', 'IOT, RFID', 'Internet Of Things', 'pap-1-VqxwtB6j9n', 'yemoco6436@angeleslid.com', 'NETAPPS22', '3', 'Camera Ready', 'Wait for the review process. The review menu will be automatically open once the review started.', '4', 'cr-NETAPPS22-1-XUzipCxmvu', '2022-05-11 22:25:54.310507');

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

--
-- Table structure for table `tbl_payments`
--

CREATE TABLE `tbl_payments` (
  `payment_id` int(5) NOT NULL,
  `paper_id` varchar(5) NOT NULL,
  `author_email` varchar(50) NOT NULL,
  `payment_paid` varchar(10) NOT NULL,
  `payment_method` varchar(15) NOT NULL,
  `payment_filename` varchar(20) NOT NULL,
  `payment_status` varchar(20) NOT NULL,
  `payment_remarks` varchar(200) DEFAULT NULL,
  `conf_id` varchar(15) NOT NULL,
  `payment_date` datetime(6) NOT NULL DEFAULT current_timestamp(6)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_payments`
--

INSERT INTO `tbl_payments` (`payment_id`, `paper_id`, `author_email`, `payment_paid`, `payment_method`, `payment_filename`, `payment_status`, `payment_remarks`, `conf_id`, `payment_date`) VALUES
(4, '2', 'yemoco6436@angeleslid.com', '1500', 'bankin', 'pay-1-ojUzbhjGyn', 'submitted', NULL, 'NETAPPS22', '2022-05-13 17:08:38.472722');

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

--
-- Table structure for table `tbl_replies`
--

CREATE TABLE `tbl_replies` (
  `message_id` varchar(10) NOT NULL,
  `author_email` varchar(50) NOT NULL,
  `reply_message` varchar(500) NOT NULL,
  `reply_date` datetime(6) NOT NULL DEFAULT current_timestamp(6)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_replies`
--

INSERT INTO `tbl_replies` (`message_id`, `author_email`, `reply_message`, `reply_date`) VALUES
('1', 'netapps_admin@soc-conferences.com', 'Can you please contact us directly with the following phone number,', '2022-05-13 21:10:42.804920'),
('4', 'netapps_admin@soc-conferences.com', 'Yes we will contact you shortly. Please wait.', '2022-05-13 21:51:58.276080'),
('4', 'netapps_admin@soc-conferences.com', 'Thank you', '2022-05-13 22:04:56.427992'),
('4', 'netapps_admin@soc-conferences.com', 'Wish you the best', '2022-05-13 22:05:26.403730'),
('5', 'netapps_admin@soc-conferences.com', 'Yes the paper will be deleted', '2022-05-13 22:08:37.630293'),
('5', 'netapps_admin@soc-conferences.com', 'Check your paper menu', '2022-05-13 22:14:13.023942'),
('5', 'netapps_admin@soc-conferences.com', 'Please upload new paper', '2022-05-13 22:16:38.119951');

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

--
-- Table structure for table `tbl_reviews`
--

CREATE TABLE `tbl_reviews` (
  `review_id` int(5) NOT NULL,
  `rev_email` varchar(50) NOT NULL,
  `paper_id` varchar(5) NOT NULL,
  `author_email` varchar(50) NOT NULL,
  `reviewer_remarks` varchar(1000) DEFAULT NULL,
  `review_remarks` varchar(500) DEFAULT NULL,
  `review_totalmarks` varchar(3) NOT NULL,
  `review_status` varchar(20) NOT NULL,
  `review_filename` varchar(20) DEFAULT NULL,
  `conf_id` varchar(15) NOT NULL,
  `review_date` datetime(6) NOT NULL DEFAULT current_timestamp(6),
  `rubric_1` int(1) DEFAULT NULL,
  `rubric_2` int(1) DEFAULT NULL,
  `rubric_3` int(1) DEFAULT NULL,
  `rubric_4` int(1) DEFAULT NULL,
  `rubric_5` int(1) DEFAULT NULL,
  `rubric_6` int(1) DEFAULT NULL,
  `rubric_7` int(1) DEFAULT NULL,
  `rubric_8` int(1) DEFAULT NULL,
  `rubric_9` int(1) DEFAULT NULL,
  `rubric_10` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_reviews`
--

INSERT INTO `tbl_reviews` (`review_id`, `rev_email`, `paper_id`, `author_email`, `reviewer_remarks`, `review_remarks`, `review_totalmarks`, `review_status`, `review_filename`, `conf_id`, `review_date`, `rubric_1`, `rubric_2`, `rubric_3`, `rubric_4`, `rubric_5`, `rubric_6`, `rubric_7`, `rubric_8`, `rubric_9`, `rubric_10`) VALUES
(2, 'vevayat288@duetube.com', '2', 'yemoco6436@angeleslid.com', 'Good introductory paper. Need more latest references.', NULL, '72', 'reviewed', 'rev-2-myEfeu2WwO', 'NETAPPS22', '2022-05-13 15:42:21.867751', 4, 4, 3, 4, 4, 3, 4, 4, 3, 3),
(3, 'hojixa1034@dakcans.com', '2', 'yemoco6436@angeleslid.com', 'Overall good.', NULL, '74', 'reviewed', NULL, 'NETAPPS22', '2022-05-13 16:28:14.668296', 4, 3, 4, 3, 4, 4, 4, 4, 4, 3);

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

--
-- Table structure for table `tbl_rubrics`
--

CREATE TABLE `tbl_rubrics` (
  `rubric_id` int(5) NOT NULL,
  `conf_id` varchar(20) NOT NULL,
  `rubric_text` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_rubrics`
--

INSERT INTO `tbl_rubrics` (`rubric_id`, `conf_id`, `rubric_text`) VALUES
(1, 'NETAPPS22 ', 'Relevance to the conference'),
(2, 'NETAPPS22 ', 'Contribution to academic debate'),
(3, 'NETAPPS22 ', 'Structure of the paper'),
(4, 'NETAPPS22 ', 'Standard of English'),
(5, 'NETAPPS22 ', 'Appropriateness of the research/study method'),
(6, 'NETAPPS22 ', 'Relevance and clarity of drawings, graphs and tables'),
(7, 'NETAPPS22 ', 'Appropriateness of abstract as a description of the paper'),
(8, 'NETAPPS22 ', 'Use and number of keywords/key phrases'),
(9, 'NETAPPS22 ', 'Discussion and conclusions'),
(11, 'NETAPPS22 ', 'Reference list, adequate and correctly cited');

--
-- Indexes for table `tbl_conferences`
--
ALTER TABLE `tbl_conferences`
  ADD UNIQUE KEY `conf_id` (`conf_id`);

--
-- Indexes for table `tbl_fields`
--
ALTER TABLE `tbl_fields`
  ADD PRIMARY KEY (`field_id`);

--
-- Indexes for table `tbl_messages`
--
ALTER TABLE `tbl_messages`
  ADD PRIMARY KEY (`message_id`);

--
-- Indexes for table `tbl_news`
--
ALTER TABLE `tbl_news`
  ADD PRIMARY KEY (`news_id`);

--
-- Indexes for table `tbl_papers`
--
ALTER TABLE `tbl_papers`
  ADD PRIMARY KEY (`paper_id`);

--
-- Indexes for table `tbl_payments`
--
ALTER TABLE `tbl_payments`
  ADD PRIMARY KEY (`payment_id`);

--
-- Indexes for table `tbl_reviews`
--
ALTER TABLE `tbl_reviews`
  ADD PRIMARY KEY (`review_id`);

--
-- Indexes for table `tbl_rubrics`
--
ALTER TABLE `tbl_rubrics`
  ADD PRIMARY KEY (`rubric_id`);

--
-- AUTO_INCREMENT for table `tbl_fields`
--
ALTER TABLE `tbl_fields`
  MODIFY `field_id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `tbl_messages`
--
ALTER TABLE `tbl_messages`
  MODIFY `message_id` int(8) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `tbl_news`
--
ALTER TABLE `tbl_news`
  MODIFY `news_id` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `tbl_papers`
--
ALTER TABLE `tbl_papers`
  MODIFY `paper_id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `tbl_payments`
--
ALTER TABLE `tbl_payments`
  MODIFY `payment_id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `tbl_reviews`
--
ALTER TABLE `tbl_reviews`
  MODIFY `review_id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `tbl_rubrics`
--
ALTER TABLE `tbl_rubrics`
  MODIFY `rubric_id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
COMMIT;

