/*
SQLyog Ultimate v11.3 (32 bit)
MySQL - 5.5.55-0ubuntu0.14.04.1 : Database - fleets_backoffice_core
*********************************************************************
*/




/*Table structure for table `gtfw_account` */


CREATE TABLE `gtfw_account` (
  `account_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `account_name` varchar(100) DEFAULT NULL,
  `account_parent_id` int(5) DEFAULT NULL,
  `account_nested_code` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`account_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

/*Data for the table `gtfw_account` */

insert  into `gtfw_account`(`account_id`,`account_name`,`account_parent_id`,`account_nested_code`) values (1,'PT. Gamatechno Indonesia',0,'0'),(10,'Operator Dishub',1,'0.1');

/*Table structure for table `gtfw_action` */


CREATE TABLE `gtfw_action` (
  `action_id` smallint(6) NOT NULL AUTO_INCREMENT,
  `action_code` varchar(20) DEFAULT NULL,
  `insert_user_id` bigint(20) DEFAULT NULL,
  `insert_timestamp` datetime DEFAULT '0000-00-00 00:00:00',
  `update_user_id` bigint(20) DEFAULT NULL,
  `update_timestamp` datetime DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`action_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

/*Data for the table `gtfw_action` */

insert  into `gtfw_action`(`action_id`,`action_code`,`insert_user_id`,`insert_timestamp`,`update_user_id`,`update_timestamp`) values (1,'view',NULL,'0000-00-00 00:00:00',NULL,'0000-00-00 00:00:00'),(2,'add',NULL,'0000-00-00 00:00:00',NULL,'0000-00-00 00:00:00'),(3,'update',NULL,'0000-00-00 00:00:00',NULL,'0000-00-00 00:00:00'),(4,'delete',NULL,'0000-00-00 00:00:00',NULL,'0000-00-00 00:00:00'),(5,'approval',NULL,'0000-00-00 00:00:00',NULL,'0000-00-00 00:00:00');

/*Table structure for table `gtfw_action_text` */


CREATE TABLE `gtfw_action_text` (
  `actiontext_action_id` smallint(6) NOT NULL COMMENT 'refer to gtfw_action.action_id',
  `actiontext_lang_code` varchar(5) NOT NULL COMMENT 'refer to gtfw_lang.lang_code',
  `actiontext_action_label` varchar(50) NOT NULL,
  `insert_user_id` bigint(20) DEFAULT NULL,
  `insert_timestamp` datetime DEFAULT '0000-00-00 00:00:00',
  `update_user_id` bigint(20) DEFAULT NULL,
  `update_timestamp` datetime DEFAULT '0000-00-00 00:00:00',
  KEY `FK_gtfw_action_text_action` (`actiontext_action_id`),
  KEY `FK_gtfw_action_text_lang` (`actiontext_lang_code`),
  CONSTRAINT `fk_gtfw_action_text` FOREIGN KEY (`actiontext_action_id`) REFERENCES `gtfw_action` (`action_id`) ON UPDATE CASCADE,
  CONSTRAINT `fk_gtfw_action_text_0` FOREIGN KEY (`actiontext_lang_code`) REFERENCES `gtfw_lang` (`lang_code`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `gtfw_action_text` */

insert  into `gtfw_action_text`(`actiontext_action_id`,`actiontext_lang_code`,`actiontext_action_label`,`insert_user_id`,`insert_timestamp`,`update_user_id`,`update_timestamp`) values (1,'id','Lihat',NULL,'0000-00-00 00:00:00',NULL,'0000-00-00 00:00:00'),(1,'en','View',NULL,'0000-00-00 00:00:00',NULL,'0000-00-00 00:00:00'),(2,'id','Tambah',NULL,'0000-00-00 00:00:00',NULL,'0000-00-00 00:00:00'),(2,'en','Add',NULL,'0000-00-00 00:00:00',NULL,'0000-00-00 00:00:00'),(3,'id','Update',NULL,'0000-00-00 00:00:00',NULL,'0000-00-00 00:00:00'),(3,'en','Update',NULL,'0000-00-00 00:00:00',NULL,'0000-00-00 00:00:00'),(4,'id','Hapus',NULL,'0000-00-00 00:00:00',NULL,'0000-00-00 00:00:00'),(4,'en','Delete',NULL,'0000-00-00 00:00:00',NULL,'0000-00-00 00:00:00'),(5,'id','Persetujuan',NULL,'0000-00-00 00:00:00',NULL,'0000-00-00 00:00:00'),(5,'en','Approval',NULL,'0000-00-00 00:00:00',NULL,'0000-00-00 00:00:00');

/*Table structure for table `gtfw_application` */


CREATE TABLE `gtfw_application` (
  `application_id` int(11) NOT NULL,
  `application_name` varchar(255) DEFAULT NULL,
  `application_desc` text,
  `insert_user_id` bigint(20) DEFAULT NULL,
  `insert_timestamp` datetime DEFAULT '0000-00-00 00:00:00',
  `update_user_id` bigint(20) DEFAULT NULL,
  `update_timestamp` datetime DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`application_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `gtfw_application` */

insert  into `gtfw_application`(`application_id`,`application_name`,`application_desc`,`insert_user_id`,`insert_timestamp`,`update_user_id`,`update_timestamp`) values (1,'ECS Suite',NULL,NULL,'0000-00-00 00:00:00',NULL,'0000-00-00 00:00:00');

/*Table structure for table `gtfw_group` */


CREATE TABLE `gtfw_group` (
  `group_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `group_name` varchar(255) DEFAULT NULL,
  `group_desc` text,
  `group_application_id` int(11) DEFAULT NULL COMMENT 'refer to gtfw_application.application_id',
  `group_account_id` bigint(20) DEFAULT NULL,
  `insert_user_id` bigint(20) DEFAULT NULL,
  `insert_timestamp` datetime DEFAULT '0000-00-00 00:00:00',
  `update_user_id` bigint(20) DEFAULT NULL,
  `update_timestamp` datetime DEFAULT '0000-00-00 00:00:00',
  `group_is_admin` enum('1','0') DEFAULT '0',
  `group_is_superadmin` enum('1','0') DEFAULT '0',
  PRIMARY KEY (`group_id`),
  KEY `FK_gtfw_group_application` (`group_application_id`),
  KEY `fk_gtfw_group_account` (`group_account_id`),
  CONSTRAINT `fk_gtfw_group` FOREIGN KEY (`group_application_id`) REFERENCES `gtfw_application` (`application_id`) ON UPDATE CASCADE,
  CONSTRAINT `fk_gtfw_group_account` FOREIGN KEY (`group_account_id`) REFERENCES `gtfw_account` (`account_id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

/*Data for the table `gtfw_group` */

insert  into `gtfw_group`(`group_id`,`group_name`,`group_desc`,`group_application_id`,`group_account_id`,`insert_user_id`,`insert_timestamp`,`update_user_id`,`update_timestamp`,`group_is_admin`,`group_is_superadmin`) values (1,'Administrator','Role sebagai Admin Sistem',1,1,1,'2013-02-20 11:31:34',1,'2017-04-18 10:54:42','1','1'),(2,'Admin Dishub','',1,1,1,'2016-11-23 17:32:42',1,'2016-12-07 08:23:13','0','0'),(3,'Grup Operator Dishub','',1,1,3,'2016-11-23 18:55:04',1,'2016-12-07 08:23:22','0','0');

/*Table structure for table `gtfw_group_menu` */


CREATE TABLE `gtfw_group_menu` (
  `groupmenu_menu_id` bigint(20) NOT NULL COMMENT 'refer to gtfw_menu.menu_id',
  `groupmenu_group_id` bigint(20) NOT NULL COMMENT 'refer to gtfw_group.group_id',
  PRIMARY KEY (`groupmenu_menu_id`,`groupmenu_group_id`),
  KEY `FK_gtfw_group_menu_group` (`groupmenu_group_id`),
  CONSTRAINT `fk_gtfw_group_menu` FOREIGN KEY (`groupmenu_menu_id`) REFERENCES `gtfw_menu` (`menu_id`) ON UPDATE CASCADE,
  CONSTRAINT `fk_gtfw_group_menu_0` FOREIGN KEY (`groupmenu_group_id`) REFERENCES `gtfw_group` (`group_id`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `gtfw_group_menu` */

insert  into `gtfw_group_menu`(`groupmenu_menu_id`,`groupmenu_group_id`) values (0,1),(1,1),(22,1),(23,1),(24,1),(26,1),(29,1),(420,1),(433,1),(438,1),(453,1),(454,1),(457,1),(458,1),(459,1),(460,1),(461,1),(463,1),(465,1),(466,1),(467,1),(468,1),(0,2),(1,2),(23,2),(26,2),(420,2),(433,2),(453,2),(454,2),(457,2),(458,2),(459,2),(460,2),(461,2),(463,2),(465,2),(466,2),(467,2),(0,3),(420,3),(433,3),(453,3),(454,3),(457,3),(458,3),(459,3),(460,3),(461,3),(463,3),(465,3),(466,3),(467,3);

/*Table structure for table `gtfw_group_module` */


CREATE TABLE `gtfw_group_module` (
  `groupmodule_group_id` bigint(20) NOT NULL COMMENT 'refer to gtfw_group.group_id',
  `groupmodule_module_id` bigint(20) NOT NULL COMMENT 'refer to gtfw_module.module_id',
  PRIMARY KEY (`groupmodule_group_id`,`groupmodule_module_id`),
  KEY `FK_gtfw_group_module_module` (`groupmodule_module_id`),
  KEY `idx_gtfw_group_module` (`groupmodule_group_id`),
  CONSTRAINT `fk_gtfw_group_module` FOREIGN KEY (`groupmodule_group_id`) REFERENCES `gtfw_group` (`group_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_gtfw_group_module_0` FOREIGN KEY (`groupmodule_module_id`) REFERENCES `gtfw_module` (`module_id`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `gtfw_group_module` */

insert  into `gtfw_group_module`(`groupmodule_group_id`,`groupmodule_module_id`) values (1,0),(2,0),(3,0),(1,9),(2,9),(3,9),(1,20),(1,21),(1,22),(1,23),(1,24),(1,25),(1,26),(1,27),(1,28),(1,29),(1,30),(2,30),(1,31),(2,31),(1,32),(2,32),(1,33),(2,33),(1,34),(2,34),(1,35),(2,35),(1,36),(2,36),(1,44),(2,44),(1,45),(2,45),(1,46),(2,46),(1,47),(2,47),(1,48),(2,48),(1,49),(2,49),(1,50),(2,50),(1,58),(1,59),(1,60),(1,61),(1,62),(1,63),(1,64),(1,87),(2,87),(3,87),(1,88),(2,88),(3,88),(1,89),(2,89),(3,89),(1,91),(2,91),(3,91),(1,92),(2,92),(3,92),(1,93),(2,93),(3,93),(1,3020),(1,3021),(1,3124),(1,3125),(1,3126),(1,3149),(2,3149),(3,3149),(1,3150),(2,3150),(3,3150),(1,3151),(2,3151),(3,3151),(1,3152),(2,3152),(3,3152),(1,3153),(2,3153),(3,3153),(1,3154),(2,3154),(3,3154),(1,3155),(2,3155),(3,3155),(1,3156),(2,3156),(3,3156),(1,3157),(2,3157),(3,3157),(1,3177),(2,3177),(3,3177),(1,3178),(2,3178),(3,3178),(1,3179),(2,3179),(3,3179),(1,3180),(2,3180),(3,3180),(1,3181),(2,3181),(3,3181),(1,3182),(2,3182),(3,3182),(1,3183),(2,3183),(3,3183),(1,3184),(2,3184),(3,3184),(1,3185),(2,3185),(3,3185),(1,3186),(2,3186),(3,3186),(1,3187),(2,3187),(3,3187),(1,3188),(2,3188),(3,3188),(1,3189),(2,3189),(3,3189),(1,3190),(2,3190),(3,3190),(1,3191),(2,3191),(3,3191),(1,3192),(2,3192),(3,3192),(1,3193),(2,3193),(3,3193),(1,3194),(2,3194),(3,3194),(1,3195),(2,3195),(3,3195),(1,3196),(2,3196),(3,3196),(1,3197),(2,3197),(3,3197),(1,3198),(2,3198),(3,3198),(1,3199),(2,3199),(3,3199),(1,3200),(2,3200),(3,3200),(1,3201),(2,3201),(3,3201),(1,3202),(2,3202),(3,3202),(1,3203),(2,3203),(3,3203),(1,3204),(2,3204),(3,3204),(1,3205),(2,3205),(3,3205),(1,3208),(1,3209),(1,3210),(2,3210),(1,3212),(2,3212),(1,3214),(2,3214),(3,3214),(1,3215),(2,3215),(3,3215),(1,3216),(2,3216),(3,3216),(1,3217),(2,3217),(3,3217),(1,3218),(2,3218),(3,3218),(1,3219),(2,3219),(3,3219),(1,3220),(2,3220),(3,3220),(1,3221),(2,3221),(3,3221),(1,3222),(2,3222),(3,3222),(1,3223),(2,3223),(3,3223),(1,3225),(2,3225),(3,3225),(1,3226),(2,3226),(3,3226),(1,3227),(2,3227),(3,3227),(1,3228),(2,3228),(3,3228),(1,3229),(2,3229),(3,3229),(1,3230),(2,3230),(3,3230),(1,3231);

/*Table structure for table `gtfw_group_report` */


CREATE TABLE `gtfw_group_report` (
  `rep_id` smallint(6) DEFAULT NULL,
  `group_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `gtfw_group_report` */

insert  into `gtfw_group_report`(`rep_id`,`group_id`) values (1,2),(4,2),(7,2),(11,2),(1,1),(2,1),(3,1),(6,1),(4,1),(12,1),(5,1),(7,1),(8,1),(9,1),(10,1),(11,1),(1,3),(5,3),(1,4),(2,4),(3,4),(6,4),(4,4),(12,4),(5,4),(7,4),(8,4),(9,4),(10,4),(11,4);

/*Table structure for table `gtfw_key` */


CREATE TABLE `gtfw_key` (
  `key_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `key_code` varchar(255) NOT NULL DEFAULT '',
  `key_desc` text,
  `insert_user_id` bigint(20) DEFAULT NULL,
  `insert_timestamp` datetime DEFAULT '0000-00-00 00:00:00',
  `update_user_id` bigint(20) DEFAULT NULL,
  `update_timestamp` datetime DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_id`),
  UNIQUE KEY `Index_key` (`key_code`)
) ENGINE=InnoDB AUTO_INCREMENT=1672 DEFAULT CHARSET=latin1;



/*Table structure for table `gtfw_key_text` */


CREATE TABLE `gtfw_key_text` (
  `key_text_key_id` bigint(20) NOT NULL COMMENT 'refer to gtfw_key.key_id',
  `key_text_lang_code` varchar(5) NOT NULL COMMENT 'refer to gtfw_lang.lang_code',
  `key_text_key_text` text,
  `insert_user_id` bigint(20) DEFAULT NULL,
  `insert_timestamp` datetime DEFAULT '0000-00-00 00:00:00',
  `update_user_id` bigint(20) DEFAULT NULL,
  `update_timestamp` datetime DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`key_text_key_id`,`key_text_lang_code`),
  KEY `FK_gtfw_key_text_lang` (`key_text_lang_code`),
  KEY `idx_gtfw_key_text` (`key_text_key_id`),
  CONSTRAINT `fk_gtfw_key_text` FOREIGN KEY (`key_text_key_id`) REFERENCES `gtfw_key` (`key_id`) ON UPDATE CASCADE,
  CONSTRAINT `fk_gtfw_key_text_0` FOREIGN KEY (`key_text_lang_code`) REFERENCES `gtfw_lang` (`lang_code`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



/*Table structure for table `gtfw_lang` */


CREATE TABLE `gtfw_lang` (
  `lang_code` varchar(5) NOT NULL,
  `lang_name` varchar(50) DEFAULT NULL,
  `lang_icon_path` varchar(255) DEFAULT NULL,
  `lang_desc` text,
  `insert_user_id` bigint(20) DEFAULT NULL,
  `insert_timestamp` datetime DEFAULT '0000-00-00 00:00:00',
  `update_user_id` bigint(20) DEFAULT NULL,
  `update_timestamp` datetime DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`lang_code`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `gtfw_lang` */

insert  into `gtfw_lang`(`lang_code`,`lang_name`,`lang_icon_path`,`lang_desc`,`insert_user_id`,`insert_timestamp`,`update_user_id`,`update_timestamp`) values ('en','English',NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,'0000-00-00 00:00:00'),('id','Indonesian',NULL,NULL,NULL,'0000-00-00 00:00:00',NULL,'0000-00-00 00:00:00');

/*Table structure for table `gtfw_logs` */


CREATE TABLE `gtfw_logs` (
  `logs_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `logs_action` varchar(50) NOT NULL,
  `logs_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `logs_old_value` text,
  `logs_new_value` text,
  `logs_user_id` bigint(20) NOT NULL,
  PRIMARY KEY (`logs_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

/*Data for the table `gtfw_logs` */

/*Table structure for table `gtfw_menu` */


CREATE TABLE `gtfw_menu` (
  `menu_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `menu_parent_id` bigint(20) DEFAULT NULL COMMENT 'refer to gtfw_menu.menu_id (parent)',
  `menu_desc` text,
  `menu_is_show` enum('Yes','No') DEFAULT NULL,
  `menu_icon_large` varchar(255) DEFAULT NULL,
  `menu_icon_path` varchar(255) DEFAULT NULL,
  `menu_icon_small` varchar(255) DEFAULT NULL,
  `menu_menu_order` int(11) DEFAULT NULL,
  `menu_application_id` int(11) NOT NULL COMMENT 'refer to gtfw_application.application_id',
  `menu_default_module_id` bigint(20) DEFAULT NULL COMMENT 'refer to gtfw_module.module_id',
  `menu_class_style` varchar(50) DEFAULT NULL,
  `insert_user_id` bigint(20) DEFAULT NULL,
  `insert_timestamp` datetime DEFAULT '0000-00-00 00:00:00',
  `update_user_id` bigint(20) DEFAULT NULL,
  `update_timestamp` datetime DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`menu_id`),
  KEY `FK_gtfw_menu_application` (`menu_application_id`),
  KEY `FK_gtfw_menu_parent` (`menu_parent_id`),
  KEY `FK_gtfw_menu_module` (`menu_default_module_id`),
  CONSTRAINT `fk_gtfw_menu` FOREIGN KEY (`menu_application_id`) REFERENCES `gtfw_application` (`application_id`) ON UPDATE CASCADE,
  CONSTRAINT `FK_gtfw_menu_module` FOREIGN KEY (`menu_default_module_id`) REFERENCES `gtfw_module` (`module_id`) ON DELETE NO ACTION ON UPDATE CASCADE,
  CONSTRAINT `FK_gtfw_menu_parent` FOREIGN KEY (`menu_parent_id`) REFERENCES `gtfw_menu` (`menu_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=469 DEFAULT CHARSET=latin1;



/*Table structure for table `gtfw_menu_text` */


CREATE TABLE `gtfw_menu_text` (
  `menutext_menu_id` bigint(20) NOT NULL COMMENT 'refer to gtfw_menu.menu_id',
  `menutext_lang_code` varchar(5) NOT NULL COMMENT 'refer to gtfw_lang.lang_code',
  `menutext_menu_name` varchar(255) DEFAULT NULL,
  `insert_user_id` bigint(20) DEFAULT NULL,
  `insert_timestamp` datetime DEFAULT '0000-00-00 00:00:00',
  `update_user_id` bigint(20) DEFAULT NULL,
  `update_timestamp` datetime DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`menutext_menu_id`,`menutext_lang_code`),
  KEY `FK_gtfw_menu_text_lang` (`menutext_lang_code`),
  KEY `idx_gtfw_menu_text` (`menutext_menu_id`),
  CONSTRAINT `fk_gtfw_menu_text` FOREIGN KEY (`menutext_lang_code`) REFERENCES `gtfw_lang` (`lang_code`) ON UPDATE CASCADE,
  CONSTRAINT `fk_gtfw_menu_text_0` FOREIGN KEY (`menutext_menu_id`) REFERENCES `gtfw_menu` (`menu_id`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



/*Table structure for table `gtfw_module` */


CREATE TABLE `gtfw_module` (
  `module_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `module` varchar(100) DEFAULT NULL,
  `module_sub_module` varchar(100) DEFAULT NULL,
  `module_action` varchar(100) DEFAULT NULL,
  `module_type` varchar(100) DEFAULT NULL,
  `module_desc` text,
  `module_access` enum('exclusive','all') DEFAULT 'all',
  `module_menu_id` bigint(20) DEFAULT NULL COMMENT 'refer to gtfw_menu.menu_id',
  `module_application_id` int(11) DEFAULT NULL COMMENT 'refer to gtfw_application.application_id',
  `module_action_id` smallint(6) DEFAULT NULL COMMENT 'refer to gtfw_action.action_id',
  `insert_user_id` bigint(20) DEFAULT NULL,
  `insert_timestamp` datetime DEFAULT '0000-00-00 00:00:00',
  `update_user_id` bigint(20) DEFAULT NULL,
  `update_timestamp` datetime DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`module_id`),
  KEY `FK_gtfw_module_application` (`module_application_id`),
  KEY `FK_gtfw_module_action` (`module_action_id`),
  KEY `FK_gtfw_module_menu` (`module_menu_id`),
  CONSTRAINT `fk_gtfw_module` FOREIGN KEY (`module_menu_id`) REFERENCES `gtfw_menu` (`menu_id`) ON DELETE NO ACTION ON UPDATE CASCADE,
  CONSTRAINT `fk_gtfw_module_0` FOREIGN KEY (`module_application_id`) REFERENCES `gtfw_application` (`application_id`) ON UPDATE CASCADE,
  CONSTRAINT `fk_gtfw_module_1` FOREIGN KEY (`module_action_id`) REFERENCES `gtfw_action` (`action_id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3232 DEFAULT CHARSET=latin1;



/*Table structure for table `gtfw_setting` */


CREATE TABLE `gtfw_setting` (
  `setting_id` int(11) NOT NULL AUTO_INCREMENT,
  `setting_name` varchar(100) DEFAULT NULL,
  `setting_value` varchar(254) DEFAULT NULL,
  `setting_desc` text,
  `insert_user_id` bigint(20) DEFAULT NULL,
  `insert_timestamp` datetime DEFAULT '0000-00-00 00:00:00',
  `update_user_id` bigint(20) DEFAULT NULL,
  `update_timestamp` datetime DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`setting_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

/*Data for the table `gtfw_setting` */

insert  into `gtfw_setting`(`setting_id`,`setting_name`,`setting_value`,`setting_desc`,`insert_user_id`,`insert_timestamp`,`update_user_id`,`update_timestamp`) values (1,'view_per_page','100','',1,'2012-06-08 08:27:59',37,'2012-11-14 11:39:47');

/*Table structure for table `gtfw_table_documentation` */


CREATE TABLE `gtfw_table_documentation` (
  `tabledoc_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `tabledoc_name` varchar(255) DEFAULT NULL,
  `tabledoc_table` varchar(255) DEFAULT NULL,
  `tabledoc_dependency_source` text,
  `tabledoc_dependency_target` text,
  `tabledoc_desc` text,
  `tabledoc_sample_data` text,
  `tabledoc_menu_name` varchar(255) DEFAULT NULL,
  `tabledoc_module_name` varchar(255) DEFAULT NULL,
  `insert_user_id` bigint(20) DEFAULT NULL,
  `insert_timestamp` datetime DEFAULT '1900-01-01 00:00:00',
  `update_user_id` bigint(20) DEFAULT NULL,
  `update_timestamp` datetime DEFAULT '1900-01-01 00:00:00',
  PRIMARY KEY (`tabledoc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `gtfw_table_documentation` */

/*Table structure for table `gtfw_unit` */


CREATE TABLE `gtfw_unit` (
  `unit_id` smallint(6) NOT NULL AUTO_INCREMENT,
  `unit_parent_id` smallint(6) DEFAULT NULL COMMENT 'refer to gtfw_unit.unit_id (parent)',
  `unit_level` varchar(20) DEFAULT NULL,
  `unit_code` varchar(50) DEFAULT NULL,
  `unit_name` varchar(255) DEFAULT NULL,
  `unit_desc` text,
  `unit_account_id` bigint(20) DEFAULT NULL,
  `insert_user_id` bigint(20) DEFAULT NULL,
  `insert_timestamp` datetime DEFAULT '0000-00-00 00:00:00',
  `update_user_id` bigint(20) DEFAULT NULL,
  `update_timestamp` datetime DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`unit_id`),
  KEY `FK_gtfw_unit_parent` (`unit_parent_id`),
  KEY `fk_gtfw_unit` (`unit_account_id`),
  CONSTRAINT `fk_gtfw_unit` FOREIGN KEY (`unit_account_id`) REFERENCES `gtfw_account` (`account_id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

/*Data for the table `gtfw_unit` */

insert  into `gtfw_unit`(`unit_id`,`unit_parent_id`,`unit_level`,`unit_code`,`unit_name`,`unit_desc`,`unit_account_id`,`insert_user_id`,`insert_timestamp`,`update_user_id`,`update_timestamp`) values (1,0,'1','KOSTI','Unit 1','',10,1,'2012-06-28 15:45:02',1,'2014-05-23 01:07:54');

/*Table structure for table `gtfw_user_fav_menu` */


CREATE TABLE `gtfw_user_fav_menu` (
  `favmenu_user_id` bigint(20) NOT NULL COMMENT 'refer to gtfw_user.user_id',
  `favmenu_menu_id` bigint(20) NOT NULL COMMENT 'refer to gtfw_menu.menu_id',
  `insert_user_id` bigint(20) DEFAULT NULL,
  `insert_timestamp` datetime DEFAULT '0000-00-00 00:00:00',
  `update_user_id` bigint(20) DEFAULT NULL,
  `update_timestamp` datetime DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`favmenu_user_id`,`favmenu_menu_id`),
  KEY `idx_gtfw_user_fav_menu` (`favmenu_user_id`),
  KEY `idx_gtfw_user_fav_menu_0` (`favmenu_menu_id`),
  CONSTRAINT `fk_gtfw_user_fav_menu` FOREIGN KEY (`favmenu_user_id`) REFERENCES `gtfw_user` (`user_id`) ON UPDATE CASCADE,
  CONSTRAINT `fk_gtfw_user_fav_menu_0` FOREIGN KEY (`favmenu_menu_id`) REFERENCES `gtfw_menu` (`menu_id`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `gtfw_user_fav_menu` */

/*Table structure for table `gtfw_user_group` */


CREATE TABLE `gtfw_user_group` (
  `usergroup_user_id` bigint(20) NOT NULL COMMENT 'refer to gtfw_user.user_id',
  `usergroup_group_id` bigint(20) NOT NULL COMMENT 'refer to gtfw_group.group_id',
  PRIMARY KEY (`usergroup_user_id`,`usergroup_group_id`),
  KEY `FK_gtfw_user_group_group` (`usergroup_group_id`),
  KEY `idx_gtfw_user_group` (`usergroup_user_id`),
  CONSTRAINT `fk_gtfw_user_group` FOREIGN KEY (`usergroup_group_id`) REFERENCES `gtfw_group` (`group_id`) ON UPDATE CASCADE,
  CONSTRAINT `fk_gtfw_user_group_0` FOREIGN KEY (`usergroup_user_id`) REFERENCES `gtfw_user` (`user_id`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `gtfw_user_group` */

insert  into `gtfw_user_group`(`usergroup_user_id`,`usergroup_group_id`) values (0,1),(1,1),(3,2),(4,3),(15,3),(16,3),(17,3),(18,3),(19,3),(20,3),(21,3),(22,3),(23,3),(24,3);

/*Table structure for table `gtfw_user_new_pass` */


CREATE TABLE `gtfw_user_new_pass` (
  `usrnewpass_user_id` bigint(20) NOT NULL,
  `usrnewpass_new_pass` varchar(50) DEFAULT NULL,
  `usrnewpass_new_pass_key` varchar(50) DEFAULT NULL,
  `usrnewpass_new_pass_datetime` datetime DEFAULT '0000-00-00 00:00:00',
  `insert_user_id` bigint(20) DEFAULT NULL,
  `insert_timestamp` datetime DEFAULT '0000-00-00 00:00:00',
  `update_user_id` bigint(20) DEFAULT NULL,
  `update_timestamp` datetime DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`usrnewpass_user_id`),
  CONSTRAINT `fk_gtfw_user_new_pass` FOREIGN KEY (`usrnewpass_user_id`) REFERENCES `gtfw_user` (`user_id`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `gtfw_user_new_pass` */

/*Table structure for table `gtfw_user_unit` */


CREATE TABLE `gtfw_user_unit` (
  `userunit_user_id` bigint(20) NOT NULL COMMENT 'refer to gtfw_user.user_id',
  `userunit_unit_id` smallint(6) NOT NULL COMMENT 'refer to gtfw_unit.unit_id',
  PRIMARY KEY (`userunit_user_id`),
  KEY `FK_gtfw_user_unit_unit` (`userunit_unit_id`),
  CONSTRAINT `fk_gtfw_user_unit_0` FOREIGN KEY (`userunit_user_id`) REFERENCES `gtfw_user` (`user_id`) ON UPDATE CASCADE,
  CONSTRAINT `FK_gtfw_user_unit_unit_id` FOREIGN KEY (`userunit_unit_id`) REFERENCES `gtfw_unit` (`unit_id`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `gtfw_user_unit` */

/*Table structure for table `gtfw_user_whosonline` */


CREATE TABLE `gtfw_user_whosonline` (
  `whos_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `whos_user_id` bigint(20) DEFAULT NULL COMMENT 'refer to gtfw_user.user_id',
  `whos_ip` varchar(15) DEFAULT NULL,
  `whos_time` datetime DEFAULT '0000-00-00 00:00:00',
  `whos_invisible` bit(1) DEFAULT b'0',
  `insert_user_id` bigint(20) DEFAULT NULL,
  `insert_timestamp` datetime DEFAULT '0000-00-00 00:00:00',
  `update_user_id` bigint(20) DEFAULT NULL,
  `update_timestamp` datetime DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`whos_id`),
  KEY `FK_gtfw_user_whosonline_user` (`whos_user_id`),
  CONSTRAINT `FK_gtfw_user_whosonline_user` FOREIGN KEY (`whos_user_id`) REFERENCES `gtfw_user` (`user_id`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `gtfw_user_whosonline` */

/*Table structure for table `gtfw_user_widget` */


CREATE TABLE `gtfw_user_widget` (
  `userwidget_user_id` bigint(20) NOT NULL,
  `userwidget_menu_id` int(11) NOT NULL,
  `userwidget_widget_id` bigint(20) NOT NULL,
  `userwidget_sizex` int(2) DEFAULT NULL,
  `userwidget_sizey` int(2) DEFAULT NULL,
  `userwidget_row` int(2) DEFAULT NULL,
  `userwidget_col` int(2) DEFAULT NULL,
  PRIMARY KEY (`userwidget_user_id`,`userwidget_menu_id`,`userwidget_widget_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `gtfw_user_widget` */

/*Table structure for table `gtfw_widget` */


CREATE TABLE `gtfw_widget` (
  `widget_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `widget_module_id` bigint(20) NOT NULL,
  `widget_name` varchar(100) DEFAULT NULL,
  `widget_description` text,
  `widget_resizable` tinyint(1) DEFAULT '1',
  `widget_sizex` tinyint(2) DEFAULT NULL,
  `widget_sizey` tinyint(2) DEFAULT NULL,
  `widget_row` tinyint(2) DEFAULT NULL,
  `widget_col` tinyint(2) DEFAULT NULL,
  `insert_user_id` bigint(20) DEFAULT NULL,
  `insert_timestamp` datetime DEFAULT '0000-00-00 00:00:00',
  `update_user_id` bigint(20) DEFAULT NULL,
  `update_timestamp` datetime DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`widget_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `gtfw_widget` */

/*Table structure for table `ref_checkpoint_type` */


CREATE TABLE `ref_checkpoint_type` (
  `cptype_id` char(3) NOT NULL,
  `cptype_name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`cptype_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `ref_checkpoint_type` */

insert  into `ref_checkpoint_type`(`cptype_id`,`cptype_name`) values ('HLT','Halte'),('POL','Pool');

/*Table structure for table `ref_color` */


CREATE TABLE `ref_color` (
  `color_id` tinyint(3) NOT NULL AUTO_INCREMENT,
  `color_name` varchar(50) DEFAULT NULL,
  `color_status` tinyint(1) DEFAULT '0',
  `color_desc` text,
  `color_is_locked` tinyint(1) DEFAULT '0',
  `insert_user_id` bigint(20) DEFAULT NULL,
  `insert_timestamp` datetime DEFAULT '1900-01-01 00:00:00',
  `update_user_id` bigint(20) DEFAULT NULL,
  `update_timestamp` datetime DEFAULT '1900-01-01 00:00:00',
  `unit_id` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`color_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

/*Data for the table `ref_color` */

insert  into `ref_color`(`color_id`,`color_name`,`color_status`,`color_desc`,`color_is_locked`,`insert_user_id`,`insert_timestamp`,`update_user_id`,`update_timestamp`,`unit_id`) values (1,'Merah ',1,NULL,1,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(2,'Jingga',1,NULL,1,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(3,'Kuning',1,NULL,1,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(4,'Hijau',1,NULL,1,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(5,'Biru',1,NULL,1,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(6,'Nila',1,NULL,1,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(7,'Ungu',1,NULL,1,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(8,'Hitam',1,NULL,1,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(9,'Putih',1,NULL,1,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(10,'Cokelat',1,NULL,1,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL);

/*Table structure for table `ref_currency` */


CREATE TABLE `ref_currency` (
  `curr_id` smallint(6) NOT NULL AUTO_INCREMENT,
  `curr_code` varchar(20) DEFAULT NULL,
  `curr_name` varchar(100) DEFAULT NULL,
  `curr_symbol` varchar(20) DEFAULT NULL,
  `curr_status` tinyint(1) DEFAULT '0',
  `curr_desc` text,
  `insert_user_id` bigint(20) DEFAULT NULL,
  `insert_timestamp` datetime DEFAULT '1900-01-01 00:00:00',
  `update_user_id` bigint(20) DEFAULT NULL,
  `update_timestamp` datetime DEFAULT '1900-01-01 00:00:00',
  `unit_id` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`curr_id`)
) ENGINE=InnoDB AUTO_INCREMENT=172 DEFAULT CHARSET=latin1;

/*Data for the table `ref_currency` */

insert  into `ref_currency`(`curr_id`,`curr_code`,`curr_name`,`curr_symbol`,`curr_status`,`curr_desc`,`insert_user_id`,`insert_timestamp`,`update_user_id`,`update_timestamp`,`unit_id`) values (1,'AED','United Arab Emirates, Dirhams','AED',0,'',1,'1900-01-01 00:00:00',1,'2012-11-08 16:27:58',NULL),(2,'AF','Afghanistan','?',0,'',1,'1900-01-01 00:00:00',1,'2012-11-09 10:58:27',NULL),(3,'ALL','Albania, Leke','Lek',0,'',1,'1900-01-01 00:00:00',24,'2012-11-08 16:11:03',NULL),(4,'AMD','Armenia, Drams','e',0,'',1,'1900-01-01 00:00:00',1,'2012-11-22 14:48:14',NULL),(5,'ANG','Netherlands Antilles, Guilders (also called Florins)','ƒ',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(6,'AOA','Angola, Kwanza','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(7,'ARS','Argentina, Pesos','$',0,'',1,'1900-01-01 00:00:00',1,'2012-11-22 14:48:38',NULL),(8,'AUD','Australia, Dollars','$',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(9,'AWG','Aruba, Guilders (also called Florins)','ƒ',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(10,'AZN','Azerbaijan, New Manats','???',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(11,'BAM','Bosnia and Herzegovina, Convertible Marka','KM',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(12,'BBD','Barbados, Dollars','$',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(13,'BDT','Bangladesh, Taka','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(14,'BGN','Bulgaria, Leva','??',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(15,'BHD','Bahrain, Dinars','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(16,'BIF','Burundi, Francs','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(17,'BMD','Bermuda, Dollars','$',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(18,'BND','Brunei Darussalam, Dollars','$',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(19,'BOB','Bolivia, Bolivianos','$b',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(20,'BRL','Brazil, Brazil Real','R$',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(21,'BSD','Bahamas, Dollars','$',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(22,'BTN','Bhutan, Ngultrum','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(23,'BWP','Botswana, Pulas','P',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(24,'BYR','Belarus, Rubles','p.',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(25,'BZD','Belize, Dollars','BZ$',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(26,'CAD','Canada, Dollars','$',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(27,'CDF','Congo/Kinshasa, Congolese Francs','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(28,'CHF','Switzerland, Francs','CHF',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(29,'CLP','Chile, Pesos','$',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(30,'CNY','China, Yuan Renminbi','¥',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(31,'COP','Colombia, Pesos','$',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(32,'CRC','Costa Rica, Colones','?',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(33,'CUP','Cuba, Pesos','?',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(34,'CVE','Cape Verde, Escudos','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(35,'CYP','Cyprus, Pounds (expires 2008-Jan-31)','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(36,'CZK','Czech Republic, Koruny','K?',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(37,'DJF','Djibouti, Francs','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(38,'DKK','Denmark, Kroner','kr',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(39,'DOP','Dominican Republic, Pesos','RD$',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(40,'DZD','Algeria, Algeria Dinars','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(41,'EEK','Estonia, Krooni','kr',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(42,'EGP','Egypt, Pounds','£',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(43,'ERN','Eritrea, Nakfa','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(44,'ETB','Ethiopia, Birr','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(45,'EUR','Euro Member Countries, Euro','ï¿½',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(46,'FJD','Fiji, Dollars','$',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(47,'FKP','Falkland Islands (Malvinas), Pounds','£',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(48,'GBP','United Kingdom, Pounds','£',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(49,'GEL','Georgia, Lari','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(50,'GGP','Guernsey, Pounds','£',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(51,'GHS','Ghana, Cedis','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(52,'GIP','Gibraltar, Pounds','£',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(53,'GMD','Gambia, Dalasi','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(54,'GNF','Guinea, Francs','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(55,'GTQ','Guatemala, Quetzales','Q',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(56,'GYD','Guyana, Dollars','$',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(57,'HKD','Hong Kong, Dollars','$',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(58,'HNL','Honduras, Lempiras','L',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(59,'HRK','Croatia, Kuna','kn',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(60,'HTG','Haiti, Gourdes','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(61,'HUF','Hungary, Forint','Ft',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(62,'IDR','Indonesia, Rupiahs','Rp',1,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(63,'ILS','Israel, New Shekels','?',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(64,'IMP','Isle of Man, Pounds','£',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(65,'INR','India, Rupees','?',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(66,'IQD','Iraq, Dinars','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(67,'IRR','Iran, Rials','?',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(68,'ISK','Iceland, Kronur','kr',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(69,'JEP','Jersey, Pounds','£',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(70,'JMD','Jamaica, Dollars','J$',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(71,'JOD','Jordan, Dinars','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(72,'JPY','Japan, Yen','¥',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(73,'KES','Kenya, Shillings','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(74,'KGS','Kyrgyzstan, Soms','??',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(75,'KHR','Cambodia, Riels','?',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(76,'KMF','Comoros, Francs','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(77,'KPW','Korea (North), Won','?',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(78,'KRW','Korea (South), Won','?',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(79,'KWD','Kuwait, Dinars','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(80,'KYD','Cayman Islands, Dollars','$',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(81,'KZT','Kazakhstan, Tenge','??',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(82,'LAK','Laos, Kips','?',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(83,'LBP','Lebanon, Pounds','£',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(84,'LKR','Sri Lanka, Rupees','?',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(85,'LRD','Liberia, Dollars','$',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(86,'LSL','Lesotho, Maloti','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(87,'LTL','Lithuania, Litai','Lt',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(88,'LVL','Latvia, Lati','Ls',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(89,'LYD','Libya, Dinars','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(90,'MAD','Morocco, Dirhams','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(91,'MDL','Moldova, Lei','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(92,'MGA','Madagascar, Ariary','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(93,'MKD','Macedonia, Denars','???',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(94,'MMK','Myanmar (Burma), Kyats','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(95,'MNT','Mongolia, Tugriks','?',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(96,'MOP','Macau, Patacas','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(97,'MRO','Mauritania, Ouguiyas','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(98,'MTL','Malta, Liri (expires 2008-Jan-31)','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(99,'MUR','Mauritius, Rupees','?',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(100,'MVR','Maldives (Maldive Islands), Rufiyaa','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(101,'MWK','Malawi, Kwachas','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(102,'MXN','Mexico, Pesos','$',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(103,'MYR','Malaysia, Ringgits','RM',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(104,'MZN','Mozambique, Meticais','MT',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(105,'NAD','Namibia, Dollars','$',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(106,'NGN','Nigeria, Nairas','?',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(107,'NIO','Nicaragua, Cordobas','C$',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(108,'NOK','Norway, Krone','kr',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(109,'NPR','Nepal, Nepal Rupees','?',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(110,'NZD','New Zealand, Dollars','$',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(111,'OMR','Oman, Rials','?',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(112,'PAB','Panama, Balboa','B/.',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(113,'PEN','Peru, Nuevos Soles','S/.',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(114,'PGK','Papua New Guinea, Kina','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(115,'PHP','Philippines, Pesos','Php',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(116,'PKR','Pakistan, Rupees','?',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(117,'PLN','Poland, Zlotych','z?',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(118,'PYG','Paraguay, Guarani','Gs',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(119,'QAR','Qatar, Rials','?',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(120,'RON','Romania, New Lei','lei',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(121,'RSD','Serbia, Dinars','???.',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(122,'RUB','Russia, Rubles','???',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(123,'RWF','Rwanda, Rwanda Francs','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(124,'SAR','Saudi Arabia, Riyals','?',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(125,'SBD','Solomon Islands, Dollars','$',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(126,'SCR','Seychelles, Rupees','?',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(127,'SDG','Sudan, Pounds','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(128,'SEK','Sweden, Kronor','kr',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(129,'SGD','Singapore, Dollars','$',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(130,'SHP','Saint Helena, Pounds','£',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(131,'SLL','Sierra Leone, Leones','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(132,'SOS','Somalia, Shillings','S',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(133,'SPL','Seborga, Luigini','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(134,'SRD','Suriname, Dollars','$',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(135,'STD','São Tome and Principe, Dobras','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(136,'SVC','El Salvador, Colones','$',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(137,'SYP','Syria, Pounds','£',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(138,'SZL','Swaziland, Emalangeni','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(139,'THB','Thailand, Baht','?',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(140,'TJS','Tajikistan, Somoni','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(141,'TMM','Turkmenistan, Manats','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(142,'TND','Tunisia, Dinars','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(143,'TOP','Tonga, Pa\'anga','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(144,'TRY','Turkey, New Lira','TL',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(145,'TTD','Trinidad and Tobago, Dollars','TT$',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(146,'TVD','Tuvalu, Tuvalu Dollars','$',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(147,'TWD','Taiwan, New Dollars','NT$',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(148,'TZS','Tanzania, Shillings','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(149,'UAH','Ukraine, Hryvnia','?',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(150,'UGX','Uganda, Shillings','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(151,'USD','United States of America, Dollars','$',1,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(152,'UYU','Uruguay, Pesos','$U',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(153,'UZS','Uzbekistan, Sums','??',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(154,'VEB','Venezuela, Bolivares (expires 2008-Jun-30)','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(155,'VEF','Venezuela, Bolivares Fuertes','Bs',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(156,'VND','Viet Nam, Dong','?',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(157,'VUV','Vanuatu, Vatu','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(158,'WST','Samoa, Tala','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(159,'XAF','Communauté Financière Africaine BEAC, Francs','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(160,'XAG','Silver, Ounces','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(161,'XAU','Gold, Ounces','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(162,'XCD','East Caribbean Dollars','$',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(163,'XDR','International Monetary Fund (IMF) Special Drawing Rights','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(164,'XOF','Communauté Financière Africaine BCEAO, Francs','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(165,'XPD','Palladium Ounces','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(166,'XPF','Comptoirs Français du Pacifique Francs','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(167,'XPT','Platinum, Ounces','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(168,'YER','Yemen, Rials','?',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(169,'ZAR','South Africa, Rand','R',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(170,'ZMK','Zambia, Kwacha','',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL),(171,'ZWD','Zimbabwe, Zimbabwe Dollars','Z$',0,NULL,1,'1900-01-01 00:00:00',NULL,'0000-00-00 00:00:00',NULL);

/*Table structure for table `ref_fuel_type` */


CREATE TABLE `ref_fuel_type` (
  `fueltype_id` tinyint(3) NOT NULL AUTO_INCREMENT,
  `fueltype_name` varchar(50) DEFAULT NULL,
  `fueltype_status` tinyint(1) DEFAULT '0',
  `fueltype_desc` text,
  `fueltype_is_locked` tinyint(1) DEFAULT '0',
  `insert_user_id` bigint(20) DEFAULT NULL,
  `insert_timestamp` datetime DEFAULT '1900-01-01 00:00:00',
  `update_user_id` bigint(20) DEFAULT NULL,
  `update_timestamp` datetime DEFAULT '1900-01-01 00:00:00',
  `unit_id` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`fueltype_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

/*Data for the table `ref_fuel_type` */

insert  into `ref_fuel_type`(`fueltype_id`,`fueltype_name`,`fueltype_status`,`fueltype_desc`,`fueltype_is_locked`,`insert_user_id`,`insert_timestamp`,`update_user_id`,`update_timestamp`,`unit_id`) values (1,'Bensin',1,'',1,1,'1900-01-01 00:00:00',1,'2013-02-22 09:51:57',NULL),(2,'Solar',1,'',1,1,'1900-01-01 00:00:00',1,'2013-02-22 09:53:03',NULL),(3,'BBG',1,NULL,1,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(4,'Pertamax',1,'bensin dengan oktan rendah',0,1,'2013-05-29 09:10:14',NULL,'1900-01-01 00:00:00',NULL);

/*Table structure for table `ref_plate_color_type` */


CREATE TABLE `ref_plate_color_type` (
  `platecolortype_id` tinyint(3) NOT NULL AUTO_INCREMENT,
  `platecolortype_name` varchar(255) DEFAULT NULL,
  `platecolortype_status` tinyint(1) DEFAULT '0',
  `platecolortype_desc` text,
  `platecolortype_is_locked` tinyint(1) DEFAULT '0',
  `insert_user_id` bigint(20) DEFAULT NULL,
  `insert_timestamp` datetime DEFAULT '1900-01-01 00:00:00',
  `update_user_id` bigint(20) DEFAULT NULL,
  `update_timestamp` datetime DEFAULT '1900-01-01 00:00:00',
  `unit_id` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`platecolortype_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

/*Data for the table `ref_plate_color_type` */

insert  into `ref_plate_color_type`(`platecolortype_id`,`platecolortype_name`,`platecolortype_status`,`platecolortype_desc`,`platecolortype_is_locked`,`insert_user_id`,`insert_timestamp`,`update_user_id`,`update_timestamp`,`unit_id`) values (1,'Hitam Teks Putih',1,'Kendaraan bermotor bukan umum dan kendaraan bermotor sewa : warna dasar hitam dengan tulisan berwarna putih',1,1,'1900-01-01 00:00:00',1,'2013-02-22 10:18:07',NULL),(2,'Kuning Teks Hitam',1,'Kendaraan bermotor umum: warna dasar kuning dengan tulisan berwarna hitam',1,1,'1900-01-01 00:00:00',1,'2013-02-22 10:13:50',NULL),(3,'Merah Teks Putih',1,'Kendaraan bermotor milik pemerintah: warna dasar merah dengan tulisan berwarna putih',1,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(4,'Putih Teks Hitam',1,'Kendaraan bermotor korps diplomatik negara asing: warna dasar putih dengan tulisan berwarna hitam',1,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(5,'Hitam Teks Putih (Diplomat)',1,'Kendaraan bermotor staf operasional korps diplomatik negara asing: warna dasar hitam dengan tulisan berwarna putih dan terdiri dari lima angka dan kode angka negara dicetak lebih kecil dengan format sub-bagian',1,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(6,'Putih Teks Merah',1,'Kendaraan bermotor untuk transportasi dealer (pengiriman dari perakitan ke dealer, atau dealer ke dealer): warna dasar putih dengan tulisan berwarna merah.',1,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL);

/*Table structure for table `ref_vehicle_brand` */


CREATE TABLE `ref_vehicle_brand` (
  `vehiclebrand_id` tinyint(3) NOT NULL AUTO_INCREMENT,
  `vehiclebrand_name` varchar(50) DEFAULT NULL,
  `vehiclebrand_origin` varchar(255) DEFAULT NULL,
  `vehiclebrand_status` tinyint(1) DEFAULT '0',
  `vehiclebrand_desc` text,
  `vehiclebrand_is_locked` tinyint(1) DEFAULT '0',
  `insert_user_id` bigint(20) DEFAULT NULL,
  `insert_timestamp` datetime DEFAULT NULL,
  `update_user_id` bigint(20) DEFAULT NULL,
  `update_timestamp` datetime DEFAULT NULL,
  `unit_id` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`vehiclebrand_id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;

/*Data for the table `ref_vehicle_brand` */

insert  into `ref_vehicle_brand`(`vehiclebrand_id`,`vehiclebrand_name`,`vehiclebrand_origin`,`vehiclebrand_status`,`vehiclebrand_desc`,`vehiclebrand_is_locked`,`insert_user_id`,`insert_timestamp`,`update_user_id`,`update_timestamp`,`unit_id`) values (1,'Toyota','Jepang',1,'desc',1,1,'0000-00-00 00:00:00',1,'2013-02-22 10:35:49',NULL),(2,'Honda','Jepang',1,NULL,0,NULL,NULL,NULL,NULL,NULL),(3,'Hyundai','Jepang',1,NULL,0,NULL,NULL,NULL,NULL,NULL),(4,'Suzuki','Jepang',1,NULL,0,NULL,NULL,NULL,NULL,NULL),(5,'KIA','Korea Selatan',1,NULL,0,NULL,NULL,NULL,NULL,NULL),(6,'Nissan','Jepang',1,NULL,0,NULL,NULL,NULL,NULL,NULL),(7,'Mercedes-Benz','Jerman',1,NULL,0,NULL,NULL,NULL,NULL,NULL),(8,'Isuzu','Jepang',1,NULL,0,NULL,NULL,NULL,NULL,NULL),(9,'Daihatsu','Jepang',1,NULL,0,NULL,NULL,NULL,NULL,NULL),(10,'Mitsubishi','Jepang',1,NULL,0,NULL,NULL,NULL,NULL,NULL),(11,'BMW','Jerman',1,NULL,0,NULL,NULL,NULL,NULL,NULL),(12,'Hino','Jepang',0,NULL,0,NULL,NULL,NULL,NULL,NULL),(13,'Chevrolet','Prancis',1,NULL,0,NULL,NULL,NULL,NULL,NULL),(14,'Yamaha','Jepang',0,NULL,0,NULL,NULL,NULL,NULL,NULL),(15,'Kawasaki','Jepang',0,NULL,0,NULL,NULL,NULL,NULL,NULL),(16,'Piaggio','Italia',0,NULL,0,NULL,NULL,NULL,NULL,NULL),(17,'Volkswagen','Jerman',0,NULL,0,NULL,NULL,NULL,NULL,NULL),(18,'Ford','Amerika Serikat',0,NULL,0,NULL,NULL,NULL,NULL,NULL),(19,'Lexus','Amerika Serikat',0,NULL,0,NULL,NULL,NULL,NULL,NULL),(20,'Ford','USA',1,'',0,1,'2013-05-29 09:11:27',NULL,NULL,NULL);

/*Table structure for table `ref_vehicle_brand_varian` */


CREATE TABLE `ref_vehicle_brand_varian` (
  `vehiclebrandvar_id` smallint(6) NOT NULL AUTO_INCREMENT,
  `vehiclebrandvar_vehiclebrand_id` tinyint(3) DEFAULT NULL COMMENT 'refer to ref_vehicle_brand.vehiclebrand_id',
  `vehiclebrandvar_name` varchar(100) DEFAULT NULL,
  `vehiclebrandvar_status` tinyint(1) DEFAULT '0',
  `vehiclebrandvar_desc` text,
  `vehiclebrandvar_is_locked` tinyint(1) DEFAULT '0',
  `insert_user_id` bigint(20) DEFAULT NULL,
  `insert_timestamp` datetime DEFAULT '1900-01-01 00:00:00',
  `update_user_id` bigint(20) DEFAULT NULL,
  `update_timestamp` datetime DEFAULT '1900-01-01 00:00:00',
  `unit_id` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`vehiclebrandvar_id`),
  KEY `FK_ref_vehicle_brand_varian_vehicle_brand` (`vehiclebrandvar_vehiclebrand_id`),
  CONSTRAINT `FK_ref_vehicle_brand_varian_vehicle_brand` FOREIGN KEY (`vehiclebrandvar_vehiclebrand_id`) REFERENCES `ref_vehicle_brand` (`vehiclebrand_id`) ON DELETE NO ACTION ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=latin1;

/*Data for the table `ref_vehicle_brand_varian` */

insert  into `ref_vehicle_brand_varian`(`vehiclebrandvar_id`,`vehiclebrandvar_vehiclebrand_id`,`vehiclebrandvar_name`,`vehiclebrandvar_status`,`vehiclebrandvar_desc`,`vehiclebrandvar_is_locked`,`insert_user_id`,`insert_timestamp`,`update_user_id`,`update_timestamp`,`unit_id`) values (1,1,'Kijang Innova',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(2,1,'Avanza',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(3,1,'Fortuner',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(4,1,'Rush',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(5,1,'Dyna',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(6,2,'Jazz',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(7,2,'CR-V',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(8,2,'Stream',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(9,3,'Accent',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(10,3,'Excel II',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(11,3,'New Atoz',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(12,3,'Trajet',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(13,4,'Grand Vitara',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(14,4,'APV',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(15,4,'Carry',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(16,4,'Carry Pickup',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(17,5,'Picanto',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(18,9,'Xenia',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(19,9,'Terios',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(20,9,'Zebra',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(21,6,'Terrano',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(22,6,'X-Trail',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(23,6,'Serena',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(24,6,'Grand Livina',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(25,1,'Limo',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(26,1,'Corolla',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(27,1,'Starlet',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(28,1,'Yaris',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(29,1,'Soluna',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(30,1,'Camry',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(31,1,'Cressida',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(32,1,'Crown',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(33,1,'Kijang',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(34,1,'Land Cruiser',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL);

/*Table structure for table `ref_vehicle_condition` */


CREATE TABLE `ref_vehicle_condition` (
  `vehiclecond_id` tinyint(3) NOT NULL AUTO_INCREMENT,
  `vehiclecond_name` varchar(50) DEFAULT NULL,
  `vehiclecond_order` int(5) DEFAULT '0',
  `vehiclecond_status` tinyint(1) DEFAULT '0',
  `vehiclecond_desc` text,
  `vehiclecond_is_locked` tinyint(1) DEFAULT '0',
  `insert_user_id` bigint(20) DEFAULT NULL,
  `insert_timestamp` datetime DEFAULT '1900-01-01 00:00:00',
  `update_user_id` bigint(20) DEFAULT NULL,
  `update_timestamp` datetime DEFAULT '1900-01-01 00:00:00',
  `unit_id` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`vehiclecond_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

/*Data for the table `ref_vehicle_condition` */

insert  into `ref_vehicle_condition`(`vehiclecond_id`,`vehiclecond_name`,`vehiclecond_order`,`vehiclecond_status`,`vehiclecond_desc`,`vehiclecond_is_locked`,`insert_user_id`,`insert_timestamp`,`update_user_id`,`update_timestamp`,`unit_id`) values (1,'Sangat Baik',1,1,'',0,1,'1900-01-01 00:00:00',1,'2013-03-08 16:21:08',NULL),(2,'Baik',2,1,NULL,0,1,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(3,'Cukup',3,1,NULL,0,1,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(4,'Kurang Baik',4,1,NULL,0,1,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(5,'Sangat Kurang Baik',5,1,NULL,0,1,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL);

/*Table structure for table `ref_vehicle_own_status` */


CREATE TABLE `ref_vehicle_own_status` (
  `vehicleownstat_id` tinyint(3) NOT NULL AUTO_INCREMENT,
  `vehicleownstat_name` varchar(255) DEFAULT NULL,
  `vehicleownstat_status` tinyint(1) DEFAULT '0',
  `vehicleownstat_desc` text,
  `vehicleownstat_is_locked` tinyint(1) DEFAULT '0',
  `insert_user_id` bigint(20) DEFAULT NULL,
  `insert_timestamp` datetime DEFAULT '1900-01-01 00:00:00',
  `update_user_id` bigint(20) DEFAULT NULL,
  `update_timestamp` datetime DEFAULT '1900-01-01 00:00:00',
  `unit_id` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`vehicleownstat_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

/*Data for the table `ref_vehicle_own_status` */

insert  into `ref_vehicle_own_status`(`vehicleownstat_id`,`vehicleownstat_name`,`vehicleownstat_status`,`vehicleownstat_desc`,`vehicleownstat_is_locked`,`insert_user_id`,`insert_timestamp`,`update_user_id`,`update_timestamp`,`unit_id`) values (1,'Pribadi',1,'',0,NULL,'1900-01-01 00:00:00',1,'2013-02-22 14:46:06',NULL),(2,'Sewa',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL);

/*Table structure for table `ref_vehicle_type` */


CREATE TABLE `ref_vehicle_type` (
  `vehicletype_id` smallint(6) NOT NULL AUTO_INCREMENT,
  `vehicletype_name` varchar(100) DEFAULT NULL,
  `vehicletype_status` tinyint(1) DEFAULT '0',
  `vehicletype_desc` text,
  `vehicletype_is_locked` tinyint(1) DEFAULT '0',
  `insert_user_id` bigint(20) DEFAULT NULL,
  `insert_timestamp` datetime DEFAULT '1900-01-01 00:00:00',
  `update_user_id` bigint(20) DEFAULT NULL,
  `update_timestamp` datetime DEFAULT '1900-01-01 00:00:00',
  `unit_id` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`vehicletype_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

/*Data for the table `ref_vehicle_type` */

insert  into `ref_vehicle_type`(`vehicletype_id`,`vehicletype_name`,`vehicletype_status`,`vehicletype_desc`,`vehicletype_is_locked`,`insert_user_id`,`insert_timestamp`,`update_user_id`,`update_timestamp`,`unit_id`) values (1,'Sedan',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(2,'MPV',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(3,'SUV',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(4,'Minibus',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(5,'Bus',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(6,'Pick Up',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(7,'Niaga',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(8,'Kargo',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(9,'Truk',1,NULL,0,NULL,'1900-01-01 00:00:00',NULL,'1900-01-01 00:00:00',NULL),(10,'Dump',1,'',0,NULL,'1900-01-01 00:00:00',1,'2013-02-22 15:09:00',NULL);

