openinteract-commits

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

Update of /cvsroot/openinteract/OpenInteract2/extra_packages/delicious_tags/struct
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv18386/delicious_tags/struct

Added Files:
	delicious_tags.sql delicious_tags_sequence.sql 
Log Message:
intial import of delicious_tags package

--- NEW FILE: delicious_tags.sql ---
CREATE TABLE delicious_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, type, object_id )
);
--- NEW FILE: delicious_tags_sequence.sql ---
CREATE SEQUENCE delicious_tags_seq;