كود:
# DatabaseBackup
# Backup made:
# March 9, 2005, 12:48 pm
# Database: neda
# Backed up tables : neda
# --------------------------------------------------------
#
# Table structure for table 'admin'
#
DROP TABLE IF EXISTS admin;
CREATE TABLE admin (
user varchar(250) NOT NULL,
password varchar(250) NOT NULL,
mail varchar(150) NOT NULL,
id int(11) NOT NULL auto_increment,
PRIMARY KEY (id)
);
#
# Dumping data for table 'admin'
#
INSERT INTO admin VALUES ('s','s','s',1);
# --------------------------------------------------------
#
# Table structure for table 'cnew'
#
DROP TABLE IF EXISTS cnew;
CREATE TABLE cnew (
id int(11) NOT NULL auto_increment,
cename varchar(150) NOT NULL,
cepict blob NOT NULL,
cedes text NOT NULL,
PRIMARY KEY (id)
);
#
# Dumping data for table 'cnew'
#
# --------------------------------------------------------
#
# Table structure for table 'comment'
#
DROP TABLE IF EXISTS comment;
CREATE TABLE comment (
id int(11) NOT NULL auto_increment,
nasheedid int(8) DEFAULT '0' NOT NULL,
cname varchar(150) NOT NULL,
coment text NOT NULL,
spost char(3) NOT NULL,
date text NOT NULL,
email varchar(150) NOT NULL,
PRIMARY KEY (id)
);
#
# Dumping data for table 'comment'
#
# --------------------------------------------------------
#
# Table structure for table 'cpict'
#
DROP TABLE IF EXISTS cpict;
CREATE TABLE cpict (
id int(11) NOT NULL auto_increment,
cname varchar(150) NOT NULL,
cpict blob NOT NULL,
cdes text NOT NULL,
PRIMARY KEY (id)
);
#
# Dumping data for table 'cpict'
#
# --------------------------------------------------------
#
# Table structure for table 'khbr'
#
DROP TABLE IF EXISTS khbr;
CREATE TABLE khbr (
id int(11) NOT NULL auto_increment,
titkh varchar(150) NOT NULL,
mskh text NOT NULL,
date text NOT NULL,
PRIMARY KEY (id)
);
#
# Dumping data for table 'khbr'
#
INSERT INTO khbr VALUES (1,'سكربت نداء الإسلام الأصدارة 2',' بسم الله الرحمن الرحيم <br/>\r\n<b>نقدم لكم هذا السكربت على أمل ان يجد استحسانكم وكل ماأطلبه من أخواني العرب حفظ الحقوق وعدم استخدامه في اي مخالفة شرعية والله سبحانه وتعالى حسيب من لم يوف بالعهدلأستفساراتكم ومقترحاتكم الرجاء التواصل على usrphp@hotmail.com ','');
# --------------------------------------------------------
#
# Table structure for table 'mnew'
#
DROP TABLE IF EXISTS mnew;
CREATE TABLE mnew (
id int(11) NOT NULL auto_increment,
cnewid int(11) DEFAULT '0' NOT NULL,
mname text NOT NULL,
mtext text NOT NULL,
mtitle varchar(150) NOT NULL,
mtmail varchar(150) NOT NULL,
mlook int(9) DEFAULT '0' NOT NULL,
mpict varchar(150) NOT NULL,
mpost varchar(150) NOT NULL,
date text NOT NULL,
PRIMARY KEY (id)
);
#
# Dumping data for table 'mnew'
#
# --------------------------------------------------------
#
# Table structure for table 'mpict'
#
DROP TABLE IF EXISTS mpict;
CREATE TABLE mpict (
id int(11) NOT NULL auto_increment,
cpictid int(11) DEFAULT '0' NOT NULL,
mpname text NOT NULL,
mptitle varchar(150) NOT NULL,
mpmail varchar(150) NOT NULL,
mpdown varchar(150) NOT NULL,
mplesn varchar(150) NOT NULL,
mplook int(9) DEFAULT '0' NOT NULL,
mpndown int(9) DEFAULT '0' NOT NULL,
mpless varchar(8) NOT NULL,
mppost char(3) NOT NULL,
date text NOT NULL,
PRIMARY KEY (id)
);
#
# Dumping data for table 'mpict'
#
# --------------------------------------------------------
#
# Table structure for table 'nash'
#
DROP TABLE IF EXISTS nash;
CREATE TABLE nash (
id int(7) NOT NULL auto_increment,
pict varchar(100) NOT NULL,
name varchar(40) NOT NULL,
des varchar(200) NOT NULL,
PRIMARY KEY (id)
);
#
# Dumping data for table 'nash'
#
# --------------------------------------------------------
#
# Table structure for table 'nasheed'
#
DROP TABLE IF EXISTS nasheed;
CREATE TABLE nasheed (
id int(8) NOT NULL auto_increment,
nashid int(7) DEFAULT '0' NOT NULL,
monshed varchar(200) NOT NULL,
title varchar(200) NOT NULL,
email varchar(200) NOT NULL,
down varchar(250) NOT NULL,
ndown int(9) DEFAULT '0' NOT NULL,
npost char(3) NOT NULL,
lesn varchar(250) NOT NULL,
count int(9) DEFAULT '0' NOT NULL,
date text NOT NULL,
send varchar(10) NOT NULL,
ndes text NOT NULL,
PRIMARY KEY (id)
);
#
# Dumping data for table 'nasheed'
#
# --------------------------------------------------------
#
# Table structure for table 'necomment'
#
DROP TABLE IF EXISTS necomment;
CREATE TABLE necomment (
id int(11) NOT NULL auto_increment,
mnewid int(8) DEFAULT '0' NOT NULL,
nename varchar(150) NOT NULL,
necoment text NOT NULL,
nepost char(3) NOT NULL,
date text NOT NULL,
nemail varchar(150) NOT NULL,
PRIMARY KEY (id)
);
#
# Dumping data for table 'necomment'
#
# --------------------------------------------------------
#
# Table structure for table 'picomment'
#
DROP TABLE IF EXISTS picomment;
CREATE TABLE picomment (
id int(11) NOT NULL auto_increment,
mpictid int(8) DEFAULT '0' NOT NULL,
piname varchar(150) NOT NULL,
picoment text NOT NULL,
pipost char(3) NOT NULL,
date text NOT NULL,
piemail varchar(150) NOT NULL,
PRIMARY KEY (id)
);
#
# Dumping data for table 'picomment'
#
# --------------------------------------------------------
#
# Table structure for table 'sglat'
#
DROP TABLE IF EXISTS sglat;
CREATE TABLE sglat (
id int(7) unsigned NOT NULL auto_increment,
name varchar(30) NOT NULL,
mail varchar(50) NOT NULL,
url varchar(50) NOT NULL,
country varchar(50) NOT NULL,
site varchar(50) NOT NULL,
date text NOT NULL,
time varchar(20) NOT NULL,
ip varchar(20) NOT NULL,
postsgl char(3) NOT NULL,
postmem char(3) NOT NULL,
msg text NOT NULL,
PRIMARY KEY (id)
);
#
# Dumping data for table 'sglat'
#
رد مع اقتباس
المشاركة الأصلية كتبت بواسطة alaneed
