Lines 2699-2704
CREATE TABLE `accountlines` (
Link Here
|
2699 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
2699 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
2700 |
`note` MEDIUMTEXT NULL default NULL, |
2700 |
`note` MEDIUMTEXT NULL default NULL, |
2701 |
`manager_id` int(11) NULL, |
2701 |
`manager_id` int(11) NULL, |
|
|
2702 |
`branchcode` VARCHAR( 10 ) NULL DEFAULT NULL, -- the branchcode of the library where a payment was made, a manual invoice created, etc. |
2702 |
PRIMARY KEY (`accountlines_id`), |
2703 |
PRIMARY KEY (`accountlines_id`), |
2703 |
KEY `acctsborridx` (`borrowernumber`), |
2704 |
KEY `acctsborridx` (`borrowernumber`), |
2704 |
KEY `timeidx` (`timestamp`), |
2705 |
KEY `timeidx` (`timestamp`), |
2705 |
- |
|
|