# Script to construct 'login' & 'logout' table within 'accounting' database.
#
#
CREATE TABLE login(
login char(15),
start_record TIMESTAMP(14),
session_id char(255) NOT NULL,
PRIMARY KEY (start_record)
);

CREATE TABLE logout (
login char(15),
input_packets int(10),
output_packets int(10),
duration int (5),
ip_address char(15),
end_record TIMESTAMP(14),
session_id char(255) NOT NULL,
PRIMARY KEY (end_record)
);

CREATE TABLE users(
login char(15),
passwd char(14),
PRIMARY KEY (login)
);
