19.02 DB Schema Changes
- Nicolas Maillet (Unlicensed)
- Kenny Duffy
Owned by Nicolas Maillet (Unlicensed)
[tbl_Fare_Header_Audit]
Added Field(s)
| Field | Datatype | NULLABLE |
|---|---|---|
| [lng_Route_Types_Id_Nmbr] | int | NO |
[tbl_Vouchers]
Added Field(s)
| Field | Datatype | NULLABLE |
|---|---|---|
| [str_Email] | VARCHAR (128) | YES |
| [str_Issued_Res_Locator] | VARCHAR (15) | YES |
| [str_Issued_Flight_Nmbr] | VARCHAR (10) | YES |
| [dtm_Issued_Flight_Date] | SMALLDATETIME | YES |
[tbl_Trigger_ADL]
New Table
| Field | Datatype | NULLABLE |
|---|---|---|
| [lng_Trigger_ADL_Id_Nmbr] | INT | NO |
| [str_Airline_Code_ID] | NVARCHAR (2) | NO |
| [str_Flight_Nmbr] | NVARCHAR (10) | NO |
| [dtm_Dep_Date] | SMALLDATETIME | NO |
| [lng_Dep_Airport_Id] | INT | NO |
| [str_Processed] | NVARCHAR (1) | NO |
| [dtm_Processed_Date] | SMALLDATETIME | NO |
| [tsp_Timestamp] | ROWVERSION | NO |
| [dtm_Creation_Date] | SMALLDATETIME | NO |
| [lng_Creation_User_Id_Nmbr] | INT | NO |
| [dtm_Last_Mod_Date] | SMALLDATETIME | NO |
| [lng_Last_Mod_User_Id_Nmbr] | INT | NO |
[tbl_Voucher_Audit]
New Table
| Field | Datatype | NULLABLE |
|---|---|---|
| [lng_Voucher_Audit_Id_Nmbr] | INT | NO |
| [dtm_Date] | SMALLDATETIME | NO |
| [lng_Vouchers_Id_Nmbr] | INT | NO |
| [lng_Audit_User_Id_Nmbr] | INT | NO |
| [str_Description] | VARCHAR (50) | NO |
| [str_Old_Value] | VARCHAR (255) | NO |
| [str_New_value] | VARCHAR (255) | NO |
| [tsp_Timestamp] | ROWVERSION | NO |
| [dtm_Creation_Date] | SMALLDATETIME | NO |
| [lng_Creation_User_Id_Nmbr] | INT | NO |
| [dtm_Last_Mod_Date] | SMALLDATETIME | NO |
| [lng_Last_Mod_User_Id_Nmbr] | INT | NO |
[tbl_Voucher_Email_Header]
New Table
| Field | Datatype | NULLABLE |
|---|---|---|
| [lng_Voucher_Email_Header_Id_Nmbr] | INT | NO |
| [str_Name] | VARCHAR (25) | NO |
| [str_Default_From_Email] | VARCHAR (128) | NO |
| [str_Bcc_Email] | VARCHAR (1000) | NO |
| [str_Subject] | VARCHAR (1000) | NO |
| [bit_Active] | BIT | NO |
| [tsp_Timestamp] | ROWVERSION | NO |
| [dtm_Creation_Date] | SMALLDATETIME | YES |
| [lng_Creation_User_Id_Nmbr] | INT | NO |
| [dtm_Last_Mod_Date] | SMALLDATETIME | YES |
| [lng_Last_Mod_User_Id_Nmbr] | INT | NO |
[tbl_Voucher_Email_Template]
New Table
| Field | Datatype | NULLABLE |
|---|---|---|
| [lng_Voucher_Email_Template_Id_Nmbr] | INT | NO |
| [lng_Voucher_Email_Header_Id_Nmbr] | INT | NO |
| [lng_Language_Id_Nmbr] | INT | YES |
| [str_SSRS_Relative_Path] | VARCHAR (1000) | NO |
| [txt_Message_HTML] | NVARCHAR (MAX) | NO |
| [txt_Message_TEXT] | NVARCHAR (MAX) | NO |
| [tsp_Timestamp] | ROWVERSION | NO |
| [dtm_Creation_Date] | SMALLDATETIME | YES |
| [lng_Creation_User_Id_Nmbr] | INT | NO |
| [dtm_Last_Mod_Date] | SMALLDATETIME | YES |
| [lng_Last_Mod_User_Id_Nmbr] | INT | NO |