Go to:
Gentoo Home
Documentation
Forums
Lists
Bugs
Planet
Store
Wiki
Get Gentoo!
Gentoo's Bugzilla – Attachment 77975 Details for
Bug 62197
Ebuild request for open-xchange
Home
|
New
–
[Ex]
|
Browse
|
Search
|
Privacy Policy
|
[?]
|
Reports
|
Requests
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
${FILESDIR}/ox_project.sql
ox_project.sql (text/plain), 6.48 KB, created by
Martin Nowack
on 2006-01-24 00:49:44 UTC
(
hide
)
Description:
${FILESDIR}/ox_project.sql
Filename:
MIME Type:
Creator:
Martin Nowack
Created:
2006-01-24 00:49:44 UTC
Size:
6.48 KB
patch
obsolete
>CREATE SEQUENCE "serial_id" start 9 increment 1 maxvalue 2147483647 minvalue 1 cache 1 cycle; >CREATE TABLE projects ( > "intfield01" integer, > "fuid" integer, > "creation_date" timestamp with time zone, > "created_from" text, > "changing_date" timestamp with time zone, > "changed_from" text, > "user_right" text, > "sid" text, > "tid" text, > "project_startdate" timestamp with time zone, > "project_enddate" timestamp with time zone, > "project_deadline" timestamp with time zone, > "project_reminder" timestamp with time zone, > "project_budget" text, > "project_effort" text, > "project_effort_unit" text, > "project_currency" text, > "project_type" text, > "project_kickoff" timestamp with time zone, > "project_description" text, > "project_goal" text, > "project_customer" text, > "project_name" text, > "project_status" text, > "project_phase" text, > "project_number_of_attachments" integer, > "project_task_folder_id" integer, > "project_manage_permissions" integer, > primary key (intfield01) >); > >CREATE TABLE backup_projects ( > "intfield01" integer, > "fuid" integer, > "creation_date" timestamp with time zone, > "created_from" text, > "changing_date" timestamp with time zone, > "changed_from" text, > "user_right" text, > "sid" text, > "tid" text, > "project_startdate" timestamp with time zone, > "project_enddate" timestamp with time zone, > "project_deadline" timestamp with time zone, > "project_reminder" timestamp with time zone, > "project_budget" text, > "project_effort" text, > "project_effort_unit" text, > "project_currency" text, > "project_type" text, > "project_kickoff" timestamp with time zone, > "project_description" text, > "project_goal" text, > "project_customer" text, > "project_name" text, > "project_status" text, > "project_phase" text, > "project_number_of_attachments" integer, > "project_task_folder_id" integer, > "project_manage_permissions" integer, > primary key (intfield01) >); > >CREATE TABLE projects_participants ( > "intfield01" integer, > "id" text, > "name" text, > "role" integer, > "ptype" integer, > "group_id" text, > "merged_permission" integer, > primary key (intfield01, id, group_id), > foreign key (intfield01) references projects on delete cascade on update cascade >); > >CREATE TABLE backup_projects_participants ( > "intfield01" integer, > "id" text, > "name" text, > "role" integer, > "ptype" integer, > "group_id" text, > "merged_permission" integer, > primary key (intfield01, id, group_id), > foreign key (intfield01) references backup_projects on delete cascade on update cascade >); > >CREATE TABLE projects_milestones ( > "intfield01" integer, > "id" integer, > "name" text, > "description" text, > "mdate" timestamp with time zone, > primary key (intfield01, id), > foreign key (intfield01) references projects on delete cascade on update cascade >); > >CREATE TABLE backup_projects_milestones ( > "intfield01" integer, > "id" integer, > "name" text, > "description" text, > "mdate" timestamp with time zone, > primary key (intfield01, id), > foreign key (intfield01) references backup_projects on delete cascade on update cascade >); > >CREATE TABLE projects_notes ( > "intfield01" integer, > "note_id" text, > "member_id" text, > primary key (intfield01, note_id), > foreign key (intfield01) references projects on delete cascade on update cascade >); > >CREATE TABLE backup_projects_notes ( > "intfield01" integer, > "note_id" text, > "member_id" text, > primary key (intfield01, note_id), > foreign key (intfield01) references backup_projects on delete cascade on update cascade >); > >CREATE TABLE projects_tasks ( > "intfield01" integer, > "task_id" integer, > primary key (intfield01, task_id), > foreign key (intfield01) references projects on delete cascade on update cascade >); > >CREATE TABLE backup_projects_tasks ( > "intfield01" integer, > "task_id" integer, > primary key (intfield01, task_id), > foreign key (intfield01) references backup_projects on delete cascade on update cascade >); > >CREATE TABLE projects_dependencies ( > "intfield01" integer, > "id" integer, > "successor" text, > "dependency_type" integer, > "object_type" integer, > primary key (intfield01, id), > foreign key (intfield01) references projects on delete cascade on update cascade >); > >CREATE TABLE backup_projects_dependencies ( > "intfield01" integer, > "id" integer, > "successor" text, > "dependency_type" integer, > "object_type" integer, > primary key (intfield01, id), > foreign key (intfield01) references backup_projects on delete cascade on update cascade >); > >CREATE TABLE projects_antecessors ( > "intfield01" integer, > "id" integer, > "antecessor" text, > "object_type" integer, > primary key (intfield01, id, antecessor), > foreign key (intfield01, id) references projects_dependencies on delete cascade on update cascade >); > >CREATE TABLE backup_projects_antecessors ( > "intfield01" integer, > "id" integer, > "antecessor" text, > "object_type" integer, > primary key (intfield01, id, antecessor), > foreign key (intfield01, id) references backup_projects_dependencies on delete cascade on update cascade >); > >CREATE TABLE projects_puids ( > "intfield01" integer, > "puid" integer, > "entity" text, > "fuid" integer, > primary key (intfield01, puid), > foreign key (intfield01) references projects on delete cascade on update cascade >); > >CREATE TABLE backup_projects_puids ( > "intfield01" integer, > "puid" integer, > "entity" text, > "fuid" integer, > primary key (intfield01, puid), > foreign key (intfield01) references backup_projects on delete cascade on update cascade >); > >CREATE table "oxfolder_userfolders" ( > "module_name" text, > "linksite" text, > "target" text, > "img" text >); > > >CREATE TABLE "ical_principal" ( > "object_id" int, > "principal" text, > "calendarfolder" int, > "taskfolder" int >); > >CREATE TABLE "ical_ids" ( > "object_id" int, > "principal_id" int, > "client_id" text, > "target_object_id" int, > "module" int >); > >CREATE TABLE "vcard_principal" ( > "object_id" int, > "principal" text, > "contactfolder" int >); > >CREATE TABLE "vcard_ids" ( > "object_id" int, > "principal_id" int, > "client_id" text, > "target_object_id" int >); > >INSERT INTO oxfolder_tree VALUES (7, 0, 'user', 'system', 'system','system', 'system', 'now', 'System', null, null); >INSERT INTO oxfolder_tree VALUES (8, 7, 'projects', 'projects', 'system','system', 'system', 'now', 'System', null, null); >INSERT INTO oxfolder_permissions VALUES ((select nextval('serial_id')), 7, 512, 'all_ox_users_and_ox_groups', 0, 2, 0, 0, 0); >INSERT INTO oxfolder_permissions VALUES ((select nextval('serial_id')), 8, 512, 'all_ox_users_and_ox_groups', 0, 8, 4, 2, 2); >INSERT INTO oxfolder_specialfolders VALUES ('user', 7); > >INSERT INTO oxfolder_userfolders VALUES ('projects', 'projects/projects_list_all', null, 'folder/item_projects.png');
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Raw
Actions:
View
Attachments on
bug 62197
:
38529
|
38692
|
38693
|
38705
|
38708
|
38710
|
38778
|
38779
|
38793
|
38831
|
38832
|
38907
|
38908
|
38909
|
38910
|
38911
|
38912
|
38950
|
39161
|
39638
|
40395
|
40677
|
43006
|
45598
|
51564
|
52969
|
57322
|
58355
|
58364
|
58367
|
59319
|
59327
|
61190
|
61191
|
61270
|
62568
|
66393
|
66394
|
66402
|
66592
|
66692
|
66817
|
66818
|
66890
|
66902
|
67034
|
67087
|
67399
|
67511
|
67595
|
67907
|
68648
|
68650
|
68695
|
68701
|
68702
|
68705
|
68706
|
68895
|
68946
|
68947
|
68959
|
68960
|
68961
|
68968
|
68973
|
68981
|
68991
|
68993
|
68994
|
69097
|
69101
|
69139
|
69140
|
69179
|
69205
|
70998
|
72090
|
72748
|
77974
|
77975
|
79765
|
79766
|
79767
|
79851
|
79943
|
79944
|
80431
|
80432
|
83756
|
83946
|
85610
|
87053
|
87995
|
87996
|
87997
|
87998
|
90889
|
94269
|
100851
|
100852
|
105319