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

(-)a/installer/data/mysql/atomicupdate/Bug10459_AddTimestampToBorrowers.sql (-2 / +2 lines)
Lines 1-8 Link Here
1 
ALTER TABLE borrowers
 1 
ALTER TABLE borrowers
2 
    ADD COLUMN timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
 2 
    ADD COLUMN updated_on timestamp NULL DEFAULT CURRENT_TIMESTAMP
3 
    ON UPDATE CURRENT_TIMESTAMP
 3 
    ON UPDATE CURRENT_TIMESTAMP
4 
    AFTER privacy_guarantor_checkouts;
 4 
    AFTER privacy_guarantor_checkouts;
5 
ALTER TABLE deletedborrowers
 5 
ALTER TABLE deletedborrowers
6 
    ADD COLUMN timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
 6 
    ADD COLUMN updated_on timestamp NULL DEFAULT CURRENT_TIMESTAMP
7 
    ON UPDATE CURRENT_TIMESTAMP
 7 
    ON UPDATE CURRENT_TIMESTAMP
8 
    AFTER privacy_guarantor_checkouts;
 8 
    AFTER privacy_guarantor_checkouts;
(-)a/installer/data/mysql/kohastructure.sql (-3 / +2 lines)
Lines 618-624 CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower Link Here
618 
  `sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber
 618 
  `sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber
619 
  `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history  KEY `borrowernumber` (`borrowernumber`),
 619 
  `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history  KEY `borrowernumber` (`borrowernumber`),
620 
  `privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts
 620 
  `privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts
621 
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- time of last change could be useful for synchronization with external systems (among others)
 621 
  `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- time of last change could be useful for synchronization with external systems (among others)
622 
  KEY borrowernumber (borrowernumber),
 622 
  KEY borrowernumber (borrowernumber),
623 
  KEY `cardnumber` (`cardnumber`),
 623 
  KEY `cardnumber` (`cardnumber`),
624 
  KEY `sms_provider_id` (`sms_provider_id`)
 624 
  KEY `sms_provider_id` (`sms_provider_id`)
Lines 1624-1630 CREATE TABLE `borrowers` ( -- this table includes information about your patrons Link Here
1624 
  `sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber
 1624 
  `sms_provider_id` int(11) DEFAULT NULL, -- the provider of the mobile phone number defined in smsalertnumber
1625 
  `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history
 1625 
  `privacy` integer(11) DEFAULT '1' NOT NULL, -- patron/borrower's privacy settings related to their reading history
1626 
  `privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts
 1626 
  `privacy_guarantor_checkouts` tinyint(1) NOT NULL DEFAULT '0', -- controls if relatives can see this patron's checkouts
1627 
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- time of last change could be useful for synchronization with external systems (among others)
 1627 
  `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- time of last change could be useful for synchronization with external systems (among others)
1628 
  UNIQUE KEY `cardnumber` (`cardnumber`),
 1628 
  UNIQUE KEY `cardnumber` (`cardnumber`),
1629 
  PRIMARY KEY `borrowernumber` (`borrowernumber`),
 1629 
  PRIMARY KEY `borrowernumber` (`borrowernumber`),
1630 
  KEY `categorycode` (`categorycode`),
 1630 
  KEY `categorycode` (`categorycode`),
1631 
-

Return to bug 10459