/*
Navicat MySQL Data Transfer

Source Server         : 192.168.3.10 Root
Source Server Version : 50712
Source Host           : 192.168.3.10:3306
Source Database       : ram_test

Target Server Type    : MYSQL
Target Server Version : 50712
File Encoding         : 65001

Date: 2018-09-11 11:41:45
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `lastname`
-- ----------------------------
DROP TABLE IF EXISTS `lastname`;
CREATE TABLE `lastname` (
  `lastname` varchar(255) DEFAULT NULL,
  `id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of lastname
-- ----------------------------
INSERT INTO `lastname` VALUES ('Rishan', '1');
INSERT INTO `lastname` VALUES ('Login', '2');

-- ----------------------------
-- Table structure for `test`
-- ----------------------------
DROP TABLE IF EXISTS `test`;
CREATE TABLE `test` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `lastname` int(255) DEFAULT NULL,
  `code` int(255) DEFAULT NULL,
  `timestamp` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=805 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of test
-- ----------------------------
INSERT INTO `test` VALUES ('1', 'Roshan', '1', '1234', null);
INSERT INTO `test` VALUES ('2', 'Rishan', '2', '1234', null);
INSERT INTO `test` VALUES ('3', 'Loginthiren', '2', '753', null);
INSERT INTO `test` VALUES ('4', 'Prakash', '2', '12345', null);
INSERT INTO `test` VALUES ('5', 'Rihanna', '2', '12345', null);
INSERT INTO `test` VALUES ('6', 'Rishanna', '2', '123', null);
INSERT INTO `test` VALUES ('7', 'Roshan', '1', '123', null);
INSERT INTO `test` VALUES ('8', 'Azmin', '1', '123', null);
INSERT INTO `test` VALUES ('9', 'Rohan', '2', '123', null);
INSERT INTO `test` VALUES ('11', 'Rohit', '2', '12345', null);
INSERT INTO `test` VALUES ('12', 'Balaji', '1', '12345', null);
INSERT INTO `test` VALUES ('13', 'Mithun', '2', '1234', null);
INSERT INTO `test` VALUES ('14', 'Ajith Kumar', '2', '12345', null);
INSERT INTO `test` VALUES ('15', 'Krishnan', '1', '7890', null);
INSERT INTO `test` VALUES ('16', 'Roger', '2', '7890', null);
INSERT INTO `test` VALUES ('17', 'Azminah', '1', '7890', null);
INSERT INTO `test` VALUES ('18', 'Name', '2', '12345', null);
INSERT INTO `test` VALUES ('19', 'Ricky', '2', '1234567', null);
INSERT INTO `test` VALUES ('21', 'Selvi', '2', '3456', null);
INSERT INTO `test` VALUES ('22', 'Edgar', '2', '123', null);
INSERT INTO `test` VALUES ('24', 'User', '2', '123', null);
INSERT INTO `test` VALUES ('25', 'Rest', '1', '123', null);
INSERT INTO `test` VALUES ('26', 'Suresh', '2', '1234', null);
INSERT INTO `test` VALUES ('27', 'Prakash Raja', '2', '7890', null);
INSERT INTO `test` VALUES ('30', 'Login', '2', '123', null);
INSERT INTO `test` VALUES ('31', 'Raqshan', '2', '7890', null);
INSERT INTO `test` VALUES ('32', 'Osman', '2', '123', null);
INSERT INTO `test` VALUES ('33', 'Arjun', '2', '1234567', null);
INSERT INTO `test` VALUES ('34', 'Ismail', '1', '7890', null);
INSERT INTO `test` VALUES ('36', 'Nirenjan', '1', '12345', null);
INSERT INTO `test` VALUES ('37', 'Mary', '1', '4567', null);
INSERT INTO `test` VALUES ('38', 'Karthik', '2', '6789', null);
INSERT INTO `test` VALUES ('39', 'Suresh Kumar', '2', '78790', null);
INSERT INTO `test` VALUES ('40', 'Logesh', '2', '12345', null);
INSERT INTO `test` VALUES ('42', 'Shabhana', '1', '6767', null);
INSERT INTO `test` VALUES ('43', 'Rishan', '2', '34545', null);
INSERT INTO `test` VALUES ('45', 'Hafiz', '1', '345', null);
INSERT INTO `test` VALUES ('48', 'Allen', '1', '34535', null);
INSERT INTO `test` VALUES ('49', 'Franklin', '2', '34535', null);
INSERT INTO `test` VALUES ('766', 'Rene', '1', '123', null);
INSERT INTO `test` VALUES ('767', 'Renes', '1', '123', null);
INSERT INTO `test` VALUES ('768', 'Ronnie', '1', '123', null);
INSERT INTO `test` VALUES ('769', 'Rohanna', '1', '12345', null);
INSERT INTO `test` VALUES ('771', 'Ros', '1', '12345', null);
INSERT INTO `test` VALUES ('772', 'Roshanth', '2', '123', null);
INSERT INTO `test` VALUES ('776', 'Risk', '2', '123', null);
INSERT INTO `test` VALUES ('777', 'Risko', '2', '123', null);
INSERT INTO `test` VALUES ('778', 'Riskona', '2', '123', null);
INSERT INTO `test` VALUES ('780', 'Frost', '1', '123', null);
INSERT INTO `test` VALUES ('791', 'Prasanna', '1', '123', null);
INSERT INTO `test` VALUES ('793', 'Usman', '2', '212312', null);
INSERT INTO `test` VALUES ('794', 'Pattani', '1', '123', null);
INSERT INTO `test` VALUES ('795', 'Raqshan', '2', '123', '2018-08-20 13:09:27');
INSERT INTO `test` VALUES ('796', 'Pradeep', '2', '123', '2018-08-20 08:58:08');
INSERT INTO `test` VALUES ('797', 'Azminah', '2', '12345', '2018-08-20 12:48:58');
INSERT INTO `test` VALUES ('800', 'Reyes', '1', '1234567', '2018-08-21 12:32:25');
INSERT INTO `test` VALUES ('801', 'Roshananth', '1', '123', '2018-08-21 18:13:06');
INSERT INTO `test` VALUES ('802', 'Lokman', '1', '123', '2018-08-21 18:15:01');
INSERT INTO `test` VALUES ('803', 'Osmania', '1', '123', '2018-08-21 18:15:59');
INSERT INTO `test` VALUES ('804', 'Jaya', '1', '123', '2018-08-29 13:40:24');