|
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), |