1tQHNp9f

1CREATE TABLE IF NOT EXISTS Loading
2  (
3     L_Id            INT,
4     PO_Id           INT NOT NULL,
5     LD_Id           INT NOT NULL,
6     LE_Id           INT,
7     W_Id            INT NOT NULL,
8     RemainingWieght DOUBLE,
9     ExpectedStart   DATETIME NOT NULL DEFAULT GETDATE(),
10     ExpectedEnd     TIMESTAMP,
11     LoadingStatus   ENUM('ASSIGNED', 'IN_PROCESS', 'STOPPED', 'COMPLETED'),
12     PRIMARY KEY (L_Id),
13     FOREIGN KEY (`PO_Id`) REFERENCES `PartOder` (`PO_Id`),
14     FOREIGN KEY (`LD_Id`) REFERENCES `LoadingDock` (`LD_Id`),
15     FOREIGN KEY (`LE_Id`) REFERENCES `LoadingError` (`LE_Id`),
16     FOREIGN KEY (`W_Id`) REFERENCES `Weighing` (`W_Id`)
17  );
18	
19ALTER TABLE MyTable
20ADD CONSTRAINT DF_MyTable_MyColumn
21DEFAULT GETDATE() FOR MyColumn