Contents

USE ToDo;

-- Table 1: User
CREATE TABLE User (
                       UserID INT PRIMARY KEY AUTO_INCREMENT,
                       FirstName VARCHAR(50) NOT NULL,
                       LastName VARCHAR(50) NOT NULL,
                       FatherName VARCHAR(50)
);
-- Table 2: Managers
CREATE TABLE Manager (
                          ManagerID INT PRIMARY KEY AUTO_INCREMENT,
                          Name VARCHAR(50) NOT NULL,
                          Email VARCHAR(255),
                          Phone VARCHAR(20) NOT NULL
);
-- Table 3: Tasks
CREATE TABLE Task (
                      TaskID INT PRIMARY KEY AUTO_INCREMENT,
                      UserID INT NOT NULL,
                      ManagerID INT NOT NULL,
                      Completed VARCHAR(10) NOT NULL CHECK (Completed IN ('Done', 'Undone', 'Process')),
                      Description TEXT,
                      Date DATE NOT NULL,
                      FOREIGN KEY (UserID) REFERENCES User (UserID),
                      FOREIGN KEY (ManagerID) REFERENCES Manager (ManagerID)
);

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
papaSquidLib-0.1.0	lib/db_config/migrations/create_tables.sql