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

START TRANSACTION;



--
-- Database: `staticki_uniform`
--

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

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `category` text NOT NULL,
  `image` text NOT NULL,
  `sort` int(11) NOT NULL,
  `status` varchar(10) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`id`, `name`, `category`, `image`, `sort`, `status`, `date`) VALUES
(7, 'rfbhfgnghmgh', 'Women', '1555400407Chrysanthemum.jpg', 2, 'Active', '2019-04-16 07:40:07'),
(8, 'test', 'Men', '1555407465Penguins.jpg', 2, 'Active', '2019-04-16 09:37:45');

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `price` text NOT NULL,
  `content` longtext NOT NULL,
  `subcategory` text NOT NULL,
  `image` varchar(100) NOT NULL,
  `sort` int(11) NOT NULL,
  `status` varchar(200) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`id`, `name`, `price`, `content`, `subcategory`, `image`, `sort`, `status`, `date`) VALUES
(66, 'dghfdhfdh', '433', 'Women', '7', '1555402727Jellyfish.jpg', 1, 'Active', '2019-04-16 08:18:47'),
(67, 'gvfdhfdhf', '436', 'n vfdhfgjfghk  nvbcmvbcmbm cvc nvbc nmbv<br>', '', '1556188838Chrysanthemum.jpg', 2, 'Active', '2019-04-25 10:40:38');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `category`
--
ALTER TABLE `category`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `category`
--
ALTER TABLE `category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=68;
COMMIT;

