incubator-aries-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From z..@apache.org
Subject svn commit: r907406 - in /incubator/aries/trunk/samples/blog-sample/blog-assembly/src/main/resources: ._blogDB.sql blogDB.sql
Date Sun, 07 Feb 2010 09:57:14 GMT
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;



Mime
View raw message