combine ticket notification scrips, #15353

[freeside.git] / etc / sql-reserved-words.txt

diff --git a/etc/sql-reserved-words.txt b/etc/sql-reserved-words.txt
index dc507ce..553eda2 100644 (file)
--- a/etc/sql-reserved-words.txt
+++ b/etc/sql-reserved-words.txt
@@ -1,3 +1,9 @@
+The data below is wrong/incomplete, see:
+PG8.3 - http://www.postgresql.org/docs/8.3/static/sql-keywords-appendix.html
+MySQL5.6 - http://dev.mysql.com/doc/refman/5.6/en/reserved-words.html
+-------------------------------------------------------------------------------
+
+
 From http://epoch.cs.berkeley.edu:8000/sequoia/dba/montage/FAQ/SQL.html
   by Jean Anderson (jta@postgres.berkeley.edu)
 
@@ -101,3 +107,116 @@ SQL3 words are not set in stone, but you'd do well to avoid them.
 
          CALL, DO, ELSEIF, EXCEPTION, IF, LEAVE, LOOP, OTHERS, RESIGNAL,
          RETURN, RETURNS, SIGNAL, TUPLE, WHILE
+
+from http://dev.mysql.com/doc/refman/5.6/en/reserved-words.html
+
+ACCESSIBLE     ADD     ALL
+ALTER  ANALYZE         AND
+AS     ASC     ASENSITIVE
+BEFORE         BETWEEN         BIGINT
+BINARY         BLOB    BOTH
+BY     CALL    CASCADE
+CASE   CHANGE  CHAR
+CHARACTER      CHECK   COLLATE
+COLUMN         CONDITION       CONSTRAINT
+CONTINUE       CONVERT         CREATE
+CROSS  CURRENT_DATE    CURRENT_TIME
+CURRENT_TIMESTAMP      CURRENT_USER    CURSOR
+DATABASE       DATABASES       DAY_HOUR
+DAY_MICROSECOND        DAY_MINUTE      DAY_SECOND
+DEC    DECIMAL         DECLARE
+DEFAULT        DELAYED         DELETE
+DESC   DESCRIBE        DETERMINISTIC
+DISTINCT       DISTINCTROW     DIV
+DOUBLE         DROP    DUAL
+EACH   ELSE    ELSEIF
+ENCLOSED       ESCAPED         EXISTS
+EXIT   EXPLAIN         FALSE
+FETCH  FLOAT   FLOAT4
+FLOAT8         FOR     FORCE
+FOREIGN        FROM    FULLTEXT
+GENERAL        GRANT   GROUP
+HAVING         HIGH_PRIORITY   HOUR_MICROSECOND
+HOUR_MINUTE    HOUR_SECOND     IF
+IGNORE         IGNORE_SERVER_IDS       IN
+INDEX  INFILE  INNER
+INOUT  INSENSITIVE     INSERT
+INT    INT1    INT2
+INT3   INT4    INT8
+INTEGER        INTERVAL        INTO
+IS     ITERATE         JOIN
+KEY    KEYS    KILL
+LEADING        LEAVE   LEFT
+LIKE   LIMIT   LINEAR
+LINES  LOAD    LOCALTIME
+LOCALTIMESTAMP         LOCK    LONG
+LONGBLOB       LONGTEXT        LOOP
+LOW_PRIORITY   MASTER_HEARTBEAT_PERIOD         MASTER_SSL_VERIFY_SERVER_CERT
+MATCH  MAXVALUE        MEDIUMBLOB
+MEDIUMINT      MEDIUMTEXT      MIDDLEINT
+MINUTE_MICROSECOND     MINUTE_SECOND   MOD
+MODIFIES       NATURAL         NOT
+NO_WRITE_TO_BINLOG     NULL    NUMERIC
+ON     OPTIMIZE        OPTION
+OPTIONALLY     OR      ORDER
+OUT    OUTER   OUTFILE
+PRECISION      PRIMARY         PROCEDURE
+PURGE  RANGE   READ
+READS  READ_WRITE      REAL
+REFERENCES     REGEXP  RELEASE
+RENAME         REPEAT  REPLACE
+REQUIRE        RESIGNAL        RESTRICT
+RETURN         REVOKE  RIGHT
+RLIKE  SCHEMA  SCHEMAS
+SECOND_MICROSECOND     SELECT  SENSITIVE
+SEPARATOR      SET     SHOW
+SIGNAL         SLOW    SMALLINT
+SPATIAL        SPECIFIC        SQL
+SQLEXCEPTION   SQLSTATE        SQLWARNING
+SQL_BIG_RESULT         SQL_CALC_FOUND_ROWS     SQL_SMALL_RESULT
+SSL    STARTING        STRAIGHT_JOIN
+TABLE  TERMINATED      THEN
+TINYBLOB       TINYINT         TINYTEXT
+TO     TRAILING        TRIGGER
+TRUE   UNDO    UNION
+UNIQUE         UNLOCK  UNSIGNED
+UPDATE         USAGE   USE
+USING  UTC_DATE        UTC_TIME
+UTC_TIMESTAMP  VALUES  VARBINARY
+VARCHAR        VARCHARACTER    VARYING
+WHEN   WHERE   WHILE
+WITH   WRITE   XOR
+YEAR_MONTH     ZEROFILL         
+
+The following are new reserved words in MySQL 5.5:
+GENERAL        IGNORE_SERVER_IDS       MASTER_HEARTBEAT_PERIOD
+MAXVALUE       RESIGNAL        SIGNAL
+SLOW            
+
+MySQL permits some keywords to be used as unquoted identifiers because many people previously used them. Examples are those in the following list:
+
+    *
+
+      ACTION
+    *
+
+      BIT
+    *
+
+      DATE
+    *
+
+      ENUM
+    *
+
+      NO
+    *
+
+      TEXT
+    *
+
+      TIME
+    *
+
+      TIMESTAMP
+