DijagramiZaSistemot: dbshop (2).sql

-- phpMyAdmin SQL Dump
-- version 4.0.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 09, 2014 at 04:42 PM
-- Server version: 5.6.12-log
-- PHP Version: 5.4.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: `dbshop`
--
CREATE DATABASE IF NOT EXISTS `dbshop` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `dbshop`;

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

--
-- Table structure for table `tdistributer`
--

CREATE TABLE IF NOT EXISTS `tdistributer` (
  `distributer_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `distributer_ime` varchar(255) NOT NULL,
  `distributer_titula` varchar(255) NOT NULL,
  PRIMARY KEY (`distributer_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `tdistributer`
--

INSERT INTO `tdistributer` (`distributer_id`, `distributer_ime`, `distributer_titula`) VALUES
(1, 'Martina Stojanovska', 'VIP'),
(2, 'Natalija Ilievska', 'Standard'),
(3, 'Stefanija Stefkovska', 'Pocetnik'),
(4, 'Stefan Dimitrov', 'Standard'),
(5, 'Elena Mitreva', 'Pocetnik');

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

--
-- Table structure for table `tinvoice`
--

CREATE TABLE IF NOT EXISTS `tinvoice` (
  `invoice_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `invoice_create_ts` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `invoice_total` float NOT NULL,
  `invoice_status` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`invoice_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=22 ;

--
-- Dumping data for table `tinvoice`
--

INSERT INTO `tinvoice` (`invoice_id`, `user_id`, `invoice_create_ts`, `invoice_total`, `invoice_status`) VALUES
(8, 1, '2014-04-21 23:07:41', 2088, 0),
(9, 2, '2014-04-21 23:10:46', 5450, 1),
(10, 2, '2014-04-21 23:11:07', 1000, 0),
(11, 3, '2014-04-21 23:12:05', 7200, 1),
(12, 4, '2014-04-21 23:13:05', 220, 0),
(13, 5, '2014-04-21 23:14:06', 3520, 0),
(14, 3, '2014-04-21 23:29:09', 990, 0),
(15, 4, '2014-04-23 21:02:22', 730, 0),
(16, 4, '2014-04-23 22:47:23', 2630, 0),
(17, 1, '2014-06-09 18:10:02', 3140, 0),
(18, 1, '2014-06-09 18:24:08', 3620, 0),
(19, 6, '2014-06-09 18:34:04', 1350, 1),
(20, 7, '2014-06-09 18:34:55', 3416, 0),
(21, 8, '2014-06-09 18:35:52', 4350, 0);

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

--
-- Table structure for table `tinvoiceproduct`
--

CREATE TABLE IF NOT EXISTS `tinvoiceproduct` (
  `ip_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) NOT NULL,
  `proizvod_id` int(11) NOT NULL,
  `ip_quantity` int(11) NOT NULL,
  `ip_unit_price` int(11) NOT NULL,
  PRIMARY KEY (`ip_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=79 ;

--
-- Dumping data for table `tinvoiceproduct`
--

INSERT INTO `tinvoiceproduct` (`ip_id`, `invoice_id`, `proizvod_id`, `ip_quantity`, `ip_unit_price`) VALUES
(25, 8, 23, 1, 990),
(26, 8, 31, 1, 250),
(27, 8, 24, 2, 249),
(28, 8, 35, 1, 350),
(29, 9, 34, 1, 260),
(30, 9, 26, 1, 150),
(31, 9, 37, 1, 150),
(32, 9, 38, 1, 990),
(33, 9, 22, 2, 950),
(34, 9, 35, 1, 350),
(35, 9, 36, 1, 350),
(36, 9, 33, 2, 650),
(37, 10, 27, 1, 730),
(38, 10, 25, 1, 270),
(39, 11, 22, 3, 950),
(40, 11, 23, 1, 990),
(41, 11, 27, 1, 730),
(42, 11, 33, 1, 650),
(43, 11, 38, 2, 990),
(44, 12, 29, 1, 220),
(45, 13, 23, 1, 990),
(46, 13, 27, 2, 730),
(47, 13, 25, 1, 270),
(48, 13, 31, 1, 250),
(49, 13, 37, 1, 150),
(50, 13, 30, 1, 250),
(51, 13, 26, 1, 150),
(52, 14, 23, 1, 990),
(53, 15, 27, 1, 730),
(54, 16, 27, 2, 730),
(55, 16, 22, 1, 950),
(56, 16, 29, 1, 220),
(57, 17, 22, 2, 950),
(58, 17, 23, 1, 990),
(59, 17, 30, 1, 250),
(60, 18, 22, 2, 950),
(61, 18, 23, 1, 990),
(62, 18, 27, 1, 730),
(63, 19, 27, 1, 730),
(64, 19, 30, 1, 250),
(65, 19, 26, 1, 150),
(66, 19, 29, 1, 220),
(67, 20, 24, 4, 249),
(68, 20, 22, 2, 950),
(69, 20, 25, 1, 270),
(70, 20, 21, 1, 250),
(71, 21, 23, 1, 990),
(72, 21, 21, 1, 250),
(73, 21, 27, 1, 730),
(74, 21, 28, 1, 330),
(75, 21, 33, 1, 650),
(76, 21, 38, 1, 990),
(77, 21, 34, 1, 260),
(78, 21, 26, 1, 150);

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

--
-- Table structure for table `tkatalog`
--

CREATE TABLE IF NOT EXISTS `tkatalog` (
  `katalog_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `katalog_ime` varchar(255) NOT NULL,
  `katalog_status` tinyint(4) NOT NULL,
  `katalog_header` tinyint(4) NOT NULL,
  PRIMARY KEY (`katalog_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `tkatalog`
--

INSERT INTO `tkatalog` (`katalog_id`, `katalog_ime`, `katalog_status`, `katalog_header`) VALUES
(1, 'ЈаМуарО 2014', 1, 1),
(2, 'ЀебруарО 2014', 1, 1);

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

--
-- Table structure for table `tkategorija`
--

CREATE TABLE IF NOT EXISTS `tkategorija` (
  `kategorija_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kategorija_order` int(11) NOT NULL,
  `kategorija_name` varchar(255) NOT NULL,
  `kategorija_opis` text NOT NULL,
  `kategorija_status` int(11) NOT NULL DEFAULT '0',
  `kategorija_header` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`kategorija_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `tkategorija`
--

INSERT INTO `tkategorija` (`kategorija_id`, `kategorija_order`, `kategorija_name`, `kategorija_opis`, `kategorija_status`, `kategorija_header`) VALUES
(1, 1, 'ПарфеЌО', 'МашкО О жеМскО', 1, 1),
(2, 3, 'КреЌО', 'За раце, лОце О телП', 1, 1),
(3, 4, 'ПрепаратО за кПса', 'КаЌпПМ,серуЌ,балсаЌ', 1, 1),
(4, 2, 'КЌОМка', 'КреПМО,ЌаскарО О карЌОМО', 1, 1);

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

--
-- Table structure for table `tproizvod`
--

CREATE TABLE IF NOT EXISTS `tproizvod` (
  `proizvod_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kategorija_id` int(11) NOT NULL,
  `katalog_id` int(11) NOT NULL,
  `proizvod_order` int(11) NOT NULL DEFAULT '0',
  `proizvod_ime` varchar(255) NOT NULL,
  `proizvod_opis` text NOT NULL,
  `proizvod_lager` int(11) NOT NULL,
  `proizvod_cena` float NOT NULL,
  `proizvod_slika` varchar(255) NOT NULL,
  `proizvod_akcija` mediumint(9) NOT NULL DEFAULT '0',
  `proizvod_status` int(11) NOT NULL DEFAULT '0',
  `proizvod_home` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`proizvod_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=39 ;

--
-- Dumping data for table `tproizvod`
--

INSERT INTO `tproizvod` (`proizvod_id`, `kategorija_id`, `katalog_id`, `proizvod_order`, `proizvod_ime`, `proizvod_opis`, `proizvod_lager`, `proizvod_cena`, `proizvod_slika`, `proizvod_akcija`, `proizvod_status`, `proizvod_home`) VALUES
(21, 2, 1, 0, 'Avon Care Family', 'КреЌа за телП', 10, 250, 'krema-telo.jpg', 0, 0, 1),
(22, 1, 1, 0, 'Pure', 'МашкО парфеЌ', 10, 950, 'pure.jpg', 0, 0, 1),
(23, 1, 1, 0, 'Outspoken intense', 'ЖеМскО парфеЌ', 33, 990, 'parfem_z.png', 0, 0, 0),
(24, 3, 1, 0, 'Palmolive', 'КаЌпПМ за сОте вОЎПвО кПса', 33, 249, 'Palmolive.jpg', 10, 0, 1),
(25, 2, 1, 0, 'Sun Magic Tan', 'КреЌа за саЌПпПтеЌМување', 23, 270, 'magic tan.jpg', 0, 0, 0),
(26, 4, 1, 0, 'Lasting Smile', 'КарЌОМ- гП ОЌа вП разлОчМО бПО', 10, 150, 'karmin.jpg', 0, 0, 1),
(27, 1, 2, 0, 'Little Black Dress', 'ЖеМскО парфеЌ', 55, 730, 'parfem.jpg', 0, 0, 1),
(28, 2, 2, 0, 'Vitale', 'НПќМа креЌа за лОце', 25, 330, 'krema lice.jpg', 0, 0, 0),
(29, 3, 2, 0, 'Hello Kitty', 'БалсаЌ за кПса', 36, 220, 'hello kitty.jpg', 0, 0, 0),
(30, 4, 1, 0, 'Super Shock', 'Маскара', 14, 250, 'supershock.jpg', 20, 0, 1),
(31, 2, 1, 0, 'Silk Beauty', 'КреЌа за раце', 57, 250, 'silkbeauty.png', 0, 0, 0),
(32, 3, 1, 0, 'Daily Shine', 'Спреј за пПсјајМа кПса сП ЌарПкаМскП арПгаМПвП ЌаслП', 2, 290, 'dailyshine.jpg', 0, 0, 0),
(33, 1, 2, 0, 'X- series', 'МашкО парфеЌ', 29, 650, 'x-series.jpg', 0, 0, 0),
(34, 4, 1, 0, 'Extend', 'Маскара за ОзЎПлжување Ма трепкО', 16, 260, 'extend.jpg', 0, 0, 0),
(35, 3, 1, 0, 'Advance Techniques', 'КаЌпПМ О балсаЌ прПтОв првут', 6, 350, 'sampon-balsam.jpg', 0, 0, 0),
(36, 2, 1, 0, 'Anew reversalist', 'ДМевМа креЌа за лОце', 30, 350, 'krema-lice.jpg', 0, 0, 0),
(37, 4, 1, 0, 'Luxe', 'КреПМ за ПчО вП разлОчМО бПО', 27, 150, 'kreon.JPG', 0, 0, 0),
(38, 1, 2, 0, 'Burberry', 'ЖеМскО парфеЌ', 13, 990, 'burberry.jpg', 0, 0, 0);

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

--
-- Table structure for table `tuser`
--

CREATE TABLE IF NOT EXISTS `tuser` (
  `user_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `distributer_id` int(11) NOT NULL,
  `user_email` varchar(255) NOT NULL,
  `user_password` varchar(255) NOT NULL,
  `user_firstname` varchar(255) NOT NULL,
  `user_lastname` varchar(255) NOT NULL,
  `user_type` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `tuser`
--

INSERT INTO `tuser` (`user_id`, `distributer_id`, `user_email`, `user_password`, `user_firstname`, `user_lastname`, `user_type`) VALUES
(1, 2, 'magi_magi@yahoo.com', 'ecf99e68289325d0025b030522f06d11', 'Magdalena ', 'Stosik', 7),
(2, 1, 'admin', '21232f297a57a5a743894a0e4a801fc3', '', '', 0),
(3, 3, 'kompanija@kompanija.com', 'ecf99e68289325d0025b030522f06d11', '', '', 0),
(4, 4, 'magi_s@magi.com', 'ecf99e68289325d0025b030522f06d11', '', '', 0),
(5, 5, 'magi_stosik@magi.com', 'ecf99e68289325d0025b030522f06d11', 'Magi', 'Stosik', 0),
(6, 2, 'silvija_miteva@yahoo.com', 'a1bf6d710d1d365407e2a4f92f1fcdb8', 'Silvija', 'Miteva', 0),
(7, 1, 'kristina_lazarevska@yahoo.com', '15ab465b07f1e770d2ca747ca567384a', 'Kristina', 'Lazarevska', 0),
(8, 4, 'katerina_pop_lazarova@yahoo.com', '16e32c2b68d80f02c4216cf316d870e2', 'Katerina', 'Pop-Lazarova', 0);

/*!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 */;