-- phpMyAdmin SQL Dump -- version 4.1.8 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Nov 06, 2014 at 12:01 AM -- Server version: 5.5.37-cll -- PHP Version: 5.4.23 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: `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', '

\r\n test

\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', '

\r\n 222

\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', '

\r\n 3

\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', '

\r\n aa

\r\n', 'aab', '2013-07-05', 'admin', 'admin', '2013-07-05 10:50:12', '2013-07-05 11:10:15', 85), (10, 'bb', 'bbbbbbbbbbbbb', '

\r\n bbbb

\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', '

\r\n Product 1

\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]', '

\r\n Product 2 desc [en]

\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, '

\r\n Product 2 desc [en]

\r\n', NULL, '12.50'), (33, 'Product 3', 'Product 3', '

\r\n Product 3

\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', '

\r\n Product 4

\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', '

\r\n Product 5

\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', '

\r\n 2

\r\n', 'admin', 'admin', '2013-07-05 11:00:37', '2013-07-05 11:00:37', 'aaa'), (5, '1', '

\r\n 1

\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', '

\r\n test3331

\r\n', '0001', 'admin', 'admin', '2012-09-24 22:12:43', '2012-09-24 22:34:40'), (19, 'service', 'test', '

\r\n testarea

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