7SgUCv14

1-- Adminer 4.2.1 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8CREATE DATABASE `ssm_robowner_14052016` /*!40100 DEFAULT CHARACTER SET latin1 */;
9USE `ssm_robowner_14052016`;
10
11DROP TABLE IF EXISTS `robowner`;
12CREATE TABLE `robowner` (
13  `srlowneridkeycode` int(8) NOT NULL DEFAULT '0',
14  `intapplicationid` int(8) NOT NULL DEFAULT '0',
15  `vchname` varchar(50) NOT NULL DEFAULT '',
16  `chrgender` char(1) NOT NULL DEFAULT '',
17  `vchidcardnumber` varchar(15) NOT NULL DEFAULT '',
18  `chridcardtype` char(1) NOT NULL DEFAULT '',
19  `chrcolor` char(1) NOT NULL DEFAULT '',
20  `vchothercolor` varchar(255) NOT NULL DEFAULT '',
21  `vchnewicnumber` varchar(12) NOT NULL DEFAULT '',
22  `dtdateofbirth` date NOT NULL DEFAULT '0000-00-00',
23  `vchaddress` varchar(70) NOT NULL DEFAULT '',
24  `vchtown` varchar(20) NOT NULL DEFAULT '',
25  `vchpostcode` varchar(5) NOT NULL DEFAULT '',
26  `chrstate` char(1) NOT NULL DEFAULT '',
27  `vchemail` varchar(255) NOT NULL DEFAULT '',
28  `vchremailnotify` char(1) NOT NULL DEFAULT '',
29  `chrrace` char(1) NOT NULL DEFAULT '',
30  `vchotherace` varchar(255) NOT NULL DEFAULT '',
31  `vchnationality` char(3) NOT NULL DEFAULT '',
32  `vchorigincountry` varchar(255) NOT NULL DEFAULT '',
33  `chrownership` char(1) NOT NULL DEFAULT '',
34  `chrstatus` char(1) NOT NULL DEFAULT '',
35  `vchownerctr` char(2) NOT NULL DEFAULT '',
36  `chrownerblacklistedind` tinyint(1) NOT NULL DEFAULT '0',
37  `vchcreateby` varchar(10) NOT NULL DEFAULT '',
38  `dtcreatedate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
39  `vchupdateby` varchar(10) NOT NULL DEFAULT '',
40  `dtupdatedate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
41  `vchtelno` varchar(11) NOT NULL,
42  `vchtelno1` varchar(11) NOT NULL,
43  `vchaddress1` varchar(255) NOT NULL DEFAULT '',
44  `vchaddress2` varchar(255) NOT NULL DEFAULT '',
45  PRIMARY KEY (`srlowneridkeycode`),
46  KEY `vchidcardnumber` (`vchidcardnumber`),
47  KEY `vchnewicnumber` (`vchnewicnumber`),
48  FULLTEXT KEY `NewIndex1` (`vchname`)
49) ENGINE=MyISAM DEFAULT CHARSET=latin1;
50
51INSERT INTO `robowner` (`srlowneridkeycode`, `intapplicationid`, `vchname`, `chrgender`, `vchidcardnumber`, `chridcardtype`, `chrcolor`, `vchothercolor`, `vchnewicnumber`, `dtdateofbirth`, `vchaddress`, `vchtown`, `vchpostcode`, `chrstate`, `vchemail`, `vchremailnotify`, `chrrace`, `vchotherace`, `vchnationality`, `vchorigincountry`, `chrownership`, `chrstatus`, `vchownerctr`, `chrownerblacklistedind`, `vchcreateby`, `dtcreatedate`, `vchupdateby`, `dtupdatedate`, `vchtelno`, `vchtelno1`, `vchaddress1`, `vchaddress2`) VALUES
52(1,	0,	'GAZALI BIN ABD.RAHMAN',	'',	'',	'K',	'B',	'',	'(KLM)034705',	'1940-12-29',	'NO.409,LORONG ANGGERIK,KEMUNTING JAYA,TAIPING',	'',	'-',	'A',	'',	'',	'M',	' ',	'MAL',	' ',	'',	'A',	'00',	0,	'Admin',	'2004-06-18 16:37:35',	'Admin',	'2004-06-18 16:37:35',	'',	'',	'',	''),
53
54(56896,	0,	'ISMALIZA BINTI ISMAIL',	'P',	' ',	'K',	'B',	'',	'790521146208',	'1979-05-21',	'NO. 49, JALAN DAMAI BUDI, ALAM DAMAI, CHERAS',	'KUALA LUMPUR',	'56000',	'W',	'ZULZBY22003@YAHOO.COM',	'T',	'M',	' ',	'MAL',	' ',	'U',	'A',	'00',	0,	'Admin',	'2004-06-18 16:38:18',	'sitimeriam',	'2010-03-03 14:16:38',	'012-7151766',	'',	'',	''),