Author: ajaquith
Date: Tue Feb 12 21:45:52 2008
New Revision: 627251
URL: http://svn.apache.org/viewvc?rev=627251&view=rev
Log:
Initial import. Let's hope I did it right.
Added:
incubator/jspwiki/branches/JSPWIKI_STRIPES_BRANCH/etc/db/postgresql/
incubator/jspwiki/branches/JSPWIKI_STRIPES_BRANCH/etc/db/postgresql/userdb-setup.ddl
incubator/jspwiki/branches/JSPWIKI_STRIPES_BRANCH/etc/db/postgresql/userdb-teardown.ddl
Added:
incubator/jspwiki/branches/JSPWIKI_STRIPES_BRANCH/etc/db/postgresql/userdb-setup.ddl
URL:
http://svn.apache.org/viewvc/incubator/jspwiki/branches/JSPWIKI_STRIPES_BRANCH/etc/db/postgresql/userdb-setup.ddl?rev=627251&view=auto
==============================================================================
---
incubator/jspwiki/branches/JSPWIKI_STRIPES_BRANCH/etc/db/postgresql/userdb-setup.ddl
(added)
+++
incubator/jspwiki/branches/JSPWIKI_STRIPES_BRANCH/etc/db/postgresql/userdb-setup.ddl
Tue Feb 12 21:45:52 2008
@@ -0,0 +1,146 @@
+drop table @jspwiki.userdatabase.table@;
+drop table @jspwiki.userdatabase.roleTable@;
+drop table @jspwiki.groupdatabase.table@;
+drop table @jspwiki.groupdatabase.membertable@;
+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 primary key,
+ @jspwiki.userdatabase.password@ varchar(100),
+ @jspwiki.userdatabase.wikiName@ varchar(100),
+ @jspwiki.userdatabase.created@ timestamp,
+ @jspwiki.userdatabase.modified@ timestamp
+);
+
+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 primary key,
+ @jspwiki.groupdatabase.creator@ varchar(100),
+ @jspwiki.groupdatabase.created@ timestamp,
+ @jspwiki.groupdatabase.modifier@ varchar(100),
+ @jspwiki.groupdatabase.modified@ timestamp
+);
+
+create table @jspwiki.groupdatabase.membertable@ (
+ @jspwiki.groupdatabase.name@ varchar(100) not null,
+ @jspwiki.groupdatabase.member@ varchar(100) not null,
+ constraint @[EMAIL PROTECTED]
+ primary key (@jspwiki.groupdatabase.name@,@jspwiki.groupdatabase.member@)
+);
+
+create user @jdbc.user.id@ with encrypted password '@jdbc.user.password@'
nocreatedb nocreateuser;
+
+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 (
+ '[EMAIL PROTECTED]',
+ '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',
+ '2006-06-20 14:50:54'
+);
+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/postgresql/userdb-teardown.ddl
URL:
http://svn.apache.org/viewvc/incubator/jspwiki/branches/JSPWIKI_STRIPES_BRANCH/etc/db/postgresql/userdb-teardown.ddl?rev=627251&view=auto
==============================================================================
---
incubator/jspwiki/branches/JSPWIKI_STRIPES_BRANCH/etc/db/postgresql/userdb-teardown.ddl
(added)
+++
incubator/jspwiki/branches/JSPWIKI_STRIPES_BRANCH/etc/db/postgresql/userdb-teardown.ddl
Tue Feb 12 21:45:52 2008
@@ -0,0 +1,5 @@
+drop table @jspwiki.userdatabase.table@;
+drop table @jspwiki.userdatabase.roleTable@;
+drop table @jspwiki.groupdatabase.table@;
+drop table @jspwiki.groupdatabase.membertable@;
+drop user @jdbc.user.id@;
