Displaying 1 result from an estimated 1 matches for "company_users_fkindex1".
2005 Sep 02
7
Form to update two tables
...ATE TABLE users (
id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
login VARCHAR(40) NOT NULL,
first VARCHAR(40),
last VARCHAR(40),
pswd VARCHAR(40) NOT NULL,
modified_at DATETIME,
created_at DATETIME,
access DATETIME,
company_id INTEGER UNSIGNED,
PRIMARY KEY(id),
INDEX company_users_FKIndex1 (company_id),
FOREIGN KEY(company_id) REFERENCES companies(id) on DELETE CASCADE
);