Creating the database (1)
I created the schema through pgAdmin III. Most of the SQL that follows is generated by that tool.
User
CREATE ROLE plone WITH PASSWORD 'plone';
Database
CREATE DATABASE timesheets
WITH OWNER = plone
ENCODING = 'UTF8';
Users table
CREATE TABLE users ( userid character varying(255) NOT NULL, -- User ID... fullname character varying(255), -- Full name... CONSTRAINT users_pkey PRIMARY KEY (userid) ) WITH (OIDS=FALSE); ALTER TABLE users OWNER TO plone; COMMENT ON COLUMN users.userid IS 'User ID As this is the primary key column, it may not be modified'; COMMENT ON COLUMN users.fullname IS 'Full name optional';
Comments on columns are structured so that the first line can be picked up by collective.mercury and used as the title, followed by a blank line, followed by a description.
