Lines 245-252
CREATE TABLE `borrowers` ( -- this table includes information about your patrons
Link Here
|
245 |
`guarantorid` int(11) default NULL, -- borrowernumber used for children or professionals to link them to guarentors or organizations |
245 |
`guarantorid` int(11) default NULL, -- borrowernumber used for children or professionals to link them to guarentors or organizations |
246 |
`borrowernotes` mediumtext, -- a note on the patron/borrower's account that is only visible in the staff client |
246 |
`borrowernotes` mediumtext, -- a note on the patron/borrower's account that is only visible in the staff client |
247 |
`relationship` varchar(100) default NULL, -- used for children to include the relationship to their guarentor |
247 |
`relationship` varchar(100) default NULL, -- used for children to include the relationship to their guarentor |
248 |
`ethnicity` varchar(50) default NULL, -- unused in Koha |
|
|
249 |
`ethnotes` varchar(255) default NULL, -- unused in Koha |
250 |
`sex` varchar(1) default NULL, -- patron/borrower's gender |
248 |
`sex` varchar(1) default NULL, -- patron/borrower's gender |
251 |
`password` varchar(60) default NULL, -- patron/borrower's encrypted password |
249 |
`password` varchar(60) default NULL, -- patron/borrower's encrypted password |
252 |
`flags` int(11) default NULL, -- will include a number associated with the staff member's permissions |
250 |
`flags` int(11) default NULL, -- will include a number associated with the staff member's permissions |
Lines 877-884
CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower
Link Here
|
877 |
`guarantorid` int(11) default NULL, -- borrowernumber used for children or professionals to link them to guarentors or organizations |
875 |
`guarantorid` int(11) default NULL, -- borrowernumber used for children or professionals to link them to guarentors or organizations |
878 |
`borrowernotes` mediumtext, -- a note on the patron/borrower's account that is only visible in the staff client |
876 |
`borrowernotes` mediumtext, -- a note on the patron/borrower's account that is only visible in the staff client |
879 |
`relationship` varchar(100) default NULL, -- used for children to include the relationship to their guarentor |
877 |
`relationship` varchar(100) default NULL, -- used for children to include the relationship to their guarentor |
880 |
`ethnicity` varchar(50) default NULL, -- unused in Koha |
|
|
881 |
`ethnotes` varchar(255) default NULL, -- unused in Koha |
882 |
`sex` varchar(1) default NULL, -- patron/borrower's gender |
878 |
`sex` varchar(1) default NULL, -- patron/borrower's gender |
883 |
`password` varchar(30) default NULL, -- patron/borrower's encrypted password |
879 |
`password` varchar(30) default NULL, -- patron/borrower's encrypted password |
884 |
`flags` int(11) default NULL, -- will include a number associated with the staff member's permissions |
880 |
`flags` int(11) default NULL, -- will include a number associated with the staff member's permissions |
Lines 962-978
CREATE TABLE `deleteditems` (
Link Here
|
962 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
958 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
963 |
|
959 |
|
964 |
-- |
960 |
-- |
965 |
-- Table structure for table `ethnicity` |
|
|
966 |
-- |
967 |
|
968 |
DROP TABLE IF EXISTS `ethnicity`; |
969 |
CREATE TABLE `ethnicity` ( |
970 |
`code` varchar(10) NOT NULL default '', |
971 |
`name` varchar(255) default NULL, |
972 |
PRIMARY KEY (`code`) |
973 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
974 |
|
975 |
-- |
976 |
-- Table structure for table `export_format` |
961 |
-- Table structure for table `export_format` |
977 |
-- |
962 |
-- |
978 |
|
963 |
|
Lines 3321-3328
CREATE TABLE IF NOT EXISTS `borrower_modifications` (
Link Here
|
3321 |
`guarantorid` int(11) DEFAULT NULL, |
3306 |
`guarantorid` int(11) DEFAULT NULL, |
3322 |
`borrowernotes` mediumtext, |
3307 |
`borrowernotes` mediumtext, |
3323 |
`relationship` varchar(100) DEFAULT NULL, |
3308 |
`relationship` varchar(100) DEFAULT NULL, |
3324 |
`ethnicity` varchar(50) DEFAULT NULL, |
|
|
3325 |
`ethnotes` varchar(255) DEFAULT NULL, |
3326 |
`sex` varchar(1) DEFAULT NULL, |
3309 |
`sex` varchar(1) DEFAULT NULL, |
3327 |
`password` varchar(30) DEFAULT NULL, |
3310 |
`password` varchar(30) DEFAULT NULL, |
3328 |
`flags` int(11) DEFAULT NULL, |
3311 |
`flags` int(11) DEFAULT NULL, |