Lines 1407-1419
DROP TABLE IF EXISTS `overduerules`;
Link Here
|
1407 |
CREATE TABLE `overduerules` ( |
1407 |
CREATE TABLE `overduerules` ( |
1408 |
`branchcode` varchar(10) NOT NULL default '', |
1408 |
`branchcode` varchar(10) NOT NULL default '', |
1409 |
`categorycode` varchar(10) NOT NULL default '', |
1409 |
`categorycode` varchar(10) NOT NULL default '', |
1410 |
`delay1` int(4) default 0, |
1410 |
`delay1` int(4) default NULL, |
1411 |
`letter1` varchar(20) default NULL, |
1411 |
`letter1` varchar(20) default NULL, |
1412 |
`debarred1` varchar(1) default 0, |
1412 |
`debarred1` varchar(1) default 0, |
1413 |
`delay2` int(4) default 0, |
1413 |
`delay2` int(4) default NULL, |
1414 |
`debarred2` varchar(1) default 0, |
1414 |
`debarred2` varchar(1) default 0, |
1415 |
`letter2` varchar(20) default NULL, |
1415 |
`letter2` varchar(20) default NULL, |
1416 |
`delay3` int(4) default 0, |
1416 |
`delay3` int(4) default NULL, |
1417 |
`letter3` varchar(20) default NULL, |
1417 |
`letter3` varchar(20) default NULL, |
1418 |
`debarred3` int(1) default 0, |
1418 |
`debarred3` int(1) default 0, |
1419 |
PRIMARY KEY (`branchcode`,`categorycode`) |
1419 |
PRIMARY KEY (`branchcode`,`categorycode`) |