I said *messed up* just to use part of your sentence. With referenced table, if you used the default ondelete attribute of the field, every "child" record gets deleted as soon as the "parent" is deleted. You can't fetch the data drom sqlite, it's definitely gone. For goods. The fact that the sqlite file is still "large" is because by default SQLite doesn't "release" the space: it keeps it for future records.
On Wednesday, December 19, 2012 2:38:32 PM UTC+1, Aurelijus Useckas wrote: > > is there any way to extract data from sqlite? The file is still full of > data... > > I don't understand, if you delete somthing that is linked, everything > messes up? > > On Wednesday, December 19, 2012 3:34:31 PM UTC+2, Niphlod wrote: >> >> definitely messed up. no way they will "return back". That's why >> referenced tables are for. >> >> Il giorno mercoledì 19 dicembre 2012 14:25:01 UTC+1, Aurelijus Useckas ha >> scritto: >>> >>> i'm on SQLite >>> >>> On Wednesday, December 19, 2012 3:21:27 PM UTC+2, Aurelijus Useckas >>> wrote: >>>> >>>> I've deleted user information from auth_users and suddenly all my data >>>> (from other table views) disapears.. Yes, other tables are linked to this >>>> one. Specifically for info on updates and simillar... >>>> >>>> If I restore the same data in auth_users other table still doesn't show >>>> anything... I event reset the autoincrement and make it appear totally >>>> identical.. still nothing :( >>>> >>>> did i mess up??? :( >>>> >>> --
