With that change, the script fails further on with the creation of the
registrations table:
ERROR X0Y46: Constraint 'REGISTRNS_1' is invalid: referenced table USERS
does not exist.
On 2/11/24 3:48 AM, John English wrote:
Either delete the constraint, or add "studentid integer" to the table
definition.
On Sat, 10 Feb 2024, 23:13 Rick Hillegas, <[email protected]> wrote:
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)
)
