schematables

schematables — This table is the documentation for the database tables.

schematables

Column nameTypeNullDefaultDescription
tablenamevarchar(40)The name of the table being described.
public_browsableenum('0','1')0If set to 1, users can view the data in this table from the web. (lookup tables only)
redist_modeenum('off','insert','replace')offDetermines if data from this table is made available in the LJ source distribution. And if so, is it to be updated with upgrades (REPLACE INTO) or just inserted once.
redist_wherevarchar(255)YES
destextYESA description of the table, for use in the schema browser, and in the LJ manual.
Key nameTypeColumn(s)
PRIMARYPRIMARY