USE [batchadmin]
GO

INSERT batch.Servers
(Name, Queue, Target, Usr ,Host, Cat, ExecLimit, privs, rank, CStringExtra, Password)
VALUES
('DO NOT REMOVE MYDB Fake', 500, 'MyDB', 'fakeOwer', 'fakeHost', 'fakeCat', 2, NULL, 5, 'pooling = false;', NULL),
('DO NOT REMOVE MYDB Fake 2', 1, 'MyDB', 'fakeOwner', 'fakeHost', 'fakeCat', 2, NULL, 5, 'pooling = false;', NULL)

INSERT dbo.MyDBHosts
(MyDBHost, Limit, path, usr, Pass, Server, CStringExtra, admin_usr, admin_pw)
VALUES
('mydbhost', 200, 'C:\MSSQL\DATA', 'mydb', '*****', 'localhost', 'pooling=false;', 'batch', '*****')

INSERT batch.Users
(Name, Email, WebServicesID, Privileges, TimeCreated, CreatedBy, UserId, EmailLevel, MyDBName, MyDBHost, MyDBMinSize, MyDBMaxSize, LastModified, pwencrypted, gvisible)
VALUES
('anonymous', 'anonymous', 0, NULL, '2014-07-10 00:00:00.000', 10000001, 'anonymous', 0, NULL, 'mydbhost', 10, 500, '2014-07-10 00:00:00.000', '0d4H/zU/3WJ70OtQk7yzrA==', 0),
('admin', 'admin', 12345678, 'admin', '2014-06-05 17:20:20.917', 10000001, 'admin', 0, NULL, 'mydbhost', 10, 500, '2014-06-05 18:58:47.857', '0d4H/zU/3WJ70OtQk7yzrA==', 0)

INSERT dbo.Output
(OutputType, Description, Path, URL, Visible)
VALUES
('CSV', 'Comma Seperated Values', 'C:\data\cjoutput\CSV\', 'http:// ... /cjoutput/CSV/', 10),
('DataSet', 'XML - DataSet', 'C:\data\cjoutput\DataSet\', 'http:// ... /cjoutput/DataSet/', 10),
('FITS', 'Flexible Image Transfer System(FITS Binary)', 'C:\data\cjoutput\FITS\', 'http:// ... /cjoutput/FITS/', 10),
('GZIP', 'Comma Separated Values (GZIP)', 'C:\data\cjoutput\CSV\', 'http:// ... /cjoutput/CSV/', 10),
('plot', 'Scatter Plot', 'C:\data\cjoutput\Plot\', 'http:// ... /cjoutput/Plot/', 10),
('QUERY', 'query', 'THIS ROW IS REQUIRED', 'na', 0),
('SCIDRIVE', 'SciDrive', 'THIS ROW IS REQUIRED', 'na', 10),
('TCSV', 'Comma Seperated Values with Types', 'C:\data\cjoutput\CSV\', 'http:// ... /cjoutput/CSV/', 10),
('VOTable', 'XML - Virtual Observatory VOTABLE', 'C:\data\cjoutput\VOTable\', 'http:// ... /cjoutput/VOTable/', 10)

INSERT dbo.Status
(Status, Text, Html)
VALUES
(0, 'Ready', '<p class = "Ready">Ready</p>'),
(1, 'Started', '<p class = "Started">Started</p>'),
(2, 'Cancelling', '<p class = "Cancelling">Cancelling</p>'),
(3, 'Cancelled', '<p class = "Cancelled">Cancelled</p>'),
(4, 'Failed', '<p class = "Failed">Failed</p>'),
(5, 'Finished', '<p class="Finished">Finished</p>')

INSERT dbo.ServiceStatus
(Name, Description, PanicMinutes, LastCycle, State)
VALUES
('Cancel Jobs Service','Picks up jobs in the cancelling state and tries to cancel them.',5,'2014-08-25 14:07:28.870','RUNNING'),
('Job Cleanup Service','Sets status of orphaned jobs to failed.',60,'2014-08-25 13:39:52.900','RUNNING'),
('Output Cleanup Service','Deletes old output files.',600,'2014-08-25 14:07:19.913','RUNNING'),
('Output Service','Executes table extraction jobs.',5,'2014-08-25 14:07:28.873','RUNNING'),
('Run Jobs Service','Executes non-quick query jobs.',5,'2014-08-25 14:07:32.940','RUNNING')

INSERT dbo.Groups
(Name, gid, owner, description, privs)
VALUES
('public',-1,12345678,'All users are automatically a member of this group.',NULL)