ü 修改E-R模型,同步数据库
新增字段EMAIL:
选择菜单Database>Modify Database..,弹出Database Modification对话框, 并按确定后执行画面如下:(注意如果要直接生成到DB中, 则应选择ODBC generation选项)
ü POWERDESIGN中的执行日志:
Database Generation Generation: Check model starting... Generation: Check model successful. Sorting objects... Sort completed. Script Generation... Dropping Indexes... -> Index: PRIMARY (PRIMARY) Dropping Tables... -> Dropping columns of the table user (user)... Creating Tables... -> Creating columns of the table user (user)... -> Column: email (email) -> Creating indexes of the table user (user)... Dropping Indexes... Dropping Tables... Creating Tables... Script Generation completed Generation successful
Usage: (1) Start command prompt (2) Go to the directory D:/project-src/hibernate-workspace/document/ (3) Start the SQL interpreter: mysql.exe (4) Run the database creation script: mysql> source crebas.sql Modification of database successful |