[gtksourceview/gtksourceview-4-6] file.sql: Add some more statements to look at



commit f0856223a6a31c308020a9e356d8378cd941958c
Author: Tomisław Kityński <t kitynski e-owl tech>
Date:   Thu Jun 25 14:13:10 2020 +0200

    file.sql: Add some more statements to look at

 tests/syntax-highlighting/file.sql | 14 ++++++++++++++
 1 file changed, 14 insertions(+)
---
diff --git a/tests/syntax-highlighting/file.sql b/tests/syntax-highlighting/file.sql
index a9c639f4..78366dc3 100644
--- a/tests/syntax-highlighting/file.sql
+++ b/tests/syntax-highlighting/file.sql
@@ -1,5 +1,13 @@
 -- this is a comment
 
+CREATE TABLE table_name (
+       column1 integer NOT NULL PRIMARY KEY,
+       column2 varchar(20),
+       column3 timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+       column4 smallint CHECK (column4 >= 0),
+       CONSTRAINT ct1 CHECK (column4 IS NULL OR column2 IS NOT NULL)
+);
+
 INSERT INTO table_name (column1, column2, column3, ...)
 VALUES (value1, value2, value3, ...);
 
@@ -9,3 +17,9 @@ BEGIN;
        WHERE account_id = '123';
 -- more comment
 COMMIT;
+
+CREATE TABLE other_table (
+       col1 int4 NOT NULL PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
+       col2 integer REFERENCES table_name
+);
+


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]