-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Mar 22, 2013 at 08:46 PM
-- Server version: 5.1.54
-- PHP Version: 5.3.5
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!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: `cmsdb`
--
-- --------------------------------------------------------
--
-- Table structure for table `category`
--
CREATE TABLE IF NOT EXISTS `category` (
`CategoryId` int(11) NOT NULL AUTO_INCREMENT,
`CategoryName` varchar(255) NOT NULL,
`CategoryDescription` varchar(255) NOT NULL,
`CompanyId` int(11) NOT NULL,
PRIMARY KEY (`CategoryId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;
--
-- Dumping data for table `category`
--
INSERT INTO `category` (`CategoryId`, `CategoryName`, `CategoryDescription`, `CompanyId`) VALUES
(2, 'Shoes', 'All Shoes types', 1),
(3, 'Beauty', 'Beauty', 1),
(4, 'Bed And Bath', 'Bed And Bath', 1),
(5, 'Clothing', 'Clothing', 1),
(6, 'Fitness And Sport', 'Fitness & Sport', 1),
(11, 'Health', 'Dog Health producten', 3),
(12, 'Male', 'male Dogs', 3),
(13, 'Female', 'Female dogs', 3),
(14, 'Dogs Clothing', 'Dogs Clothing', 3),
(15, 'Elektronic', 'Elektronic', 3),
(16, 'gnsgdsn', 'hngds', 4),
(17, 'fbrsavwrb', 'GSEABE', 4),
(18, 'FBSDA', 'ASFADVGS', 4),
(19, 'fsabda', 'fsavdcs', 4),
(20, 'fsadvs', 'FSdvCA', 4);
-- --------------------------------------------------------
--
-- Table structure for table `company`
--
CREATE TABLE IF NOT EXISTS `company` (
`CompanyId` int(11) NOT NULL AUTO_INCREMENT,
`CompanyName` varchar(255) NOT NULL,
`Company_Mission` varchar(255) NOT NULL,
`Company_Vission` varchar(255) NOT NULL,
`Company_Slogon` varchar(255) NOT NULL,
`Company_Logo` varchar(100) DEFAULT NULL,
`Company_LogoUrl` varchar(45) DEFAULT NULL,
PRIMARY KEY (`CompanyId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `company`
--
INSERT INTO `company` (`CompanyId`, `CompanyName`, `Company_Mission`, `Company_Vission`, `Company_Slogon`, `Company_Logo`, `Company_LogoUrl`) VALUES
(1, 'Coesus', 'Be Better', 'Be Better', 'Be Better at fashion', NULL, 'Home.php?CId=1&pid=1'),
(3, 'Bradas Kennel', 'We want to sell the Baddes PittBulls in Suriname', 'We simple want to be the best in Suriname', 'All Pitts at Bradas Kennel', NULL, 'Home.php?CId=3&pid=1'),
(4, 'Dogs', 'Dogs', 'Dogs', 'Dogs', NULL, 'Home.php?CId=4&pid=1');
-- --------------------------------------------------------
--
-- Table structure for table `company_styles`
--
CREATE TABLE IF NOT EXISTS `company_styles` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`CompanyID` int(11) NOT NULL,
`Company_Style_Id` int(11) NOT NULL,
PRIMARY KEY (`Id`),
UNIQUE KEY `CompanyID` (`CompanyID`,`Company_Style_Id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
--
-- Dumping data for table `company_styles`
--
INSERT INTO `company_styles` (`Id`, `CompanyID`, `Company_Style_Id`) VALUES
(5, 1, 4),
(7, 3, 5),
(8, 4, 3);
-- --------------------------------------------------------
--
-- Table structure for table `events`
--
CREATE TABLE IF NOT EXISTS `events` (
`EventID` int(11) NOT NULL AUTO_INCREMENT,
`EventName` varchar(255) DEFAULT NULL,
`EventUrl` varchar(255) DEFAULT NULL,
`EventTitle` varchar(255) DEFAULT NULL,
`CompanyID` int(11) NOT NULL,
PRIMARY KEY (`EventID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
--
-- Dumping data for table `events`
--
INSERT INTO `events` (`EventID`, `EventName`, `EventUrl`, `EventTitle`, `CompanyID`) VALUES
(3, 'Fashoin Show', '#', 'fashion is Life', 1),
(4, 'New jeans Merk', '#', 'New jeans Merk 2', 1),
(9, 'Test', '#', 'test', 3),
(10, 'Test 2', '#', 'eeee', 3),
(12, 'yrwtewrg', '#', 'ywtqr', 4);
-- --------------------------------------------------------
--
-- Table structure for table `links`
--
CREATE TABLE IF NOT EXISTS `links` (
`LinkID` int(11) NOT NULL AUTO_INCREMENT,
`LinkName` varchar(255) NOT NULL,
`LinkUrl` varchar(255) DEFAULT NULL,
`LinkImage` varchar(255) DEFAULT NULL,
`LinkDescription` varchar(255) NOT NULL,
`LinkVisible` int(11) NOT NULL,
`CompanyId` int(11) NOT NULL,
PRIMARY KEY (`LinkID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ;
--
-- Dumping data for table `links`
--
INSERT INTO `links` (`LinkID`, `LinkName`, `LinkUrl`, `LinkImage`, `LinkDescription`, `LinkVisible`, `CompanyId`) VALUES
(16, 'HOME', 'Home.php?CId=1&pid=16', NULL, 'Home Page', 1, 1),
(17, 'CONTACT US', 'Page.php?CId=1&pid=17', NULL, 'Contact page 8877665544', 1, 1),
(18, 'ABOUT US', 'Page.php?CId=1&pid=18', NULL, 'ABOUT Page This is me and you', 1, 1),
(22, 'HOME', 'Home.php?CId=3&pid=22', NULL, 'Home Page', 1, 3),
(23, 'ABOUT US', 'Page.php?CId=3&pid=23', NULL, 'Ons Missie Is: We want to sell the Baddes PittBulls in Suriname <br/> En Vissie:We simple want to be the best in Suriname', 1, 3),
(24, 'CONTACT US', 'Page.php?CId=3&pid=24', NULL, 'CONTACT Page', 1, 3),
(25, 'HOME', 'Home.php?CId=4&pid=25', NULL, 'Home Page', 1, 4),
(26, 'ABOUT US', 'Page.php?CId=4&pid=26', NULL, 'Ons Missie Is: Dogs <br/> En Vissie:Dogs', 1, 4),
(27, 'CONTACT US', 'Page.php?CId=4&pid=27', NULL, 'CONTACT Page', 1, 4);
-- --------------------------------------------------------
--
-- Table structure for table `products`
--
CREATE TABLE IF NOT EXISTS `products` (
`Prod_Id` int(11) NOT NULL AUTO_INCREMENT,
`Product_Name` varchar(255) NOT NULL,
`Product_Price` float NOT NULL,
`Product_Description` varchar(255) NOT NULL,
`Product_Image` varchar(255) DEFAULT NULL,
`Product_Discount` float DEFAULT NULL,
`CategoryId` int(11) NOT NULL,
`CompanyID` int(11) NOT NULL,
PRIMARY KEY (`Prod_Id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;
--
-- Dumping data for table `products`
--
INSERT INTO `products` (`Prod_Id`, `Product_Name`, `Product_Price`, `Product_Description`, `Product_Image`, `Product_Discount`, `CategoryId`, `CompanyID`) VALUES
(13, 'D & G trui', 30, 'D & G Baseball hemd', NULL, 0, 5, 1),
(14, 'Armani jeans', 200, 'new Armani Jeans for Men', NULL, 0, 5, 1),
(18, 'Bruintje pit', 200, 'Bruintje pit', NULL, 0, 13, 3),
(19, 'Bleu', 300, 'Bleu', NULL, 0, 12, 3);
-- --------------------------------------------------------
--
-- Table structure for table `rechten`
--
CREATE TABLE IF NOT EXISTS `rechten` (
`idRechten` int(11) NOT NULL AUTO_INCREMENT,
`RechtName` varchar(145) DEFAULT NULL,
`RechtImage` varchar(145) DEFAULT NULL,
`RechtUrl` varchar(145) DEFAULT NULL,
PRIMARY KEY (`idRechten`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
--
-- Dumping data for table `rechten`
--
INSERT INTO `rechten` (`idRechten`, `RechtName`, `RechtImage`, `RechtUrl`) VALUES
(1, 'Products', '../Images/Admin/prod.png', 'Product.php?Compid='),
(2, 'New Category', '../Images/Admin/cat.png', 'Category.php?Compid='),
(3, 'Events', '../Images/Admin/eve.png', 'Events.php?Compid='),
(4, 'New Company', '../Images/Admin/com.png', 'Company.php?Compid='),
(5, 'My Company', '../Images/Admin/com.png', 'MyCompany.php?Compid='),
(6, 'Links', '../Images/Admin/i.png', 'Links.php?Compid='),
(7, 'Themes', '../Images/Admin/fol2.png', 'Themes.php?Compid=');
-- --------------------------------------------------------
--
-- Table structure for table `roles`
--
CREATE TABLE IF NOT EXISTS `roles` (
`RoleId` int(11) NOT NULL AUTO_INCREMENT,
`Role` varchar(145) DEFAULT NULL,
PRIMARY KEY (`RoleId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `roles`
--
INSERT INTO `roles` (`RoleId`, `Role`) VALUES
(1, 'Admin'),
(2, 'User');
-- --------------------------------------------------------
--
-- Table structure for table `role_rechten`
--
CREATE TABLE IF NOT EXISTS `role_rechten` (
`idRole_Rechten` int(11)
