Changeset: 3519088d87c1 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=3519088d87c1
Modified Files:
sql/scripts/51_sys_schema_extension.sql
Branch: Jul2017
Log Message:
Layout.
diffs (truncated from 421 to 300 lines):
diff --git a/sql/scripts/51_sys_schema_extension.sql
b/sql/scripts/51_sys_schema_extension.sql
--- a/sql/scripts/51_sys_schema_extension.sql
+++ b/sql/scripts/51_sys_schema_extension.sql
@@ -10,28 +10,224 @@ CREATE TABLE sys.keywords (
keyword VARCHAR(40) NOT NULL PRIMARY KEY);
INSERT INTO sys.keywords (keyword) VALUES
-('ADD'), ('ADMIN'), ('AFTER'), ('AGGREGATE'), ('ALL'), ('ALTER'), ('ALWAYS'),
('AND'), ('ANY'), ('ASC'), ('ASYMMETRIC'), ('ATOMIC'), ('AUTO_INCREMENT'),
-('BEFORE'), ('BEGIN'), ('BEST'), ('BETWEEN'), ('BIGINT'), ('BIGSERIAL'),
('BINARY'), ('BLOB'), ('BY'),
-('CALL'), ('CASCADE'), ('CASE'), ('CAST'), ('CHAIN'), ('CHAR'), ('CHARACTER'),
('CHECK'), ('CLOB'), ('COALESCE'), ('COMMIT'), ('COMMITTED'), ('CONSTRAINT'),
('CONVERT'), ('COPY'), ('CORRESPONDING'), ('CREATE'), ('CROSS'), ('CURRENT'),
('CURRENT_DATE'), ('CURRENT_ROLE'), ('CURRENT_TIME'), ('CURRENT_TIMESTAMP'),
('CURRENT_USER'),
-('DAY'), ('DEC'), ('DECIMAL'), ('DECLARE'), ('DEFAULT'), ('DELETE'),
('DELIMITERS'), ('DESC'), ('DO'), ('DOUBLE'), ('DROP'),
-('EACH'), ('EFFORT'), ('ELSE'), ('ELSEIF'), ('ENCRYPTED'), ('END'),
('ESCAPE'), ('EVERY'), ('EXCEPT'), ('EXCLUDE'), ('EXISTS'), ('EXTERNAL'),
('EXTRACT'),
-('FALSE'), ('FLOAT'), ('FOLLOWING'), ('FOR'), ('FOREIGN'), ('FROM'), ('FULL'),
('FUNCTION'),
-('GENERATED'), ('GLOBAL'), ('GRANT'), ('GROUP'),
-('HAVING'), ('HOUR'), ('HUGEINT'),
-('IDENTITY'), ('IF'), ('ILIKE'), ('IN'), ('INDEX'), ('INNER'), ('INSERT'),
('INT'), ('INTEGER'), ('INTERSECT'), ('INTO'), ('IS'), ('ISOLATION'),
-('JOIN'),
-('LEFT'), ('LIKE'), ('LIMIT'), ('LOCAL'), ('LOCALTIME'), ('LOCALTIMESTAMP'),
('LOCKED'),
-('MEDIUMINT'), ('MERGE'), ('MINUTE'), ('MONTH'),
-('NATURAL'), ('NEW'), ('NEXT'), ('NOCYCLE'), ('NOMAXVALUE'), ('NOMINVALUE'),
('NOT'), ('NOW'), ('NULL'), ('NULLIF'), ('NUMERIC'),
-('OF'), ('OFFSET'), ('OLD'), ('ON'), ('ONLY'), ('OPTION'), ('OR'), ('ORDER'),
('OTHERS'), ('OUTER'), ('OVER'),
-('PARTIAL'), ('PARTITION'), ('POSITION'), ('PRECEDING'), ('PRESERVE'),
('PRIMARY'), ('PRIVILEGES'), ('PROCEDURE'), ('PUBLIC'),
-('RANGE'), ('READ'), ('REAL'), ('RECORDS'), ('REFERENCES'), ('REFERENCING'),
('REMOTE'), ('RENAME'), ('REPEATABLE'), ('REPLICA'), ('RESTART'), ('RESTRICT'),
('RETURN'), ('RETURNS'), ('REVOKE'), ('RIGHT'), ('ROLLBACK'), ('ROWS'),
-('SAMPLE'), ('SAVEPOINT'), ('SECOND'), ('SELECT'), ('SEQUENCE'), ('SERIAL'),
('SERIALIZABLE'), ('SESSION_USER'), ('SET'), ('SIMPLE'), ('SMALLINT'),
('SOME'), ('SPLIT_PART'), ('STDIN'), ('STDOUT'), ('STORAGE'), ('STREAM'),
('STRING'), ('SUBSTRING'), ('SYMMETRIC'),
-('THEN'), ('TIES'), ('TINYINT'), ('TO'), ('TRANSACTION'), ('TRIGGER'),
('TRUE'),
-('UNBOUNDED'), ('UNCOMMITTED'), ('UNENCRYPTED'), ('UNION'), ('UNIQUE'),
('UPDATE'), ('USER'), ('USING'),
-('VALUES'), ('VARCHAR'), ('VARYING'), ('VIEW'),
-('WHEN'), ('WHERE'), ('WHILE'), ('WITH'), ('WORK'), ('WRITE'),
-('XMLAGG'), ('XMLATTRIBUTES'), ('XMLCOMMENT'), ('XMLCONCAT'), ('XMLDOCUMENT'),
('XMLELEMENT'), ('XMLFOREST'), ('XMLNAMESPACES'), ('XMLPARSE'), ('XMLPI'),
('XMLQUERY'), ('XMLSCHEMA'), ('XMLTEXT'), ('XMLVALIDATE');
+ ('ADD'),
+ ('ADMIN'),
+ ('AFTER'),
+ ('AGGREGATE'),
+ ('ALL'),
+ ('ALTER'),
+ ('ALWAYS'),
+ ('AND'),
+ ('ANY'),
+ ('ASC'),
+ ('ASYMMETRIC'),
+ ('ATOMIC'),
+ ('AUTO_INCREMENT'),
+ ('BEFORE'),
+ ('BEGIN'),
+ ('BEST'),
+ ('BETWEEN'),
+ ('BIGINT'),
+ ('BIGSERIAL'),
+ ('BINARY'),
+ ('BLOB'),
+ ('BY'),
+ ('CALL'),
+ ('CASCADE'),
+ ('CASE'),
+ ('CAST'),
+ ('CHAIN'),
+ ('CHAR'),
+ ('CHARACTER'),
+ ('CHECK'),
+ ('CLOB'),
+ ('COALESCE'),
+ ('COMMIT'),
+ ('COMMITTED'),
+ ('CONSTRAINT'),
+ ('CONVERT'),
+ ('COPY'),
+ ('CORRESPONDING'),
+ ('CREATE'),
+ ('CROSS'),
+ ('CURRENT'),
+ ('CURRENT_DATE'),
+ ('CURRENT_ROLE'),
+ ('CURRENT_TIME'),
+ ('CURRENT_TIMESTAMP'),
+ ('CURRENT_USER'),
+ ('DAY'),
+ ('DEC'),
+ ('DECIMAL'),
+ ('DECLARE'),
+ ('DEFAULT'),
+ ('DELETE'),
+ ('DELIMITERS'),
+ ('DESC'),
+ ('DO'),
+ ('DOUBLE'),
+ ('DROP'),
+ ('EACH'),
+ ('EFFORT'),
+ ('ELSE'),
+ ('ELSEIF'),
+ ('ENCRYPTED'),
+ ('END'),
+ ('ESCAPE'),
+ ('EVERY'),
+ ('EXCEPT'),
+ ('EXCLUDE'),
+ ('EXISTS'),
+ ('EXTERNAL'),
+ ('EXTRACT'),
+ ('FALSE'),
+ ('FLOAT'),
+ ('FOLLOWING'),
+ ('FOR'),
+ ('FOREIGN'),
+ ('FROM'),
+ ('FULL'),
+ ('FUNCTION'),
+ ('GENERATED'),
+ ('GLOBAL'),
+ ('GRANT'),
+ ('GROUP'),
+ ('HAVING'),
+ ('HOUR'),
+ ('HUGEINT'),
+ ('IDENTITY'),
+ ('IF'),
+ ('ILIKE'),
+ ('IN'),
+ ('INDEX'),
+ ('INNER'),
+ ('INSERT'),
+ ('INT'),
+ ('INTEGER'),
+ ('INTERSECT'),
+ ('INTO'),
+ ('IS'),
+ ('ISOLATION'),
+ ('JOIN'),
+ ('LEFT'),
+ ('LIKE'),
+ ('LIMIT'),
+ ('LOCAL'),
+ ('LOCALTIME'),
+ ('LOCALTIMESTAMP'),
+ ('LOCKED'),
+ ('MEDIUMINT'),
+ ('MERGE'),
+ ('MINUTE'),
+ ('MONTH'),
+ ('NATURAL'),
+ ('NEW'),
+ ('NEXT'),
+ ('NOCYCLE'),
+ ('NOMAXVALUE'),
+ ('NOMINVALUE'),
+ ('NOT'),
+ ('NOW'),
+ ('NULL'),
+ ('NULLIF'),
+ ('NUMERIC'),
+ ('OF'),
+ ('OFFSET'),
+ ('OLD'),
+ ('ON'),
+ ('ONLY'),
+ ('OPTION'),
+ ('OR'),
+ ('ORDER'),
+ ('OTHERS'),
+ ('OUTER'),
+ ('OVER'),
+ ('PARTIAL'),
+ ('PARTITION'),
+ ('POSITION'),
+ ('PRECEDING'),
+ ('PRESERVE'),
+ ('PRIMARY'),
+ ('PRIVILEGES'),
+ ('PROCEDURE'),
+ ('PUBLIC'),
+ ('RANGE'),
+ ('READ'),
+ ('REAL'),
+ ('RECORDS'),
+ ('REFERENCES'),
+ ('REFERENCING'),
+ ('REMOTE'),
+ ('RENAME'),
+ ('REPEATABLE'),
+ ('REPLICA'),
+ ('RESTART'),
+ ('RESTRICT'),
+ ('RETURN'),
+ ('RETURNS'),
+ ('REVOKE'),
+ ('RIGHT'),
+ ('ROLLBACK'),
+ ('ROWS'),
+ ('SAMPLE'),
+ ('SAVEPOINT'),
+ ('SECOND'),
+ ('SELECT'),
+ ('SEQUENCE'),
+ ('SERIAL'),
+ ('SERIALIZABLE'),
+ ('SESSION_USER'),
+ ('SET'),
+ ('SIMPLE'),
+ ('SMALLINT'),
+ ('SOME'),
+ ('SPLIT_PART'),
+ ('STDIN'),
+ ('STDOUT'),
+ ('STORAGE'),
+ ('STREAM'),
+ ('STRING'),
+ ('SUBSTRING'),
+ ('SYMMETRIC'),
+ ('THEN'),
+ ('TIES'),
+ ('TINYINT'),
+ ('TO'),
+ ('TRANSACTION'),
+ ('TRIGGER'),
+ ('TRUE'),
+ ('UNBOUNDED'),
+ ('UNCOMMITTED'),
+ ('UNENCRYPTED'),
+ ('UNION'),
+ ('UNIQUE'),
+ ('UPDATE'),
+ ('USER'),
+ ('USING'),
+ ('VALUES'),
+ ('VARCHAR'),
+ ('VARYING'),
+ ('VIEW'),
+ ('WHEN'),
+ ('WHERE'),
+ ('WHILE'),
+ ('WITH'),
+ ('WORK'),
+ ('WRITE'),
+ ('XMLAGG'),
+ ('XMLATTRIBUTES'),
+ ('XMLCOMMENT'),
+ ('XMLCONCAT'),
+ ('XMLDOCUMENT'),
+ ('XMLELEMENT'),
+ ('XMLFOREST'),
+ ('XMLNAMESPACES'),
+ ('XMLPARSE'),
+ ('XMLPI'),
+ ('XMLQUERY'),
+ ('XMLSCHEMA'),
+ ('XMLTEXT'),
+ ('XMLVALIDATE');
ALTER TABLE sys.keywords SET READ ONLY;
GRANT SELECT ON sys.keywords TO PUBLIC;
@@ -41,13 +237,27 @@ CREATE TABLE sys.table_types (
table_type_id SMALLINT NOT NULL PRIMARY KEY,
table_type_name VARCHAR(25) NOT NULL UNIQUE);
--- Values taken from sql/include/sql_catalog.h see enum table_types: table =
0, view = 1, merge_table = 3, stream = 4, remote = 5, replica_table = 6.
--- Note: values 10, 11, 20 and 30 are synthetically constructed, see view
sys.tables. Do not change them as they are used by ODBC
SQLTables(SQL_ALL_TABLE_TYPES) and JDBC methods getTableTypes() and getTables()
+-- Values taken from sql/include/sql_catalog.h see enum table_types:
+-- table = 0, view = 1, merge_table = 3, stream = 4, remote = 5,
+-- replica_table = 6.
+-- Note: values 10, 11, 20 and 30 are synthetically constructed, see
+-- view sys.tables. Do not change them as they are used by ODBC
+-- SQLTables(SQL_ALL_TABLE_TYPES) and JDBC methods getTableTypes() and
+-- getTables()
INSERT INTO sys.table_types (table_type_id, table_type_name) VALUES
- (0, 'TABLE'), (1, 'VIEW'), (3, 'MERGE TABLE'), (4, 'STREAM TABLE'), (5,
'REMOTE TABLE'), (6, 'REPLICA TABLE'),
--- synthetically constructed system obj variants (added 10 to sys._tables.type
value when sys._tables.system is true).
- (10, 'SYSTEM TABLE'), (11, 'SYSTEM VIEW'),
--- synthetically constructed temporary variants (added 20 or 30 to
sys._tables.type value depending on values of temporary and commit_action).
+ (0, 'TABLE'),
+ (1, 'VIEW'),
+ (3, 'MERGE TABLE'),
+ (4, 'STREAM TABLE'),
+ (5, 'REMOTE TABLE'),
+ (6, 'REPLICA TABLE'),
+-- synthetically constructed system obj variants (added 10 to
+-- sys._tables.type value when sys._tables.system is true).
+ (10, 'SYSTEM TABLE'),
+ (11, 'SYSTEM VIEW'),
+-- synthetically constructed temporary variants (added 20 or 30 to
+-- sys._tables.type value depending on values of temporary and
+-- commit_action).
(20, 'GLOBAL TEMPORARY TABLE'),
(30, 'LOCAL TEMPORARY TABLE');
@@ -61,8 +271,21 @@ CREATE TABLE sys.dependency_types (
-- Values taken from sql/include/sql_catalog.h see: #define SCHEMA_DEPENDENCY
1, TABLE_DEPENDENCY 2, ..., TYPE_DEPENDENCY 15.
INSERT INTO sys.dependency_types (dependency_type_id, dependency_type_name)
VALUES
- (1, 'SCHEMA'), (2, 'TABLE'), (3, 'COLUMN'), (4, 'KEY'), (5, 'VIEW'), (6,
'USER'), (7, 'FUNCTION'), (8, 'TRIGGER'),
- (9, 'OWNER'), (10, 'INDEX'), (11, 'FKEY'), (12, 'SEQUENCE'), (13,
'PROCEDURE'), (14, 'BE_DROPPED'), (15, 'TYPE');
+ (1, 'SCHEMA'),
+ (2, 'TABLE'),
+ (3, 'COLUMN'),
+ (4, 'KEY'),
+ (5, 'VIEW'),
+ (6, 'USER'),
+ (7, 'FUNCTION'),
+ (8, 'TRIGGER'),
+ (9, 'OWNER'),
+ (10, 'INDEX'),
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
