1drop table if exists t1;
2CREATE TABLE t1 (
3kodoboru varchar(10) default NULL,
4obor tinytext,
5aobor tinytext,
6UNIQUE INDEX kodoboru (kodoboru),
7FULLTEXT KEY obor (obor),
8FULLTEXT KEY aobor (aobor)
9);
10INSERT INTO t1 VALUES ('0101000000','aaa','AAA');
11INSERT INTO t1 VALUES ('0102000000','bbb','BBB');
12INSERT INTO t1 VALUES ('0103000000','ccc','CCC');
13INSERT INTO t1 VALUES ('0104000000','xxx','XXX');
14select * from t1;
15kodoboru	obor	aobor
160101000000	aaa	AAA
170102000000	bbb	BBB
180103000000	ccc	CCC
190104000000	xxx	XXX
20drop table t1;
21