bp_comp.sql

--
-- Table structure for table `wp_bp_compliments`
--

CREATE TABLE IF NOT EXISTS `wp_bp_compliments` (
  `id` bigint(20) NOT NULL,
  `term_id` int(10) NOT NULL,
  `post_id` int(10) DEFAULT NULL,
  `receiver_id` bigint(20) NOT NULL,
  `sender_id` bigint(20) NOT NULL,
  `message` varchar(1000) DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `wp_bp_compliments`
--
ALTER TABLE `wp_bp_compliments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `compliments` (`receiver_id`,`sender_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `wp_bp_compliments`
--
ALTER TABLE `wp_bp_compliments`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;