SQL Schema Builder

1 [ 0.082s ] sqlite: #1 - create default table

2 [ 0.000s ] sqlite: #2 - $table->build() returns TableModifier

3 [ 0.002s ] sqlite: #3 - drop table

4 [ 0.006s ] sqlite: #4 - create new table with additional columns

5 [ 0.005s ] sqlite: #5 - adding column [BOOLEAN], nullable

6 [ 0.006s ] sqlite: #6 - adding column [INT1], nullable

7 [ 0.006s ] sqlite: #7 - adding column [INT2], nullable

8 [ 0.005s ] sqlite: #8 - adding column [INT4], nullable

9 [ 0.006s ] sqlite: #9 - adding column [INT8], nullable

10 [ 0.006s ] sqlite: #10 - adding column [FLOAT], nullable

11 [ 0.006s ] sqlite: #11 - adding column [DOUBLE], nullable

12 [ 0.005s ] sqlite: #12 - adding column [VARCHAR128], nullable

13 [ 0.006s ] sqlite: #13 - adding column [VARCHAR256], nullable

14 [ 0.006s ] sqlite: #14 - adding column [VARCHAR512], nullable

15 [ 0.008s ] sqlite: #15 - adding column [TEXT], nullable

16 [ 0.005s ] sqlite: #16 - adding column [LONGTEXT], nullable

17 [ 0.006s ] sqlite: #17 - adding column [DATE], nullable

18 [ 0.006s ] sqlite: #18 - adding column [DATETIME], nullable

19 [ 0.005s ] 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.005s ] 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.004s ] sqlite: #40 - testing max decimal precision: 123456789.01235 (/home/ikkez/domains/f3.ikkez.de/public_html/sugar/SchemaBuilder/test/schema.php:174)

41 [ 0.006s ] sqlite: #41 - adding column [VARCHAR128], not nullable with default value

42 [ 0.006s ] sqlite: #42 - mapping dummy data

43 [ 0.005s ] sqlite: #43 - adding column [INT4], not nullable with default value

44 [ 0.020s ] sqlite: #44 - mapping dummy data

45 [ 0.008s ] sqlite: #45 - adding column [VARCHAR128], nullable with default value

46 [ 0.010s ] sqlite: #46 - mapping dummy data

47 [ 0.012s ] sqlite: #47 - adding column [INT4], nullable with default value

48 [ 0.023s ] sqlite: #48 - mapping dummy data

49 [ 0.011s ] sqlite: #49 - adding column [TIMESTAMP], not nullable with current_timestamp default value

50 [ 0.005s ] sqlite: #50 - adding column [DATETIME], nullable, no default

51 [ 0.005s ] sqlite: #51 - mapping dummy data

52 [ 0.008s ] sqlite: #52 - renaming column

53 [ 0.005s ] sqlite: #53 - mapping dummy data

54 [ 0.011s ] sqlite: #54 - removing column

55 [ 0.006s ] sqlite: #55 - renaming table

56 [ 0.007s ] sqlite: #56 - check record count

57 [ 0.010s ] sqlite: #57 - adding composite primary-keys

58 [ 0.002s ] sqlite: #58 - check record count

59 [ 0.007s ] sqlite: #59 - drop table

60 [ 0.061s ] sqlite: #60 - creating new table with composite key

61 [ 0.000s ] sqlite: #61 - default value on composite primary key

62 [ 0.005s ] sqlite: #62 - adding more fields to composite pk table

63 [ 0.017s ] sqlite: #63 - adding items with composite primary-keys

64 [ 0.006s ] sqlite: #64 - truncate table

65 [ 0.011s ] sqlite: #65 - adding column with options array

66 [ 0.000s ] sqlite: #66 - column index on table creation

67 [ 0.012s ] 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.034s ] sqlite: #70 - preserve indexes after table rebuild

71 [ 0.006s ] sqlite: #71 - drop index

72 [ 0.017s ] sqlite: #72 - update column

73 [ 0.034s ] sqlite: #73 - update column and default

74 [ 0.026s ] sqlite: #74 - update default value

75 [ 0.023s ] sqlite: #75 - update nullable flag

76 [ 0.006s ] sqlite: #76 - create new table with not nullable text column

77 [ 0.010s ] sqlite: #77 - create new table with not nullable boolean column

78 [ 0.006s ] sqlite: #78 - add not nullable boolean columns with default to existing table

79 [ 0.031s ] mysql: #1 - create default table

80 [ 0.000s ] mysql: #2 - $table->build() returns TableModifier

81 [ 0.003s ] mysql: #3 - drop table

82 [ 0.014s ] mysql: #4 - create new table with additional columns

83 [ 0.003s ] mysql: #5 - adding column [BOOLEAN], nullable

84 [ 0.002s ] mysql: #6 - adding column [INT1], nullable

85 [ 0.002s ] mysql: #7 - adding column [INT2], nullable

86 [ 0.002s ] mysql: #8 - adding column [INT4], nullable

87 [ 0.002s ] mysql: #9 - adding column [INT8], nullable

88 [ 0.002s ] mysql: #10 - adding column [FLOAT], nullable

89 [ 0.002s ] mysql: #11 - adding column [DOUBLE], nullable

90 [ 0.002s ] mysql: #12 - adding column [VARCHAR128], nullable

91 [ 0.002s ] mysql: #13 - adding column [VARCHAR256], nullable

92 [ 0.002s ] mysql: #14 - adding column [VARCHAR512], nullable

93 [ 0.003s ] mysql: #15 - adding column [TEXT], nullable

94 [ 0.006s ] mysql: #16 - adding column [LONGTEXT], nullable

95 [ 0.002s ] mysql: #17 - adding column [DATE], nullable

96 [ 0.002s ] mysql: #18 - adding column [DATETIME], nullable

97 [ 0.002s ] 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.002s ] 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.002s ] mysql: #50 - adding column [DATETIME], nullable, no default

129 [ 0.003s ] mysql: #51 - mapping dummy data

130 [ 0.016s ] mysql: #52 - renaming column

131 [ 0.003s ] mysql: #53 - mapping dummy data

132 [ 0.017s ] mysql: #54 - removing column

133 [ 0.004s ] mysql: #55 - renaming table

134 [ 0.005s ] mysql: #56 - check record count

135 [ 0.014s ] mysql: #57 - adding composite primary-keys

136 [ 0.002s ] mysql: #58 - check record count

137 [ 0.003s ] mysql: #59 - drop table

138 [ 0.036s ] 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.016s ] mysql: #64 - truncate table

143 [ 0.021s ] mysql: #65 - adding column with options array

144 [ 0.000s ] mysql: #66 - column index on table creation

145 [ 0.012s ] 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.021s ] mysql: #71 - update column

150 [ 0.022s ] mysql: #72 - update column and default

151 [ 0.002s ] mysql: #73 - update default value

152 [ 0.016s ] mysql: #74 - update nullable flag

153 [ 0.015s ] 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.044s ] pgsql: #1 - create default table

157 [ 0.000s ] pgsql: #2 - $table->build() returns TableModifier

158 [ 0.006s ] pgsql: #3 - drop table

159 [ 0.036s ] pgsql: #4 - create new table with additional columns

160 [ 0.027s ] pgsql: #5 - adding column [BOOLEAN], nullable

161 [ 0.019s ] pgsql: #6 - adding column [INT1], nullable

162 [ 0.026s ] pgsql: #7 - adding column [INT2], nullable

163 [ 0.018s ] pgsql: #8 - adding column [INT4], nullable

164 [ 0.019s ] pgsql: #9 - adding column [INT8], nullable

165 [ 0.019s ] pgsql: #10 - adding column [FLOAT], nullable

166 [ 0.019s ] pgsql: #11 - adding column [DOUBLE], nullable

167 [ 0.019s ] pgsql: #12 - adding column [VARCHAR128], nullable

168 [ 0.022s ] pgsql: #13 - adding column [VARCHAR256], nullable

169 [ 0.018s ] pgsql: #14 - adding column [VARCHAR512], nullable

170 [ 0.018s ] pgsql: #15 - adding column [TEXT], nullable

171 [ 0.018s ] pgsql: #16 - adding column [LONGTEXT], nullable

172 [ 0.019s ] pgsql: #17 - adding column [DATE], nullable

173 [ 0.019s ] pgsql: #18 - adding column [DATETIME], nullable

174 [ 0.020s ] pgsql: #19 - adding column [TIMESTAMP], nullable

175 [ 0.019s ] pgsql: #20 - adding column [BLOB], nullable

176 [ 0.015s ] 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.021s ] pgsql: #40 - testing max decimal precision: 123456789012.345678

196 [ 0.039s ] pgsql: #41 - adding column [VARCHAR128], not nullable with default value

197 [ 0.019s ] pgsql: #42 - mapping dummy data

198 [ 0.063s ] pgsql: #43 - adding column [INT4], not nullable with default value

199 [ 0.018s ] pgsql: #44 - mapping dummy data

200 [ 0.037s ] pgsql: #45 - adding column [VARCHAR128], nullable with default value

201 [ 0.022s ] pgsql: #46 - mapping dummy data

202 [ 0.039s ] pgsql: #47 - adding column [INT4], nullable with default value

203 [ 0.022s ] pgsql: #48 - mapping dummy data

204 [ 0.045s ] 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.019s ] pgsql: #51 - mapping dummy data

207 [ 0.050s ] pgsql: #52 - renaming column

208 [ 0.020s ] pgsql: #53 - mapping dummy data

209 [ 0.069s ] pgsql: #54 - removing column

210 [ 0.004s ] pgsql: #55 - renaming table

211 [ 0.017s ] pgsql: #56 - check record count

212 [ 0.053s ] pgsql: #57 - adding composite primary-keys

213 [ 0.020s ] pgsql: #58 - check record count

214 [ 0.006s ] pgsql: #59 - drop table

215 [ 0.030s ] pgsql: #60 - creating new table with composite key

216 [ 0.000s ] pgsql: #61 - default value on composite primary key

217 [ 0.035s ] pgsql: #62 - adding more fields to composite pk table

218 [ 0.023s ] pgsql: #63 - adding items with composite primary-keys

219 [ 0.027s ] pgsql: #64 - truncate table

220 [ 0.037s ] pgsql: #65 - adding column with options array

221 [ 0.002s ] pgsql: #66 - column index on table creation

222 [ 0.048s ] 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.005s ] pgsql: #70 - drop index

226 [ 0.017s ] pgsql: #71 - update column

227 [ 0.058s ] pgsql: #72 - update column and default

228 [ 0.042s ] pgsql: #73 - update default value

229 [ 0.025s ] pgsql: #74 - update nullable flag

230 [ 0.035s ] pgsql: #75 - create new table with not nullable text column

231 [ 0.034s ] pgsql: #76 - create new table with not nullable boolean column

232 [ 0.033s ] pgsql: #77 - add not nullable boolean columns with default to existing table


Page rendered in 2559.87 msecs / Memory usage 2097.2 Kibytes