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