Line data Source code
1 : unsigned char _10_sys_schema_extension_sql[10937] = {
2 : "CREATE TABLE sys.keywords (\n"
3 : " keyword VARCHAR(40) NOT NULL PRIMARY KEY);\n"
4 : "INSERT INTO sys.keywords (keyword) VALUES\n"
5 : " ('ADD'),\n"
6 : " ('ADMIN'),\n"
7 : " ('AFTER'),\n"
8 : " ('AGGREGATE'),\n"
9 : " ('ALL'),\n"
10 : " ('ALTER'),\n"
11 : " ('ALWAYS'),\n"
12 : " ('ANALYZE'),\n"
13 : " ('AND'),\n"
14 : " ('ANY'),\n"
15 : " ('ASC'),\n"
16 : " ('ASYMMETRIC'),\n"
17 : " ('AT'),\n"
18 : " ('ATOMIC'),\n"
19 : " ('AUTHORIZATION'),\n"
20 : " ('AUTO_INCREMENT'),\n"
21 : " ('BEFORE'),\n"
22 : " ('BEGIN'),\n"
23 : " ('BEST'),\n"
24 : " ('BETWEEN'),\n"
25 : " ('BIG'),\n"
26 : " ('BIGINT'),\n"
27 : " ('BIGSERIAL'),\n"
28 : " ('BINARY'),\n"
29 : " ('BLOB'),\n"
30 : " ('BY'),\n"
31 : " ('CACHE'),\n"
32 : " ('CALL'),\n"
33 : " ('CASCADE'),\n"
34 : " ('CASE'),\n"
35 : " ('CAST'),\n"
36 : " ('CENTURY'),\n"
37 : " ('CHAIN'),\n"
38 : " ('CHAR'),\n"
39 : " ('CHARACTER'),\n"
40 : " ('CHECK'),\n"
41 : " ('CLIENT'),\n"
42 : " ('CLOB'),\n"
43 : " ('COALESCE'),\n"
44 : " ('COLUMN'),\n"
45 : " ('COMMENT'),\n"
46 : " ('COMMIT'),\n"
47 : " ('COMMITTED'),\n"
48 : " ('CONSTRAINT'),\n"
49 : " ('CONTINUE'),\n"
50 : " ('CONVERT'),\n"
51 : " ('COPY'),\n"
52 : " ('CORRESPONDING'),\n"
53 : " ('CREATE'),\n"
54 : " ('CROSS'),\n"
55 : " ('CUBE'),\n"
56 : " ('CURRENT'),\n"
57 : " ('CURRENT_DATE'),\n"
58 : " ('CURRENT_ROLE'),\n"
59 : " ('CURRENT_SCHEMA'),\n"
60 : " ('CURRENT_TIME'),\n"
61 : " ('CURRENT_TIMESTAMP'),\n"
62 : " ('CURRENT_TIMEZONE'),\n"
63 : " ('CURRENT_USER'),\n"
64 : " ('CYCLE'),\n"
65 : " ('DATA'),\n"
66 : " ('DATE'),\n"
67 : " ('DAY'),\n"
68 : " ('DEALLOCATE'),\n"
69 : " ('DEBUG'),\n"
70 : " ('DEC'),\n"
71 : " ('DECADE'),\n"
72 : " ('DECIMAL'),\n"
73 : " ('DECLARE'),\n"
74 : " ('DEFAULT'),\n"
75 : " ('DELETE'),\n"
76 : " ('DELIMITERS'),\n"
77 : " ('DESC'),\n"
78 : " ('DIAGNOSTICS'),\n"
79 : " ('DISTINCT'),\n"
80 : " ('DO'),\n"
81 : " ('DOUBLE'),\n"
82 : " ('DOW'),\n"
83 : " ('DOY'),\n"
84 : " ('DROP'),\n"
85 : " ('EACH'),\n"
86 : " ('EFFORT'),\n"
87 : " ('ELSE'),\n"
88 : " ('ELSEIF'),\n"
89 : " ('ENCRYPTED'),\n"
90 : " ('END'),\n"
91 : " ('ENDIAN'),\n"
92 : " ('EPOCH'),\n"
93 : " ('ESCAPE'),\n"
94 : " ('EVERY'),\n"
95 : " ('EXCEPT'),\n"
96 : " ('EXCLUDE'),\n"
97 : " ('EXEC'),\n"
98 : " ('EXECUTE'),\n"
99 : " ('EXISTS'),\n"
100 : " ('EXPLAIN'),\n"
101 : " ('EXTERNAL'),\n"
102 : " ('EXTRACT'),\n"
103 : " ('FALSE'),\n"
104 : " ('FIRST'),\n"
105 : " ('FLOAT'),\n"
106 : " ('FOLLOWING'),\n"
107 : " ('FOR'),\n"
108 : " ('FOREIGN'),\n"
109 : " ('FROM'),\n"
110 : " ('FULL'),\n"
111 : " ('FUNCTION'),\n"
112 : " ('FWF'),\n"
113 : " ('GENERATED'),\n"
114 : " ('GLOBAL'),\n"
115 : " ('GRANT'),\n"
116 : " ('GROUP'),\n"
117 : " ('GROUPING'),\n"
118 : " ('GROUPS'),\n"
119 : " ('HAVING'),\n"
120 : " ('HOUR'),\n"
121 : " ('HUGEINT'),\n"
122 : " ('IDENTITY'),\n"
123 : " ('IF'),\n"
124 : " ('ILIKE'),\n"
125 : " ('IMPRINTS'),\n"
126 : " ('IN'),\n"
127 : " ('INCREMENT'),\n"
128 : " ('INDEX'),\n"
129 : " ('INNER'),\n"
130 : " ('INSERT'),\n"
131 : " ('INT'),\n"
132 : " ('INTEGER'),\n"
133 : " ('INTERSECT'),\n"
134 : " ('INTERVAL'),\n"
135 : " ('INTO'),\n"
136 : " ('IS'),\n"
137 : " ('ISOLATION'),\n"
138 : " ('JOIN'),\n"
139 : " ('KEY'),\n"
140 : " ('LANGUAGE'),\n"
141 : " ('LARGE'),\n"
142 : " ('LAST'),\n"
143 : " ('LATERAL'),\n"
144 : " ('LEFT'),\n"
145 : " ('LEVEL'),\n"
146 : " ('LIKE'),\n"
147 : " ('LIMIT'),\n"
148 : " ('LITTLE'),\n"
149 : " ('LOADER'),\n"
150 : " ('LOCAL'),\n"
151 : " ('LOCALTIME'),\n"
152 : " ('LOCALTIMESTAMP'),\n"
153 : " ('MATCH'),\n"
154 : " ('MATCHED'),\n"
155 : " ('MAXVALUE'),\n"
156 : " ('MEDIUMINT'),\n"
157 : " ('MERGE'),\n"
158 : " ('MINUTE'),\n"
159 : " ('MINVALUE'),\n"
160 : " ('MONTH'),\n"
161 : " ('NAME'),\n"
162 : " ('NATIVE'),\n"
163 : " ('NATURAL'),\n"
164 : " ('NEW'),\n"
165 : " ('NEXT'),\n"
166 : " ('NO'),\n"
167 : " ('NOT'),\n"
168 : " ('NOW'),\n"
169 : " ('NULL'),\n"
170 : " ('NULLIF'),\n"
171 : " ('NULLS'),\n"
172 : " ('NUMERIC'),\n"
173 : " ('OBJECT'),\n"
174 : " ('OF'),\n"
175 : " ('OFFSET'),\n"
176 : " ('OLD'),\n"
177 : " ('ON'),\n"
178 : " ('ONLY'),\n"
179 : " ('OPTION'),\n"
180 : " ('OPTIONS'),\n"
181 : " ('OR'),\n"
182 : " ('ORDER'),\n"
183 : " ('ORDERED'),\n"
184 : " ('OTHERS'),\n"
185 : " ('OUTER'),\n"
186 : " ('OVER'),\n"
187 : " ('PARTIAL'),\n"
188 : " ('PARTITION'),\n"
189 : " ('PASSWORD'),\n"
190 : " ('PATH'),\n"
191 : " ('PLAN'),\n"
192 : " ('POSITION'),\n"
193 : " ('PRECEDING'),\n"
194 : " ('PRECISION'),\n"
195 : " ('PREP'),\n"
196 : " ('PREPARE'),\n"
197 : " ('PRESERVE'),\n"
198 : " ('PRIMARY'),\n"
199 : " ('PRIVILEGES'),\n"
200 : " ('PROCEDURE'),\n"
201 : " ('PUBLIC'),\n"
202 : " ('QUARTER'),\n"
203 : " ('RANGE'),\n"
204 : " ('READ'),\n"
205 : " ('REAL'),\n"
206 : " ('RECORDS'),\n"
207 : " ('REFERENCES'),\n"
208 : " ('REFERENCING'),\n"
209 : " ('RELEASE'),\n"
210 : " ('REMOTE'),\n"
211 : " ('RENAME'),\n"
212 : " ('REPEATABLE'),\n"
213 : " ('REPLACE'),\n"
214 : " ('REPLICA'),\n"
215 : " ('RESTART'),\n"
216 : " ('RESTRICT'),\n"
217 : " ('RETURN'),\n"
218 : " ('RETURNS'),\n"
219 : " ('REVOKE'),\n"
220 : " ('RIGHT'),\n"
221 : " ('ROLE'),\n"
222 : " ('ROLLBACK'),\n"
223 : " ('ROLLUP'),\n"
224 : " ('ROW'),\n"
225 : " ('ROWS'),\n"
226 : " ('SAMPLE'),\n"
227 : " ('SAVEPOINT'),\n"
228 : " ('SCHEMA'),\n"
229 : " ('SECOND'),\n"
230 : " ('SEED'),\n"
231 : " ('SELECT'),\n"
232 : " ('SEQUENCE'),\n"
233 : " ('SERIAL'),\n"
234 : " ('SERIALIZABLE'),\n"
235 : " ('SERVER'),\n"
236 : " ('SESSION'),\n"
237 : " ('SESSION_USER'),\n"
238 : " ('SET'),\n"
239 : " ('SETS'),\n"
240 : " ('SIMPLE'),\n"
241 : " ('SIZE'),\n"
242 : " ('SMALLINT'),\n"
243 : " ('SOME'),\n"
244 : " ('SPLIT_PART'),\n"
245 : " ('START'),\n"
246 : " ('STATEMENT'),\n"
247 : " ('STDIN'),\n"
248 : " ('STDOUT'),\n"
249 : " ('STORAGE'),\n"
250 : " ('STRING'),\n"
251 : " ('SUBSTRING'),\n"
252 : " ('SYMMETRIC'),\n"
253 : " ('TABLE'),\n"
254 : " ('TEMP'),\n"
255 : " ('TEMPORARY'),\n"
256 : " ('TEXT'),\n"
257 : " ('THEN'),\n"
258 : " ('TIES'),\n"
259 : " ('TIME'),\n"
260 : " ('TIMESTAMP'),\n"
261 : " ('TINYINT'),\n"
262 : " ('TO'),\n"
263 : " ('TRACE'),\n"
264 : " ('TRANSACTION'),\n"
265 : " ('TRIGGER'),\n"
266 : " ('TRUE'),\n"
267 : " ('TRUNCATE'),\n"
268 : " ('TYPE'),\n"
269 : " ('UNBOUNDED'),\n"
270 : " ('UNCOMMITTED'),\n"
271 : " ('UNENCRYPTED'),\n"
272 : " ('UNION'),\n"
273 : " ('UNIQUE'),\n"
274 : " ('UPDATE'),\n"
275 : " ('USER'),\n"
276 : " ('USING'),\n"
277 : " ('VALUE'),\n"
278 : " ('VALUES'),\n"
279 : " ('VARCHAR'),\n"
280 : " ('VARYING'),\n"
281 : " ('VIEW'),\n"
282 : " ('WEEK'),\n"
283 : " ('WHEN'),\n"
284 : " ('WHERE'),\n"
285 : " ('WHILE'),\n"
286 : " ('WINDOW'),\n"
287 : " ('WITH'),\n"
288 : " ('WORK'),\n"
289 : " ('WRITE'),\n"
290 : " ('XMLAGG'),\n"
291 : " ('XMLATTRIBUTES'),\n"
292 : " ('XMLCOMMENT'),\n"
293 : " ('XMLCONCAT'),\n"
294 : " ('XMLDOCUMENT'),\n"
295 : " ('XMLELEMENT'),\n"
296 : " ('XMLFOREST'),\n"
297 : " ('XMLNAMESPACES'),\n"
298 : " ('XMLPARSE'),\n"
299 : " ('XMLPI'),\n"
300 : " ('XMLQUERY'),\n"
301 : " ('XMLSCHEMA'),\n"
302 : " ('XMLTEXT'),\n"
303 : " ('XMLVALIDATE'),\n"
304 : " ('YEAR'),\n"
305 : " ('ZONE');\n"
306 : "ALTER TABLE sys.keywords SET READ ONLY;\n"
307 : "GRANT SELECT ON sys.keywords TO PUBLIC;\n"
308 : "CREATE TABLE sys.table_types (\n"
309 : " table_type_id SMALLINT NOT NULL PRIMARY KEY,\n"
310 : " table_type_name VARCHAR(25) NOT NULL UNIQUE);\n"
311 : "INSERT INTO sys.table_types (table_type_id, table_type_name) VALUES\n"
312 : " (0, 'TABLE'),\n"
313 : " (1, 'VIEW'),\n"
314 : " (3, 'MERGE TABLE'),\n"
315 : " (5, 'REMOTE TABLE'),\n"
316 : " (6, 'REPLICA TABLE'),\n"
317 : " (7, 'UNLOGGED TABLE'),\n"
318 : " (10, 'SYSTEM TABLE'),\n"
319 : " (11, 'SYSTEM VIEW'),\n"
320 : " (20, 'GLOBAL TEMPORARY TABLE'),\n"
321 : " (30, 'LOCAL TEMPORARY TABLE');\n"
322 : "ALTER TABLE sys.table_types SET READ ONLY;\n"
323 : "GRANT SELECT ON sys.table_types TO PUBLIC;\n"
324 : "CREATE TABLE sys.function_types (\n"
325 : " function_type_id SMALLINT NOT NULL PRIMARY KEY,\n"
326 : " function_type_name VARCHAR(30) NOT NULL UNIQUE,\n"
327 : " function_type_keyword VARCHAR(30) NOT NULL);\n"
328 : "INSERT INTO sys.function_types (function_type_id, function_type_name, function_type_keyword) VALUES\n"
329 : " (1, 'Scalar function', 'FUNCTION'),\n"
330 : " (2, 'Procedure', 'PROCEDURE'),\n"
331 : " (3, 'Aggregate function', 'AGGREGATE'),\n"
332 : " (4, 'Filter function', 'FILTER FUNCTION'),\n"
333 : " (5, 'Function returning a table', 'FUNCTION'),\n"
334 : " (6, 'Analytic function', 'WINDOW'),\n"
335 : " (7, 'Loader function', 'LOADER');\n"
336 : "ALTER TABLE sys.function_types SET READ ONLY;\n"
337 : "GRANT SELECT ON sys.function_types TO PUBLIC;\n"
338 : "CREATE TABLE sys.function_languages (\n"
339 : " language_id SMALLINT NOT NULL PRIMARY KEY,\n"
340 : " language_name VARCHAR(20) NOT NULL UNIQUE,\n"
341 : " language_keyword VARCHAR(20));\n"
342 : "INSERT INTO sys.function_languages (language_id, language_name, language_keyword) VALUES\n"
343 : " (0, 'Internal C', NULL),\n"
344 : " (1, 'MAL', NULL),\n"
345 : " (2, 'SQL', NULL),\n"
346 : " (3, 'R', 'R'),\n"
347 : " (4, 'C', 'C'),\n"
348 : " (6, 'Python', 'PYTHON'),\n"
349 : " (10, 'Python3', 'PYTHON3'),\n"
350 : " (12, 'C++', 'CPP');\n"
351 : "ALTER TABLE sys.function_languages SET READ ONLY;\n"
352 : "GRANT SELECT ON sys.function_languages TO PUBLIC;\n"
353 : "CREATE TABLE sys.key_types (\n"
354 : " key_type_id SMALLINT NOT NULL PRIMARY KEY,\n"
355 : " key_type_name VARCHAR(15) NOT NULL UNIQUE);\n"
356 : "INSERT INTO sys.key_types (key_type_id, key_type_name) VALUES\n"
357 : " (0, 'Primary Key'),\n"
358 : " (1, 'Unique Key'),\n"
359 : " (2, 'Foreign Key');\n"
360 : "ALTER TABLE sys.key_types SET READ ONLY;\n"
361 : "GRANT SELECT ON sys.key_types TO PUBLIC;\n"
362 : "CREATE TABLE sys.fkey_actions (\n"
363 : " action_id SMALLINT NOT NULL PRIMARY KEY,\n"
364 : " action_name VARCHAR(15) NOT NULL);\n"
365 : "INSERT INTO sys.fkey_actions (action_id, action_name) VALUES\n"
366 : " (0, 'NO ACTION'),\n"
367 : " (1, 'CASCADE'),\n"
368 : " (2, 'RESTRICT'),\n"
369 : " (3, 'SET NULL'),\n"
370 : " (4, 'SET DEFAULT');\n"
371 : "ALTER TABLE sys.fkey_actions SET READ ONLY;\n"
372 : "GRANT SELECT ON sys.fkey_actions TO PUBLIC;\n"
373 : "CREATE VIEW sys.fkeys AS\n"
374 : "SELECT id, table_id, type, name, rkey, update_action_id, upd.action_name as update_action, delete_action_id, del.action_name as delete_action FROM (\n"
375 : " SELECT id, table_id, type, name, rkey, cast(((\"action\" >> 8) & 255) as smallint) as update_action_id, cast((\"action\" & 255) as smallint) AS delete_action_id FROM sys.keys WHERE type = 2\n"
376 : " UNION ALL\n"
377 : " SELECT id, table_id, type, name, rkey, cast(((\"action\" >> 8) & 255) as smallint) as update_action_id, cast((\"action\" & 255) as smallint) AS delete_action_id FROM tmp.keys WHERE type = 2\n"
378 : ") AS fks\n"
379 : "JOIN sys.fkey_actions upd ON fks.update_action_id = upd.action_id\n"
380 : "JOIN sys.fkey_actions del ON fks.delete_action_id = del.action_id;\n"
381 : "GRANT SELECT ON sys.fkeys TO PUBLIC;\n"
382 : "CREATE TABLE sys.index_types (\n"
383 : " index_type_id SMALLINT NOT NULL PRIMARY KEY,\n"
384 : " index_type_name VARCHAR(25) NOT NULL UNIQUE);\n"
385 : "INSERT INTO sys.index_types (index_type_id, index_type_name) VALUES\n"
386 : " (0, 'Hash'),\n"
387 : " (1, 'Join'),\n"
388 : " (2, 'Order preserving hash'),\n"
389 : " (3, 'No-index'),\n"
390 : " (4, 'Imprint'),\n"
391 : " (5, 'Ordered');\n"
392 : "ALTER TABLE sys.index_types SET READ ONLY;\n"
393 : "GRANT SELECT ON sys.index_types TO PUBLIC;\n"
394 : "CREATE TABLE sys.privilege_codes (\n"
395 : " privilege_code_id INT NOT NULL PRIMARY KEY,\n"
396 : " privilege_code_name VARCHAR(40) NOT NULL UNIQUE);\n"
397 : "INSERT INTO sys.privilege_codes (privilege_code_id, privilege_code_name) VALUES\n"
398 : " (1, 'SELECT'),\n"
399 : " (2, 'UPDATE'),\n"
400 : " (4, 'INSERT'),\n"
401 : " (8, 'DELETE'),\n"
402 : " (16, 'EXECUTE'),\n"
403 : " (32, 'GRANT'),\n"
404 : " (64, 'TRUNCATE'),\n"
405 : " (3, 'SELECT,UPDATE'),\n"
406 : " (5, 'SELECT,INSERT'),\n"
407 : " (6, 'INSERT,UPDATE'),\n"
408 : " (7, 'SELECT,INSERT,UPDATE'),\n"
409 : " (9, 'SELECT,DELETE'),\n"
410 : " (10, 'UPDATE,DELETE'),\n"
411 : " (11, 'SELECT,UPDATE,DELETE'),\n"
412 : " (12, 'INSERT,DELETE'),\n"
413 : " (13, 'SELECT,INSERT,DELETE'),\n"
414 : " (14, 'INSERT,UPDATE,DELETE'),\n"
415 : " (15, 'SELECT,INSERT,UPDATE,DELETE'),\n"
416 : " (65, 'SELECT,TRUNCATE'),\n"
417 : " (66, 'UPDATE,TRUNCATE'),\n"
418 : " (67, 'SELECT,UPDATE,TRUNCATE'),\n"
419 : " (68, 'INSERT,TRUNCATE'),\n"
420 : " (69, 'SELECT,INSERT,TRUNCATE'),\n"
421 : " (70, 'INSERT,UPDATE,TRUNCATE'),\n"
422 : " (71, 'SELECT,INSERT,UPDATE,TRUNCATE'),\n"
423 : " (72, 'DELETE,TRUNCATE'),\n"
424 : " (73, 'SELECT,DELETE,TRUNCATE'),\n"
425 : " (74, 'UPDATE,DELETE,TRUNCATE'),\n"
426 : " (75, 'SELECT,UPDATE,DELETE,TRUNCATE'),\n"
427 : " (76, 'INSERT,DELETE,TRUNCATE'),\n"
428 : " (77, 'SELECT,INSERT,DELETE,TRUNCATE'),\n"
429 : " (78, 'INSERT,UPDATE,DELETE,TRUNCATE'),\n"
430 : " (79, 'SELECT,INSERT,UPDATE,DELETE,TRUNCATE');\n"
431 : "ALTER TABLE sys.privilege_codes SET READ ONLY;\n"
432 : "GRANT SELECT ON sys.privilege_codes TO PUBLIC;\n"
433 : "CREATE VIEW sys.roles AS SELECT id, name, grantor FROM sys.auths a WHERE a.name NOT IN (SELECT u.name FROM sys.db_user_info u);\n"
434 : "GRANT SELECT ON sys.roles TO PUBLIC;\n"
435 : "CREATE VIEW sys.users AS SELECT name, fullname, default_schema, schema_path, max_memory, max_workers, optimizer, default_role FROM sys.db_user_info;\n"
436 : "GRANT SELECT ON sys.users TO PUBLIC;\n"
437 : "CREATE FUNCTION sys.db_users() RETURNS TABLE(name VARCHAR(2048)) RETURN SELECT name FROM sys.db_user_info;\n"
438 : "CREATE VIEW sys.var_values (var_name, value) AS\n"
439 : "SELECT 'current_role', current_role UNION ALL\n"
440 : "SELECT 'current_schema', current_schema UNION ALL\n"
441 : "SELECT 'current_timezone', current_timezone UNION ALL\n"
442 : "SELECT 'current_user', current_user UNION ALL\n"
443 : "SELECT 'debug', debug UNION ALL\n"
444 : "SELECT 'last_id', last_id UNION ALL\n"
445 : "SELECT 'optimizer', optimizer UNION ALL\n"
446 : "SELECT 'pi', pi() UNION ALL\n"
447 : "SELECT 'rowcnt', rowcnt;\n"
448 : "GRANT SELECT ON sys.var_values TO PUBLIC;\n"
449 : "CREATE AGGREGATE sys.group_concat(str string) RETURNS string EXTERNAL NAME \"aggr\".\"str_group_concat\";\n"
450 : "GRANT EXECUTE ON AGGREGATE sys.group_concat(string) TO PUBLIC;\n"
451 : "CREATE AGGREGATE sys.group_concat(str string, sep string) RETURNS string EXTERNAL NAME \"aggr\".\"str_group_concat\";\n"
452 : "GRANT EXECUTE ON AGGREGATE sys.group_concat(string, string) TO PUBLIC;\n"
453 : "CREATE WINDOW sys.group_concat(str string) RETURNS string EXTERNAL NAME \"sql\".\"str_group_concat\";\n"
454 : "GRANT EXECUTE ON WINDOW sys.group_concat(string) TO PUBLIC;\n"
455 : "CREATE WINDOW sys.group_concat(str string, sep string) RETURNS string EXTERNAL NAME \"sql\".\"str_group_concat\";\n"
456 : "GRANT EXECUTE ON WINDOW sys.group_concat(string, string) TO PUBLIC;\n"
457 : };
458 : #include "monetdb_config.h"
459 : #include "sql_import.h"
460 : #ifdef _MSC_VER
461 : #undef read
462 : #pragma section(".CRT$XCU",read)
463 : #endif
464 331 : LIB_STARTUP_FUNC(init_10_sys_schema_extension_sql)
465 331 : { sql_register("10_sys_schema_extension", _10_sys_schema_extension_sql); }
|