From 8db98fe1142211c9941d9c7d944394c5d7a33159 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期一, 21 六月 2021 09:17:53 +0800
Subject: [PATCH] 提交
---
表修改.sql | 238 ++++++++++++++++++++++++++++++++++++++++++----------------
1 files changed, 171 insertions(+), 67 deletions(-)
diff --git "a/\350\241\250\344\277\256\346\224\271.sql" "b/\350\241\250\344\277\256\346\224\271.sql"
index 4b263e2..38629a9 100644
--- "a/\350\241\250\344\277\256\346\224\271.sql"
+++ "b/\350\241\250\344\277\256\346\224\271.sql"
@@ -1,12 +1,178 @@
USE [zhengcaioa]
GO
+/****** Object: Table [dbo].[hr_jixiaoticheng] Script Date: 2021/6/9 14:15:04 ******/
+SET ANSI_NULLS ON
+GO
+
+SET QUOTED_IDENTIFIER ON
+GO
+IF EXISTS(Select 1 From Sysobjects Where Name='hr_jixiaoticheng') --查询表名costSeparateConfig是否存在
+drop table [hr_jixiaoticheng]
+GO
+
+CREATE TABLE [dbo].[hr_jixiaoticheng](
+ [Id] [nvarchar](50) NOT NULL,
+ [post_id] [nvarchar](50) NULL,
+ [piecerate_id] [nvarchar](50) NULL,
+ [tichengstandard] [nvarchar](50) NULL,
+ [renwustandard] [nvarchar](50) NULL,
+
+ [ticheng] [money] NULL,
+ [renwu] [money] NULL,
+
+
+ [effecttime] [datetime] NULL,
+
+ [rec_status] [nvarchar](1) NOT NULL,
+ [creater] [nvarchar](50) NOT NULL,
+ [createtime] [datetime] NOT NULL,
+ [modifier] [nvarchar](50) NOT NULL,
+ [modifytime] [datetime] NOT NULL,
+ CONSTRAINT [PK_hr_jixiaoticheng] PRIMARY KEY CLUSTERED
+(
+ [Id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+GO
+
+ALTER TABLE [dbo].[hr_jixiaoticheng] ADD DEFAULT ('A') FOR [rec_status]
+GO
+
+ALTER TABLE [dbo].[hr_jixiaoticheng] ADD DEFAULT ('1') FOR [creater]
+GO
+
+ALTER TABLE [dbo].[hr_jixiaoticheng] ADD DEFAULT (getdate()) FOR [createtime]
+GO
+
+ALTER TABLE [dbo].[hr_jixiaoticheng] ADD DEFAULT ('1') FOR [modifier]
+GO
+
+ALTER TABLE [dbo].[hr_jixiaoticheng] ADD DEFAULT (getdate()) FOR [modifytime]
+GO
+
+
+
+
+
+
+USE [zhengcaioa]
+GO
+
+/****** Object: Table [dbo].[hr_jibengongzi] Script Date: 2021/6/9 14:15:04 ******/
+SET ANSI_NULLS ON
+GO
+
+SET QUOTED_IDENTIFIER ON
+GO
+IF EXISTS(Select 1 From Sysobjects Where Name='hr_jibengongzi') --查询表名costSeparateConfig是否存在
+drop table [hr_jibengongzi]
+GO
+
+CREATE TABLE [dbo].[hr_jibengongzi](
+ [Id] [nvarchar](50) NOT NULL,
+ [post_id] [nvarchar](50) NULL,
+ [jibengongzi] [money] NULL,
+ [baomifei] [money] NULL,
+ [shebaodanwei] [money] NULL,
+ [shebaogeren] [money] NULL,
+ [dianhuabutie] [nvarchar](50) NULL,
+ [quanqingjiang] [money] NULL,
+ [jiaotongbutie] [money] NULL,
+
+ [effecttime] [datetime] NULL,
+
+ [rec_status] [nvarchar](1) NOT NULL,
+ [creater] [nvarchar](50) NOT NULL,
+ [createtime] [datetime] NOT NULL,
+ [modifier] [nvarchar](50) NOT NULL,
+ [modifytime] [datetime] NOT NULL,
+ CONSTRAINT [PK_hr_jibengongzi] PRIMARY KEY CLUSTERED
+(
+ [Id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+GO
+
+ALTER TABLE [dbo].[hr_jibengongzi] ADD DEFAULT ('A') FOR [rec_status]
+GO
+
+ALTER TABLE [dbo].[hr_jibengongzi] ADD DEFAULT ('1') FOR [creater]
+GO
+
+ALTER TABLE [dbo].[hr_jibengongzi] ADD DEFAULT (getdate()) FOR [createtime]
+GO
+
+ALTER TABLE [dbo].[hr_jibengongzi] ADD DEFAULT ('1') FOR [modifier]
+GO
+
+ALTER TABLE [dbo].[hr_jibengongzi] ADD DEFAULT (getdate()) FOR [modifytime]
+GO
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+USE [zhengcaioa]
+GO
+
/****** Object: Table [dbo].[ADM_AttendanceRules_dtl] Script Date: 2021/6/9 14:15:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
+IF EXISTS(Select 1 From Sysobjects Where Name='ADM_AttendanceRules_dtl') --查询表名costSeparateConfig是否存在
drop table [ADM_AttendanceRules_dtl]
GO
@@ -45,26 +211,6 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
USE [zhengcaioa]
GO
@@ -74,6 +220,7 @@
SET QUOTED_IDENTIFIER ON
GO
+IF EXISTS(Select 1 From Sysobjects Where Name='fi_account_record') --查询表名costSeparateConfig是否存在
drop table [fi_account_record]
GO
@@ -129,6 +276,7 @@
SET QUOTED_IDENTIFIER ON
GO
+IF EXISTS(Select 1 From Sysobjects Where Name='ADM_AskLeave') --查询表名costSeparateConfig是否存在
drop table [ADM_AskLeave]
GO
CREATE TABLE [dbo].[ADM_AskLeave](
@@ -225,7 +373,7 @@
SET QUOTED_IDENTIFIER ON
GO
-
+IF EXISTS(Select 1 From Sysobjects Where Name='ADM_AskLeaveOff') --查询表名costSeparateConfig是否存在
drop table [ADM_AskLeaveOff]
GO
@@ -313,7 +461,7 @@
SET QUOTED_IDENTIFIER ON
GO
-
+IF EXISTS(Select 1 From Sysobjects Where Name='ADM_AttendanceRules') --查询表名costSeparateConfig是否存在
drop table [ADM_AttendanceRules]
GO
@@ -441,50 +589,6 @@
-USE [zhengcaioa]
-GO
-
-/****** Object: Table [dbo].[ADM_AttendanceRules_dtl] Script Date: 2021/6/7 16:55:36 ******/
-SET ANSI_NULLS ON
-GO
-
-SET QUOTED_IDENTIFIER ON
-GO
-
-drop table [ADM_AttendanceRules_dtl]
-GO
-
-CREATE TABLE [dbo].[ADM_AttendanceRules_dtl](
- [Id] [nvarchar](50) NOT NULL,
- [pid] [nvarchar](50) NULL,
- [value_start] [nvarchar](50) NULL,
- [value_end] [nvarchar](50) NULL,
- [Name] [nvarchar](200) NULL,
- [rec_status] [nvarchar](1) NOT NULL,
- [creater] [nvarchar](50) NOT NULL,
- [createtime] [datetime] NOT NULL,
- [modifier] [nvarchar](50) NOT NULL,
- [modifytime] [datetime] NOT NULL,
- CONSTRAINT [PK_ADM_AttendanceRules_dtl] PRIMARY KEY CLUSTERED
-(
- [Id] ASC
-)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
-) ON [PRIMARY]
-GO
-
-ALTER TABLE [dbo].[ADM_AttendanceRules_dtl] ADD DEFAULT ('A') FOR [rec_status]
-GO
-
-ALTER TABLE [dbo].[ADM_AttendanceRules_dtl] ADD DEFAULT ('1') FOR [creater]
-GO
-
-ALTER TABLE [dbo].[ADM_AttendanceRules_dtl] ADD DEFAULT (getdate()) FOR [createtime]
-GO
-
-ALTER TABLE [dbo].[ADM_AttendanceRules_dtl] ADD DEFAULT ('1') FOR [modifier]
-GO
-
-ALTER TABLE [dbo].[ADM_AttendanceRules_dtl] ADD DEFAULT (getdate()) FOR [modifytime]
-GO
+
--
Gitblit v1.9.1