#
# The tags table is used to store misc information about any other object in
# the database. This is for when a plugin or the app wants to store addtional
# information about a specific object.
#
# _rowid       is a positive integer, unique within the TAGS table, that 
#              is used to identify a specific row in the table.
# tag_key      is the key for this tag.
# tag_value    is the value for this tag.
# target_table is which table this tag is for.
# target_id    is the rowid of the target
#
create table tags (
   _rowid       int not null,
   tag_key      char(255),
   tag_value    char(255),
   target_table char(80),
   target_rowid int,
   primary key  (_rowid)
);