本文共 1125 字,大约阅读时间需要 3 分钟。
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转载地址:http://mwrli.baihongyu.com/