Table

-- phpMyAdmin SQL Dump
-- version 4.1.14
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Jul 07, 2015 at 04:08 PM
-- Server version: 5.6.17
-- PHP Version: 5.5.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `mojalatrs`
--

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

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

CREATE TABLE IF NOT EXISTS `category` (
  `id_category` int(11) NOT NULL AUTO_INCREMENT,
  `category_name` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id_category`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=60 ;

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

INSERT INTO `category` (`id_category`, `category_name`) VALUES
(1, 'Bušilice'),
(2, 'Ugaone brusilice'),
(3, 'Aku.bušilice'),
(4, 'Čeone brusilice'),
(5, 'Fenovi'),
(6, 'Glodalice, kekserice'),
(7, 'Heftalice'),
(8, 'Lemilice'),
(9, 'Makaze za lim'),
(10, 'Mašine za poliranje'),
(11, 'Mešači'),
(12, 'Oštrači, tocila'),
(13, 'Pegle za cevi'),
(14, 'Pištolji za farbanje'),
(16, 'Pištolji za lepljenj'),
(17, 'Pneumatske čekić-buš'),
(18, 'Rende'),
(19, 'Rotacione brusilice'),
(20, 'Ručni cirkulari'),
(21, 'Trakaste brusilice'),
(22, 'Ubodne testere'),
(23, 'Usisivači'),
(24, 'Vibracione brusilice'),
(25, 'Zavrtači'),
(26, 'Abrihteri'),
(27, 'Ger za drvo'),
(28, 'Ger za metal'),
(29, 'Industrijski usisivači'),
(30, 'Mašine za pločice i kamen'),
(31, 'Stoni cirkulari'),
(32, 'Strugovi'),
(33, 'Stubne bušilice'),
(34, 'Tračne testere'),
(35, 'Daljinomeri'),
(36, 'Detektori metala'),
(37, 'Laserske libele'),
(38, 'Rotacioni laseri'),
(39, 'Laseri za projekciju tačaka'),
(40, 'Laseri za projekciju linija'),
(41, 'Samonivelišući laseri'),
(42, 'Merni točkovi'),
(43, 'Optički niveliri'),
(44, 'Merač vlažnosti'),
(45, 'Pribor za merni alat'),
(46, 'Pretvarači napona'),
(47, 'Punjači akumulatora'),
(48, 'Agregati'),
(49, 'Električne dizalice'),
(50, 'Mešalice za beton'),
(51, 'Kompresori'),
(52, 'Pneumatske čeone brusilice'),
(53, 'Pneumatske heftalice'),
(54, 'Pneumatske mazalice'),
(55, 'Pištolji za duvanje guma'),
(56, 'Pneumatski pištolji za farbanje'),
(57, 'Pištolji za izduvavanje'),
(58, 'Pištolji za peskarenje'),
(59, 'Pneumatski udarni odvrtači');

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

--
-- Table structure for table `product`
--

CREATE TABLE IF NOT EXISTS `product` (
  `id_product` int(11) NOT NULL AUTO_INCREMENT,
  `id_category` int(11) NOT NULL,
  `manufacturer` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `name` char(30) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `power` int(11) NOT NULL,
  `image` char(40) COLLATE utf8_unicode_ci NOT NULL,
  `price` float NOT NULL,
  `catalogue_number` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `discount` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Akcija',
  PRIMARY KEY (`id_product`),
  KEY `id_category` (`id_category`),
  KEY `id_category_2` (`id_category`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=11 ;

--
-- Dumping data for table `product`
--

INSERT INTO `product` (`id_product`, `id_category`, `manufacturer`, `name`, `description`, `power`, `image`, `price`, `catalogue_number`, `discount`) VALUES
(9, 1, 'Bosch', 'GBH 2-20', 'Random description text.', 800, '', 18251, '2607060103', 0),
(10, 2, 'Metabo', 'W1080', 'Random descr text', 1000, '', 14823, '61266003', 0);

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

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id_user` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `firstname` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `lastname` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `active` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id_user`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=10 ;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id_user`, `username`, `firstname`, `lastname`, `password`, `email`, `active`) VALUES
(1, 'vts', 'vts', 'vts', '8d3569e953a5cd25bed569e68ba06715', 'vts@vts.com', NULL),
(8, 'zimcommerce', 'Norbert', 'Mahalik', '$2y$10$m.a20ECHJy6S1BPJKtXjheCUi', 'norbert@gmail.com', NULL),
(9, 'tamara', 'tamara', 'radlovic', '$2y$10$cOXcIBed05C1L6gawa9pcOhK9', 'tamara@gmail.com', NULL);

--
-- Constraints for dumped tables
--

--
-- Constraints for table `product`
--
ALTER TABLE `product`
  ADD CONSTRAINT `fk_constraint1` FOREIGN KEY (`id_category`) REFERENCES `category` (`id_category`) ON DELETE CASCADE ON UPDATE CASCADE;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;