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 */; |