等级更新
Change-Id: I1ced9fab16019e2175ce165b4bd16c1bbef3e05b
diff --git a/src/test/resources/schema.sql b/src/test/resources/schema.sql
index 677d41c..945e692 100644
--- a/src/test/resources/schema.sql
+++ b/src/test/resources/schema.sql
@@ -38,3 +38,16 @@
create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP(),
CONSTRAINT fk_seed_comments_post FOREIGN KEY (post_id) REFERENCES seed_posts(id) ON DELETE CASCADE
);
+
+CREATE TABLE IF NOT EXISTS "user" (
+ username VARCHAR(20) NOT NULL PRIMARY KEY,
+ password VARCHAR(200) NOT NULL,
+ authority VARCHAR(10) NOT NULL,
+ level INT NOT NULL DEFAULT 0,
+ registTime DATE NOT NULL,
+ lastLogin DATE NULL,
+ upload BIGINT NOT NULL DEFAULT 0,
+ download BIGINT NOT NULL DEFAULT 0,
+ shareRate DOUBLE NULL,
+ magicPoints BIGINT NOT NULL DEFAULT 0
+ );