BUGGER-1: Decomission BUGGER



Issue Information

Issue Type: Task
 
Priority: Major
Status: Open

Reported By:
Ben Tasker
Assigned To:
Ben Tasker
Project: BUGGER (BUGGER)
Resolution: Unresolved

Created: 2014-11-12 02:42:47
Time Spent Working


Description
BUGGER has been moved to http://projects.bentasker.co.uk/archived_content/ until such a time as data can be extracted.

Once that's complete, the system needs to be decommissioned and removed.


Subtasks

BUGGER-2: Create Data extraction script
BUGGER-3: Ensure codebase is preserved
BUGGER-4: Find and disable dependant modules
BUGGER-7: Extract and publish data
Toggle State Changes

Activity


Been looking at whether any of the projects can be removed prior to data extraction, there are a few that are either empty, nonpublic and not needed or now redundant. These are

- bentasker.co.uk. Project ID 22
- LottoPredict. Project ID 34
- ModGooPlusFeed. Project ID 41
- Property Monkey. Project ID 33
- RAuth. Project ID 36
- Whitepapers. Project ID 26

Removing the above with the following

mysql> DELETE FROM Documents WHERE Project IN (22,34,41,33,36,26);
Query OK, 11 rows affected (0.00 sec)

mysql> DELETE FROM Bugs WHERE Project IN (22,34,41,33,36,26);
Query OK, 3 rows affected (0.01 sec)

mysql> DELETE FROM Changelog WHERE Project IN (22,34,41,33,36,26);
Query OK, 32 rows affected (0.00 sec)

mysql> DELETE FROM Comments WHERE Project IN (22,34,41,33,36,26);
Query OK, 0 rows affected (0.01 sec)

mysql> DELETE FROM Releases WHERE Project IN (22,34,41,33,36,26);
Query OK, 4 rows affected (0.01 sec)

mysql> DELETE FROM Tasks WHERE Project IN (22,34,41,33,36,26);
Query OK, 4 rows affected (0.00 sec)

mysql> DELETE FROM Projects WHERE ProjectRef IN (22,34,41,33,36,26);
Query OK, 6 rows affected (0.00 sec)