Shopxx adopts spring + jpa hibernate without hbm files, and adopts hbm2dllauto default update
Update means that when hibernate is loaded for the first time, the table structure will be automatically created based on the model class (the premise is that the database is established first), and the table structure will be automatically updated based on the model class when hibernate is loaded later, even if the table structure is changed, the row in the table still does not delete the previous row.
Therefore, the example SQL provided does not need to be used. You need to modify the number field to num. Do not use the Oracle keyword.
The admin record resource table name is reserved.
The required data table is admin role admin_role resource role_resource.
Other footer items are optional. You can add it later.
Test data. You also need to make simple modifications.