OPMS/02-系統分析、設計階段/DBScript/20141014/insertIntoSysAndInsertPro.sql

--���J�M���v���Ҳժ��Ѽ�
INSERT INTO dbo.OTB_SYS_SystemSetting
        ( OrganizationID ,
          SettingItem ,
          SettingDescription ,
          SettingValue ,
          Memo ,
          Effective ,
          CreateUser ,
          CreateDate ,
          ModifyUser ,
          ModifyDate
        )
VALUES  ( 'Origtek' , -- OrganizationID - varchar(50)
          N'PrjAuthMod' , -- SettingItem - nvarchar(50)
          N'�M���v���Ҳ�' , -- SettingDescription - nvarchar(100)
          N'DEV;PRJ;' , -- SettingValue - nvarchar(400)
          '' , -- Memo - text
          'Y' , -- Effective - char(1)
          'apadmin' , -- CreateUser - varchar(50)
          GETDATE(), -- CreateDate - datetime
          'apadmin' , -- ModifyUser - varchar(50)
          GETDATE()  -- ModifyDate - datetime
        )
        
  --���J�M�׵{�����v�s���{��
INSERT INTO  dbo.OTB_SYS_ProgramList
        ( OrganizationID ,
          ProgramID ,
          LanguageID ,
          ProgramName ,
          ModuleID ,
          FilePath ,
          ImgPath ,
          AllowRight ,
          OrderByValue ,
          ProgramType ,
          BackgroundCSS ,
          GroupTag ,
          Effective ,
          ShowInList ,
          MainTableName ,
          Memo ,
          CreateUser ,
          CreateDate ,
          ModifyUser ,
          ModifyDate
        )
VALUES  ( 'Origtek' , -- OrganizationID - varchar(50)
          N'WorkAuthorizePrograms' , -- ProgramID - nvarchar(200)
          N'zh-TW' , -- LanguageID - nvarchar(50)
          N'�M�׵{�����v�s��' , -- ProgramName - nvarchar(100)
          'PRJ' , -- ModuleID - varchar(10)
          N'Page/PRJ/WorkAuthorizePrograms.aspx' , -- FilePath - nvarchar(500)
          N'setting2' , -- ImgPath - nvarchar(500)
          'Upd|Save|Qry|View                                                                                                                                                                                       ' , -- AllowRight - char(200)
          (SELECT COUNT(0)+1 FROM dbo.OTB_SYS_ProgramList WHERE ModuleID='PRJ') , -- OrderByValue - int
          'P' , -- ProgramType - varchar(1)
          'blue-box' , -- BackgroundCSS - varchar(50)
          N'' , -- GroupTag - nvarchar(200)
          'Y' , -- Effective - char(1)
          'Y' , -- ShowInList - char(1)
          'OTB_PRJ_WorkAuthorize' , -- MainTableName - varchar(50)
          '' , -- Memo - text
          'apadmin' , -- CreateUser - varchar(50)
          GETDATE() , -- CreateDate - datetime
          'apadmin' , -- ModifyUser - varchar(50)
          GETDATE()  -- ModifyDate - datetime
        )


--���J�M�׵{�����v�s���v��

INSERT INTO dbo.OTB_SYS_Authorize
        ( OrganizationID ,
          RuleID ,
          ProgramID ,
          AllowRight ,
          Memo ,
          CreateUser ,
          CreateDate ,
          ModifyUser ,
          ModifyDate
        )
VALUES  ( 'Origtek' , -- OrganizationID - varchar(50)
          'Admin' , -- RuleID - varchar(20)
          'WorkAuthorizePrograms' , -- ProgramID - varchar(200)
          'Save|Upd|Qry|View                                                                                                                                                                                       ' , -- AllowRight - char(200)
          '' , -- Memo - text
          'apadmin' , -- CreateUser - varchar(50)
          GETDATE() , -- CreateDate - datetime
          'apadmin' , -- ModifyUser - varchar(50)
          GETDATE()  -- ModifyDate - datetime
        )

--���J�M�׽ƻs�v���{��
INSERT INTO  dbo.OTB_SYS_ProgramList
        ( OrganizationID ,
          ProgramID ,
          LanguageID ,
          ProgramName ,
          ModuleID ,
          FilePath ,
          ImgPath ,
          AllowRight ,
          OrderByValue ,
          ProgramType ,
          BackgroundCSS ,
          GroupTag ,
          Effective ,
          ShowInList ,
          MainTableName ,
          Memo ,
          CreateUser ,
          CreateDate ,
          ModifyUser ,
          ModifyDate
        )
VALUES  ( 'Origtek' , -- OrganizationID - varchar(50)
          N'PrjCopyRight_Pop' , -- ProgramID - nvarchar(200)
          N'zh-TW' , -- LanguageID - nvarchar(50)
          N'�M�׽ƻs�v��' , -- ProgramName - nvarchar(100)
          'PRJ' , -- ModuleID - varchar(10)
          N'Page/Utl/PrjCopyRight_Pop.aspx' , -- FilePath - nvarchar(500)
          N'setting2' , -- ImgPath - nvarchar(500)
          'View|Upd',
          (SELECT COUNT(0)+1 FROM dbo.OTB_SYS_ProgramList WHERE ModuleID='PRJ') , -- OrderByValue - int
          'S' , -- ProgramType - varchar(1)
          '-box' , -- BackgroundCSS - varchar(50)
          N'PrjCopyRight' , -- GroupTag - nvarchar(200)
          'Y' , -- Effective - char(1)
          'N' , -- ShowInList - char(1)
          '' , -- MainTableName - varchar(50)
          '' , -- Memo - text
          'apadmin' , -- CreateUser - varchar(50)
          GETDATE() , -- CreateDate - datetime
          'apadmin' , -- ModifyUser - varchar(50)
          GETDATE()  -- ModifyDate - datetime
        )


--���J�׽ƻs�v���v��

INSERT INTO dbo.OTB_SYS_Authorize
        ( OrganizationID ,
          RuleID ,
          ProgramID ,
          AllowRight ,
          Memo ,
          CreateUser ,
          CreateDate ,
          ModifyUser ,
          ModifyDate
        )
VALUES  ( 'Origtek' , -- OrganizationID - varchar(50)
          'Admin' , -- RuleID - varchar(20)
          'PrjCopyRight_Pop' , -- ProgramID - varchar(200)
          'View|Upd',
          '' , -- Memo - text
          'apadmin' , -- CreateUser - varchar(50)
          GETDATE() , -- CreateDate - datetime
          'apadmin' , -- ModifyUser - varchar(50)
          GETDATE()  -- ModifyDate - datetime
        )