Paul,
Wednesday, June 26, 2002, 7:43:44 PM, you wrote:
PT> I've got the following 2 tables:
PT> create table cinema_order (
PT> id int not null primary key auto_increment,
PT> revision_number int not null default 1,
PT> active_revision int not null default 1
PT> );
PT> create table cinema_order_
I've got the following 2 tables:
create table cinema_order (
id int not null primary key auto_increment,
revision_number int not null default 1,
active_revision int not null default 1
);
create table cinema_order_revision (
id int not null primary key auto_increment,
cinema_order_id int not null
