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




--
-- Database: `funkystuffdb`
--

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

--
-- Table structure for table `bookmark`
--

CREATE TABLE `bookmark` (
  `bookmark_id` bigint(12) unsigned NOT NULL auto_increment,
  `company_id` int(8) NOT NULL,
  `remote_ip` varchar(20) NOT NULL,
  `bookmark_time` datetime NOT NULL,
  PRIMARY KEY  (`bookmark_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=29 ;

--
-- Dumping data for table `bookmark`
--

INSERT INTO `bookmark` VALUES(1, 1, '180.234.203.111', '2012-04-07 05:56:21');
INSERT INTO `bookmark` VALUES(2, 3, '180.234.203.111', '2012-04-07 05:56:25');
INSERT INTO `bookmark` VALUES(3, 2, '180.234.203.111', '2012-04-07 09:48:57');
INSERT INTO `bookmark` VALUES(4, 2, '98.80.100.138', '2012-04-07 11:02:03');
INSERT INTO `bookmark` VALUES(5, 2, '180.234.16.143', '2012-04-09 09:04:46');
INSERT INTO `bookmark` VALUES(6, 3, '180.234.16.143', '2012-04-09 09:07:17');
INSERT INTO `bookmark` VALUES(7, 1, '180.234.16.143', '2012-04-09 09:07:30');
INSERT INTO `bookmark` VALUES(8, 5, '180.234.16.143', '2012-04-09 09:13:17');
INSERT INTO `bookmark` VALUES(9, 5, '123.49.51.50', '2012-04-09 21:14:29');
INSERT INTO `bookmark` VALUES(10, 2, '123.49.51.50', '2012-04-09 21:14:35');
INSERT INTO `bookmark` VALUES(11, 2, '98.67.240.100', '2012-04-10 18:37:08');
INSERT INTO `bookmark` VALUES(12, 10, '180.234.47.149', '2012-05-04 10:42:06');
INSERT INTO `bookmark` VALUES(13, 8, '180.234.47.149', '2012-05-04 10:42:18');
INSERT INTO `bookmark` VALUES(14, 10, '180.234.235.230', '2012-05-05 01:26:51');
INSERT INTO `bookmark` VALUES(15, 13, '180.234.235.230', '2012-05-05 01:27:05');
INSERT INTO `bookmark` VALUES(16, 11, '180.234.235.230', '2012-05-05 01:27:16');
INSERT INTO `bookmark` VALUES(17, 6, '58.97.210.99', '2012-05-13 03:39:58');
INSERT INTO `bookmark` VALUES(18, 3, '58.97.210.99', '2012-05-13 03:40:00');
INSERT INTO `bookmark` VALUES(19, 2, '58.97.210.99', '2012-05-13 03:40:05');
INSERT INTO `bookmark` VALUES(20, 1, '58.97.210.99', '2012-05-13 03:40:07');
INSERT INTO `bookmark` VALUES(21, 3, '180.234.102.161', '2012-05-15 09:31:25');
INSERT INTO `bookmark` VALUES(22, 6, '180.234.102.161', '2012-05-15 09:31:29');
INSERT INTO `bookmark` VALUES(23, 1, '180.234.102.161', '2012-05-15 09:31:33');
INSERT INTO `bookmark` VALUES(24, 2, '180.234.98.63', '2012-05-18 23:47:58');
INSERT INTO `bookmark` VALUES(25, 6, '180.234.98.63', '2012-05-18 23:48:04');
INSERT INTO `bookmark` VALUES(26, 6, '180.234.37.54', '2012-06-01 21:55:05');
INSERT INTO `bookmark` VALUES(27, 20, '180.234.195.60', '2012-06-03 08:37:53');
INSERT INTO `bookmark` VALUES(28, 2, '180.234.195.60', '2012-06-03 08:38:03');

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

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

CREATE TABLE `categories` (
  `category_id` int(5) NOT NULL auto_increment,
  `category_name` varchar(200) NOT NULL,
  `category_order` int(5) NOT NULL,
  `category_status` enum('Active','Inactive') character set utf8 NOT NULL default 'Active',
  PRIMARY KEY  (`category_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=34 ;

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

INSERT INTO `categories` VALUES(1, 'Astronomy', 1, 'Active');
INSERT INTO `categories` VALUES(2, 'Beverages', 2, 'Active');
INSERT INTO `categories` VALUES(3, 'Books', 3, 'Active');
INSERT INTO `categories` VALUES(4, 'Clubs', 4, 'Active');
INSERT INTO `categories` VALUES(5, 'Clothings', 5, 'Active');
INSERT INTO `categories` VALUES(7, 'Establishments', 6, 'Active');
INSERT INTO `categories` VALUES(8, 'Electronics', 7, 'Active');
INSERT INTO `categories` VALUES(9, 'Events', 9, 'Active');
INSERT INTO `categories` VALUES(10, 'Food', 10, 'Active');
INSERT INTO `categories` VALUES(11, 'Furniture', 11, 'Active');
INSERT INTO `categories` VALUES(12, 'Games', 12, 'Active');
INSERT INTO `categories` VALUES(13, 'Health', 13, 'Active');
INSERT INTO `categories` VALUES(14, 'History', 14, 'Active');
INSERT INTO `categories` VALUES(15, 'Household', 15, 'Active');
INSERT INTO `categories` VALUES(16, 'Informatives', 16, 'Active');
INSERT INTO `categories` VALUES(17, 'Kids', 17, 'Active');
INSERT INTO `categories` VALUES(18, 'Adventure', 1, 'Active');
INSERT INTO `categories` VALUES(19, 'Art', 1, 'Active');
INSERT INTO `categories` VALUES(20, 'Love', 20, 'Active');
INSERT INTO `categories` VALUES(21, 'Nature', 21, 'Active');
INSERT INTO `categories` VALUES(22, 'Non-profit', 22, 'Active');
INSERT INTO `categories` VALUES(23, 'Relegion', 23, 'Active');
INSERT INTO `categories` VALUES(24, 'Relationships', 24, 'Active');
INSERT INTO `categories` VALUES(25, 'Technology', 25, 'Active');
INSERT INTO `categories` VALUES(26, 'Travel', 26, 'Active');
INSERT INTO `categories` VALUES(27, 'Toys', 27, 'Active');
INSERT INTO `categories` VALUES(28, 'Tools', 28, 'Active');
INSERT INTO `categories` VALUES(29, 'Transportation', 29, 'Active');
INSERT INTO `categories` VALUES(30, 'Weapons', 30, 'Active');
INSERT INTO `categories` VALUES(31, 'World', 31, 'Active');
INSERT INTO `categories` VALUES(32, 'Other', 32, 'Active');
INSERT INTO `categories` VALUES(33, 'Music', 0, 'Active');

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

--
-- Table structure for table `event`
--

CREATE TABLE `event` (
  `event_id` int(2) NOT NULL auto_increment,
  `event_name` varchar(100) NOT NULL,
  `event_date` datetime NOT NULL,
  PRIMARY KEY  (`event_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `event`
--

INSERT INTO `event` VALUES(1, 'Sangeet and Mehndi', '2012-09-21 19:00:00');
INSERT INTO `event` VALUES(2, 'Wedding Ceremony', '2012-09-23 09:00:00');
INSERT INTO `event` VALUES(3, 'Wedding Reception', '2012-09-23 18:00:00');

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

--
-- Table structure for table `event_to_guest`
--

CREATE TABLE `event_to_guest` (
  `event_id` int(5) NOT NULL,
  `invitation_id` int(5) NOT NULL,
  `no_of_guest` int(3) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `event_to_guest`
--

INSERT INTO `event_to_guest` VALUES(1, 1, 4);
INSERT INTO `event_to_guest` VALUES(3, 1, 5);

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

--
-- Table structure for table `feedback`
--

CREATE TABLE `feedback` (
  `feedback_id` bigint(12) NOT NULL auto_increment,
  `name` varchar(150) NOT NULL,
  `email` varchar(100) NOT NULL,
  `comments` text NOT NULL,
  `add_date` datetime NOT NULL,
  PRIMARY KEY  (`feedback_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `groups`
--

CREATE TABLE `groups` (
  `group_id` int(5) NOT NULL auto_increment,
  `group_name` varchar(200) NOT NULL,
  `group_order` int(5) NOT NULL,
  `group_status` enum('Active','Inactive') NOT NULL default 'Active',
  PRIMARY KEY  (`group_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `groups`
--

INSERT INTO `groups` VALUES(1, 'Products', 1, 'Active');
INSERT INTO `groups` VALUES(2, 'Services', 2, 'Active');
INSERT INTO `groups` VALUES(3, 'Places', 3, 'Active');
INSERT INTO `groups` VALUES(4, 'People', 4, 'Active');
INSERT INTO `groups` VALUES(5, 'Animals', 5, 'Active');
INSERT INTO `groups` VALUES(6, 'Sports', 6, 'Active');
INSERT INTO `groups` VALUES(7, 'Hobbies', 7, 'Active');
INSERT INTO `groups` VALUES(8, 'Entertainment', 8, 'Active');
INSERT INTO `groups` VALUES(9, 'Education', 9, 'Active');
INSERT INTO `groups` VALUES(10, 'Misc', 10, 'Active');

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

--
-- Table structure for table `invitation`
--

CREATE TABLE `invitation` (
  `invitation_id` int(5) NOT NULL auto_increment,
  `invitation_code` varchar(30) NOT NULL,
  `guest_name` varchar(200) NOT NULL,
  `guest_email` varchar(50) NOT NULL,
  `guest_phone` varchar(20) NOT NULL,
  `status` enum('Active','Inactive') NOT NULL,
  PRIMARY KEY  (`invitation_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `invitation`
--

INSERT INTO `invitation` VALUES(1, '11456', 'kazi Abdullah Al Mamun', 'sumon.du@gmail.com', '8801674981927', 'Active');

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

--
-- Table structure for table `invited_guest`
--

CREATE TABLE `invited_guest` (
  `invite_id` int(5) NOT NULL auto_increment,
  `invitation_id` int(5) NOT NULL,
  `event_id` int(2) NOT NULL,
  `invite_title` varchar(25) NOT NULL,
  `invite_f_name` varchar(50) NOT NULL,
  `invite_l_name` varchar(50) NOT NULL,
  PRIMARY KEY  (`invite_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `invited_guest`
--

INSERT INTO `invited_guest` VALUES(1, 1, 1, 'Mr.', 'Kazi Abdullah', 'Al Mamun');
INSERT INTO `invited_guest` VALUES(2, 1, 3, 'Mr.', 'Kazi Abdullah', 'Al Mamun');
INSERT INTO `invited_guest` VALUES(3, 1, 3, 'Ms.', 'Farjana', 'Sharmin');

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

--
-- Table structure for table `tb_style`
--

CREATE TABLE `tb_style` (
  `style_id` varchar(50) collate latin1_general_ci NOT NULL,
  `style_name` varchar(30) collate latin1_general_ci default NULL,
  `style_qty` varchar(10) collate latin1_general_ci default NULL,
  `style_color` varchar(20) collate latin1_general_ci default NULL,
  `style_size` varchar(100) collate latin1_general_ci default NULL,
  `img_title` varchar(50) collate latin1_general_ci default NULL,
  `img_location` varchar(100) collate latin1_general_ci default NULL,
  `style_type` varchar(15) collate latin1_general_ci default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `tb_style`
--

INSERT INTO `tb_style` VALUES('3-man', 'Round neck', '792', '11', 'Small, Mediam, Large, XL, XL2, XL5', NULL, 'product/3-man.jpg', 'man');
INSERT INTO `tb_style` VALUES('2-kid', 'Round neck hooded', '328', '12', 'Small, Mediam, Large, XL, XL2', NULL, 'product/2-kid.jpg', 'kid');
INSERT INTO `tb_style` VALUES('5-kid', 'Round neck', '792', ' 11', 'Small, Mediam, Large, XL, XL2, XL5 ', NULL, 'product/5-kid.jpg', 'kid');
INSERT INTO `tb_style` VALUES('4-man', 'Round neck hooded', '328', '12', 'Small, Mediam, Large, XL, XL2', NULL, 'product/4-man.jpg', 'man');
INSERT INTO `tb_style` VALUES('5-man', 'Round neck hooded-full zip', '228', '5', 'Small, Mediam, Large, XL, XL2 ', NULL, 'product/5-man.jpg', 'man');
INSERT INTO `tb_style` VALUES('6-woman', 'Round neck with hood ', '261', '7', 'Mix size.', NULL, 'product/6-woman.jpg', 'woman');
INSERT INTO `tb_style` VALUES('7-woman', 'Round neck hooded-full zip ', '440', '12', 'Small, Mediam, Large, XL, XL2', NULL, 'product/7-woman.jpg', 'woman');
INSERT INTO `tb_style` VALUES('8-woman', 'Round neck-full zip', '294', '7', 'Small, Mediam, Large, XL, XL2', NULL, 'product/8-woman.jpg', 'woman');

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

--
-- Table structure for table `user_list`
--

CREATE TABLE `user_list` (
  `user_id` bigint(10) NOT NULL auto_increment,
  `recomended_id` varchar(20) NOT NULL,
  `job_id` varchar(20) NOT NULL,
  `datetime` datetime NOT NULL,
  PRIMARY KEY  (`user_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `user_list`
--

INSERT INTO `user_list` VALUES(1, 'RLNX02P5YR89JZ8X9CJ2', 'J3G87072WTDVKQMC19M', '2012-06-15 02:47:49');
INSERT INTO `user_list` VALUES(2, 'RLNX02P5YR89JZ8X9CJ2', 'J3J4WL76G5VMKW35CGQ', '2012-06-15 05:32:10');

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

--
-- Table structure for table `user_view`
--

CREATE TABLE `user_view` (
  `user_id` bigint(10) NOT NULL auto_increment,
  `recomended_id` varchar(20) NOT NULL,
  `job_id` varchar(20) NOT NULL,
  `datetime` datetime NOT NULL,
  PRIMARY KEY  (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `user_view`
--

