-
-
Notifications
You must be signed in to change notification settings - Fork 813
Closed
Description
Spotted this while playing around with Datasette Lite and ?install=datasette-visible-internal-db:
CREATE TABLE catalog_columns (
database_name TEXT,
table_name TEXT,
cid INTEGER,
name TEXT,
type TEXT,
"notnull" INTEGER,
default_value TEXT, -- renamed from dflt_value
is_pk INTEGER, -- renamed from pk
hidden INTEGER,
PRIMARY KEY (database_name, table_name, name),
FOREIGN KEY (database_name) REFERENCES databases(database_name),
FOREIGN KEY (database_name, table_name) REFERENCES tables(database_name, table_name)
);Those foreign key references should point to catalog_databases and catalog_tables.
Reactions are currently unavailable