drop table Inputs;
drop table Exercises;
drop table Timing;
drop table PolecatEvents;
create table PolecatEvents(
ID int identity(1,1) not null,
MsgText nvarchar(400) not null,
Probability int not null,
Constraint PCEPK Primary Key (ID)
);
Create table Exercises(
ID int identity(1,1) not null,
EName nvarchar(30) not null,
InitialReport nvarchar(800),
WhosMissing nvarchar(800),
KnownStory nvarchar(800),
MapCoords nvarchar(800),
ExternalR nvarchar(800),
WhatReallyHappened nvarchar(800),
Crew int,
EStartTime nvarchar(30),
Constraint ExercisePK Primary Key (ID)
);
create table Timing(
ID int identity(1,1) not null,
TName nvarchar(100),
Constraint ATimingPK Primary Key (ID)
);
create table Inputs(
ID int identity(1,1) not null,
ExerciseID int,
TimingID int,
IMsg nvarchar(1000),
Constraint InputsPK Primary Key (ID),
Constraint FKExercise Foreign Key (ExerciseID)
references Exercises (ID) On delete set null,
Constraint FKTiming Foreign Key (TimingID)
references Timing (ID) On delete set null
);
insert into Timing (TName) Values( 'Skal gis');
insert into Timing (TName) Values( 'På forespørsel');
insert into Timing (TName) Values( 'På jordet');
