START TRANSACTION;

create schema netrip;
use netrip;
-- Table structure for table `nt_data`
CREATE TABLE `nt_data` (
  `id` int(50) NOT NULL,
  `username` varchar(50) NOT NULL,
  `title` varchar(50) NOT NULL,
  `state` varchar(50) NOT NULL ,
  `category` varchar(50) NOT NULL,
  `images` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `update_time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table `nt_data`
INSERT INTO `nt_data` (`id`,`username`, `title`, `state`, `category`,`images`,`description`,`update_time`) VALUES
(1,'user1','xxx', 'Sikkim', 'Events','Sikkim.jpg','lorem ipsum', '2020-09-11 07:34:41');
-- Indexes for table `nt_data`
ALTER TABLE `nt_data`
  ADD PRIMARY KEY (`id`);
-- AUTO_INCREMENT for table `nt_data`
ALTER TABLE `nt_data`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
