CREATE DATABASE RGDS;

CREATE TABLE AdminTools_Logon
(
AdminID INT NOT NULL UNIQUE,
AdminUsername VARCHAR(24) NOT NULL,
AdminPassword VARCHAR(128) NOT NULL,
AdminIsSuperAdmin SMALLINT DEFAULT 0 NOT NULL,
AdminCreatedDate DATE DEFAULT CURTIME() NOT NULL

);

CREATE TABLE AdminTools_Log
(
ID INT NOT NULL UNIQUE,
AdminLog VARCHAR(256),
LogCreatedDate DATE DEFAULT CURTIME()
);