diff options
author | xue <> | 2007-04-08 21:33:23 +0000 |
---|---|---|
committer | xue <> | 2007-04-08 21:33:23 +0000 |
commit | ff32eed01f783ee33caeacb0f7315612f0994f8f (patch) | |
tree | 7b42ed14181d56632160f88f8063b54b17f176af /demos/blog-tutorial/samples/day3/blog/protected/schema.sql | |
parent | 773bf1d0299246d936dcad2ac2ca01bca9d64ca4 (diff) |
Added Day 2 tutorial.
Diffstat (limited to 'demos/blog-tutorial/samples/day3/blog/protected/schema.sql')
-rw-r--r-- | demos/blog-tutorial/samples/day3/blog/protected/schema.sql | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/demos/blog-tutorial/samples/day3/blog/protected/schema.sql b/demos/blog-tutorial/samples/day3/blog/protected/schema.sql new file mode 100644 index 00000000..d3189b40 --- /dev/null +++ b/demos/blog-tutorial/samples/day3/blog/protected/schema.sql @@ -0,0 +1,24 @@ +/* create users table */
+CREATE TABLE users (
+ username VARCHAR(128) NOT NULL PRIMARY KEY,
+ 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)
+);
+
+/* create posts table */
+CREATE TABLE posts (
+ post_id INTEGER NOT NULL PRIMARY KEY,
+ 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 */
+ 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', 0);
|