You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@aries.apache.org by zo...@apache.org on 2010/02/07 10:57:14 UTC
svn commit: r907406 - in
/incubator/aries/trunk/samples/blog-sample/blog-assembly/src/main/resources:
._blogDB.sql blogDB.sql
Author: zoe
Date: Sun Feb 7 09:57:13 2010
New Revision: 907406
URL: http://svn.apache.org/viewvc?rev=907406&view=rev
Log:
ARIES-149
Removed:
incubator/aries/trunk/samples/blog-sample/blog-assembly/src/main/resources/._blogDB.sql
Modified:
incubator/aries/trunk/samples/blog-sample/blog-assembly/src/main/resources/blogDB.sql
Modified: incubator/aries/trunk/samples/blog-sample/blog-assembly/src/main/resources/blogDB.sql
URL: http://svn.apache.org/viewvc/incubator/aries/trunk/samples/blog-sample/blog-assembly/src/main/resources/blogDB.sql?rev=907406&r1=907405&r2=907406&view=diff
==============================================================================
--- incubator/aries/trunk/samples/blog-sample/blog-assembly/src/main/resources/blogDB.sql (original)
+++ incubator/aries/trunk/samples/blog-sample/blog-assembly/src/main/resources/blogDB.sql Sun Feb 7 09:57:13 2010
@@ -1,8 +1,15 @@
-connect 'jdbc:derby:blogDB;create=true';
-CREATE TABLE Author (email VARCHAR(255) NOT NULL, bio VARCHAR(255), displayName VARCHAR(255), dob TIMESTAMP, name VARCHAR(255), PRIMARY KEY (email));
-CREATE TABLE Author_BlogEntry (AUTHOR_EMAIL VARCHAR(255), POSTS_ID BIGINT);
-CREATE TABLE BlogEntry (id BIGINT NOT NULL, blogText VARCHAR(10000), publishDate TIMESTAMP, title VARCHAR(255), updatedDate TIMESTAMP, AUTHOR_EMAIL VARCHAR(255), PRIMARY KEY (id));
-CREATE INDEX I_THR_TRY_AUTHOR_EMAIL ON Author_BlogEntry (AUTHOR_EMAIL);
-CREATE INDEX I_THR_TRY_ELEMENT ON Author_BlogEntry (POSTS_ID);
-CREATE INDEX I_BLGNTRY_AUTHOR ON BlogEntry (AUTHOR_EMAIL);
+connect 'jdbc:derby:BLOGDB/;create=true';
+CREATE TABLE AUTHOR (email VARCHAR(255) NOT NULL, bio VARCHAR(255), displayName VARCHAR(255), dob TIMESTAMP, name VARCHAR(255), PRIMARY KEY (email));
+CREATE TABLE AUTHOR_BLOGENTRY (AUTHOR_EMAIL VARCHAR(255), POSTS_ID BIGINT);
+CREATE TABLE BLOGENTRY (id BIGINT NOT NULL, blogText VARCHAR(10000), publishDate TIMESTAMP, title VARCHAR(255), updatedDate TIMESTAMP, AUTHOR_EMAIL VARCHAR(255), PRIMARY KEY (id));
+CREATE TABLE COMMENT (id BIGINT NOT NULL, comment VARCHAR(255), creationDate TIMESTAMP, AUTHOR_EMAIL VARCHAR(255), BLOGENTRY_ID BIGINT);
+CREATE TABLE OPENJPA_SEQUENCE_TABLE (ID SMALLINT NOT NULL, SEQUENCE_VALUE BIGINT, PRIMARY KEY (ID));
+CREATE INDEX I_THR_TRY_AUTHOR_EMAIL ON AUTHOR_BLOGENTRY (AUTHOR_EMAIL);
+CREATE INDEX I_THR_TRY_ELEMENT ON AUTHOR_BLOGENTRY (POSTS_ID);
+CREATE INDEX I_BLGNTRY_AUTHOR ON BLOGENTRY (AUTHOR_EMAIL);
+DELETE FROM AUTHOR;
+DELETE FROM AUTHOR_BLOGENTRY;
+DELETE FROM BLOGENTRY;
+DELETE FROM COMMENT;
+DELETE FROM OPENJPA_SEQUENCE_TABLE;
exit;