CREATE TABLE [dbo].[mbl_opt](
	[site_cd] [varchar](4) NOT NULL,
	[mbl_opt_service] [varchar](30) NULL,
	[mbl_opt_seq] [numeric](12, 0) NULL,
	[mbl_opt_more_name] [varchar](50) NULL,
	[mbl_opt_disable] [varchar](1) NULL,
	[audit_user] [varchar](50) NOT NULL,
	[audit_date] [datetime] NOT NULL,
	[column1] [varchar](60) NULL,
	[column2] [varchar](60) NULL,
	[column3] [varchar](60) NULL,
	[column4] [varchar](60) NULL,
	[column5] [varchar](60) NULL,
	[RowID] [numeric](12, 0) IDENTITY(1,1) NOT NULL
) ON [PRIMARY]
GO

Insert into mbl_opt (site_cd, mbl_opt_service, mbl_opt_seq,  mbl_opt_more_name,  mbl_opt_disable, audit_user, audit_date) Values ('B05', 'FEMS', 1, 'Acknowledgement', '1', 'admin', getdate())
Insert into mbl_opt (site_cd, mbl_opt_service, mbl_opt_seq,  mbl_opt_more_name,  mbl_opt_disable, audit_user, audit_date) Values ('B05', 'FEMS', 2, 'WO Completion', '1', 'admin', getdate())
Insert into mbl_opt (site_cd, mbl_opt_service, mbl_opt_seq,  mbl_opt_more_name,  mbl_opt_disable, audit_user, audit_date) Values ('B05', 'FEMS', 3, 'Timecard', '1', 'admin', getdate())
Insert into mbl_opt (site_cd, mbl_opt_service, mbl_opt_seq,  mbl_opt_more_name,  mbl_opt_disable, audit_user, audit_date) Values ('B05', 'FEMS', 4, 'Material Request', '1', 'admin', getdate())
Insert into mbl_opt (site_cd, mbl_opt_service, mbl_opt_seq,  mbl_opt_more_name,  mbl_opt_disable, audit_user, audit_date) Values ('B05', 'FEMS', 5, 'Contract Request', '1', 'admin', getdate())
Insert into mbl_opt (site_cd, mbl_opt_service, mbl_opt_seq,  mbl_opt_more_name,  mbl_opt_disable, audit_user, audit_date) Values ('B05', 'FEMS', 6, 'PPM Reschedule', '1', 'admin', getdate())
Insert into mbl_opt (site_cd, mbl_opt_service, mbl_opt_seq,  mbl_opt_more_name,  mbl_opt_disable, audit_user, audit_date) Values ('B05', 'FEMS', 7, 'Create Sub Work Order', '1', 'admin', getdate())

Insert into mbl_opt (site_cd, mbl_opt_service, mbl_opt_seq,  mbl_opt_more_name,  mbl_opt_disable, audit_user, audit_date) Values ('B05', 'BEMS', 1, 'Acknowledgement', '1', 'admin', getdate())
Insert into mbl_opt (site_cd, mbl_opt_service, mbl_opt_seq,  mbl_opt_more_name,  mbl_opt_disable, audit_user, audit_date) Values ('B05', 'BEMS', 2, 'WO Completion', '1', 'admin', getdate())
Insert into mbl_opt (site_cd, mbl_opt_service, mbl_opt_seq,  mbl_opt_more_name,  mbl_opt_disable, audit_user, audit_date) Values ('B05', 'BEMS', 3, 'Timecard', '1', 'admin', getdate())
Insert into mbl_opt (site_cd, mbl_opt_service, mbl_opt_seq,  mbl_opt_more_name,  mbl_opt_disable, audit_user, audit_date) Values ('B05', 'BEMS', 4, 'Material Request', '1', 'admin', getdate())
Insert into mbl_opt (site_cd, mbl_opt_service, mbl_opt_seq,  mbl_opt_more_name,  mbl_opt_disable, audit_user, audit_date) Values ('B05', 'BEMS', 5, 'Contract Request', '1', 'admin', getdate())
Insert into mbl_opt (site_cd, mbl_opt_service, mbl_opt_seq,  mbl_opt_more_name,  mbl_opt_disable, audit_user, audit_date) Values ('B05', 'BEMS', 6, 'PPM Reschedule', '1', 'admin', getdate())
Insert into mbl_opt (site_cd, mbl_opt_service, mbl_opt_seq,  mbl_opt_more_name,  mbl_opt_disable, audit_user, audit_date) Values ('B05', 'BEMS', 7, 'Create Sub Work Order', '1', 'admin', getdate())
Insert into mbl_opt (site_cd, mbl_opt_service, mbl_opt_seq,  mbl_opt_more_name,  mbl_opt_disable, audit_user, audit_date) Values ('B05', 'BEMS', 8, 'BEMS Safety And Performance Test', '1', 'admin', getdate())
Insert into mbl_opt (site_cd, mbl_opt_service, mbl_opt_seq,  mbl_opt_more_name,  mbl_opt_disable, audit_user, audit_date) Values ('B05', 'BEMS', 9, 'Chargeable', '1', 'admin', getdate())
Insert into mbl_opt (site_cd, mbl_opt_service, mbl_opt_seq,  mbl_opt_more_name,  mbl_opt_disable, audit_user, audit_date) Values ('B05', 'BEMS', 10, 'Check List', '1', 'admin', getdate())


Insert into mbl_opt (site_cd, mbl_opt_service, mbl_opt_seq,  mbl_opt_more_name,  mbl_opt_disable, audit_user, audit_date) Values ('B05', 'ICT', 1, 'Acknowledgement', '1', 'admin', getdate())
Insert into mbl_opt (site_cd, mbl_opt_service, mbl_opt_seq,  mbl_opt_more_name,  mbl_opt_disable, audit_user, audit_date) Values ('B05', 'ICT', 2, 'WO Completion', '1', 'admin', getdate())
Insert into mbl_opt (site_cd, mbl_opt_service, mbl_opt_seq,  mbl_opt_more_name,  mbl_opt_disable, audit_user, audit_date) Values ('B05', 'ICT', 3, 'Timecard', '1', 'admin', getdate())
Insert into mbl_opt (site_cd, mbl_opt_service, mbl_opt_seq,  mbl_opt_more_name,  mbl_opt_disable, audit_user, audit_date) Values ('B05', 'ICT', 4, 'Material Request', '1', 'admin', getdate())
Insert into mbl_opt (site_cd, mbl_opt_service, mbl_opt_seq,  mbl_opt_more_name,  mbl_opt_disable, audit_user, audit_date) Values ('B05', 'ICT', 5, 'Contract Request', '1', 'admin', getdate())
Insert into mbl_opt (site_cd, mbl_opt_service, mbl_opt_seq,  mbl_opt_more_name,  mbl_opt_disable, audit_user, audit_date) Values ('B05', 'ICT', 6, 'PPM Reschedule', '1', 'admin', getdate())
Insert into mbl_opt (site_cd, mbl_opt_service, mbl_opt_seq,  mbl_opt_more_name,  mbl_opt_disable, audit_user, audit_date) Values ('B05', 'ICT', 7, 'Create Sub Work Order', '1', 'admin', getdate())

Insert into mbl_opt (site_cd, mbl_opt_service, mbl_opt_seq,  mbl_opt_more_name,  mbl_opt_disable, audit_user, audit_date) Values ('B05', 'CLS', 1, 'Acknowledgement', '1', 'admin', getdate())
Insert into mbl_opt (site_cd, mbl_opt_service, mbl_opt_seq,  mbl_opt_more_name,  mbl_opt_disable, audit_user, audit_date) Values ('B05', 'CLS', 2, 'WO Completion', '1', 'admin', getdate())
Insert into mbl_opt (site_cd, mbl_opt_service, mbl_opt_seq,  mbl_opt_more_name,  mbl_opt_disable, audit_user, audit_date) Values ('B05', 'CLS', 3, 'Timecard', '1', 'admin', getdate())
Insert into mbl_opt (site_cd, mbl_opt_service, mbl_opt_seq,  mbl_opt_more_name,  mbl_opt_disable, audit_user, audit_date) Values ('B05', 'CLS', 4, 'Material Request', '1', 'admin', getdate())
Insert into mbl_opt (site_cd, mbl_opt_service, mbl_opt_seq,  mbl_opt_more_name,  mbl_opt_disable, audit_user, audit_date) Values ('B05', 'CLS', 5, 'Contract Request', '1', 'admin', getdate())
Insert into mbl_opt (site_cd, mbl_opt_service, mbl_opt_seq,  mbl_opt_more_name,  mbl_opt_disable, audit_user, audit_date) Values ('B05', 'CLS', 6, 'PPM Reschedule', '1', 'admin', getdate())
Insert into mbl_opt (site_cd, mbl_opt_service, mbl_opt_seq,  mbl_opt_more_name,  mbl_opt_disable, audit_user, audit_date) Values ('B05', 'CLS', 7, 'Create Sub Work Order', '1', 'admin', getdate())

Insert into mbl_opt (site_cd, mbl_opt_service, mbl_opt_seq,  mbl_opt_more_name,  mbl_opt_disable, audit_user, audit_date) Values ('B05', 'HWMS', 1, 'Acknowledgement', '1', 'admin', getdate())
Insert into mbl_opt (site_cd, mbl_opt_service, mbl_opt_seq,  mbl_opt_more_name,  mbl_opt_disable, audit_user, audit_date) Values ('B05', 'HWMS', 2, 'WO Completion', '1', 'admin', getdate())
Insert into mbl_opt (site_cd, mbl_opt_service, mbl_opt_seq,  mbl_opt_more_name,  mbl_opt_disable, audit_user, audit_date) Values ('B05', 'HWMS', 3, 'Timecard', '1', 'admin', getdate())
Insert into mbl_opt (site_cd, mbl_opt_service, mbl_opt_seq,  mbl_opt_more_name,  mbl_opt_disable, audit_user, audit_date) Values ('B05', 'HWMS', 4, 'Material Request', '1', 'admin', getdate())
Insert into mbl_opt (site_cd, mbl_opt_service, mbl_opt_seq,  mbl_opt_more_name,  mbl_opt_disable, audit_user, audit_date) Values ('B05', 'HWMS', 5, 'Contract Request', '1', 'admin', getdate())
Insert into mbl_opt (site_cd, mbl_opt_service, mbl_opt_seq,  mbl_opt_more_name,  mbl_opt_disable, audit_user, audit_date) Values ('B05', 'HWMS', 6, 'PPM Reschedule', '1', 'admin', getdate())
Insert into mbl_opt (site_cd, mbl_opt_service, mbl_opt_seq,  mbl_opt_more_name,  mbl_opt_disable, audit_user, audit_date) Values ('B05', 'HWMS', 7, 'Create Sub Work Order', '1', 'admin', getdate())