add functionality and fix bug

add list() in Notice
add sql file
fix bug