Description
noneTable properties
| name | value |
|---|
| name | country
|
| created | 3/19/2009 11:39:17 PM
|
| modified |
|
| row count | 109
|
| Size of data | 16 kb
|
| Size of indexes | 0 kb |
| average row size | 150 b
|
| engine | InnoDB
|
| version | 10
|
| row format | Compact
|
| max data length | 0 kb
|
| data free | 5242880
|
| auto increment | 110
|
| table collation | utf8_general_ci
|
| create options |
|
Columns
| column | datatype | length | bytes | precision | scale | default | nulls | PK | FK | UQ | extra | privileges | comment |
|---|
| country_id
| smallint(5) unsigned
|
|
| 5
| 0
|
| NO
| yes
|
| yes
| auto_increment
| select,insert,update,references
|
|
| country
| varchar(50)
| 50
| 150
|
|
|
| NO
|
|
|
|
| select,insert,update,references
|
|
| last_update
| timestamp
|
|
|
|
| CURRENT_TIMESTAMP
| NO
|
|
|
| on update CURRENT_TIMESTAMP
| select,insert,update,references
|
|
Indexes
| name | columns | unique | cardinality | type | comment |
|---|
| PRIMARY
| country_id
| yes
| 109
| BTREE
|
|
Referenced by
Foreign key graph
Dependency graph
Objects that depend on country
Sample rows
| country_id | country | last_update |
|---|
| 1
| Afghanistan
| 2/15/2006 4:44:00 AM
|
| 2
| Algeria
| 2/15/2006 4:44:00 AM
|
| 3
| American Samoa
| 2/15/2006 4:44:00 AM
|
| 4
| Angola
| 2/15/2006 4:44:00 AM
|
| 5
| Anguilla
| 2/15/2006 4:44:00 AM
|
| 6
| Argentina
| 2/15/2006 4:44:00 AM
|
| 7
| Armenia
| 2/15/2006 4:44:00 AM
|
| 8
| Australia
| 2/15/2006 4:44:00 AM
|
| 9
| Austria
| 2/15/2006 4:44:00 AM
|
| 10
| Azerbaijan
| 2/15/2006 4:44:00 AM
|
Code
CREATE TABLE `country` (
`country_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`country` varchar(50) NOT NULL,
`last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`country_id`)
) ENGINE=InnoDB AUTO_INCREMENT=110 DEFAULT CHARSET=utf8