/
AstroJohn
/
MailRobot
Обзор
Документация
Войти
/
AstroJohn
/
MailRobot
Код
Запросы
0
Задачи
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
DBProject/UpdateScripts/Script008.sql
76 строк
3 KB
AstroJohn
1st commit
11 сен 2024, 13:31
11 сен 2024, 13:31
0f57dc5
Код
Авторство
О чём код?
Create Table [dbo].[VHFResults] ( [ID] Int Not Null identity (1, 1), [SuperCategory] Varchar(255) Collate Cyrillic_General_CI_AS Null, [Category] Varchar(255) Collate Cyrillic_General_CI_AS Null, [Place] Int Null, [Call] Varchar(20) Collate Cyrillic_General_CI_AS Null, [QSOs_Claimed] Int Null, [Score_Claimed] Int Null, [QSOs] Int Null, [Score] Int Null, [FIO] Varchar(1000) Collate Cyrillic_General_CI_AS Null, [Location] Varchar(255) Collate Cyrillic_General_CI_AS Null, [Equipment] Varchar(8000) Collate Cyrillic_General_CI_AS Null, [Rank0] Varchar(200) Collate Cyrillic_General_CI_AS Null, [BirthYear] Varchar(200) Collate Cyrillic_General_CI_AS Null, [ODX] varchar(30) Null, [Band] Nvarchar(5) Collate Cyrillic_General_CI_AS Null, [ODX_Distance] Int Null, [ODX_WWLoc] varchar(6) Null, [ODX_Count] Int Null, [EVSK] Varchar(20) Collate Cyrillic_General_CI_AS Null, [EVSK_Points] Int Null, [Link] Varchar(1000) Collate Cyrillic_General_CI_AS Null, [BandQSOsCfm] Int Null, [BandPointsCfm] Int Null, [BandMultCfm] Int Null, [BandQSOs] Int Null, [BandPoints] Int Null, [BandMult] Int Null ) Alter Table dbo.VHFResults Add Constraint PK_VHFResults__ID Primary Key Nonclustered (ID) On [PRIMARY] Create Table [dbo].[HFResults] ( [SuperCategory_ID] Int Null, [SuperCategory] Varchar(255) Collate Cyrillic_General_CI_AS Null, [Category] Varchar(255) Collate Cyrillic_General_CI_AS Null, [Call] Varchar(20) Collate Cyrillic_General_CI_AS Null, [Place] Int Null, [AudioExists] Bit Null, [QSOs_Claimed] Int Null, [Points_Claimed] Int Null, [Mult1_Claimed] Int Null, [Mult2_Claimed] Int Null, [Mult3_Claimed] Int Null, [Score_Claimed] Int Null, [QSOs] Int Null, [Points] Int Null, [Mult1] Int Null, [Mult2] Int Null, [Mult3] Int Null, [Score] Int Null, [Link] Varchar(1000) Collate Cyrillic_General_CI_AS Null, [Location] Varchar(255) Collate Cyrillic_General_CI_AS Null, [Soapbox] Varchar(1000) Collate Cyrillic_General_CI_AS Null, [Band_ID] Int Null, [Category_ID] Int Null, [Month] Int Null, [SuperCategory_SortOrder] Int Null, [VIP] Float Null, [Proc_VIP] Float Null, [Rank] Varchar(10) Collate Cyrillic_General_CI_AS Null, [FIO] Varchar(1000) Collate Cyrillic_General_CI_AS Null, [Rank0] Varchar(200) Collate Cyrillic_General_CI_AS Null, [BirthYear] Varchar(200) Collate Cyrillic_General_CI_AS Null, [Регион] Varchar(255) Collate Cyrillic_General_CI_AS Null, [MS] Int Null, [KMS] Int Null, [TOTAL] Int Null, [R1] Int Null, [ID] Int Not Null identity (1, 1) ) Alter Table dbo.HFResults Add Constraint PK_HFResults__ID Primary Key Nonclustered (ID) On [PRIMARY]