Future Database Structure

Even though the 1.5 version is not ready yet, I also have in mind the next release, 1.6, which will introduce a much needed DB rethinking. Currently the DB schema is very weak and inefficient, making it difficult to introduce new features and having lots of redundant data. Another effect of the “never thought this project would get that big” syndrome.

What I have currently in mind is this schema:
DB schema v2

Comments welcome on the wiki page to keep things in one place.

Short URL to this post: http://yourls.org/2

One thought on “Future Database Structure

  1. Looks great – I especially like the meta_type, meta_value and tags fields. I’m really looking forward to being able to store more than just the short and long URLs – get crackin!

    Kurt

Comments are closed.