DROP TABLE [dbo].[red_envelope_original]
GO
CREATE TABLE [dbo].[red_envelope_original] (
[id] int NOT NULL IDENTITY(1,1) ,
[qrcode] varchar(64) NULL ,
[creation_time] datetime NULL DEFAULT (getdate())
)
GO
DBCC CHECKIDENT(N'[dbo].[red_envelope_original]', RESEED, 24000)
GO
-- ----------------------------
-- Records of red_envelope_original
-- ----------------------------
SET IDENTITY_INSERT [dbo].[red_envelope_original] ON
GO
INSERT INTO [dbo].[red_envelope_original] ([id], [qrcode], [creation_time]) VALUES (N'1', N'8FA215443AA64A9DB1E4213070F72EC8', N'2018-08-20 16:30:21.237')
GO
SET IDENTITY_INSERT [dbo].[red_envelope_original] OFF
GO
-- ----------------------------
-- Indexes structure for table red_envelope_original
-- ----------------------------
CREATE UNIQUE INDEX [idx_qrcode_d9l2m4n7_copy1] ON [dbo].[red_envelope_original]
([qrcode] ASC)
WITH (IGNORE_DUP_KEY = ON)
GO
-- ----------------------------
-- Primary Key structure for table red_envelope_original
-- ----------------------------
ALTER TABLE [dbo].[red_envelope_original] ADD PRIMARY KEY ([id]) WITH (ALLOW_ROW_LOCKS=OFF, ALLOW_PAGE_LOCKS=OFF)
GO