← Back to branch summary

~drizzle-trunk/drizzle/development 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23

# Drizzle's data dictionary, column specific test.

CREATE SCHEMA data_dictionary;
CREATE SCHEMA test_columns;

use test_columns;
CREATE TABLE types (
  a integer,
  b bigint,
  c varchar(10),
  d double,
  e blob,
  f enum("yes", "no"),
  g decimal,
  h date,
  j timestamp,
  k datetime
);

SELECT DATA_TYPE  FROM data_dictionary.columns WHERE TABLE_SCHEMA="test_columns" GROUP BY DATA_TYPE;

DROP SCHEMA test_columns;
DROP SCHEMA data_dictionary;