Bug 817443

Summary:	RFE: SQL script for Skynet install
Product:	[Community] PressGang CCMS	Reporter:	Joshua Wulf <jwulf>
Component:	Web-UI	Assignee:	Matthew Casperson <mcaspers>
Status:	CLOSED CURRENTRELEASE	QA Contact:
Severity:	low	Docs Contact:
Priority:	low
Version:	1.x	CC:	cbredesen, lcarlon, lnewson, topic-tool-list
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2013-10-09 05:11:14 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

Description Joshua Wulf 2012-04-30 03:23:03 UTC

A Skynet installation requires a database with a specific schema.

It also requires specific data to be present (constants). 

Can I get a SQL script with the schema and the necessary data populated in order to spin up a Skynet instance.

Comment 1 Joshua Wulf 2012-05-03 14:04:38 UTC

Setting the priority and urgency to high. 

Needed for the FUDCon deployment before I can start testing it.

FUDCon is March 18, and I'd like to have it up a week ahead.

Comment 2 Lee Newson 2012-05-11 06:13:00 UTC

Since I talked to Josh and he's set it up using the live copy, however removing our topics, I'm gonna set this to low priority as it's probably still a good idea.

Comment 3 Matthew Casperson 2012-07-30 01:20:19 UTC

This is something that I am implementing with the next version at https://github.com/mcasperson/PressGangCCMSREST

The idea will be to use topics distributed in the system to document the system. To this end, basic tags like Concept, Task and Reference will be included in a deployment SQL script, along with categories and projects for the PressGang CCMS product.

What I need to know is what tags, categories, projects, string constants, images etc should be included in the default installation.

Comment 4 Matthew Casperson 2013-06-12 21:02:50 UTC

See https://github.com/pressgang-ccms/PressGangCCMSDeployable

CreateInitialDatabase.sql will copy across the minimum database rows into a new table.

import.sql is the minimum table exported.

Comment 5 Lee Newson 2013-10-09 05:11:14 UTC

Moving this bug to CLOSED CURRENT_RELEASE to clean up old bugs that were QA'd by the PressGang team but not by the original reporter.