[racktables-users] Re: [racktables-users] RE: [racktables-users] Re: [racktables-users] Deleting objects doesn´t delete corresponding attributes
- From: Denis Ovsienko <infrastation@xxxxxxxxx>
- To: racktables-users@xxxxxxxxxxxxx
- Date: Thu, 17 Mar 2011 17:40:58 +0300
17.03.2011, 14:22, "Göran Törnqvist" <Goran.Tornqvist@xxxxxxxxxx>:
> Hi,
> No constraints or ON DELETE CASCADE.
> I didn´t install racktables so not sure if it was done incorrectly or
> something.
> Is there a sql script I can run to add the constraints needed?
[...]
> ) ENGINE=MyISAM DEFAULT CHARSET=utf8 |
This must be InnoDB. There should be only 4 MyISAM tables in RackTables:
Attribute, Chapter, Dictionary and UserAccount. Fixing this database would
require:
1. making a backup
2. converting all tables, which must be InnoDB, respectively
3. finding missing constraints (checking one by one or comparing SQL structure
dumps)
4. restoring constraints with ALTER TABLE
--
Denis Ovsienko
Other related posts:
- » [racktables-users] Re: [racktables-users] RE: [racktables-users] Re: [racktables-users] Deleting objects doesn´t delete corresponding attributes - Denis Ovsienko
