Creating the database (1)

by Laurence Rowe — last modified Feb 04, 2009 03:05 AM
Database creation and a users table

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.