code:

* Powered by General SQL Parser ([url]www.sqlparser.com[/url]) */

CREATE TABLE INFRASTRUCTURE (
  ASSET_TAG        INT   NOT NULL   AUTO_INCREMENT,
  DEVICE_TYPE      TEXT   NOT NULL,
  MANUFACTURER     TEXT   NOT NULL,
  NETWORK_NAME     TEXT,
  IP_ADDR          VARCHAR(15),
  SUB_MASK         VARCHAR(15),
  CPU              TEXT,
  MEMORY           VARCHAR(5),
  OPERATING_SYSTEM TEXT,
  PURPOSE          TEXT   NOT NULL,
    PRIMARY KEY ( ASSET_TAG ));



CREATE TABLE LOCATION (
  ASSET_TAG INT   NOT NULL,
  LOCATION  TEXT   NOT NULL,
  BUILDING  TEXT   NOT NULL,
    PRIMARY KEY ( ASSET_TAG ));