Contents

CREATE  TABLE IF NOT EXISTS `authentication_log` (
	`id` int(10) NOT NULL AUTO_INCREMENT,
	`companyId` bigint(20) NOT NULL,
	`date` datetime NOT NULL,
	`login_id` varchar(75) NOT NULL,
	`access_ip` varchar(15) NOT NULL,
	`host_name` varchar(75) NOT NULL,
	`status` varchar(50) NOT NULL,
	PRIMARY KEY (`id`)
);

CREATE  TABLE IF NOT EXISTS `access_log` (
	`id` int(10) NOT NULL AUTO_INCREMENT,
	`companyId` bigint(20) NOT NULL,
	`date` datetime NOT NULL,
	`login_id` varchar(75) NOT NULL,
	`access_ip` varchar(15) NOT NULL,
	`host_name` varchar(75) NOT NULL,
	`access_url` varchar(2048) NOT NULL,
	`forward_time` int(5) NOT NULL,
	`httpstatus` int(3) NOT NULL,
	`user_agent` varchar(512) NOT NULL,
	`referer` varchar(2048),
	PRIMARY KEY (`id`)
);

CREATE  TABLE IF NOT EXISTS `authorization_log` (
	`id` int(10) NOT NULL AUTO_INCREMENT,
	`companyId` bigint(20) NOT NULL,
	`date` datetime NOT NULL,
	`login_id` varchar(75) NOT NULL,
	`host_name` varchar(75) NOT NULL,
	`access_url` varchar(2048) NOT NULL,
	`status` varchar(50) NOT NULL,
	PRIMARY KEY (`id`)
);

Version data entries

4 entries across 4 versions & 1 rubygems

Version	Path
rbatch-1.8.0	sample/moto/src/main/sql/tables.sql
rbatch-1.7.0	sample/moto/src/main/sql/tables.sql
rbatch-1.6.6	sample/moto/src/main/sql/tables.sql
rbatch-1.6.4	sample/moto/src/main/sql/tables.sql