cDwRfAka

1-- phpMyAdmin SQL Dump
2-- version 4.3.11
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Aug 22, 2016 at 01:53 PM
7-- Server version: 5.6.24
8-- PHP Version: 5.6.8
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `vrayi`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `cms_latest_updates_log`
27--
28
29CREATE TABLE IF NOT EXISTS `cms_latest_updates_log` (
30  `log_id` int(10) NOT NULL,
31  `lu_id` int(10) NOT NULL,
32  `log_status` enum('A','I') NOT NULL DEFAULT 'A',
33  `log_date` date NOT NULL,
34  `log_comments` text NOT NULL,
35  `log_file` varchar(225) DEFAULT NULL,
36  `lulog_delete` enum('Y','N') NOT NULL DEFAULT 'N' COMMENT 'Y:YES | N:No',
37  `lulog_created_by` int(10) NOT NULL,
38  `lulog_created_on` datetime NOT NULL,
39  `lulog_updated_on` datetime NOT NULL,
40  `lulog_updated_by` int(10) NOT NULL
41) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
42
43--
44-- Dumping data for table `cms_latest_updates_log`
45--
46
47INSERT INTO `cms_latest_updates_log` (`log_id`, `lu_id`, `log_status`, `log_date`, `log_comments`, `log_file`, `lulog_delete`, `lulog_created_by`, `lulog_created_on`, `lulog_updated_on`, `lulog_updated_by`) VALUES
48(1, 2, 'A', '2016-08-11', 'First Comment', '', 'Y', 1, '2016-08-11 11:32:42', '2016-08-11 17:33:38', 1),
49(2, 2, 'A', '2016-08-11', 'Second comment', NULL, 'Y', 1, '2016-08-11 16:43:57', '2016-08-11 17:35:28', 1),
50(3, 2, 'A', '2016-08-11', 'Daily GK Updates 1st August 2016, Current Affairs 2016 Today GK Quiz:  Job finders can get the collection of August 2016 current affairs capsule. Let’s check Daily GK Updates 1st August 2016, today GK quiz daily updates now available. Applicants must read and prepare your notes for your exam preparation. Candidates can get also Collection of GK quiz from sports, trade/economics, award and others fields.', NULL, 'N', 1, '2016-08-11 16:56:15', '2016-08-11 16:56:15', 1),
51(4, 2, 'A', '2016-08-11', 'Markets regulator Securities and Exchange Board of India (SEBI) has initiated the first phase of its new enterprise portal to facilitate accurate and timely circulation of information to internal and external stakeholders.', NULL, 'N', 1, '2016-08-11 17:04:34', '2016-08-11 17:04:34', 1),
52(5, 2, 'A', '0000-00-00', '', NULL, 'N', 1, '2016-08-22 15:29:13', '2016-08-22 15:29:13', 1),
53(6, 1, 'A', '0000-00-00', 'ohm namah sivaya', NULL, 'N', 1, '2016-08-22 16:10:13', '2016-08-22 16:10:13', 1),
54(7, 1, 'A', '0000-00-00', 'ohm namah sivaya', NULL, 'N', 1, '2016-08-22 16:10:13', '2016-08-22 16:10:13', 1);
55
56--
57-- Indexes for dumped tables
58--
59
60--
61-- Indexes for table `cms_latest_updates_log`
62--
63ALTER TABLE `cms_latest_updates_log`
64  ADD PRIMARY KEY (`log_id`);
65
66--
67-- AUTO_INCREMENT for dumped tables
68--
69
70--
71-- AUTO_INCREMENT for table `cms_latest_updates_log`
72--
73ALTER TABLE `cms_latest_updates_log`
74  MODIFY `log_id` int(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
75/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
76/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
77/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;