-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `flexdwcb_b24_16373649_angel`
--

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

--
-- Table structure for table `mem_signup`
--

CREATE TABLE `mem_signup` (
  `mem_id` int(5) NOT NULL,
  `userid` varchar(15) NOT NULL,
  `password` varchar(32) NOT NULL,
  `email` varchar(75) NOT NULL,
  `fname` varchar(50) NOT NULL,
  `lname` varchar(50) NOT NULL,
  `add1` varchar(100) NOT NULL,
  `add2` varchar(100) NOT NULL,
  `city` varchar(100) NOT NULL,
  `state` varchar(100) NOT NULL,
  `country` varchar(100) NOT NULL,
  `zip` varchar(6) NOT NULL,
  `occu1` varchar(50) NOT NULL,
  `occu2` varchar(50) NOT NULL,
  `occu3` varchar(50) NOT NULL,
  `abtme` varchar(400) NOT NULL,
  `mbcast` varchar(100) NOT NULL,
  `link1` varchar(100) NOT NULL,
  `link2` varchar(100) NOT NULL,
  `link3` varchar(100) NOT NULL,
  `titls` varchar(50) NOT NULL,
  `contact` varchar(50) NOT NULL,
  `pads1` varchar(50) NOT NULL,
  `dtj` datetime NOT NULL,
  `ip` varchar(16) NOT NULL,
  `status` char(1) NOT NULL,
  `dtl` text DEFAULT NULL,
  `profile_photo` varchar(200) DEFAULT NULL,
  `profile_photo2` varchar(200) DEFAULT NULL,
  `profile_photo1` varchar(200) DEFAULT NULL,
  `profile_photo3` varchar(200) DEFAULT NULL,
  `profile_photo4` varchar(200) DEFAULT NULL,
  `profile_pic` varchar(200) DEFAULT NULL,
  `profile-photo6` varchar(200) DEFAULT NULL,
  `profile-photo7` varchar(200) DEFAULT NULL,
  `profile-photo8` varchar(200) DEFAULT NULL,
  `profile-main-media` varchar(200) DEFAULT NULL,
  `promotions` varchar(200) DEFAULT NULL,
  `promotion1` varchar(200) DEFAULT NULL,
  `flexmusic` varchar(200) DEFAULT NULL,
  `flexvideo` varchar(200) DEFAULT NULL,
  `p_id` int(3) NOT NULL,
  `p_name` varchar(100) NOT NULL,
  `price` decimal(5,2) NOT NULL,
  `img` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `pic2` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `pic3` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `pic4` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `mem_signup`
--

INSERT INTO `mem_signup` (`mem_id`, `userid`, `password`, `email`, `fname`, `lname`, `add1`, `add2`, `city`, `state`, `country`, `zip`, `occu1`, `occu2`, `occu3`, `abtme`, `mbcast`, `link1`, `link2`, `link3`, `titls`, `contact`, `pads1`, `dtj`, `ip`, `status`, `dtl`, `profile_photo`, `profile_photo2`, `profile_photo1`, `profile_photo3`, `profile_photo4`, `profile_pic`, `profile-photo6`, `profile-photo7`, `profile-photo8`, `profile-main-media`, `promotions`, `promotion1`, `flexmusic`, `flexvideo`, `p_id`, `p_name`, `price`, `img`, `pic2`, `pic3`, `pic4`) VALUES
(3, 'siteadmin', 'ae2b1fca515949e5d54fb22b8ed95575', 'siteadmin@domain.com', 'site admin', 'admin site', '520', 'A', 'City details', 'state', 'USA', '3456', 'website designer', 'biz Opp provider', 'networker', 'Flexgloble welcomes all genuine people from the public to use this website as a source portal, to promote opportunities, entertainment, information, products and services etc. You can use this website to your advantage whether your a seeker or a provider this depends on your needs !!!\r\n\r\n\r\nJoin Us and broadcast your skills, services, products, content, and more for free. \r\n\r\n\r\n', 'free promos', 'soon', 'soon', 'soon', 'mr', 'on request', 'other stuff', '2012-03-02 00:00:00', '127.0.0.1', 'B', '', '3.jpg', '3.jpg', NULL, '3.jpg', '3.jpg', '', NULL, NULL, NULL, '', '', '3.jpg', '', '', 1, 'Rose', 20.34, 'rose.jpg', '', '', '');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `mem_signup`
--
ALTER TABLE `mem_signup`
  ADD PRIMARY KEY (`mem_id`),
  ADD KEY `p_id` (`p_id`) USING BTREE,
  ADD KEY `userid` (`userid`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `mem_signup`
--
ALTER TABLE `mem_signup`
  MODIFY `mem_id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
COMMIT;

