1 files changed, 5 insertions, 4 deletions
diff --git a/demos/blog-tutorial/samples/day2/blog/protected/schema.sql b/demos/blog-tutorial/samples/day2/blog/protected/schema.sql
index 085e47c3..d3189b40 100644
--- a/demos/blog-tutorial/samples/day2/blog/protected/schema.sql
+++ b/demos/blog-tutorial/samples/day2/blog/protected/schema.sql
@@ -1,8 +1,8 @@
 /* create users table */
 CREATE TABLE users (
   username      VARCHAR(128) NOT NULL PRIMARY KEY,
-  email         VARCHAR(128) NOT NULL UNIQUE,
-  password      VARCHAR(128) NOT NULL,  /* plain text password */
+  email         VARCHAR(128) NOT NULL,
+  password      VARCHAR(128) NOT NULL,  /* in plain text */
   role          INTEGER NOT NULL,       /* 0: normal user, 1: administrator */
   first_name    VARCHAR(128),
   last_name     VARCHAR(128)
@@ -14,10 +14,11 @@ CREATE TABLE posts (
   author        VARCHAR(128) NOT NULL,  /* references users.username */
   create_time   INTEGER NOT NULL,       /* UNIX timestamp */
   title         VARCHAR(256) NOT NULL,  /* title of the post */
-  content       TEXT NOT NULL           /* content of the post */
+  content       TEXT NOT NULL,          /* content of the post */
+  status		INTEGER NOT NULL		/* 0: published; 1: draft; 2: pending; 2: denied */
 );
 
 /* insert some initial data records for testing */
 INSERT INTO users VALUES ('admin', 'admin@example.com', 'demo', 1, 'Qiang', 'Xue');
 INSERT INTO users VALUES ('demo', 'demo@example.com', 'demo', 0, 'Wei', 'Zhuo');
-INSERT INTO posts VALUES (NULL, 'admin', 1175708482, 'first post', 'this is my first post');
+INSERT INTO posts VALUES (NULL, 'admin', 1175708482, 'first post', 'this is my first post', 0);