According to research progress of http://drupal.org/node/371#comment-1123065, D7 core schema is now conflict with following keywords. Any idea about the solution? Should we revamp and avoid the use of these reserved words?
Complete reserved word list (including ANSI-92/99/2003, MySQL, PostgreSQL, SQLite and Oracle):
abort, absolute, access, action, add, after, all, allocate, alter, analyse, analyze, and, any, are, array, as, asc, asensitive, assertion, asymmetric, at, atomic, attach, audit, authorization, autoincrement, avg, before, begin, between, bigint, binary, bit, bit_length, blob, boolean, both, breadth, by, call, called, cascade, cascaded, case, cast, catalog, change, char, char_length, character, character_length, check, clob, close, cluster, coalesce, collate, collation, column, comment, commit, compress, condition, conflict, connect, connection, constraint, constraints, constructor, contains, continue, convert, corresponding, count, create, cross, cube, current, current_date, current_default_transform_group, current_path, current_role, current_time, current_timestamp, current_transform_group_for_type, current_user, cursor, cycle, data, database, databases, date, day, day_hour, day_microsecond, day_minute, day_second, deallocate, dec, decimal, declare, default, deferrable, deferred, delayed, delete, depth, deref, desc, describe, descriptor, detach, deterministic, diagnostics, disconnect, distinct, distinctrow, div, do, domain, double, drop, dual, dynamic, each, element, else, elseif, enclosed, end, equals, escape, escaped, except, exception, exclusive, exec, execute, exists, exit, explain, external, extract, fail, false, fetch, file, filter, first, float, float4, float8, for, force, foreign, found, free, freeze, from, full, fulltext, function, general, get, glob, global, go, goto, grant, group, grouping, handler, having, high_priority, hold, hour, hour_microsecond, hour_minute, hour_second, identified, identity, if, ignore, ilike, immediate, in, increment, index, indexed, indicator, infile, initial, initially, inner, inout, input, insensitive, insert, instead, int, int1, int2, int3, int4, int8, integer, intersect, interval, into, is, isnull, isolation, iterate, join, key, keys, kill, language, large, last, lateral, leading, leave, left, level, like, limit, lines, load, local, localtime, localtimestamp, locator, lock, long, longblob, longtext, loop, low_priority, lower, map, match, max, maxextents, mediumblob, mediumint, mediumtext, member, merge, method, middleint, min, minus, minute, minute_microsecond, minute_second, mlslabel, mod, mode, modifies, modify, module, month, multiset, names, national, natural, nchar, nclob, new, next, no, no_write_to_binlog, noaudit, nocompress, none, not, notnull, nowait, null, nullif, number, numeric, object, octet_length, of, off, offline, offset, old, on, online, only, open, optimize, option, optionally, or, order, ordinality, out, outer, outfile, output, over, overlaps, pad, parameter, partial, partition, path, pctfree, placing, plan, position, pragma, precision, prepare, preserve, primary, prior, privileges, procedure, public, purge, query, raid0, raise, range, raw, read, reads, real, recursive, ref, references, referencing, regexp, reindex, relative, release, rename, repeat, replace, require, resignal, resource, restrict, result, return, returns, revoke, right, rlike, role, rollback, rollup, routine, row, rowid, rownum, rows, savepoint, scale, schema, schemas, scope, scroll, search, second, second_microsecond, section, select, sensitive, separator, sequence, session, session_user, set, sets, share, show, signal, similar, size, smallint, some, soname, space, spatial, specific, specifictype, sql, sql_big_result, sql_calc_found_rows, sql_small_result, sqlcode, sqlerror, sqlexception, sqlstate, sqlwarning, ssl, start, starting, state, static, straight_join, submultiset, substring, successful, sum, symmetric, synonym, sysdate, system, system_user, table, tablesample, temp, temporary, terminated, then, time, timestamp, timezone_hour, timezone_minute, tinyblob, tinyint, tinytext, to, trailing, transaction, translate, translation, treat, trigger, trim, true, type, uid, under, undo, union, unique, unknown, unlock, unnest, unsigned, until, update, upgrade, upper, usage, use, user, using, utc_date, utc_time, utc_timestamp, vacuum, validate, value, values, varbinary, varchar, varchar2, varcharacter, varying, verbose, view, virtual, when, whenever, where, while, window, with, within, without, work, write, x509, xor, year, year_month, zerofill, zoneOriginal name and suggested new name (table name conflict is not such important because we can overcome with $db_prefix):
| Original name | Suggested new name | Conflict with |
|---|---|---|
| accesslog.path | accesslog.path | ansi |
| accesslog.timestamp | accesslog.timestamp | ansi |
| accesslog.uid | accesslog.user_id | oci |
| actions.type | actions.type | well-know |
| aggregator_item.timestamp | aggregator_item.timestamp | ansi |
| authmap.module | authmap.module | ansi |
| authmap.uid | authmap.user_id | oci |
| batch.timestamp | batch.timestamp | ansi |
| block.module | block.module | ansi |
| block_role.module | block_role.module | ansi |
| blogapi_files.uid | blogapi_files.user_id | oci |
| cache.data | cache.data | ansi |
| cache_block.data | cache_block.data | ansi |
| cache_filter.data | cache_filter.data | ansi |
| cache_form.data | cache_form.data | ansi |
| cache_menu.data | cache_menu.data | ansi |
| cache_page.data | cache_page.data | ansi |
| cache_registry.data | cache_registry.data | ansi |
| cache_update.data | cache_update.data | ansi |
| comments.comment | comments.body | oci, well-know |
| comments.timestamp | comments.timestamp | ansi |
| comments.uid | comments.user_id | oci |
| files.timestamp | files.timestamp | ansi |
| files.uid | files.user_id | oci |
| filters.module | filters.module | ansi |
| flood.timestamp | flood.timestamp | ansi |
| history.timestamp | history.timestamp | ansi |
| history.uid | history.user_id | oci |
| languages.domain | languages.domain | ansi |
| languages.language | languages.language | ansi |
| locales_target.language | locales_target.language | ansi |
| locales_target.translation | locales_target.translation | ansi |
| menu_links.depth | menu_links.depth | ansi |
| menu_links.external | menu_links.external | ansi |
| menu_links.module | menu_links.module | ansi |
| menu_router.path | menu_router.path | ansi |
| menu_router.position | menu_router.position | ansi |
| menu_router.type | menu_router.type | well-know |
| node.comment | node.comment_mode | oci, well-know |
| node.language | node.language | ansi |
| node.translate | node.translate | ansi |
| node.type | node.type | well-know |
| node.uid | node.user_id | oci |
| node_counter.timestamp | node_counter.timestamp | ansi |
| node_revisions.timestamp | node_revisions.timestamp | ansi |
| node_revisions.uid | node_revisions.user_id | oci |
| node_type.type | node_type.type | well-know |
| poll_votes.uid | poll_votes.user_id | oci |
| profile_fields.type | profile_fields.type | well-know |
| profile_values.uid | profile_values.user_id | oci |
| profile_values.value | profile_values.value | ansi, well-know |
| registry.module | registry.module | ansi |
| registry.type | registry.type | well-know |
| role | role | ansi |
| search_dataset.data | search_dataset.data | ansi |
| search_dataset.reindex | search_dataset.reindex | sqlite |
| search_dataset.type | search_dataset.type | well-know |
| search_index.type | search_index.type | well-know |
| search_node_links.type | search_node_links.type | well-know |
| search_total.count | search_total.count | ansi |
| sessions.session | sessions.session_data | ansi, oci |
| sessions.timestamp | sessions.timestamp | ansi |
| sessions.uid | sessions.user_id | oci |
| simpletest.file | simpletest.filename | oci |
| simpletest.function | simpletest.function | ansi |
| system | system | ansi |
| system.type | system.type | well-know |
| url_alias.language | url_alias.language | ansi |
| users.access | users.last_access | oci |
| users.data | users.data | ansi |
| users.language | users.language | ansi |
| users.uid | users.user_id | oci |
| users_roles.uid | users_roles.user_id | oci |
| variable.value | variable.value | ansi, well-know |
| vocabulary.module | vocabulary.module | ansi |
| vocabulary_node_types.type | vocabulary_node_types.type | well-know |
| watchdog.timestamp | watchdog.timestamp | ansi |
| watchdog.type | watchdog.type | well-know |
| watchdog.uid | watchdog.user_id | oci |