Database error after migration

Dev Talk
1

Hi,
We did a migration from Airtime and the following error occurs when trying to schedule a smart block.

Unable to execute SELECT statement [SELECT cc_blockcriteria.id, cc_blockcriteria.criteria, cc_blockcriteria.modifier, cc_blockcriteria.value, cc_blockcriteria.extra, cc_blockcriteria.criteriagroup, cc_blockcriteria.block_id FROM cc_blockcriteria WHERE cc_blockcriteria.block_id=:p1 ORDER BY cc_blockcriteria.criteria ASC] [wrapped: SQLSTATE[42703]: Undefined column: 7 ERROR:  column cc_blockcriteria.criteriagroup does not exist
LINE 1: ..., cc_blockcriteria.value, cc_blockcriteria.extra, cc_blockcr...
                                                             ^]

So the table cc_blockcriteria is wrong, the migration did not create it well. The creation of smart block is not possible too.

I can add this column criteriagroup manually with psql but I just don’t know its data type.
My questions :

  1. Is it possible to retrieve the structure of the tables somewhere ?
  2. Is there a script to reset the database from scratch ?

Thx !

2

Hum, maybe a local issue from a friend in fact.
I hope I can find the shemes somewhere anyway.