create or replace table accountamplifierthank ( accountId int not null, amplifierId int not null, time timestamp default current_timestamp() not null on update current_timestamp(), constraint accountamplifierthank_ibfk_1 foreign key (accountId) references accounts (id) ); create or replace index accountId on accountamplifierthank (accountId);