-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathSqlQuery_1.sql
More file actions
33 lines (32 loc) · 4.94 KB
/
SqlQuery_1.sql
File metadata and controls
33 lines (32 loc) · 4.94 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
CREATE TABLE [dbo].[Clans] (
[Id] [int] NOT NULL IDENTITY,
[ClanName] [nvarchar](max),
CONSTRAINT [PK_dbo.Clans] PRIMARY KEY ([Id])
)
CREATE TABLE [dbo].[Ninjas] (
[Id] [int] NOT NULL IDENTITY,
[Name] [nvarchar](max),
[ServedInOniwaban] [bit] NOT NULL,
[ClanId] [int] NOT NULL,
CONSTRAINT [PK_dbo.Ninjas] PRIMARY KEY ([Id])
)
CREATE INDEX [IX_ClanId] ON [dbo].[Ninjas]([ClanId])
CREATE TABLE [dbo].[NinjaEquipments] (
[Id] [int] NOT NULL IDENTITY,
[Name] [nvarchar](max),
[Type] [int] NOT NULL,
[Ninja_Id] [int] NOT NULL,
CONSTRAINT [PK_dbo.NinjaEquipments] PRIMARY KEY ([Id])
)
CREATE INDEX [IX_Ninja_Id] ON [dbo].[NinjaEquipments]([Ninja_Id])
ALTER TABLE [dbo].[Ninjas] ADD CONSTRAINT [FK_dbo.Ninjas_dbo.Clans_ClanId] FOREIGN KEY ([ClanId]) REFERENCES [dbo].[Clans] ([Id]) ON DELETE CASCADE
ALTER TABLE [dbo].[NinjaEquipments] ADD CONSTRAINT [FK_dbo.NinjaEquipments_dbo.Ninjas_Ninja_Id] FOREIGN KEY ([Ninja_Id]) REFERENCES [dbo].[Ninjas] ([Id]) ON DELETE CASCADE
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 ([MigrationId], [ContextKey])
)
INSERT [dbo].[__MigrationHistory]([MigrationId], [ContextKey], [Model], [ProductVersion])
VALUES (N'201810161028197_InititalMigration', N'NinjaDomain.DataModel.Migrations.Configuration', 0x1F8B0800000000000400ED5ACD6EE33610BE17E83B083AB54536CACF651BD8BBC83A4911741D2FE2ECB6B78096C60E5B8A52452A6BA3E893F5D047EA2B74A87F91A22D3B3F0D168B1C62539CE170E69BE1F093FFFDFB9FC1DB65C89C7B48048DF8D03DDC3F701DE07E1450BE18BAA99CBF7AEDBE7DF3ED3783F3205C3A9FCA79C76A1E4A723174EFA48C4F3C4FF8771012B11F523F89443497FB7E147A2488BCA383831FBDC3430F50858BBA1C67709D724943C8BEE0D751C47D88654AD8380A8089621C9F4C33ADCE150941C4C487A17B45F96FE42C0A09E5FB6744924CC2754E192568CC14D8DC7508E79124124D3DF928602A93882FA6310E1076B38A01E7CD0913506CE1A49EDE773707476A375E2D58AAF25321D1B6ED141E1E17EEF174F19D9CEC56EE43079EA3A3E54AED3A73E2D01D31826AF5854E462C5193DAFEC5B9428050FFF99ED3F164AF82042247FDED39A394C934812187542684ED391FD219A3FECFB0BA897E073EE429634D0BD1467CD61AC0A10F4914432257D7302FECBE0C5CC76BCB79BA6025D690C97775C9E5F191EB5CE1E264C6A00240C303531925F01370488884E003911212AE7440E64263756D2DE523F5A95C11518739E43A63B27C0F7C21EF862E7E749D0BBA84A01C29ACF8C829A61C0AC9240563A12B724F17998DDA92594084EB5C03CB1E8B3B1AE729B09F3DBACD637D9144E175C44A816CF4F686240B90686C643C9A4669E26B660CBC1A486BE195E9D9165FD9D85780AD07D8D3804B5B640AC93D04977CC2E9673253E8C9177C17214AD45763839BB362B393FA023EC7F32E702F31DD01F73213FA1A71FE474AE3106336F9CC21B09B53CDBB2D7242334C7BDE9D91FAA487E766A571A724ADA4BF66EB0BC856A5BE5A4401AF0A4FFE64E7442B10FB58D0EECC3E1BFEFB413B0D1BC0D6B67D292E1859D45DDE76386F297B549863700348D80AC1D084613B26630867909401C6B2EB3A9F084BF1CBA111BFD6DC5F80C4AA632C661FAD9F3D49E567204935FDD8747CEEE2E6E0A910914F331F36819217DEF662E73C70EC55B8466C01A031FA8FC6E8310CF6D0FDC1B0BD535D55316B75F911D0D676E8EAE564C2CF808104E7D4CF9BF411113E09CC04412F04ED11AC4090A8124018DE5A04069B7269962BCA7D1A1366B55993E859E29445956EFDC919C4C05575B2FABDCFA2E5816D2E5CE9D75CB4C92303AF019B1E68D28BCB5A20582B8D86B0C6A9B725D4ACC7F4060C3F1EEAAC0ECC6B233A5DA2CBABCCCEAC5183B0EC3AE3F1425C943F511C32FAF695D229C80620F08E51D7E156A619BE6B0B97371443BA70D906F146D4BA35342668AA1A2ED3CC29DAC4C604B389D443B7B69A5556D7FB35B2676DFD6A2828BCAD03A2BD9BBE3B358E69CB9ED7665CFF9C6B6CC31A97FEF9B5D1AB6BBC52B60D556AD4849297334A25F3E459A8A7C198C4319ED30D2AAA1871A6390F357A35DD9E9D09731D9E2F3A489ACADA6A256C41C902B4A7B8345A7A41132115FF3523AAC51905A131AD55082C89562ED5CC75336065EA95B3D5E706CE74366EBF2B876A0F5EE0A654C0B3FD81067E532C630109234947373F8A581A72FB716997AEE99AA68E7AD4D434F034FB8D13D2709451D6DB5EEF159302FC0F0F4A676EF7888A45EE69C26286C4160E9B0693C1686A339F6E07197D77B676E97F834B5D791F093156857DA1B346C14BC5507E8D6C6AC8479E3FCAED23AEA3321867FC76412DA5B68B9C3AC3BB1803CB596E7AAD57D4731DDD979186013BDA66BD13ED8C48BB557AAB6286DAE858F42915D0AACE45EB500645B7B0F90D9AD13EE4535C076DBFA7816A1DA62B2121CC50B33FFD838D18CD7AB972C298703A0721736EC3C5EEE6B5F606EEE5BC0DF38408588F5762CFCE4152E5D18D2CE30E7C7B937AE4F724F1EF48F25D4896DF37B599F4E296AF78BE0C7FEDE8ABFE2F4E66543EF0A509EDA4EA2F7900CBA1FB672672E25CFE7A9B4BED39930433F4C43970FEDAB0F0AEEF0DBE46DE4AC267966E6B4875CC6D17EF52EE1122BE13AF9BD328CFC9BD6ACCC12E3CF24EF4ADE53AFB348CED97C8D23E275BBA86617A102DBC3BF1FF6CD059775533575CD75E3F3A8ABAA96A93C8DACC455BA9E8BC8B1DBAC12CC240E735B09B4EED64A9ED247597620B25D9A9791B16DBBA5635C75CF4A9A8EEA6B76B7E6E23A16B52B72F9CCFDE6CF0DA9A62BF353F09616D5EF3302D1B3FA7C4D220E8A256A17E5CC9C16F256435E792CFA3B23268169553B46E650C920498ADA789A473E24B7CEC8310D9EF1B8A57C9E7E12CEB845319A712B70CE18CB57E2FA1EACBBAF53356BE6DF36012673F44788C2DA09914B70013FE2EA52CA8ECBEE868982C2A54E12A7A51154BA97AD2C5AAD27415F19E8A0AF755F5F606C298A13231E153720FBBD8F651C07B58107F55DED6ED4A3607A2EDF6C119258B8484A2D051CBE357C470102EDFFC07B0A261E5552C0000 , N'6.2.0-61023')