# --------------------------------------------------------
# DATABASE DUMP
# Host: sql104.hostwq.net
# Time: 11. May 2008 um 16:00
# Running on: Linux cp1.byetcluster.com. 2.6.18-fza-028stab053.5-686 #1 SMP Sat Mar 1 10:53:11 CET 2008 i686
# MySQL-Version: 5.0.51a-5-log
# PHP-Version: 5.2.5
# Database: `hq_1550805_ms`
# --------------------------------------------------------

#
# Data for table `Settings`
#

DROP TABLE IF EXISTS Settings;
CREATE TABLE Settings (
    SettingId int(11) NOT NULL auto_increment,
    site_url varchar(255) NOT NULL,
    site_name varchar(255) NOT NULL,
    Register_status tinyint(1) DEFAULT '0' NOT NULL,
    SMS_status tinyint(1) DEFAULT '0' NOT NULL,
    site_mail varchar(255) NOT NULL,
    site_administrator varchar(255) NOT NULL,
    per_page int(11) DEFAULT '0' NOT NULL,
    Oreginator varchar(11) NOT NULL,
    GatewayUser varchar(255) NOT NULL,
    GatewayPass varchar(255) NOT NULL,
    country_status int(1) DEFAULT '0' NOT NULL,
    varification_status int(1) DEFAULT '0' NOT NULL,
    PRIMARY KEY (SettingId)
);

INSERT INTO Settings (SettingId,site_url,site_name,Register_status,SMS_status,site_mail,site_administrator,per_page,Oreginator,GatewayUser,GatewayPass,country_status,varification_status) VALUES ('1','http://www.domain.com/NewsList','القائمة الإخبارية','1','1','email@domain.com','سعودي اس ام اس','0','Demo','demo','demo','1','1');

#
# Data for table `SmsArchives`
#

DROP TABLE IF EXISTS SmsArchives;
CREATE TABLE SmsArchives (
    id int(6) unsigned NOT NULL auto_increment,
    idUser varchar(255) DEFAULT '0',
    number text,
    msg text,
    date datetime,
    sender varchar(255),
    IsPublic char(1) NOT NULL,
    Groups varchar(255) NOT NULL,
    PRIMARY KEY (id)
);


#
# Data for table `SmsTemp`
#

DROP TABLE IF EXISTS SmsTemp;
CREATE TABLE SmsTemp (
    id int(6) unsigned NOT NULL auto_increment,
    userSender varchar(255) DEFAULT '0',
    numbers text,
    msg text,
    userId varchar(255),
    PRIMARY KEY (id)
);


#
# Data for table `Subscripers`
#

DROP TABLE IF EXISTS Subscripers;
CREATE TABLE Subscripers (
    Id bigint(20) NOT NULL auto_increment,
    Mobile bigint(12) DEFAULT '0' NOT NULL,
    Name varchar(255) NOT NULL,
    Country varchar(255) NOT NULL,
    City varchar(255) NOT NULL,
    SubDate date DEFAULT '0000-00-00' NOT NULL,
    SubStatus char(1) NOT NULL,
    UserKey int(1) DEFAULT '0' NOT NULL,
    PRIMARY KEY (Id),
    UNIQUE Mobile (Mobile)
);


#
# Data for table `temp_msg`
#

DROP TABLE IF EXISTS temp_msg;
CREATE TABLE temp_msg (
    id int(6) NOT NULL auto_increment,
    name varchar(255) DEFAULT '0',
    msg text,
    date varchar(255) DEFAULT '0',
    idCategory int(3) DEFAULT '0' NOT NULL,
    viewMsg varchar(255) DEFAULT '0' NOT NULL,
    userId varchar(255),
    PRIMARY KEY (id)
);

INSERT INTO temp_msg (id,name,msg,date,idCategory,viewMsg,userId) VALUES ('5','test','test msg','2007-06-16 00:56:00','0','','2');
INSERT INTO temp_msg (id,name,msg,date,idCategory,viewMsg,userId) VALUES ('6','اخبار اليوم','تم بحمد الله','2007-07-27 17:25:55','0','','1');

#
# Data for table `users`
#

DROP TABLE IF EXISTS users;
CREATE TABLE users (
    Uid int(11) NOT NULL auto_increment,
    UserName varchar(255) NOT NULL,
    Upassword varchar(32) NOT NULL,
    UName text NOT NULL,
    Umobile varchar(255) NOT NULL,
    Ugroup char(1) DEFAULT 'U' NOT NULL,
    Ustatus char(1) DEFAULT 'N' NOT NULL,
    Usess varchar(255) NOT NULL,
    PRIMARY KEY (Uid),
    UNIQUE UserName (UserName),
    UNIQUE Umobile (Umobile)
);

INSERT INTO users (Uid,UserName,Upassword,UName,Umobile,Ugroup,Ustatus,Usess) VALUES ('1','admin','fe01ce2a7fbac8fafaed7c982a04e229','محمد مصلوخ','966111111111','S','M','fc84be4a32bed0df1c5d7ae3086d0ef9');