this is THE PG sql for use with Pollster...
--
-- Users table
--
create table Users (userId char(35),
userName varchar(64) not null,
password char(32) not null,
roles varchar(256) not null,
emailAddress varchar(128) not null,
active varchar(5) not null,
lastLoginDate timestamp not null,
primary key (userId));
grant all on Users to pollster_client;
--
-- Polls table
--
create table Polls (pollId char(35),
userId char(35) not null,
name varchar(64) not null,
question varchar(128) not null,
limitByUserHash varchar(5) not null,
active varchar(5) not null,
creationDate timestamp not null,
primary key (pollId),
foreign key(userId) references Users);
grant all on Polls to pollster_client;
--
-- Options table
--
create table Options (optionId serial,
pollId char(35) not null,
optionText varchar(64) not null,
sortOrder smallint not null,
primary key (optionId),
foreign key(pollId) references Polls);
grant all on Options to pollster_client;
grant all on options_optionid_seq to pollster_client;
--
-- Responses table
--
create table Responses (responseId bigserial,
optionId integer not null,
userHash char(32) not null,
ipAddress varchar(15) not null,
responseDate timestamp not null,
primary key (responseId),
foreign key(optionId) references Options);
grant all on Responses to pollster_client;
grant all on responses_responseid_seq to pollster_client;
Thanx once more...
On Fri, 06 Aug 2004 19:40:01 +0200, Jochem van Dieten
<[EMAIL PROTECTED]> wrote:
> Marco Antonio C. Santos wrote:
> > Anyone uses? It's so hard to change SQL from SQL Server (inside
> > Pollster app) to PG?
>
> Is it? Can you show an example that you are having trouble with?
>
> Jochem
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
