I get the following error when I run this DDL:ERROR 42X93: Table 'ACTIVE_LIST' contains a constraint definition with column 'STUDENTID' which is not in the table.
On 2/10/24 6:03 AM, John English wrote:
CREATE TABLE active_list ( username VARCHAR(15) NOT NULL, surname VARCHAR(255) NOT NULL, initials VARCHAR(255) NOT NULL DEFAULT '', email VARCHAR(255) NOT NULL DEFAULT '', settings CLOB, CONSTRAINT active_pk PRIMARY KEY (username), CONSTRAINT active_1 UNIQUE (studentid) )