|
Lines 244-251
CREATE TABLE `borrowers` ( -- this table includes information about your patrons
Link Here
|
| 244 |
`guarantorid` int(11) default NULL, -- borrowernumber used for children or professionals to link them to guarentors or organizations |
244 |
`guarantorid` int(11) default NULL, -- borrowernumber used for children or professionals to link them to guarentors or organizations |
| 245 |
`borrowernotes` mediumtext, -- a note on the patron/borroewr's account that is only visible in the staff client |
245 |
`borrowernotes` mediumtext, -- a note on the patron/borroewr's account that is only visible in the staff client |
| 246 |
`relationship` varchar(100) default NULL, -- used for children to include the relationship to their guarentor |
246 |
`relationship` varchar(100) default NULL, -- used for children to include the relationship to their guarentor |
| 247 |
`ethnicity` varchar(50) default NULL, -- unused in Koha |
|
|
| 248 |
`ethnotes` varchar(255) default NULL, -- unused in Koha |
| 249 |
`sex` varchar(1) default NULL, -- patron/borrower's gender |
247 |
`sex` varchar(1) default NULL, -- patron/borrower's gender |
| 250 |
`password` varchar(60) default NULL, -- patron/borrower's encrypted password |
248 |
`password` varchar(60) default NULL, -- patron/borrower's encrypted password |
| 251 |
`flags` int(11) default NULL, -- will include a number associated with the staff member's permissions |
249 |
`flags` int(11) default NULL, -- will include a number associated with the staff member's permissions |
|
Lines 873-880
CREATE TABLE `deletedborrowers` ( -- stores data related to the patrons/borrower
Link Here
|
| 873 |
`guarantorid` int(11) default NULL, -- borrowernumber used for children or professionals to link them to guarentors or organizations |
871 |
`guarantorid` int(11) default NULL, -- borrowernumber used for children or professionals to link them to guarentors or organizations |
| 874 |
`borrowernotes` mediumtext, -- a note on the patron/borroewr's account that is only visible in the staff client |
872 |
`borrowernotes` mediumtext, -- a note on the patron/borroewr's account that is only visible in the staff client |
| 875 |
`relationship` varchar(100) default NULL, -- used for children to include the relationship to their guarentor |
873 |
`relationship` varchar(100) default NULL, -- used for children to include the relationship to their guarentor |
| 876 |
`ethnicity` varchar(50) default NULL, -- unused in Koha |
|
|
| 877 |
`ethnotes` varchar(255) default NULL, -- unused in Koha |
| 878 |
`sex` varchar(1) default NULL, -- patron/borrower's gender |
874 |
`sex` varchar(1) default NULL, -- patron/borrower's gender |
| 879 |
`password` varchar(30) default NULL, -- patron/borrower's encrypted password |
875 |
`password` varchar(30) default NULL, -- patron/borrower's encrypted password |
| 880 |
`flags` int(11) default NULL, -- will include a number associated with the staff member's permissions |
876 |
`flags` int(11) default NULL, -- will include a number associated with the staff member's permissions |
|
Lines 957-973
CREATE TABLE `deleteditems` (
Link Here
|
| 957 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
953 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 958 |
|
954 |
|
| 959 |
-- |
955 |
-- |
| 960 |
-- Table structure for table `ethnicity` |
|
|
| 961 |
-- |
| 962 |
|
| 963 |
DROP TABLE IF EXISTS `ethnicity`; |
| 964 |
CREATE TABLE `ethnicity` ( |
| 965 |
`code` varchar(10) NOT NULL default '', |
| 966 |
`name` varchar(255) default NULL, |
| 967 |
PRIMARY KEY (`code`) |
| 968 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 969 |
|
| 970 |
-- |
| 971 |
-- Table structure for table `export_format` |
956 |
-- Table structure for table `export_format` |
| 972 |
-- |
957 |
-- |
| 973 |
|
958 |
|
|
Lines 3314-3321
CREATE TABLE IF NOT EXISTS `borrower_modifications` (
Link Here
|
| 3314 |
`guarantorid` int(11) DEFAULT NULL, |
3299 |
`guarantorid` int(11) DEFAULT NULL, |
| 3315 |
`borrowernotes` mediumtext, |
3300 |
`borrowernotes` mediumtext, |
| 3316 |
`relationship` varchar(100) DEFAULT NULL, |
3301 |
`relationship` varchar(100) DEFAULT NULL, |
| 3317 |
`ethnicity` varchar(50) DEFAULT NULL, |
|
|
| 3318 |
`ethnotes` varchar(255) DEFAULT NULL, |
| 3319 |
`sex` varchar(1) DEFAULT NULL, |
3302 |
`sex` varchar(1) DEFAULT NULL, |
| 3320 |
`password` varchar(30) DEFAULT NULL, |
3303 |
`password` varchar(30) DEFAULT NULL, |
| 3321 |
`flags` int(11) DEFAULT NULL, |
3304 |
`flags` int(11) DEFAULT NULL, |