Table: nornix_site.blocktemplate
Structure Block templates| Name | Type | Null | Key | Default | Extra | Comment |
|---|
| Script | text | NO | | | | |
|---|
| Type | tinyint(3) unsigned | NO | | 0 | | |
|---|
| Block | varchar(16) | NO | UNI | | | |
|---|
| BlockNo | smallint(6) | NO | PRI | | | |
|---|
Indexes| Non-unique | Key | Seq | Column | Collation | Cardinality | Sub part | Packed | Null | Type | Comment |
|---|
| 0 | Block | 1 | Block | A | 1 | | | | BTREE | |
Information| Engine | Row format | Table collation | Create options |
|---|
| MyISAM | Dynamic | utf8_general_ci | |
CREATE TABLE `blocktemplate` (
`Script` text NOT NULL,
`Type` tinyint(3) unsigned NOT NULL default '',
`Block` varchar(16) NOT NULL,
`BlockNo` smallint(6) NOT NULL,
PRIMARY KEY (`BlockNo`),
UNIQUE KEY `Block` (`Block`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Block templates'