/*
SQLyog - Free MySQL GUI v5.12
Host - 5.0.24-community-nt : Database - virtualmsgr
*********************************************************************
Server version : 5.0.24-community-nt
*/


SET NAMES utf8;

SET SQL_MODE='';

create database if not exists `chequedb`;

USE `chequedb`;

/*Table structure for table `addbookgroups` */

DROP TABLE IF EXISTS `addbookgroups`;

CREATE TABLE `addbookgroups` (
  `ID` bigint(20) NOT NULL auto_increment,
  `GroupName` varchar(255) default NULL,
  `GroupUsers` text,
  `Status` varchar(25) default 'ACTIVE',
  `Owner` varchar(35) default 'admin',
  `Share` varchar(10) default 'No',
  `ShareGroup` varchar(65) default 'PERSONAL',
  `grptype` varchar(25) default NULL,
  PRIMARY KEY  (`ID`),
  KEY `Owner` (`Owner`),
  KEY `ShareGroup` (`ShareGroup`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `addressbook` */

DROP TABLE IF EXISTS `addressbook`;

CREATE TABLE `addressbook` (
  `bid` bigint(20) NOT NULL auto_increment,
  `nmcode` varchar(75) default NULL,
  `name` varchar(255) default NULL,
  `company` varchar(255) default NULL,
  `address` text,
  `address2` text,
  `contactno` varchar(255) default NULL,
  `faxno` varchar(255) default NULL,
  `mobileno` varchar(255) default NULL,
  `email` varchar(255) default NULL,
  `urlweb` varchar(255) default 'http://',
  `xdescription` text,
  `namecard` longblob,
  `bnamecard` longblob,
  `createby` varchar(255) default NULL,
  `insertdate` datetime default NULL,
  `lastmodified` datetime default NULL,
  `status` varchar(50) default 'PERSONAL',
  `noic` varchar(50) default NULL,
  `GroupName` varchar(255) default NULL,
  `Cname` varchar(120) default NULL,
  `jawatan` varchar(45) default NULL,
  `desc` text,
  `category` varchar(100) default NULL,
  `pbt` varchar(25) default NULL,
  PRIMARY KEY  (`bid`),
  KEY `aname` (`name`),
  KEY `status` (`status`),
  KEY `createby` (`createby`),
  KEY `mobileno` (`mobileno`),
  KEY `nmcode` (`nmcode`),
  KEY `insertdate` (`insertdate`),
  KEY `company` (`company`)
) ENGINE=MyISAM AUTO_INCREMENT=3257 DEFAULT CHARSET=latin1;

/*Table structure for table `addrgrpmembers` */

DROP TABLE IF EXISTS `addrgrpmembers`;

CREATE TABLE `addrgrpmembers` (
  `idno` bigint(20) NOT NULL auto_increment,
  `nmcode` varchar(15) default NULL,
  `addrgroup` varchar(15) default NULL,
  PRIMARY KEY  (`idno`),
  KEY `nmcode` (`nmcode`),
  KEY `addrgroup` (`addrgroup`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `alias` */

DROP TABLE IF EXISTS `alias`;

CREATE TABLE `alias` (
  `IDNO` int(11) NOT NULL auto_increment,
  `ALIAS` varchar(75) default NULL,
  `USERID` varchar(75) default NULL,
  `DOMAINNAME` varchar(125) default 'vss.com.my',
  `TYPE` varchar(25) default NULL,
  PRIMARY KEY  (`IDNO`),
  KEY `ALIAS` (`ALIAS`),
  KEY `DOMAINNAME` (`DOMAINNAME`)
) ENGINE=MyISAM AUTO_INCREMENT=289 DEFAULT CHARSET=latin1;

/*Table structure for table `allowed` */

DROP TABLE IF EXISTS `allowed`;

CREATE TABLE `allowed` (
  `IDNO` int(11) NOT NULL auto_increment,
  `ROOM` varchar(35) default NULL,
  `USERID` varchar(35) default NULL,
  `SITES` varchar(200) default NULL,
  PRIMARY KEY  (`IDNO`),
  KEY `ROOM` (`ROOM`,`USERID`)
) ENGINE=MyISAM AUTO_INCREMENT=124 DEFAULT CHARSET=latin1;

/*Table structure for table `artcomments` */

DROP TABLE IF EXISTS `artcomments`;

CREATE TABLE `artcomments` (
  `idno` bigint(20) NOT NULL auto_increment,
  `artid` bigint(20) default NULL,
  `comment` longtext,
  `userid` varchar(65) default NULL,
  `tarikh` datetime default NULL,
  PRIMARY KEY  (`idno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `articles` */

DROP TABLE IF EXISTS `articles`;

CREATE TABLE `articles` (
  `idno` bigint(20) NOT NULL auto_increment,
  `userid` varchar(65) default NULL,
  `comment` longtext,
  `tarikh` datetime default NULL,
  `category` varchar(65) default NULL,
  `atype` varchar(65) default NULL,
  `title` varchar(190) default NULL,
  `allowcomment` varchar(5) default NULL,
  PRIMARY KEY  (`idno`),
  KEY `poster` (`userid`),
  KEY `tarikh` (`tarikh`),
  KEY `category` (`category`),
  KEY `atype` (`atype`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `bankaccounts` */

DROP TABLE IF EXISTS `bankaccounts`;

CREATE TABLE `bankaccounts` (
  `accountno` varchar(35) NOT NULL,
  `bank` varchar(120) default NULL,
  `curchequeno` int(11) default NULL,
  `ptleft` int(11) default '65',
  `pttop` int(11) default '562',
  `rmleft` int(11) default '65',
  `rmtop` int(11) default '595',
  `rm2left` int(11) default '27',
  `rm2top` int(11) default '633',
  `cashleft` int(11) default '475',
  `cashtop` int(11) default '600',
  `datex1` int(11) default '496',
  `datex2` int(11) default '526',
  `datex3` int(11) default '556',
  `datex4` int(11) default '586',
  `datex5` int(11) default '616',
  `datex6` int(11) default '646',
  `datestyle` int(11) default '1',
  `company` varchar(120) default 'Virtual Softnet Solutions Sdn. Bhd.',
  `datetop` int(11) default '526',
  `branch` varchar(120) default NULL,
  `total_signatories` int(11) default '3',
  `orientation` int(11) default '0',
  `YOffset` int(11) default '455',
  `XOffset` int(11) default NULL,
  PRIMARY KEY  (`accountno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `blocksubject` */

DROP TABLE IF EXISTS `blocksubject`;

CREATE TABLE `blocksubject` (
  `idno` int(11) NOT NULL auto_increment,
  `subject` varchar(120) default NULL,
  PRIMARY KEY  (`idno`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Table structure for table `charges` */

DROP TABLE IF EXISTS `charges`;

CREATE TABLE `charges` (
  `idno` int(11) NOT NULL auto_increment,
  `PreFix` varchar(10) default NULL,
  `DestiTelco` varchar(15) default NULL,
  `SMSCharge` float default NULL,
  `owner` varchar(75) default 'abakar',
  PRIMARY KEY  (`idno`),
  KEY `PreFix` (`PreFix`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `cheque_details` */

DROP TABLE IF EXISTS `cheque_details`;

CREATE TABLE `cheque_details` (
  `IDNO` int(11) NOT NULL auto_increment,
  `dateaction` datetime default NULL,
  `accountno` varchar(35) default NULL,
  `chequeno` int(11) default NULL,
  `userid` varchar(75) default NULL,
  `status` varchar(120) default NULL,
  `lock` int(11) default '1',
  PRIMARY KEY  (`IDNO`),
  KEY `dateaction` (`dateaction`),
  KEY `accountno` (`accountno`),
  KEY `chequeno` (`chequeno`),
  KEY `status` (`status`),
  KEY `userid` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `cheque_items` */

DROP TABLE IF EXISTS `cheque_items`;

CREATE TABLE `cheque_items` (
  `idno` bigint(20) NOT NULL,
  `chequeno` int(11) default NULL,
  `accountno` varchar(35) default NULL,
  `transtype` varchar(75) default 'CHEQUE',
  `bank` varchar(75) default NULL,
  `chequedate` date default NULL,
  `amount` double default NULL,
  `dateissue` datetime default NULL,
  `paymentfor` varchar(255) default NULL,
  `draftby` varchar(75) default NULL,
  `signatory1` varchar(75) default NULL,
  `signatory2` varchar(75) default NULL,
  `signatory3` varchar(75) default NULL,
  `signdate1` datetime default NULL,
  `signdate2` datetime default NULL,
  `signdate3` datetime default NULL,
  `payto` varchar(75) default NULL,
  `status` varchar(35) default NULL,
  `ref_no` varchar(35) default NULL,
  `vendorid` varchar(15) default NULL,
  `voucherid` int(11) default NULL,
  `AYear` int(11) default NULL,
  `AMonth` int(11) default NULL,
  `AWeek` int(11) default NULL,
  `ADay` int(11) default NULL,
  `balance` double default NULL,
  `real_balance` double default NULL,	
  `signmode` double default '-1.0',
  `alock` int(11) default '1',	
  PRIMARY KEY  (`idno`),
  KEY `transtype` (`transtype`),
  KEY `chequedate` (`chequedate`),
  KEY `dateissue` (`dateissue`),
  KEY `accountno` (`accountno`),
  KEY `bank` (`bank`),
  KEY `status` (`status`),
  KEY `vendorid` (`vendorid`),
  KEY `vaucherid` (`voucherid`),
  KEY `AYear` (`AYear`),
  KEY `AMonth` (`AMonth`),
  KEY `AWeek` (`AWeek`),
  KEY `ADay` (`ADay`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `cheque_items_cleared` */

DROP TABLE IF EXISTS `cheque_items_cleared`;

CREATE TABLE `cheque_items_cleared` (
  `id` bigint(20) NOT NULL auto_increment,
  `idno` bigint(20) NOT NULL,
  `chequeno` int(11) default NULL,
  `accountno` varchar(35) default NULL,
  `bank` varchar(75) default NULL,
  `chequedate` date default NULL,
  `amount` double default NULL,
  `dateissue` datetime default NULL,
  `paymentfor` varchar(255) default NULL,
  `draftby` varchar(75) default NULL,
  `signatory1` varchar(75) default NULL,
  `signatory2` varchar(75) default NULL,
  `signatory3` varchar(75) default NULL,
  `signdate1` datetime default NULL,
  `signdate2` datetime default NULL,
  `signdate3` datetime default NULL,
  `payto` varchar(75) default NULL,
  `status` varchar(35) default NULL,
  `ref_no` varchar(35) default NULL,
  `vendorid` varchar(15) default NULL,
  `voucherid` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `chequedate` (`chequedate`),
  KEY `dateissue` (`dateissue`),
  KEY `accountno` (`accountno`),
  KEY `bank` (`bank`),
  KEY `status` (`status`),
  KEY `vendorid` (`vendorid`),
  KEY `vaucherid` (`voucherid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `chequeusers` */

DROP TABLE IF EXISTS `chequeusers`;

CREATE TABLE `chequeusers` (
  `idno` bigint(20) NOT NULL auto_increment,
  `userid` varchar(75) default NULL,
  `grp` varchar(75) default NULL,
  PRIMARY KEY  (`idno`),
  KEY `userid` (`userid`),
  KEY `grp` (`grp`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `credits` */

DROP TABLE IF EXISTS `credits`;

CREATE TABLE `credits` (
  `idno` int(11) NOT NULL auto_increment,
  `TELCO` varchar(25) default NULL,
  `PreFix` varchar(5) default NULL,
  `CurrentCredit` float default NULL,
  `PhoneNo` varchar(15) default NULL,
  `PortID` int(11) default NULL,
  PRIMARY KEY  (`idno`),
  KEY `TELCO` (`TELCO`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `cusdlog` */

DROP TABLE IF EXISTS `cusdlog`;

CREATE TABLE `cusdlog` (
  `id` bigint(20) NOT NULL auto_increment,
  `tarikh` datetime default NULL,
  `cmdtxt` varchar(75) default NULL,
  `rettxt` text,
  `owner` varchar(75) default NULL,
  `astatus` varchar(15) default 'NEW',
  `endpat` varchar(15) default ',15',
  `atype` varchar(25) default 'BALANCE',
  PRIMARY KEY  (`id`),
  KEY `tarikh` (`tarikh`),
  KEY `astatus` (`astatus`),
  KEY `owner` (`owner`),
  KEY `atype` (`atype`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `departments` */

DROP TABLE IF EXISTS `departments`;

CREATE TABLE `departments` (
  `department` varchar(75) NOT NULL default '',
  `description` varchar(150) default NULL,
  PRIMARY KEY  (`department`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Table structure for table `detailcharges` */

DROP TABLE IF EXISTS `detailcharges`;

CREATE TABLE `detailcharges` (
  `idno` bigint(20) NOT NULL auto_increment,
  `tarikh` datetime default NULL,
  `userid` varchar(35) default NULL,
  `phoneno` varchar(20) default NULL,
  `charges` float default NULL,
  `smslen` int(11) default NULL,
  `totalsms` int(11) default NULL,
  `Telco` varchar(25) default NULL,
  `usercharges` float default NULL,
  `owner` varchar(75) default 'abakar',
  PRIMARY KEY  (`idno`),
  KEY `tarikh` (`tarikh`),
  KEY `userid` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `domains` */

DROP TABLE IF EXISTS `domains`;

CREATE TABLE `domains` (
  `DOMAINNAME` varchar(125) NOT NULL default '',
  `ADESC` varchar(175) default NULL,
  `ADEFAULT` int(11) default NULL,
  `USERID` varchar(75) default NULL,
  PRIMARY KEY  (`DOMAINNAME`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Table structure for table `emailoutbox` */

DROP TABLE IF EXISTS `emailoutbox`;

CREATE TABLE `emailoutbox` (
  `idno` bigint(20) NOT NULL auto_increment,
  `afrom` varchar(100) default NULL,
  `fromemail` varchar(100) default NULL,
  `ato` varchar(100) default NULL,
  `asubject` varchar(200) default NULL,
  `abody` longblob,
  `status` varchar(15) default NULL,
  `date_insert` datetime default NULL,
  PRIMARY KEY  (`idno`),
  KEY `status` (`status`),
  KEY `date_insert` (`date_insert`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `expireddates` */

DROP TABLE IF EXISTS `expireddates`;

CREATE TABLE `expireddates` (
  `idno` bigint(20) NOT NULL auto_increment,
  `identity` varchar(75) default NULL,
  `expired_date` datetime default NULL,
  `amemo` text,
  PRIMARY KEY  (`idno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `friend_list` */

DROP TABLE IF EXISTS `friend_list`;

CREATE TABLE `friend_list` (
  `idno` int(11) NOT NULL auto_increment,
  `userid` char(100) default NULL,
  `friendid` char(100) default NULL,
  `category` char(100) default 'Normal',
  PRIMARY KEY  (`idno`),
  KEY `friend_id` (`friendid`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM AUTO_INCREMENT=773 DEFAULT CHARSET=latin1;

/*Table structure for table `friendlists` */

DROP TABLE IF EXISTS `friendlists`;

CREATE TABLE `friendlists` (
  `idno` int(11) NOT NULL default '0',
  `userid` varchar(100) default NULL,
  `friendlistdesc` varchar(175) default NULL,
  PRIMARY KEY  (`idno`),
  KEY `friendlistdesc` (`friendlistdesc`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Table structure for table `groupmembers` */

DROP TABLE IF EXISTS `groupmembers`;

CREATE TABLE `groupmembers` (
  `idno` bigint(20) NOT NULL auto_increment,
  `GroupIdentity` varchar(75) default NULL,
  `userid` varchar(75) default NULL,
  PRIMARY KEY  (`idno`),
  KEY `GroupIdentity` (`GroupIdentity`),
  KEY `userid` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `groupphotos` */

DROP TABLE IF EXISTS `groupphotos`;

CREATE TABLE `groupphotos` (
  `idno` bigint(20) NOT NULL auto_increment,
  `grp` varchar(100) default NULL,
  `userid` varchar(75) default NULL,
  `fileloc` varchar(200) default NULL,
  `tarikh` datetime default NULL,
  `filethumb` varchar(200) default NULL,
  `comment` longblob,
  PRIMARY KEY  (`idno`),
  KEY `grp` (`grp`),
  KEY `userid` (`userid`),
  KEY `tarikh` (`tarikh`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `groups` */

DROP TABLE IF EXISTS `groups`;

CREATE TABLE `groups` (
  `idno` int(11) NOT NULL auto_increment,
  `grpidentity` varchar(75) default NULL,
  `groupname` varchar(120) default NULL,
  `state` varchar(75) default NULL,
  `pbt` varchar(10) default NULL,
  `owner` varchar(75) default NULL,
  `date_registered` datetime default NULL,
  `anyone` varchar(5) default NULL,
  `request` varchar(5) default NULL,
  `invite` varchar(5) default NULL,
  `view` varchar(5) default '1',
  `desc1` blob,
  PRIMARY KEY  (`idno`),
  KEY `grpidentity` (`grpidentity`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `grppiccomment` */

DROP TABLE IF EXISTS `grppiccomment`;

CREATE TABLE `grppiccomment` (
  `idno` bigint(20) NOT NULL auto_increment,
  `picid` bigint(20) default NULL,
  `comment` longblob,
  `tarikh` datetime default NULL,
  `userid` varchar(75) default NULL,
  PRIMARY KEY  (`idno`),
  KEY `picid` (`picid`),
  KEY `tarikh` (`tarikh`),
  KEY `userid` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `imlog` */

DROP TABLE IF EXISTS `imlog`;

CREATE TABLE `imlog` (
  `idno` int(11) NOT NULL auto_increment,
  `adate` double default NULL,
  `fromid` varchar(120) default NULL,
  `toid` varchar(120) default NULL,
  `atext` longtext,
  `astatus` varchar(15) default NULL,
  `bstatus` varchar(15) default NULL,
  `amode` int(11) default NULL,
  PRIMARY KEY  (`idno`),
  KEY `adate` (`adate`),
  KEY `fromid` (`fromid`),
  KEY `toid` (`toid`)
) ENGINE=MyISAM AUTO_INCREMENT=254890 DEFAULT CHARSET=latin1;

/*Table structure for table `inbox` */

DROP TABLE IF EXISTS `inbox`;

CREATE TABLE `inbox` (
  `IDNO` int(11) NOT NULL auto_increment,
  `Tarikh` datetime default NULL,
  `PhoneNo` varchar(35) default NULL,
  `TxtMsg` text,
  `AStatus` varchar(10) default NULL,
  `ASize` int(11) default NULL,
  `ATime` datetime default NULL,
  `ATxt` varchar(75) default NULL,
  `AName` varchar(120) default NULL,
  `ICNo` varchar(35) default NULL,
  `RowId` int(11) default NULL,
  `FormatStatus` varchar(20) default NULL,
  `StatusReply` varchar(20) default 'NEW',
  `userid` varchar(75) default NULL,
  `TextOk` int(11) default '1',
  `owner` varchar(75) default 'abakar',
  `Lock` int(11) default NULL,
  `smscode` varchar(35) default NULL,
  PRIMARY KEY  (`IDNO`),
  KEY `Tarikh` (`Tarikh`),
  KEY `AStatus` (`AStatus`),
  KEY `userid` (`userid`),
  KEY `owner` (`owner`),
  KEY `smscode` (`smscode`),
  KEY `StatusReply` (`StatusReply`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `invoices` */

DROP TABLE IF EXISTS `invoices`;

CREATE TABLE `invoices` (
  `idno` bigint(20) NOT NULL auto_increment,
  `vendorid` varchar(10) default NULL,
  `refno` varchar(75) default NULL,
  `invoicedate` date default NULL,
  `duedate` date default NULL,
  `category` varchar(75) default NULL,
  `description` varchar(120) default NULL,
  `amount` double default NULL,
  `branch` varchar(75) default NULL,
  `voucherid` bigint(20) default NULL,
  `status` varchar(15) default 'NEW',
  `attachment` varchar(250) default NULL,
  `draftedby` varchar(75) default NULL,
  `validatedby` varchar(75) default NULL,
  `filename` varchar(25) default NULL,
  `remarks` text,
  `catid` int(11) default NULL,
  `daterequest` datetime default NULL,
  `priority` int(11) default NULL,
  PRIMARY KEY  (`idno`),
  KEY `vaucherno` (`voucherid`),
  KEY `duedate` (`duedate`),
  KEY `status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `ipblocklists` */

DROP TABLE IF EXISTS `ipblocklists`;

CREATE TABLE `ipblocklists` (
  `idno` int(11) NOT NULL auto_increment,
  `IPAddress` varchar(25) default NULL,
  `Comments` varchar(200) default 'Excessive unknown receipients. Possible spamming',
  `Status` varchar(15) default NULL,
  `Occurance` int(11) default NULL,
  `LastOccurance` datetime default NULL,
  `Reason` varchar(200) default NULL,
  `LastBLCheck` datetime default NULL,
  `astatus` varchar(125) default NULL,
  `date_happen` datetime default NULL,
  PRIMARY KEY  (`idno`),
  UNIQUE KEY `IPAddress` (`IPAddress`)
) ENGINE=MyISAM AUTO_INCREMENT=181512 DEFAULT CHARSET=latin1;

/*Table structure for table `ipblocktrail` */

DROP TABLE IF EXISTS `ipblocktrail`;

CREATE TABLE `ipblocktrail` (
  `idno` int(11) NOT NULL auto_increment,
  `ipaddress` varchar(25) default NULL,
  `reason` varchar(200) default NULL,
  `date_happen` datetime default NULL,
  `fromdomain` varchar(150) default NULL,
  PRIMARY KEY  (`idno`),
  KEY `ipaddress` (`ipaddress`)
) ENGINE=MyISAM AUTO_INCREMENT=535946 DEFAULT CHARSET=latin1;

/*Table structure for table `lat_log` */

DROP TABLE IF EXISTS `lat_log`;

CREATE TABLE `lat_log` (
  `ID` int(4) NOT NULL auto_increment,
  `CODE` varchar(25) NOT NULL default '',
  `NAME` varchar(125) NOT NULL default '',
  `LATITUDE` double(14,12) NOT NULL default '0.000000000000',
  `LOGITUTE` double(14,12) NOT NULL default '0.000000000000',
  `HEIGHT` float NOT NULL default '0',
  `GMT` float NOT NULL default '0',
  `STATE` varchar(120) NOT NULL default '',
  `COUNTRY` varchar(120) default NULL,
  PRIMARY KEY  (`ID`),
  KEY `STATE` (`STATE`),
  KEY `COUNTRY` (`COUNTRY`),
  KEY `NAME` (`NAME`),
  KEY `CODE` (`CODE`)
) ENGINE=MyISAM AUTO_INCREMENT=1375 DEFAULT CHARSET=latin1;

/*Table structure for table `loginlogs` */

DROP TABLE IF EXISTS `loginlogs`;

CREATE TABLE `loginlogs` (
  `idno` bigint(20) NOT NULL auto_increment,
  `userid` varchar(75) default NULL,
  `logindate` datetime default NULL,
  PRIMARY KEY  (`idno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `lookupemails` */

DROP TABLE IF EXISTS `lookupemails`;

CREATE TABLE `lookupemails` (
  `ADDRESSEE` varchar(100) NOT NULL default '',
  `EmailAddr` varchar(100) default NULL,
  PRIMARY KEY  (`ADDRESSEE`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Table structure for table `lookupsvrs` */

DROP TABLE IF EXISTS `lookupsvrs`;

CREATE TABLE `lookupsvrs` (
  `domainname` varchar(75) NOT NULL default '',
  `serverip` varchar(75) default NULL,
  PRIMARY KEY  (`domainname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Table structure for table `messages` */

DROP TABLE IF EXISTS `messages`;

CREATE TABLE `messages` (
  `idno` bigint(20) NOT NULL auto_increment,
  `fromid` varchar(65) default NULL,
  `toid` varchar(65) default NULL,
  `type` int(11) default NULL,
  `msg` longblob,
  `grpid` varchar(80) default NULL,
  `status` varchar(10) default 'NEW',
  `tarikh` datetime default NULL,
  `atxt` varchar(200) default NULL,
  PRIMARY KEY  (`idno`),
  KEY `fromid` (`fromid`),
  KEY `toid` (`toid`),
  KEY `status` (`status`),
  KEY `dateaction` (`tarikh`),
  KEY `type` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `news` */

DROP TABLE IF EXISTS `news`;

CREATE TABLE `news` (
  `IDNews` int(8) NOT NULL auto_increment,
  `News` text,
  `NDate` datetime default NULL,
  `Sender` varchar(255) default NULL,
  `SNews` varchar(255) default NULL,
  `NStatus` varchar(20) default NULL,
  PRIMARY KEY  (`IDNews`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Table structure for table `outbox` */

DROP TABLE IF EXISTS `outbox`;

CREATE TABLE `outbox` (
  `IDNO` int(11) NOT NULL auto_increment,
  `PhoneNo` varchar(35) default NULL,
  `AStatus` varchar(35) default NULL,
  `TxtMsg` text,
  `ADate` datetime default NULL,
  `SendDate` datetime default NULL,
  `sendby` varchar(45) default NULL,
  `replytoid` int(11) default NULL,
  `StatusReply` varchar(50) default NULL,
  `AName` varchar(120) default NULL,
  `isPersonal` varchar(5) default 'F',
  `owner` varchar(75) default 'abakar',
  `smsnumber` varchar(35) default NULL,
  `scheduleid` int(11) default NULL,
  `draftedby` varchar(75) default NULL,
  PRIMARY KEY  (`IDNO`),
  KEY `astatus` (`AStatus`),
  KEY `adate` (`ADate`),
  KEY `sendby` (`sendby`),
  KEY `owner` (`owner`),
  KEY `smsnumber` (`smsnumber`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `pbt` */

DROP TABLE IF EXISTS `pbt`;

CREATE TABLE `pbt` (
  `idno` int(11) NOT NULL auto_increment,
  `pbtcode` varchar(75) default NULL,
  `pbtname` varchar(100) default NULL,
  `state` varchar(73) default NULL,
  `latitude` float default '3.133',
  `longitude` float default '101.7',
  `height` float default '0',
  `gmt` float default '8',
  PRIMARY KEY  (`idno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `personalphotos` */

DROP TABLE IF EXISTS `personalphotos`;

CREATE TABLE `personalphotos` (
  `idno` bigint(20) NOT NULL auto_increment,
  `userid` varchar(75) default NULL,
  `tarikh` datetime default NULL,
  `fileloc` varchar(150) default NULL,
  `filethumb` varchar(200) default NULL,
  PRIMARY KEY  (`idno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `phonealias` */

DROP TABLE IF EXISTS `phonealias`;

CREATE TABLE `phonealias` (
  `phoneno` varchar(75) NOT NULL,
  `phonealias` varchar(75) default NULL,
  PRIMARY KEY  (`phoneno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `photoalbum` */

DROP TABLE IF EXISTS `photoalbum`;

CREATE TABLE `photoalbum` (
  `idno` bigint(20) NOT NULL auto_increment,
  `userid` varchar(75) default NULL,
  `albumname` varchar(100) default NULL,
  `desc` varchar(150) default NULL,
  `tarikh` datetime default NULL,
  PRIMARY KEY  (`idno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `photos` */

DROP TABLE IF EXISTS `photos`;

CREATE TABLE `photos` (
  `idni` bigint(20) NOT NULL auto_increment,
  `albumid` bigint(20) default NULL,
  `fileloc` varchar(200) default NULL,
  `tarikh` datetime default NULL,
  PRIMARY KEY  (`idni`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `prj_branch` */

DROP TABLE IF EXISTS `prj_branch`;

CREATE TABLE `prj_branch` (
  `idno` int(11) NOT NULL auto_increment,
  `branchcode` varchar(75) default NULL,
  `branchname` varchar(125) default NULL,
  PRIMARY KEY  (`idno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `prj_category` */

DROP TABLE IF EXISTS `prj_category`;

CREATE TABLE `prj_category` (
  `idno` int(11) NOT NULL auto_increment,
  `categoryid` varchar(75) default NULL,
  `cat_desc` varchar(125) default NULL,
  PRIMARY KEY  (`idno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `prj_costing` */

DROP TABLE IF EXISTS `prj_costing`;

CREATE TABLE `prj_costing` (
  `ID` int(11) NOT NULL auto_increment,
  `UserName` varchar(25) default NULL,
  `ProjCode` int(11) default NULL,
  `Tarikh` double default NULL,
  `Jenis` int(11) default NULL,
  `Description` text,
  `Item` text,
  `Quantity` double default NULL,
  `Total` double default NULL,
  `SupplierID` int(11) default '-1',
  `ReferenceNo` varchar(255) default NULL,
  `Status` int(11) default '0',
  `TarikhTerima` double default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=1202 DEFAULT CHARSET=latin1;

/*Table structure for table `prj_departments` */

DROP TABLE IF EXISTS `prj_departments`;

CREATE TABLE `prj_departments` (
  `ID` bigint(11) NOT NULL auto_increment,
  `DEPARTMENT` varchar(255) NOT NULL default '',
  `GROUPS` varchar(255) NOT NULL default '',
  `STATUS` int(1) NOT NULL default '1',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

/*Table structure for table `prj_groups` */

DROP TABLE IF EXISTS `prj_groups`;

CREATE TABLE `prj_groups` (
  `ID` bigint(11) NOT NULL auto_increment,
  `IDPRJ` varchar(255) NOT NULL default '',
  `GROUPNAME` varchar(255) NOT NULL default '',
  `STATUS` int(1) NOT NULL default '1',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;

/*Table structure for table `prj_history` */

DROP TABLE IF EXISTS `prj_history`;

CREATE TABLE `prj_history` (
  `ID` bigint(20) NOT NULL auto_increment,
  `TASKID` int(11) default NULL,
  `DATE` double default NULL,
  `DESCRIPTION` text,
  `STATUS` int(1) NOT NULL default '1',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Table structure for table `prj_meetings` */

DROP TABLE IF EXISTS `prj_meetings`;

CREATE TABLE `prj_meetings` (
  `ID` bigint(11) NOT NULL auto_increment,
  `DEPARTMENT` varchar(255) NOT NULL default '',
  `STARTTIME` datetime NOT NULL default '0000-00-00 00:00:00',
  `ENDTIME` datetime NOT NULL default '0000-00-00 00:00:00',
  `VANUE` varchar(255) NOT NULL default '',
  `CHAIRMAN` varchar(255) NOT NULL default '',
  `SECRETARY` varchar(255) NOT NULL default '',
  `ATTENDANCE` text,
  `ABSENCE` text,
  `WELCOMINGADDR` text,
  `STATUS` int(1) NOT NULL default '1',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

/*Table structure for table `prj_notes` */

DROP TABLE IF EXISTS `prj_notes`;

CREATE TABLE `prj_notes` (
  `ID` bigint(11) NOT NULL auto_increment,
  `PRJID` bigint(11) NOT NULL default '0',
  `MINUTESMEETING` bigint(11) NOT NULL default '0',
  `SUBJECT` varchar(255) default NULL,
  `DESCRIPTION` text,
  `STATUS` int(1) NOT NULL default '1',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;

/*Table structure for table `prj_othersmatter` */

DROP TABLE IF EXISTS `prj_othersmatter`;

CREATE TABLE `prj_othersmatter` (
  `ID` bigint(11) NOT NULL auto_increment,
  `MEETINGID` bigint(11) NOT NULL default '0',
  `PERSON` varchar(255) NOT NULL default '',
  `DESCRIPTION` text,
  `STATUS` int(1) NOT NULL default '1',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

/*Table structure for table `prj_pass` */

DROP TABLE IF EXISTS `prj_pass`;

CREATE TABLE `prj_pass` (
  `id` int(11) NOT NULL default '0',
  `password` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Table structure for table `prj_paytype` */

DROP TABLE IF EXISTS `prj_paytype`;

CREATE TABLE `prj_paytype` (
  `idno` int(11) NOT NULL auto_increment,
  `paymentcode` varchar(75) default NULL,
  `paydesc` varchar(125) default NULL,
  PRIMARY KEY  (`idno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `prj_priority` */

DROP TABLE IF EXISTS `prj_priority`;

CREATE TABLE `prj_priority` (
  `ID` bigint(11) NOT NULL auto_increment,
  `PRIORITY` varchar(255) NOT NULL default '',
  `STATUS` int(1) NOT NULL default '1',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

/*Table structure for table `prj_projects` */

DROP TABLE IF EXISTS `prj_projects`;

CREATE TABLE `prj_projects` (
  `ID` bigint(11) NOT NULL auto_increment,
  `PRJGROUP` varchar(255) NOT NULL default '',
  `SIRI` int(3) unsigned zerofill NOT NULL default '000',
  `PRJNAME` varchar(255) NOT NULL default '',
  `PRJDESCRIPTION` tinytext,
  `PRJVALUE` float default NULL,
  `WARRANTY_DUE` float default NULL,
  `STATUS` int(1) NOT NULL default '1',
  `PRJDATE` datetime default NULL,
  `CATEGORY` varchar(75) default NULL,
  `DELIVERYDATE` datetime default NULL,
  `PREPAREDBY` varchar(75) default NULL,
  `VENDORID` varchar(35) default NULL,
  `REMARKS` text,
  `FILENAME` varchar(75) default NULL,
  `FILEPATH` varchar(200) default NULL,
  `BRANCH` varchar(75) default NULL,
  `REFNO` varchar(75) default NULL,
  `projstatus` varchar(35) default NULL,
  `insert_date` datetime default NULL,
  PRIMARY KEY  (`ID`),
  KEY `STATUS` (`STATUS`),
  KEY `CATEGORY` (`CATEGORY`)
) ENGINE=MyISAM AUTO_INCREMENT=445 DEFAULT CHARSET=latin1;

/*Table structure for table `prj_purchasenotes` */

DROP TABLE IF EXISTS `prj_purchasenotes`;

CREATE TABLE `prj_purchasenotes` (
  `ID` int(11) NOT NULL auto_increment,
  `IDRequest` int(11) default NULL,
  `Tarikh` double default NULL,
  `Notes` text,
  `UserName` varchar(25) default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

/*Table structure for table `prj_requestpurchase` */

DROP TABLE IF EXISTS `prj_requestpurchase`;

CREATE TABLE `prj_requestpurchase` (
  `ID` int(11) NOT NULL auto_increment,
  `UserName` varchar(25) default NULL,
  `ProjCode` int(11) default NULL,
  `Tarikh` double default NULL,
  `Jenis` int(11) default NULL,
  `Description` text,
  `Item` text,
  `Quantity` double default NULL,
  `Total` double default NULL,
  `SupplierID` int(11) default NULL,
  `ReferenceNo` varchar(255) default NULL,
  `Status` int(11) default '0',
  `IDMain` int(11) default '-1',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=181 DEFAULT CHARSET=latin1;

/*Table structure for table `prj_supplier` */

DROP TABLE IF EXISTS `prj_supplier`;

CREATE TABLE `prj_supplier` (
  `ID` int(11) NOT NULL auto_increment,
  `SupplierNo` varchar(20) default NULL,
  `SupplierName` varchar(255) default NULL,
  `Phone` varchar(20) default NULL,
  `Faks` varchar(20) default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=92 DEFAULT CHARSET=latin1;

/*Table structure for table `prj_tasks` */

DROP TABLE IF EXISTS `prj_tasks`;

CREATE TABLE `prj_tasks` (
  `ID` bigint(11) NOT NULL auto_increment,
  `PRJID` bigint(11) NOT NULL default '0',
  `MINUTESMEETING` bigint(11) NOT NULL default '0',
  `SUBJECT` varchar(255) NOT NULL default '',
  `DESCRIPTION` text,
  `DUEDATE` double NOT NULL default '0',
  `COMPLETEDDATE` double NOT NULL default '0',
  `PRIORITY` int(2) default NULL,
  `PERCENTAGE` int(3) NOT NULL default '0',
  `TASKSTATUS` int(2) default NULL,
  `TASKCREATEDBY` varchar(255) default NULL,
  `TASKCREATEDON` double NOT NULL default '0',
  `INCHARGE` varchar(255) default NULL,
  `STATUS` int(1) NOT NULL default '1',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

/*Table structure for table `prj_tasks_status` */

DROP TABLE IF EXISTS `prj_tasks_status`;

CREATE TABLE `prj_tasks_status` (
  `ID` bigint(11) NOT NULL auto_increment,
  `TASKSTATUS` varchar(255) NOT NULL default '',
  `STATUS` int(1) NOT NULL default '1',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

/*Table structure for table `prj_users` */

DROP TABLE IF EXISTS `prj_users`;

CREATE TABLE `prj_users` (
  `ID` int(11) NOT NULL auto_increment,
  `CardID` varchar(20) default NULL,
  `name` varchar(60) NOT NULL default '',
  `username` varchar(25) default NULL,
  `user_level` int(10) default '3',
  `department` int(11) default NULL,
  `claimauthorize` int(11) default '0',
  `jawatan` varchar(75) default NULL,
  `email` varchar(100) default NULL,
  `status` int(11) default NULL,
  `limitkm` double default '0',
  `user_access` int(11) default NULL,
  PRIMARY KEY  (`ID`),
  KEY `username` (`username`),
  KEY `user_level` (`user_level`)
) ENGINE=MyISAM AUTO_INCREMENT=44 DEFAULT CHARSET=latin1;

/*Table structure for table `products` */

DROP TABLE IF EXISTS `products`;

CREATE TABLE `products` (
  `PID` bigint(20) NOT NULL auto_increment,
  `ProductName` varchar(200) default NULL,
  PRIMARY KEY  (`PID`)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;

/*Table structure for table `purchaseorder` */

DROP TABLE IF EXISTS `purchaseorder`;

CREATE TABLE `purchaseorder` (
  `idno` int(11) NOT NULL auto_increment,
  `refno` varchar(75) default NULL,
  `projid` varchar(35) default NULL,
  `adesc` varchar(200) default NULL,
  `amount` double default NULL,
  `podate` date default NULL,
  `deliverydate` date default NULL,
  `category` varchar(75) default NULL,
  `vendorid` varchar(15) default NULL,
  `remarks` text,
  `status` varchar(20) default NULL,
  `preparedby` varchar(75) default NULL,
  `filename` varchar(75) default NULL,
  `filepath` varchar(200) default NULL,
  `branch` varchar(75) default NULL,
  PRIMARY KEY  (`idno`),
  KEY `refno` (`podate`),
  KEY `projfromid` (`vendorid`),
  KEY `status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `replybox` */

DROP TABLE IF EXISTS `replybox`;

CREATE TABLE `replybox` (
  `IDNO` bigint(20) NOT NULL auto_increment,
  `AName` varchar(255) default NULL,
  `PhoneNo` varchar(255) default NULL,
  `SendDate` datetime default NULL,
  `TxtMsg` text,
  `AStatus` varchar(255) default NULL,
  `sendby` varchar(75) default NULL,
  `owner` varchar(75) default 'abakar',
  `Lock` int(11) default NULL,
  PRIMARY KEY  (`IDNO`),
  KEY `sendby` (`sendby`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `reports` */

DROP TABLE IF EXISTS `reports`;

CREATE TABLE `reports` (
  `IDNO` int(11) NOT NULL auto_increment,
  `TARIKH` date default NULL,
  `Subject` varchar(100) NOT NULL default '',
  `DESCRIPTION` text NOT NULL,
  `REPORTBY` varchar(65) NOT NULL default '',
  `MASA` time default NULL,
  `IDMemoTypes` int(11) NOT NULL default '0',
  `IDReply` int(11) default '0',
  `FACE` int(11) NOT NULL default '1',
  `reads` int(11) default '0',
  `flag` int(1) default '0',
  PRIMARY KEY  (`IDNO`),
  KEY `REPORTBY` (`REPORTBY`),
  KEY `IDMemoTypes` (`IDMemoTypes`),
  KEY `Subject` (`Subject`),
  KEY `IDReply` (`IDReply`)
) ENGINE=MyISAM AUTO_INCREMENT=2671 DEFAULT CHARSET=latin1;

/*Table structure for table `reports_guest` */

DROP TABLE IF EXISTS `reports_guest`;

CREATE TABLE `reports_guest` (
  `IDNO` int(11) NOT NULL auto_increment,
  `TARIKH` date default NULL,
  `Subject` varchar(100) NOT NULL default '',
  `DESCRIPTION` text NOT NULL,
  `REPORTBY` varchar(65) NOT NULL default '',
  `MASA` time default NULL,
  `IDMemoTypes` int(11) NOT NULL default '0',
  `IDReply` int(11) default '0',
  `FACE` int(11) NOT NULL default '1',
  `reads` int(11) default '0',
  `flag` int(1) default '0',
  PRIMARY KEY  (`IDNO`),
  KEY `REPORTBY` (`REPORTBY`),
  KEY `IDMemoTypes` (`IDMemoTypes`),
  KEY `Subject` (`Subject`),
  KEY `IDReply` (`IDReply`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;

/*Table structure for table `rooms` */

DROP TABLE IF EXISTS `rooms`;

CREATE TABLE `rooms` (
  `NAME` varchar(200) NOT NULL default '',
  `MAXIMUM` int(11) default '40',
  `LISTEN` int(11) default NULL,
  `SPEAK` int(11) default NULL,
  `OWNER` varchar(100) default NULL,
  `DESCRIPTION` varchar(250) default NULL,
  `SERVERNAME` varchar(100) default NULL,
  `Status` varchar(100) default NULL,
  PRIMARY KEY  (`NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Table structure for table `securitycode` */

DROP TABLE IF EXISTS `securitycode`;

CREATE TABLE `securitycode` (
  `id` int(11) NOT NULL auto_increment,
  `code` varchar(10) default NULL,
  `scode` varchar(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `sendbox` */

DROP TABLE IF EXISTS `sendbox`;

CREATE TABLE `sendbox` (
  `IDNO` int(11) NOT NULL auto_increment,
  `PhoneNo` varchar(35) default NULL,
  `TxtMsg` text,
  `SendDate` datetime default NULL,
  `sendby` varchar(75) default NULL,
  `AStatus` varchar(35) default NULL,
  `ADate` datetime default NULL,
  `StatusReply` varchar(35) default NULL,
  `AName` varchar(120) default NULL,
  `rowId` int(11) default NULL,
  `replytoid` varchar(35) default NULL,
  `owner` varchar(75) default 'abakar',
  `Lock` int(11) default NULL,
  `draftedby` varchar(75) default NULL,
  PRIMARY KEY  (`IDNO`),
  KEY `sendby` (`sendby`),
  KEY `owner` (`owner`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `serialno` */

DROP TABLE IF EXISTS `serialno`;

CREATE TABLE `serialno` (
  `strid` varchar(35) NOT NULL,
  `serialno` bigint(20) default NULL,
  PRIMARY KEY  (`strid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `signatories` */

DROP TABLE IF EXISTS `signatories`;

CREATE TABLE `signatories` (
  `idno` int(11) NOT NULL auto_increment,
  `accountno` varchar(100) default NULL,
  `userid` varchar(100) default NULL,
  PRIMARY KEY  (`idno`),
  KEY `accountno` (`accountno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `sms_expiredate` */

DROP TABLE IF EXISTS `sms_expiredate`;

CREATE TABLE `sms_expiredate` (
  `idno` bigint(20) NOT NULL auto_increment,
  `idstr` varchar(35) default NULL,
  `expireddate` datetime default NULL,
  `sentstatus` varchar(25) default NULL,
  PRIMARY KEY  (`idno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `sms_schedule` */

DROP TABLE IF EXISTS `sms_schedule`;

CREATE TABLE `sms_schedule` (
  `idno` bigint(20) NOT NULL auto_increment,
  `tarikh` datetime default NULL,
  `astatus` varchar(15) default 'NEW',
  PRIMARY KEY  (`idno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `smscodes` */

DROP TABLE IF EXISTS `smscodes`;

CREATE TABLE `smscodes` (
  `ID` bigint(20) NOT NULL auto_increment,
  `smscode` varchar(35) default NULL,
  `userid` varchar(75) default NULL,
  `smsnumber` varchar(25) default NULL,
  PRIMARY KEY  (`ID`),
  KEY `smscode` (`smscode`),
  KEY `userid` (`userid`),
  KEY `smsnumber` (`smsnumber`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `smsmembers` */

DROP TABLE IF EXISTS `smsmembers`;

CREATE TABLE `smsmembers` (
  `idno` bigint(20) NOT NULL auto_increment,
  `userid` varchar(75) default NULL,
  `smsowner` varchar(75) default NULL,
  `templatexp` longblob,
  `status` varchar(10) default 'ACTIVE',
  `smscode` varchar(10) default NULL,
  `currentcredit` float default '0',
  `chargepersms` float default '0.25',
  `unlimited` varchar(5) default 'No',
  `smsintrate` float default '0.75',
  `sharedid` varchar(75) default NULL,
  PRIMARY KEY  (`idno`),
  KEY `userid` (`userid`),
  KEY `smscode` (`smscode`),
  KEY `smsowner` (`smsowner`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `smsowners` */

DROP TABLE IF EXISTS `smsowners`;

CREATE TABLE `smsowners` (
  `idno` bigint(20) NOT NULL auto_increment,
  `userid` varchar(75) default NULL,
  `phoneno` varchar(35) default NULL,
  `telco` varchar(45) default NULL,
  `status` varchar(75) default NULL,
  `hdkey` varchar(100) default NULL,
  `mainowner` varchar(75) default NULL,
  PRIMARY KEY  (`idno`),
  KEY `userid` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `statusupdates` */

DROP TABLE IF EXISTS `statusupdates`;

CREATE TABLE `statusupdates` (
  `idno` bigint(20) NOT NULL auto_increment,
  `userid` varchar(75) default NULL,
  `comment` varchar(200) default NULL,
  `tarikh` datetime default NULL,
  PRIMARY KEY  (`idno`),
  KEY `insert_date` (`tarikh`),
  KEY `userid` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `templates` */

DROP TABLE IF EXISTS `templates`;

CREATE TABLE `templates` (
  `ID` int(11) NOT NULL auto_increment,
  `TemplateName` varchar(50) default NULL,
  `Templates` varchar(255) default NULL,
  `Owner` varchar(120) default NULL,
  `Share` varchar(5) default 'No',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

/*Table structure for table `testimonial` */

DROP TABLE IF EXISTS `testimonial`;

CREATE TABLE `testimonial` (
  `IDTestimonial` int(11) NOT NULL auto_increment,
  `Title` varchar(255) default NULL,
  `Content` text,
  `UserID` varchar(50) default NULL,
  `Email` varchar(255) default NULL,
  `DateInsert` datetime default NULL,
  `sContent` varchar(255) default NULL,
  PRIMARY KEY  (`IDTestimonial`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

/*Table structure for table `topups` */

DROP TABLE IF EXISTS `topups`;

CREATE TABLE `topups` (
  `IDNO` bigint(20) NOT NULL auto_increment,
  `userid` varchar(75) default NULL,
  `amount` float default NULL,
  `adate` datetime default NULL,
  `astatus` varchar(25) default NULL,
  `aref` varchar(50) default NULL,
  `action` varchar(50) default 'topup',
  `Telco` varchar(50) default NULL,
  `smsnumber` varchar(25) default NULL,
  PRIMARY KEY  (`IDNO`),
  KEY `astatus` (`astatus`),
  KEY `smsnumber` (`smsnumber`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `transactions` */

DROP TABLE IF EXISTS `transactions`;

CREATE TABLE `transactions` (
  `idno` int(11) NOT NULL,
  `accountno` varchar(50) default NULL,
  `draftedby` varchar(75) default NULL,
  `tarikh` datetime default NULL,
  `adesc` varchar(150) default NULL,
  `atransaction` varchar(70) default NULL,
  `amount` double default NULL,
  PRIMARY KEY  (`idno`),
  KEY `accountno` (`accountno`),
  KEY `tarikh` (`tarikh`),
  KEY `atransaction` (`atransaction`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `txtsettings` */

DROP TABLE IF EXISTS `txtsettings`;

CREATE TABLE `txtsettings` (
  `idno` int(11) NOT NULL auto_increment,
  `userid` varchar(95) default NULL,
  `cmd` varchar(95) default NULL,
  `atext` varchar(165) default NULL,
  PRIMARY KEY  (`idno`),
  KEY `userid` (`userid`),
  KEY `cmd` (`cmd`)
) ENGINE=MyISAM AUTO_INCREMENT=1126 DEFAULT CHARSET=latin1;

/*Table structure for table `unsendbox` */

DROP TABLE IF EXISTS `unsendbox`;

CREATE TABLE `unsendbox` (
  `IDNO` int(11) NOT NULL auto_increment,
  `PhoneNo` varchar(35) default NULL,
  `TxtMsg` text,
  `SendDate` datetime default NULL,
  `sendby` varchar(75) default NULL,
  `AStatus` varchar(35) default NULL,
  `ADate` datetime default NULL,
  `StatusReply` varchar(35) default NULL,
  `AName` varchar(120) default NULL,
  `rowId` int(11) default NULL,
  `replytoid` varchar(35) default NULL,
  `owner` varchar(75) default 'abakar',
  `Lock` int(11) default NULL,
  `smsnumber` varchar(25) default NULL,
  `draftedby` varchar(75) default NULL,
  PRIMARY KEY  (`IDNO`),
  KEY `owner` (`owner`),
  KEY `smsnumber` (`smsnumber`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `user_group` */

DROP TABLE IF EXISTS `user_group`;

CREATE TABLE `user_group` (
  `idno` int(11) NOT NULL auto_increment,
  `GroupName` varchar(75) default NULL,
  `ACCESS` int(11) default NULL,
  `ACCESS2` int(11) default NULL,
  PRIMARY KEY  (`idno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `userlist` */

DROP TABLE IF EXISTS `userlist`;

CREATE TABLE `userlist` (
  `idno` int(11) NOT NULL auto_increment,
  `Name` varchar(125) default NULL,
  `CompanyName` varchar(100) default NULL,
  `CompAddr1` varchar(125) default NULL,
  `CompAddr2` varchar(125) default NULL,
  `ContactNo` varchar(30) default NULL,
  `FaxNo` varchar(30) default NULL,
  `MobileNo` varchar(30) default NULL,
  `EmailAddr` varchar(100) default NULL,
  `Position` varchar(100) default NULL,
  `UlrAddr` varchar(175) default NULL,
  `EnteredBy` varchar(100) default NULL,
  `namecard` blob,
  `backnamecard` blob,
  `description` text,
  `imagename` varchar(150) default NULL,
  `Status` varchar(20) default 'PERSONAL',
  `InsertDate` datetime default NULL,
  `ModifyDate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`idno`),
  KEY `Name` (`Name`),
  KEY `CompanyName` (`CompanyName`),
  KEY `Status` (`Status`)
) ENGINE=MyISAM AUTO_INCREMENT=198 DEFAULT CHARSET=latin1;

/*Table structure for table `users` */

DROP TABLE IF EXISTS `users`;

CREATE TABLE `users` (
  `uid` bigint(20) NOT NULL auto_increment,
  `userid` varchar(255) default NULL,
  `name` varchar(255) default NULL,
  `email` varchar(255) default NULL,
  `SessionID` varchar(255) default NULL,
  `StatusOnline` varchar(255) default NULL,
  `SessionTime` varchar(255) default NULL,
  `Lastvisit` datetime default NULL,
  `Status` varchar(50) default 'AKTIF',
  `UserGroup` varchar(100) default NULL,
  `CurrentCredit` float default NULL,
  `CreditPerSMS` float default '0.08',
  `smscode` varchar(25) default NULL,
  `type` int(11) default '0',
  `displayname` varchar(160) default NULL,
  `hashpassword` varchar(75) default '202cb962ac59075b964b07152d234b70',
  `password` varchar(75) default NULL,
  `useridstatus` varchar(25) default NULL,
  `Jabatan` varchar(25) default NULL,
  `eonline` varchar(75) default NULL,
  `room` varchar(45) default NULL,
  `online` varchar(25) default NULL,
  `version` varchar(15) default NULL,
  `lsize` double default NULL,
  `emailaktif` varchar(25) default NULL,
  `logindate` datetime default NULL,
  `wonline` varchar(75) default NULL,
  `domain` varchar(35) default NULL,
  `pangkat` varchar(25) default NULL,
  `clienttype` int(11) default NULL,
  `jawatan` varchar(25) default NULL,
  `accesszone` varchar(200) default NULL,
  `user_group` varchar(75) default NULL,
  `unlimited` varchar(10) default 'No',
  `mobileno` varchar(25) default NULL,
  `avatar` longblob,
  `avatar_type` varchar(100) default NULL,
  `signature` text,
  `user_level` int(11) default NULL,
  `flag_login` int(1) default NULL,
  `GlobalAddrAccess` varchar(5) default 'No',
  `AllowPublicAccess` varchar(5) default 'No',
  `DraftNew` varchar(5) default 'Yes',
  `SMSIntRate` float default '0.3',
  `ChequeMSAccess` int(11) default NULL,
  `SMSNumber` varchar(25) default NULL,
  `designation` smallint(3) default NULL,
  `dbname` varchar(75) default NULL,
  `SMSOwner` varchar(75) default NULL,
  `birthdate` datetime default NULL,
  `sex` int(11) default NULL,
  `LoginEmail` varchar(10) default 'No',
  `imgext` varchar(10) default NULL,
  `defpbt` varchar(75) default NULL,
  `defgroup` varchar(75) default 'mygroup',
  `stranger_profile_access` int(11) default '0',
  `friend_only_profile_access` int(11) default '1',
  `display_birth_date` int(11) default '0',
  `birthdate_disp_month_day` int(11) default '1',
  `access_2_myfriend` int(11) default '1',
  `display_mobile_no` int(11) default '0',
  `tarikh` datetime default NULL,
  `fileloc` varchar(200) default NULL,
  `fileid` int(11) default '1',
  `thumbfile` varchar(150) default NULL,
  `points` int(11) default '0',
  `createby` varchar(75) default NULL,
  PRIMARY KEY  (`uid`),
  KEY `email` (`email`),
  KEY `userid` (`userid`),
  KEY `tarikh` (`tarikh`),
  KEY `useridstatus` (`useridstatus`)
) ENGINE=MyISAM AUTO_INCREMENT=250 DEFAULT CHARSET=latin1;

/*Table structure for table `vouchers` */

DROP TABLE IF EXISTS `vouchers`;

CREATE TABLE `vouchers` (
  `idno` int(11) NOT NULL,
  `payeeid` varchar(15) default NULL,
  `payeename` varchar(150) default NULL,
  `addr1` varchar(200) default NULL,
  `addr2` varchar(200) default NULL,
  `date_issue` date default NULL,
  `amount` double default NULL,
  `preparedby` varchar(75) default NULL,
  `verifiedby` varchar(75) default NULL,
  `approvedby` varchar(75) default NULL,
  `paymethod` varchar(25) default NULL,
  `adesc` text,
  `status` varchar(15) default 'NEW',
  `chequeno` int(11) default NULL,
  `accountno` varchar(25) default NULL,
  `remarks` text,
  `transactionid` varchar(25) default NULL,
  PRIMARY KEY  (`idno`),
  KEY `date_issue` (`date_issue`),
  KEY `status` (`status`),
  KEY `paymethod` (`paymethod`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

insert into `users` (`userid`,`name`,`email`,`SessionID`,`StatusOnline`,`SessionTime`,`Lastvisit`,`Status`,`UserGroup`,`CurrentCredit`,`CreditPerSMS`,`smscode`,`type`,`displayname`,`hashpassword`,`password`,`useridstatus`,`Jabatan`,`eonline`,`room`,`online`,`version`,`lsize`,`emailaktif`,`logindate`,`wonline`,`domain`,`pangkat`,`clienttype`,`jawatan`,`accesszone`,`user_group`,`unlimited`,`mobileno`,`avatar`,`avatar_type`,`signature`,`user_level`,`flag_login`,`GlobalAddrAccess`,`AllowPublicAccess`,`DraftNew`,`SMSIntRate`,`ChequeMSAccess`,`SMSNumber`,`designation`,`dbname`,`SMSOwner`,`birthdate`,`sex`,`LoginEmail`,`imgext`,`defpbt`,`defgroup`,`stranger_profile_access`,`friend_only_profile_access`,`display_birth_date`,`birthdate_disp_month_day`,`access_2_myfriend`,`display_mobile_no`,`tarikh`,`fileloc`,`fileid`,`thumbfile`,`points`,`createby`) values ('admin','Administrator','','59B54720C0EEE00EB7BFB2E0B9E8D254','ONLINE','1237362899','2008-10-23 23:44:26','AKTIF','ADMIN',199.92,0.15,'ad',3,NULL,'202cb962ac59075b964b07152d234b70',NULL,'Away!',NULL,'59B54720C0EEE00EB7BFB2E0B9E8D254','','ONLINE','2.6.0.32',0,'AKTIF','2009-03-18 09:22:34',NULL,'',NULL,NULL,NULL,'','','No','',NULL,NULL,NULL,NULL,NULL,'No','Yes','Yes',0.3,NULL,NULL,NULL,'vssuser','admin','0000-00-00 00:00:00',1,'YES',NULL,'WPPJ','mygroup',0,1,0,1,1,0,NULL,NULL,2,NULL,14,NULL);
insert into `prj_users` (`CardID`,`name`,`username`,`user_level`,`department`,`claimauthorize`,`jawatan`,`email`,`status`,`limitkm`,`user_access`) values (NULL,'','admin',1,NULL,0,NULL,NULL,NULL,0,16383);