From 274fb67703d0ffcc7e3398d41855c5c8bfb3383b Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 25 六月 2021 13:07:44 +0800
Subject: [PATCH] Merge branch 'master' of http://47.108.235.38:8080/r/zhengcaioa
---
申诉记录表.sql | 37 +++++++++++++++++++++++++++++++++++++
1 files changed, 37 insertions(+), 0 deletions(-)
diff --git "a/\347\224\263\350\257\211\350\256\260\345\275\225\350\241\250.sql" "b/\347\224\263\350\257\211\350\256\260\345\275\225\350\241\250.sql"
new file mode 100644
index 0000000..813d13b
--- /dev/null
+++ "b/\347\224\263\350\257\211\350\256\260\345\275\225\350\241\250.sql"
@@ -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
\ No newline at end of file
--
Gitblit v1.9.1