Comment 0 for bug 836707

the current (0.4.0) database structure is impractical. i doesn’t even adheres to the first normal form.

i suggest to normalize it. this would also fix related bugs such as
https://bugs.launchpad.net/midori/+bug/700033
https://bugs.launchpad.net/midori/+bug/725460
https://bugs.launchpad.net/midori/+bug/711400

1th solution:
  folders | id (int primary), title (text), folder_id (int)
  bookmarks | id (int primary), title (text), folder_id (int), uri (text), desc (text), app (int), toolbar (int)
where folder.folder_id and bookmarks.folder_id refer to folder.id

2th solution:
  bookmarks | id (int primary), title (text), folder (int), uri (text), desc (text), app (int), toolbar (int)
where bookmarks.folder refers to bookmarks.id