1#@!#!123s

: / home / probwael / public_html /
Filename : _SQL.txt
back
-- phpMyAdmin SQL Dump
-- version 3.1.3.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 09, 2018 at 11:15 PM
-- Server version: 5.1.33
-- PHP Version: 5.2.9

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `snso`
--

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

--
-- Table structure for table `newsletter_subscribers`
--

CREATE TABLE IF NOT EXISTS `newsletter_subscribers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dname` varchar(60) NOT NULL,
  `demail` varchar(60) NOT NULL,
  `local_ip` varchar(100) NOT NULL,
  `dtime` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `newsletter_subscribers`
--

INSERT INTO `newsletter_subscribers` (`id`, `dname`, `demail`, `local_ip`, `dtime`) VALUES
(1, 'Lucky Uzoma', 'luzomamicrosystems@gmail.com', '127.0.0.1', '07-Jul-2018 - 09:02 pm');

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

--
-- Table structure for table `_dcart`
--

CREATE TABLE IF NOT EXISTS `_dcart` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pid` varchar(30) NOT NULL,
  `sid` varchar(30) NOT NULL,
  `dcategory` varchar(100) NOT NULL,
  `transid` varchar(30) NOT NULL,
  `iprice` varchar(30) NOT NULL DEFAULT '0',
  `iquantity` varchar(30) NOT NULL DEFAULT '0',
  `tprice` varchar(30) NOT NULL DEFAULT '0',
  `cname` varchar(120) NOT NULL,
  `cmail` varchar(60) NOT NULL,
  `cphone` varchar(30) NOT NULL,
  `caddress` varchar(230) NOT NULL,
  `extrainfo` varchar(2000) NOT NULL,
  `pay_option` varchar(30) NOT NULL,
  `dtime` varchar(30) NOT NULL,
  `status` varchar(30) NOT NULL DEFAULT 'pending',
  `pay_status` varchar(20) NOT NULL DEFAULT 'pending',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `_dcart`
--

INSERT INTO `_dcart` (`id`, `pid`, `sid`, `dcategory`, `transid`, `iprice`, `iquantity`, `tprice`, `cname`, `cmail`, `cphone`, `caddress`, `extrainfo`, `pay_option`, `dtime`, `status`, `pay_status`) VALUES
(3, '3', '201807132440', 'Furniture', '180709133400', '27500', '2', '55000', 'Lucky Uzoma', 'luzomamicrosystems@gmail.com', '08069524047', 'No. 5 Thompson Street, Rumuodomaya', '', '', '09-Jul-2018 02:30 pm', 'pending', 'pending'),
(4, '2', '201807132217', 'Furniture', '180709133400', '27000', '1', '27000', 'Lucky Uzoma', 'luzomamicrosystems@gmail.com', '08069524047', 'No. 5 Thompson Street, Rumuodomaya', '', '', '09-Jul-2018 02:31 pm', 'pending', 'pending'),
(5, '3', '201807132440', 'Furniture', '180709160429', '27500', '1', '27500', 'Lucky Uzoma', 'luzomamicrosystems@gmail.com', '08069524047', 'No. 5 Thompson Street, Rumuodomaya', '', '', '09-Jul-2018 03:05 pm', 'pending', 'pending'),
(6, '3', '201807132440', 'Furniture', '180709163128', '27500', '1', '27500', 'Lucky I. Uzoma', 'luzomamicrosystems@gmail.com', '08069524047', 'No. 5 Thompson Street, Rumuodomaya', '', '', '09-Jul-2018 03:34 pm', 'pending', 'pending'),
(7, '3', '201807132440', 'Furniture', '180709163834', '27500', '1', '27500', 'Lucky I. Uzoma', 'luzomamicrosystems@gmail.com', '08069524047', 'No. 5 Thompson Street, Rumuodomaya', '', '', '09-Jul-2018 03:38 pm', 'pending', 'pending');

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

--
-- Table structure for table `_dcategories`
--

CREATE TABLE IF NOT EXISTS `_dcategories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dcat` varchar(250) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `_dcategories`
--

INSERT INTO `_dcategories` (`id`, `dcat`) VALUES
(1, 'Furniture'),
(2, 'Flowers and Decorations'),
(3, 'Building Materials'),
(4, 'Electricals and Appliances'),
(5, 'Electronics');

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

--
-- Table structure for table `_dpics`
--

CREATE TABLE IF NOT EXISTS `_dpics` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sid` varchar(30) NOT NULL,
  `picid` varchar(30) NOT NULL,
  `transid` varchar(30) NOT NULL,
  `status` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `_dpics`
--

INSERT INTO `_dpics` (`id`, `sid`, `picid`, `transid`, `status`) VALUES
(1, '201807131848', '201807131848-1', '201807131848', ''),
(2, '201807132217', '201807132217-1', '201807132217', ''),
(3, '201807132440', '201807132440-1', '201807132440', ''),
(4, '201807131848', '20180709132702', '201807131848', '');

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

--
-- Table structure for table `_dproducts`
--

CREATE TABLE IF NOT EXISTS `_dproducts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sid` varchar(30) NOT NULL,
  `icode` varchar(100) NOT NULL,
  `icategory` varchar(250) NOT NULL,
  `subcat` varchar(120) NOT NULL,
  `ititle` varchar(250) NOT NULL,
  `descr` varchar(9999) NOT NULL,
  `rprice` varchar(30) NOT NULL DEFAULT '0',
  `iprice` varchar(30) NOT NULL DEFAULT '0',
  `iquantity` varchar(30) NOT NULL DEFAULT '0',
  `tprice` varchar(30) NOT NULL DEFAULT '0',
  `prneg` varchar(10) NOT NULL,
  `status` varchar(30) NOT NULL,
  `featured` varchar(30) NOT NULL DEFAULT 'no',
  `istock` varchar(60) NOT NULL DEFAULT 'In-stock',
  `transid` varchar(30) NOT NULL,
  `dtime` varchar(30) NOT NULL,
  `iviews` varchar(30) NOT NULL DEFAULT '0',
  `archived` varchar(10) NOT NULL DEFAULT 'no',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `_dproducts`
--

INSERT INTO `_dproducts` (`id`, `sid`, `icode`, `icategory`, `subcat`, `ititle`, `descr`, `rprice`, `iprice`, `iquantity`, `tprice`, `prneg`, `status`, `featured`, `istock`, `transid`, `dtime`, `iviews`, `archived`) VALUES
(1, '201807131848', '', 'Electricals and Appliances', '', 'Puck Wall Lamp', 'Puck is one of Orsjo classic ranges. A timeless design combined with effortless function and an effective light source.', '15000', '12500', '', '0', '', '', 'no', 'In-stock', '201807131848', '09-Jul-2018 13:18 pm', '0', 'no'),
(2, '201807132217', '', 'Furniture', '', 'Lounge Chair', 'With its streamlined curves and angles, the Risom side chair exhibits the designers taste for well-crafted Scandinavian Modernism.', '28000', '27000', '', '0', '', '', 'no', 'In-stock', '201807132217', '09-Jul-2018 13:22 pm', '0', 'no'),
(3, '201807132440', '', 'Furniture', '', 'Side Chair', 'With its streamlined curves and angles, the Risom side chair exhibits the designer&acircs taste for well-crafted Scandinavian Modernism.', '29000', '27500', '', '0', '', '', 'no', 'In-stock', '201807132440', '09-Jul-2018 13:24 pm', '0', 'no');

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

--
-- Table structure for table `_dsubcats`
--

CREATE TABLE IF NOT EXISTS `_dsubcats` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dcat` varchar(250) NOT NULL,
  `dsubcat` varchar(250) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `_dsubcats`
--


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

--
-- Table structure for table `_register`
--

CREATE TABLE IF NOT EXISTS `_register` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(60) NOT NULL,
  `pword` varchar(60) NOT NULL,
  `fullname` varchar(120) NOT NULL,
  `gender` varchar(10) NOT NULL,
  `phone` varchar(30) NOT NULL,
  `postal` varchar(120) NOT NULL,
  `city` varchar(500) NOT NULL,
  `state` varchar(250) NOT NULL,
  `country` varchar(250) NOT NULL,
  `dbalance` varchar(30) NOT NULL DEFAULT '0',
  `regdate` varchar(60) NOT NULL,
  `pic` varchar(9999) NOT NULL,
  `picid` varchar(60) NOT NULL,
  `newsletter` varchar(10) NOT NULL,
  `advices` varchar(10) NOT NULL,
  `status` varchar(30) NOT NULL DEFAULT 'offline',
  `lastlogin` varchar(60) NOT NULL,
  `visits` varchar(30) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

--
-- Dumping data for table `_register`
--

INSERT INTO `_register` (`id`, `email`, `pword`, `fullname`, `gender`, `phone`, `postal`, `city`, `state`, `country`, `dbalance`, `regdate`, `pic`, `picid`, `newsletter`, `advices`, `status`, `lastlogin`, `visits`) VALUES
(1, 'luzomamicrosystems@gmail.com', 'luzoma', 'Lucky I. Uzoma', '', '08069524047', 'No. 5 Thompson Street, Rumuodomaya', '', '', '', '0', '21-Dec-2016 - 11:32 pm', '', '', '', '', 'offline', '09-Jul-2018 - 03:50 pm', '1'),
(9, 'roselyn@yahoo.com', 'roselyn', 'Roseline Kudu', '', '08135031057', 'No.3 Chad street, Port Harcourt, Nigeria', '', '', '', '0', '05-Jul-2018 - 03:40 pm', '', '', '', '', 'offline', '07-Jul-2018 - 08:28 pm', '1');

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

--
-- Table structure for table `_security`
--

CREATE TABLE IF NOT EXISTS `_security` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `email` varchar(60) NOT NULL,
  `uname` varchar(60) NOT NULL,
  `pword` varchar(60) NOT NULL,
  `dcompany` varchar(250) NOT NULL,
  `address` varchar(250) NOT NULL,
  `dphone` varchar(30) NOT NULL,
  `dphone2` varchar(30) NOT NULL,
  `demail` varchar(60) NOT NULL,
  `dwebsite` varchar(120) NOT NULL,
  `icurrency` varchar(30) NOT NULL DEFAULT '&pound;',
  `aboutus` mediumtext NOT NULL,
  `dterms` longtext NOT NULL,
  `dservices` mediumtext NOT NULL,
  `dlogo` varchar(120) NOT NULL DEFAULT 'default.png',
  `dtitle` varchar(300) NOT NULL DEFAULT 'My Shopping Cart ',
  `social_fb` varchar(350) NOT NULL DEFAULT '#',
  `social_tw` varchar(350) NOT NULL DEFAULT '#',
  `social_lk` varchar(350) NOT NULL DEFAULT '#',
  `social_gp` varchar(350) NOT NULL DEFAULT '#',
  `social_in` varchar(350) NOT NULL DEFAULT '#',
  `status` varchar(30) NOT NULL DEFAULT 'offline',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `_security`
--

INSERT INTO `_security` (`id`, `email`, `uname`, `pword`, `dcompany`, `address`, `dphone`, `dphone2`, `demail`, `dwebsite`, `icurrency`, `aboutus`, `dterms`, `dservices`, `dlogo`, `dtitle`, `social_fb`, `social_tw`, `social_lk`, `social_gp`, `social_in`, `status`) VALUES
(1, 'admin@snsoproperty.com', 'admin', 'admin100@', 'SNSO Property', '', '', '', 'info@snsoproperty.com', 'snsoproperty.com', '₦', 'About us information goes here...', 'Terms and conditions information goes here...', 'Our Services Information here...', 'default.png', 'SNSO Property', '#', '#', '', '#', '', 'online');