| 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; |
|---|
