Revision 3526,
736 bytes
checked in by afernandes, 14 years ago
(diff) |
Ticket #1416 - Disponibilizado modulos Timesheet e DMS para a comunidade.
|
Rev | Line | |
---|
[3526] | 1 | TODO: |
---|
| 2 | CREATE TABLE phpgw_timesheet |
---|
| 3 | ( |
---|
| 4 | ts_id integer NOT NULL DEFAULT nextval('seq_phpgw_timesheet'::regclass), |
---|
| 5 | ts_project character varying(80) DEFAULT NULL::character varying, |
---|
| 6 | ts_title character varying(80) NOT NULL, |
---|
| 7 | ts_description text, |
---|
| 8 | ts_start bigint NOT NULL, |
---|
| 9 | ts_end bigint NOT NULL DEFAULT (0)::bigint, |
---|
| 10 | ts_cat integer DEFAULT 0, |
---|
| 11 | ts_owner integer NOT NULL, |
---|
| 12 | ts_modified bigint NOT NULL, |
---|
| 13 | ts_infolog character varying(255), |
---|
| 14 | ts_modifier bigint NOT NULL DEFAULT 0, |
---|
| 15 | ts_tracker character varying DEFAULT 255, |
---|
| 16 | ts_owner_name character varying(255), |
---|
| 17 | ts_modifier_name character varying(255), |
---|
| 18 | CONSTRAINT phpgw_timesheet_pkey PRIMARY KEY (ts_id) |
---|
| 19 | ) |
---|
| 20 | WITH (OIDS=FALSE); |
---|
| 21 | ALTER TABLE phpgw_timesheet OWNER TO postgres; |
---|
| 22 | |
---|
Note: See
TracBrowser
for help on using the repository browser.