23 lines
1.4 KiB
MySQL
23 lines
1.4 KiB
MySQL
|
if exists (select * from sysobjects where id = OBJECT_ID('[user_sign_log]') and OBJECTPROPERTY(id, 'IsUserTable') = 1)
|
|||
|
|
DROP TABLE [user_sign_log]
|
|||
|
|
|
|||
|
|
CREATE TABLE [user_sign_log] (
|
|||
|
|
[id] [int] IDENTITY (1, 1) NOT NULL,
|
|||
|
|
[user_id] [int] NOT NULL DEFAULT (0),
|
|||
|
|
[before_point] [decimal] (18,2) NOT NULL DEFAULT (0),
|
|||
|
|
[point] [decimal] (18,2) NOT NULL DEFAULT (0),
|
|||
|
|
[after_point] [decimal] (18,2) NOT NULL DEFAULT (0),
|
|||
|
|
[number_day] [int] NULL DEFAULT (0),
|
|||
|
|
[class_id] [int] NULL DEFAULT (0),
|
|||
|
|
[create_day] [varchar] (50) NULL,
|
|||
|
|
[create_time] [datetime] NULL DEFAULT (getdate()),
|
|||
|
|
[remark] [nvarchar] (500) NULL)
|
|||
|
|
|
|||
|
|
ALTER TABLE [user_sign_log] WITH NOCHECK ADD CONSTRAINT [PK_user_sign_log] PRIMARY KEY NONCLUSTERED ( [id] )
|
|||
|
|
SET IDENTITY_INSERT [user_sign_log] ON
|
|||
|
|
|
|||
|
|
INSERT [user_sign_log] ([id],[user_id],[before_point],[point],[after_point],[number_day],[class_id],[create_day],[create_time],[remark]) VALUES ( 1,160017,1450.00,5.00,1455.00,1,1,N'2026-02-03',N'2026/2/3 14:53:13',N'<EFBFBD>û<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ţ<EFBFBD>160017<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ڣ<EFBFBD>2026-02-03<30><33><EFBFBD><EFBFBD>1<EFBFBD><31>ǩ<EFBFBD><C7A9><EFBFBD>ɹ<EFBFBD><C9B9><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>5<EFBFBD>һ<EFBFBD>ȯ<EFBFBD><C8AF><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ǰ<EFBFBD>һ<EFBFBD>ȯ<EFBFBD><C8AF><EFBFBD><EFBFBD><EFBFBD><EFBFBD>1450<35><30><EFBFBD><EFBFBD><EFBFBD>º<EFBFBD><C2BA>һ<EFBFBD>ȯ<EFBFBD><C8AF><EFBFBD><EFBFBD><EFBFBD><EFBFBD>1455')
|
|||
|
|
INSERT [user_sign_log] ([id],[user_id],[before_point],[point],[after_point],[number_day],[class_id],[create_day],[create_time],[remark]) VALUES ( 2,160017,1000.00,5.00,1005.00,2,1,N'2026-02-06',N'2026/2/6 10:09:53',N'<EFBFBD>û<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ţ<EFBFBD>160017<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ڣ<EFBFBD>2026-02-06<30><36><EFBFBD><EFBFBD>2<EFBFBD><32>ǩ<EFBFBD><C7A9><EFBFBD>ɹ<EFBFBD><C9B9><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>5<EFBFBD>һ<EFBFBD>ȯ<EFBFBD><C8AF><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ǰ<EFBFBD>һ<EFBFBD>ȯ<EFBFBD><C8AF><EFBFBD><EFBFBD><EFBFBD><EFBFBD>1000<30><30><EFBFBD><EFBFBD><EFBFBD>º<EFBFBD><C2BA>һ<EFBFBD>ȯ<EFBFBD><C8AF><EFBFBD><EFBFBD><EFBFBD><EFBFBD>1005')
|
|||
|
|
|
|||
|
|
SET IDENTITY_INSERT [user_sign_log] OFF
|