CREATE TABLE system_preferences(
id INT PRIMARY KEY auto_increment COMMENT 'primary key',
pref_key VARCHAR(256) COMMENT 'preference key',
pref_val VARCHAR(256) COMMENT 'value',
pref_name VARCHAR(512) COMMENT 'name',
description VARCHAR(1024) COMMENT 'description',
show_user INT COMMENT 'can modify by user',
fx_group VARCHAR(256) COMMENT 'Group of Preferences',
ordernum INT COMMENT 'list order',
insert_time DATETIME COMMENT 'create datetime',
insert_user INT COMMENT 'create user',
update_time DATETIME COMMENT 'update datetime',
update_user INT COMMENT 'update user'
)  type=InnoDB, COMMENT = 'System Preferences'
;

INSERT INTO system_preferences ( id, pref_key, pref_val, pref_name, description, show_user, fx_group, ordernum, insert_time, insert_user, update_time, update_user ) VALUES (1,'required_issue_deadline','1','required of deadline','Deadline of issue is required?',1,'Issues',1,'2009-11-15 00:00:00',0,'2009-11-15 00:00:00',0)
;
