سلام
این کد دیتابیس شماست بدون دستکاری
اساتید لطفا راهنمایی فرمایند:
-- version 3.4.3.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Dec 06, 2011 at 10:54 AM
-- Server version: 5.5.13
-- PHP Version: 5.3.6
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: `ccweb`
--
-- --------------------------------------------------------
--
-- Table structure for table `account`
--
CREATE TABLE IF NOT EXISTS `account` (
`username` varchar(255) COLLATE utf8_persian_ci NOT NULL,
`credit` int(11) NOT NULL,
`use` int(11) NOT NULL DEFAULT '0',
`email` varchar(255) COLLATE utf8_persian_ci NOT NULL,
`comment` text COLLATE utf8_persian_ci NOT NULL,
`owner` varchar(255) COLLATE utf8_persian_ci NOT NULL,
`test` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_persian_ci;
-- --------------------------------------------------------
--
-- Table structure for table `admin`
--
CREATE TABLE IF NOT EXISTS `admin` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(255) COLLATE utf8_persian_ci NOT NULL,
`password` varchar(255) COLLATE utf8_persian_ci NOT NULL,
`email` varchar(255) COLLATE utf8_persian_ci NOT NULL,
`subject` varchar(255) COLLATE utf8_persian_ci NOT NULL,
`template` text COLLATE utf8_persian_ci NOT NULL,
`tsubject` varchar(255) COLLATE utf8_persian_ci NOT NULL,
`ttemplate` text COLLATE utf8_persian_ci NOT NULL,
`esubject` varchar(255) COLLATE utf8_persian_ci NOT NULL,
`etemplate` text COLLATE utf8_persian_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_persian_ci AUTO_INCREMENT=1 ;
--
-- Dumping data for table `admin`
--
INSERT INTO `admin` (`id`, `username`, `password`, `email`, `subject`, `template`, `tsubject`, `ttemplate`, `esubject`, `etemplate`) VALUES
(1, 'admin', '21232f297a57a5a743894a0e4a801fc3', '', '', '', '', '', '', '');
-- --------------------------------------------------------
--
-- Table structure for table `chat`
--
CREATE TABLE IF NOT EXISTS `chat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`from` varchar(255) COLLATE utf8_persian_ci NOT NULL,
`to` varchar(255) COLLATE utf8_persian_ci NOT NULL,
`msg` text COLLATE utf8_persian_ci NOT NULL,
`read` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_persian_ci AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `reseller`
--
CREATE TABLE IF NOT EXISTS `reseller` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(255) COLLATE utf8_persian_ci NOT NULL,
`password` varchar(255) COLLATE utf8_persian_ci NOT NULL,
`credit` int(11) NOT NULL DEFAULT '0',
`testcredit` int(11) NOT NULL DEFAULT '0',
`used` int(11) NOT NULL DEFAULT '0',
`testused` int(11) NOT NULL DEFAULT '0',
`email` varchar(255) COLLATE utf8_persian_ci NOT NULL,
`subject` varchar(255) COLLATE utf8_persian_ci NOT NULL,
`template` text CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
`tsubject` varchar(255) COLLATE utf8_persian_ci NOT NULL,
`ttemplate` text COLLATE utf8_persian_ci NOT NULL,
`makereseller` int(11) NOT NULL DEFAULT '1',
`enable` int(11) NOT NULL DEFAULT '1',
`comment` text COLLATE utf8_persian_ci NOT NULL,
`owner` varchar(255) CHARACTER SET utf8 COLLATE utf8_polish_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_persian_ci AUTO_INCREMENT=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 */;
[B]-- phpMyAdmin SQL Dump[/B]