1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
|
use test;
SET NAMES cp1251;
drop table if exists
test.t8,
test.t7,
test.t6,
test.t5,
test.t4,
test.t3,
test.t2,
test.t1;
-- tables for checking of join composition
create table t1 (t1_id int, primary key (t1_id)) engine=innodb;
create table t2 (t2_id int, primary key (t2_id),
t1_id int, index(t1_id),
FOREIGN KEY (t1_id)
REFERENCES t1(t1_id)) engine=innodb;
create table t3 (t2_id int, primary key (t2_id),
silly_name int, index(silly_name),
FOREIGN KEY (silly_name)
REFERENCES t1(t1_id)) engine=innodb;
-- tables for checking of quotas in the composition
create table t4 (`field with complex name `` \\ "` int,
primary key (`field with complex name `` \\ "`)) engine=innodb;
create table t5 (t5_id int, primary key (t5_id),
`field with complex name `` \\ "` int,
index(`field with complex name `` \\ "`),
FOREIGN KEY (`field with complex name `` \\ "`)
REFERENCES t4(`field with complex name `` \\ "`)) engine=innodb;
create table t6 (t6_id int, primary key (t6_id),
silly_name int, index(silly_name),
FOREIGN KEY (silly_name)
REFERENCES t4(`field with complex name `` \\ "`)) engine=innodb;
create table t7 (`field with complex name `` \\ " 2` int,
primary key (`field with complex name `` \\ " 2`)) engine=myisam;
create table t8 (t8_id int, primary key (t8_id),
`field with complex name `` \\ " 2` int,
index(`field with complex name `` \\ " 2`),
FOREIGN KEY (`field with complex name `` \\ " 2`)
REFERENCES t7(`field with complex name `` \\ "`)) engine=myisam;
-- tables with utf-8 symbols
DROP TABLE IF EXISTS `2`;
CREATE TABLE `2` (
`1` VARCHAR (50) collate utf8_bin, primary key (`1`)
) DEFAULT CHARACTER SET utf8 COLLATE=utf8_bin;
INSERT INTO `2` VALUES ('1'),('2');
DROP TABLE IF EXISTS `1`;
CREATE TABLE `1` (
`2` VARCHAR(50) collate utf8_bin,
`1` VARCHAR(50) collate utf8_bin,
index(`1`),
FOREIGN KEY (`1`) REFERENCES t4(`1`)
) DEFAULT CHARACTER SET utf8 COLLATE=utf8_bin;
INSERT INTO `1` VALUES
('3','1_3'),
('4','1_4'),
('5','1_5');
|
