Lines 72-79
if( CheckVersion( $DBversion ) ) {
Link Here
|
72 |
|
72 |
|
73 |
$dbh->do(q| |
73 |
$dbh->do(q| |
74 |
ALTER TABLE subscriptionhistory |
74 |
ALTER TABLE subscriptionhistory |
75 |
MODIFY COLUMN biblionumber int(11), |
75 |
MODIFY COLUMN biblionumber int(11) NOT NULL, |
76 |
MODIFY COLUMN subscriptionid int(11) |
76 |
MODIFY COLUMN subscriptionid int(11) NOT NULL |
77 |
|); |
77 |
|); |
78 |
|
78 |
|
79 |
unless ( foreign_key_exists( 'subscriptionhistory', 'subscription_history_ibfk_1' ) ) { |
79 |
unless ( foreign_key_exists( 'subscriptionhistory', 'subscription_history_ibfk_1' ) ) { |
Lines 98-104
if( CheckVersion( $DBversion ) ) {
Link Here
|
98 |
|
98 |
|
99 |
$dbh->do(q| |
99 |
$dbh->do(q| |
100 |
ALTER TABLE subscription |
100 |
ALTER TABLE subscription |
101 |
MODIFY COLUMN biblionumber int(11) |
101 |
MODIFY COLUMN biblionumber int(11) NOT NULL |
102 |
|); |
102 |
|); |
103 |
|
103 |
|
104 |
unless ( foreign_key_exists( 'subscription', 'subscription_ibfk_3' ) ) { |
104 |
unless ( foreign_key_exists( 'subscription', 'subscription_ibfk_3' ) ) { |
105 |
- |
|
|