Lines 7923-7942
if ( CheckVersion($DBversion) ) {
Link Here
|
7923 |
fax varchar(100) default NULL, |
7923 |
fax varchar(100) default NULL, |
7924 |
email varchar(100) default NULL, |
7924 |
email varchar(100) default NULL, |
7925 |
notes mediumtext, |
7925 |
notes mediumtext, |
7926 |
rank SMALLINT default 0, |
7926 |
claimacquisition BOOLEAN NOT NULL DEFAULT 0, |
|
|
7927 |
claimissues BOOLEAN NOT NULL DEFAULT 0, |
7927 |
booksellerid int(11) not NULL, |
7928 |
booksellerid int(11) not NULL, |
7928 |
PRIMARY KEY (id), |
7929 |
PRIMARY KEY (id), |
7929 |
CONSTRAINT booksellerid_fk2 FOREIGN KEY (booksellerid) |
7930 |
CONSTRAINT booksellerid_aqcontacts_fk FOREIGN KEY (booksellerid) |
7930 |
REFERENCES aqbooksellers (id) ON DELETE CASCADE ON UPDATE CASCADE |
7931 |
REFERENCES aqbooksellers (id) ON DELETE CASCADE ON UPDATE CASCADE |
7931 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;"); |
7932 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;"); |
7932 |
$dbh->do("INSERT INTO aqcontacts (name, position, phone, altphone, fax, |
7933 |
$dbh->do("INSERT INTO aqcontacts (name, position, phone, altphone, fax, |
7933 |
email, notes, booksellerid) |
7934 |
email, notes, booksellerid, claimacquisition, claimissues) |
7934 |
SELECT contact, contpos, contphone, contaltphone, contfax, contemail, |
7935 |
SELECT contact, contpos, contphone, contaltphone, contfax, contemail, |
7935 |
contnotes, id FROM aqbooksellers;"); |
7936 |
contnotes, id, 1, 1 FROM aqbooksellers;"); |
7936 |
$dbh->do("ALTER TABLE aqbooksellers DROP COLUMN contact, |
7937 |
$dbh->do("ALTER TABLE aqbooksellers DROP COLUMN contact, |
7937 |
DROP COLUMN contpos, DROP COLUMN contphone, |
7938 |
DROP COLUMN contpos, DROP COLUMN contphone, |
7938 |
DROP COLUMN contaltphone, DROP COLUMN contfax, |
7939 |
DROP COLUMN contaltphone, DROP COLUMN contfax, |
7939 |
DROP COLUMN contemail, DROP COLUMN contnotes;"); |
7940 |
DROP COLUMN contemail, DROP COLUMN contnotes;"); |
|
|
7941 |
$dbh->do("UPDATE letter SET content = replace(content, '<<aqbooksellers.contact>>', '<<aqcontacts.name>>')"); |
7942 |
$dbh->do("UPDATE letter SET content = replace(content, '<<aqbooksellers.contpos>>', '<<aqcontacts.position>>')"); |
7943 |
$dbh->do("UPDATE letter SET content = replace(content, '<<aqbooksellers.contphone>>', '<<aqcontacts.phone>>')"); |
7944 |
$dbh->do("UPDATE letter SET content = replace(content, '<<aqbooksellers.contaltphone>>', '<<aqcontacts.altphone>>')"); |
7945 |
$dbh->do("UPDATE letter SET content = replace(content, '<<aqbooksellers.contfax>>', '<<aqcontacts.contfax>>')"); |
7946 |
$dbh->do("UPDATE letter SET content = replace(content, '<<aqbooksellers.contemail>>', '<<aqcontacts.contemail>>')"); |
7947 |
$dbh->do("UPDATE letter SET content = replace(content, '<<aqbooksellers.contnotes>>', '<<aqcontacts.contnotes>>')"); |
7940 |
print "Upgrade to $DBversion done (Bug 10402: Move bookseller contacts to separate table)\n"; |
7948 |
print "Upgrade to $DBversion done (Bug 10402: Move bookseller contacts to separate table)\n"; |
7941 |
SetVersion($DBversion); |
7949 |
SetVersion($DBversion); |
7942 |
} |
7950 |
} |