add_preference.sql

来自「国外的一套开源CRM」· SQL 代码 · 共 19 行

insert into user_preference_definitions (
	preference_id,
	preference_name,
	preference_description,
	preference_valid_for_company,
	preference_valid_for_user,
	preference_default,
	preference_data_type,
	preference_values )
values (
	'ROWS_PER_PAGE',
	'Maximum Rows per page on tabular data',
	'How many rows should be displayed on a page when returning large sets of data',
	'Y',
	'Y',
	'20',
	'LONG',
	NULL);