Lines 4442-4448
CREATE TABLE return_claims (
Link Here
|
4442 |
|
4442 |
|
4443 |
DROP TABLE IF EXISTS `problem_reports`; |
4443 |
DROP TABLE IF EXISTS `problem_reports`; |
4444 |
CREATE TABLE `problem_reports` ( |
4444 |
CREATE TABLE `problem_reports` ( |
4445 |
`reportid` int(11) NOT NULL auto_increment, -- unqiue identifier assigned by Koha |
4445 |
`reportid` int(11) NOT NULL auto_increment, -- unique identifier assigned by Koha |
4446 |
`title` varchar(40) NOT NULL default '', -- report subject line |
4446 |
`title` varchar(40) NOT NULL default '', -- report subject line |
4447 |
`content` varchar(255) NOT NULL default '', -- report message content |
4447 |
`content` varchar(255) NOT NULL default '', -- report message content |
4448 |
`borrowernumber` int(11) default NULL, -- the user who created the problem report |
4448 |
`borrowernumber` int(11) default NULL, -- the user who created the problem report |
Lines 4450-4456
CREATE TABLE `problem_reports` (
Link Here
|
4450 |
`username` varchar(75) default NULL, -- OPAC username |
4450 |
`username` varchar(75) default NULL, -- OPAC username |
4451 |
`problempage` varchar(255) default NULL, -- page the user triggered the problem report form from |
4451 |
`problempage` varchar(255) default NULL, -- page the user triggered the problem report form from |
4452 |
`recipient` enum('admin','library') NOT NULL default 'library', -- the 'to-address' of the problem report |
4452 |
`recipient` enum('admin','library') NOT NULL default 'library', -- the 'to-address' of the problem report |
4453 |
`reportdate` datetime default NULL, -- date and time of report submission |
4453 |
`created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, -- timestamp of report submission |
4454 |
`status` varchar(1) NOT NULL default 'N', -- status of the report. N=new, V=viewed, C=closed |
4454 |
`status` varchar(1) NOT NULL default 'N', -- status of the report. N=new, V=viewed, C=closed |
4455 |
PRIMARY KEY (`reportid`), |
4455 |
PRIMARY KEY (`reportid`), |
4456 |
CONSTRAINT `problem_reports_ibfk1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
4456 |
CONSTRAINT `problem_reports_ibfk1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |