|
Lines 642-648
CREATE TABLE `deletedbiblioitems` (
Link Here
|
| 642 |
DROP TABLE IF EXISTS `deletedborrowers`; |
642 |
DROP TABLE IF EXISTS `deletedborrowers`; |
| 643 |
CREATE TABLE `deletedborrowers` ( |
643 |
CREATE TABLE `deletedborrowers` ( |
| 644 |
`borrowernumber` int(11) NOT NULL default 0, |
644 |
`borrowernumber` int(11) NOT NULL default 0, |
| 645 |
`cardnumber` varchar(9) NOT NULL default '', |
645 |
`cardnumber` varchar(16) NOT NULL default '', |
| 646 |
`surname` mediumtext NOT NULL, |
646 |
`surname` mediumtext NOT NULL, |
| 647 |
`firstname` text, |
647 |
`firstname` text, |
| 648 |
`title` mediumtext, |
648 |
`title` mediumtext, |
|
Lines 703-708
CREATE TABLE `deletedborrowers` (
Link Here
|
| 703 |
`altcontactcountry` text default NULL, |
703 |
`altcontactcountry` text default NULL, |
| 704 |
`altcontactphone` varchar(50) default NULL, |
704 |
`altcontactphone` varchar(50) default NULL, |
| 705 |
`smsalertnumber` varchar(50) default NULL, |
705 |
`smsalertnumber` varchar(50) default NULL, |
|
|
706 |
`privacy` integer(11) DEFAULT '1' NOT NULL, |
| 706 |
KEY `borrowernumber` (`borrowernumber`), |
707 |
KEY `borrowernumber` (`borrowernumber`), |
| 707 |
KEY `cardnumber` (`cardnumber`) |
708 |
KEY `cardnumber` (`cardnumber`) |
| 708 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
709 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |