-- MySQL dump 9.09
--
-- Host: localhost Database: kawakbc_forum
---------------------------------------------------------
-- Server version 4.0.15-standard
--
-- Table structure for table `ADDRESS`
--
DROP TABLE IF EXISTS ADDRESS;
CREATE TABLE ADDRESS (
id int(11) NOT NULL auto_increment,
uid int(11) default NULL,
name char(40) default NULL,
email char(50) default NULL,
mobile char(50) default NULL,
home_address char(200) default NULL,
home_tel char(20) default NULL,
business_address char(200) default NULL,
business_tel char(20) default NULL,
birthday date default NULL,
agroup char(20) default NULL,
comment char(255) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;
--
-- Dumping data for table `ADDRESS`
--
--
-- Table structure for table `CALENDAR`
--
DROP TABLE IF EXISTS CALENDAR;
CREATE TABLE CALENDAR (
id int(11) NOT NULL auto_increment,
uid int(11) default NULL,
rdate datetime default NULL,
title char(255) default NULL,
comment char(255) default NULL,
sdate datetime default NULL,
edate datetime default NULL,
public char(1) default NULL,
periodic char(1) default NULL,
period char(1) default NULL,
disabled char(1) default NULL,
priority char(1) default NULL,
bkid int(11) default NULL,
url char(255) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;
--
-- Dumping data for table `CALENDAR`
--
--
-- Table structure for table `CONFIG`
--
DROP TABLE IF EXISTS CONFIG;
CREATE TABLE CONFIG (
uid int(11) NOT NULL default '0',
memo text,
config text,
PRIMARY KEY (uid)
) TYPE=MyISAM;
--
-- Dumping data for table `CONFIG`
--
--
-- Table structure for table `Csa23Tw`
--
DROP TABLE IF EXISTS Csa23Tw;
CREATE TABLE Csa23Tw (
userid int(10) unsigned NOT NULL auto_increment,
usergroupid smallint(5) unsigned NOT NULL default '0',
username varchar(50) NOT NULL default '',
password varchar(50) NOT NULL default '',
email varchar(50) NOT NULL default '',
styleid smallint(5) unsigned NOT NULL default '0',
parentemail varchar(50) NOT NULL default '',
coppauser smallint(6) NOT NULL default '0',
homepage varchar(100) NOT NULL default '',
icq varchar(20) NOT NULL default '',
aim varchar(20) NOT NULL default '',
yahoo varchar(20) NOT NULL default '',
signature mediumtext NOT NULL,
adminemail smallint(6) NOT NULL default '0',
showemail smallint(6) NOT NULL default '0',
invisible smallint(6) NOT NULL default '0',
usertitle varchar(250) NOT NULL default '',
customtitle smallint(6) NOT NULL default '0',
joindate int(10) unsigned NOT NULL default '0',
cookieuser smallint(6) NOT NULL default '0',
daysprune smallint(6) NOT NULL default '0',
lastvisit int(10) unsigned NOT NULL default '0',
lastactivity int(10) unsigned NOT NULL default '0',
lastpost int(10) unsigned NOT NULL default '0',
posts smallint(5) unsigned NOT NULL default '0',
timezoneoffset varchar(4) NOT NULL default '',
emailnotification smallint(6) NOT NULL default '0',
buddylist mediumtext NOT NULL,
ignorelist mediumtext NOT NULL,
pmfolders mediumtext NOT NULL,
receivepm smallint(6) NOT NULL default '0',
emailonpm smallint(6) NOT NULL default '0',
pmpopup smallint(6) NOT NULL default '0',
avatarid smallint(6) NOT NULL default '0',
options smallint(6) NOT NULL default '15',
birthday date NOT NULL default '0000-00-00',
maxposts smallint(6) NOT NULL default '-1',
startofweek smallint(6) NOT NULL default '1',
ipaddress varchar(20) NOT NULL default '',
referrerid int(10) unsigned NOT NULL default '0',
nosessionhash smallint(6) NOT NULL default '0',
inforum smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (userid),
KEY usergroupid (usergroupid),
KEY username (username),
KEY inforum (inforum)
) TYPE=MyISAM;
--
-- Dumping data for table `Csa23Tw`
--
INSERT INTO Csa23Tw (userid, usergroupid, username, password, email, styleid, parentemail, coppauser, homepage, icq, aim, yahoo, signature, adminemail, showemail, invisible, usertitle, customtitle, joindate, cookieuser, daysprune, lastvisit, lastactivity, lastpost, posts, timezoneoffset, emailnotification, buddylist, ignorelist, pmfolders, receivepm, emailonpm, pmpopup, avatarid, options, birthday, maxposts, startofweek, ipaddress, referrerid, nosessionhash, inforum) VALUES (1,6,'Space-tooN','428cc5906dda703217de5d515bbd7a15','aa7at@hotmail.com',1,'',0,'http://space-toon.com','','','','',1,0,1,'المشرف العام',1,1013360385,1,-1,1016070701,1016076697,1015423815,0,'0',0,'','','',1,1,1,0,15,'0000-00-00',-1,6,'',0,1,2);
INSERT INTO Csa23Tw (userid, usergroupid, username, password, email, styleid, parentemail, coppauser, homepage, icq, aim, yahoo, signature, adminemail, showemail, invisible, usertitle, customtitle, joindate, cookieuser, daysprune, lastvisit, lastactivity, lastpost, posts, timezoneoffset, emailnotification, buddylist, ignorelist, pmfolders, receivepm, emailonpm, pmpopup, avatarid, options, birthday, maxposts, startofweek, ipaddress, referrerid, nosessionhash, inforum) VALUES (3,2,'رعــ(الغروب)ــد','428cc5906dda703217de5d515bbd7a15','ra3d66@hotmail.com',1,'',0,'http://','','','','',1,1,0,'جديد اسبيس تون',1,1013372426,1,-1,1016059736,1016059735,1016050563,69,'0',1,'','','',1,0,0,0,15,'0000-00-00',-1,1,'212.138.47.11',0,1,0);
INSERT INTO Csa23Tw (userid, usergroupid, username, password, email, styleid, parentemail, coppauser, homepage, icq, aim, yahoo, signature, adminemail, showemail, invisible, usertitle, customtitle, joindate, cookieuser, daysprune, lastvisit, lastactivity, lastpost, posts, timezoneoffset, emailnotification, buddylist, ignorelist, pmfolders, receivepm, emailonpm, pmpopup, avatarid, options, birthday, maxposts, startofweek, ipaddress, referrerid, nosessionhash, inforum) VALUES (4,2,'لسبيس((الطفل المدلل))توون','b52a9ceab401a2877799151f4197d514','sederella@hotmail.com',1,'',0,'http://space-toon.com','','','','',1,0,1,'جديد اسبيس تون',0,1013386774,1,-1,1016023538,1016057684,1015834330,66,'0',1,'','','',1,1,1,0,15,'1980-02-09',-1,1,'212.138.47.22',0,1,11);
INSERT INTO Csa23Tw (userid, usergroupid, username, password, email, styleid, parentemail, coppauser, homepage, icq, aim, yahoo, signature, adminemail, showemail, invisible, usertitle, customtitle, joindate, cookieuser, daysprune, lastvisit, lastactivity, lastpost, posts, timezoneoffset, emailnotification, buddylist, ignorelist, pmfolders, receivepm, emailonpm, pmpopup, avatarid, options, birthday, maxposts, startofweek, ipaddress, referrerid, nosessionhash, inforum) VALUES (5,2,'sasa29','3ffbef8c36931458716f50168795c7a3','sasa29@hotmail.com',1,'',0,'http://','','','','',1,1,1,'جديد اسبيس تون',0,1013386845,0,-1,1015029826,1015247372,1014230858,1,'3',1,'','','',1,0,0,0,15,'1978-08-08',-1,7,'12.151.162.61',0,0,0);
INSERT INTO Csa23Tw (userid, usergroupid, username, password, email, styleid, parentemail, coppauser, homepage, icq, aim, yahoo, signature, adminemail, showemail, invisible, usertitle, customtitle, joindate, cookieuser, daysprune, lastvisit, lastactivity, lastpost, posts, timezoneoffset, emailnotification, buddylist, ignorelist, pmfolders, receivepm, emailonpm, pmpopup, avatarid, options, birthday, maxposts, startofweek, ipaddress, referrerid, nosessionhash, inforum) VALUES (6,2,'الادميرال','3ca901e7e1075a4683b4744cdae3cb9a','shrshr8@hotmail.com',1,'',0,'http://','','','','شكرا',1,1,1,'عضو جديد',0,1013526122,1,-1,1013526149,1014438247,0,0,'0',1,'','','',1,0,0,0,15,'0000-00-00',-1,1,'212.138.47.11',0,1,0);
INSERT INTO Csa23Tw (userid, usergroupid, username, password, email, styleid, parentemail, coppauser, homepage, icq, aim, yahoo, signature, adminemail, showemail, invisible, usertitle, customtitle, joindate, cookieuser, daysprune, lastvisit, lastactivity, lastpost, posts, timezoneoffset, emailnotification, buddylist, ignorelist, pmfolders, receivepm, emailonpm, pmpopup, avatarid, options, birthday, maxposts, startofweek, ipaddress, referrerid, nosessionhash, inforum) VALUES (7,7,'صدى^الآهات','c648af2cace6e72c543cdcc9571157d3','memo338@hotmail.com',1,'',0,'http://space-toon.com','','','','