openinteract-commits

[Chris W. <la...@us...>]

Update of /cvsroot/openinteract/OpenInteract2/pkg/object_tags/struct
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv30046/object_tags/struct

Added Files:
	object_tags.sql object_tags_sequence.sql 
Log Message:
OIN-37: migrate delicious_tags package to core

--- NEW FILE: object_tags.sql ---
CREATE TABLE object_tags (
  tag_id            %%INCREMENT%% NOT NULL,
  tag               VARCHAR(35) NOT NULL,
  object_type       VARCHAR(20) NOT NULL,
  object_id         %%INCREMENT_TYPE%% NOT NULL,
  name              VARCHAR(100) NULL,
  url               VARCHAR(150) NULL,
  created_on        %%DATETIME%% NULL,
  PRIMARY KEY( tag_id ),
  UNIQUE( tag, object_type, object_id )
);
--- NEW FILE: object_tags_sequence.sql ---
CREATE SEQUENCE object_tags_seq;