 -- Table structure for table `categories`
 --
 
-DROP TABLE IF EXISTS `categories`;
 CREATE TABLE IF NOT EXISTS `categories` (
-  `categoryId` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  `parentId` int(10) unsigned DEFAULT NULL,
+  `categoryId` int(11) unsigned NOT NULL AUTO_INCREMENT,
+  `parentId` int(11) unsigned DEFAULT NULL,
   `name` varchar(50) NOT NULL,
   `description` text,
   PRIMARY KEY (`categoryId`),
   KEY `PARENTID_IDX` (`parentId`) COMMENT 'Parent ID Indexes'
-) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;
+) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ;
 
 --
 -- Dumping data for table `categories`
 --
 
 INSERT INTO `categories` (`categoryId`, `parentId`, `name`, `description`) VALUES
-(5, NULL, 'Operating System', 'Category to hold articles relevant to a specific type of Operating System'),
+(5, NULL, 'Operating System ', 'Category to hold articles relevant to a specific type of Operating System such as Linux, Windows, Unix'),
 (6, 5, 'Linux', 'Linux HowTo, Notes, Documents'),
 (7, 5, 'Unix Solaris', 'Oracle Solaris documents and information'),
 (8, NULL, 'Server Setup and Configuration', 'Category for articles on setup various server such as WAMP, FTP, MySQL, Web Server, PHP Server'),
 (9, NULL, 'Web Development', 'Technologies and Tools use in Web Development'),
 (10, 9, 'PHP Programming Language ', 'PHP code snippet, howto'),
-(11, 5, 'Microsoft Windows', 'All related articles with Microsoft Windows'),
 (12, 10, 'Code Igniter Framework', 'Information and code snippet for Code Igniter Framework some thing long in the description to see it wrap around.'),
-(13, 14, 'HTML', 'All about HTML 5 information'),
 (14, 9, 'Web front end UI development tools', 'HTML/CSS/Java Scripts'),
 (15, 14, 'CSS and CSS Framework', 'Articles about CSS, Bootstrap, Material Design Lite, or any other CSS framework'),
-(16, 14, 'Javascripts', 'Java Script Framework, jQuery, AngularJS, JavaScript libraries');
+(16, 14, 'Javascripts', 'Java Script Framework, jQuery, AngularJS, JavaScript libraries'),
+(23, NULL, 'Programming', 'General programming languages'),
+(24, 23, 'C/C++', 'Programming code snippet or howto for C and C++');
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `tags`
+--
+
+CREATE TABLE IF NOT EXISTS `tags` (
+  `tagId` int(11) unsigned NOT NULL AUTO_INCREMENT,
+  `name` varchar(30) NOT NULL,
+  PRIMARY KEY (`tagId`)
+) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
+
+--
+-- Dumping data for table `tags`
+--
+
+INSERT INTO `tags` (`tagId`, `name`) VALUES
+(1, 'PHP'),
+(2, 'CSS'),
+(3, 'JavaScript'),
+(4, 'Operating System'),
+(5, 'HTML5'),
+(6, 'jQuery'),
+(7, 'Howto');
 
 --
 -- Constraints for dumped tables

--
-- Database: `demo`
--
CREATE DATABASE IF NOT EXISTS `demo` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `demo`;


-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Apr 10, 2016 at 09:21 PM
-- Server version: 5.6.17
-- PHP Version: 5.5.12

