PyRIGS/training/migrations/data/esql_create.txt

-- Exported from MS Access to PostgreSQL
-- (C) 1997-98 CYNERGI - www.cynergi.net, info@cynergi.net

CREATE TABLE Categories
     (
     ID                    serial,
     Category_Number      int8,
     Category_Name        varchar(255),
     PRIMARY KEY (ID)
     );


CREATE TABLE Members
     (
     ID                    serial,
     Member_Name          varchar(255),
     PRIMARY KEY (ID)
     );


CREATE TABLE tblrequirements
     (
     ID                    serial,
     level_id             int8,
     item_id              int8,
     PRIMARY KEY (ID)
     );


CREATE TABLE Training_Items
     (
     ID                    serial,
     Category_ID          int8,
     Item_Number          int8,
     Item_Name            varchar(255),
     PRIMARY KEY (ID)
     );


CREATE TABLE Training_Level_Reco
     (
     ID                    serial,
     Member_ID            int8,
     Training_Level_ID    int8,
     Date_Level_Awarded   DATETIME,
     PRIMARY KEY (ID)
     );


CREATE TABLE Training_Levels
     (
     ID                    serial,
     Level_Name           varchar(255),
     PRIMARY KEY (ID)
     );


CREATE TABLE Training_Records
     (
     ID                    serial,
     Member_ID            int8,
     Training_Item_ID     int8,
     Traning_Started_Dat  DATETIME,
     Training_Started_As  int8,
     Training_Started_No  text,
     Traning_Complete_Da  DATETIME,
     Training_Complete_A  int8,
     Training_Complete_N  text,
     Competency_Assessed  DATETIME,
     Competency_Assessed  int8,
     Competency_Assessed  text,
     PRIMARY KEY (ID)
     );