search

dealy14 / ComplianceFactors.Website

This repository contains all source code for the ComplianceFactors SaaS web application.
0 stars 1 forks source link

The delivery types in the drop-down #9

Closed dealy14 closed 10 years ago

dealy14 commented 11 years ago

The delivery types in the drop-down – First, I would re-order them to show the most common three first (OLT, ILT, VCT) then I would combine lunchbox or brownbag and then, checklist is confusing as we are in a “Add a New Course” option, remove checklist.

ryanammons commented 11 years ago

These are pulled from a database lookup table, so to enforce a sort order I have to add a column for that purpose and use it in the stored procedure that grabs the values.

ryanammons commented 10 years ago

The stored procedure used for the dropdown is 'c_course_sp_get_delivery_type'. I have added a new sort column and modified the data according to the request. The database schema and data change to the SP and underlying table needs to be pushed to the the production database for the code to work. So, I'm holding off on committing the code changes until the database is updated.

ryanammons commented 10 years ago

Here is the definition script for the SP including the changes:

USE [ComplianceFactors]
GO
/****** Object:  StoredProcedure [dbo].[c_course_sp_get_delivery_type]    Script Date: 11/21/2013 16:49:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[c_course_sp_get_delivery_type]
    @s_locale NVARCHAR(255)
AS
BEGIN
declare @result NVARCHAR(MAX)
SET @result='select s_ui_dropdown_name as s_delivery_type_system_id_pk,(CASE 
                WHEN (s_ui_dropdown_'+@s_locale+' IS NULL OR LEN(s_ui_dropdown_'+@s_locale+')=0)
                    THEN s_ui_dropdown_us_english
                ELSE
                    s_ui_dropdown_'+@s_locale+'
                END) as s_delivery_type_name, 0 as s_delivery_type_order from s_tb_ui_dropdown
where [s_ui_dropdown_Name]=''app_ddl_all_text''
 union all
 select LTRIM(RTRIM(s_delivery_type_system_id_pk)) AS s_delivery_type_system_id_pk,  (CASE 
                WHEN (s_delivery_type_name_'+@s_locale+' IS NULL OR LEN(s_delivery_type_name_'+@s_locale+')=0)
                    THEN s_delivery_type_name_us_english
                ELSE
                    s_delivery_type_name_'+@s_locale+'
                END) AS s_delivery_type_name, s_delivery_type_order from s_tb_delivery_types
                order by s_delivery_type_order'
EXEC(@result)
END
ryanammons commented 10 years ago

Here is the script to re-create the table of delivery-types with the new data for sort order:

USE [ComplianceFactors]
GO
/****** Object:  Table [dbo].[s_tb_delivery_types]    Script Date: 11/21/2013 19:50:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[s_tb_delivery_types](
    [s_delivery_type_system_id_pk] [uniqueidentifier] NOT NULL,
    [s_delivery_type_id] [varchar](50) NULL,
    [s_delivery_type_name_us_english] [varchar](50) NULL,
    [s_delivery_type_desc_us_english] [varchar](max) NULL,
    [s_delivery_type_status_id_fk] [nvarchar](255) NULL,
    [s_delivery_type_mode_id_fk] [uniqueidentifier] NULL,
    [s_delivery_type_order] [int] NULL,
    [s_delivery_type_name_uk_english] [varchar](50) NULL,
    [s_delivery_type_desc_uk_english] [varchar](max) NULL,
    [s_delivery_type_name_ca_french] [varchar](50) NULL,
    [s_delivery_type_desc_ca_french] [varchar](max) NULL,
    [s_delivery_type_name_fr_french] [varchar](50) NULL,
    [s_delivery_type_desc_fr_french] [varchar](max) NULL,
    [s_delivery_type_name_mx_spanish] [varchar](50) NULL,
    [s_delivery_type_desc_mx_spanish] [varchar](max) NULL,
    [s_delivery_type_name_sp_spanish] [varchar](50) NULL,
    [s_delivery_type_desc_sp_spanish] [varchar](max) NULL,
    [s_delivery_type_name_portuguese] [varchar](50) NULL,
    [s_delivery_type_desc_portuguese] [varchar](max) NULL,
    [s_delivery_type_name_german] [varchar](50) NULL,
    [s_delivery_type_desc_german] [varchar](max) NULL,
    [s_delivery_type_name_japanese] [varchar](50) NULL,
    [s_delivery_type_desc_japanese] [varchar](max) NULL,
    [s_delivery_type_name_russian] [varchar](50) NULL,
    [s_delivery_type_desc_russian] [varchar](max) NULL,
    [s_delivery_type_name_danish] [varchar](50) NULL,
    [s_delivery_type_desc_danish] [varchar](max) NULL,
    [s_delivery_type_name_polish] [varchar](50) NULL,
    [s_delivery_type_desc_polish] [varchar](max) NULL,
    [s_delivery_type_name_swedish] [varchar](50) NULL,
    [s_delivery_type_desc_swedish] [varchar](max) NULL,
    [s_delivery_type_name_finnish] [varchar](50) NULL,
    [s_delivery_type_desc_finnish] [varchar](max) NULL,
    [s_delivery_type_name_korean] [varchar](50) NULL,
    [s_delivery_type_desc_korean] [varchar](max) NULL,
    [s_delivery_type_name_italian] [varchar](50) NULL,
    [s_delivery_type_desc_italian] [varchar](max) NULL,
    [s_delivery_type_name_dutch] [varchar](50) NULL,
    [s_delivery_type_desc_dutch] [varchar](max) NULL,
    [s_delivery_type_name_indonesian] [varchar](50) NULL,
    [s_delivery_type_desc_indonesian] [varchar](max) NULL,
    [s_delivery_type_name_greek] [varchar](50) NULL,
    [s_delivery_type_desc_greek] [varchar](max) NULL,
    [s_delivery_type_name_hungarian] [varchar](50) NULL,
    [s_delivery_type_desc_hungarian] [varchar](max) NULL,
    [s_delivery_type_name_norwegian] [varchar](50) NULL,
    [s_delivery_type_desc_norwegian] [varchar](max) NULL,
    [s_delivery_type_name_turkish] [varchar](50) NULL,
    [s_delivery_type_desc_turkish] [varchar](max) NULL,
    [s_delivery_type_name_arabic_rtl] [varchar](50) NULL,
    [s_delivery_type_desc_arabic_rtl] [varchar](max) NULL,
    [s_delivery_type_name_custom_01] [varchar](50) NULL,
    [s_delivery_type_desc_custom_01] [varchar](max) NULL,
    [s_delivery_type_name_custom_02] [varchar](50) NULL,
    [s_delivery_type_desc_custom_02] [varchar](max) NULL,
    [s_delivery_type_name_custom_03] [varchar](50) NULL,
    [s_delivery_type_desc_custom_03] [varchar](max) NULL,
    [s_delivery_type_name_custom_04] [varchar](50) NULL,
    [s_delivery_type_desc_custom_04] [varchar](max) NULL,
    [s_delivery_type_name_custom_05] [varchar](50) NULL,
    [s_delivery_type_desc_custom_05] [varchar](max) NULL,
    [s_delivery_type_name_custom_06] [varchar](50) NULL,
    [s_delivery_type_desc_custom_06] [varchar](max) NULL,
    [s_delivery_type_name_custom_07] [varchar](50) NULL,
    [s_delivery_type_desc_custom_07] [varchar](max) NULL,
    [s_delivery_type_name_custom_08] [varchar](50) NULL,
    [s_delivery_type_desc_custom_08] [varchar](max) NULL,
    [s_delivery_type_name_custom_09] [varchar](50) NULL,
    [s_delivery_type_desc_custom_09] [varchar](max) NULL,
    [s_delivery_type_name_custom_10] [varchar](50) NULL,
    [s_delivery_type_desc_custom_10] [varchar](max) NULL,
    [s_delivery_type_name_custom_11] [varchar](50) NULL,
    [s_delivery_type_desc_custom_11] [varchar](max) NULL,
    [s_delivery_type_name_custom_12] [varchar](50) NULL,
    [s_delivery_type_desc_custom_12] [varchar](max) NULL,
    [s_delivery_type_name_custom_13] [varchar](50) NULL,
    [s_delivery_type_desc_custom_13] [varchar](max) NULL,
    [s_delivery_type_name_simp_chinese] [nvarchar](100) NULL,
    [s_delivery_type_desc_simp_chinese] [nvarchar](max) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[s_tb_delivery_types] ([s_delivery_type_system_id_pk], [s_delivery_type_id], [s_delivery_type_name_us_english], [s_delivery_type_desc_us_english], [s_delivery_type_status_id_fk], [s_delivery_type_mode_id_fk], [s_delivery_type_order], [s_delivery_type_name_uk_english], [s_delivery_type_desc_uk_english], [s_delivery_type_name_ca_french], [s_delivery_type_desc_ca_french], [s_delivery_type_name_fr_french], [s_delivery_type_desc_fr_french], [s_delivery_type_name_mx_spanish], [s_delivery_type_desc_mx_spanish], [s_delivery_type_name_sp_spanish], [s_delivery_type_desc_sp_spanish], [s_delivery_type_name_portuguese], [s_delivery_type_desc_portuguese], [s_delivery_type_name_german], [s_delivery_type_desc_german], [s_delivery_type_name_japanese], [s_delivery_type_desc_japanese], [s_delivery_type_name_russian], [s_delivery_type_desc_russian], [s_delivery_type_name_danish], [s_delivery_type_desc_danish], [s_delivery_type_name_polish], [s_delivery_type_desc_polish], [s_delivery_type_name_swedish], [s_delivery_type_desc_swedish], [s_delivery_type_name_finnish], [s_delivery_type_desc_finnish], [s_delivery_type_name_korean], [s_delivery_type_desc_korean], [s_delivery_type_name_italian], [s_delivery_type_desc_italian], [s_delivery_type_name_dutch], [s_delivery_type_desc_dutch], [s_delivery_type_name_indonesian], [s_delivery_type_desc_indonesian], [s_delivery_type_name_greek], [s_delivery_type_desc_greek], [s_delivery_type_name_hungarian], [s_delivery_type_desc_hungarian], [s_delivery_type_name_norwegian], [s_delivery_type_desc_norwegian], [s_delivery_type_name_turkish], [s_delivery_type_desc_turkish], [s_delivery_type_name_arabic_rtl], [s_delivery_type_desc_arabic_rtl], [s_delivery_type_name_custom_01], [s_delivery_type_desc_custom_01], [s_delivery_type_name_custom_02], [s_delivery_type_desc_custom_02], [s_delivery_type_name_custom_03], [s_delivery_type_desc_custom_03], [s_delivery_type_name_custom_04], [s_delivery_type_desc_custom_04], [s_delivery_type_name_custom_05], [s_delivery_type_desc_custom_05], [s_delivery_type_name_custom_06], [s_delivery_type_desc_custom_06], [s_delivery_type_name_custom_07], [s_delivery_type_desc_custom_07], [s_delivery_type_name_custom_08], [s_delivery_type_desc_custom_08], [s_delivery_type_name_custom_09], [s_delivery_type_desc_custom_09], [s_delivery_type_name_custom_10], [s_delivery_type_desc_custom_10], [s_delivery_type_name_custom_11], [s_delivery_type_desc_custom_11], [s_delivery_type_name_custom_12], [s_delivery_type_desc_custom_12], [s_delivery_type_name_custom_13], [s_delivery_type_desc_custom_13], [s_delivery_type_name_simp_chinese], [s_delivery_type_desc_simp_chinese]) VALUES (N'80831fa5-f6ed-4e58-a355-19f1d4fff382', N'SOPT', N'SOPT', N'Standard Operating Procedure Training', N'app_ddl_active_text', N'79e43468-f375-447e-9644-11b6bb988d03', 4, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'')
INSERT [dbo].[s_tb_delivery_types] ([s_delivery_type_system_id_pk], [s_delivery_type_id], [s_delivery_type_name_us_english], [s_delivery_type_desc_us_english], [s_delivery_type_status_id_fk], [s_delivery_type_mode_id_fk], [s_delivery_type_order], [s_delivery_type_name_uk_english], [s_delivery_type_desc_uk_english], [s_delivery_type_name_ca_french], [s_delivery_type_desc_ca_french], [s_delivery_type_name_fr_french], [s_delivery_type_desc_fr_french], [s_delivery_type_name_mx_spanish], [s_delivery_type_desc_mx_spanish], [s_delivery_type_name_sp_spanish], [s_delivery_type_desc_sp_spanish], [s_delivery_type_name_portuguese], [s_delivery_type_desc_portuguese], [s_delivery_type_name_german], [s_delivery_type_desc_german], [s_delivery_type_name_japanese], [s_delivery_type_desc_japanese], [s_delivery_type_name_russian], [s_delivery_type_desc_russian], [s_delivery_type_name_danish], [s_delivery_type_desc_danish], [s_delivery_type_name_polish], [s_delivery_type_desc_polish], [s_delivery_type_name_swedish], [s_delivery_type_desc_swedish], [s_delivery_type_name_finnish], [s_delivery_type_desc_finnish], [s_delivery_type_name_korean], [s_delivery_type_desc_korean], [s_delivery_type_name_italian], [s_delivery_type_desc_italian], [s_delivery_type_name_dutch], [s_delivery_type_desc_dutch], [s_delivery_type_name_indonesian], [s_delivery_type_desc_indonesian], [s_delivery_type_name_greek], [s_delivery_type_desc_greek], [s_delivery_type_name_hungarian], [s_delivery_type_desc_hungarian], [s_delivery_type_name_norwegian], [s_delivery_type_desc_norwegian], [s_delivery_type_name_turkish], [s_delivery_type_desc_turkish], [s_delivery_type_name_arabic_rtl], [s_delivery_type_desc_arabic_rtl], [s_delivery_type_name_custom_01], [s_delivery_type_desc_custom_01], [s_delivery_type_name_custom_02], [s_delivery_type_desc_custom_02], [s_delivery_type_name_custom_03], [s_delivery_type_desc_custom_03], [s_delivery_type_name_custom_04], [s_delivery_type_desc_custom_04], [s_delivery_type_name_custom_05], [s_delivery_type_desc_custom_05], [s_delivery_type_name_custom_06], [s_delivery_type_desc_custom_06], [s_delivery_type_name_custom_07], [s_delivery_type_desc_custom_07], [s_delivery_type_name_custom_08], [s_delivery_type_desc_custom_08], [s_delivery_type_name_custom_09], [s_delivery_type_desc_custom_09], [s_delivery_type_name_custom_10], [s_delivery_type_desc_custom_10], [s_delivery_type_name_custom_11], [s_delivery_type_desc_custom_11], [s_delivery_type_name_custom_12], [s_delivery_type_desc_custom_12], [s_delivery_type_name_custom_13], [s_delivery_type_desc_custom_13], [s_delivery_type_name_simp_chinese], [s_delivery_type_desc_simp_chinese]) VALUES (N'5cf9bd9b-ae9d-4d28-b2c8-1be6b4ed1b82', N'VLT01', N'VLT', N'Virtual-Classroom Training', N'app_ddl_active_text', N'79e43468-f375-447e-9644-11b6bb988d03', 3, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'')
INSERT [dbo].[s_tb_delivery_types] ([s_delivery_type_system_id_pk], [s_delivery_type_id], [s_delivery_type_name_us_english], [s_delivery_type_desc_us_english], [s_delivery_type_status_id_fk], [s_delivery_type_mode_id_fk], [s_delivery_type_order], [s_delivery_type_name_uk_english], [s_delivery_type_desc_uk_english], [s_delivery_type_name_ca_french], [s_delivery_type_desc_ca_french], [s_delivery_type_name_fr_french], [s_delivery_type_desc_fr_french], [s_delivery_type_name_mx_spanish], [s_delivery_type_desc_mx_spanish], [s_delivery_type_name_sp_spanish], [s_delivery_type_desc_sp_spanish], [s_delivery_type_name_portuguese], [s_delivery_type_desc_portuguese], [s_delivery_type_name_german], [s_delivery_type_desc_german], [s_delivery_type_name_japanese], [s_delivery_type_desc_japanese], [s_delivery_type_name_russian], [s_delivery_type_desc_russian], [s_delivery_type_name_danish], [s_delivery_type_desc_danish], [s_delivery_type_name_polish], [s_delivery_type_desc_polish], [s_delivery_type_name_swedish], [s_delivery_type_desc_swedish], [s_delivery_type_name_finnish], [s_delivery_type_desc_finnish], [s_delivery_type_name_korean], [s_delivery_type_desc_korean], [s_delivery_type_name_italian], [s_delivery_type_desc_italian], [s_delivery_type_name_dutch], [s_delivery_type_desc_dutch], [s_delivery_type_name_indonesian], [s_delivery_type_desc_indonesian], [s_delivery_type_name_greek], [s_delivery_type_desc_greek], [s_delivery_type_name_hungarian], [s_delivery_type_desc_hungarian], [s_delivery_type_name_norwegian], [s_delivery_type_desc_norwegian], [s_delivery_type_name_turkish], [s_delivery_type_desc_turkish], [s_delivery_type_name_arabic_rtl], [s_delivery_type_desc_arabic_rtl], [s_delivery_type_name_custom_01], [s_delivery_type_desc_custom_01], [s_delivery_type_name_custom_02], [s_delivery_type_desc_custom_02], [s_delivery_type_name_custom_03], [s_delivery_type_desc_custom_03], [s_delivery_type_name_custom_04], [s_delivery_type_desc_custom_04], [s_delivery_type_name_custom_05], [s_delivery_type_desc_custom_05], [s_delivery_type_name_custom_06], [s_delivery_type_desc_custom_06], [s_delivery_type_name_custom_07], [s_delivery_type_desc_custom_07], [s_delivery_type_name_custom_08], [s_delivery_type_desc_custom_08], [s_delivery_type_name_custom_09], [s_delivery_type_desc_custom_09], [s_delivery_type_name_custom_10], [s_delivery_type_desc_custom_10], [s_delivery_type_name_custom_11], [s_delivery_type_desc_custom_11], [s_delivery_type_name_custom_12], [s_delivery_type_desc_custom_12], [s_delivery_type_name_custom_13], [s_delivery_type_desc_custom_13], [s_delivery_type_name_simp_chinese], [s_delivery_type_desc_simp_chinese]) VALUES (N'742623b9-f4f1-4d14-be1c-51b3be27ae93', N'Lunchbox', N'Lunchbox', N'Lunch Box', N'app_ddl_active_text', N'79e43468-f375-447e-9644-11b6bb988d03', 8, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', NULL, NULL)
INSERT [dbo].[s_tb_delivery_types] ([s_delivery_type_system_id_pk], [s_delivery_type_id], [s_delivery_type_name_us_english], [s_delivery_type_desc_us_english], [s_delivery_type_status_id_fk], [s_delivery_type_mode_id_fk], [s_delivery_type_order], [s_delivery_type_name_uk_english], [s_delivery_type_desc_uk_english], [s_delivery_type_name_ca_french], [s_delivery_type_desc_ca_french], [s_delivery_type_name_fr_french], [s_delivery_type_desc_fr_french], [s_delivery_type_name_mx_spanish], [s_delivery_type_desc_mx_spanish], [s_delivery_type_name_sp_spanish], [s_delivery_type_desc_sp_spanish], [s_delivery_type_name_portuguese], [s_delivery_type_desc_portuguese], [s_delivery_type_name_german], [s_delivery_type_desc_german], [s_delivery_type_name_japanese], [s_delivery_type_desc_japanese], [s_delivery_type_name_russian], [s_delivery_type_desc_russian], [s_delivery_type_name_danish], [s_delivery_type_desc_danish], [s_delivery_type_name_polish], [s_delivery_type_desc_polish], [s_delivery_type_name_swedish], [s_delivery_type_desc_swedish], [s_delivery_type_name_finnish], [s_delivery_type_desc_finnish], [s_delivery_type_name_korean], [s_delivery_type_desc_korean], [s_delivery_type_name_italian], [s_delivery_type_desc_italian], [s_delivery_type_name_dutch], [s_delivery_type_desc_dutch], [s_delivery_type_name_indonesian], [s_delivery_type_desc_indonesian], [s_delivery_type_name_greek], [s_delivery_type_desc_greek], [s_delivery_type_name_hungarian], [s_delivery_type_desc_hungarian], [s_delivery_type_name_norwegian], [s_delivery_type_desc_norwegian], [s_delivery_type_name_turkish], [s_delivery_type_desc_turkish], [s_delivery_type_name_arabic_rtl], [s_delivery_type_desc_arabic_rtl], [s_delivery_type_name_custom_01], [s_delivery_type_desc_custom_01], [s_delivery_type_name_custom_02], [s_delivery_type_desc_custom_02], [s_delivery_type_name_custom_03], [s_delivery_type_desc_custom_03], [s_delivery_type_name_custom_04], [s_delivery_type_desc_custom_04], [s_delivery_type_name_custom_05], [s_delivery_type_desc_custom_05], [s_delivery_type_name_custom_06], [s_delivery_type_desc_custom_06], [s_delivery_type_name_custom_07], [s_delivery_type_desc_custom_07], [s_delivery_type_name_custom_08], [s_delivery_type_desc_custom_08], [s_delivery_type_name_custom_09], [s_delivery_type_desc_custom_09], [s_delivery_type_name_custom_10], [s_delivery_type_desc_custom_10], [s_delivery_type_name_custom_11], [s_delivery_type_desc_custom_11], [s_delivery_type_name_custom_12], [s_delivery_type_desc_custom_12], [s_delivery_type_name_custom_13], [s_delivery_type_desc_custom_13], [s_delivery_type_name_simp_chinese], [s_delivery_type_desc_simp_chinese]) VALUES (N'f78bf32b-ad6e-4f90-a082-543da85afa21', N'OJT', N'OJT', N'On-the-Job Training', N'app_ddl_active_text', N'79e43468-f375-447e-9644-11b6bb988d03', 5, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', NULL, NULL)
INSERT [dbo].[s_tb_delivery_types] ([s_delivery_type_system_id_pk], [s_delivery_type_id], [s_delivery_type_name_us_english], [s_delivery_type_desc_us_english], [s_delivery_type_status_id_fk], [s_delivery_type_mode_id_fk], [s_delivery_type_order], [s_delivery_type_name_uk_english], [s_delivery_type_desc_uk_english], [s_delivery_type_name_ca_french], [s_delivery_type_desc_ca_french], [s_delivery_type_name_fr_french], [s_delivery_type_desc_fr_french], [s_delivery_type_name_mx_spanish], [s_delivery_type_desc_mx_spanish], [s_delivery_type_name_sp_spanish], [s_delivery_type_desc_sp_spanish], [s_delivery_type_name_portuguese], [s_delivery_type_desc_portuguese], [s_delivery_type_name_german], [s_delivery_type_desc_german], [s_delivery_type_name_japanese], [s_delivery_type_desc_japanese], [s_delivery_type_name_russian], [s_delivery_type_desc_russian], [s_delivery_type_name_danish], [s_delivery_type_desc_danish], [s_delivery_type_name_polish], [s_delivery_type_desc_polish], [s_delivery_type_name_swedish], [s_delivery_type_desc_swedish], [s_delivery_type_name_finnish], [s_delivery_type_desc_finnish], [s_delivery_type_name_korean], [s_delivery_type_desc_korean], [s_delivery_type_name_italian], [s_delivery_type_desc_italian], [s_delivery_type_name_dutch], [s_delivery_type_desc_dutch], [s_delivery_type_name_indonesian], [s_delivery_type_desc_indonesian], [s_delivery_type_name_greek], [s_delivery_type_desc_greek], [s_delivery_type_name_hungarian], [s_delivery_type_desc_hungarian], [s_delivery_type_name_norwegian], [s_delivery_type_desc_norwegian], [s_delivery_type_name_turkish], [s_delivery_type_desc_turkish], [s_delivery_type_name_arabic_rtl], [s_delivery_type_desc_arabic_rtl], [s_delivery_type_name_custom_01], [s_delivery_type_desc_custom_01], [s_delivery_type_name_custom_02], [s_delivery_type_desc_custom_02], [s_delivery_type_name_custom_03], [s_delivery_type_desc_custom_03], [s_delivery_type_name_custom_04], [s_delivery_type_desc_custom_04], [s_delivery_type_name_custom_05], [s_delivery_type_desc_custom_05], [s_delivery_type_name_custom_06], [s_delivery_type_desc_custom_06], [s_delivery_type_name_custom_07], [s_delivery_type_desc_custom_07], [s_delivery_type_name_custom_08], [s_delivery_type_desc_custom_08], [s_delivery_type_name_custom_09], [s_delivery_type_desc_custom_09], [s_delivery_type_name_custom_10], [s_delivery_type_desc_custom_10], [s_delivery_type_name_custom_11], [s_delivery_type_desc_custom_11], [s_delivery_type_name_custom_12], [s_delivery_type_desc_custom_12], [s_delivery_type_name_custom_13], [s_delivery_type_desc_custom_13], [s_delivery_type_name_simp_chinese], [s_delivery_type_desc_simp_chinese]) VALUES (N'6a81ecdf-4fd8-4710-8c09-61b07a3592ed', N'Exam Survey', N'Survey 01', N'Exam Survey', N'app_ddl_active_text', N'0b76fa3d-a64c-4256-9297-af0f42808ec1', 12, N'Survey 01', N'Exam survey of this year', N'sondage', N'Examen enquête de cette année', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'')
INSERT [dbo].[s_tb_delivery_types] ([s_delivery_type_system_id_pk], [s_delivery_type_id], [s_delivery_type_name_us_english], [s_delivery_type_desc_us_english], [s_delivery_type_status_id_fk], [s_delivery_type_mode_id_fk], [s_delivery_type_order], [s_delivery_type_name_uk_english], [s_delivery_type_desc_uk_english], [s_delivery_type_name_ca_french], [s_delivery_type_desc_ca_french], [s_delivery_type_name_fr_french], [s_delivery_type_desc_fr_french], [s_delivery_type_name_mx_spanish], [s_delivery_type_desc_mx_spanish], [s_delivery_type_name_sp_spanish], [s_delivery_type_desc_sp_spanish], [s_delivery_type_name_portuguese], [s_delivery_type_desc_portuguese], [s_delivery_type_name_german], [s_delivery_type_desc_german], [s_delivery_type_name_japanese], [s_delivery_type_desc_japanese], [s_delivery_type_name_russian], [s_delivery_type_desc_russian], [s_delivery_type_name_danish], [s_delivery_type_desc_danish], [s_delivery_type_name_polish], [s_delivery_type_desc_polish], [s_delivery_type_name_swedish], [s_delivery_type_desc_swedish], [s_delivery_type_name_finnish], [s_delivery_type_desc_finnish], [s_delivery_type_name_korean], [s_delivery_type_desc_korean], [s_delivery_type_name_italian], [s_delivery_type_desc_italian], [s_delivery_type_name_dutch], [s_delivery_type_desc_dutch], [s_delivery_type_name_indonesian], [s_delivery_type_desc_indonesian], [s_delivery_type_name_greek], [s_delivery_type_desc_greek], [s_delivery_type_name_hungarian], [s_delivery_type_desc_hungarian], [s_delivery_type_name_norwegian], [s_delivery_type_desc_norwegian], [s_delivery_type_name_turkish], [s_delivery_type_desc_turkish], [s_delivery_type_name_arabic_rtl], [s_delivery_type_desc_arabic_rtl], [s_delivery_type_name_custom_01], [s_delivery_type_desc_custom_01], [s_delivery_type_name_custom_02], [s_delivery_type_desc_custom_02], [s_delivery_type_name_custom_03], [s_delivery_type_desc_custom_03], [s_delivery_type_name_custom_04], [s_delivery_type_desc_custom_04], [s_delivery_type_name_custom_05], [s_delivery_type_desc_custom_05], [s_delivery_type_name_custom_06], [s_delivery_type_desc_custom_06], [s_delivery_type_name_custom_07], [s_delivery_type_desc_custom_07], [s_delivery_type_name_custom_08], [s_delivery_type_desc_custom_08], [s_delivery_type_name_custom_09], [s_delivery_type_desc_custom_09], [s_delivery_type_name_custom_10], [s_delivery_type_desc_custom_10], [s_delivery_type_name_custom_11], [s_delivery_type_desc_custom_11], [s_delivery_type_name_custom_12], [s_delivery_type_desc_custom_12], [s_delivery_type_name_custom_13], [s_delivery_type_desc_custom_13], [s_delivery_type_name_simp_chinese], [s_delivery_type_desc_simp_chinese]) VALUES (N'888a19f9-d939-4854-9f80-6aff2a223f82', N'Brownbag', N'Brownbag', N'Brownbag', N'app_ddl_active_text', N'79e43468-f375-447e-9644-11b6bb988d03', 7, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', NULL, NULL)
INSERT [dbo].[s_tb_delivery_types] ([s_delivery_type_system_id_pk], [s_delivery_type_id], [s_delivery_type_name_us_english], [s_delivery_type_desc_us_english], [s_delivery_type_status_id_fk], [s_delivery_type_mode_id_fk], [s_delivery_type_order], [s_delivery_type_name_uk_english], [s_delivery_type_desc_uk_english], [s_delivery_type_name_ca_french], [s_delivery_type_desc_ca_french], [s_delivery_type_name_fr_french], [s_delivery_type_desc_fr_french], [s_delivery_type_name_mx_spanish], [s_delivery_type_desc_mx_spanish], [s_delivery_type_name_sp_spanish], [s_delivery_type_desc_sp_spanish], [s_delivery_type_name_portuguese], [s_delivery_type_desc_portuguese], [s_delivery_type_name_german], [s_delivery_type_desc_german], [s_delivery_type_name_japanese], [s_delivery_type_desc_japanese], [s_delivery_type_name_russian], [s_delivery_type_desc_russian], [s_delivery_type_name_danish], [s_delivery_type_desc_danish], [s_delivery_type_name_polish], [s_delivery_type_desc_polish], [s_delivery_type_name_swedish], [s_delivery_type_desc_swedish], [s_delivery_type_name_finnish], [s_delivery_type_desc_finnish], [s_delivery_type_name_korean], [s_delivery_type_desc_korean], [s_delivery_type_name_italian], [s_delivery_type_desc_italian], [s_delivery_type_name_dutch], [s_delivery_type_desc_dutch], [s_delivery_type_name_indonesian], [s_delivery_type_desc_indonesian], [s_delivery_type_name_greek], [s_delivery_type_desc_greek], [s_delivery_type_name_hungarian], [s_delivery_type_desc_hungarian], [s_delivery_type_name_norwegian], [s_delivery_type_desc_norwegian], [s_delivery_type_name_turkish], [s_delivery_type_desc_turkish], [s_delivery_type_name_arabic_rtl], [s_delivery_type_desc_arabic_rtl], [s_delivery_type_name_custom_01], [s_delivery_type_desc_custom_01], [s_delivery_type_name_custom_02], [s_delivery_type_desc_custom_02], [s_delivery_type_name_custom_03], [s_delivery_type_desc_custom_03], [s_delivery_type_name_custom_04], [s_delivery_type_desc_custom_04], [s_delivery_type_name_custom_05], [s_delivery_type_desc_custom_05], [s_delivery_type_name_custom_06], [s_delivery_type_desc_custom_06], [s_delivery_type_name_custom_07], [s_delivery_type_desc_custom_07], [s_delivery_type_name_custom_08], [s_delivery_type_desc_custom_08], [s_delivery_type_name_custom_09], [s_delivery_type_desc_custom_09], [s_delivery_type_name_custom_10], [s_delivery_type_desc_custom_10], [s_delivery_type_name_custom_11], [s_delivery_type_desc_custom_11], [s_delivery_type_name_custom_12], [s_delivery_type_desc_custom_12], [s_delivery_type_name_custom_13], [s_delivery_type_desc_custom_13], [s_delivery_type_name_simp_chinese], [s_delivery_type_desc_simp_chinese]) VALUES (N'86f87998-a16d-4f02-a939-708e7ebcbe05', N'test', N'test', N'test', N'app_ddl_active_text', N'0b76fa3d-a64c-4256-9297-af0f42808ec1', 2147483647, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'')
INSERT [dbo].[s_tb_delivery_types] ([s_delivery_type_system_id_pk], [s_delivery_type_id], [s_delivery_type_name_us_english], [s_delivery_type_desc_us_english], [s_delivery_type_status_id_fk], [s_delivery_type_mode_id_fk], [s_delivery_type_order], [s_delivery_type_name_uk_english], [s_delivery_type_desc_uk_english], [s_delivery_type_name_ca_french], [s_delivery_type_desc_ca_french], [s_delivery_type_name_fr_french], [s_delivery_type_desc_fr_french], [s_delivery_type_name_mx_spanish], [s_delivery_type_desc_mx_spanish], [s_delivery_type_name_sp_spanish], [s_delivery_type_desc_sp_spanish], [s_delivery_type_name_portuguese], [s_delivery_type_desc_portuguese], [s_delivery_type_name_german], [s_delivery_type_desc_german], [s_delivery_type_name_japanese], [s_delivery_type_desc_japanese], [s_delivery_type_name_russian], [s_delivery_type_desc_russian], [s_delivery_type_name_danish], [s_delivery_type_desc_danish], [s_delivery_type_name_polish], [s_delivery_type_desc_polish], [s_delivery_type_name_swedish], [s_delivery_type_desc_swedish], [s_delivery_type_name_finnish], [s_delivery_type_desc_finnish], [s_delivery_type_name_korean], [s_delivery_type_desc_korean], [s_delivery_type_name_italian], [s_delivery_type_desc_italian], [s_delivery_type_name_dutch], [s_delivery_type_desc_dutch], [s_delivery_type_name_indonesian], [s_delivery_type_desc_indonesian], [s_delivery_type_name_greek], [s_delivery_type_desc_greek], [s_delivery_type_name_hungarian], [s_delivery_type_desc_hungarian], [s_delivery_type_name_norwegian], [s_delivery_type_desc_norwegian], [s_delivery_type_name_turkish], [s_delivery_type_desc_turkish], [s_delivery_type_name_arabic_rtl], [s_delivery_type_desc_arabic_rtl], [s_delivery_type_name_custom_01], [s_delivery_type_desc_custom_01], [s_delivery_type_name_custom_02], [s_delivery_type_desc_custom_02], [s_delivery_type_name_custom_03], [s_delivery_type_desc_custom_03], [s_delivery_type_name_custom_04], [s_delivery_type_desc_custom_04], [s_delivery_type_name_custom_05], [s_delivery_type_desc_custom_05], [s_delivery_type_name_custom_06], [s_delivery_type_desc_custom_06], [s_delivery_type_name_custom_07], [s_delivery_type_desc_custom_07], [s_delivery_type_name_custom_08], [s_delivery_type_desc_custom_08], [s_delivery_type_name_custom_09], [s_delivery_type_desc_custom_09], [s_delivery_type_name_custom_10], [s_delivery_type_desc_custom_10], [s_delivery_type_name_custom_11], [s_delivery_type_desc_custom_11], [s_delivery_type_name_custom_12], [s_delivery_type_desc_custom_12], [s_delivery_type_name_custom_13], [s_delivery_type_desc_custom_13], [s_delivery_type_name_simp_chinese], [s_delivery_type_desc_simp_chinese]) VALUES (N'50b85bf4-b9e3-46ea-9560-7aa1f21a13e5', N'OLT', N'OLT', N'On-line Training', N'app_ddl_active_text', N'79e43468-f375-447e-9644-11b6bb988d03', 1, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', NULL, NULL)
INSERT [dbo].[s_tb_delivery_types] ([s_delivery_type_system_id_pk], [s_delivery_type_id], [s_delivery_type_name_us_english], [s_delivery_type_desc_us_english], [s_delivery_type_status_id_fk], [s_delivery_type_mode_id_fk], [s_delivery_type_order], [s_delivery_type_name_uk_english], [s_delivery_type_desc_uk_english], [s_delivery_type_name_ca_french], [s_delivery_type_desc_ca_french], [s_delivery_type_name_fr_french], [s_delivery_type_desc_fr_french], [s_delivery_type_name_mx_spanish], [s_delivery_type_desc_mx_spanish], [s_delivery_type_name_sp_spanish], [s_delivery_type_desc_sp_spanish], [s_delivery_type_name_portuguese], [s_delivery_type_desc_portuguese], [s_delivery_type_name_german], [s_delivery_type_desc_german], [s_delivery_type_name_japanese], [s_delivery_type_desc_japanese], [s_delivery_type_name_russian], [s_delivery_type_desc_russian], [s_delivery_type_name_danish], [s_delivery_type_desc_danish], [s_delivery_type_name_polish], [s_delivery_type_desc_polish], [s_delivery_type_name_swedish], [s_delivery_type_desc_swedish], [s_delivery_type_name_finnish], [s_delivery_type_desc_finnish], [s_delivery_type_name_korean], [s_delivery_type_desc_korean], [s_delivery_type_name_italian], [s_delivery_type_desc_italian], [s_delivery_type_name_dutch], [s_delivery_type_desc_dutch], [s_delivery_type_name_indonesian], [s_delivery_type_desc_indonesian], [s_delivery_type_name_greek], [s_delivery_type_desc_greek], [s_delivery_type_name_hungarian], [s_delivery_type_desc_hungarian], [s_delivery_type_name_norwegian], [s_delivery_type_desc_norwegian], [s_delivery_type_name_turkish], [s_delivery_type_desc_turkish], [s_delivery_type_name_arabic_rtl], [s_delivery_type_desc_arabic_rtl], [s_delivery_type_name_custom_01], [s_delivery_type_desc_custom_01], [s_delivery_type_name_custom_02], [s_delivery_type_desc_custom_02], [s_delivery_type_name_custom_03], [s_delivery_type_desc_custom_03], [s_delivery_type_name_custom_04], [s_delivery_type_desc_custom_04], [s_delivery_type_name_custom_05], [s_delivery_type_desc_custom_05], [s_delivery_type_name_custom_06], [s_delivery_type_desc_custom_06], [s_delivery_type_name_custom_07], [s_delivery_type_desc_custom_07], [s_delivery_type_name_custom_08], [s_delivery_type_desc_custom_08], [s_delivery_type_name_custom_09], [s_delivery_type_desc_custom_09], [s_delivery_type_name_custom_10], [s_delivery_type_desc_custom_10], [s_delivery_type_name_custom_11], [s_delivery_type_desc_custom_11], [s_delivery_type_name_custom_12], [s_delivery_type_desc_custom_12], [s_delivery_type_name_custom_13], [s_delivery_type_desc_custom_13], [s_delivery_type_name_simp_chinese], [s_delivery_type_desc_simp_chinese]) VALUES (N'04602917-c080-4f38-b603-a1f3ff628ed0', N'Exam', N'Exam', N'Exam', N'app_ddl_active_text', N'79e43468-f375-447e-9644-11b6bb988d03', 6, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', NULL, NULL)
INSERT [dbo].[s_tb_delivery_types] ([s_delivery_type_system_id_pk], [s_delivery_type_id], [s_delivery_type_name_us_english], [s_delivery_type_desc_us_english], [s_delivery_type_status_id_fk], [s_delivery_type_mode_id_fk], [s_delivery_type_order], [s_delivery_type_name_uk_english], [s_delivery_type_desc_uk_english], [s_delivery_type_name_ca_french], [s_delivery_type_desc_ca_french], [s_delivery_type_name_fr_french], [s_delivery_type_desc_fr_french], [s_delivery_type_name_mx_spanish], [s_delivery_type_desc_mx_spanish], [s_delivery_type_name_sp_spanish], [s_delivery_type_desc_sp_spanish], [s_delivery_type_name_portuguese], [s_delivery_type_desc_portuguese], [s_delivery_type_name_german], [s_delivery_type_desc_german], [s_delivery_type_name_japanese], [s_delivery_type_desc_japanese], [s_delivery_type_name_russian], [s_delivery_type_desc_russian], [s_delivery_type_name_danish], [s_delivery_type_desc_danish], [s_delivery_type_name_polish], [s_delivery_type_desc_polish], [s_delivery_type_name_swedish], [s_delivery_type_desc_swedish], [s_delivery_type_name_finnish], [s_delivery_type_desc_finnish], [s_delivery_type_name_korean], [s_delivery_type_desc_korean], [s_delivery_type_name_italian], [s_delivery_type_desc_italian], [s_delivery_type_name_dutch], [s_delivery_type_desc_dutch], [s_delivery_type_name_indonesian], [s_delivery_type_desc_indonesian], [s_delivery_type_name_greek], [s_delivery_type_desc_greek], [s_delivery_type_name_hungarian], [s_delivery_type_desc_hungarian], [s_delivery_type_name_norwegian], [s_delivery_type_desc_norwegian], [s_delivery_type_name_turkish], [s_delivery_type_desc_turkish], [s_delivery_type_name_arabic_rtl], [s_delivery_type_desc_arabic_rtl], [s_delivery_type_name_custom_01], [s_delivery_type_desc_custom_01], [s_delivery_type_name_custom_02], [s_delivery_type_desc_custom_02], [s_delivery_type_name_custom_03], [s_delivery_type_desc_custom_03], [s_delivery_type_name_custom_04], [s_delivery_type_desc_custom_04], [s_delivery_type_name_custom_05], [s_delivery_type_desc_custom_05], [s_delivery_type_name_custom_06], [s_delivery_type_desc_custom_06], [s_delivery_type_name_custom_07], [s_delivery_type_desc_custom_07], [s_delivery_type_name_custom_08], [s_delivery_type_desc_custom_08], [s_delivery_type_name_custom_09], [s_delivery_type_desc_custom_09], [s_delivery_type_name_custom_10], [s_delivery_type_desc_custom_10], [s_delivery_type_name_custom_11], [s_delivery_type_desc_custom_11], [s_delivery_type_name_custom_12], [s_delivery_type_desc_custom_12], [s_delivery_type_name_custom_13], [s_delivery_type_desc_custom_13], [s_delivery_type_name_simp_chinese], [s_delivery_type_desc_simp_chinese]) VALUES (N'9ad817b9-cb2c-46a1-a898-aecc785c20f4', N'SLM01', N'SLM 01', N'new SLM 01', N'app_ddl_inactive_text', N'137d32ea-7f55-48a9-801d-757dae796fe5', 2147483647, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'')
INSERT [dbo].[s_tb_delivery_types] ([s_delivery_type_system_id_pk], [s_delivery_type_id], [s_delivery_type_name_us_english], [s_delivery_type_desc_us_english], [s_delivery_type_status_id_fk], [s_delivery_type_mode_id_fk], [s_delivery_type_order], [s_delivery_type_name_uk_english], [s_delivery_type_desc_uk_english], [s_delivery_type_name_ca_french], [s_delivery_type_desc_ca_french], [s_delivery_type_name_fr_french], [s_delivery_type_desc_fr_french], [s_delivery_type_name_mx_spanish], [s_delivery_type_desc_mx_spanish], [s_delivery_type_name_sp_spanish], [s_delivery_type_desc_sp_spanish], [s_delivery_type_name_portuguese], [s_delivery_type_desc_portuguese], [s_delivery_type_name_german], [s_delivery_type_desc_german], [s_delivery_type_name_japanese], [s_delivery_type_desc_japanese], [s_delivery_type_name_russian], [s_delivery_type_desc_russian], [s_delivery_type_name_danish], [s_delivery_type_desc_danish], [s_delivery_type_name_polish], [s_delivery_type_desc_polish], [s_delivery_type_name_swedish], [s_delivery_type_desc_swedish], [s_delivery_type_name_finnish], [s_delivery_type_desc_finnish], [s_delivery_type_name_korean], [s_delivery_type_desc_korean], [s_delivery_type_name_italian], [s_delivery_type_desc_italian], [s_delivery_type_name_dutch], [s_delivery_type_desc_dutch], [s_delivery_type_name_indonesian], [s_delivery_type_desc_indonesian], [s_delivery_type_name_greek], [s_delivery_type_desc_greek], [s_delivery_type_name_hungarian], [s_delivery_type_desc_hungarian], [s_delivery_type_name_norwegian], [s_delivery_type_desc_norwegian], [s_delivery_type_name_turkish], [s_delivery_type_desc_turkish], [s_delivery_type_name_arabic_rtl], [s_delivery_type_desc_arabic_rtl], [s_delivery_type_name_custom_01], [s_delivery_type_desc_custom_01], [s_delivery_type_name_custom_02], [s_delivery_type_desc_custom_02], [s_delivery_type_name_custom_03], [s_delivery_type_desc_custom_03], [s_delivery_type_name_custom_04], [s_delivery_type_desc_custom_04], [s_delivery_type_name_custom_05], [s_delivery_type_desc_custom_05], [s_delivery_type_name_custom_06], [s_delivery_type_desc_custom_06], [s_delivery_type_name_custom_07], [s_delivery_type_desc_custom_07], [s_delivery_type_name_custom_08], [s_delivery_type_desc_custom_08], [s_delivery_type_name_custom_09], [s_delivery_type_desc_custom_09], [s_delivery_type_name_custom_10], [s_delivery_type_desc_custom_10], [s_delivery_type_name_custom_11], [s_delivery_type_desc_custom_11], [s_delivery_type_name_custom_12], [s_delivery_type_desc_custom_12], [s_delivery_type_name_custom_13], [s_delivery_type_desc_custom_13], [s_delivery_type_name_simp_chinese], [s_delivery_type_desc_simp_chinese]) VALUES (N'901cbe03-1f0b-4510-9ff0-b1d58453e651', N'Checklist', N'Checklist', N'Checklist', N'app_ddl_active_text', N'79e43468-f375-447e-9644-11b6bb988d03', 11, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', NULL, NULL)
INSERT [dbo].[s_tb_delivery_types] ([s_delivery_type_system_id_pk], [s_delivery_type_id], [s_delivery_type_name_us_english], [s_delivery_type_desc_us_english], [s_delivery_type_status_id_fk], [s_delivery_type_mode_id_fk], [s_delivery_type_order], [s_delivery_type_name_uk_english], [s_delivery_type_desc_uk_english], [s_delivery_type_name_ca_french], [s_delivery_type_desc_ca_french], [s_delivery_type_name_fr_french], [s_delivery_type_desc_fr_french], [s_delivery_type_name_mx_spanish], [s_delivery_type_desc_mx_spanish], [s_delivery_type_name_sp_spanish], [s_delivery_type_desc_sp_spanish], [s_delivery_type_name_portuguese], [s_delivery_type_desc_portuguese], [s_delivery_type_name_german], [s_delivery_type_desc_german], [s_delivery_type_name_japanese], [s_delivery_type_desc_japanese], [s_delivery_type_name_russian], [s_delivery_type_desc_russian], [s_delivery_type_name_danish], [s_delivery_type_desc_danish], [s_delivery_type_name_polish], [s_delivery_type_desc_polish], [s_delivery_type_name_swedish], [s_delivery_type_desc_swedish], [s_delivery_type_name_finnish], [s_delivery_type_desc_finnish], [s_delivery_type_name_korean], [s_delivery_type_desc_korean], [s_delivery_type_name_italian], [s_delivery_type_desc_italian], [s_delivery_type_name_dutch], [s_delivery_type_desc_dutch], [s_delivery_type_name_indonesian], [s_delivery_type_desc_indonesian], [s_delivery_type_name_greek], [s_delivery_type_desc_greek], [s_delivery_type_name_hungarian], [s_delivery_type_desc_hungarian], [s_delivery_type_name_norwegian], [s_delivery_type_desc_norwegian], [s_delivery_type_name_turkish], [s_delivery_type_desc_turkish], [s_delivery_type_name_arabic_rtl], [s_delivery_type_desc_arabic_rtl], [s_delivery_type_name_custom_01], [s_delivery_type_desc_custom_01], [s_delivery_type_name_custom_02], [s_delivery_type_desc_custom_02], [s_delivery_type_name_custom_03], [s_delivery_type_desc_custom_03], [s_delivery_type_name_custom_04], [s_delivery_type_desc_custom_04], [s_delivery_type_name_custom_05], [s_delivery_type_desc_custom_05], [s_delivery_type_name_custom_06], [s_delivery_type_desc_custom_06], [s_delivery_type_name_custom_07], [s_delivery_type_desc_custom_07], [s_delivery_type_name_custom_08], [s_delivery_type_desc_custom_08], [s_delivery_type_name_custom_09], [s_delivery_type_desc_custom_09], [s_delivery_type_name_custom_10], [s_delivery_type_desc_custom_10], [s_delivery_type_name_custom_11], [s_delivery_type_desc_custom_11], [s_delivery_type_name_custom_12], [s_delivery_type_desc_custom_12], [s_delivery_type_name_custom_13], [s_delivery_type_desc_custom_13], [s_delivery_type_name_simp_chinese], [s_delivery_type_desc_simp_chinese]) VALUES (N'8230706c-6f7c-496c-8704-bc6ad2e97f22', N'ILT', N'ILT', N'Instructor-Led Classroom Training', N'app_ddl_active_text', N'79e43468-f375-447e-9644-11b6bb988d03', 2, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', NULL, NULL)
INSERT [dbo].[s_tb_delivery_types] ([s_delivery_type_system_id_pk], [s_delivery_type_id], [s_delivery_type_name_us_english], [s_delivery_type_desc_us_english], [s_delivery_type_status_id_fk], [s_delivery_type_mode_id_fk], [s_delivery_type_order], [s_delivery_type_name_uk_english], [s_delivery_type_desc_uk_english], [s_delivery_type_name_ca_french], [s_delivery_type_desc_ca_french], [s_delivery_type_name_fr_french], [s_delivery_type_desc_fr_french], [s_delivery_type_name_mx_spanish], [s_delivery_type_desc_mx_spanish], [s_delivery_type_name_sp_spanish], [s_delivery_type_desc_sp_spanish], [s_delivery_type_name_portuguese], [s_delivery_type_desc_portuguese], [s_delivery_type_name_german], [s_delivery_type_desc_german], [s_delivery_type_name_japanese], [s_delivery_type_desc_japanese], [s_delivery_type_name_russian], [s_delivery_type_desc_russian], [s_delivery_type_name_danish], [s_delivery_type_desc_danish], [s_delivery_type_name_polish], [s_delivery_type_desc_polish], [s_delivery_type_name_swedish], [s_delivery_type_desc_swedish], [s_delivery_type_name_finnish], [s_delivery_type_desc_finnish], [s_delivery_type_name_korean], [s_delivery_type_desc_korean], [s_delivery_type_name_italian], [s_delivery_type_desc_italian], [s_delivery_type_name_dutch], [s_delivery_type_desc_dutch], [s_delivery_type_name_indonesian], [s_delivery_type_desc_indonesian], [s_delivery_type_name_greek], [s_delivery_type_desc_greek], [s_delivery_type_name_hungarian], [s_delivery_type_desc_hungarian], [s_delivery_type_name_norwegian], [s_delivery_type_desc_norwegian], [s_delivery_type_name_turkish], [s_delivery_type_desc_turkish], [s_delivery_type_name_arabic_rtl], [s_delivery_type_desc_arabic_rtl], [s_delivery_type_name_custom_01], [s_delivery_type_desc_custom_01], [s_delivery_type_name_custom_02], [s_delivery_type_desc_custom_02], [s_delivery_type_name_custom_03], [s_delivery_type_desc_custom_03], [s_delivery_type_name_custom_04], [s_delivery_type_desc_custom_04], [s_delivery_type_name_custom_05], [s_delivery_type_desc_custom_05], [s_delivery_type_name_custom_06], [s_delivery_type_desc_custom_06], [s_delivery_type_name_custom_07], [s_delivery_type_desc_custom_07], [s_delivery_type_name_custom_08], [s_delivery_type_desc_custom_08], [s_delivery_type_name_custom_09], [s_delivery_type_desc_custom_09], [s_delivery_type_name_custom_10], [s_delivery_type_desc_custom_10], [s_delivery_type_name_custom_11], [s_delivery_type_desc_custom_11], [s_delivery_type_name_custom_12], [s_delivery_type_desc_custom_12], [s_delivery_type_name_custom_13], [s_delivery_type_desc_custom_13], [s_delivery_type_name_simp_chinese], [s_delivery_type_desc_simp_chinese]) VALUES (N'2f1bc074-13e0-4f0a-b242-d40798a25ad1', N'Survey', N'Survey', N'Survey', N'app_ddl_active_text', N'79e43468-f375-447e-9644-11b6bb988d03', 9, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', NULL, NULL)
INSERT [dbo].[s_tb_delivery_types] ([s_delivery_type_system_id_pk], [s_delivery_type_id], [s_delivery_type_name_us_english], [s_delivery_type_desc_us_english], [s_delivery_type_status_id_fk], [s_delivery_type_mode_id_fk], [s_delivery_type_order], [s_delivery_type_name_uk_english], [s_delivery_type_desc_uk_english], [s_delivery_type_name_ca_french], [s_delivery_type_desc_ca_french], [s_delivery_type_name_fr_french], [s_delivery_type_desc_fr_french], [s_delivery_type_name_mx_spanish], [s_delivery_type_desc_mx_spanish], [s_delivery_type_name_sp_spanish], [s_delivery_type_desc_sp_spanish], [s_delivery_type_name_portuguese], [s_delivery_type_desc_portuguese], [s_delivery_type_name_german], [s_delivery_type_desc_german], [s_delivery_type_name_japanese], [s_delivery_type_desc_japanese], [s_delivery_type_name_russian], [s_delivery_type_desc_russian], [s_delivery_type_name_danish], [s_delivery_type_desc_danish], [s_delivery_type_name_polish], [s_delivery_type_desc_polish], [s_delivery_type_name_swedish], [s_delivery_type_desc_swedish], [s_delivery_type_name_finnish], [s_delivery_type_desc_finnish], [s_delivery_type_name_korean], [s_delivery_type_desc_korean], [s_delivery_type_name_italian], [s_delivery_type_desc_italian], [s_delivery_type_name_dutch], [s_delivery_type_desc_dutch], [s_delivery_type_name_indonesian], [s_delivery_type_desc_indonesian], [s_delivery_type_name_greek], [s_delivery_type_desc_greek], [s_delivery_type_name_hungarian], [s_delivery_type_desc_hungarian], [s_delivery_type_name_norwegian], [s_delivery_type_desc_norwegian], [s_delivery_type_name_turkish], [s_delivery_type_desc_turkish], [s_delivery_type_name_arabic_rtl], [s_delivery_type_desc_arabic_rtl], [s_delivery_type_name_custom_01], [s_delivery_type_desc_custom_01], [s_delivery_type_name_custom_02], [s_delivery_type_desc_custom_02], [s_delivery_type_name_custom_03], [s_delivery_type_desc_custom_03], [s_delivery_type_name_custom_04], [s_delivery_type_desc_custom_04], [s_delivery_type_name_custom_05], [s_delivery_type_desc_custom_05], [s_delivery_type_name_custom_06], [s_delivery_type_desc_custom_06], [s_delivery_type_name_custom_07], [s_delivery_type_desc_custom_07], [s_delivery_type_name_custom_08], [s_delivery_type_desc_custom_08], [s_delivery_type_name_custom_09], [s_delivery_type_desc_custom_09], [s_delivery_type_name_custom_10], [s_delivery_type_desc_custom_10], [s_delivery_type_name_custom_11], [s_delivery_type_desc_custom_11], [s_delivery_type_name_custom_12], [s_delivery_type_desc_custom_12], [s_delivery_type_name_custom_13], [s_delivery_type_desc_custom_13], [s_delivery_type_name_simp_chinese], [s_delivery_type_desc_simp_chinese]) VALUES (N'c84f1408-4314-4cf4-8ea4-ee8089b22f46', N'Observation', N'Observation', N'Observation', N'app_ddl_active_text', N'79e43468-f375-447e-9644-11b6bb988d03', 10, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', NULL, NULL)
INSERT [dbo].[s_tb_delivery_types] ([s_delivery_type_system_id_pk], [s_delivery_type_id], [s_delivery_type_name_us_english], [s_delivery_type_desc_us_english], [s_delivery_type_status_id_fk], [s_delivery_type_mode_id_fk], [s_delivery_type_order], [s_delivery_type_name_uk_english], [s_delivery_type_desc_uk_english], [s_delivery_type_name_ca_french], [s_delivery_type_desc_ca_french], [s_delivery_type_name_fr_french], [s_delivery_type_desc_fr_french], [s_delivery_type_name_mx_spanish], [s_delivery_type_desc_mx_spanish], [s_delivery_type_name_sp_spanish], [s_delivery_type_desc_sp_spanish], [s_delivery_type_name_portuguese], [s_delivery_type_desc_portuguese], [s_delivery_type_name_german], [s_delivery_type_desc_german], [s_delivery_type_name_japanese], [s_delivery_type_desc_japanese], [s_delivery_type_name_russian], [s_delivery_type_desc_russian], [s_delivery_type_name_danish], [s_delivery_type_desc_danish], [s_delivery_type_name_polish], [s_delivery_type_desc_polish], [s_delivery_type_name_swedish], [s_delivery_type_desc_swedish], [s_delivery_type_name_finnish], [s_delivery_type_desc_finnish], [s_delivery_type_name_korean], [s_delivery_type_desc_korean], [s_delivery_type_name_italian], [s_delivery_type_desc_italian], [s_delivery_type_name_dutch], [s_delivery_type_desc_dutch], [s_delivery_type_name_indonesian], [s_delivery_type_desc_indonesian], [s_delivery_type_name_greek], [s_delivery_type_desc_greek], [s_delivery_type_name_hungarian], [s_delivery_type_desc_hungarian], [s_delivery_type_name_norwegian], [s_delivery_type_desc_norwegian], [s_delivery_type_name_turkish], [s_delivery_type_desc_turkish], [s_delivery_type_name_arabic_rtl], [s_delivery_type_desc_arabic_rtl], [s_delivery_type_name_custom_01], [s_delivery_type_desc_custom_01], [s_delivery_type_name_custom_02], [s_delivery_type_desc_custom_02], [s_delivery_type_name_custom_03], [s_delivery_type_desc_custom_03], [s_delivery_type_name_custom_04], [s_delivery_type_desc_custom_04], [s_delivery_type_name_custom_05], [s_delivery_type_desc_custom_05], [s_delivery_type_name_custom_06], [s_delivery_type_desc_custom_06], [s_delivery_type_name_custom_07], [s_delivery_type_desc_custom_07], [s_delivery_type_name_custom_08], [s_delivery_type_desc_custom_08], [s_delivery_type_name_custom_09], [s_delivery_type_desc_custom_09], [s_delivery_type_name_custom_10], [s_delivery_type_desc_custom_10], [s_delivery_type_name_custom_11], [s_delivery_type_desc_custom_11], [s_delivery_type_name_custom_12], [s_delivery_type_desc_custom_12], [s_delivery_type_name_custom_13], [s_delivery_type_desc_custom_13], [s_delivery_type_name_simp_chinese], [s_delivery_type_desc_simp_chinese]) VALUES (N'c8932298-2d41-4083-8b9c-f38028da9eee', N'SLM01_Copy', N'SLM 01', N'new SLM 01', N'app_ddl_inactive_text', N'137d32ea-7f55-48a9-801d-757dae796fe5', 2147483647, N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'', N'')
/****** Object:  Default [DF_s_tb_delivery_types_s_delivery_type_order]    Script Date: 11/21/2013 19:50:27 ******/
ALTER TABLE [dbo].[s_tb_delivery_types] ADD  CONSTRAINT [DF_s_tb_delivery_types_s_delivery_type_order]  DEFAULT ((2147483647)) FOR [s_delivery_type_order]
GO
ryanammons commented 10 years ago

The changes have been applied to the database and are reflected in the production app.