From 19709958fde51853336e953a59829d97b279e192 Mon Sep 17 00:00:00 2001 From: Nicole C. Engard Date: Wed, 18 Jul 2012 09:34:08 -0400 Subject: [PATCH] Bug 6716: Document tags tables I did not document the 'tags' table in this patch because it looks like this table is unused, so I need confirmation of that before marking it as 'unused.' --- installer/data/mysql/kohastructure.sql | 34 ++++++++++++++++---------------- 1 files changed, 17 insertions(+), 17 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 3b9827a..c8443f5 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -2004,13 +2004,13 @@ CREATE TABLE `tags` ( -- DROP TABLE IF EXISTS `tags_all`; -CREATE TABLE `tags_all` ( - `tag_id` int(11) NOT NULL auto_increment, - `borrowernumber` int(11) NOT NULL, - `biblionumber` int(11) NOT NULL, - `term` varchar(255) NOT NULL, - `language` int(4) default NULL, - `date_created` datetime NOT NULL, +CREATE TABLE `tags_all` ( -- all of the tags + `tag_id` int(11) NOT NULL auto_increment, -- unique id and primary key + `borrowernumber` int(11) NOT NULL, -- the patron who added the tag (borrowers.borrowernumber) + `biblionumber` int(11) NOT NULL, -- the bib record this tag was left on (biblio.biblionumber) + `term` varchar(255) NOT NULL, -- the tag + `language` int(4) default NULL, -- the language the tag was left in + `date_created` datetime NOT NULL, -- the date the tag was added PRIMARY KEY (`tag_id`), KEY `tags_borrowers_fk_1` (`borrowernumber`), KEY `tags_biblionumber_fk_1` (`biblionumber`), @@ -2025,12 +2025,12 @@ CREATE TABLE `tags_all` ( -- DROP TABLE IF EXISTS `tags_approval`; -CREATE TABLE `tags_approval` ( - `term` varchar(255) NOT NULL, - `approved` int(1) NOT NULL default '0', - `date_approved` datetime default NULL, - `approved_by` int(11) default NULL, - `weight_total` int(9) NOT NULL default '1', +CREATE TABLE `tags_approval` ( -- approved tags + `term` varchar(255) NOT NULL, -- the tag + `approved` int(1) NOT NULL default '0', -- whether the tag is approved or not (1=yes, 0=pending, -1=rejected) + `date_approved` datetime default NULL, -- the date this tag was approved + `approved_by` int(11) default NULL, -- the librarian who approved the tag (borrowers.borrowernumber) + `weight_total` int(9) NOT NULL default '1', -- the total number of times this tag was used PRIMARY KEY (`term`), KEY `tags_approval_borrowers_fk_1` (`approved_by`), CONSTRAINT `tags_approval_borrowers_fk_1` FOREIGN KEY (`approved_by`) @@ -2042,10 +2042,10 @@ CREATE TABLE `tags_approval` ( -- DROP TABLE IF EXISTS `tags_index`; -CREATE TABLE `tags_index` ( - `term` varchar(255) NOT NULL, - `biblionumber` int(11) NOT NULL, - `weight` int(9) NOT NULL default '1', +CREATE TABLE `tags_index` ( -- a weighted list of all tags and where they are used + `term` varchar(255) NOT NULL, -- the tag + `biblionumber` int(11) NOT NULL, -- the bib record this tag was used on (biblio.biblionumber) + `weight` int(9) NOT NULL default '1', -- the number of times this term was used on this bib record PRIMARY KEY (`term`,`biblionumber`), KEY `tags_index_biblionumber_fk_1` (`biblionumber`), CONSTRAINT `tags_index_term_fk_1` FOREIGN KEY (`term`) -- 1.7.2.3