You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@jspwiki.apache.org by aj...@apache.org on 2008/02/13 06:45:35 UTC
svn commit: r627250 - in
/incubator/jspwiki/branches/JSPWIKI_STRIPES_BRANCH/etc: ./ db/ db/hsql/
db/hsql/server.properties db/hsql/userdb-setup.ddl
db/hsql/userdb-teardown.ddl
Author: ajaquith
Date: Tue Feb 12 21:45:34 2008
New Revision: 627250
URL: http://svn.apache.org/viewvc?rev=627250&view=rev
Log:
Initial import. Let's hope I did it right.
Added:
incubator/jspwiki/branches/JSPWIKI_STRIPES_BRANCH/etc/
incubator/jspwiki/branches/JSPWIKI_STRIPES_BRANCH/etc/db/
incubator/jspwiki/branches/JSPWIKI_STRIPES_BRANCH/etc/db/hsql/
incubator/jspwiki/branches/JSPWIKI_STRIPES_BRANCH/etc/db/hsql/server.properties
incubator/jspwiki/branches/JSPWIKI_STRIPES_BRANCH/etc/db/hsql/userdb-setup.ddl
incubator/jspwiki/branches/JSPWIKI_STRIPES_BRANCH/etc/db/hsql/userdb-teardown.ddl
Added: incubator/jspwiki/branches/JSPWIKI_STRIPES_BRANCH/etc/db/hsql/server.properties
URL: http://svn.apache.org/viewvc/incubator/jspwiki/branches/JSPWIKI_STRIPES_BRANCH/etc/db/hsql/server.properties?rev=627250&view=auto
==============================================================================
--- incubator/jspwiki/branches/JSPWIKI_STRIPES_BRANCH/etc/db/hsql/server.properties (added)
+++ incubator/jspwiki/branches/JSPWIKI_STRIPES_BRANCH/etc/db/hsql/server.properties Tue Feb 12 21:45:34 2008
@@ -0,0 +1,3 @@
+server.port=9001
+server.database.0=file:jspwiki
+server.dbname.0=jspwiki
Added: incubator/jspwiki/branches/JSPWIKI_STRIPES_BRANCH/etc/db/hsql/userdb-setup.ddl
URL: http://svn.apache.org/viewvc/incubator/jspwiki/branches/JSPWIKI_STRIPES_BRANCH/etc/db/hsql/userdb-setup.ddl?rev=627250&view=auto
==============================================================================
--- incubator/jspwiki/branches/JSPWIKI_STRIPES_BRANCH/etc/db/hsql/userdb-setup.ddl (added)
+++ incubator/jspwiki/branches/JSPWIKI_STRIPES_BRANCH/etc/db/hsql/userdb-setup.ddl Tue Feb 12 21:45:34 2008
@@ -0,0 +1,148 @@
+drop table @jspwiki.userdatabase.table@ if exists;
+drop table @jspwiki.userdatabase.roleTable@ if exists;
+drop table @jspwiki.groupdatabase.table@ if exists;
+drop table @jspwiki.groupdatabase.membertable@ if exists;
+drop user @jdbc.user.id@;
+
+create table @jspwiki.userdatabase.table@ (
+ @jspwiki.userdatabase.email@ varchar(100),
+ @jspwiki.userdatabase.fullName@ varchar(100),
+ @jspwiki.userdatabase.loginName@ varchar(100) not null,
+ @jspwiki.userdatabase.password@ varchar(100),
+ @jspwiki.userdatabase.wikiName@ varchar(100),
+ @jspwiki.userdatabase.created@ timestamp,
+ @jspwiki.userdatabase.modified@ timestamp,
+ constraint @jspwiki.userdatabase.table@ primary key (@jspwiki.userdatabase.loginName@)
+);
+
+create table @jspwiki.userdatabase.roleTable@ (
+ @jspwiki.userdatabase.loginName@ varchar(100) not null,
+ @jspwiki.userdatabase.role@ varchar(100) not null
+);
+
+create table @jspwiki.groupdatabase.table@ (
+ @jspwiki.groupdatabase.name@ varchar(100) not null,
+ @jspwiki.groupdatabase.creator@ varchar(100),
+ @jspwiki.groupdatabase.created@ timestamp,
+ @jspwiki.groupdatabase.modifier@ varchar(100),
+ @jspwiki.groupdatabase.modified@ timestamp,
+ constraint @jspwiki.groupdatabase.table@ primary key (@jspwiki.groupdatabase.name@)
+);
+
+create table @jspwiki.groupdatabase.membertable@ (
+ @jspwiki.groupdatabase.name@ varchar(100) not null,
+ @jspwiki.groupdatabase.member@ varchar(100) not null,
+ constraint @jspwiki.groupdatabase.membertable@ primary key
+ (@jspwiki.groupdatabase.name@,@jspwiki.groupdatabase.member@)
+);
+
+create user @jdbc.user.id@ password "@jdbc.user.password@";
+
+grant select, insert, update, delete on @jspwiki.userdatabase.table@ to @jdbc.user.id@;
+grant select, insert, update, delete on @jspwiki.userdatabase.roleTable@ to @jdbc.user.id@;
+grant select, insert, update, delete on @jspwiki.groupdatabase.table@ to @jdbc.user.id@;
+grant select, insert, update, delete on @jspwiki.groupdatabase.membertable@ to @jdbc.user.id@;
+
+insert into @jspwiki.userdatabase.table@ (
+ @jspwiki.userdatabase.email@,
+ @jspwiki.userdatabase.fullName@,
+ @jspwiki.userdatabase.loginName@,
+ @jspwiki.userdatabase.password@,
+ @jspwiki.userdatabase.wikiName@
+) values (
+ 'janne@ecyrd.com',
+ 'Janne Jalkanen',
+ 'janne',
+ '457b08e825da547c3b77fbc1ff906a1d00a7daee',
+ 'JanneJalkanen'
+);
+
+insert into @jspwiki.userdatabase.roleTable@ (
+ @jspwiki.userdatabase.loginName@,
+ @jspwiki.userdatabase.role@
+) values (
+ 'janne',
+ 'Authenticated'
+);
+
+insert into @jspwiki.groupdatabase.table@ (
+ @jspwiki.groupdatabase.name@,
+ @jspwiki.groupdatabase.created@,
+ @jspwiki.groupdatabase.modified@
+) values (
+ 'TV',
+ '2006-06-20 14:50:54.00000000',
+ '2006-06-20 14:50:54.00000000'
+);
+insert into @jspwiki.groupdatabase.membertable@ (
+ @jspwiki.groupdatabase.name@,
+ @jspwiki.groupdatabase.member@
+) values (
+ 'TV',
+ 'Archie Bunker'
+);
+insert into @jspwiki.groupdatabase.membertable@ (
+ @jspwiki.groupdatabase.name@,
+ @jspwiki.groupdatabase.member@
+) values (
+ 'TV',
+ 'BullwinkleMoose'
+);
+insert into @jspwiki.groupdatabase.membertable@ (
+ @jspwiki.groupdatabase.name@,
+ @jspwiki.groupdatabase.member@
+) values (
+ 'TV',
+ 'Fred Friendly'
+);
+
+insert into @jspwiki.groupdatabase.table@ (
+ @jspwiki.groupdatabase.name@,
+ @jspwiki.groupdatabase.created@,
+ @jspwiki.groupdatabase.modified@
+) values (
+ 'Literature',
+ '2006-06-20 14:50:54.00000000',
+ '2006-06-20 14:50:54.00000000'
+);
+insert into @jspwiki.groupdatabase.membertable@ (
+ @jspwiki.groupdatabase.name@,
+ @jspwiki.groupdatabase.member@
+) values (
+ 'Literature',
+ 'Charles Dickens'
+);
+insert into @jspwiki.groupdatabase.membertable@ (
+ @jspwiki.groupdatabase.name@,
+ @jspwiki.groupdatabase.member@
+) values (
+ 'Literature',
+ 'Homer'
+);
+
+insert into @jspwiki.groupdatabase.table@ (
+ @jspwiki.groupdatabase.name@,
+ @jspwiki.groupdatabase.created@,
+ @jspwiki.groupdatabase.modified@
+) values (
+ 'Art',
+ '2006-06-20 14:50:54.00000000',
+ '2006-06-20 14:50:54.00000000'
+);
+
+insert into @jspwiki.groupdatabase.table@ (
+ @jspwiki.groupdatabase.name@,
+ @jspwiki.groupdatabase.created@,
+ @jspwiki.groupdatabase.modified@
+) values (
+ 'Admin',
+ '2006-06-20 14:50:54.00000000',
+ '2006-06-20 14:50:54.00000000'
+);
+insert into @jspwiki.groupdatabase.membertable@ (
+ @jspwiki.groupdatabase.name@,
+ @jspwiki.groupdatabase.member@
+) values (
+ 'Admin',
+ 'Administrator'
+);
Added: incubator/jspwiki/branches/JSPWIKI_STRIPES_BRANCH/etc/db/hsql/userdb-teardown.ddl
URL: http://svn.apache.org/viewvc/incubator/jspwiki/branches/JSPWIKI_STRIPES_BRANCH/etc/db/hsql/userdb-teardown.ddl?rev=627250&view=auto
==============================================================================
--- incubator/jspwiki/branches/JSPWIKI_STRIPES_BRANCH/etc/db/hsql/userdb-teardown.ddl (added)
+++ incubator/jspwiki/branches/JSPWIKI_STRIPES_BRANCH/etc/db/hsql/userdb-teardown.ddl Tue Feb 12 21:45:34 2008
@@ -0,0 +1,5 @@
+drop table @jspwiki.userdatabase.table@ if exists;
+drop table @jspwiki.userdatabase.roleTable@ if exists;
+drop table @jspwiki.groupdatabase.table@ if exists;
+drop table @jspwiki.groupdatabase.membertable@ if exists;
+drop user @jdbc.user.id@;