1 | TODO: |
---|
2 | - some artwork : general resource pictures like (room, car, beamer ...) (Benkom) |
---|
3 | - sitemgr module |
---|
4 | |
---|
5 | - list |
---|
6 | select all button --> add actions for selected: move to other cat,... |
---|
7 | |
---|
8 | Long Term todo's: |
---|
9 | --------------------------- |
---|
10 | advanced search dialog, accessable via sideboxmenu |
---|
11 | add buy and prize functionality |
---|
12 | add location functionality |
---|
13 | |
---|
14 | |
---|
15 | CREATE 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 | ) |
---|
35 | WITH (OIDS=TRUE); |
---|
36 | ALTER TABLE phpgw_resources OWNER TO postgres; |
---|