· 8 years ago · Dec 01, 2017, 06:56 PM
1CREATE TABLE IF NOT EXISTS scanpoint (
2 xxx CHAR(6) NOT NULL DEFAULT '',
3 YYYYYYY CHAR(2) NOT NULL DEFAULT '',
4 ZZZZZZ SMALLINT UNSIGNED NOT NULL DEFAULT 0,
5 AAAAAA CHAR(3) NOT NULL DEFAULT '',
6 BBBBBB TINYINT UNSIGNED NOT NULL DEFAULT 0,
7 CCCCCC TIMESTAMP
8 );
9
10CHAR: 11 bytes =6+2+3
11SMALLINT: 2 bytes
12TINYINT: 1 byte
13TIMESTMAP: 7 bytes?