Bugzilla – Attachment 36670 Details for
Bug 10703
add/update database documentation
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 10703: Add more serial table DB documentation
Bug-10703-Add-more-serial-table-DB-documentation.patch (text/plain), 6.65 KB, created by
Dobrica Pavlinusic
on 2015-03-06 10:33:08 UTC
(
hide
)
Description:
Bug 10703: Add more serial table DB documentation
Filename:
MIME Type:
Creator:
Dobrica Pavlinusic
Created:
2015-03-06 10:33:08 UTC
Size:
6.65 KB
patch
obsolete
>From 4e64f286269faef5caca2e324ecc25009e7f7239 Mon Sep 17 00:00:00 2001 >From: Nicole <nicole@bywatersolutions.com> >Date: Fri, 6 Mar 2015 04:01:58 -0600 >Subject: [PATCH] Bug 10703: Add more serial table DB documentation > >This patch adds a bit more documentation to the serial related tables >in Koha. > >To test, apply the patch and review the kohastructure for comments > >Signed-off-by: Dobrica Pavlinusic <dpavlin@rot13.org> >--- > installer/data/mysql/kohastructure.sql | 82 ++++++++++++++++---------------- > 1 files changed, 41 insertions(+), 41 deletions(-) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index daa7f20..c69a10f 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -1956,18 +1956,18 @@ CREATE TABLE IF NOT EXISTS `search_history` ( -- patron's opac search history > -- > > DROP TABLE IF EXISTS `serial`; >-CREATE TABLE `serial` ( >- `serialid` int(11) NOT NULL auto_increment, >- `biblionumber` varchar(100) NOT NULL default '', >- `subscriptionid` varchar(100) NOT NULL default '', >- `serialseq` varchar(100) NOT NULL default '', >- `status` tinyint(4) NOT NULL default 0, >- `planneddate` date default NULL, >- `notes` text, >- `publisheddate` date default NULL, >- `claimdate` date default NULL, >- claims_count int(11) default 0, >- `routingnotes` text, >+CREATE TABLE `serial` ( -- issues related to subscriptions >+ `serialid` int(11) NOT NULL auto_increment, -- unique key for the issue >+ `biblionumber` varchar(100) NOT NULL default '', -- foreign key for the biblio.biblionumber that this issue is attached to >+ `subscriptionid` varchar(100) NOT NULL default '', -- foreign key to the subscription.subscriptionid that this issue is part of >+ `serialseq` varchar(100) NOT NULL default '', -- issue information (volume, number, etc) >+ `status` tinyint(4) NOT NULL default 0, -- status code for this issue (see manual for full descriptions) >+ `planneddate` date default NULL, -- date expected >+ `notes` text, -- notes >+ `publisheddate` date default NULL, -- date published >+ `claimdate` date default NULL, -- date claimed >+ claims_count int(11) default 0, -- number of claims made related to this issue >+ `routingnotes` text, -- notes from the routing list > PRIMARY KEY (`serialid`) > ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; > >@@ -2090,47 +2090,47 @@ CREATE TABLE subscription_numberpatterns ( > -- > > DROP TABLE IF EXISTS `subscription`; >-CREATE TABLE `subscription` ( >- `biblionumber` int(11) NOT NULL default 0, >- `subscriptionid` int(11) NOT NULL auto_increment, >- `librarian` varchar(100) default '', >- `startdate` date default NULL, >- `aqbooksellerid` int(11) default 0, >- `cost` int(11) default 0, >+CREATE TABLE `subscription` ( -- information related to the subscription >+ `biblionumber` int(11) NOT NULL default 0, -- foreign key for biblio.biblionumber that this subscription is attached to >+ `subscriptionid` int(11) NOT NULL auto_increment, -- unique key for this subscription >+ `librarian` varchar(100) default '', -- the librarian's username from borrowers.userid >+ `startdate` date default NULL, -- start date for this subscription >+ `aqbooksellerid` int(11) default 0, -- foreign key for aqbooksellers.id to link to the vendor >+ `cost` int(11) default 0, > `aqbudgetid` int(11) default 0, >- `weeklength` int(11) default 0, >- `monthlength` int(11) default 0, >- `numberlength` int(11) default 0, >- `periodicity` integer default null, >+ `weeklength` int(11) default 0, -- subscription length in weeks (will not be filled in if monthlength or numberlength is set) >+ `monthlength` int(11) default 0, -- subscription length in weeks (will not be filled in if weeklength or numberlength is set) >+ `numberlength` int(11) default 0, -- subscription length in weeks (will not be filled in if monthlength or weeklength is set) >+ `periodicity` integer default null, -- frequency type links to subscription_frequencies.id > countissuesperunit INTEGER NOT NULL DEFAULT 1, >- `notes` mediumtext, >- `status` varchar(100) NOT NULL default '', >- `lastvalue1` int(11) default NULL, >+ `notes` mediumtext, -- notes >+ `status` varchar(100) NOT NULL default '', -- status of this subscription >+ `lastvalue1` int(11) default NULL, > `innerloop1` int(11) default 0, > `lastvalue2` int(11) default NULL, > `innerloop2` int(11) default 0, > `lastvalue3` int(11) default NULL, > `innerloop3` int(11) default 0, >- `firstacquidate` date default NULL, >- `manualhistory` tinyint(1) NOT NULL default 0, >- `irregularity` text, >+ `firstacquidate` date default NULL, -- first issue received date >+ `manualhistory` tinyint(1) NOT NULL default 0, -- yes or no to managing the history manually >+ `irregularity` text, -- any irregularities in the subscription > skip_serialseq BOOLEAN NOT NULL DEFAULT 0, > `letter` varchar(20) default NULL, >- `numberpattern` integer default null, >- locale VARCHAR(80) DEFAULT NULL, >+ `numberpattern` integer default null, -- the numbering pattern used links to subscription_numberpatterns.id >+ locale VARCHAR(80) DEFAULT NULL, -- for foreign language subscriptions to display months, seasons, etc correctly > `distributedto` text, > `internalnotes` longtext, >- `callnumber` text, >- `location` varchar(80) NULL default '', >- `branchcode` varchar(10) NOT NULL default '', >+ `callnumber` text, -- default call number >+ `location` varchar(80) NULL default '', -- default shelving location (items.location) >+ `branchcode` varchar(10) NOT NULL default '', -- default branches (items.homebranch) > `lastbranch` varchar(10), >- `serialsadditems` tinyint(1) NOT NULL default '0', >- `staffdisplaycount` VARCHAR(10) NULL, >- `opacdisplaycount` VARCHAR(10) NULL, >- `graceperiod` int(11) NOT NULL default '0', >- `enddate` date default NULL, >- `closed` INT(1) NOT NULL DEFAULT 0, >- `reneweddate` date default NULL, >+ `serialsadditems` tinyint(1) NOT NULL default '0', -- does receiving this serial create an item record >+ `staffdisplaycount` VARCHAR(10) NULL, -- how many issues to show to the staff >+ `opacdisplaycount` VARCHAR(10) NULL, -- how many issues to show to the public >+ `graceperiod` int(11) NOT NULL default '0', -- grace period in days >+ `enddate` date default NULL, -- subscription end date >+ `closed` INT(1) NOT NULL DEFAULT 0, -- yes / no if the subscription is closed >+ `reneweddate` date default NULL, -- date of last renewal for the subscription > PRIMARY KEY (`subscriptionid`), > CONSTRAINT subscription_ibfk_1 FOREIGN KEY (periodicity) REFERENCES subscription_frequencies (id) ON DELETE SET NULL ON UPDATE CASCADE, > CONSTRAINT subscription_ibfk_2 FOREIGN KEY (numberpattern) REFERENCES subscription_numberpatterns (id) ON DELETE SET NULL ON UPDATE CASCADE >-- >1.7.2.5
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 10703
:
20208
|
20209
|
20210
|
20248
|
20249
|
20250
|
20415
|
20416
|
20417
|
36582
|
36602
|
36603
|
36604
|
36605
|
36640
|
36641
|
36642
|
36648
|
36649
|
36650
|
36660
|
36669
|
36670
|
36910
|
36911
|
36912
|
36913