Changeset 3526 for contrib/Resources


Ignore:
Timestamp:
11/19/10 17:14:02 (13 years ago)
Author:
afernandes
Message:

Ticket #1416 - Disponibilizado modulos Timesheet e DMS para a comunidade.

Location:
contrib/Resources
Files:
1 edited
1 moved

Legend:

Unmodified
Added
Removed
  • contrib/Resources/todo

    r3524 r3526  
    1111add buy and prize functionality 
    1212add location functionality 
     13 
     14 
     15CREATE TABLE phpgw_resources 
     16( 
     17  res_id integer NOT NULL DEFAULT nextval('seq_phpgw_resources'::regclass), 
     18  "name" character varying(100), 
     19  short_description character varying(100), 
     20  cat_id integer NOT NULL, 
     21  quantity integer, 
     22  useable integer, 
     23  "location" character varying(100), 
     24  bookable character(1), 
     25  prize character varying(200), 
     26  picture_src character varying(20), 
     27  accessory_of integer, 
     28  storage_info character varying(200), 
     29  inventory_number character varying(20), 
     30  administrador character varying(255), 
     31  email character varying(255), 
     32  "owner" character varying(255), 
     33  CONSTRAINT phpgw_resources_pkey PRIMARY KEY (res_id) 
     34) 
     35WITH (OIDS=TRUE); 
     36ALTER TABLE phpgw_resources OWNER TO postgres; 
Note: See TracChangeset for help on using the changeset viewer.