View | Details | Raw Unified | Return to bug 12375
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-1 / +3 lines)
Lines 1958-1963 CREATE TABLE `serial` ( -- issues related to subscriptions Link Here
1958
  `biblionumber` varchar(100) NOT NULL default '', -- foreign key for the biblio.biblionumber that this issue is attached to
1958
  `biblionumber` varchar(100) NOT NULL default '', -- foreign key for the biblio.biblionumber that this issue is attached to
1959
  `subscriptionid` varchar(100) NOT NULL default '', -- foreign key to the subscription.subscriptionid that this issue is part of
1959
  `subscriptionid` varchar(100) NOT NULL default '', -- foreign key to the subscription.subscriptionid that this issue is part of
1960
  `serialseq` varchar(100) NOT NULL default '', -- issue information (volume, number, etc)
1960
  `serialseq` varchar(100) NOT NULL default '', -- issue information (volume, number, etc)
1961
  `serialseq_x` varchar( 100 ) NULL DEFAULT NULL, -- first part of issue information
1962
  `serialseq_y` varchar( 100 ) NULL DEFAULT NULL, -- second part of issue information
1963
  `serialseq_z` varchar( 100 ) NULL DEFAULT NULL, -- third part of issue information
1961
  `status` tinyint(4) NOT NULL default 0, -- status code for this issue (see manual for full descriptions)
1964
  `status` tinyint(4) NOT NULL default 0, -- status code for this issue (see manual for full descriptions)
1962
  `planneddate` date default NULL, -- date expected
1965
  `planneddate` date default NULL, -- date expected
1963
  `notes` text, -- notes
1966
  `notes` text, -- notes
1964
- 

Return to bug 12375