diff options
Diffstat (limited to 'spring-framework/07-user-jdbc-ds-transaction/misc')
| -rw-r--r-- | spring-framework/07-user-jdbc-ds-transaction/misc/mysql-schema.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/spring-framework/07-user-jdbc-ds-transaction/misc/mysql-schema.sql b/spring-framework/07-user-jdbc-ds-transaction/misc/mysql-schema.sql new file mode 100644 index 0000000..5f7e263 --- /dev/null +++ b/spring-framework/07-user-jdbc-ds-transaction/misc/mysql-schema.sql @@ -0,0 +1,7 @@ +CREATE TABLE user_account ( + uid int(11) primary key NOT NULL AUTO_INCREMENT, + username varchar(20) not null unique, + full_name text, + password char(32), + active boolean +) Engine=InnoDB; |