zhengcaioa.git - Gitblit

New file
			@@ -0,0 +1,37 @@
			use zhengcaioa

			if exists (select 1
			from sysobjects
			where id = object_id('t_salary_appeal')
			and type = 'U')
			drop table t_salary_appeal
			go

			/==============================================================/
			/* Table: t_salary_appeal */
			/==============================================================/
			create table t_salary_appeal (
			id int identity,
			salary_id nvarchar(50) null,
			reason nvarchar(1000) null,
			amount decimal(10,2) null,
			basis nvarchar(500) null,
			sub_user nvarchar(50) null,
			sub_time datetime null,
			chk_user nvarchar(50) null,
			chk_time datetime null,
			chk_result nvarchar(1000) null,
			status nvarchar(1) null,
			constraint PK_T_SALARY_APPEAL primary key (id)
			)
			go


			INSERT [dbo].[plt_page] ([Id], [system_id], [page_name], [display_seq], [page_path], [page_method], [page_type], [page_superior], [open_type], [rec_status], [creater], [createtime]) VALUES (newid(), N'1', N'宸ヨ祫鏍稿', 7, N'/SalaryCheck/Employee', N'01', N'M', N'6a13cb10-35d9-4176-a231-8887948e059e', 0, N'A', N'e4c93811-b9b1-4998-89f5-c416ebab0c07', getdate())
			go

			INSERT [dbo].[plt_page] ([Id], [system_id], [page_name], [display_seq], [page_path], [page_method], [page_type], [page_superior], [open_type], [rec_status], [creater], [createtime]) VALUES (newid(), N'1', N'宸ヨ祫鏌ヨ', 2, N'/SalaryCheck/SearchIndex', N'01', N'M', N'6a13cb10-35d9-4176-a231-8887948e059e', 0, N'A', N'e4c93811-b9b1-4998-89f5-c416ebab0c07', getdate())
			go

			INSERT [dbo].[plt_page] ([Id], [system_id], [page_name], [display_seq], [page_path], [page_method], [page_type], [page_superior], [open_type], [rec_status], [creater], [createtime]) VALUES (newid(), N'1', N'宸ヨ祫鏍稿噯', 3, N'/SalaryCheck/Index', N'01', N'M', N'6a13cb10-35d9-4176-a231-8887948e059e', 0, N'A', N'e4c93811-b9b1-4998-89f5-c416ebab0c07', getdate())
			go