-- http://www.phpmyadmin.net
--




--
-- Database: `devdb-backend`
--

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

--
-- Table structure for table `banners`
--

CREATE TABLE IF NOT EXISTS `banners` (
  `banners_id` int(10) NOT NULL AUTO_INCREMENT,
  `banners_file` varchar(255) DEFAULT NULL,
  `banners_comment` longtext,
  `banners_order` int(10) DEFAULT NULL,
  `banners_title` varchar(255) DEFAULT NULL,
  `banners_link` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`banners_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ;

--
-- Dumping data for table `banners`
--

INSERT INTO `banners` (`banners_id`, `banners_file`, `banners_comment`, `banners_order`, `banners_title`, `banners_link`) VALUES
(25, 'resources/banners/nemo.jpg', 'Nemo slider image', 1, NULL, NULL),
(26, 'resources/banners/walle.jpg', 'Walle slider image', 4, NULL, NULL),
(32, 'resources/banners/12731.jpg', 'sdfsdfsd', 3, NULL, NULL),
(34, 'resources/banners/macklemore_thrift_shop_review.jpg', NULL, 2, NULL, NULL);

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

--
-- Table structure for table `blogcategories`
--

CREATE TABLE IF NOT EXISTS `blogcategories` (
  `blogcategories_id` int(10) NOT NULL AUTO_INCREMENT,
  `blogcategories_name` varchar(255) DEFAULT NULL,
  `blogcategories_description` longtext,
  `blogcategories_order` varchar(20) DEFAULT NULL,
  `blogcategories_usercreate` varchar(20) DEFAULT NULL,
  `blogcategories_userupdate` varchar(20) DEFAULT NULL,
  `blogcategories_datecreate` datetime DEFAULT NULL,
  `blogcategories_dateupdate` datetime DEFAULT NULL,
  PRIMARY KEY (`blogcategories_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `blogcategories`
--

INSERT INTO `blogcategories` (`blogcategories_id`, `blogcategories_name`, `blogcategories_description`, `blogcategories_order`, `blogcategories_usercreate`, `blogcategories_userupdate`, `blogcategories_datecreate`, `blogcategories_dateupdate`) VALUES
(2, 'category 2', '', '2', 'admin', 'admin', '2012-10-09 19:29:55', '2012-10-09 19:29:55'),
(3, 'category 3', '', '3', 'admin', 'admin', '2012-10-09 19:30:14', '2012-10-09 19:30:14'),
(4, 'category 1', '', '1', 'admin', 'admin', '2012-10-09 19:30:18', '2012-10-09 19:30:18');

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

--
-- Table structure for table `blogentries`
--

CREATE TABLE IF NOT EXISTS `blogentries` (
  `blogentries_id` int(10) NOT NULL AUTO_INCREMENT,
  `blogentries_title` varchar(255) DEFAULT NULL,
  `blogentries_date` date DEFAULT NULL,
  `blogentries_short_description` longtext,
  `blogentries_description` longtext,
  `blogentries_order` varchar(20) DEFAULT NULL,
  `blogentries_usercreate` varchar(255) DEFAULT NULL,
  `blogentries_userupdate` varchar(255) DEFAULT NULL,
  `blogentries_datecreate` datetime DEFAULT NULL,
  `blogentries_dateupdate` datetime DEFAULT NULL,
  `blogcategories_id` int(10) DEFAULT NULL,
  `blogentries_filecompid` int(10) DEFAULT NULL,
  PRIMARY KEY (`blogentries_id`),
  KEY `FK_blogentries` (`blogcategories_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `blogentries`
--

INSERT INTO `blogentries` (`blogentries_id`, `blogentries_title`, `blogentries_date`, `blogentries_short_description`, `blogentries_description`, `blogentries_order`, `blogentries_usercreate`, `blogentries_userupdate`, `blogentries_datecreate`, `blogentries_dateupdate`, `blogcategories_id`, `blogentries_filecompid`) VALUES
(4, 'tet', '2013-07-05', 'te', '<p>\r\n	test</p>\r\n', 'aaa', 'admin', 'admin', '2013-07-05 10:54:30', '2013-07-05 10:54:30', 4, 89),
(5, '2222', '2013-07-05', '2222', '<p>\r\n	222</p>\r\n', 'aab', 'admin', 'admin', '2013-07-05 10:55:07', '2013-07-05 10:55:07', 4, 90),
(6, '1', '2013-07-05', '2', '<p>\r\n	3</p>\r\n', '4', 'admin', 'admin', '2013-07-05 10:57:57', '2013-07-05 10:57:57', 4, 91);

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

--
-- Table structure for table `blogentriesgallery`
--

CREATE TABLE IF NOT EXISTS `blogentriesgallery` (
  `blogentriesgallery_id` int(10) NOT NULL AUTO_INCREMENT,
  `blogentriesgallery_file` blob,
  `blogentriesgallery_comment` longtext,
  `blogentriesgallery_blogentriesid` int(11) NOT NULL,
  `blogentriesgallery_order` int(10) DEFAULT NULL,
  PRIMARY KEY (`blogentriesgallery_id`),
  KEY `FK_blogentriesgallery` (`blogentriesgallery_blogentriesid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;

--
-- Dumping data for table `blogentriesgallery`
--

INSERT INTO `blogentriesgallery` (`blogentriesgallery_id`, `blogentriesgallery_file`, `blogentriesgallery_comment`, `blogentriesgallery_blogentriesid`, `blogentriesgallery_order`) VALUES
(18, 0x7265736f75726365732f626c6f67656e74726965732f625f4e413d3d2f73706f72745f3331385f746573745f3230312e676966, NULL, 4, NULL);

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

--
-- Table structure for table `colours`
--

CREATE TABLE IF NOT EXISTS `colours` (
  `colours_id` int(10) NOT NULL AUTO_INCREMENT,
  `colours_hex` varchar(10) NOT NULL,
  `colours_name` varchar(255) NOT NULL,
  `colours_usercreate` varchar(255) NOT NULL,
  `colours_userupdate` varchar(255) NOT NULL,
  `colours_datecreate` datetime NOT NULL,
  `colours_dateupdate` datetime NOT NULL,
  PRIMARY KEY (`colours_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `colours`
--

INSERT INTO `colours` (`colours_id`, `colours_hex`, `colours_name`, `colours_usercreate`, `colours_userupdate`, `colours_datecreate`, `colours_dateupdate`) VALUES
(1, '0cf200', 'green', 'admin', 'admin', '2013-07-08 15:40:30', '2013-07-08 17:30:26'),
(2, '000000', 'black', 'admin', 'admin', '2013-07-08 16:26:28', '2013-07-08 17:30:33'),
(3, '0000ff', 'blue', 'admin', 'admin', '2013-07-08 20:37:58', '2013-07-08 20:37:58');

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

--
-- Table structure for table `content`
--

CREATE TABLE IF NOT EXISTS `content` (
  `content_id` varchar(20) NOT NULL,
  `content_text` blob,
  `content_text_fr` blob,
  `content_text_es` blob,
  `content_title` varchar(255) DEFAULT NULL,
  `content_title_fr` varchar(255) DEFAULT NULL,
  `content_title_es` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`content_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `content`
--

INSERT INTO `content` (`content_id`, `content_text`, `content_text_fr`, `content_text_es`, `content_title`, `content_title_fr`, `content_title_es`) VALUES
('ABOUTUS', 0x3c703e0d0a0941626f75742075732064657363205b656e5d3c2f703e0d0a, 0x3c703e0d0a0941626f75742075732064657363205b66725d3c2f703e0d0a, 0x3c703e0d0a0941626f75742075732064657363205b65735d3c2f703e0d0a, 'About us [en]', 'About us [fr]', 'About us [es]'),
('HOME', 0x3c703e0d0a096865726520697320736f6d6520636f6e74656e743c2f703e0d0a, 0x3c703e0d0a09486f6d652064657363205b66725d3c2f703e0d0a, 0x3c703e0d0a09486f6d652064657363205b65735d3c2f703e0d0a, 'my page', 'Home [fr]', 'Home [es]');

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

--
-- Table structure for table `contentgallery`
--

CREATE TABLE IF NOT EXISTS `contentgallery` (
  `contentgallery_id` int(10) NOT NULL AUTO_INCREMENT,
  `contentgallery_file` blob,
  `contentgallery_comment` longtext,
  PRIMARY KEY (`contentgallery_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=51 ;

--
-- Dumping data for table `contentgallery`
--

INSERT INTO `contentgallery` (`contentgallery_id`, `contentgallery_file`, `contentgallery_comment`) VALUES
(49, 0x7265736f75726365732f636f6e74656e742f612e706466, 'desc'),
(50, 0x7265736f75726365732f636f6e74656e742f73706f72745f3331385f746573745f3230312e676966, NULL);

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

--
-- Table structure for table `files`
--

CREATE TABLE IF NOT EXISTS `files` (
  `Id` int(10) NOT NULL AUTO_INCREMENT,
  `IdFileComponent` int(11) DEFAULT NULL,
  `Name` varchar(255) DEFAULT NULL,
  `FileName` varchar(255) DEFAULT NULL,
  `InitialName` varchar(255) DEFAULT NULL,
  `Extension` varchar(10) DEFAULT NULL,
  `FileType` varchar(255) DEFAULT NULL,
  `FileSize` float(15,2) DEFAULT NULL,
  `DbFile` longblob,
  `UserCreate` varchar(50) DEFAULT NULL,
  `UserUpdate` varchar(50) DEFAULT NULL,
  `DateUpdate` datetime DEFAULT NULL,
  `DateCreate` datetime DEFAULT NULL,
  `Label` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `FK_files` (`IdFileComponent`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=114 ;

--
-- Dumping data for table `files`
--

INSERT INTO `files` (`Id`, `IdFileComponent`, `Name`, `FileName`, `InitialName`, `Extension`, `FileType`, `FileSize`, `DbFile`, `UserCreate`, `UserUpdate`, `DateUpdate`, `DateCreate`, `Label`) VALUES
(106, 90, 'sport_318_test-201.gif', '9wqpstpzzt1bxhpfw8wg95t7r7p070fncsjg7xfcvvs8kk3kng', 'sport_318_test-201.gif', 'gif', 'image/gif', 22544.00, '', 'admin', 'admin', '2013-07-05 10:55:24', '2013-07-05 10:55:24', 'upload'),
(107, 99, 'Download Thermory - Thermal treated wood.pdf', 'wsbkj5xj4t9cx_tnz0rgp3x5p0950wr7n5wftz4vc5xmskgpff', 'download_thermory_-_thermal_treated_wood.pdf', 'pdf', 'application/force-download', 1440962.00, '', 'admin', 'admin', '2014-07-03 17:44:49', '2014-07-03 17:44:49', 'upload'),
(108, 99, 'Download Porch Flooring.pdf', 'zrh4zvrghv161vv7bb3bxmcpcyw6gmk0ckpzn__k422r_qmts9', 'download_porch_flooring.pdf', 'pdf', 'application/force-download', 429680.00, '', 'admin', 'admin', '2014-07-03 17:45:00', '2014-07-03 17:45:00', 'upload'),
(109, 99, 'Download Popular Profiles.pdf', '_m_f0574ng_w4_mb3cv8h_8sr2btd47b875c97d3y3_xnzy5sc', 'download_popular_profiles.pdf', 'pdf', 'application/force-download', 133796.00, '', 'admin', 'admin', '2014-07-03 17:45:08', '2014-07-03 17:45:08', 'upload'),
(110, 99, 'Download -MSDS.pdf', 'fs87qhrvpyvdjxfqsps_95b8t_jrgv_r1ngc79qqh6bz80n54s', 'download_-msds.pdf', 'pdf', 'application/force-download', 138664.00, '', 'admin', 'admin', '2014-07-03 17:45:23', '2014-07-03 17:45:23', 'upload'),
(111, 99, 'Download Handbook.pdf', 'v6kdyhftjh2cmrc8bvq9rrnwdv7j706c695xzr11jrgwtzq3fp', 'download_handbook.pdf', 'pdf', 'application/force-download', 997198.00, '', 'admin', 'admin', '2014-07-03 17:45:33', '2014-07-03 17:45:33', 'upload'),
(112, 99, 'Download Decking.pdf', 'y8r336jvwq56cs1drnk2fqgwmj74d980z78bvfp6mzsg1v36kq', 'download_decking.pdf', 'pdf', 'application/force-download', 435025.00, '', 'admin', 'admin', '2014-07-03 17:45:43', '2014-07-03 17:45:43', 'upload'),
(113, 99, 'Download Architect Info.pdf', 'r51c6psry3bkk0bwjcthvb6f_586hppmqzmt4dmtp7q46shmc4', 'download_architect_info.pdf', 'pdf', 'application/force-download', 338974.00, '', 'admin', 'admin', '2014-07-03 17:45:53', '2014-07-03 17:45:53', 'upload');

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

--
-- Table structure for table `file_components`
--

CREATE TABLE IF NOT EXISTS `file_components` (
  `Id` int(10) NOT NULL AUTO_INCREMENT,
  `Name` varchar(150) DEFAULT NULL,
  `Path` varchar(500) DEFAULT NULL,
  `Active` tinyint(1) DEFAULT '1',
  `UserCreate` varchar(50) DEFAULT NULL,
  `UserUpdate` varchar(50) DEFAULT NULL,
  `DateUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `DateCreate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=100 ;

--
-- Dumping data for table `file_components`
--

INSERT INTO `file_components` (`Id`, `Name`, `Path`, `Active`, `UserCreate`, `UserUpdate`, `DateUpdate`, `DateCreate`) VALUES
(76, 'prod_24', NULL, 1, 'admin', 'admin', '2013-07-05 15:34:17', '2013-07-05 15:34:17'),
(77, 'prod_25', NULL, 1, 'admin', 'admin', '2013-07-05 15:42:42', '2013-07-05 15:42:42'),
(78, 'news_2', NULL, 1, 'admin', 'admin', '2013-07-05 15:44:09', '2013-07-05 15:44:09'),
(79, 'news_3', NULL, 1, 'admin', 'admin', '2013-07-05 15:44:26', '2013-07-05 15:44:26'),
(80, 'news_4', NULL, 1, 'admin', 'admin', '2013-07-05 15:45:27', '2013-07-05 15:45:27'),
(81, 'news_5', NULL, 1, 'admin', 'admin', '2013-07-05 15:46:02', '2013-07-05 15:46:02'),
(82, 'news_6', NULL, 1, 'admin', 'admin', '2013-07-05 15:46:21', '2013-07-05 15:46:21'),
(83, 'news_7', NULL, 1, 'admin', 'admin', '2013-07-05 15:47:47', '2013-07-05 15:47:47'),
(84, 'news_8', NULL, 1, 'admin', 'admin', '2013-07-05 15:47:55', '2013-07-05 15:47:55'),
(85, 'news_9', NULL, 1, 'admin', 'admin', '2013-07-05 15:50:12', '2013-07-05 15:50:12'),
(86, 'news_10', NULL, 1, 'admin', 'admin', '2013-07-05 15:50:34', '2013-07-05 15:50:34'),
(87, 'blog_2', NULL, 1, 'admin', 'admin', '2013-07-05 15:51:02', '2013-07-05 15:51:02'),
(88, 'blog_3', NULL, 1, 'admin', 'admin', '2013-07-05 15:52:02', '2013-07-05 15:52:02'),
(89, 'blog_4', NULL, 1, 'admin', 'admin', '2013-07-05 15:54:30', '2013-07-05 15:54:30'),
(90, 'blog_5', NULL, 1, 'admin', 'admin', '2013-07-05 15:55:07', '2013-07-05 15:55:07'),
(91, 'blog_6', NULL, 1, 'admin', 'admin', '2013-07-05 15:57:57', '2013-07-05 15:57:57'),
(92, 'prod_26', NULL, 1, 'admin', 'admin', '2013-07-05 16:21:49', '2013-07-05 16:21:49'),
(93, 'prod_30', NULL, 1, 'admin', 'admin', '2013-07-08 22:28:59', '2013-07-08 22:28:59'),
(94, 'prod_31', NULL, 1, 'admin', 'admin', '2013-07-08 22:29:34', '2013-07-08 22:29:34'),
(95, 'prod_32', NULL, 1, 'admin', 'admin', '2013-07-08 22:31:02', '2013-07-08 22:31:02'),
(96, 'prod_33', NULL, 1, 'admin', 'admin', '2013-07-08 22:31:39', '2013-07-08 22:31:39'),
(97, 'prod_35', NULL, 1, 'admin', 'admin', '2013-07-08 22:34:49', '2013-07-08 22:34:49'),
(98, 'prod_36', NULL, 1, 'admin', 'admin', '2014-07-03 21:24:30', '2014-07-03 21:24:30'),
(99, 'prod_37', NULL, 1, 'admin', 'admin', '2014-07-03 21:29:02', '2014-07-03 21:29:02');

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

--
-- Table structure for table `gallery`
--

CREATE TABLE IF NOT EXISTS `gallery` (
  `gallery_id` int(10) NOT NULL AUTO_INCREMENT,
  `gallery_file` varchar(255) DEFAULT NULL,
  `gallery_comment` longtext,
  `gallery_order` int(10) DEFAULT NULL,
  PRIMARY KEY (`gallery_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;

--
-- Dumping data for table `gallery`
--

INSERT INTO `gallery` (`gallery_id`, `gallery_file`, `gallery_comment`, `gallery_order`) VALUES
(18, 'resources/products/gallery/image_02.jpg', 'desc', 2),
(19, 'resources/products/gallery/image_03.jpg', NULL, 1),
(20, 'resources/gallery/image_04.jpg', NULL, 0);

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

--
-- Table structure for table `news`
--

CREATE TABLE IF NOT EXISTS `news` (
  `news_id` int(10) NOT NULL AUTO_INCREMENT,
  `news_title` varchar(255) DEFAULT NULL,
  `news_short_description` longtext,
  `news_description` longtext,
  `news_order` varchar(10) DEFAULT NULL,
  `news_date` date DEFAULT NULL,
  `news_usercreate` varchar(255) DEFAULT NULL,
  `news_userupdate` varchar(255) DEFAULT NULL,
  `news_datecreate` datetime DEFAULT NULL,
  `news_dateupdate` datetime DEFAULT NULL,
  `news_filecompid` int(10) DEFAULT NULL,
  PRIMARY KEY (`news_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `news`
--

INSERT INTO `news` (`news_id`, `news_title`, `news_short_description`, `news_description`, `news_order`, `news_date`, `news_usercreate`, `news_userupdate`, `news_datecreate`, `news_dateupdate`, `news_filecompid`) VALUES
(9, 'aa', 'aaa', '<p>\r\n	aa</p>\r\n', 'aab', '2013-07-05', 'admin', 'admin', '2013-07-05 10:50:12', '2013-07-05 11:10:15', 85),
(10, 'bb', 'bbbbbbbbbbbbb', '<p>\r\n	bbbb</p>\r\n', 'aaa', '2013-07-05', 'admin', 'admin', '2013-07-05 10:50:34', '2013-07-05 11:10:06', 86);

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

--
-- Table structure for table `newsgallery`
--

CREATE TABLE IF NOT EXISTS `newsgallery` (
  `newsgallery_id` int(10) NOT NULL AUTO_INCREMENT,
  `newsgallery_file` blob,
  `newsgallery_comment` longtext,
  `newsgallery_newsid` int(11) NOT NULL,
  `newsgallery_order` int(10) DEFAULT NULL,
  PRIMARY KEY (`newsgallery_id`),
  KEY `FK_newsgallery` (`newsgallery_newsid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ;

--
-- Dumping data for table `newsgallery`
--

INSERT INTO `newsgallery` (`newsgallery_id`, `newsgallery_file`, `newsgallery_comment`, `newsgallery_newsid`, `newsgallery_order`) VALUES
(24, 0x7265736f75726365732f6e6577732f6e5f4f513d3d2f73706f72745f3331385f746573745f3230312e676966, NULL, 9, NULL);

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

--
-- Table structure for table `orders`
--

CREATE TABLE IF NOT EXISTS `orders` (
  `orders_id` int(10) NOT NULL AUTO_INCREMENT,
  `orders_datecreate` datetime DEFAULT NULL,
  `orders_siteusers_id` int(10) NOT NULL,
  `orders_identifier` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`orders_id`),
  KEY `FK_orders` (`orders_siteusers_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` (`orders_id`, `orders_datecreate`, `orders_siteusers_id`, `orders_identifier`) VALUES
(1, '2013-07-10 01:04:23', 1, '110001');

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

--
-- Table structure for table `ordersxproducts`
--

CREATE TABLE IF NOT EXISTS `ordersxproducts` (
  `ordersxproducts_id` int(10) NOT NULL AUTO_INCREMENT,
  `ordersxproducts_orderid` int(10) NOT NULL,
  `ordersxproducts_prodid` int(10) DEFAULT NULL,
  `ordersxproducts_prodname` varchar(255) DEFAULT NULL,
  `ordersxproducts_prodparent` varchar(255) DEFAULT NULL COMMENT 'category or subcategory',
  `ordersxproducts_prodprice` decimal(13,2) DEFAULT NULL,
  `ordersxproducts_quantity` int(10) DEFAULT NULL,
  PRIMARY KEY (`ordersxproducts_id`),
  KEY `FK_ordersxproducts` (`ordersxproducts_orderid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `ordersxproducts`
--

INSERT INTO `ordersxproducts` (`ordersxproducts_id`, `ordersxproducts_orderid`, `ordersxproducts_prodid`, `ordersxproducts_prodname`, `ordersxproducts_prodparent`, `ordersxproducts_prodprice`, `ordersxproducts_quantity`) VALUES
(1, 1, 25, 'Product name back then 1', 'Parent category name', NULL, 10),
(2, 1, 222, 'Product name back then 2', 'Parent category name', '12.50', 11);

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

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

CREATE TABLE IF NOT EXISTS `products` (
  `products_id` int(10) NOT NULL AUTO_INCREMENT,
  `products_name` varchar(255) DEFAULT NULL,
  `products_short_description` longtext,
  `products_description` longtext,
  `products_order` varchar(10) DEFAULT NULL,
  `products_image` varchar(255) DEFAULT NULL,
  `products_usercreate` varchar(255) DEFAULT NULL,
  `products_userupdate` varchar(255) DEFAULT NULL,
  `products_datecreate` datetime DEFAULT NULL,
  `products_dateupdate` datetime DEFAULT NULL,
  `products_subcategoryid` int(10) DEFAULT NULL,
  `products_categoryid` int(10) DEFAULT NULL,
  `products_filecompid` int(10) DEFAULT NULL,
  `products_quantity` int(100) DEFAULT NULL,
  `products_is_featured` tinyint(1) DEFAULT NULL,
  `products_name_fr` varchar(255) DEFAULT NULL,
  `products_name_es` varchar(255) DEFAULT NULL,
  `products_short_description_fr` longtext,
  `products_short_description_es` longtext,
  `products_description_fr` longtext,
  `products_description_es` longtext,
  `products_price` decimal(13,2) DEFAULT NULL,
  PRIMARY KEY (`products_id`),
  KEY `FK_products` (`products_subcategoryid`),
  KEY `FK_products_fcm` (`products_filecompid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=36 ;

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

INSERT INTO `products` (`products_id`, `products_name`, `products_short_description`, `products_description`, `products_order`, `products_image`, `products_usercreate`, `products_userupdate`, `products_datecreate`, `products_dateupdate`, `products_subcategoryid`, `products_categoryid`, `products_filecompid`, `products_quantity`, `products_is_featured`, `products_name_fr`, `products_name_es`, `products_short_description_fr`, `products_short_description_es`, `products_description_fr`, `products_description_es`, `products_price`) VALUES
(31, 'Product 1', 'Product 1', '<p>\r\n	Product 1</p>\r\n', '0001', '', 'admin', 'admin', '2013-07-08 17:29:34', '2013-07-08 17:29:34', NULL, 6, 94, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(32, 'Product 2 [en]', 'Product 2 d [en]', '<p>\r\n	Product 2 desc [en]</p>\r\n', '0000', '', 'admin', 'admin', '2013-07-08 17:31:02', '2013-07-13 05:39:36', NULL, 4, 95, 0, 0, 'Product 2 [fr]', NULL, 'Product 2 d [en]', NULL, '<p>\r\n	Product 2 desc [en]</p>\r\n', NULL, '12.50'),
(33, 'Product 3', 'Product 3', '<p>\r\n	Product 3</p>\r\n', '0002', '', 'admin', 'admin', '2013-07-08 17:31:39', '2013-07-08 17:31:39', NULL, 6, 96, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(34, 'Product 4', 'Product 4', '<p>\r\n	Product 4</p>\r\n', '0003', '', 'admin', 'admin', '2013-07-08 17:33:20', '2013-07-08 17:33:51', NULL, 5, NULL, 20, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(35, 'Product 5', 'Product 5', '<p>\r\n	Product 5</p>\r\n', '0004', '', 'admin', 'admin', '2013-07-08 17:34:46', '2013-07-08 17:35:29', 1, 6, 97, 11, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `productscategories`
--

CREATE TABLE IF NOT EXISTS `productscategories` (
  `productscategories_id` int(10) NOT NULL AUTO_INCREMENT,
  `productscategories_name` varchar(255) DEFAULT NULL,
  `productscategories_short_description` longtext,
  `productscategories_order` varchar(20) DEFAULT NULL,
  `productscategories_usercreate` varchar(255) DEFAULT NULL,
  `productscategories_userupdate` varchar(255) DEFAULT NULL,
  `productscategories_datecreate` datetime DEFAULT NULL,
  `productscategories_dateupdate` datetime DEFAULT NULL,
  `productscategories_name_fr` varchar(255) DEFAULT NULL,
  `productscategories_name_es` varchar(255) DEFAULT NULL,
  `productscategories_short_description_fr` longtext,
  `productscategories_short_description_es` longtext,
  PRIMARY KEY (`productscategories_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `productscategories`
--

INSERT INTO `productscategories` (`productscategories_id`, `productscategories_name`, `productscategories_short_description`, `productscategories_order`, `productscategories_usercreate`, `productscategories_userupdate`, `productscategories_datecreate`, `productscategories_dateupdate`, `productscategories_name_fr`, `productscategories_name_es`, `productscategories_short_description_fr`, `productscategories_short_description_es`) VALUES
(4, 'Contemporary living', '', '0000', 'admin', 'admin', '2013-03-06 13:30:15', '2013-03-06 13:30:15', NULL, NULL, NULL, NULL),
(5, 'Transational living', '', '0001', 'admin', 'admin', '2013-03-06 13:30:27', '2013-03-06 13:30:36', NULL, NULL, NULL, NULL),
(6, 'Casual living [en]', 'Casual living desc [en]', '0002', 'admin', 'admin', '2013-03-06 13:30:47', '2013-07-09 10:08:47', 'Casual living [fr]', 'Casual living [es]', 'Casual living desc [fr]', 'Casual living desc [es]'),
(7, 'Traditional living', '', '0003', 'admin', 'admin', '2013-03-06 13:30:55', '2013-03-06 13:30:55', NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `productsgallery`
--

CREATE TABLE IF NOT EXISTS `productsgallery` (
  `productsgallery_id` int(10) NOT NULL AUTO_INCREMENT,
  `productsgallery_file` blob,
  `productsgallery_comment` longtext,
  `productsgallery_prodid` int(11) NOT NULL,
  `productsgallery_order` int(10) DEFAULT NULL,
  PRIMARY KEY (`productsgallery_id`),
  KEY `FK_productsgallery` (`productsgallery_prodid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `productssubcategories`
--

CREATE TABLE IF NOT EXISTS `productssubcategories` (
  `productssubcategories_id` int(10) NOT NULL AUTO_INCREMENT,
  `productssubcategories_name` varchar(255) DEFAULT NULL,
  `productssubcategories_short_description` longtext,
  `productssubcategories_order` varchar(10) DEFAULT NULL,
  `productssubcategories_usercreate` varchar(255) DEFAULT NULL,
  `productssubcategories_userupdate` varchar(255) DEFAULT NULL,
  `productssubcategories_datecreate` datetime DEFAULT NULL,
  `productssubcategories_dateupdate` datetime DEFAULT NULL,
  `productssubcategories_categoryid` int(10) DEFAULT NULL,
  `productssubcategories_name_fr` varchar(255) DEFAULT NULL,
  `productssubcategories_name_es` varchar(255) DEFAULT NULL,
  `productssubcategories_short_description_fr` longtext,
  `productssubcategories_short_description_es` longtext,
  PRIMARY KEY (`productssubcategories_id`),
  KEY `FK_productssubcategories` (`productssubcategories_categoryid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `productssubcategories`
--

INSERT INTO `productssubcategories` (`productssubcategories_id`, `productssubcategories_name`, `productssubcategories_short_description`, `productssubcategories_order`, `productssubcategories_usercreate`, `productssubcategories_userupdate`, `productssubcategories_datecreate`, `productssubcategories_dateupdate`, `productssubcategories_categoryid`, `productssubcategories_name_fr`, `productssubcategories_name_es`, `productssubcategories_short_description_fr`, `productssubcategories_short_description_es`) VALUES
(1, 'CL 01 [en]', 'CL 01 desc [en]', '1', 'admin', 'admin', '2013-07-08 17:34:23', '2013-07-09 10:09:27', 6, 'CL 01 [fr]', 'CL 01 [es]', 'CL 01 desc [fr]', 'CL 01 desc [es]');

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

--
-- Table structure for table `productsxcolours`
--

CREATE TABLE IF NOT EXISTS `productsxcolours` (
  `productsxcolours_id` int(10) NOT NULL AUTO_INCREMENT,
  `productsxcolours_prodid` int(10) NOT NULL,
  `productsxcolours_colid` int(10) NOT NULL,
  PRIMARY KEY (`productsxcolours_id`),
  KEY `productsxcolours_prodid` (`productsxcolours_prodid`),
  KEY `productsxcolours_prodid_2` (`productsxcolours_prodid`),
  KEY `productsxcolours_prodid_3` (`productsxcolours_prodid`),
  KEY `FK_productsxcolours` (`productsxcolours_colid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=56 ;

--
-- Dumping data for table `productsxcolours`
--

INSERT INTO `productsxcolours` (`productsxcolours_id`, `productsxcolours_prodid`, `productsxcolours_colid`) VALUES
(36, 31, 3),
(40, 33, 1),
(43, 34, 2),
(44, 34, 1),
(46, 35, 1),
(53, 32, 2),
(54, 32, 3),
(55, 32, 1);

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

--
-- Table structure for table `projects`
--

CREATE TABLE IF NOT EXISTS `projects` (
  `projects_id` int(10) NOT NULL AUTO_INCREMENT,
  `projects_name` varchar(255) DEFAULT NULL,
  `projects_description` text,
  `projects_usercreate` varchar(255) DEFAULT NULL,
  `projects_userupdate` varchar(255) DEFAULT NULL,
  `projects_datecreate` datetime DEFAULT NULL,
  `projects_dateupdate` datetime DEFAULT NULL,
  `projects_order` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`projects_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `projects`
--

INSERT INTO `projects` (`projects_id`, `projects_name`, `projects_description`, `projects_usercreate`, `projects_userupdate`, `projects_datecreate`, `projects_dateupdate`, `projects_order`) VALUES
(4, '2', '<p>\r\n	2</p>\r\n', 'admin', 'admin', '2013-07-05 11:00:37', '2013-07-05 11:00:37', 'aaa'),
(5, '1', '<p>\r\n	1</p>\r\n', 'admin', 'admin', '2013-07-05 11:01:03', '2013-07-05 11:01:03', 'aab');

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

--
-- Table structure for table `projectsgallery`
--

CREATE TABLE IF NOT EXISTS `projectsgallery` (
  `projectsgallery_id` int(10) NOT NULL AUTO_INCREMENT,
  `projectsgallery_file` blob,
  `projectsgallery_comment` longtext,
  `projectsgallery_projid` int(11) NOT NULL,
  `projectsgallery_order` int(10) DEFAULT NULL,
  PRIMARY KEY (`projectsgallery_id`),
  KEY `FK_projectsgallery` (`projectsgallery_projid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;

--
-- Dumping data for table `projectsgallery`
--

INSERT INTO `projectsgallery` (`projectsgallery_id`, `projectsgallery_file`, `projectsgallery_comment`, `projectsgallery_projid`, `projectsgallery_order`) VALUES
(21, 0x7265736f75726365732f70726f6a656374732f70675f4e413d3d2f73706f72745f3331385f746573745f3230312e676966, 'desc', 4, NULL);

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

--
-- Table structure for table `relatedproducts`
--

CREATE TABLE IF NOT EXISTS `relatedproducts` (
  `relatedproducts_id` int(10) NOT NULL AUTO_INCREMENT,
  `relatedproducts_prodid` int(10) NOT NULL,
  `relatedproducts_relprodid` int(10) DEFAULT NULL,
  PRIMARY KEY (`relatedproducts_id`),
  KEY `FK_relatedproducts_id` (`relatedproducts_prodid`),
  KEY `FK_relatedproducts_id2` (`relatedproducts_relprodid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=43 ;

--
-- Dumping data for table `relatedproducts`
--

INSERT INTO `relatedproducts` (`relatedproducts_id`, `relatedproducts_prodid`, `relatedproducts_relprodid`) VALUES
(33, 33, 31),
(34, 33, 32),
(36, 34, 31),
(37, 34, 33),
(39, 35, 34),
(42, 32, 31);

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

--
-- Table structure for table `services`
--

CREATE TABLE IF NOT EXISTS `services` (
  `services_id` int(10) NOT NULL AUTO_INCREMENT,
  `services_title` varchar(255) DEFAULT NULL,
  `services_short_description` longtext,
  `services_description` longtext,
  `services_order` varchar(10) DEFAULT NULL,
  `services_usercreate` varchar(255) DEFAULT NULL,
  `services_userupdate` varchar(255) DEFAULT NULL,
  `services_datecreate` datetime DEFAULT NULL,
  `services_dateupdate` datetime DEFAULT NULL,
  PRIMARY KEY (`services_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

--
-- Dumping data for table `services`
--

INSERT INTO `services` (`services_id`, `services_title`, `services_short_description`, `services_description`, `services_order`, `services_usercreate`, `services_userupdate`, `services_datecreate`, `services_dateupdate`) VALUES
(18, 'test1111', 'test2221', '<p>\r\n	test<strong>3331</strong></p>\r\n', '0001', 'admin', 'admin', '2012-09-24 22:12:43', '2012-09-24 22:34:40'),
(19, 'service', 'test', '<p>\r\n	testarea</p>\r\n', '0000', 'admin', 'admin', '2013-07-05 10:43:45', '2013-07-05 10:43:45');

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

--
-- Table structure for table `siteusers`
--

CREATE TABLE IF NOT EXISTS `siteusers` (
  `siteusers_id` int(10) NOT NULL AUTO_INCREMENT,
  `siteusers_username` varchar(20) DEFAULT NULL,
  `siteusers_password` varchar(20) DEFAULT NULL,
  `siteusers_fname` varchar(255) DEFAULT NULL,
  `siteusers_lname` varchar(255) DEFAULT NULL,
  `siteusers_contact_email` varchar(255) DEFAULT NULL,
  `siteusers_company_name` varchar(255) DEFAULT NULL,
  `siteusers_company_address` longtext,
  `siteusers_company_phone` varchar(255) DEFAULT NULL,
  `siteusers_company_website` varchar(255) DEFAULT NULL,
  `siteusers_datecreate` datetime DEFAULT NULL,
  `siteusers_dateupdate` datetime DEFAULT NULL,
  `siteusers_userupdate` varchar(255) DEFAULT NULL,
  `siteusers_active` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`siteusers_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `siteusers`
--

INSERT INTO `siteusers` (`siteusers_id`, `siteusers_username`, `siteusers_password`, `siteusers_fname`, `siteusers_lname`, `siteusers_contact_email`, `siteusers_company_name`, `siteusers_company_address`, `siteusers_company_phone`, `siteusers_company_website`, `siteusers_datecreate`, `siteusers_dateupdate`, `siteusers_userupdate`, `siteusers_active`) VALUES
(1, 'radualex', 'radualexp', 'Radu (e)', 'Alex (e)', 'radu@gmail.com', 'RAI SOFT (e)', 'PItesti, Arges, RO (e)', '0747087555 (e)', 'www.rai.ro (e)', '2013-07-09 18:58:16', '2013-07-10 00:25:21', 'admin', 1),
(2, 'andrew', 'andrew', 'Andrew', 'K.', 'andrew@email.com', 'SWS', 'Canada', 'xxxxxxxxx', 'www.sws.com', '2013-07-10 01:11:08', '2013-07-09 18:26:01', 'admin', 0);

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

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

CREATE TABLE IF NOT EXISTS `users` (
  `users_id` int(10) NOT NULL AUTO_INCREMENT,
  `users_username` varchar(20) NOT NULL,
  `users_password` varchar(255) NOT NULL,
  `users_email` varchar(255) DEFAULT NULL,
  `users_firstname` varchar(255) NOT NULL,
  `users_lastname` varchar(255) NOT NULL,
  `users_active` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`users_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

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

INSERT INTO `users` (`users_id`, `users_username`, `users_password`, `users_email`, `users_firstname`, `users_lastname`, `users_active`) VALUES
(1, 'admin', 'admin', 'admin@admin.ro', 'radu', 'alex', 1);

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

--
-- Table structure for table `userssettings`
--

CREATE TABLE IF NOT EXISTS `userssettings` (
  `userssettings_id` int(10) NOT NULL AUTO_INCREMENT,
  `userssettings_users_id` int(10) NOT NULL,
  PRIMARY KEY (`userssettings_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `_config`
--

CREATE TABLE IF NOT EXISTS `_config` (
  `Code` varchar(100) NOT NULL,
  `Value` longtext,
  PRIMARY KEY (`Code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `_config`
--

INSERT INTO `_config` (`Code`, `Value`) VALUES
('RAISOFT_FCM_MAX_SIZE', '10240'),
('RAISOFT_FCM_ALLOWED_EXT', 'gif;png;jpg;pdf;doc;docx;xls;xlsx;txt;'),
('RAISOFT_FCM_UPLOAD_DB', '0'),
('RAISOFT_FCM_UPLOAD_DIR', '/resources/products/fcm'),
('RAISOFT_FCM_LANGUAGE', 'en'),
('RAISOFT_FCM_TEMPLATE', 'Original'),
('RAISOFT_FCM_ADM_PASS', '21232f297a57a5a743894a0e4a801fc3'),
('RAISOFT_FCM_ADM_USER', 'admin');

--
-- Constraints for dumped tables
--

--
-- Constraints for table `blogentries`
--
ALTER TABLE `blogentries`
  ADD CONSTRAINT `FK_blogentries` FOREIGN KEY (`blogcategories_id`) REFERENCES `blogcategories` (`blogcategories_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `blogentriesgallery`
--
ALTER TABLE `blogentriesgallery`
  ADD CONSTRAINT `FK_blogentriesgallery` FOREIGN KEY (`blogentriesgallery_blogentriesid`) REFERENCES `blogentries` (`blogentries_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `files`
--
ALTER TABLE `files`
  ADD CONSTRAINT `FK_files` FOREIGN KEY (`IdFileComponent`) REFERENCES `file_components` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `newsgallery`
--
ALTER TABLE `newsgallery`
  ADD CONSTRAINT `FK_newsgallery` FOREIGN KEY (`newsgallery_newsid`) REFERENCES `news` (`news_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `orders`
--
ALTER TABLE `orders`
  ADD CONSTRAINT `FK_orders` FOREIGN KEY (`orders_siteusers_id`) REFERENCES `siteusers` (`siteusers_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `ordersxproducts`
--
ALTER TABLE `ordersxproducts`
  ADD CONSTRAINT `FK_ordersxproducts` FOREIGN KEY (`ordersxproducts_orderid`) REFERENCES `orders` (`orders_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `FK_products_fcm` FOREIGN KEY (`products_filecompid`) REFERENCES `file_components` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `productsgallery`
--
ALTER TABLE `productsgallery`
  ADD CONSTRAINT `FK_productsgallery` FOREIGN KEY (`productsgallery_prodid`) REFERENCES `products` (`products_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `productssubcategories`
--
ALTER TABLE `productssubcategories`
  ADD CONSTRAINT `FK_productssubcategories` FOREIGN KEY (`productssubcategories_categoryid`) REFERENCES `productscategories` (`productscategories_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `productsxcolours`
--
ALTER TABLE `productsxcolours`
  ADD CONSTRAINT `FK_productsxcolours` FOREIGN KEY (`productsxcolours_colid`) REFERENCES `colours` (`colours_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_productsxcolours_prod` FOREIGN KEY (`productsxcolours_prodid`) REFERENCES `products` (`products_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `projectsgallery`
--
ALTER TABLE `projectsgallery`
  ADD CONSTRAINT `FK_projectsgallery` FOREIGN KEY (`projectsgallery_projid`) REFERENCES `projects` (`projects_id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `relatedproducts`
--
ALTER TABLE `relatedproducts`
  ADD CONSTRAINT `FK_relatedproducts_id` FOREIGN KEY (`relatedproducts_prodid`) REFERENCES `products` (`products_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `FK_relatedproducts_id2` FOREIGN KEY (`relatedproducts_relprodid`) REFERENCES `products` (`products_id`) ON DELETE CASCADE ON UPDATE CASCADE;

