Table: nornix_site.metadata
Structure | Name | Type | Null | Key | Default | Extra | Comment |
|---|
| No | int(10) unsigned | NO | PRI | 0 | | |
|---|
| ElementNo | int(10) unsigned | NO | PRI | 0 | | |
|---|
| Value | varchar(255) | NO | | | | |
|---|
Indexes| Non-unique | Key | Seq | Column | Collation | Cardinality | Sub part | Packed | Null | Type | Comment |
|---|
| 0 | PRIMARY | 2 | ElementNo | A | 6 | | | | BTREE | |
Information| Engine | Row format | Table collation | Create options |
|---|
| MyISAM | Dynamic | utf8_general_ci | |
CREATE TABLE `metadata` (
`No` int(10) unsigned NOT NULL default '',
`ElementNo` int(10) unsigned NOT NULL default '',
`Value` varchar(255) NOT NULL default '',
PRIMARY KEY (`No`,`ElementNo`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8