Required new table

Ashok Chandraa year ago

I have added new table "table1" in changalog and added some columns. but when i restart the server newly added table not creating. If I delete the entire database and create new after that restart process is making that.

There is a another way to create new col and table without deleting the db.

Anton Tananaeva year ago

Have you created a new changelog file? It won't re-run the ones that already completed before.

Ashok Chandraa year ago

No, I have added in existing file. In last file I think it is 5.11 or 5.10

Ashok Chandraa year ago

@anton do the needfully, I am added following line in Changa-lock 5.11. After restarting its not making table or columns. I also try with new file but not working.

    <createTable tableName="tc_device_models">
    <column name="id" type="INT" autoIncrement="true">
      <constraints primaryKey="true" />
    </column>
      <column name="userid" type="INT"/>
      <column name="devicename" type="VARCHAR(100)"/>
      <column name="deviceprotocol" type="VARCHAR(100)"/>
      <column name="deviceport" type="VARCHAR(100)"/>
      <column name="attributes" type="VARCHAR(1000)"/>
    </createTable>
Anton Tananaeva year ago

I have already explained why it doesn't work and what you need to do to make it work.