From ff32eed01f783ee33caeacb0f7315612f0994f8f Mon Sep 17 00:00:00 2001 From: xue <> Date: Sun, 8 Apr 2007 21:33:23 +0000 Subject: Added Day 2 tutorial. --- .../samples/day2/blog/protected/data/blog.db | Bin 5120 -> 4096 bytes .../day2/blog/protected/database/PostRecord.php | 4 +++- .../day2/blog/protected/database/UserRecord.php | 2 +- .../day2/blog/protected/layouts/MainLayout.tpl | 2 +- .../samples/day2/blog/protected/schema.sql | 9 +++++---- 5 files changed, 10 insertions(+), 7 deletions(-) (limited to 'demos/blog-tutorial/samples/day2/blog/protected') diff --git a/demos/blog-tutorial/samples/day2/blog/protected/data/blog.db b/demos/blog-tutorial/samples/day2/blog/protected/data/blog.db index 37449fd3..46e82bfb 100644 Binary files a/demos/blog-tutorial/samples/day2/blog/protected/data/blog.db and b/demos/blog-tutorial/samples/day2/blog/protected/data/blog.db differ diff --git a/demos/blog-tutorial/samples/day2/blog/protected/database/PostRecord.php b/demos/blog-tutorial/samples/day2/blog/protected/database/PostRecord.php index 31451b30..a761286a 100644 --- a/demos/blog-tutorial/samples/day2/blog/protected/database/PostRecord.php +++ b/demos/blog-tutorial/samples/day2/blog/protected/database/PostRecord.php @@ -1,6 +1,6 @@ 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); -- cgit v1.2.3