Hi,
I am new to yii and php. I am testing the framework and have been stuck for days. Below is my SQL for the database:
CREATE TABLE IF NOT EXISTS tbl_project
(
id
int(11) NOT NULL AUTO_INCREMENT,
description
varchar(500) DEFAULT NULL,
client_id
int(11) DEFAULT NULL,
status_id
int(11) DEFAULT NULL,
job_number
varchar(10) DEFAULT NULL,
date
datetime DEFAULT NULL,
PRIMARY KEY (id
),
KEY client_id
(client_id
)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;
CREATE TABLE IF NOT EXISTS tbl_client
(
id
int(11) NOT NULL AUTO_INCREMENT,
firstname
varchar(20) NOT NULL,
lastname
varchar(20) NOT NULL,
company
varchar(30) NOT NULL,
phone
varchar(10) NOT NULL,
email
varchar(50) NOT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
ALTER TABLE tbl_project
ADD CONSTRAINT tbl_project_client
FOREIGN KEY (client_id
) REFERENCES tbl_client
(id
) ON DELETE CASCADE;
I have run the model and crud generators and everything works properly and I can access client properties with Relational AR. However when I delete a client from the database, it also deletes the associated projects. This is not the behavior I expected. I am sure it is nothing but a database design issue, but I can not figure it out.
Any ideas?
Thanks,
Darryl