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




--
-- Database: `ksoft_ananda_v2`
--

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

--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `id` int(11) NOT NULL,
  `title` text NOT NULL,
  `content` text NOT NULL,
  `thumb_image` text NOT NULL,
  `images` text NOT NULL,
  `date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `events`
--

INSERT INTO `events` (`id`, `title`, `content`, `thumb_image`, `images`, `date`) VALUES
(1, 'Maroons Night 20145', 'Dubai. Featuring “Chill Outâ€ (leading band from Sri Lanka) with Ronnie Leitch and Sajee Lamahewa. At Zabeel Ballroom, Radisson Blu Hotel, Dubai Deira Creek on Thursday the 27th March 2014 from 7.30 PM onwardsd', '57f96b1d92bc4.thumb.png', '1', '2015-07-19'),
(5, 'awrudu function', 'to be held on 10th april 2018                      ', '1523465752_122.png', '1', '2018-03-20'),
(32, 'Maroons Night 2014', 'Dubai. Featuring “Chill Outâ€ (leading band from Sri Lanka) with Ronnie Leitch and Sajee Lamahewa. At Zabeel Ballroom, Radisson Blu Hotel, Dubai Deira Creek on Thursday the 27th March 2014 from 7.30 PM onwards.', '1523610038_12.png', '1', '2018-04-13'),
(33, 'event 18thldk', 'sdlfkjkl', '1523629931_Events image.png', '1', '2018-04-20');

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

--
-- Table structure for table `gallery`
--

CREATE TABLE `gallery` (
  `id` int(11) NOT NULL,
  `image` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `gallery`
--

INSERT INTO `gallery` (`id`, `image`) VALUES
(103, '5ad1d19a7150f.thumb.png'),
(121, '5ad2d476c5dc9.thumb.png'),
(122, '5ad2d495a305d.thumb.png');

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

--
-- Table structure for table `images`
--

CREATE TABLE `images` (
  `id` int(11) NOT NULL,
  `image` text NOT NULL,
  `content_type` varchar(255) DEFAULT NULL,
  `fk_content_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `images`
--

INSERT INTO `images` (`id`, `image`, `content_type`, `fk_content_id`) VALUES
(2, '15234671615ace439963661.1.png', 'news', 14),
(36, '15235106565aceed80b7e8f.0.png', 'events', 1),
(37, '15235106565aceed80b7e8f.1.png', 'events', 1),
(38, '15235106565aceed80b7e8f.2.png', 'events', 1),
(39, '15235106995aceedab5cd48.0.png', 'events', 5),
(40, '15235106995aceedab5cd48.1.png', 'events', 5),
(43, '15235150835acefecbefafd.0.png', 'news', 12),
(44, '15235150835acefecbefafd.1.JPG', 'news', 12),
(45, '15235150835acefecbefafd.2.png', 'news', 12),
(46, '15235728075acfe0478537d.0.png', 'events', 25),
(47, '15235728075acfe0478537d.1.jpg', 'events', 25),
(48, '15235750275acfe8f365e6c.0.png', 'events', 29),
(49, '15235750275acfe8f365e6c.1.jpg', 'events', 29),
(50, '15235754225acfea7e0d4ed.0.png', 'news', 17),
(51, '15235754225acfea7e0d4ed.1.jpg', 'news', 17),
(52, '15235758485acfec2855ad0.0.png', 'news', 18),
(53, '15235758485acfec2855ad0.1.jpg', 'news', 18),
(54, '15235765245acfeecc553bc.0.png', 'news', 19),
(55, '15235765245acfeecc553bc.1.jpg', 'news', 19),
(56, '15235772885acff1c8e96a0.0.png', 'news', 20),
(57, '15235772885acff1c8e96a0.1.jpg', 'news', 20),
(58, '15235775045acff2a0d80ed.0.png', 'news', 21),
(59, '15235775045acff2a0d80ed.1.jpg', 'news', 21),
(62, '15235777785acff3b2ad643.0.png', 'events', 31),
(63, '15235777785acff3b2ad643.1.jpg', 'events', 31),
(64, '15235777785acff3b2ad643.2.png', 'events', 31),
(65, '15235778505acff3faca647.0.png', 'events', 32),
(66, '15235778505acff3faca647.1.png', 'events', 32),
(67, '15236299315ad0bf6bd4831.0.png', 'events', 33),
(68, '15236299315ad0bf6bd4831.1.jpg', 'events', 33),
(69, '15236301265ad0c02ecf6a1.0.png', 'news', 22),
(70, '15236301265ad0c02ecf6a1.1.jpg', 'news', 22),
(72, '5ad1d19a7150f.original.png', 'gallery', 103),
(73, '5ad1d2612bebe.original.png', 'gallery', 104),
(74, '5ad1d2dbcf96f.original.png', 'gallery', 105),
(75, '5ad1d3353f254.original.png', 'gallery', 106),
(76, '5ad1d3d715147.original.png', 'gallery', 107),
(77, '5ad1d463bdc54.original.png', 'gallery', 108),
(78, '5ad1d493dabe1.original.png', 'gallery', 109),
(79, '5ad1d4d42bab3.original.png', 'gallery', 110),
(80, '5ad1df352a97c.original.png', 'gallery', 111),
(81, '5ad1e0fa0125c.original.png', 'gallery', 112),
(82, '5ad1e17e959b8.original.png', 'gallery', 113),
(83, '5ad1e53266bc8.original.png', 'gallery', 114),
(84, '5ad2c5154c46b.original.png', 'gallery', 115),
(85, '5ad2c55f4b985.original.png', 'gallery', 116),
(86, '5ad2c5ee0c0ce.original.png', 'gallery', 117),
(88, '5ad2ca879ccac.original.jpg', 'gallery', 120),
(89, '5ad2d476c5dc9.original.jpg', 'gallery', 121),
(90, '5ad2d495a305d.original.jpg', 'gallery', 122);

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

--
-- Table structure for table `members`
--

CREATE TABLE `members` (
  `table_id` int(10) NOT NULL,
  `surname` varchar(100) DEFAULT NULL,
  `forenames` varchar(255) DEFAULT NULL,
  `mem_id` varchar(12) DEFAULT NULL,
  `mem_name` varchar(255) DEFAULT NULL,
  `sl_address` text,
  `uae_address` text,
  `uae_fix_phone` text,
  `uae_m_phone` text,
  `sl_fix_phone` text,
  `sl_m_phone` text,
  `batch` int(5) DEFAULT NULL,
  `company` varchar(50) DEFAULT NULL,
  `b_day` date DEFAULT NULL,
  `profession` varchar(25) DEFAULT NULL,
  `status` varchar(10) DEFAULT NULL,
  `comments` text,
  `image` text,
  `payment_amt` varchar(10) DEFAULT NULL,
  `payment_id` varchar(15) DEFAULT NULL,
  `admission_no` varchar(10) DEFAULT NULL,
  `alevel` int(11) DEFAULT NULL,
  `olevel` int(11) DEFAULT NULL,
  `college_from` int(11) DEFAULT NULL,
  `college_to` int(11) DEFAULT NULL,
  `extra_cur` varchar(255) DEFAULT NULL,
  `hostel_from` int(11) DEFAULT NULL,
  `hostel_to` int(11) DEFAULT NULL,
  `ref_name1` varchar(100) DEFAULT NULL,
  `ref_email1` varchar(50) DEFAULT NULL,
  `ref_mem_no1` varchar(20) DEFAULT NULL,
  `ref_name2` varchar(100) DEFAULT NULL,
  `ref_email2` varchar(50) DEFAULT NULL,
  `ref_mem_no2` varchar(20) DEFAULT NULL,
  `designation` varchar(50) DEFAULT NULL,
  `education` varchar(255) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `emirate` varchar(100) DEFAULT NULL,
  `telephone_office` varchar(20) DEFAULT NULL,
  `telephone_res` varchar(20) DEFAULT NULL,
  `official_addr` varchar(255) DEFAULT NULL,
  `payment_method` varchar(30) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `members`
--

INSERT INTO `members` (`table_id`, `surname`, `forenames`, `mem_id`, `mem_name`, `sl_address`, `uae_address`, `uae_fix_phone`, `uae_m_phone`, `sl_fix_phone`, `sl_m_phone`, `batch`, `company`, `b_day`, `profession`, `status`, `comments`, `image`, `payment_amt`, `payment_id`, `admission_no`, `alevel`, `olevel`, `college_from`, `college_to`, `extra_cur`, `hostel_from`, `hostel_to`, `ref_name1`, `ref_email1`, `ref_mem_no1`, `ref_name2`, `ref_email2`, `ref_mem_no2`, `designation`, `education`, `email`, `emirate`, `telephone_office`, `telephone_res`, `official_addr`, `payment_method`) VALUES
(11, '', '', '001', 'test123', '', '', '0551234567', '0551234567', '0717333073', '', 2010, 'test', '1970-01-01', 'test', 'married', '', '', '', '', '', 0, 0, -1, -1, '', -1, -1, '', '', '', '', '', '', '', '', '', '', '', '', '', 'Cash'),
(15, 'sdfkabcd', 'sdkl', '10001', 'sdkl', '', 'klsdsdfsdfsdfsdfsd', NULL, NULL, NULL, NULL, NULL, NULL, '1981-10-04', 'klsd', NULL, NULL, NULL, '2342', 'ksldf', 'sdfkl', 302, 201, 201, 202, 'klsdf', -1, 23, 'klsd', 'kljsl', '23423423', 'klsd', 'klsdkl', 'sdfsd', 'klsd', 'sfskdl', 'klsd', 'ksd', '234345', '23423', 'klsdjfk', 'Money Order'),
(19, 'sdfsdf', 'sdfsd', '19', 'sdfs', '', 'sdf', NULL, NULL, NULL, NULL, NULL, NULL, '1999-01-23', 'cxvsd', NULL, NULL, NULL, '234', 'sdfsdf', 'sdfs', 23, 23, 24, 234, 'sdfs', 23, 23, 'sdfs', 'sdfs', 'sdfs', 'sdf', 'sdf', 'sdfs', 'sdfs', 'sdfs', 'xcv', 'cvxc', 'sdfs', '23423', 'sdfs', 'Postal Order'),
(20, 'sdfsdf', 'sdfsd', '21', 'sdfs', 'sdfs', 'sdf', NULL, NULL, NULL, NULL, NULL, NULL, '1999-01-23', 'cxvsd', NULL, NULL, NULL, '234', 'sdfsdf', 'sdfs', 23, 23, 24, 234, 'sdfs', 23, 23, 'sdfs', 'sdfs', 'sdfs', 'sdf', 'sdf', 'sdfs', 'sdfs', 'sdfs', 'xcv', 'cvxc', 'sdfs', '23423', 'sdfs', 'Postal Order'),
(29, 'sdfsdf', 'sdfsd', '29', 'sdfs', 'sdfs', 'sdf', NULL, NULL, NULL, NULL, NULL, NULL, '1999-01-23', 'cxvsd', NULL, NULL, NULL, '234', 'sdfsdf', 'sdfs', 23, 23, 24, 234, 'sdfs', 23, 23, 'sdfs', 'sdfs', 'sdfs', 'sdf', 'sdf', 'sdfs', 'sdfs', 'sdfs', 'xcv', 'cvxc', 'sdfs', '23423', 'sdfs', 'Postal Order'),
(30, 'sdfsdf', 'sdfsd', '30', 'sdfs', 'sdfs', 'sdf', NULL, NULL, NULL, NULL, NULL, NULL, '1999-01-23', 'cxvsd', NULL, NULL, NULL, '234', 'sdfsdf', 'sdfs', 23, 23, 24, 234, 'sdfs', 23, 23, 'sdfs', 'sdfs', 'sdfs', 'sdf', 'sdf', 'sdfs', 'sdfs', 'sdfs', 'xcv', 'cvxc', 'sdfs', '23423', 'sdfs', 'Postal Order'),
(31, 'sdfsd', 'efe', '31', 'sefsdfs', '', 'adfsdfsd', NULL, NULL, NULL, NULL, NULL, NULL, '1990-10-04', '', NULL, NULL, NULL, '', '', '', -1, -1, 2001, 2007, '', -1, -1, 'd', 'sefs', 'sdfs', 'sdfs', 'sdf', 'sdf', 'sdfsdf', '', 'dfsdf', 'sdfwdf', '', '342342', '', 'Cash'),
(32, 'sdfsd', 'efe', '32', 'sefsdfs', '', 'adfsdfsd', NULL, NULL, NULL, NULL, NULL, NULL, '1990-10-04', '', NULL, NULL, NULL, '', '', '', -1, -1, 2001, 2007, '', -1, -1, 'd', 'sefs', 'sdfs', 'sdfs', 'sdf', 'sdf', 'sdfsdf', '', 'dfsdf', 'sdfwdf', '', '342342', '', 'Cash'),
(33, 'sdkl', 'sdkl', '33', 'sdklf', 'sdkl', 'sdklf', NULL, NULL, NULL, NULL, NULL, NULL, '1990-10-23', 'sdjkl', NULL, NULL, NULL, '13', 'sdfkl', 'sf', 23, 23, 134, 23, 'sdf', 23, 234, 'sdf', 'ljds', 'klsd', 'kldskl', 'sdkl', 'sdkl', 'sdkl', 'sdlk', 'skld', 'dskl', '34242', 'sdkl', 'dskl', 'Cash'),
(34, 'sdfsd', 'sdfs', '34', 'sdfs', 'sdfsdf', 'sdfs', NULL, NULL, NULL, NULL, NULL, NULL, '1992-12-21', 'sdfs', NULL, NULL, NULL, '2342', 'sdfsd', 'sds', 23, 23, 23, 23, 'sdfs', 23, 42, 'sdfs', 'sdfs', 'sdf', 'sdf', 'sdf', 'sdf', 'sdfs', 'sdfsd', 'sdfs@sd.df', 'Sharjah', '13423', '4234', 'sdfs', 'Bank Transfer'),
(35, 'sdfklj', 'dslk', '35', 'dskl', 'sdflkj', 'dskl', NULL, NULL, NULL, NULL, NULL, NULL, '1970-01-01', 'sdflk', NULL, NULL, NULL, '', '', 'sd', 23, 23, 23, 23, 'sdsdf', 23, 234, '', '', '', '', '', '', 'dskl', 'sdklj', 'skl@sdkl.co', 'Sharjah', '2423', '234', 'sdklj', 'Cash'),
(36, 'skldfj', 'dskl', '36', 'dskl', 'sdklfj', 'sdkl', NULL, NULL, NULL, NULL, NULL, NULL, '1970-01-01', 'skldj', NULL, NULL, NULL, '', '', 'sdfkl', 23, 23, 234, 23, 'sdklfj', 234, 23, '', '', '', '', '', '', 'klsd', 'sdfkl', 'sdkl@ckl.dl', 'Abu Dhabi', '234', '234', 'sdkl', 'Cash'),
(37, 'sdflkj', 'sdkl', '37', 'sdkl', 'sldkf', 'sdkl', NULL, NULL, NULL, NULL, NULL, NULL, '2014-02-18', 'sdkl', NULL, NULL, NULL, '234', '', 'sdklf', 234, 234, 23, 234, 'skldf', 234, 53, 'sfl', 'sdklj', 'kld', 'sdkl', 'dlk', 'dkl', 'sdkl', 'sdklfj', 'sdkl@lkd.', 'Abu Dhabi', '234', '234', 'sdkl', 'Cash'),
(38, 'sdfsd', 'sdfs', '38', 'sdfsd', 'sdfsdf', 'sdfsdf', NULL, NULL, NULL, NULL, NULL, NULL, '2018-03-23', 'sdfsd', NULL, NULL, NULL, '2342', 'sdfsdf', 'sdfsdfsd', 234, 23, 234, 234, 'sdfsd', 23, 234, 'sdfsd', 'sdf@ljk.com', 'klsjd', 'lkjds', 'klkl@lk.com', 'klsd', 'sdfs', 'sdf', 'dfsd@jkl.com', 'Dubai', '23', '32', 'sdfsd', 'Cash'),
(39, 'sldfkj', 'dsklj', '39', 'sdkl', 'klsdj', 'sdklj', NULL, NULL, NULL, NULL, NULL, NULL, '2018-04-12', 'kldfj', NULL, NULL, NULL, '234', 'sdfs', 'sklf', 234, 234, 234, 234, 'sdfkl', 324, 234, 'dfklj', 'sdkl@kl.com', 'klsdj', 'klsd', 'klsd@kflds.com', 'klsdj', 'sdklj', 'klsdjkl', 'skldj@kl.com', 'Abu Dhabi', '2342', '234', 'dsklfjkl', 'Cash');

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

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
  `id` int(11) NOT NULL,
  `title` text NOT NULL,
  `content` text NOT NULL,
  `thumb_image` text NOT NULL,
  `images` text NOT NULL,
  `date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `news`
--

INSERT INTO `news` (`id`, `title`, `content`, `thumb_image`, `images`, `date`) VALUES
(12, 'News1', '                        News1 description                      ', '1523471128_news- img5.png', '1', '2018-04-04'),
(13, 'Maroons Night UAE 2018', 'Maroons Night UAE 2018', '57f96f3868923.thumb.png', '1', '2018-04-07'),
(14, 'Big Match is Coming Up', '140th Battle of the Maroons. 140th Battle of the Maroons. 140th Battle of the Maroons. 140th Battle of the Maroons. 140th Battle of the Maroons.140th Battle of the Maroons.140th Battle of the Maroons.140th Battle of the Maroons. 140th Battle of the Maroons.                                                                                                                                                          ', '1523466429_Events image.png', '1', '2018-04-08'),
(21, 'News new', 'sdklfjskdlj sdfs sdklfjskdlj sdfs sdklfjskdlj sdfs sdklfjskdlj sdfs sdklfjskdlj sdfs sdklfjskdlj sdfs sdklfjskdlj sdfs sdklfjskdlj sdfs sdklfjskdlj sdfs sdklfjskdlj sdfs sdklfjskdlj sdfs sdklfjskdlj sdfs sdfs sdklfjskdlj sdfs sdklfjskdlj sdfs sdklfjskdlj sdfs sdfs sdklfjskdlj sdfs sdklfjskdlj sdfs sdklfjskdlj sdfs', '1523577504_122.png', '1', '2018-04-12'),
(22, 'news 17th', 'sdklfs', '1523630126_news- img1.png', '1', '2018-04-19');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `events`
--
ALTER TABLE `events`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `gallery`
--
ALTER TABLE `gallery`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `images`
--
ALTER TABLE `images`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `members`
--
ALTER TABLE `members`
  ADD PRIMARY KEY (`table_id`),
  ADD UNIQUE KEY `mem_id` (`mem_id`);

--
-- Indexes for table `news`
--
ALTER TABLE `news`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `events`
--
ALTER TABLE `events`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;
--
-- AUTO_INCREMENT for table `gallery`
--
ALTER TABLE `gallery`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=123;
--
-- AUTO_INCREMENT for table `images`
--
ALTER TABLE `images`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=91;
--
-- AUTO_INCREMENT for table `members`
--
ALTER TABLE `members`
  MODIFY `table_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40;
--
-- AUTO_INCREMENT for table `news`
--
ALTER TABLE `news`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;
