Lines 3444-3450
CREATE TABLE uploaded_files (
Link Here
|
3444 |
dir MEDIUMTEXT NOT NULL, |
3444 |
dir MEDIUMTEXT NOT NULL, |
3445 |
filesize int(11), |
3445 |
filesize int(11), |
3446 |
dtcreated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
3446 |
dtcreated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, |
3447 |
uploadcategorycode tinytext, |
3447 |
uploadcategorycode TEXT, |
3448 |
owner int(11), |
3448 |
owner int(11), |
3449 |
public tinyint, |
3449 |
public tinyint, |
3450 |
permanent tinyint, |
3450 |
permanent tinyint, |
Lines 3967-3973
CREATE TABLE deletedbiblio_metadata (
Link Here
|
3967 |
|
3967 |
|
3968 |
CREATE TABLE IF NOT EXISTS club_templates ( |
3968 |
CREATE TABLE IF NOT EXISTS club_templates ( |
3969 |
id int(11) NOT NULL AUTO_INCREMENT, |
3969 |
id int(11) NOT NULL AUTO_INCREMENT, |
3970 |
`name` tinytext NOT NULL, |
3970 |
`name` TEXT NOT NULL, |
3971 |
description MEDIUMTEXT, |
3971 |
description MEDIUMTEXT, |
3972 |
is_enrollable_from_opac tinyint(1) NOT NULL DEFAULT '0', |
3972 |
is_enrollable_from_opac tinyint(1) NOT NULL DEFAULT '0', |
3973 |
is_email_required tinyint(1) NOT NULL DEFAULT '0', |
3973 |
is_email_required tinyint(1) NOT NULL DEFAULT '0', |
Lines 3987-3993
CREATE TABLE IF NOT EXISTS club_templates (
Link Here
|
3987 |
CREATE TABLE IF NOT EXISTS clubs ( |
3987 |
CREATE TABLE IF NOT EXISTS clubs ( |
3988 |
id int(11) NOT NULL AUTO_INCREMENT, |
3988 |
id int(11) NOT NULL AUTO_INCREMENT, |
3989 |
club_template_id int(11) NOT NULL, |
3989 |
club_template_id int(11) NOT NULL, |
3990 |
`name` tinytext NOT NULL, |
3990 |
`name` TEXT NOT NULL, |
3991 |
description MEDIUMTEXT, |
3991 |
description MEDIUMTEXT, |
3992 |
date_start date DEFAULT NULL, |
3992 |
date_start date DEFAULT NULL, |
3993 |
date_end date DEFAULT NULL, |
3993 |
date_end date DEFAULT NULL, |
Lines 4030-4036
CREATE TABLE IF NOT EXISTS club_enrollments (
Link Here
|
4030 |
CREATE TABLE IF NOT EXISTS club_template_enrollment_fields ( |
4030 |
CREATE TABLE IF NOT EXISTS club_template_enrollment_fields ( |
4031 |
id int(11) NOT NULL AUTO_INCREMENT, |
4031 |
id int(11) NOT NULL AUTO_INCREMENT, |
4032 |
club_template_id int(11) NOT NULL, |
4032 |
club_template_id int(11) NOT NULL, |
4033 |
`name` tinytext NOT NULL, |
4033 |
`name` TEXT NOT NULL, |
4034 |
description MEDIUMTEXT, |
4034 |
description MEDIUMTEXT, |
4035 |
authorised_value_category varchar(16) DEFAULT NULL, |
4035 |
authorised_value_category varchar(16) DEFAULT NULL, |
4036 |
PRIMARY KEY (id), |
4036 |
PRIMARY KEY (id), |
Lines 4061-4067
CREATE TABLE IF NOT EXISTS club_enrollment_fields (
Link Here
|
4061 |
CREATE TABLE IF NOT EXISTS club_template_fields ( |
4061 |
CREATE TABLE IF NOT EXISTS club_template_fields ( |
4062 |
id int(11) NOT NULL AUTO_INCREMENT, |
4062 |
id int(11) NOT NULL AUTO_INCREMENT, |
4063 |
club_template_id int(11) NOT NULL, |
4063 |
club_template_id int(11) NOT NULL, |
4064 |
`name` tinytext NOT NULL, |
4064 |
`name` TEXT NOT NULL, |
4065 |
description MEDIUMTEXT, |
4065 |
description MEDIUMTEXT, |
4066 |
authorised_value_category varchar(16) DEFAULT NULL, |
4066 |
authorised_value_category varchar(16) DEFAULT NULL, |
4067 |
PRIMARY KEY (id), |
4067 |
PRIMARY KEY (id), |