[3524] | 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 |
---|
[3526] | 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; |
---|