Here are the list of column name that is bad practice to be used in liferay
custom table. The list is given from Liferay itself.
abstract
access
active
add
alias
all
alter
analyze
and
as
asc
asensitive
assert
auto
before
between
bigint
binary
blob
boolean
both
break
by
byte
call
cascade
case
catch
change
char
character
check
class
code
collate
column
comment
condition
const
constraint
continue
convert
create
cross
currency
current_date
current_time
current_timestamp
current_user
cursor
data
database
databases
date
day_hour
day_microsecond
day_minute
day_second
dec
decimal
declare
default
delayed
delete
desc
describe
deterministic
distinct
distinctrow
div
do
double
drop
dual
each
else
elseif
enclosed
end
enum
escaped
exists
exit
explain
extends
false
featured
fetch
fields
final
finally
float
float4
float8
for
force
foreign
from
full
fulltext
goto
grant
group
having
hidden
high_priority
hour_microsecond
hour_minute
hour_second
hyperlink
id
idd
if
ignore
implements
import
in
increment
index
infile
initial
inner
inout
insensitive
insert
instanceof
int
int1
int2
int3
int4
int8
integer
interface
internal
interval
into
is
iterate
join
key
keys
kill
leading
leave
left
like
limit
lines
load
localtime
localtimestamp
lock
log
long
longblob
longtext
lookup
loop
low_priority
match
mediumblob
mediumint
mediumtext
middleint
minute_microsecond
minute_second
mod
mode
modifies
native
natural
new
no_write_to_binlog
not
null
number
numeric
on
online
optimize
option
optionally
or
order
out
outer
outfile
package
password
path
precision
primary
private
procedure
protected
public
purge
read
reads
real
references
regexp
release
rename
repeat
replace
require
restrict
return
revoke
right
rlike
rowId
rownum
sale
schema
schemas
second_microsecond
select
sensitive
separator
set
settings
short
show
single
size
smallint
soname
spatial
specific
sql
sql_big_result
sql_calc_found_rows
sql_small_result
sqlexception
sqlstate
sqlwarning
ssl
start
starting
state
static
straight_join
strictfp
super
switch
synchronized
table
terminated
text
then
this
throw
throws
time
tinyblob
tinyint
tinytext
to
top
trailing
transient
trigger
true
try
type
undo
union
unique
unique
unlock
unsigned
update
usage
use
using
utc_date
utc_time
utc_timestamp
uuid
values
varbinary
varchar
varcharacter
varying
void
volatile
when
where
while
with
write
xor
year_month
zerofill
Comments
Post a Comment