SQL Schema Builder
1
[ 0.111s ] sqlite: #1 - create default table
2
[ 0.000s ] sqlite: #2 - $table->build() returns TableModifier
3
[ 0.002s ] sqlite: #3 - drop table
4
[ 0.012s ] sqlite: #4 - create new table with additional columns
5
[ 0.005s ] sqlite: #5 - adding column [BOOLEAN], nullable
6
[ 0.012s ] sqlite: #6 - adding column [INT1], nullable
7
[ 0.063s ] sqlite: #7 - adding column [INT2], nullable
8
[ 0.005s ] sqlite: #8 - adding column [INT4], nullable
9
[ 0.014s ] sqlite: #9 - adding column [INT8], nullable
10
[ 0.003s ] sqlite: #10 - adding column [FLOAT], nullable
11
[ 0.002s ] sqlite: #11 - adding column [DOUBLE], nullable
12
[ 0.002s ] sqlite: #12 - adding column [VARCHAR128], nullable
13
[ 0.002s ] sqlite: #13 - adding column [VARCHAR256], nullable
14
[ 0.002s ] sqlite: #14 - adding column [VARCHAR512], nullable
15
[ 0.002s ] sqlite: #15 - adding column [TEXT], nullable
16
[ 0.002s ] sqlite: #16 - adding column [LONGTEXT], nullable
17
[ 0.002s ] sqlite: #17 - adding column [DATE], nullable
18
[ 0.002s ] sqlite: #18 - adding column [DATETIME], nullable
19
[ 0.004s ] sqlite: #19 - adding column [TIMESTAMP], nullable
20
[ 0.006s ] sqlite: #20 - adding column [BLOB], nullable
21
[ 0.001s ] sqlite: #21 - reverse lookup compatible: YES, BOOLEAN: [BOOLEAN > BOOLEAN]
22
[ 0.000s ] sqlite: #22 - reverse lookup compatible: YES, INT1: [integer(4) > integer(4)]
23
[ 0.000s ] sqlite: #23 - reverse lookup compatible: YES, INT2: [integer(6) > integer(6)]
24
[ 0.000s ] sqlite: #24 - reverse lookup compatible: YES, INT4: [integer(11) > integer(11)]
25
[ 0.000s ] sqlite: #25 - reverse lookup compatible: YES, INT8: [integer(20) > integer(20)]
26
[ 0.000s ] sqlite: #26 - reverse lookup compatible: YES, FLOAT: [FLOAT > FLOAT]
27
[ 0.000s ] sqlite: #27 - reverse lookup compatible: YES, DOUBLE: [decimal(15,6) > decimal(15,6)]
28
[ 0.000s ] sqlite: #28 - reverse lookup compatible: YES, VARCHAR128: [varchar(128) > varchar(128)]
29
[ 0.000s ] sqlite: #29 - reverse lookup compatible: YES, VARCHAR256: [varchar(255) > varchar(255)]
30
[ 0.000s ] sqlite: #30 - reverse lookup compatible: YES, VARCHAR512: [varchar(512) > varchar(512)]
31
[ 0.000s ] sqlite: #31 - reverse lookup compatible: YES, TEXT: [text > text]
32
[ 0.000s ] sqlite: #32 - reverse lookup compatible: YES, LONGTEXT: [text > text]
33
[ 0.000s ] sqlite: #33 - reverse lookup compatible: YES, DATE: [date > date]
34
[ 0.000s ] sqlite: #34 - reverse lookup compatible: YES, DATETIME: [datetime > datetime]
35
[ 0.000s ] sqlite: #35 - reverse lookup compatible: YES, TIMESTAMP: [DATETIME > DATETIME]
36
[ 0.000s ] sqlite: #36 - reverse lookup compatible: YES, BLOB: [blob > blob]
37
[ 0.011s ] sqlite: #37 - mapping dummy data
38
[ 0.000s ] sqlite: #38 - testing float value: 123.456
39
[ 0.000s ] sqlite: #39 - testing decimal value: 123456.789012
40
[ 0.003s ] sqlite: #40 - testing max decimal precision: 123456789.01235 (/home/ikkez/domains/f3.ikkez.de/public_html/sugar/SchemaBuilder/test/schema.php:174)
41
[ 0.074s ] sqlite: #41 - adding column [VARCHAR128], not nullable with default value
42
[ 0.023s ] sqlite: #42 - mapping dummy data
43
[ 0.003s ] sqlite: #43 - adding column [INT4], not nullable with default value
44
[ 0.003s ] sqlite: #44 - mapping dummy data
45
[ 0.003s ] sqlite: #45 - adding column [VARCHAR128], nullable with default value
46
[ 0.111s ] sqlite: #46 - mapping dummy data
47
[ 0.005s ] sqlite: #47 - adding column [INT4], nullable with default value
48
[ 0.024s ] sqlite: #48 - mapping dummy data
49
[ 0.012s ] sqlite: #49 - adding column [TIMESTAMP], not nullable with current_timestamp default value
50
[ 0.012s ] sqlite: #50 - adding column [DATETIME], nullable, no default
51
[ 0.013s ] sqlite: #51 - mapping dummy data
52
[ 0.010s ] sqlite: #52 - renaming column
53
[ 0.005s ] sqlite: #53 - mapping dummy data
54
[ 0.014s ] sqlite: #54 - removing column
55
[ 0.003s ] sqlite: #55 - renaming table
56
[ 0.021s ] sqlite: #56 - check record count
57
[ 0.016s ] sqlite: #57 - adding composite primary-keys
58
[ 0.001s ] sqlite: #58 - check record count
59
[ 0.010s ] sqlite: #59 - drop table
60
[ 0.011s ] sqlite: #60 - creating new table with composite key
61
[ 0.000s ] sqlite: #61 - default value on composite primary key
62
[ 0.023s ] sqlite: #62 - adding more fields to composite pk table
63
[ 0.069s ] sqlite: #63 - adding items with composite primary-keys
64
[ 0.011s ] sqlite: #64 - truncate table
65
[ 0.155s ] sqlite: #65 - adding column with options array
66
[ 0.000s ] sqlite: #66 - column index on table creation
67
[ 0.004s ] sqlite: #67 - column index on table alteration
68
[ 0.000s ] sqlite: #68 - unique index
69
[ 0.000s ] sqlite: #69 - index on combined columns
70
[ 0.017s ] sqlite: #70 - preserve indexes after table rebuild
71
[ 0.084s ] sqlite: #71 - drop index
72
[ 0.023s ] sqlite: #72 - update column
73
[ 0.029s ] sqlite: #73 - update column and default
74
[ 0.086s ] sqlite: #74 - update default value
75
[ 0.043s ] sqlite: #75 - update nullable flag
76
[ 0.008s ] sqlite: #76 - create new table with not nullable text column
77
[ 0.008s ] sqlite: #77 - create new table with not nullable boolean column
78
[ 0.003s ] sqlite: #78 - add not nullable boolean columns with default to existing table
79
[ 0.057s ] mysql: #1 - create default table
80
[ 0.000s ] mysql: #2 - $table->build() returns TableModifier
81
[ 0.004s ] mysql: #3 - drop table
82
[ 0.021s ] mysql: #4 - create new table with additional columns
83
[ 0.009s ] mysql: #5 - adding column [BOOLEAN], nullable
84
[ 0.014s ] mysql: #6 - adding column [INT1], nullable
85
[ 0.003s ] mysql: #7 - adding column [INT2], nullable
86
[ 0.003s ] mysql: #8 - adding column [INT4], nullable
87
[ 0.003s ] mysql: #9 - adding column [INT8], nullable
88
[ 0.002s ] mysql: #10 - adding column [FLOAT], nullable
89
[ 0.003s ] mysql: #11 - adding column [DOUBLE], nullable
90
[ 0.003s ] mysql: #12 - adding column [VARCHAR128], nullable
91
[ 0.002s ] mysql: #13 - adding column [VARCHAR256], nullable
92
[ 0.003s ] mysql: #14 - adding column [VARCHAR512], nullable
93
[ 0.002s ] mysql: #15 - adding column [TEXT], nullable
94
[ 0.003s ] mysql: #16 - adding column [LONGTEXT], nullable
95
[ 0.005s ] mysql: #17 - adding column [DATE], nullable
96
[ 0.003s ] mysql: #18 - adding column [DATETIME], nullable
97
[ 0.003s ] mysql: #19 - adding column [TIMESTAMP], nullable
98
[ 0.003s ] mysql: #20 - adding column [BLOB], nullable
99
[ 0.001s ] mysql: #21 - reverse lookup compatible: YES, BOOLEAN: [tinyint(1) > tinyint(1)]
100
[ 0.000s ] mysql: #22 - reverse lookup compatible: YES, INT1: [tinyint(4) > tinyint(4)]
101
[ 0.000s ] mysql: #23 - reverse lookup compatible: YES, INT2: [smallint(6) > smallint(6)]
102
[ 0.000s ] mysql: #24 - reverse lookup compatible: YES, INT4: [int(11) > int(11)]
103
[ 0.000s ] mysql: #25 - reverse lookup compatible: YES, INT8: [bigint(20) > bigint(20)]
104
[ 0.000s ] mysql: #26 - reverse lookup compatible: YES, FLOAT: [FLOAT > float]
105
[ 0.000s ] mysql: #27 - reverse lookup compatible: YES, DOUBLE: [decimal(18,6) > decimal(18,6)]
106
[ 0.000s ] mysql: #28 - reverse lookup compatible: YES, VARCHAR128: [varchar(128) > varchar(128)]
107
[ 0.000s ] mysql: #29 - reverse lookup compatible: YES, VARCHAR256: [varchar(255) > varchar(255)]
108
[ 0.000s ] mysql: #30 - reverse lookup compatible: YES, VARCHAR512: [varchar(512) > varchar(512)]
109
[ 0.000s ] mysql: #31 - reverse lookup compatible: YES, TEXT: [text > text]
110
[ 0.000s ] mysql: #32 - reverse lookup compatible: YES, LONGTEXT: [LONGTEXT > longtext]
111
[ 0.000s ] mysql: #33 - reverse lookup compatible: YES, DATE: [date > date]
112
[ 0.000s ] mysql: #34 - reverse lookup compatible: YES, DATETIME: [datetime > datetime]
113
[ 0.000s ] mysql: #35 - reverse lookup compatible: YES, TIMESTAMP: [timestamp > timestamp]
114
[ 0.000s ] mysql: #36 - reverse lookup compatible: YES, BLOB: [blob > blob]
115
[ 0.003s ] mysql: #37 - mapping dummy data
116
[ 0.000s ] mysql: #38 - testing float value: 123.456
117
[ 0.000s ] mysql: #39 - testing decimal value: 123456.789012
118
[ 0.003s ] mysql: #40 - testing max decimal precision: 123456789012.345678
119
[ 0.010s ] mysql: #41 - adding column [VARCHAR128], not nullable with default value
120
[ 0.003s ] mysql: #42 - mapping dummy data
121
[ 0.002s ] mysql: #43 - adding column [INT4], not nullable with default value
122
[ 0.003s ] mysql: #44 - mapping dummy data
123
[ 0.003s ] mysql: #45 - adding column [VARCHAR128], nullable with default value
124
[ 0.005s ] mysql: #46 - mapping dummy data
125
[ 0.003s ] mysql: #47 - adding column [INT4], nullable with default value
126
[ 0.004s ] mysql: #48 - mapping dummy data
127
[ 0.003s ] mysql: #49 - adding column [TIMESTAMP], not nullable with current_timestamp default value
128
[ 0.003s ] mysql: #50 - adding column [DATETIME], nullable, no default
129
[ 0.017s ] mysql: #51 - mapping dummy data
130
[ 0.022s ] mysql: #52 - renaming column
131
[ 0.003s ] mysql: #53 - mapping dummy data
132
[ 0.080s ] mysql: #54 - removing column
133
[ 0.003s ] mysql: #55 - renaming table
134
[ 0.014s ] mysql: #56 - check record count
135
[ 0.020s ] mysql: #57 - adding composite primary-keys
136
[ 0.002s ] mysql: #58 - check record count
137
[ 0.005s ] mysql: #59 - drop table
138
[ 0.029s ] mysql: #60 - creating new table with composite key
139
[ 0.000s ] mysql: #61 - default value on composite primary key
140
[ 0.006s ] mysql: #62 - adding more fields to composite pk table
141
[ 0.005s ] mysql: #63 - adding items with composite primary-keys
142
[ 0.030s ] mysql: #64 - truncate table
143
[ 0.042s ] mysql: #65 - adding column with options array
144
[ 0.000s ] mysql: #66 - column index on table creation
145
[ 0.023s ] mysql: #67 - column index on table alteration
146
[ 0.000s ] mysql: #68 - unique index
147
[ 0.000s ] mysql: #69 - index on combined columns
148
[ 0.003s ] mysql: #70 - drop index
149
[ 0.063s ] mysql: #71 - update column
150
[ 0.037s ] mysql: #72 - update column and default
151
[ 0.002s ] mysql: #73 - update default value
152
[ 0.046s ] mysql: #74 - update nullable flag
153
[ 0.021s ] mysql: #75 - create new table with not nullable text column
154
[ 0.022s ] mysql: #76 - create new table with not nullable boolean column
155
[ 0.005s ] mysql: #77 - add not nullable boolean columns with default to existing table
156
[ 0.035s ] pgsql: #1 - create default table
157
[ 0.000s ] pgsql: #2 - $table->build() returns TableModifier
158
[ 0.004s ] pgsql: #3 - drop table
159
[ 0.108s ] pgsql: #4 - create new table with additional columns
160
[ 0.058s ] pgsql: #5 - adding column [BOOLEAN], nullable
161
[ 0.020s ] pgsql: #6 - adding column [INT1], nullable
162
[ 0.020s ] pgsql: #7 - adding column [INT2], nullable
163
[ 0.019s ] pgsql: #8 - adding column [INT4], nullable
164
[ 0.017s ] pgsql: #9 - adding column [INT8], nullable
165
[ 0.025s ] pgsql: #10 - adding column [FLOAT], nullable
166
[ 0.021s ] pgsql: #11 - adding column [DOUBLE], nullable
167
[ 0.021s ] pgsql: #12 - adding column [VARCHAR128], nullable
168
[ 0.023s ] pgsql: #13 - adding column [VARCHAR256], nullable
169
[ 0.022s ] pgsql: #14 - adding column [VARCHAR512], nullable
170
[ 0.022s ] pgsql: #15 - adding column [TEXT], nullable
171
[ 0.019s ] pgsql: #16 - adding column [LONGTEXT], nullable
172
[ 0.019s ] pgsql: #17 - adding column [DATE], nullable
173
[ 0.018s ] pgsql: #18 - adding column [DATETIME], nullable
174
[ 0.018s ] pgsql: #19 - adding column [TIMESTAMP], nullable
175
[ 0.019s ] pgsql: #20 - adding column [BLOB], nullable
176
[ 0.014s ] pgsql: #21 - reverse lookup compatible: YES, BOOLEAN: [BOOLEAN > boolean]
177
[ 0.000s ] pgsql: #22 - reverse lookup compatible: YES, INT1: [smallint > smallint]
178
[ 0.000s ] pgsql: #23 - reverse lookup compatible: YES, INT2: [smallint > smallint]
179
[ 0.000s ] pgsql: #24 - reverse lookup compatible: YES, INT4: [integer > integer]
180
[ 0.000s ] pgsql: #25 - reverse lookup compatible: YES, INT8: [bigint > bigint]
181
[ 0.000s ] pgsql: #26 - reverse lookup compatible: YES, FLOAT: [double precision > double precision]
182
[ 0.000s ] pgsql: #27 - reverse lookup compatible: YES, DOUBLE: [numeric(18,6) > numeric]
183
[ 0.000s ] pgsql: #28 - reverse lookup compatible: YES, VARCHAR128: [character varying(128) > character varying]
184
[ 0.000s ] pgsql: #29 - reverse lookup compatible: YES, VARCHAR256: [character varying(255) > character varying]
185
[ 0.000s ] pgsql: #30 - reverse lookup compatible: YES, VARCHAR512: [character varying(512) > character varying]
186
[ 0.000s ] pgsql: #31 - reverse lookup compatible: YES, TEXT: [text > text]
187
[ 0.000s ] pgsql: #32 - reverse lookup compatible: YES, LONGTEXT: [text > text]
188
[ 0.000s ] pgsql: #33 - reverse lookup compatible: YES, DATE: [date > date]
189
[ 0.000s ] pgsql: #34 - reverse lookup compatible: YES, DATETIME: [timestamp without time zone > timestamp without time zone]
190
[ 0.000s ] pgsql: #35 - reverse lookup compatible: YES, TIMESTAMP: [timestamp without time zone > timestamp without time zone]
191
[ 0.000s ] pgsql: #36 - reverse lookup compatible: YES, BLOB: [bytea > bytea]
192
[ 0.019s ] pgsql: #37 - mapping dummy data
193
[ 0.000s ] pgsql: #38 - testing float value: 123.456
194
[ 0.000s ] pgsql: #39 - testing decimal value: 123456.789012
195
[ 0.017s ] pgsql: #40 - testing max decimal precision: 123456789012.345678
196
[ 0.027s ] pgsql: #41 - adding column [VARCHAR128], not nullable with default value
197
[ 0.018s ] pgsql: #42 - mapping dummy data
198
[ 0.108s ] pgsql: #43 - adding column [INT4], not nullable with default value
199
[ 0.016s ] pgsql: #44 - mapping dummy data
200
[ 0.101s ] pgsql: #45 - adding column [VARCHAR128], nullable with default value
201
[ 0.021s ] pgsql: #46 - mapping dummy data
202
[ 0.036s ] pgsql: #47 - adding column [INT4], nullable with default value
203
[ 0.023s ] pgsql: #48 - mapping dummy data
204
[ 0.030s ] pgsql: #49 - adding column [TIMESTAMP], not nullable with current_timestamp default value
205
[ 0.019s ] pgsql: #50 - adding column [DATETIME], nullable, no default
206
[ 0.018s ] pgsql: #51 - mapping dummy data
207
[ 0.049s ] pgsql: #52 - renaming column
208
[ 0.019s ] pgsql: #53 - mapping dummy data
209
[ 0.074s ] pgsql: #54 - removing column
210
[ 0.005s ] pgsql: #55 - renaming table
211
[ 0.022s ] pgsql: #56 - check record count
212
[ 0.056s ] pgsql: #57 - adding composite primary-keys
213
[ 0.017s ] pgsql: #58 - check record count
214
[ 0.006s ] pgsql: #59 - drop table
215
[ 0.090s ] pgsql: #60 - creating new table with composite key
216
[ 0.000s ] pgsql: #61 - default value on composite primary key
217
[ 0.435s ] pgsql: #62 - adding more fields to composite pk table
218
[ 0.019s ] pgsql: #63 - adding items with composite primary-keys
219
[ 0.036s ] pgsql: #64 - truncate table
220
[ 0.083s ] pgsql: #65 - adding column with options array
221
[ 0.002s ] pgsql: #66 - column index on table creation
222
[ 0.088s ] pgsql: #67 - column index on table alteration
223
[ 0.000s ] pgsql: #68 - unique index
224
[ 0.000s ] pgsql: #69 - index on combined columns
225
[ 0.004s ] pgsql: #70 - drop index
226
[ 0.017s ] pgsql: #71 - update column
227
[ 0.057s ] pgsql: #72 - update column and default
228
[ 0.040s ] pgsql: #73 - update default value
229
[ 0.022s ] pgsql: #74 - update nullable flag
230
[ 0.056s ] pgsql: #75 - create new table with not nullable text column
231
[ 0.057s ] pgsql: #76 - create new table with not nullable boolean column
232
[ 0.045s ] pgsql: #77 - add not nullable boolean columns with default to existing table
Page rendered in 4196.22 msecs / Memory usage 2097.2 Kibytes