|
Lines 3922-3927
CREATE TABLE `article_requests` (
Link Here
|
| 3922 |
CONSTRAINT `article_requests_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE |
3922 |
CONSTRAINT `article_requests_ibfk_4` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE |
| 3923 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
3923 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 3924 |
|
3924 |
|
|
|
3925 |
-- |
| 3926 |
-- Table structure for table 'club_templates' |
| 3927 |
-- |
| 3928 |
|
| 3929 |
CREATE TABLE IF NOT EXISTS club_templates ( |
| 3930 |
id int(11) NOT NULL AUTO_INCREMENT, |
| 3931 |
`name` tinytext NOT NULL, |
| 3932 |
description text, |
| 3933 |
is_enrollable_from_opac tinyint(1) NOT NULL DEFAULT '0', |
| 3934 |
is_email_required tinyint(1) NOT NULL DEFAULT '0', |
| 3935 |
`branchcode` varchar(10) COLLATE utf8_unicode_ci NULL DEFAULT NULL, |
| 3936 |
date_created timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, |
| 3937 |
date_updated timestamp NULL DEFAULT NULL, |
| 3938 |
is_deletable tinyint(1) NOT NULL DEFAULT '1', |
| 3939 |
PRIMARY KEY (id), |
| 3940 |
KEY ct_branchcode (branchcode), |
| 3941 |
CONSTRAINT `club_templates_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE |
| 3942 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 3943 |
|
| 3944 |
-- |
| 3945 |
-- Table structure for table 'clubs' |
| 3946 |
-- |
| 3947 |
|
| 3948 |
CREATE TABLE IF NOT EXISTS clubs ( |
| 3949 |
id int(11) NOT NULL AUTO_INCREMENT, |
| 3950 |
club_template_id int(11) NOT NULL, |
| 3951 |
`name` tinytext NOT NULL, |
| 3952 |
description text, |
| 3953 |
date_start date DEFAULT NULL, |
| 3954 |
date_end date DEFAULT NULL, |
| 3955 |
`branchcode` varchar(10) COLLATE utf8_unicode_ci NULL DEFAULT NULL, |
| 3956 |
date_created timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, |
| 3957 |
date_updated timestamp NULL DEFAULT NULL, |
| 3958 |
PRIMARY KEY (id), |
| 3959 |
KEY club_template_id (club_template_id), |
| 3960 |
KEY branchcode (branchcode), |
| 3961 |
CONSTRAINT clubs_ibfk_1 FOREIGN KEY (club_template_id) REFERENCES club_templates (id) ON DELETE CASCADE ON UPDATE CASCADE, |
| 3962 |
CONSTRAINT clubs_ibfk_2 FOREIGN KEY (branchcode) REFERENCES branches (branchcode) |
| 3963 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 3964 |
|
| 3965 |
-- |
| 3966 |
-- Table structure for table 'club_enrollments' |
| 3967 |
-- |
| 3968 |
|
| 3969 |
CREATE TABLE IF NOT EXISTS club_enrollments ( |
| 3970 |
id int(11) NOT NULL AUTO_INCREMENT, |
| 3971 |
club_id int(11) NOT NULL, |
| 3972 |
borrowernumber int(11) NOT NULL, |
| 3973 |
date_enrolled timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, |
| 3974 |
date_canceled timestamp NULL DEFAULT NULL, |
| 3975 |
date_created timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', |
| 3976 |
date_updated timestamp NULL DEFAULT NULL, |
| 3977 |
`branchcode` varchar(10) COLLATE utf8_unicode_ci NULL DEFAULT NULL, |
| 3978 |
PRIMARY KEY (id), |
| 3979 |
KEY club_id (club_id), |
| 3980 |
KEY borrowernumber (borrowernumber), |
| 3981 |
KEY branchcode (branchcode), |
| 3982 |
CONSTRAINT club_enrollments_ibfk_1 FOREIGN KEY (club_id) REFERENCES clubs (id) ON DELETE CASCADE ON UPDATE CASCADE, |
| 3983 |
CONSTRAINT club_enrollments_ibfk_2 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE, |
| 3984 |
CONSTRAINT club_enrollments_ibfk_3 FOREIGN KEY (branchcode) REFERENCES branches (branchcode) ON DELETE SET NULL ON UPDATE CASCADE |
| 3985 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 3986 |
|
| 3987 |
-- |
| 3988 |
-- Table structure for table 'club_template_enrollment_fields' |
| 3989 |
-- |
| 3990 |
|
| 3991 |
CREATE TABLE IF NOT EXISTS club_template_enrollment_fields ( |
| 3992 |
id int(11) NOT NULL AUTO_INCREMENT, |
| 3993 |
club_template_id int(11) NOT NULL, |
| 3994 |
`name` tinytext NOT NULL, |
| 3995 |
description text, |
| 3996 |
authorised_value_category varchar(16) DEFAULT NULL, |
| 3997 |
PRIMARY KEY (id), |
| 3998 |
KEY club_template_id (club_template_id), |
| 3999 |
CONSTRAINT club_template_enrollment_fields_ibfk_1 FOREIGN KEY (club_template_id) REFERENCES club_templates (id) ON DELETE CASCADE ON UPDATE CASCADE |
| 4000 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 4001 |
|
| 4002 |
-- |
| 4003 |
-- Table structure for table 'club_enrollment_fields' |
| 4004 |
-- |
| 4005 |
|
| 4006 |
CREATE TABLE IF NOT EXISTS club_enrollment_fields ( |
| 4007 |
id int(11) NOT NULL AUTO_INCREMENT, |
| 4008 |
club_enrollment_id int(11) NOT NULL, |
| 4009 |
club_template_enrollment_field_id int(11) NOT NULL, |
| 4010 |
`value` text NOT NULL, |
| 4011 |
PRIMARY KEY (id), |
| 4012 |
KEY club_enrollment_id (club_enrollment_id), |
| 4013 |
KEY club_template_enrollment_field_id (club_template_enrollment_field_id), |
| 4014 |
CONSTRAINT club_enrollment_fields_ibfk_1 FOREIGN KEY (club_enrollment_id) REFERENCES club_enrollments (id) ON DELETE CASCADE ON UPDATE CASCADE, |
| 4015 |
CONSTRAINT club_enrollment_fields_ibfk_2 FOREIGN KEY (club_template_enrollment_field_id) REFERENCES club_template_enrollment_fields (id) ON DELETE CASCADE ON UPDATE CASCADE |
| 4016 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 4017 |
|
| 4018 |
-- |
| 4019 |
-- Table structure for table 'club_template_fields' |
| 4020 |
-- |
| 4021 |
|
| 4022 |
CREATE TABLE IF NOT EXISTS club_template_fields ( |
| 4023 |
id int(11) NOT NULL AUTO_INCREMENT, |
| 4024 |
club_template_id int(11) NOT NULL, |
| 4025 |
`name` tinytext NOT NULL, |
| 4026 |
description text, |
| 4027 |
authorised_value_category varchar(16) DEFAULT NULL, |
| 4028 |
PRIMARY KEY (id), |
| 4029 |
KEY club_template_id (club_template_id), |
| 4030 |
CONSTRAINT club_template_fields_ibfk_1 FOREIGN KEY (club_template_id) REFERENCES club_templates (id) ON DELETE CASCADE ON UPDATE CASCADE |
| 4031 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 4032 |
|
| 4033 |
-- |
| 4034 |
-- Table structure for table 'club_fields' |
| 4035 |
-- |
| 4036 |
|
| 4037 |
CREATE TABLE IF NOT EXISTS club_fields ( |
| 4038 |
id int(11) NOT NULL AUTO_INCREMENT, |
| 4039 |
club_template_field_id int(11) NOT NULL, |
| 4040 |
club_id int(11) NOT NULL, |
| 4041 |
`value` text, |
| 4042 |
PRIMARY KEY (id), |
| 4043 |
KEY club_template_field_id (club_template_field_id), |
| 4044 |
KEY club_id (club_id), |
| 4045 |
CONSTRAINT club_fields_ibfk_3 FOREIGN KEY (club_template_field_id) REFERENCES club_template_fields (id) ON DELETE CASCADE ON UPDATE CASCADE, |
| 4046 |
CONSTRAINT club_fields_ibfk_4 FOREIGN KEY (club_id) REFERENCES clubs (id) ON DELETE CASCADE ON UPDATE CASCADE |
| 4047 |
>>>>>>> Bug 12461 - Add patron clubs feature |
| 4048 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 4049 |
|
| 3925 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
4050 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
| 3926 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
4051 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
| 3927 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
4052 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |