Data base

[Mohammed Jebrini]

hi guys , 

please try this sql for the data base : 

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

-- phpMyAdmin SQL Dump

-- version 3.2.5

-- http://www.phpmyadmin.net

--

-- Host: localhost

-- Generation Time: Oct 09, 2010 at 10:19 PM

-- Server version: 5.1.44

-- PHP Version: 5.2.13

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--

-- Database: `blogDB`

--

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

--

-- Table structure for table `ci_sessions`

--

CREATE TABLE `ci_sessions` (

  `session_id` varchar(40) NOT NULL DEFAULT '0',

  `ip_address` varchar(16) NOT NULL DEFAULT '0',

  `user_agent` varchar(50) NOT NULL,

  `last_activity` int(10) unsigned NOT NULL DEFAULT '0',

  `user_data` text NOT NULL,

  PRIMARY KEY (`session_id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--

-- Dumping data for table `ci_sessions`

--

INSERT INTO `ci_sessions` VALUES('da8bf78fb2ade5deefd361990513e9b7', '0.0.0.0', 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en', 1286377385, 'a:2:{s:7:"user_id";s:1:"2";s:8:"username";s:5:"admin";}');

INSERT INTO `ci_sessions` VALUES('c7d1ffc09441f60224cd1686ff5a0667', '0.0.0.0', 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en', 1286377532, 'a:2:{s:7:"user_id";s:1:"2";s:8:"username";s:5:"admin";}');

INSERT INTO `ci_sessions` VALUES('97c454c47451f98cddb041fff1f5a0a1', '0.0.0.0', 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en', 1286377653, 'a:2:{s:7:"user_id";s:1:"2";s:8:"username";s:5:"admin";}');

INSERT INTO `ci_sessions` VALUES('f8ef6c8e7debbb8afea41bff45a5b195', '0.0.0.0', 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en', 1286379690, '');

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

--

-- Table structure for table `comments`

--

CREATE TABLE `comments` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `name` varchar(300) DEFAULT NULL,

  `email` varchar(70) NOT NULL,

  `body` text NOT NULL,

  `post_id` int(11) NOT NULL,

  `published` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

  PRIMARY KEY (`id`),

  KEY `post_id` (`post_id`)

) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

--

-- Dumping data for table `comments`

--

INSERT INTO `comments` VALUES(1, 'asdasdasd', 'em...@mail.com', 'asdsadsad', 2, '2010-10-05 00:00:00');

INSERT INTO `comments` VALUES(2, 'asdasdasd', 'em...@mail.com', 'asdsadsad', 2, '2010-10-04 00:00:00');

INSERT INTO `comments` VALUES(3, 'Comment ', 'com...@mail.com', 'comment ', 3, '2010-10-04 16:44:41');

INSERT INTO `comments` VALUES(4, 'dasdasdsd', 'em...@mail.com', 'sdasasd', 3, '2010-10-04 16:46:22');

INSERT INTO `comments` VALUES(5, 'ffsdfs', 'sdf...@fsdfsd.com', 'sdfsdfdsfsdf', 4, '2010-10-04 17:10:29');

INSERT INTO `comments` VALUES(6, 'test', 'te...@test.com', 'test test ', 2, '2010-10-04 17:43:29');

INSERT INTO `comments` VALUES(7, 'dsfdsf', 'd...@sadd.vom', 'sdfsdfsdfsf', 4, '2010-10-05 23:59:09');

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

--

-- Table structure for table `posts`

--

CREATE TABLE `posts` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `title` varchar(300) NOT NULL,

  `body` text NOT NULL,

  `published` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

  `isActive` tinyint(1) NOT NULL,

  `user_id` int(11) NOT NULL,

  PRIMARY KEY (`id`),

  KEY `user_id` (`user_id`)

) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

--

-- Dumping data for table `posts`

--

INSERT INTO `posts` VALUES(2, 'This is my first blog post', 'lorem text is slandered dummy text lorem text is slandered dummy text lorem text is slandered dummy text lorem text is slandered dummy text lorem text is slandered dummy text lorem text is slandered dummy text lorem text is slandered dummy text lorem text is slandered dummy text lorem text is slandered dummy text lorem text is slandered dummy text ', '2010-10-03 17:10:23', 0, 2);

INSERT INTO `posts` VALUES(3, 'This is my fsecond blog post', 'lorem text is slandered dummy text lorem text is slandered dummy text lorem text is slandered dummy text lorem text is slandered dummy text lorem text is slandered dummy text lorem text is slandered dummy text lorem text is slandered dummy text lorem text is slandered dummy text lorem text is slandered dummy text lorem text is slandered dummy text ', '2010-10-03 17:10:48', 0, 2);

INSERT INTO `posts` VALUES(4, 'This is my third blog post', 'lorem text is slandered dummy text lorem text is slandered dummy text lorem text is slandered dummy text lorem text is slandered dummy text lorem text is slandered dummy text lorem text is slandered dummy text lorem text is slandered dummy text lorem text is slandered dummy text lorem text is slandered dummy text lorem text is slandered dummy text ', '2010-10-03 17:11:00', 0, 2);

INSERT INTO `posts` VALUES(5, 'This is my fourth blog post', 'lorem text is slandered dummy text lorem text is slandered dummy text lorem text is slandered dummy text lorem text is slandered dummy text lorem text is slandered dummy text lorem text is slandered dummy text lorem text is slandered dummy text lorem text is slandered dummy text lorem text is slandered dummy text lorem text is slandered dummy text ', '2010-10-03 17:11:12', 0, 2);

INSERT INTO `posts` VALUES(6, 'This is my fifth blog post', 'lorem text is slandered dummy text lorem text is slandered dummy text lorem text is slandered dummy text lorem text is slandered dummy text lorem text is slandered dummy text lorem text is slandered dummy text lorem text is slandered dummy text lorem text is slandered dummy text lorem text is slandered dummy text lorem text is slandered dummy text ', '2010-10-03 17:11:17', 0, 2);

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

--

-- Table structure for table `users`

--

CREATE TABLE `users` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `username` varchar(100) NOT NULL,

  `password` varchar(32) NOT NULL,

  `email` varchar(70) NOT NULL,

  PRIMARY KEY (`id`),

  UNIQUE KEY `username` (`username`,`email`)

) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

--

-- Dumping data for table `users`

--

INSERT INTO `users` VALUES(2, 'admin', '21232f297a57a5a743894a0e4a801fc3', 'ad...@localhost.com');

INSERT INTO `users` VALUES(3, 'YourName', 'password', 'ma...@mail.com');

INSERT INTO `users` VALUES(5, 'Mohammed', 'newPassword', 'us...@mail.com');

INSERT INTO `users` VALUES(7, 'user2', 'password', 'us...@mail.com');

INSERT INTO `users` VALUES(8, 'user3', 'password', 'us...@mail.com');

INSERT INTO `users` VALUES(9, 'sfsdfsdf', 'password', 'sdfsdfds');

--

-- Constraints for dumped tables

--

--

-- Constraints for table `comments`

--

ALTER TABLE `comments`

  ADD CONSTRAINT `comments_ibfk_1` FOREIGN KEY (`post_id`) REFERENCES `posts` (`id`);

--

-- Constraints for table `posts`

--

ALTER TABLE `posts`

  ADD CONSTRAINT `posts_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

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

--

Mohammed Jebrini
+970 (or 2 ) 599 937 590

mohammed...@gmail.com

Privileged And Confidential Communication.
This electronic transmission, and any documents attached hereto, (a) are protected by the Electronic Communications Privacy Act (18 USC §§ 2510-2521), (b) may contain confidential and/or legally privileged information, and (c) are for the sole use of the intended recipient named above. If you have received this electronic message in error, please notify the sender and delete the electronic message. Any disclosure, copying, distribution, or use of the contents of the information received in error is strictly prohibited.

P Please consider the environment before printing this e-mail.

[nagham morrar]

ok i will try it now :))