[dev] PostgreSQL version of sql files

[Dan Wilson]

I've altered the .sql files for ulaform and scry to PostgreSQL.  You can find 
them attached.

-Dan

-------------- next part --------------
--
-- Table structure for table `scry_choices`
--

CREATE TABLE scry_choices (
  choice_id int NOT NULL default 0,
  poll_id int NOT NULL default 0,
  choice_value varchar(255) NOT NULL default '',
  PRIMARY KEY  (choice_id)
);
CREATE INDEX scry_choices_poll_id_idx ON scry_choices (poll_id);

--
-- Table structure for table `scry_polls`
--

CREATE TABLE scry_polls (
  poll_id int NOT NULL default 0,
  poll_title varchar(255) NOT NULL default '',
  poll_question varchar(255) NOT NULL default '',
  poll_start date NOT NULL,
  poll_end date NOT NULL,
  poll_enabled varchar(1) NOT NULL default '0',
  PRIMARY KEY  (poll_id)
);

--
-- Table structure for table `scry_votes`
--

CREATE TABLE scry_votes (
  vote_id int NOT NULL default 0,
  poll_id int NOT NULL default 0,
  choice_id int NOT NULL default 0,
  vote_identifier varchar(255) default NULL,
  vote_ip varchar(255) NOT NULL default '',
  vote_confirmation varchar(255) default NULL,
  vote_timestamp timestamp NOT NULL,
  PRIMARY KEY  (vote_id,poll_id)
);
CREATE INDEX scry_votes_poll_id_idx ON scry_votes (poll_id);
CREATE INDEX scry_votes_choice_id_idx ON scry_votes (choice_id);
-------------- next part --------------
-- $Horde: ulaform/scripts/drivers/ulaform.sql,v 1.3 2003/01/22 22:09:31 jan Exp $

CREATE TABLE ulaform_fields (
    form_owner VARCHAR(80) DEFAULT '' NOT NULL,
    form_name VARCHAR(40) DEFAULT '' NOT NULL,
    field_name VARCHAR(40) DEFAULT '' NOT NULL,
    field_number INT DEFAULT 1 NOT NULL,
    field_type VARCHAR(5) DEFAULT 'text' NOT NULL,
    field_length INT DEFAULT 80 NOT NULL,
    field_required VARCHAR(1) DEFAULT 'N' NOT NULL,
    field_description VARCHAR(80) DEFAULT '' NOT NULL,

    PRIMARY KEY (form_owner, form_name, field_name)
);