RocketCalculator/RCDBPopulate.sql at master · AveryPratt/RocketCalculator · GitHub

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
INSERT INTO Kerbals VALUES ('Default', 'sapassword');

INSERT INTO Rockets VALUES (1, 'Falcon 9', 22.8, 'Earth', 2);
INSERT INTO Stages VALUES (1, 1, 111.5, 4, 345, 5455, 934, 0.7089, 3.5525);
INSERT INTO Stages VALUES (1, 2, 543.2, 133.7, 311, 3922, 8226, 1.4815, 5.3580);

INSERT INTO Rockets VALUES (1, 'Saturn V', 48.6, 'Earth', 3);
INSERT INTO Stages VALUES (2, 1, 123, 13.5, 421, 4198, 1000, 0.5940, 1.6414);
INSERT INTO Stages VALUES (2, 2, 619.2, 163.1, 421, 4745, 4400, 0.6716, 2.1186);
INSERT INTO Stages VALUES (2, 3, 2909.2, 749.2, 263, 3381, 34020, 1.1724, 4.3468);

SELECT * FROM Kerbals
SELECT * FROM Rockets
SELECT * FROM Stages

DELETE FROM Stages;
DELETE FROM Rockets;
DELETE FROM Kerbals;

DBCC CHECKIDENT (Kerbals, RESEED, 0)
DBCC CHECKIDENT (Rockets, RESEED, 0)
DBCC CHECKIDENT (Stages, RESEED, 0)

SET IDENTITY_INSERT Kerbals ON
SET IDENTITY_INSERT Rockets ON
SET IDENTITY_INSERT Stages ON