Merhaba arkadaşlar altaki veri sql dosyasini kurmak istiyorum veritabani adi , kullanıcı adı , site adresi, keyword, kelime hangileriyle değistircem acaba beynim durdu suan iftar çartpi galiba
-- phpMyAdmin SQL Dump
-- version 4.1.8
-- http://www.phpmyadmin.net
--
-- Anamakine: localhost
-- Üretim Zamanı: 06 May 2014, 19:12:41
-- Sunucu sürümü: 5.5.36-cll
-- PHP Sürümü: 5.4.23
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 */;
--
-- Veritabanı: `teppz_de`
--
-- --------------------------------------------------------
--
-- Tablo için tablo yapısı `questions`
--
CREATE TABLE IF NOT EXISTS `questions` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`to_user` varchar(400) NOT NULL,
`question` text NOT NULL,
`from_user` varchar(400) NOT NULL,
`answer` text NOT NULL,
`status` set('0','1') NOT NULL,
`anonymous` set('0','1') NOT NULL,
`date` varchar(20) NOT NULL,
`ip` varchar(30) NOT NULL,
`time` varchar(30) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tablo için tablo yapısı `site_config`
--
CREATE TABLE IF NOT EXISTS `site_config` (
`website_name` varchar(500) NOT NULL,
`website_domain` text NOT NULL,
`website_keywords` text NOT NULL,
`website_description` text NOT NULL,
`website_language` varchar(60) NOT NULL,
`website_maintenance` set('0','1') NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Tablo için tablo yapısı `users`
--
CREATE TABLE IF NOT EXISTS `users` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID do Usuário',
`username` varchar(400) NOT NULL COMMENT 'Nome do Usuário',
`password` text NOT NULL COMMENT 'Senha',
`real_name` varchar(400) NOT NULL COMMENT 'Nome e/ou Sobrenome',
`real_surname` varchar(400) NOT NULL,
`rank` enum('0','1','2') NOT NULL,
`email` varchar(200) NOT NULL COMMENT 'Email',
`website` varchar(300) NOT NULL COMMENT 'Site',
`localization` varchar(300) NOT NULL COMMENT 'Localização',
`bio` text NOT NULL COMMENT 'Sobre Mim',
`what_ask` varchar(400) NOT NULL,
`theme` enum('birch','bluedots','charcoal','chocolate','cranberry','default','django','forest','indigo','morocco','pinkdots','tartan') NOT NULL,
`photo` text NOT NULL,
`status` enum('0','1') NOT NULL,
`ip` varchar(50) NOT NULL,
`password_key` varchar(400) NOT NULL,
`anonymous_view` enum('0','1') NOT NULL,
`reg_date` varchar(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Tablo için tablo yapısı `widgets`
--
CREATE TABLE IF NOT EXISTS `widgets` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(400) NOT NULL,
`size` set('Large','Medium','Small') NOT NULL,
`background_color` varchar(200) NOT NULL,
`foreground_color` varchar(200) NOT NULL,
`height` varchar(10) NOT NULL,
`width` varchar(10) NOT NULL,
`status` varchar(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 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 */;