Lines 7773-7792
if ( CheckVersion($DBversion) ) {
Link Here
|
7773 |
fax varchar(100) default NULL, |
7773 |
fax varchar(100) default NULL, |
7774 |
email varchar(100) default NULL, |
7774 |
email varchar(100) default NULL, |
7775 |
notes mediumtext, |
7775 |
notes mediumtext, |
7776 |
rank SMALLINT default 0, |
7776 |
claimacquisition BOOLEAN NOT NULL DEFAULT 0, |
|
|
7777 |
claimissues BOOLEAN NOT NULL DEFAULT 0, |
7777 |
booksellerid int(11) not NULL, |
7778 |
booksellerid int(11) not NULL, |
7778 |
PRIMARY KEY (id), |
7779 |
PRIMARY KEY (id), |
7779 |
CONSTRAINT booksellerid_fk2 FOREIGN KEY (booksellerid) |
7780 |
CONSTRAINT booksellerid_aqcontacts_fk FOREIGN KEY (booksellerid) |
7780 |
REFERENCES aqbooksellers (id) ON DELETE CASCADE ON UPDATE CASCADE |
7781 |
REFERENCES aqbooksellers (id) ON DELETE CASCADE ON UPDATE CASCADE |
7781 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;"); |
7782 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;"); |
7782 |
$dbh->do("INSERT INTO aqcontacts (name, position, phone, altphone, fax, |
7783 |
$dbh->do("INSERT INTO aqcontacts (name, position, phone, altphone, fax, |
7783 |
email, notes, booksellerid) |
7784 |
email, notes, booksellerid, claimacquisition, claimissues) |
7784 |
SELECT contact, contpos, contphone, contaltphone, contfax, contemail, |
7785 |
SELECT contact, contpos, contphone, contaltphone, contfax, contemail, |
7785 |
contnotes, id FROM aqbooksellers;"); |
7786 |
contnotes, id, 1, 1 FROM aqbooksellers;"); |
7786 |
$dbh->do("ALTER TABLE aqbooksellers DROP COLUMN contact, |
7787 |
$dbh->do("ALTER TABLE aqbooksellers DROP COLUMN contact, |
7787 |
DROP COLUMN contpos, DROP COLUMN contphone, |
7788 |
DROP COLUMN contpos, DROP COLUMN contphone, |
7788 |
DROP COLUMN contaltphone, DROP COLUMN contfax, |
7789 |
DROP COLUMN contaltphone, DROP COLUMN contfax, |
7789 |
DROP COLUMN contemail, DROP COLUMN contnotes;"); |
7790 |
DROP COLUMN contemail, DROP COLUMN contnotes;"); |
|
|
7791 |
$dbh->do("UPDATE letter SET content = replace(content, '<<aqbooksellers.contact>>', '<<aqcontacts.name>>')"); |
7792 |
$dbh->do("UPDATE letter SET content = replace(content, '<<aqbooksellers.contpos>>', '<<aqcontacts.position>>')"); |
7793 |
$dbh->do("UPDATE letter SET content = replace(content, '<<aqbooksellers.contphone>>', '<<aqcontacts.phone>>')"); |
7794 |
$dbh->do("UPDATE letter SET content = replace(content, '<<aqbooksellers.contaltphone>>', '<<aqcontacts.altphone>>')"); |
7795 |
$dbh->do("UPDATE letter SET content = replace(content, '<<aqbooksellers.contfax>>', '<<aqcontacts.contfax>>')"); |
7796 |
$dbh->do("UPDATE letter SET content = replace(content, '<<aqbooksellers.contemail>>', '<<aqcontacts.contemail>>')"); |
7797 |
$dbh->do("UPDATE letter SET content = replace(content, '<<aqbooksellers.contnotes>>', '<<aqcontacts.contnotes>>')"); |
7790 |
print "Upgrade to $DBversion done (Bug 10402: Move bookseller contacts to separate table)\n"; |
7798 |
print "Upgrade to $DBversion done (Bug 10402: Move bookseller contacts to separate table)\n"; |
7791 |
SetVersion($DBversion); |
7799 |
SetVersion($DBversion); |
7792 |
} |
7800 |
} |