CREATE TABLE inv_t_users
(UserID VARCHAR(20) NOT NULL , 
Password VARCHAR(20), 
UserName VARCHAR(50), 
EMail VARCHAR(50),
UserType CHAR(1),
Active CHAR(1),
PRIMARY KEY (UserID));

CREATE TABLE inv_t_network  (
    NetworkCode VARCHAR(20) NOT NULL , 
    NetworkName VARCHAR(100),
    Description VARCHAR(255),
    UserLastUpdated VARCHAR(20),
    Active CHAR(1),
    LastUpdatedDate DATETIME,
    PRIMARY KEY (NetworkCode)
);

CREATE TABLE inv_t_devicetype  (
    DeviceTypeCode VARCHAR(20) NOT NULL , 
    Description VARCHAR(255),
    UserLastUpdated VARCHAR(20),
    LastUpdatedDate DATETIME,
    PRIMARY KEY (DeviceTypeCode)
);

CREATE TABLE inv_t_manufacturer  (
    MFGCode VARCHAR(20) NOT NULL , 
    MFGName VARCHAR(100), 
    MFGSupportTelephone VARCHAR(100), 
    MFGWeb VARCHAR(100), 
    Active CHAR(1),
    UserLastUpdated VARCHAR(20),
    LastUpdatedDate DATE,
    PRIMARY KEY (MFGCode)
);
CREATE TABLE inv_t_vendor  (
    VendorCode VARCHAR(20) NOT NULL , 
    VendorName VARCHAR(100), 
    Telephone VARCHAR(100), 
    Address VARCHAR(100), 
    Active CHAR(1),
    UserLastUpdated VARCHAR(20),
    LastUpdatedDate DATETIME,
    PRIMARY KEY (VendorCode)
);

CREATE TABLE inv_t_device  (
    DeviceCode VARCHAR(20) NOT NULL , 
    DeviceName VARCHAR(100)  , 
    SerialNumber VARCHAR(100), 
    DeviceDescription VARCHAR(100), 
    IPAddress VARCHAR(25), 
    DefaultGateway VARCHAR(25), 
    PortsUsed VARCHAR(100), 
    Dateofpurchase DATE,  
    Firmwareversion  VARCHAR(100), 
    Comments     VARCHAR(255),
    Datetakenoffline DATE,
    WarrantyLength  VARCHAR(10),
    MRTGGraphLink VARCHAR(100),
    UserLastUpdated VARCHAR(20),
    LastUpdatedDate DATETIME,
    Active CHAR(1),
    DeviceTypeCode VARCHAR(20), 
    MFGCode VARCHAR(20), 
    NetworkCode VARCHAR(20), 
    VendorCode  VARCHAR(20),
    PRIMARY KEY (DeviceCode)
);

CREATE TABLE inv_t_usertype  (
    UserTypeCode VARCHAR(1) NOT NULL , 
    Description VARCHAR(15),
    PRIMARY KEY (UserTypeCode)
);

CREATE TABLE inv_t_devicelogs (
    ID MEDIUMINT  UNSIGNED NOT NULL AUTO_INCREMENT,
    DeviceCode VARCHAR(20), 
    Comments VARCHAR(255)    ,
    UserLastUpdated VARCHAR(20),
    LastUpdatedDate DATETIME, 
     PRIMARY KEY (id)
);

CREATE TABLE inv_t_menus (
   ID mediumint(8) unsigned NOT NULL auto_increment,
   Title varchar(255),
   HyperLink varchar(255),
   DisplaySequence mediumint(8) unsigned,
   Active char(1),
   PRIMARY KEY (ID)
);

insert into inv_t_users(UserID,Password,username,active,UserType) values('admin'
,'admin','admin','Y','A');

insert into inv_t_usertype(UserTypeCode,Description) values('A'
,'Admin');

insert into inv_t_usertype(UserTypeCode,Description) values('N'
,'Normal User');
insert into inv_t_usertype(UserTypeCode,Description) values('L'
,'User');



