3 -- Define the most common datatypes in query.datatype. Note that none of
4 -- these stock datatypes specifies a width or precision.
6 -- Also: set the sequence for query.datatype to 1000, leaving plenty of
7 -- room for more stock datatypes if we ever want to add them.
9 INSERT INTO config.upgrade_log (version) VALUES ('0311'); -- Scott McKellar
11 SELECT setval( 'query.datatype_id_seq', 1000 );
13 INSERT INTO query.datatype (id, datatype_name, is_numeric )
14 VALUES (1, 'SMALLINT', true);
16 INSERT INTO query.datatype (id, datatype_name, is_numeric )
17 VALUES (2, 'INTEGER', true);
19 INSERT INTO query.datatype (id, datatype_name, is_numeric )
20 VALUES (3, 'BIGINT', true);
22 INSERT INTO query.datatype (id, datatype_name, is_numeric )
23 VALUES (4, 'DECIMAL', true);
25 INSERT INTO query.datatype (id, datatype_name, is_numeric )
26 VALUES (5, 'NUMERIC', true);
28 INSERT INTO query.datatype (id, datatype_name, is_numeric )
29 VALUES (6, 'REAL', true);
31 INSERT INTO query.datatype (id, datatype_name, is_numeric )
32 VALUES (7, 'DOUBLE PRECISION', true);
34 INSERT INTO query.datatype (id, datatype_name, is_numeric )
35 VALUES (8, 'SERIAL', true);
37 INSERT INTO query.datatype (id, datatype_name, is_numeric )
38 VALUES (9, 'BIGSERIAL', true);
40 INSERT INTO query.datatype (id, datatype_name, is_numeric )
41 VALUES (10, 'MONEY', false);
43 INSERT INTO query.datatype (id, datatype_name, is_numeric )
44 VALUES (11, 'VARCHAR', false);
46 INSERT INTO query.datatype (id, datatype_name, is_numeric )
47 VALUES (12, 'CHAR', false);
49 INSERT INTO query.datatype (id, datatype_name, is_numeric )
50 VALUES (13, 'TEXT', false);
52 INSERT INTO query.datatype (id, datatype_name, is_numeric )
53 VALUES (14, '"char"', false);
55 INSERT INTO query.datatype (id, datatype_name, is_numeric )
56 VALUES (15, 'NAME', false);
58 INSERT INTO query.datatype (id, datatype_name, is_numeric )
59 VALUES (16, 'BYTEA', false);
61 INSERT INTO query.datatype (id, datatype_name, is_numeric )
62 VALUES (17, 'TIMESTAMP WITHOUT TIME ZONE', false);
64 INSERT INTO query.datatype (id, datatype_name, is_numeric )
65 VALUES (18, 'TIMESTAMP WITH TIME ZONE', false);
67 INSERT INTO query.datatype (id, datatype_name, is_numeric )
68 VALUES (19, 'DATE', false);
70 INSERT INTO query.datatype (id, datatype_name, is_numeric )
71 VALUES (20, 'TIME WITHOUT TIME ZONE', false);
73 INSERT INTO query.datatype (id, datatype_name, is_numeric )
74 VALUES (21, 'TIME WITH TIME ZONE', false);
76 INSERT INTO query.datatype (id, datatype_name, is_numeric )
77 VALUES (22, 'INTERVAL', false);
79 INSERT INTO query.datatype (id, datatype_name, is_numeric )
80 VALUES (23, 'BOOLEAN', false);