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




--
-- Database: `directsuites`
--

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

--
-- Table structure for table `attributes`
--

CREATE TABLE IF NOT EXISTS `attributes` (
  `index` int(11) NOT NULL auto_increment,
  `id` int(11) NOT NULL default '0',
  `title` varchar(100) NOT NULL default '',
  `parentid` int(11) NOT NULL default '-1',
  `value` varchar(150) NOT NULL default '',
  `productid` int(11) NOT NULL default '0',
  `sortorder` int(11) NOT NULL default '0',
  PRIMARY KEY  (`index`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3781 ;

--
-- Dumping data for table `attributes`
--


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

--
-- Table structure for table `baskets`
--

CREATE TABLE IF NOT EXISTS `baskets` (
  `basketID` int(11) NOT NULL auto_increment,
  `basketSession` varchar(50) default NULL,
  `productID` int(11) default NULL,
  `productPrice` float(7,2) default NULL,
  `productoptions` varchar(255) NOT NULL default '',
  `productoptionsforstock` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`basketID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=565 ;

--
-- Dumping data for table `baskets`
--


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

--
-- Table structure for table `categories`
--

CREATE TABLE IF NOT EXISTS `categories` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(100) NOT NULL default '',
  `metadescription` text NOT NULL,
  `metakeywords` text NOT NULL,
  `categorytext` text NOT NULL,
  `parentid` int(11) NOT NULL default '0',
  `imageurl` varchar(255) NOT NULL default '',
  `keywords` varchar(100) NOT NULL default '',
  `catorder` int(11) NOT NULL default '0',
  `displaycategorytitle` int(11) NOT NULL default '1',
  `positionoftext` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=68 ;

--
-- Dumping data for table `categories`
--


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

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

CREATE TABLE IF NOT EXISTS `content` (
  `id` int(11) NOT NULL auto_increment,
  `content` mediumblob NOT NULL,
  `title` varchar(150) NOT NULL default '',
  `img` varchar(155) NOT NULL default '',
  `location` varchar(50) NOT NULL default '',
  `admindescription` text NOT NULL,
  `perm` int(11) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=38 ;

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

INSERT INTO `content` (`id`, `content`, `title`, `img`, `location`, `admindescription`, `perm`) VALUES
(14, 0x[BLOB], 'homepage', '', '', '', 1),
(3, 0x3c703e3c7370616e207374796c653d22666f6e742d73697a653a20736d616c6c3b223e3c7370616e207374796c653d22636f6c6f723a20233939333330303b223e53616c65205072696365203c2f7370616e3e3c2f7370616e3e3c2f703e, 'special offer text', '', '', 'Where ever a sale price is displayed', 1),
(4, '', 'standard price', '', '', 'Where ever a standard price is displayed', 1),
(10, 0x3c703e5465726d733c2f703e, 'terms', '', '', '', 1),
(16, 0x3c703e4469726563745375697465732e6e65743c2f703e, 'Site Title', '', '', 'In the browser title bar', 1),
(17, '', 'meta keywords', '', '', 'in the meta keywords tags on every page', 1),
(18, '', 'meta description', '', '', 'In the meta description tags on every page', 1),
(19, 0x[BLOB], 'Status Message', '', '', '', 1),
(20, 0x[BLOB], 'Default Payment Error', '', '', 'Whenever a customer returns from payment page with an unspecified error', 1),
(21, 0x[BLOB], 'Payment Error Bad Card', '', '', 'Whenever a customer returns from payment page with a bad card error', 1),
(22, 0x[BLOB], 'Payment Error payment Gateway fault', '', '', 'Whenever a customer returns from payment page with a payment Gateway fault', 1),
(23, 0x[BLOB], 'Payment Error cancelled', '', '', 'Whenever a customer returns from payment page by cancelling', 1),
(24, 0x[BLOB], 'Payment Error Rejected', '', '', 'Whenever a customer returns from payment page with a rejected order', 1),
(25, 0x[BLOB], 'Payment Success', '', '', 'Displayed on successful purchase', 1),
(26, 0x3c703e4469726563745375697465732e6e6574206261736b6574207570646174653c2f703e, 'during order email subject', '', '', 'during order email subject', 1),
(27, 0x[BLOB], 'during order email message', '', '', 'during order email message', 1),
(28, 0x3c703e4469726563745375697465732e6e6574206f7264657220537563636573733c2f703e, 'successful order email subject', '', '', 'successful order email subject', 1),
(29, 0x[BLOB], 'successful order email message', '', '', 'successful order email message', 1),
(30, 0x3c703e6661696c6564206f7264657220656d61696c207375626a6563743c2f703e, 'failed order email subject', '', '', 'failed order email subject', 1),
(31, 0x3c703e6661696c6564206f7264657220656d61696c206d6573736167653c2f703e, 'failed order email message', '', '', 'failed order email message', 1),
(32, 0x3c703e54686572652069732063757272656e746c79206e6f2073746f636b20666f722074686973206974656d3c2f703e, 'no stock message', '', '', 'no stock message', 1),
(33, 0x3c703e3c7374726f6e673e4e6f2073746f636b2e3c2f7374726f6e673e20506c656173652063616c6c203031393532203530362038323220666f72206164766963652061626f7574206f75722073746f636b2e3c2f703e, 'no stock with these options', '', '', 'when choosing product attributes on product detail page eg; colour or size and there is no stock', 1),
(34, 0x3c7072652069643d226c696e6531223e4469726563745375697465732e6e65743c2f7072653e, 'home page title', '', '', 'In the browser title bar ONLY on the homepage', 1),
(35, 0x3c703e3c7374726f6e673e3c7370616e207374796c653d22636f6c6f723a20233939333330303b223e467265653c2f7370616e3e3c2f7374726f6e673e20554b205368697070696e67206f6e2074686973204974656d3c2f703e, 'free shipping on product page', '', '', 'free shipping message on product detail page', 1),
(36, 0x3c703e3c7370616e207374796c653d22636f6c6f723a20233939333330303b223e46726565203c2f7370616e3e7368697070696e6720746f20554b206d61696e6c616e643c2f703e, 'free shipping in basket', '', '', 'free shipping message on basket billing info page', 1),
(37, '', 'home page under category list', '', '', 'home page under category list', 1);

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

--
-- Table structure for table `menu`
--

CREATE TABLE IF NOT EXISTS `menu` (
  `id` int(11) NOT NULL default '0',
  `parentid` int(11) NOT NULL default '0',
  `title` varchar(100) NOT NULL default '',
  `link` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `menu`
--


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

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

CREATE TABLE IF NOT EXISTS `products` (
  `id` int(11) NOT NULL auto_increment,
  `productName` varchar(50) default NULL,
  `productImage` varchar(250) default NULL,
  `productPrice` float(7,2) default NULL,
  `category` int(11) NOT NULL default '0',
  `shortdescription` varchar(255) NOT NULL default '',
  `description` blob NOT NULL,
  `categories` varchar(255) NOT NULL default '',
  `image1` varchar(150) NOT NULL default '',
  `image2` varchar(150) NOT NULL default '',
  `image3` varchar(150) NOT NULL default '',
  `image4` varchar(150) NOT NULL default '',
  `image5` varchar(150) NOT NULL default '',
  `specialprice` float NOT NULL default '0',
  `enabled` int(11) NOT NULL default '1',
  `freeshipping` int(11) NOT NULL default '0',
  `shipping` float NOT NULL default '0',
  `stock` int(11) NOT NULL default '1',
  `stockoptions` text NOT NULL,
  `onoffer` int(11) NOT NULL default '0',
  `featured` int(11) NOT NULL default '0',
  `metakeywords` text NOT NULL,
  `metadescription` text NOT NULL,
  `sku` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=211 ;

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


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

--
-- Table structure for table `sales`
--

CREATE TABLE IF NOT EXISTS `sales` (
  `id` int(11) NOT NULL auto_increment,
  `datetime` datetime NOT NULL default '0000-00-00 00:00:00',
  `status` int(11) NOT NULL default '0',
  `VPSTxId` varchar(100) NOT NULL default '',
  `TxAuthNo` varchar(10) NOT NULL default '',
  `Amount` varchar(20) NOT NULL default '',
  `CardType` varchar(25) NOT NULL default '',
  `Last4Digits` varchar(5) NOT NULL default '',
  `strBillingFirstnames` varchar(50) NOT NULL default '',
  `strBillingSurname` varchar(50) NOT NULL default '',
  `strBillingAddress1` varchar(100) NOT NULL default '',
  `strBillingCity` varchar(50) NOT NULL default '',
  `strBillingPostCode` varchar(10) NOT NULL default '',
  `strBillingCountry` varchar(5) NOT NULL default '',
  `strBillingPhone` varchar(30) NOT NULL default '',
  `strCustomerEMail` varchar(100) NOT NULL default '',
  `ordersummary` text NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=111 ;

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

--
-- Table structure for table `stats`
--

CREATE TABLE IF NOT EXISTS `stats` (
  `id` int(11) NOT NULL auto_increment,
  `productid` int(11) NOT NULL default '0',
  `ipaddress` varchar(20) NOT NULL default '',
  `datetime` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1695 ;
