forked from xiajingren/EFDynamicDatabaseBuilding
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathmasterdb-sqlserver.sql
More file actions
43 lines (43 loc) · 7.77 KB
/
masterdb-sqlserver.sql
File metadata and controls
43 lines (43 loc) · 7.77 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
USE [masterdb]
GO
/****** Object: Table [dbo].[Enterprises] Script Date: 02/27/2020 12:39:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Enterprises](
[ID] [uniqueidentifier] NOT NULL,
[Name] [nvarchar](50) NOT NULL,
[DBName] [nvarchar](100) NOT NULL,
[AdminAccount] [nvarchar](20) NOT NULL,
[AdminPassword] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_dbo.Enterprises] 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
INSERT [dbo].[Enterprises] ([ID], [Name], [DBName], [AdminAccount], [AdminPassword]) VALUES (N'ee77ed7c-2ae1-4ed5-9301-36d0d08e2d7f', N'企业A', N'BusinessDB637184034764024289', N'aa', N'123456')
INSERT [dbo].[Enterprises] ([ID], [Name], [DBName], [AdminAccount], [AdminPassword]) VALUES (N'71efb89c-64e5-4e38-ae1f-c9e62dba055e', N'企业B', N'BusinessDB637184035544250702', N'bb', N'123456')
/****** Object: Table [dbo].[__MigrationHistory] Script Date: 02/27/2020 12:39:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[__MigrationHistory](
[MigrationId] [nvarchar](150) NOT NULL,
[ContextKey] [nvarchar](300) NOT NULL,
[Model] [varbinary](max) NOT NULL,
[ProductVersion] [nvarchar](32) NOT NULL,
CONSTRAINT [PK_dbo.__MigrationHistory] PRIMARY KEY CLUSTERED
(
[MigrationId] ASC,
[ContextKey] 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
SET ANSI_PADDING OFF
GO
INSERT [dbo].[__MigrationHistory] ([MigrationId], [ContextKey], [Model], [ProductVersion]) VALUES (N'202002270429286_AutomaticMigration', N'XHZNL.EFDynamicDatabaseBuilding.MasterEntity.Migrations.Configuration', 0x1F8B0800000000000400CD58DB6EDB38107D5F60FF41E0736ADA290A7403B98563C76DD03809AAB458EC1B2D8D1DA214A99254D6FEB67DD84FDA5FD8A1EE966CC7769BC52280110D67CE5C347338F63F7FFDEDBF5FC5C27B026DB8924332E8F5890732541197CB2149EDE2D55BF2FEDDAFBFF85751BCF2BE967AAF9D1E5A4A33248FD62617949AF01162667A310FB5326A617BA18A298B143DEFF77FA3830105842088E579FEE7545A1E43F6808F632543486CCAC44C45204C21C7932043F56E590C2661210CC9EF1FFFB8BDE95D4D276BC9D0D784593667062E532E5CD0BD193316F415E2DB35F14682338C3100B1201E9352596631838B2F0602AB955C06090A98785827807A0B260C14995DD4EA8726D93F7749D2DAB0840A5363557C24E0E0755135DA363FA9F6A4AA2AD635AF8FCB3AABED90A00074A2B94BBFEDEE622CB4533DAEF8BD1AF2CC3BC6F0ACEA336C47F777E68D5361530D4309A9D54C9C79F7E95CF0F013AC1FD4379043990AD1CC0F33C4B30D018AEEB54A40DBF5675814595F4F884737ED68DBB0326BD8E4D5F890F28878B7E89BCD0554DD43F79ABBCF12005B109327DE8CAD6E402EEDE390BCC1C19AF21544A5A000FD22394E25DA589DC2D14E2797CFB81DF45FC4EF288AB91C85A1C279DFE3FDFCE59CDF3363FE543A7AE192FBB49EA8EE9C21BF59C625E822B2BCDB27974E0E2BBB65E2909F8AA13385FFCD5473DC006C677C0DF1EA5072E6EB35877B5BD4557C35F1D29C794B86A63B28DA9FB124C1823628BB907841CED7E357C1F17415E71834345B58AB8AB6F26495664B689DA26B8C74CAB5B125DD106F1CC51DB5F6DBD851E9D25BB7E06D9EA9EB5FDAB8FF73BB1319B4EDA3AEF314538F41DAAC0A5045BBC1E81DE3EC666582E92DDC3656228DE52E7EDC679D734CD33E971C8E50F25413A3941D8EB2C93A4DACCD9323116B2AE940D6475D4C9FB6DE54BB5D68A75F5A3752BB05F74D705BA5F25E4D726B62FD627A9EDFBC3AE394AB100F8BF5C423374AC11ABB37EE39855EF05D8C050757E85261C6245F80B1F9A58DB4DF7FDB5AD1FE3FEB1235261207EF4CFFF9EE914AFE3D052C2A06B5E0A07F680F914F4C878F4C77AEC51F5A33B6A2668BC64FD822B6829F9F88DD5E124EABC7713B40F7723AF4867FE682CFA77248A2B9C27CF26837D6831337802E4FF8B4F93DCE9F80E1CB1AC27DAB9310BA01AC414B9D6BB950E59BC01C9B11952AAD173503CB222CD54863C3B3D0E27108C664CBDC57265297653C87E85ADEA53649EDC81888E762DDCCD7A7FBFD676BCE66CCFE5DE29ECCCF4801C3E49802DCC9ECBAAFE29E6EE9A51D10AE6B3E00CA3362C36516E196EB0AE956C903818AF24D2001E948E401E2442098B993017B825362C39DF506962C5C9774BF1BE4F917B159767FC2D952B3D81418B5BDFB6D82BA1F27DEFD0B216EF036CE100000, N'6.4.0')