-
Notifications
You must be signed in to change notification settings - Fork 0
/
zend (1).sql
161 lines (135 loc) · 39.2 KB
/
zend (1).sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
-- phpMyAdmin SQL Dump
-- version 3.5.2.2
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Apr 09, 2013 at 06:31 PM
-- Server version: 5.5.27
-- PHP Version: 5.4.7
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `zend`
--
-- --------------------------------------------------------
--
-- Table structure for table `category`
--
CREATE TABLE IF NOT EXISTS `category` (
`CategoryId` int(11) NOT NULL AUTO_INCREMENT,
`CategoryName` varchar(50) NOT NULL,
`ParentId` int(11) NOT NULL,
`IsActive` tinyint(1) NOT NULL,
PRIMARY KEY (`CategoryId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;
--
-- Dumping data for table `category`
--
INSERT INTO `category` (`CategoryId`, `CategoryName`, `ParentId`, `IsActive`) VALUES
(1, 'CMS', 0, 1),
(2, 'Drupal', 1, 1),
(3, 'Wordpress', 1, 1),
(4, 'Joomla', 1, 1),
(5, 'Other', 1, 1),
(6, 'Programming News', 0, 1),
(7, 'PHP', 6, 1),
(8, 'Java', 6, 1),
(9, 'Jquery', 6, 1),
(10, 'Other', 6, 1),
(11, 'Technology', 0, 1),
(12, 'Desktop', 11, 1),
(13, 'Mobile', 11, 1),
(14, 'Android', 13, 1),
(15, 'iOS', 13, 1),
(16, 'Blackberry', 13, 1),
(17, 'Web', 11, 1);
-- --------------------------------------------------------
--
-- Table structure for table `link`
--
CREATE TABLE IF NOT EXISTS `link` (
`Id` int(11) NOT NULL,
`TaxonomyId` int(11) NOT NULL,
`PostId` int(11) NOT NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `posts`
--
CREATE TABLE IF NOT EXISTS `posts` (
`Post_Id` int(11) NOT NULL AUTO_INCREMENT,
`Author_Id` int(11) NOT NULL,
`Category_Id` varchar(25) NOT NULL,
`Post_Title` text CHARACTER SET utf8 NOT NULL,
`Post_Author` varchar(20) NOT NULL,
`Post_content` longtext NOT NULL,
`Post_Status` tinyint(1) NOT NULL,
`Post_Date` date NOT NULL,
PRIMARY KEY (`Post_Id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;
--
-- Dumping data for table `posts`
--
INSERT INTO `posts` (`Post_Id`, `Author_Id`, `Category_Id`, `Post_Title`, `Post_Author`, `Post_content`, `Post_Status`, `Post_Date`) VALUES
(1, 10, '0', 'Post Number 2.... more fun', 'tariq', '<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using 'Content here, content here', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for 'lorem ipsum' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like). test .v</p>\r\n', 1, '2013-02-21'),
(2, 3, '0', 'Post Number 2.... more fun', 'tariq', '<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using 'Content here, content here', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for 'lorem ipsum' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like). test .vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv</p>\r\n', 1, '2013-02-10'),
(3, 2, '0', 'Post Number 2.... more fun', 'tariq', '<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using 'Content here, content here', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for 'lorem ipsum' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like). test .</p>\r\n', 1, '2013-02-28'),
(4, 2, '0', 'latest update on zend', 'tariq', '<p>hed fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using 'Content here, content here', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for 'lorem ipsum' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like). </p>\r\n', 1, '2013-03-06'),
(5, 2, '0', 'Post Number 2.... more fun', 'tariq', '< text, and a search for 'lorem ipsum' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like). test .vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv</p>\r\n', 1, '2013-02-01'),
(6, 2, '0', 'Post Number 2.... more fun', 'tariq', '<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using 'Content here, content here', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for 'lorem ipsum' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like). test .vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv</p>\r\n', 1, '2013-02-10'),
(7, 2, '0', 'Post Number 2.... more fun', 'tariq', '<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using 'Content here, content here', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for 'lorem ipsum' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like). test .vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv</p>\r\n', 1, '2013-02-10'),
(8, 2, '0', 'Post Number 2.... more fun', 'tariq', '<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using 'Content here, content here', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for 'lorem ipsum' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like). test .vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv</p>\r\n', 1, '2013-02-10'),
(9, 2, '0', 'Post Number 2.... more fun', 'tariq', '<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using 'Content here, content here', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for 'lorem ipsum' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like). test .vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv</p>\r\n', 1, '2013-02-10'),
(10, 2, '0', 'Post Number 2.... more fun', 'tariq', '<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using 'Content here, content here', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for 'lorem ipsum' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like). test .vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv</p>\r\n', 1, '2013-02-10'),
(11, 2, '0', 'Post Number 2.... more fun', 'tariq', '<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using 'Content here, content here', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for 'lorem ipsum' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like). test .vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv</p>\r\n', 1, '2013-02-10'),
(12, 2, '0', 'Post Number 2.... more fun', 'tariq', '<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using 'Content here, content here', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for 'lorem ipsum' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like). test .vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv</p>\r\n', 0, '2013-02-10'),
(13, 10, '0', 'great experience', 'asdf', '<p class="para" style="box-sizing: border-box; margin: 0px 0px 17px; padding: 0px; font-size: 14px; direction: ltr; font-family: MuseoSans500Regular; line-height: 1.6; color: rgb(79, 78, 78);"><span class="classname" style="box-sizing: border-box; background-color: rgb(236, 240, 243); font-family: monospace;">Zend_Db</span> and its related classes provide a simple <acronym class="acronym" style="box-sizing: border-box; text-transform: uppercase; font-size: 13px; color: rgb(34, 34, 34); border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(221, 221, 221); cursor: help;">SQL</acronym> database interface for Zend Framework. The <span class="classname" style="box-sizing: border-box; background-color: rgb(236, 240, 243); font-family: monospace;">Zend_Db_Adapter</span> is the basic class you use to connect your <acronym class="acronym" style="box-sizing: border-box; text-transform: uppercase; font-size: 13px; color: rgb(34, 34, 34); border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(221, 221, 221); cursor: help;">PHP</acronym> application to an <acronym class="acronym" style="box-sizing: border-box; text-transform: uppercase; font-size: 13px; color: rgb(34, 34, 34); border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(221, 221, 221); cursor: help;">RDBMS</acronym>. There is a different Adapter class for each brand of <acronym class="acronym" style="box-sizing: border-box; text-transform: uppercase; font-size: 13px; color: rgb(34, 34, 34); border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(221, 221, 221); cursor: help;">RDBMS</acronym>.</p>\r\n\r\n<p class="para" style="box-sizing: border-box; margin: 0px 0px 17px; padding: 0px; font-size: 14px; direction: ltr; font-family: MuseoSans500Regular; line-height: 1.6; color: rgb(79, 78, 78);">The <span class="classname" style="box-sizing: border-box; background-color: rgb(236, 240, 243); font-family: monospace;">Zend_Db</span> adapters create a bridge from the vendor-specific <acronym class="acronym" style="box-sizing: border-box; text-transform: uppercase; font-size: 13px; color: rgb(34, 34, 34); border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(221, 221, 221); cursor: help;">PHP</acronym> extensions to a common interface to help you write <acronym class="acronym" style="box-sizing: border-box; text-transform: uppercase; font-size: 13px; color: rgb(34, 34, 34); border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(221, 221, 221); cursor: help;">PHP</acronym> applications once and deploy with multiple brands of <acronym class="acronym" style="box-sizing: border-box; text-transform: uppercase; font-size: 13px; color: rgb(34, 34, 34); border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(221, 221, 221); cursor: help;">RDBMS</acronym> with very little effort.</p>\r\n\r\n<p class="para" style="box-sizing: border-box; margin: 0px 0px 17px; padding: 0px; font-size: 14px; direction: ltr; font-family: MuseoSans500Regular; line-height: 1.6; color: rgb(79, 78, 78);">The interface of the adapter class is similar to the interface of the <a class="link external" href="http://www.php.net/pdo" style="box-sizing: border-box; color: rgb(0, 145, 213); text-decoration: initial; line-height: inherit; -webkit-transition: all 0.25s linear;">» PHP Data Objects</a> extension. <span class="classname" style="box-sizing: border-box; background-color: rgb(236, 240, 243); font-family: monospace;">Zend_Db</span> provides Adapter classes to <acronym class="acronym" style="box-sizing: border-box; text-transform: uppercase; font-size: 13px; color: rgb(34, 34, 34); border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(221, 221, 221); cursor: help;">PDO</acronym>drivers for the following <acronym class="acronym" style="box-sizing: border-box; text-transform: uppercase; font-size: 13px; color: rgb(34, 34, 34); border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(221, 221, 221); cursor: help;">RDBMS</acronym> brands:</p>\r\n\r\n<ul class="itemizedlist" style="box-sizing: border-box; margin: 0px 0px 17px 20px; padding-right: 0px; padding-left: 0px; font-size: 14px; direction: ltr; line-height: 1.6; list-style-position: outside; color: rgb(79, 78, 78); font-family: MuseoSans500Regular;">\r\n <li class="listitem" style="box-sizing: border-box; margin: 0px; padding: 0px; direction: ltr;">\r\n <p class="para" style="box-sizing: border-box; margin: 0px 0px 17px; padding: 0px; direction: ltr; font-family: inherit; line-height: 1.6;"><acronym class="acronym" style="box-sizing: border-box; text-transform: uppercase; font-size: 13px; color: rgb(34, 34, 34); border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(221, 221, 221); cursor: help;">IBM</acronym> <acronym class="acronym" style="box-sizing: border-box; text-transform: uppercase; font-size: 13px; color: rgb(34, 34, 34); border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(221, 221, 221); cursor: help;">DB2</acronym> and Informix Dynamic Server (<acronym class="acronym" style="box-sizing: border-box; text-transform: uppercase; font-size: 13px; color: rgb(34, 34, 34); border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(221, 221, 221); cursor: help;">IDS</acronym>), using the <a class="link external" href="http://www.php.net/pdo-ibm" style="box-sizing: border-box; color: rgb(0, 145, 213); text-decoration: initial; line-height: inherit; -webkit-transition: all 0.25s linear;">» pdo_ibm</a> <acronym class="acronym" style="box-sizing: border-box; text-transform: uppercase; font-size: 13px; color: rgb(34, 34, 34); border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(221, 221, 221); cursor: help;">PHP</acronym> extension</p>\r\n </li>\r\n <li class="listitem" style="box-sizing: border-box; margin: 0px; padding: 0px; direction: ltr;">\r\n <p class="para" style="box-sizing: border-box; margin: 0px 0px 17px; padding: 0px; direction: ltr; font-family: inherit; line-height: 1.6;">MariaDB, using the <a class="link external" href="http://www.php.net/pdo-mysql" style="box-sizing: border-box; color: rgb(0, 145, 213); text-decoration: initial; line-height: inherit; -webkit-transition: all 0.25s linear;">» pdo_mysql</a> <acronym class="acronym" style="box-sizing: border-box; text-transform: uppercase; font-size: 13px; color: rgb(34, 34, 34); border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(221, 221, 221); cursor: help;">PHP</acronym> extension</p>\r\n </li>\r\n <li class="listitem" style="box-sizing: border-box; margin: 0px; padding: 0px; direction: ltr;">\r\n <p class="para" style="box-sizing: border-box; margin: 0px 0px 17px; padding: 0px; direction: ltr; font-family: inherit; line-height: 1.6;">MySQL, using the <a class="link external" href="http://www.php.net/pdo-mysql" style="box-sizing: border-box; color: rgb(0, 145, 213); text-decoration: initial; line-height: inherit; -webkit-transition: all 0.25s linear;">» pdo_mysql</a> <acronym class="acronym" style="box-sizing: border-box; text-transform: uppercase; font-size: 13px; color: rgb(34, 34, 34); border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(221, 221, 221); cursor: help;">PHP</acronym> extension</p>\r\n </li>\r\n <li class="listitem" style="box-sizing: border-box; margin: 0px; padding: 0px; direction: ltr;">\r\n <p class="para" style="box-sizing: border-box; margin: 0px 0px 17px; padding: 0px; direction: ltr; font-family: inherit; line-height: 1.6;">Microsoft <acronym class="acronym" style="box-sizing: border-box; text-transform: uppercase; font-size: 13px; color: rgb(34, 34, 34); border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(221, 221, 221); cursor: help;">SQL</acronym> Server, using the <a class="link external" href="http://www.php.net/pdo-dblib" style="box-sizing: border-box; color: rgb(0, 145, 213); text-decoration: initial; line-height: inherit; -webkit-transition: all 0.25s linear;">» pdo_dblib</a> <acronym class="acronym" style="box-sizing: border-box; text-transform: uppercase; font-size: 13px; color: rgb(34, 34, 34); border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(221, 221, 221); cursor: help;">PHP</acronym> extension</p>\r\n </li>\r\n <li class="listitem" style="box-sizing: border-box; margin: 0px; padding: 0px; direction: ltr;">\r\n <p class="para" style="box-sizing: border-box; margin: 0px 0px 17px; padding: 0px; direction: ltr; font-family: inherit; line-height: 1.6;">Oracle, using the <a class="link external" href="http://www.php.net/pdo-oci" style="box-sizing: border-box; color: rgb(0, 145, 213); text-decoration: initial; line-height: inherit; -webkit-transition: all 0.25s linear;">» pdo_oci</a> <acronym class="acronym" style="box-sizing: border-box; text-transform: uppercase; font-size: 13px; color: rgb(34, 34, 34); border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(221, 221, 221); cursor: help;">PHP</acronym> extension</p>\r\n </li>\r\n <li class="listitem" style="box-sizing: border-box; margin: 0px; padding: 0px; direction: ltr;">\r\n <p class="para" style="box-sizing: border-box; margin: 0px 0px 17px; padding: 0px; direction: ltr; font-family: inherit; line-height: 1.6;">PostgreSQL, using the <a class="link external" href="http://www.php.net/pdo-pgsql" style="box-sizing: border-box; color: rgb(0, 145, 213); text-decoration: initial; line-height: inherit; -webkit-transition: all 0.25s linear;">» pdo_pgsql</a> <acronym class="acronym" style="box-sizing: border-box; text-transform: uppercase; font-size: 13px; color: rgb(34, 34, 34); border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(221, 221, 221); cursor: help;">PHP</acronym> extension</p>\r\n </li>\r\n <li class="listitem" style="box-sizing: border-box; margin: 0px; padding: 0px; direction: ltr;">\r\n <p class="para" style="box-sizing: border-box; margin: 0px 0px 17px; padding: 0px; direction: ltr; font-family: inherit; line-height: 1.6;">SQLite, using the <a class="link external" href="http://www.php.net/pdo-sqlite" style="box-sizing: border-box; color: rgb(0, 145, 213); text-decoration: initial; line-height: inherit; -webkit-transition: all 0.25s linear;">» pdo_sqlite</a> <acronym class="acronym" style="box-sizing: border-box; text-transform: uppercase; font-size: 13px; color: rgb(34, 34, 34); border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(221, 221, 221); cursor: help;">PHP</acronym> extension</p>\r\n </li>\r\n <li class="listitem" style="box-sizing: border-box; margin: 0px; padding: 0px; direction: ltr;">\r\n <p class="para" style="box-sizing: border-box; margin: 0px 0px 17px; padding: 0px; direction: ltr; font-family: inherit; line-height: 1.6;">test update</p>\r\n </li>\r\n</ul>\r\n', 1, '2013-02-14'),
(14, 10, '0', 'LGA Issue', 'asdf', '<p style="margin: 0px 0px 20px; padding: 0px; border: 0px; outline: 0px; vertical-align: baseline; line-height: 20px; color: rgb(34, 34, 34); font-family: Arial, Helvetica, sans-serif;">The following steps were taken:</p>\r\n\r\n<ol style="margin: 0px 0px 20px; padding-right: 0px; padding-left: 0px; border: 0px; outline: 0px; vertical-align: baseline; line-height: 20px; list-style: none; color: rgb(34, 34, 34); font-family: Arial, Helvetica, sans-serif;">\r\n <li style="margin: 0px 0px 0px 30px; padding: 0px; border: 0px; outline: 0px; vertical-align: baseline; background-color: transparent; line-height: inherit; list-style: decimal;">Add chart.</li>\r\n <li style="margin: 0px 0px 0px 30px; padding: 0px; border: 0px; outline: 0px; vertical-align: baseline; background-color: transparent; line-height: inherit; list-style: decimal;">Add the metric "Population - Three broad age groups (economic) - percentage of population aged 16 to 64 males and 16 to 59 for females".</li>\r\n <li style="margin: 0px 0px 0px 30px; padding: 0px; border: 0px; outline: 0px; vertical-align: baseline; background-color: transparent; line-height: inherit; list-style: decimal;">Open the metric options and choose "Gender" for "Breakdown by".</li>\r\n <li style="margin: 0px 0px 0px 30px; padding: 0px; border: 0px; outline: 0px; vertical-align: baseline; background-color: transparent; line-height: inherit; list-style: decimal;">Click next to go to "Select area".</li>\r\n <li style="margin: 0px 0px 0px 30px; padding: 0px; border: 0px; outline: 0px; vertical-align: baseline; background-color: transparent; line-height: inherit; list-style: decimal;">Add "All local authorities in South East" and "All local authorities in East Midlands".</li>\r\n <li style="margin: 0px 0px 0px 30px; padding: 0px; border: 0px; outline: 0px; vertical-align: baseline; background-color: transparent; line-height: inherit; list-style: decimal;">Click next and choose "100% stacked bar/column".</li>\r\n <li style="margin: 0px 0px 0px 30px; padding: 0px; border: 0px; outline: 0px; vertical-align: baseline; background-color: transparent; line-height: inherit; list-style: decimal;">Click "Further customise summary values".</li>\r\n <li style="margin: 0px 0px 0px 30px; padding: 0px; border: 0px; outline: 0px; vertical-align: baseline; background-color: transparent; line-height: inherit; list-style: decimal;">Add the "Median" summary type.</li>\r\n <li style="margin: 0px 0px 0px 30px; padding: 0px; border: 0px; outline: 0px; vertical-align: baseline; background-color: transparent; line-height: inherit; list-style: decimal;">Choose "Areas" for "Applied to" and the "Comparison group" as "All London Boroughs".</li>\r\n</ol>\r\n\r\n<p style="margin: 0px 0px 20px; padding: 0px; border: 0px; outline: 0px; vertical-align: baseline; line-height: 20px; color: rgb(34, 34, 34); font-family: Arial, Helvetica, sans-serif;">The added summary line is too big for the graph and results in the graph being too small to view, this line has been highlighted in "report_builder_-_summary_type_result_lies_outside_useful_graph_area.png".</p>\r\n', 1, '2013-02-14'),
(15, 10, '0', 'MVC with Zend', 'asdf', '<p style="box-sizing: border-box; margin: 0px 0px 17px; padding: 0px; font-size: 14px; direction: ltr; font-family: MuseoSans500Regular; line-height: 1.6; color: rgb(79, 78, 78);">he MVC layer is built on top of the following components:</p>\r\n\r\n<ul class="simple" style="box-sizing: border-box; margin: 0px 0px 17px; padding-right: 0px; padding-left: 20px; font-size: 14px; direction: ltr; line-height: 1.6; list-style-position: outside; color: rgb(79, 78, 78); font-family: MuseoSans500Regular;">\r\n <li style="box-sizing: border-box; margin: 0px; padding: 0px; direction: ltr;"><tt class="docutils literal" style="box-sizing: border-box; background-color: rgb(236, 240, 243);"><span class="pre" style="box-sizing: border-box;">Zend\\ServiceManager</span></tt> - Zend Framework provides a set of default service definitions set up at <tt class="docutils literal" style="box-sizing: border-box; background-color: rgb(236, 240, 243);"><span class="pre" style="box-sizing: border-box;">Zend\\Mvc\\Service</span></tt>. The<tt class="docutils literal" style="box-sizing: border-box; background-color: rgb(236, 240, 243);"><span class="pre" style="box-sizing: border-box;">ServiceManager</span></tt> creates and configures your application instance and workflow.</li>\r\n <li style="box-sizing: border-box; margin: 0px; padding: 0px; direction: ltr;"><tt class="docutils literal" style="box-sizing: border-box; background-color: rgb(236, 240, 243);"><span class="pre" style="box-sizing: border-box;">Zend\\EventManager</span></tt> - The MVC is event driven. This component is used everywhere from initial bootstrapping of the application, through returning response and request calls, to setting and retrieving routes and matched routes, as well as render views.</li>\r\n <li style="box-sizing: border-box; margin: 0px; padding: 0px; direction: ltr;"><tt class="docutils literal" style="box-sizing: border-box; background-color: rgb(236, 240, 243);"><span class="pre" style="box-sizing: border-box;">Zend\\Http</span></tt> - specifically the request and response objects, used within:</li>\r\n <li style="box-sizing: border-box; margin: 0px; padding: 0px; direction: ltr;"><tt class="docutils literal" style="box-sizing: border-box; background-color: rgb(236, 240, 243);"><span class="pre" style="box-sizing: border-box;">Zend\\Stdlib\\DispatchableInterface</span></tt>. All “controllers” are simply dispatchable objects.</li>\r\n</ul>\r\n\r\n<p style="box-sizing: border-box; margin: 0px 0px 17px; padding: 0px; font-size: 14px; direction: ltr; font-family: MuseoSans500Regular; line-height: 1.6; color: rgb(79, 78, 78);">Within the MVC layer, several sub-components are exposed:</p>\r\n\r\n<ul class="simple" style="box-sizing: border-box; margin: 0px 0px 17px; padding-right: 0px; padding-left: 20px; font-size: 14px; direction: ltr; line-height: 1.6; list-style-position: outside; color: rgb(79, 78, 78); font-family: MuseoSans500Regular;">\r\n <li style="box-sizing: border-box; margin: 0px; padding: 0px; direction: ltr;"><tt class="docutils literal" style="box-sizing: border-box; background-color: rgb(236, 240, 243);"><span class="pre" style="box-sizing: border-box;">Zend\\Mvc\\Router</span></tt> contains classes pertaining to routing a request. In other words, it matches the request to its respective controller (or dispatchable).</li>\r\n <li style="box-sizing: border-box; margin: 0px; padding: 0px; direction: ltr;"><tt class="docutils literal" style="box-sizing: border-box; background-color: rgb(236, 240, 243);"><span class="pre" style="box-sizing: border-box;">Zend\\Http\\PhpEnvironment</span></tt> provides a set of decorators for the HTTP <tt class="docutils literal" style="box-sizing: border-box; background-color: rgb(236, 240, 243);"><span class="pre" style="box-sizing: border-box;">Request</span></tt> and <tt class="docutils literal" style="box-sizing: border-box; background-color: rgb(236, 240, 243);"><span class="pre" style="box-sizing: border-box;">Response</span></tt> objects that ensure the request is injected with the current environment (including query parameters, POST parameters, HTTP headers, etc.)</li>\r\n</ul>\r\n', 0, '2013-02-14'),
(16, 2, '0', 'great experience', 'tariq', '<p>$result = $postsTBL->select()->where("Author_Id= $this->_id"); //its not post request, so fetch posts without any sorting.</p>\r\n\r\n<p>$result = $postsTBL->select()->where("Author_Id= $this->_id"); //its not post request, so fetch posts without any sorting.$result = $postsTBL->select()->where("Author_Id= $this->_id"); //its not post request, so fetch posts without any sorting.$result = $postsTBL->select()->where("Author_Id= $this->_id"); //its not post request, so fetch posts without any sorting.$result = $postsTBL->select()->where("Author_Id= $this->_id"); //its not post request, so fetch posts without any sorting.</p>\r\n', 1, '2013-03-22'),
(17, 2, '0', 'MVC with Zend', 'tariq', '<div class="post-text" style="margin: 0px 5px 5px 0px; padding: 0px; border: 0px; font-size: 14px; vertical-align: baseline; width: 660px; line-height: 18px; color: rgb(0, 0, 0); font-family: Arial, ''Liberation Sans'', ''DejaVu Sans'', sans-serif;">\r\n<p style="margin: 0px 0px 1em; padding: 0px; border: 0px; vertical-align: baseline; background-color: transparent; clear: both; word-wrap: break-word;">To populate all form values, you can call $form->populate($dataAsArray);</p>\r\n\r\n<p style="margin: 0px 0px 1em; padding: 0px; border: 0px; vertical-align: baseline; background-color: transparent; clear: both; word-wrap: break-word;">If you want to set a default value, you can call $select->setValue('valueHere'); If it were a checkbox, instead of pass one sigle value you would pass an array of selected indexes.</p>\r\n\r\n<p style="margin: 0px 0px 1em; padding: 0px; border: 0px; vertical-align: baseline; background-color: transparent; clear: both; word-wrap: break-word;">See this question: <a href="http://stackoverflow.com/questions/3488057/zend-form-element-multiselect-element-definition/3488129#3488129" style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; background-color: transparent; color: rgb(74, 107, 130); text-decoration: none; cursor: pointer;">http://stackoverflow.com/questions/3488057/zend-form-element-multiselect-element-definition/3488129#348812</a></p>\r\n</div>\r\n', 0, '2013-02-27'),
(18, 2, '11', 'test post 1', 'tariq', '<p>sadfasd </p>\r\n\r\n<p>asffasdfasd asdfasdf</p>\r\n', 1, '2013-02-07'),
(19, 2, '11,13,15', 'Introduction to Ajax for PHP', 'tariq', '<p style="margin: 0px; padding: 0px 0px 10px; font-family: Arial, Helvetica, Verdana; font-size: 12px; line-height: 19px;">This document provides an introduction to Ajax and demonstrates some of the features in the NetBeans IDE that allow you to program faster and more efficiently when working with Ajax-related technologies. While learning about the low-level functionality of Ajax, you build a simple application that employs auto-completion in a text field. Content here has been adapted from Greg Murray's article and sample application from <a href="http://weblogs.java.net/blog/gmurray71/archive/2005/12/using_ajax_with_1.html" style="color: rgb(35, 86, 157); text-decoration: none;" target="_blank">Using Ajax with Java Technology</a>.</p>\r\n\r\n<p style="margin: 0px; padding: 0px 0px 10px; font-family: Arial, Helvetica, Verdana; font-size: 12px; line-height: 19px;">Ajax stands for Asynchronous JavaScript and XML. In essence, Ajax is an efficient way for a web application to handle user interactions with a web page - a way that reduces the need to do a page refresh or full page reload for every user interaction. This enables rich behavior (similar to that of a desktop application or plugin-based web application) using a browser. Ajax interactions are handled asynchronously in the background. As this happens, a user can continue working with the page. Ajax interactions are initiated by JavaScript code. When the Ajax interaction is complete, JavaScript updates the HTML source of the page. The changes are made immediately without requiring a page refresh. Ajax interactions can be used to do things such as validate form entries (while the user is entering them) using server-side logic, retrieve detailed data from the server, dynamically update data on a page, and submit partial forms from the page.</p>\r\n\r\n<p style="margin: 0px; padding: 0px 0px 10px; font-family: Arial, Helvetica, Verdana; font-size: 12px; line-height: 19px;"><strong>Contents</strong></p>\r\n\r\n<p style="margin: 0px; padding: 0px 0px 10px; font-family: Arial, Helvetica, Verdana; font-size: 12px; line-height: 19px;"><img alt="Content on this page applies to NetBeans IDE 6.9 and later" class="stamp" src="http://netbeans.org/images_www/articles/71/netbeans-stamp-71-72-73.png" style="float: right; margin: 0px 0px 10px 10px;" title="Content on this page applies to NetBeans IDE 6.9 and later" /></p>\r\n\r\n<ul class="toc" style="margin: 0px 0px 15px; font-family: Arial, Helvetica, Verdana; font-size: 12px; line-height: 19px;">\r\n <li style="margin: 0px 0px 4px 15px; list-style: disc; padding-top: 0px; padding-bottom: 0px;"><a href="http://netbeans.org/kb/docs/php/ajax-quickstart.html#overview" style="color: rgb(35, 86, 157); text-decoration: none;">Overview of the Application</a></li>\r\n <li style="margin: 0px 0px 4px 15px; list-style: disc; padding-top: 0px; padding-bottom: 0px;"><a href="http://netbeans.org/kb/docs/php/ajax-quickstart.html#client1" style="color: rgb(35, 86, 157); text-decoration: none;">Programming the Client-Side: Part 1</a>\r\n <ul style="margin: 8px 0px 15px;">\r\n <li style="margin: 0px 0px 4px 15px; list-style: disc; padding-top: 0px; padding-bottom: 0px;"><a href="http://netbeans.org/kb/docs/php/ajax-quickstart.html#html" style="color: rgb(35, 86, 157); text-decoration: none;">Using the HTML Editor</a></li>\r\n <li style="margin: 0px 0px 4px 15px; list-style: disc; padding-top: 0px; padding-bottom: 0px;"><a href="http://netbeans.org/kb/docs/php/ajax-quickstart.html#javascript" style="color: rgb(35, 86, 157); text-decoration: none;">Using the JavaScript Editor</a></li>\r\n </ul>\r\n </li>\r\n <li style="margin: 0px 0px 4px 15px; list-style: disc; padding-top: 0px; padding-bottom: 0px;"><a href="http://netbeans.org/kb/docs/php/ajax-quickstart.html#serverside" style="color: rgb(35, 86, 157); text-decoration: none;">Programming the Server-Side</a>\r\n <ul style="margin: 8px 0px 15px;">\r\n <li style="margin: 0px 0px 4px 15px; list-style: disc; padding-top: 0px; padding-bottom: 0px;"><a href="http://netbeans.org/kb/docs/php/ajax-quickstart.html#data" style="color: rgb(35, 86, 157); text-decoration: none;">Creating the Data Store</a></li>\r\n <li style="margin: 0px 0px 4px 15px; list-style: disc; padding-top: 0px; padding-bottom: 0px;"><a href="http://netbeans.org/kb/docs/php/ajax-quickstart.html#business" style="color: rgb(35, 86, 157); text-decoration: none;">Creating the Business Logic</a></li>\r\n </ul>\r\n </li>\r\n <li style="margin: 0px 0px 4px 15px; list-style: disc; padding-top: 0px; padding-bottom: 0px;"><a href="http://netbeans.org/kb/docs/php/ajax-quickstart.html#client2" style="color: rgb(35, 86, 157); text-decoration: none;">Programming the Client-Side: Part 2</a>\r\n <ul style="margin: 8px 0px 15px;">\r\n <li style="margin: 0px 0px 4px 15px; list-style: disc; padding-top: 0px; padding-bottom: 0px;"><a href="http://netbeans.org/kb/docs/php/ajax-quickstart.html#callback" style="color: rgb(35, 86, 157); text-decoration: none;">Adding Callback Functionality</a></li>\r\n <li style="margin: 0px 0px 4px 15px; list-style: disc; padding-top: 0px; padding-bottom: 0px;"><a href="http://netbeans.org/kb/docs/php/ajax-quickstart.html#htmldom" style="color: rgb(35, 86, 157); text-decoration: none;">Updating the HTML DOM</a></li>\r\n <li style="margin: 0px 0px 4px 15px; list-style: disc; padding-top: 0px; padding-bottom: 0px;"><a href="http://netbeans.org/kb/docs/php/ajax-quickstart.html#stylesheet" style="color: rgb(35, 86, 157); text-decoration: none;">Attaching a Stylesheet</a></li>\r\n </ul>\r\n </li>\r\n <li style="margin: 0px 0px 4px 15px; list-style: disc; padding-top: 0px; padding-bottom: 0px;"><a href="http://netbeans.org/kb/docs/php/ajax-quickstart.html#conclusion" style="color: rgb(35, 86, 157); text-decoration: none;">Conclusion</a></li>\r\n <li style="margin: 0px 0px 4px 15px; list-style: disc; padding-top: 0px; padding-bottom: 0px;"><a href="http://netbeans.org/kb/docs/php/ajax-quickstart.html#seeAlso" style="color: rgb(35, 86, 157); text-decoration: none;">See Also</a></li>\r\n</ul>\r\n', 1, '2013-03-28');
-- --------------------------------------------------------
--
-- Table structure for table `taxonomy`
--
CREATE TABLE IF NOT EXISTS `taxonomy` (
`TaxonomyId` int(11) NOT NULL,
`Name` varchar(50) NOT NULL,
`slug` varchar(50) NOT NULL,
`ParentId` int(11) NOT NULL,
`IsActive` tinyint(1) NOT NULL,
PRIMARY KEY (`TaxonomyId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE IF NOT EXISTS `users` (
`Id` int(11) NOT NULL AUTO_INCREMENT,
`Name` varchar(25) NOT NULL,
`Email` varchar(30) NOT NULL,
`Password` varchar(45) NOT NULL,
`Role` varchar(15) NOT NULL DEFAULT 'registered',
`TokenId` varchar(35) NOT NULL,
`IsActive` tinyint(1) NOT NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=34 ;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`Id`, `Name`, `Email`, `Password`, `Role`, `TokenId`, `IsActive`) VALUES
(2, 'tariq', 'tariq.inaam@gmail.com', '827ccb0eea8a706c4c34a16891f84e7b', 'registered', 'CCG9UEF2D26T98HWG59', 1),
(10, 'asdf', 'tariq@yahoo.com', '1234', 'admin', '0', 0),
(23, 'tariq', 'tariq.inam@readingroom.com', 'tariq', 'registered', 'CCG9UEF2D26T98HWG59', 1),
(32, 'name', 'tarique.qadian@gmail.com', 'tariq', 'registered', 'CYQB41BF99RP1H7N™R8S', 0),
(33, 'name', 'example@example.com', '827ccb0eea8a706c4c34a16891f84e7b', 'registered', 'MESGXDAENVKFZZZTM32', 1);
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;