a, dobra, dzień dziecka już za tydzień :) musisz wykonać poniższe:
mysql -f -u lms lms<<_EOT_ # # Downgrade bazy z 1.7-cvs do 1.6.0rc3 # ALTER TABLE assignments CHANGE customerid userid INT(11) DEFAULT '0' NOT NULL; ALTER TABLE events CHANGE customerid userid INT(11) DEFAULT '0' NOT NULL; ALTER TABLE rttickets CHANGE customerid userid INT(11) DEFAULT '0' NOT NULL; ALTER TABLE rtmessages CHANGE customerid userid INT(11) DEFAULT '0' NOT NULL; ALTER TABLE cash CHANGE customerid userid INT(11) DEFAULT '0' NOT NULL; ALTER TABLE cash DROP INDEX customerid ; ALTER TABLE cash ADD INDEX userid (userid); ALTER TABLE userassignments CHANGE customerid userid INT(11) DEFAULT '0' NOT NULL; ALTER TABLE userassignments DROP UNIQUE (usergroupid, customerid); ALTER TABLE userassignments ADD INDEX usergroupid (usergroupid); _EOT_