مناقشة الدرس الثانى انشاء قاعدة البيانات باستخدام phpmyadmin عمليا

-- phpMyAdmin SQL Dump
-- version 2.11.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 17, 2008 at 07:12 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `mtwer_g`
--

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

--
-- Table structure for table `badwords`
--

CREATE TABLE IF NOT EXISTS `badwords` (
  `id` int(10) NOT NULL auto_increment,
  `b_word` varchar(100) NOT NULL,
  `b_new` varchar(100) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `badwords`
--


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

--
-- Table structure for table `comments`
--

CREATE TABLE IF NOT EXISTS `comments` (
  `id` int(10) NOT NULL auto_increment,
  `c_name` varchar(100) NOT NULL,
  `c_country` varchar(60) NOT NULL,
  `c_city` varchar(60) NOT NULL,
  `c_email` varchar(100) NOT NULL,
  `c_comment` text NOT NULL,
  `c_time` varchar(60) NOT NULL,
  `active` tinyint(1) NOT NULL,
  `c_ip` varchar(60) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `comments`
--


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

--
-- Table structure for table `moderators`
--

CREATE TABLE IF NOT EXISTS `moderators` (
  `id` int(10) NOT NULL auto_increment,
  `m_name` varchar(100) NOT NULL,
  `m_pass` varchar(100) NOT NULL,
  `m_agree` tinyint(1) NOT NULL,
  `m_edit` tinyint(1) NOT NULL,
  `m_delete` tinyint(1) NOT NULL,
  `m_reply` tinyint(1) NOT NULL,
  `m_upgrade` tinyint(1) NOT NULL,
  `m_ban` tinyint(1) NOT NULL,
  `m_ip` tinyint(1) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `moderators`
--


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

--
-- Table structure for table `smiles`
--

CREATE TABLE IF NOT EXISTS `smiles` (
  `id` int(10) NOT NULL auto_increment,
  `s_name` varchar(100) NOT NULL,
  `s_url` varchar(255) NOT NULL,
  `active` tinyint(1) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `smiles`
--