• R/O
  • SSH
  • HTTPS

peetan: Commit


Commit MetaInfo

Revision2 (tree)
Time2007-10-30 13:36:46
Authorcre8system

Log Message

初回公開

Change Summary

Incremental Difference

--- trunk/blog/sql/postgresql/blog_data.sql (nonexistent)
+++ trunk/blog/sql/postgresql/blog_data.sql (revision 2)
@@ -0,0 +1,17 @@
1+CREATE TABLE blog_data (
2+ id integer NOT NULL,
3+ title text NOT NULL,
4+ body text NOT NULL,
5+ modified date DEFAULT now() NOT NULL
6+);
7+
8+CREATE SEQUENCE blog_data_id_seq
9+ INCREMENT BY 1
10+ NO MAXVALUE
11+ NO MINVALUE
12+ CACHE 1;
13+
14+ALTER SEQUENCE blog_data_id_seq OWNED BY blog_data.id;
15+ALTER TABLE blog_data ALTER COLUMN id SET DEFAULT nextval('blog_data_id_seq'::regclass);
16+ALTER TABLE ONLY blog_data
17+ ADD CONSTRAINT blog_data_pkey PRIMARY KEY (id);
--- trunk/blog/sql/mysql/blog_data.sql (nonexistent)
+++ trunk/blog/sql/mysql/blog_data.sql (revision 2)
@@ -0,0 +1,8 @@
1+CREATE TABLE `blog_data` (
2+ `id` int(11) NOT NULL auto_increment,
3+ `title` text NOT NULL,
4+ `body` text NOT NULL,
5+ `modified` timestamp NOT NULL
6+ default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
7+ PRIMARY KEY (`id`)
8+);
--- trunk/blog/sql/sqlserver/blog_data.sql (nonexistent)
+++ trunk/blog/sql/sqlserver/blog_data.sql (revision 2)
@@ -0,0 +1,10 @@
1+CREATE TABLE [dbo].[blog_data](
2+ [id] [int] IDENTITY(1,1) NOT NULL,
3+ [title] [text] NOT NULL,
4+ [body] [text] NOT NULL,
5+ [modified] [datetime] NOT NULL CONSTRAINT [DF_blog_data_modified] DEFAULT (getdate()),
6+ CONSTRAINT [PK_blog_data] PRIMARY KEY CLUSTERED
7+ (
8+ [id] ASC
9+ )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
10+) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
--- trunk/blog/del.html (nonexistent)
+++ trunk/blog/del.html (revision 2)
@@ -0,0 +1,11 @@
1+<!--#include file="../peetan/render.asp"-->
2+<form method="post" action="del.asp">
3+Delete OK?<br>
4+TITLE<br>
5+<%=s.html(data("data")("title"))%><br>
6+BODY<br>
7+<%=Replace(s.html(data("data")("body")), vbCrLf, "<br>")%><br>
8+<input type="hidden" name="id" value="<%=data("data")("id")%>">
9+<input type="submit" value="DELETE"><br>
10+<a href=".">back</a>
11+</form>
--- trunk/blog/edit.html (nonexistent)
+++ trunk/blog/edit.html (revision 2)
@@ -0,0 +1,12 @@
1+<!--#include file="../peetan/render.asp"-->
2+<form method="post" action="edit.asp?id=<%=data("data")("id")%>">
3+<font color="red"><%=data("errmsg")%></font>
4+TITLE<br>
5+<input type="text" name="blog/title" value="<%=s.html(data("data")("title"))%>"><br>
6+BODY<br>
7+<textarea cols="40" rows="6" name="blog/body">
8+<%=s.html(data("data")("body"))%></textarea><br>
9+<input type="hidden" name="blog/id" value="<%=data("data")("id")%>">
10+<input type="submit" value="UPDATE">
11+</form>
12+<a href=".">back</a>
--- trunk/blog/index.html (nonexistent)
+++ trunk/blog/index.html (revision 2)
@@ -0,0 +1,23 @@
1+<!--#include file="../peetan/render.asp"-->
2+<p>
3+<a href="add.asp">Write new</a>
4+</p>
5+
6+<% For Each d in data("datas").Items %>
7+<table border=1 cellpadding=8 cellspacing=0>
8+ <tr>
9+ <td>
10+ <%=s.html(d("title"))%>&nbsp;
11+ <a href="edit.asp?id=<%=d("id")%>">Edit</a>&nbsp;
12+ <a href="del.asp?id=<%=d("id")%>">Del</a>
13+ </td>
14+ </tr>
15+ <tr>
16+ <td><%=Replace(s.html(d("body")), vbCrLf, "<br>")%></td>
17+ </tr>
18+ <tr>
19+ <td><%=d("modified")%></td>
20+ </tr>
21+</table>
22+<br>
23+<% Next %>
--- trunk/blog/add.html (nonexistent)
+++ trunk/blog/add.html (revision 2)
@@ -0,0 +1,11 @@
1+<!--#include file="../peetan/render.asp"-->
2+<form method="post" action="add.asp">
3+<font color="red"><%=data("errmsg")%></font>
4+TITLE<br>
5+<input type="text" name="blog/title" value="<%=s.html(data("data")("title"))%>"><br>
6+BODY<br>
7+<textarea cols="40" rows="6" name="blog/body">
8+<%=s.html(data("data")("body"))%></textarea><br>
9+<input type="submit" value="WRITE">
10+</form>
11+<a href=".">back</a>
--- trunk/blog/template.html (nonexistent)
+++ trunk/blog/template.html (revision 2)
@@ -0,0 +1,11 @@
1+<!--#include file="../peetan/render.asp"-->
2+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
3+<html>
4+<head>
5+<meta http-equiv="Content-Type" content="text/html; charset=Shift_JIS">
6+<title>Peetan blog</title>
7+</head>
8+<body>
9+<%=view.content%>
10+</body>
11+</html>
Show on old repository browser