1 ALTER TABLE authorised_values_branches
2 CHANGE av_id av_id INT( 11 ) NOT NULL,
3 CHANGE branchcode branchcode VARCHAR( 10 ) NOT NULL;
6 $DBversion = "3.21.00.XXX";
7 if ( CheckVersion($DBversion) ) {
9 ALTER TABLE authorised_values_branches
10 CHANGE av_id av_id INT( 11 ) NOT NULL,
11 CHANGE branchcode branchcode VARCHAR( 10 ) NOT NULL
13 print "Upgrade to $DBversion done (Bug 10363: There is no package for authorised values)\n";
14 SetVersion($DBversion);