|
Lines 13-19
return {
Link Here
|
| 13 |
$dbh->do( |
13 |
$dbh->do( |
| 14 |
q{ |
14 |
q{ |
| 15 |
ALTER TABLE borrower_attribute_types |
15 |
ALTER TABLE borrower_attribute_types |
| 16 |
MODIFY COLUMN `mandatory` tinyint(1) DEFAULT 0 COMMENT 'defines if the attribute is mandatory or not in the staff interface' |
16 |
MODIFY COLUMN `mandatory` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if the attribute is mandatory or not in the staff interface' |
| 17 |
} |
17 |
} |
| 18 |
); |
18 |
); |
| 19 |
say_success( $out, "Modified column 'borrower_attribute_types.mandatory'" ); |
19 |
say_success( $out, "Modified column 'borrower_attribute_types.mandatory'" ); |
|
Lines 21-27
return {
Link Here
|
| 21 |
$dbh->do( |
21 |
$dbh->do( |
| 22 |
q{ |
22 |
q{ |
| 23 |
ALTER TABLE borrower_attribute_types |
23 |
ALTER TABLE borrower_attribute_types |
| 24 |
ADD COLUMN `opac_mandatory` tinyint(1) DEFAULT 0 COMMENT 'defines if the attribute is mandatory or not in the OPAC' |
24 |
ADD COLUMN `opac_mandatory` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'defines if the attribute is mandatory or not in the OPAC' |
| 25 |
AFTER `mandatory` |
25 |
AFTER `mandatory` |
| 26 |
} |
26 |
} |
| 27 |
); |
27 |
); |
| 28 |
- |
|
|