Check extra columns in production database not present in ActiveRecord migrations.

[stevelaskaridis]

There is a deviation in production VM of Hellasgrid CA, running at access.hellasgrid.gr and the migrations described inside the codebase.

Tasks:

• Find differences.
• Find if extra columns are used anywhere inside the application logic.

[stevelaskaridis]

Access ca portal

Differences in columns:

Table: alternative_names

OK

Table: certificate_requests

OK

Table: certificates

OK

Table: distinguished_names

OK

Table: email_confirmations

OK

Table: host_administration_requests

OK

Table: host_versions

OK

Table: hosts

OK

Table: nwchem_vo_requests

Not used in production

Table: organizations

OK

Table: people

1. persistence_token
2. perishable_token
3. active
4. deleted

Table: person_versions

1. persistence_token
2. perishable_token
3. active
4. deleted

Table: prace_t1_requests

Not used in production

Table: ra_organization_relations

OK

Table: ra_staff_memberships

OK

Table: registration_authorities

OK

Table: registration_logs

OK

Table: roles

OK

Table: roles_users

OK

Table: schema_migrations

Migrations not available in the code base:

• 20091229005120
• 20091229182554
• 20091231192630

Table: scientific_fields

OK

Table: see_vo_requests

OK

Table: ui_requests

OK

[stevelaskaridis]

Checked the code base for mention of the extra fields described above and nothing found.

Next steps:

• Need to delete extra columns from production database. (issue #21 )

Closing issue as resolved.