[CS-Project-svn_notify] SF.net SVN: cs-project: [872] trunk/1.2/docs
Brought to you by:
crazedsanity
Menu
▾
▴
[CS-Project-svn_notify] SF.net SVN: cs-project: [872] trunk/1.2/docs
|
From: <cra...@us...> - 2008-04-09 03:07:02
|
Revision: 872
http://cs-project.svn.sourceforge.net/cs-project/?rev=872&view=rev
Author: crazedsanity
Date: 2008-04-08 20:06:56 -0700 (Tue, 08 Apr 2008)
Log Message:
-----------
More renaming of "todo" to "task" (issue #151)
Modified Paths:
--------------
trunk/1.2/docs/features.txt
trunk/1.2/docs/schema/cs_project.schema.sql
trunk/1.2/docs/sql/setup/02__tables.sql
trunk/1.2/docs/sql/setup/03__indexes_etc.sql
Modified: trunk/1.2/docs/features.txt
===================================================================
--- trunk/1.2/docs/features.txt 2008-04-09 02:59:06 UTC (rev 871)
+++ trunk/1.2/docs/features.txt 2008-04-09 03:06:56 UTC (rev 872)
@@ -6,7 +6,7 @@
=== Simplicity ===
This system is built on a very simple premise: Project managers manage projects. There are various types of issues associated with those projects (bugs, feature requests, etc). Each project and issue have tasks associated with them. Everyone is interested in how long things take.
- CS-Project incorporates all of these principles. Projects are a broad indicator of the various pieces of a system. Large projects can be broken into smaller parts (sometimes referred to as “milestones”) to help focus efforts. New issues, including bugs and feature requests, can be added to a project to help maintain a list of all the things that are requested or have been found to be problematic. Tasks (todos) create a breakdown of things that need to be accomplished.
+ CS-Project incorporates all of these principles. Projects are a broad indicator of the various pieces of a system. Large projects can be broken into smaller parts (sometimes referred to as “milestones”) to help focus efforts. New issues, including bugs and feature requests, can be added to a project to help maintain a list of all the things that are requested or have been found to be problematic. Tasks create a breakdown of things that need to be accomplished.
To further simplify things, CS-Project doesn't tie its users down to a specific way to use it: it can be easily used strictly as a Trouble Ticket (Help Desk) system, or just projects, or both.
Modified: trunk/1.2/docs/schema/cs_project.schema.sql
===================================================================
--- trunk/1.2/docs/schema/cs_project.schema.sql 2008-04-09 02:59:06 UTC (rev 871)
+++ trunk/1.2/docs/schema/cs_project.schema.sql 2008-04-09 03:06:56 UTC (rev 872)
@@ -899,7 +899,7 @@
log_estimate_id integer NOT NULL,
creation timestamp with time zone DEFAULT now() NOT NULL,
uid integer NOT NULL,
- todo_id integer NOT NULL,
+ task_id integer NOT NULL,
add_elapsed numeric(10,2) NOT NULL,
system_note text
);
@@ -1361,12 +1361,12 @@
--
--- Name: todo_comment_table; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
+-- Name: task_comment_table; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
-CREATE TABLE todo_comment_table (
- todo_comment_id integer NOT NULL,
- todo_id integer NOT NULL,
+CREATE TABLE task_comment_table (
+ task_comment_id integer NOT NULL,
+ task_id integer NOT NULL,
creator_contact_id integer NOT NULL,
created timestamp with time zone DEFAULT now() NOT NULL,
updated timestamp with time zone,
@@ -1375,13 +1375,13 @@
);
-ALTER TABLE public.todo_comment_table OWNER TO postgres;
+ALTER TABLE public.task_comment_table OWNER TO postgres;
--
--- Name: todo_comment_table_todo_comment_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
+-- Name: task_comment_table_task_comment_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
-CREATE SEQUENCE todo_comment_table_todo_comment_id_seq
+CREATE SEQUENCE task_comment_table_task_comment_id_seq
START WITH 1
INCREMENT BY 1
NO MAXVALUE
@@ -1389,21 +1389,21 @@
CACHE 1;
-ALTER TABLE public.todo_comment_table_todo_comment_id_seq OWNER TO postgres;
+ALTER TABLE public.task_comment_table_task_comment_id_seq OWNER TO postgres;
--
--- Name: todo_comment_table_todo_comment_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
+-- Name: task_comment_table_task_comment_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
-ALTER SEQUENCE todo_comment_table_todo_comment_id_seq OWNED BY todo_comment_table.todo_comment_id;
+ALTER SEQUENCE task_comment_table_task_comment_id_seq OWNED BY task_comment_table.task_comment_id;
--
--- Name: todo_table; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
+-- Name: task_table; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
-CREATE TABLE todo_table (
- todo_id integer NOT NULL,
+CREATE TABLE task_table (
+ task_id integer NOT NULL,
creator_contact_id integer NOT NULL,
name text NOT NULL,
body text NOT NULL,
@@ -1422,13 +1422,13 @@
);
-ALTER TABLE public.todo_table OWNER TO postgres;
+ALTER TABLE public.task_table OWNER TO postgres;
--
--- Name: todo_table_todo_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
+-- Name: task_table_task_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
-CREATE SEQUENCE todo_table_todo_id_seq
+CREATE SEQUENCE task_table_task_id_seq
START WITH 1
INCREMENT BY 1
NO MAXVALUE
@@ -1436,13 +1436,13 @@
CACHE 1;
-ALTER TABLE public.todo_table_todo_id_seq OWNER TO postgres;
+ALTER TABLE public.task_table_task_id_seq OWNER TO postgres;
--
--- Name: todo_table_todo_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
+-- Name: task_table_task_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
-ALTER SEQUENCE todo_table_todo_id_seq OWNED BY todo_table.todo_id;
+ALTER SEQUENCE task_table_task_id_seq OWNED BY task_table.task_id;
--
@@ -1691,17 +1691,17 @@
--
--- Name: todo_comment_id; Type: DEFAULT; Schema: public; Owner: postgres
+-- Name: task_comment_id; Type: DEFAULT; Schema: public; Owner: postgres
--
-ALTER TABLE todo_comment_table ALTER COLUMN todo_comment_id SET DEFAULT nextval('todo_comment_table_todo_comment_id_seq'::regclass);
+ALTER TABLE task_comment_table ALTER COLUMN task_comment_id SET DEFAULT nextval('task_comment_table_task_comment_id_seq'::regclass);
--
--- Name: todo_id; Type: DEFAULT; Schema: public; Owner: postgres
+-- Name: task_id; Type: DEFAULT; Schema: public; Owner: postgres
--
-ALTER TABLE todo_table ALTER COLUMN todo_id SET DEFAULT nextval('todo_table_todo_id_seq'::regclass);
+ALTER TABLE task_table ALTER COLUMN task_id SET DEFAULT nextval('task_table_task_id_seq'::regclass);
--
@@ -1902,19 +1902,19 @@
--
--- Name: todo_comment_table_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
+-- Name: task_comment_table_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--
-ALTER TABLE ONLY todo_comment_table
- ADD CONSTRAINT todo_comment_table_pkey PRIMARY KEY (todo_comment_id);
+ALTER TABLE ONLY task_comment_table
+ ADD CONSTRAINT task_comment_table_pkey PRIMARY KEY (task_comment_id);
--
--- Name: todo_table_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
+-- Name: task_table_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--
-ALTER TABLE ONLY todo_table
- ADD CONSTRAINT todo_table_pkey PRIMARY KEY (todo_id);
+ALTER TABLE ONLY task_table
+ ADD CONSTRAINT task_table_pkey PRIMARY KEY (task_id);
--
@@ -2024,11 +2024,11 @@
--
--- Name: log_estiate_table_todo_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
+-- Name: log_estiate_table_task_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY log_estimate_table
- ADD CONSTRAINT log_estiate_table_todo_id_fkey FOREIGN KEY (todo_id) REFERENCES todo_table(todo_id);
+ ADD CONSTRAINT log_estiate_table_task_id_fkey FOREIGN KEY (task_id) REFERENCES task_table(task_id);
--
@@ -2176,51 +2176,51 @@
--
--- Name: todo_comment_table_creator_contact_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
+-- Name: task_comment_table_creator_contact_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--
-ALTER TABLE ONLY todo_comment_table
- ADD CONSTRAINT todo_comment_table_creator_contact_id_fkey FOREIGN KEY (creator_contact_id) REFERENCES contact_table(contact_id);
+ALTER TABLE ONLY task_comment_table
+ ADD CONSTRAINT task_comment_table_creator_contact_id_fkey FOREIGN KEY (creator_contact_id) REFERENCES contact_table(contact_id);
--
--- Name: todo_comment_table_todo_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
+-- Name: task_comment_table_task_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--
-ALTER TABLE ONLY todo_comment_table
- ADD CONSTRAINT todo_comment_table_todo_id_fkey FOREIGN KEY (todo_id) REFERENCES todo_table(todo_id);
+ALTER TABLE ONLY task_comment_table
+ ADD CONSTRAINT task_comment_table_task_id_fkey FOREIGN KEY (task_id) REFERENCES task_table(task_id);
--
--- Name: todo_table_assigned_contact_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
+-- Name: task_table_assigned_contact_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--
-ALTER TABLE ONLY todo_table
- ADD CONSTRAINT todo_table_assigned_contact_id_fkey FOREIGN KEY (assigned_contact_id) REFERENCES contact_table(contact_id);
+ALTER TABLE ONLY task_table
+ ADD CONSTRAINT task_table_assigned_contact_id_fkey FOREIGN KEY (assigned_contact_id) REFERENCES contact_table(contact_id);
--
--- Name: todo_table_creator_contact_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
+-- Name: task_table_creator_contact_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--
-ALTER TABLE ONLY todo_table
- ADD CONSTRAINT todo_table_creator_contact_id_fkey FOREIGN KEY (creator_contact_id) REFERENCES contact_table(contact_id);
+ALTER TABLE ONLY task_table
+ ADD CONSTRAINT task_table_creator_contact_id_fkey FOREIGN KEY (creator_contact_id) REFERENCES contact_table(contact_id);
--
--- Name: todo_table_record_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
+-- Name: task_table_record_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--
-ALTER TABLE ONLY todo_table
- ADD CONSTRAINT todo_table_record_id_fkey FOREIGN KEY (record_id) REFERENCES record_table(record_id);
+ALTER TABLE ONLY task_table
+ ADD CONSTRAINT task_table_record_id_fkey FOREIGN KEY (record_id) REFERENCES record_table(record_id);
--
--- Name: todo_table_status_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
+-- Name: task_table_status_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--
-ALTER TABLE ONLY todo_table
- ADD CONSTRAINT todo_table_status_id_fkey FOREIGN KEY (status_id) REFERENCES status_table(status_id);
+ALTER TABLE ONLY task_table
+ ADD CONSTRAINT task_table_status_id_fkey FOREIGN KEY (status_id) REFERENCES status_table(status_id);
--
Modified: trunk/1.2/docs/sql/setup/02__tables.sql
===================================================================
--- trunk/1.2/docs/sql/setup/02__tables.sql 2008-04-09 02:59:06 UTC (rev 871)
+++ trunk/1.2/docs/sql/setup/02__tables.sql 2008-04-09 03:06:56 UTC (rev 872)
@@ -289,7 +289,7 @@
log_estimate_id integer NOT NULL,
creation timestamp with time zone DEFAULT now() NOT NULL,
uid integer NOT NULL,
- todo_id integer NOT NULL,
+ task_id integer NOT NULL,
add_elapsed numeric(10,2) NOT NULL,
system_note text
);
@@ -753,12 +753,12 @@
--
--- Name: todo_comment_table; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
+-- Name: task_comment_table; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
-CREATE TABLE todo_comment_table (
- todo_comment_id integer NOT NULL,
- todo_id integer NOT NULL,
+CREATE TABLE task_comment_table (
+ task_comment_id integer NOT NULL,
+ task_id integer NOT NULL,
creator_contact_id integer NOT NULL,
created timestamp with time zone DEFAULT now() NOT NULL,
updated timestamp with time zone,
@@ -767,13 +767,13 @@
);
-ALTER TABLE public.todo_comment_table OWNER TO postgres;
+ALTER TABLE public.task_comment_table OWNER TO postgres;
--
--- Name: todo_comment_table_todo_comment_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
+-- Name: task_comment_table_task_comment_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
-CREATE SEQUENCE todo_comment_table_todo_comment_id_seq
+CREATE SEQUENCE task_comment_table_task_comment_id_seq
START WITH 1
INCREMENT BY 1
NO MAXVALUE
@@ -781,21 +781,21 @@
CACHE 1;
-ALTER TABLE public.todo_comment_table_todo_comment_id_seq OWNER TO postgres;
+ALTER TABLE public.task_comment_table_task_comment_id_seq OWNER TO postgres;
--
--- Name: todo_comment_table_todo_comment_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
+-- Name: task_comment_table_task_comment_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
-ALTER SEQUENCE todo_comment_table_todo_comment_id_seq OWNED BY todo_comment_table.todo_comment_id;
+ALTER SEQUENCE task_comment_table_task_comment_id_seq OWNED BY task_comment_table.task_comment_id;
--
--- Name: todo_table; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
+-- Name: task_table; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
--
-CREATE TABLE todo_table (
- todo_id integer NOT NULL,
+CREATE TABLE task_table (
+ task_id integer NOT NULL,
creator_contact_id integer NOT NULL,
name text NOT NULL,
body text NOT NULL,
@@ -814,13 +814,13 @@
);
-ALTER TABLE public.todo_table OWNER TO postgres;
+ALTER TABLE public.task_table OWNER TO postgres;
--
--- Name: todo_table_todo_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
+-- Name: task_table_task_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--
-CREATE SEQUENCE todo_table_todo_id_seq
+CREATE SEQUENCE task_table_task_id_seq
START WITH 1
INCREMENT BY 1
NO MAXVALUE
@@ -828,13 +828,13 @@
CACHE 1;
-ALTER TABLE public.todo_table_todo_id_seq OWNER TO postgres;
+ALTER TABLE public.task_table_task_id_seq OWNER TO postgres;
--
--- Name: todo_table_todo_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
+-- Name: task_table_task_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--
-ALTER SEQUENCE todo_table_todo_id_seq OWNED BY todo_table.todo_id;
+ALTER SEQUENCE task_table_task_id_seq OWNED BY task_table.task_id;
--
Modified: trunk/1.2/docs/sql/setup/03__indexes_etc.sql
===================================================================
--- trunk/1.2/docs/sql/setup/03__indexes_etc.sql 2008-04-09 02:59:06 UTC (rev 871)
+++ trunk/1.2/docs/sql/setup/03__indexes_etc.sql 2008-04-09 03:06:56 UTC (rev 872)
@@ -153,17 +153,17 @@
--
--- Name: todo_comment_id; Type: DEFAULT; Schema: public; Owner: postgres
+-- Name: task_comment_id; Type: DEFAULT; Schema: public; Owner: postgres
--
-ALTER TABLE todo_comment_table ALTER COLUMN todo_comment_id SET DEFAULT nextval('todo_comment_table_todo_comment_id_seq'::regclass);
+ALTER TABLE task_comment_table ALTER COLUMN task_comment_id SET DEFAULT nextval('task_comment_table_task_comment_id_seq'::regclass);
--
--- Name: todo_id; Type: DEFAULT; Schema: public; Owner: postgres
+-- Name: task_id; Type: DEFAULT; Schema: public; Owner: postgres
--
-ALTER TABLE todo_table ALTER COLUMN todo_id SET DEFAULT nextval('todo_table_todo_id_seq'::regclass);
+ALTER TABLE task_table ALTER COLUMN task_id SET DEFAULT nextval('task_table_task_id_seq'::regclass);
--
@@ -364,19 +364,19 @@
--
--- Name: todo_comment_table_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
+-- Name: task_comment_table_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--
-ALTER TABLE ONLY todo_comment_table
- ADD CONSTRAINT todo_comment_table_pkey PRIMARY KEY (todo_comment_id);
+ALTER TABLE ONLY task_comment_table
+ ADD CONSTRAINT task_comment_table_pkey PRIMARY KEY (task_comment_id);
--
--- Name: todo_table_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
+-- Name: task_table_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
--
-ALTER TABLE ONLY todo_table
- ADD CONSTRAINT todo_table_pkey PRIMARY KEY (todo_id);
+ALTER TABLE ONLY task_table
+ ADD CONSTRAINT task_table_pkey PRIMARY KEY (task_id);
--
@@ -486,11 +486,11 @@
--
--- Name: log_estiate_table_todo_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
+-- Name: log_estiate_table_task_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--
ALTER TABLE ONLY log_estimate_table
- ADD CONSTRAINT log_estiate_table_todo_id_fkey FOREIGN KEY (todo_id) REFERENCES todo_table(todo_id);
+ ADD CONSTRAINT log_estiate_table_task_id_fkey FOREIGN KEY (task_id) REFERENCES task_table(task_id);
--
@@ -638,51 +638,51 @@
--
--- Name: todo_comment_table_creator_contact_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
+-- Name: task_comment_table_creator_contact_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--
-ALTER TABLE ONLY todo_comment_table
- ADD CONSTRAINT todo_comment_table_creator_contact_id_fkey FOREIGN KEY (creator_contact_id) REFERENCES contact_table(contact_id);
+ALTER TABLE ONLY task_comment_table
+ ADD CONSTRAINT task_comment_table_creator_contact_id_fkey FOREIGN KEY (creator_contact_id) REFERENCES contact_table(contact_id);
--
--- Name: todo_comment_table_todo_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
+-- Name: task_comment_table_task_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--
-ALTER TABLE ONLY todo_comment_table
- ADD CONSTRAINT todo_comment_table_todo_id_fkey FOREIGN KEY (todo_id) REFERENCES todo_table(todo_id);
+ALTER TABLE ONLY task_comment_table
+ ADD CONSTRAINT task_comment_table_task_id_fkey FOREIGN KEY (task_id) REFERENCES task_table(task_id);
--
--- Name: todo_table_assigned_contact_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
+-- Name: task_table_assigned_contact_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--
-ALTER TABLE ONLY todo_table
- ADD CONSTRAINT todo_table_assigned_contact_id_fkey FOREIGN KEY (assigned_contact_id) REFERENCES contact_table(contact_id);
+ALTER TABLE ONLY task_table
+ ADD CONSTRAINT task_table_assigned_contact_id_fkey FOREIGN KEY (assigned_contact_id) REFERENCES contact_table(contact_id);
--
--- Name: todo_table_creator_contact_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
+-- Name: task_table_creator_contact_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--
-ALTER TABLE ONLY todo_table
- ADD CONSTRAINT todo_table_creator_contact_id_fkey FOREIGN KEY (creator_contact_id) REFERENCES contact_table(contact_id);
+ALTER TABLE ONLY task_table
+ ADD CONSTRAINT task_table_creator_contact_id_fkey FOREIGN KEY (creator_contact_id) REFERENCES contact_table(contact_id);
--
--- Name: todo_table_record_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
+-- Name: task_table_record_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--
-ALTER TABLE ONLY todo_table
- ADD CONSTRAINT todo_table_record_id_fkey FOREIGN KEY (record_id) REFERENCES record_table(record_id);
+ALTER TABLE ONLY task_table
+ ADD CONSTRAINT task_table_record_id_fkey FOREIGN KEY (record_id) REFERENCES record_table(record_id);
--
--- Name: todo_table_status_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
+-- Name: task_table_status_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--
-ALTER TABLE ONLY todo_table
- ADD CONSTRAINT todo_table_status_id_fkey FOREIGN KEY (status_id) REFERENCES status_table(status_id);
+ALTER TABLE ONLY task_table
+ ADD CONSTRAINT task_table_status_id_fkey FOREIGN KEY (status_id) REFERENCES status_table(status_id);
--
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
