| 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 @jspwiki.groupdatabase.membertable@_pk |
| 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 ( |
| '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', |
| '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' |
| ); |