metadata

NAME

metadata: Information about the common_schema project.

TYPE

Table

DESCRIPTION

metadata is a two-columns table, in key-value format, which lists some internal and general information on the project.

Information includes distribution version, repository, license and author info.

STRUCTURE

mysql> DESC common_schema.metadata;
+-----------------+---------------+------+-----+---------+-------+
| Field           | Type          | Null | Key | Default | Extra |
+-----------------+---------------+------+-----+---------+-------+
| attribute_name  | varchar(32)   | NO   | PRI | NULL    |       |
| attribute_value | varchar(2048) | NO   |     | NULL    |       |
+-----------------+---------------+------+-----+---------+-------+

SYNOPSIS

Columns of this table:

  • attribute_name: metadata key
  • attribute_value: metadata value

EXAMPLES

Get repository information:

mysql> SELECT * FROM metadata WHERE attribute_name like '%repository%';
+-------------------------+-------------------------------------------------+
| attribute_name          | attribute_value                                 |
+-------------------------+-------------------------------------------------+
| project_repository      | https://common-schema.googlecode.com/svn/trunk/ |
| project_repository_type | svn                                             |
+-------------------------+-------------------------------------------------+

ENVIRONMENT

MySQL 5.1 or newer.

SEE ALSO

help()

AUTHOR

Shlomi Noach
 
common_schema documentation