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 @@
 <?php
 /**
- * Auto generated by prado-cli.php on 2007-04-06 08:42:12.
+ * Auto generated by prado-cli.php on 2007-04-07 10:44:20.
  */
 class PostRecord extends TActiveRecord
 {
@@ -15,6 +15,8 @@ class PostRecord extends TActiveRecord
 	public $title;
 
 	public $content;
+
+	public $status;
 
 
 	public static function finder($className=__CLASS__)
diff --git a/demos/blog-tutorial/samples/day2/blog/protected/database/UserRecord.php b/demos/blog-tutorial/samples/day2/blog/protected/database/UserRecord.php
index 2f657cd8..87043894 100644
--- a/demos/blog-tutorial/samples/day2/blog/protected/database/UserRecord.php
+++ b/demos/blog-tutorial/samples/day2/blog/protected/database/UserRecord.php
@@ -1,6 +1,6 @@
 <?php
 /**
- * Auto generated by prado-cli.php on 2007-04-06 08:42:08.
+ * Auto generated by prado-cli.php on 2007-04-07 10:44:25.
  */
 class UserRecord extends TActiveRecord
 {
diff --git a/demos/blog-tutorial/samples/day2/blog/protected/layouts/MainLayout.tpl b/demos/blog-tutorial/samples/day2/blog/protected/layouts/MainLayout.tpl
index 5218b98d..6e264936 100644
--- a/demos/blog-tutorial/samples/day2/blog/protected/layouts/MainLayout.tpl
+++ b/demos/blog-tutorial/samples/day2/blog/protected/layouts/MainLayout.tpl
@@ -12,7 +12,7 @@
 </div>
  
 <div id="footer">
-Powered by <%= PRADO::poweredByPrado() %>
+<%= PRADO::poweredByPrado() %>
 </div>
  
 </com:TForm>
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