schematables — This table is the documentation for the database tables.
| Column name | Type | Null | Default | Description |
|---|---|---|---|---|
| tablename | varchar(40) | The name of the table being described. | ||
| public_browsable | enum('0','1') | 0 | If set to 1, users can view the data in this table from the web. (lookup tables only) | |
| redist_mode | enum('off','insert','replace') | off | Determines 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_where | varchar(255) | YES | ||
| des | text | YES | A description of the table, for use in the schema browser, and in the LJ manual. |
| Key name | Type | Column(s) |
|---|---|---|
| PRIMARY | PRIMARY |