Too strict base_dao (required id and created_at fields)

[thibaultcha]

Because of the base_dao we require every table to have an id and a created_at. This was fine until yesterday when we removed applications and we now have tons of tables not requiring those. Ex:

CREATE TABLE IF NOT EXISTS basicauth_credentials(
  id uuid,
  username text,
  password text,
  consumer_id uuid,
  created_at timestamp,
  PRIMARY KEY (id)
);

CREATE INDEX IF NOT EXISTS ON basicauth_credentials(username);

CREATE TABLE IF NOT EXISTS keyauth_credentials(
  id uuid,
  key text,
  consumer_id uuid,
  created_at timestamp,
  PRIMARY KEY (id)
);

CREATE INDEX IF NOT EXISTS ON keyauth_credentials(key);

Could simply be:

CREATE TABLE IF NOT EXISTS basicauth_credentials(
  username text,
  password text,
  consumer_id uuid,
  created_at timestamp,
  PRIMARY KEY (username)
);

CREATE TABLE IF NOT EXISTS keyauth_credentials(
  key text,
  consumer_id uuid,
  created_at timestamp,
  PRIMARY KEY (key)
);

If we improve the DAO so the select_one, delete methods don't rely only on id and if insert doesn't automatically add an id and a created_at property.