Release

Concept of releases

Instead of grouping files by group only (anime-group) we could introduce "Releases" in which files could be grouped completely

aribitary. That is both files from different groups and files without group.

Why

Fix ag-state, or rather an addition to ag state (240, 145)
Grouping and states for no-group files
Multiple relases per group; DTV/DVD, low/high quality, avi/mkv, xvid/h264, etc. instead of version abuse

Why not?

More data to store.
More administration.

Possible tables

 releasetb(
  id int4,
  date int4,
  update int4,
  uid int4,
  edituid int 4,
  aid int 4,
 -- cached gids
  gids int4[],
  status int2,
 -- cached ep map, only for anime with known number of eps, only normal eps (and O)
  completion bitstring,
 -- comment?
  other varchar
 );

 releasefiletb(
  id int4,
  date int4,
  rid int4,
  aid int4,
  eid int4,
 -- only one file per eid, deprecated files would not be part of any release
  fid int4,
  gid int4,
 -- maybe, requests could possibly be related to releastb instead
  update int4,
  uid int4,
  edituid int4 
 );

Interface

On file add: select one of the existing releases or create a new release (only if epno is 1)
Request file to be added/removed from a release (from anime/group/file page)
Replace/merge/add to group box @ anime page, new release page (per anime)

Questions

Can it replace animegrouptb?

Don't think so. A release can not be 'dropped' because it would break the purpose of it self (at least partly). And since a system

like this can't be fully automated, the ag table is (most likely) needed as the basic way of file grouping.

Can it be semi-automated?

It should at least be possible to build the initial content based on some general rules. This might not be wanted though; it could

only be an addition to animegroups. Meaning releases would only be used where it is needed (sort of like file/ep rels are used

today). It should at least not be needed for movies/ovas (only one "ep").