[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] tts/setup default_records.inc.php phpgw_ca.lang...
|
From: |
Dave Hall |
|
Subject: |
[Phpgroupware-cvs] tts/setup default_records.inc.php phpgw_ca.lang... |
|
Date: |
Tue, 24 Oct 2006 00:50:09 +0000 |
CVSROOT: /cvsroot/phpgroupware
Module name: tts
Changes by: Dave Hall <skwashd> 06/10/24 00:50:09
Modified files:
setup : default_records.inc.php phpgw_ca.lang
phpgw_cs.lang phpgw_da.lang phpgw_de.lang
phpgw_fi.lang phpgw_fr.lang phpgw_it.lang
phpgw_pl.lang phpgw_pt.lang phpgw_tr.lang
setup.inc.php tables_baseline.inc.php
tables_current.inc.php tables_update.inc.php
Log message:
start to fix this mess, this should have gone to HEAD in the first place
CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/tts/setup/default_records.inc.php?cvsroot=phpgroupware&r1=1.5&r2=1.6
http://cvs.savannah.gnu.org/viewcvs/tts/setup/phpgw_ca.lang?cvsroot=phpgroupware&r1=1.3&r2=1.4
http://cvs.savannah.gnu.org/viewcvs/tts/setup/phpgw_cs.lang?cvsroot=phpgroupware&r1=1.2&r2=1.3
http://cvs.savannah.gnu.org/viewcvs/tts/setup/phpgw_da.lang?cvsroot=phpgroupware&r1=1.5&r2=1.6
http://cvs.savannah.gnu.org/viewcvs/tts/setup/phpgw_de.lang?cvsroot=phpgroupware&r1=1.8&r2=1.9
http://cvs.savannah.gnu.org/viewcvs/tts/setup/phpgw_fi.lang?cvsroot=phpgroupware&r1=1.3&r2=1.4
http://cvs.savannah.gnu.org/viewcvs/tts/setup/phpgw_fr.lang?cvsroot=phpgroupware&r1=1.9&r2=1.10
http://cvs.savannah.gnu.org/viewcvs/tts/setup/phpgw_it.lang?cvsroot=phpgroupware&r1=1.7&r2=1.8
http://cvs.savannah.gnu.org/viewcvs/tts/setup/phpgw_pl.lang?cvsroot=phpgroupware&r1=1.3&r2=1.4
http://cvs.savannah.gnu.org/viewcvs/tts/setup/phpgw_pt.lang?cvsroot=phpgroupware&r1=1.4&r2=1.5
http://cvs.savannah.gnu.org/viewcvs/tts/setup/phpgw_tr.lang?cvsroot=phpgroupware&r1=1.3&r2=1.4
http://cvs.savannah.gnu.org/viewcvs/tts/setup/setup.inc.php?cvsroot=phpgroupware&r1=1.13&r2=1.14
http://cvs.savannah.gnu.org/viewcvs/tts/setup/tables_baseline.inc.php?cvsroot=phpgroupware&r1=1.2&r2=1.3
http://cvs.savannah.gnu.org/viewcvs/tts/setup/tables_current.inc.php?cvsroot=phpgroupware&r1=1.10&r2=1.11
http://cvs.savannah.gnu.org/viewcvs/tts/setup/tables_update.inc.php?cvsroot=phpgroupware&r1=1.4&r2=1.5
Patches:
Index: default_records.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/tts/setup/default_records.inc.php,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -b -r1.5 -r1.6
--- default_records.inc.php 19 May 2005 09:53:38 -0000 1.5
+++ default_records.inc.php 24 Oct 2006 00:50:09 -0000 1.6
@@ -6,72 +6,7 @@
* @license http://www.gnu.org/licenses/gpl.html GNU General Public
License
* @package tts
* @subpackage setup
- * @version $Id: default_records.inc.php,v 1.5 2005/05/19 09:53:38
fipsfuchs Exp $
+ * @version $Id: default_records.inc.php,v 1.6 2006/10/24 00:50:09
skwashd Exp $
*/
- $exist_cat_names = array();
- $GLOBALS['phpgw_setup']->oProc->query("SELECT cat_name from
phpgw_categories where cat_appname='tts'",__LINE__,__FILE__);
- while($GLOBALS['phpgw_setup']->oProc->next_record())
- {
- $exist_cat_names[] =
$GLOBALS['phpgw_setup']->oProc->f('cat_name');
- }
- if(!in_array('Platform', $exist_cat_names))
- {
- $GLOBALS['phpgw_setup']->oProc->query('INSERT into
phpgw_categories
(cat_main,cat_parent,cat_level,cat_owner,cat_access,cat_appname,cat_name,cat_description,cat_data)'
-
. " values(0,0,0,-1,'public','tts','Platform','Global category for
tts','platform')",__LINE__,__FILE__);
- }
-
- $GLOBALS['phpgw_setup']->oProc->query("SELECT cat_id from
phpgw_categories where cat_name='Platform' and cat_owner=-1 and
cat_appname='tts'",__LINE__,__FILE__);
- if($GLOBALS['phpgw_setup']->oProc->next_record())
- {
- $main = $GLOBALS['phpgw_setup']->oProc->f('cat_id');
- }
- $main = intval($main);
-
- $GLOBALS['phpgw_setup']->oProc->query('UPDATE phpgw_categories set
cat_main=' . $main . ' where cat_id=' . $main,__LINE__,__FILE__);
-
- if(!in_array('Linux', $exist_cat_names))
- {
- $GLOBALS['phpgw_setup']->oProc->query('INSERT into
phpgw_categories
(cat_main,cat_parent,cat_level,cat_owner,cat_access,cat_appname,cat_name,cat_description,cat_data)'
-
. ' values('. $main . ',' . $main .
",1,-1,'public','tts','Linux','Global category for
tts','platform')",__LINE__,__FILE__);
- }
-
- if(!in_array('Windows', $exist_cat_names))
- {
- $GLOBALS['phpgw_setup']->oProc->query('INSERT into
phpgw_categories
(cat_main,cat_parent,cat_level,cat_owner,cat_access,cat_appname,cat_name,cat_description,cat_data)'
-
. ' values('. $main . ',' . $main .
",1,-1,'public','tts','Windows','Global category for
tts','platform')",__LINE__,__FILE__);
- }
-
- if(!in_array('MacOS', $exist_cat_names))
- {
- $GLOBALS['phpgw_setup']->oProc->query('INSERT into
phpgw_categories
(cat_main,cat_parent,cat_level,cat_owner,cat_access,cat_appname,cat_name,cat_description,cat_data)'
-
. ' values('. $main . ',' . $main .
",1,-1,'public','tts','MacOS','Global category for
tts','platform')",__LINE__,__FILE__);
- }
-
- if(!in_array('Type', $exist_cat_names))
- {
- $GLOBALS['phpgw_setup']->oProc->query('INSERT into
phpgw_categories
(cat_main,cat_parent,cat_level,cat_owner,cat_access,cat_appname,cat_name,cat_description,cat_data)'
-
. " values(0,0,0,-1,'public','tts','Type','Global category for
tts','type')",__LINE__,__FILE__);
- }
-
- $GLOBALS['phpgw_setup']->oProc->query("SELECT cat_id from
phpgw_categories where cat_name='Type' and cat_owner=-1 and
cat_appname='tts'",__LINE__,__FILE__);
- if($GLOBALS['phpgw_setup']->oProc->next_record())
- {
- $main = $GLOBALS['phpgw_setup']->oProc->f('cat_id');
- }
- $main = intval($main);
-
- $GLOBALS['phpgw_setup']->oProc->query('UPDATE phpgw_categories set
cat_main=' . $main . ' where cat_id=' . $main,__LINE__,__FILE__);
-
- if(!in_array('Bug', $exist_cat_names))
- {
- $GLOBALS['phpgw_setup']->oProc->query('INSERT into
phpgw_categories
(cat_main,cat_parent,cat_level,cat_owner,cat_access,cat_appname,cat_name,cat_description,cat_data)'
-
. ' values('. $main . ',' . $main . ",1,-1,'public','tts','Bug','Global
category for tts','type')",__LINE__,__FILE__);
- }
-
- if(!in_array('Feature Request', $exist_cat_names))
- {
- $GLOBALS['phpgw_setup']->oProc->query('INSERT into
phpgw_categories
(cat_main,cat_parent,cat_level,cat_owner,cat_access,cat_appname,cat_name,cat_description,cat_data)'
-
. ' values('. $main . ',' . $main . ",1,-1,'public','tts','Feature
Request','Global category for tts','type')",__LINE__,__FILE__);
- }
Index: phpgw_ca.lang
===================================================================
RCS file: /cvsroot/phpgroupware/tts/setup/phpgw_ca.lang,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -b -r1.3 -r1.4
--- phpgw_ca.lang 22 Feb 2006 06:17:45 -0000 1.3
+++ phpgw_ca.lang 24 Oct 2006 00:50:09 -0000 1.4
@@ -1,8 +1,8 @@
-action tts ca Acció
+action tts ca Acció
add new ticket tts ca Afegir nou tiquet
add ticket tts ca Afegir tiquet
additional notes tts ca Notes adicionals
-admin options admin ca Opcions d'administració
+admin options admin ca Opcions d'administració
assign to tts ca Assignar a
assigned from tts ca Assignat per
assigned to tts ca Assignat a
@@ -14,22 +14,22 @@
billable hours rate tts ca Tasa d'hores computables
billable rate tts ca Tasa computable
billable rate changed tts ca Tasa computable canviada
-category changed tts ca CategorÃa canviada
+category changed tts ca Categoría canviada
clear form tts ca Netejar Formulari
closed tts ca Tancat
create new ticket tts ca Crear nou tiquet
creates a new ticket, returns ticket_id tts ca Crear un nou
tiquet, retorna ticket_id
creates a struct of tickets tts ca Crear una estructura de tiquets
date opened tts ca Data d'alta
-deadline tts ca Data lÃmit
-deadline changed tts ca Data lÃmit canviada
+deadline tts ca Data límit
+deadline changed tts ca Data límit canviada
detail tts ca Destall
-effort tts ca Esforç
-effort changed tts ca Esforç canviat
-force tts ca Forçar
-group ownership changed tts ca Pertanyença a grups canviada
-in progress tts ca En Progrès
-latest note added tts ca Ãltima Nota Afegida
+effort tts ca Esforç
+effort changed tts ca Esforç canviat
+force tts ca Forçar
+group ownership changed tts ca Pertanyença a grups canviada
+in progress tts ca En Progrès
+latest note added tts ca Última Nota Afegida
new ticket tts ca Nou Tiquet
new value tts ca Nou Valor
no additional notes tts ca Sense notes adicionals
@@ -49,7 +49,7 @@
priority changed tts ca Prioritat canviada
re-assigned tts ca Reassignat
re-opened tts ca Re-obert
-returns a struct of a tickets history tts ca Retorna una estructura
d'història de tiquets
+returns a struct of a tickets history tts ca Retorna una estructura
d'història de tiquets
returns a struct of values of a single ticket tts ca Retorna una
estructura de valors d'un tiquet
returns the additional notes attached to a ticket tts ca Retorna
les notes addicionals assignades a un ticket
status/date closed tts ca Estat/Data tancat
@@ -60,15 +60,15 @@
tickets found %1 tts ca Tiquets trobats %1
tickets open %1 tts ca Tiquets oberts %1
tickets total %1 tts ca Total de tiquets %1
-to go back to the tts index, click <a href= %1 >here</a> tts ca
Tornar a l'Ãndex, click <a href="%1">aqui</a>
+to go back to the tts index, click <a href= %1 >here</a> tts ca
Tornar a l'índex, click <a href="%1">aqui</a>
total billable tts ca Total computable
-trouble ticket system common ca Sistema de Tiquets d'Incidències
-tts common ca Sistema de Tiquets d'Incidències
-tts preferences tts ca Sistema de Tiquets d'Incidències -
preferències
+trouble ticket system common ca Sistema de Tiquets d'Incidències
+tts common ca Sistema de Tiquets d'Incidències
+tts preferences tts ca Sistema de Tiquets d'Incidències -
preferències
type tts ca Tipus
type changed tts ca Tipus canviat
updates ticket tts ca Actualitza tiquet
-use email notification tts ca Utilitzar notificació per email
+use email notification tts ca Utilitzar notificació per email
view all tickets tts ca Veure tots els tiquets
view job detail tts ca Veure detall del treball
-view only open tickets tts ca Veure només tiquets oberts
+view only open tickets tts ca Veure només tiquets oberts
Index: phpgw_cs.lang
===================================================================
RCS file: /cvsroot/phpgroupware/tts/setup/phpgw_cs.lang,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -b -r1.2 -r1.3
--- phpgw_cs.lang 22 Feb 2006 06:19:42 -0000 1.2
+++ phpgw_cs.lang 24 Oct 2006 00:50:09 -0000 1.3
@@ -1 +1 @@
-trouble ticket system common cs Sledovánà problémů
+trouble ticket system common cs Sledování problémù
Index: phpgw_da.lang
===================================================================
RCS file: /cvsroot/phpgroupware/tts/setup/phpgw_da.lang,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -b -r1.5 -r1.6
--- phpgw_da.lang 22 Feb 2006 06:20:33 -0000 1.5
+++ phpgw_da.lang 24 Oct 2006 00:50:09 -0000 1.6
@@ -1,5 +1,5 @@
-add new ticket tts da Tilføj ny billet
-add ticket tts da Tilføj billet
+add new ticket tts da Tilføj ny billet
+add ticket tts da Tilføj billet
additional notes tts da Yderligere noter
assign to tts da Anvis til
assigned from tts da Anvist fra
@@ -8,26 +8,26 @@
close tts da Luk
close date tts da Luk dato
closed tts da Lukket
-date opened tts da Dato åbnet
+date opened tts da Dato åbnet
detail tts da Detalje
details tts da Detaljer
group tts da Gruppe
-in progress tts da Under udførsel
+in progress tts da Under udførsel
new ticket tts da Ny billet
no subject tts da Intet emne
no tickets found tts da Ingen billetter fundet
ok tts da OK
-open date tts da Dato åben
-opened by tts da Ã
bnet af
+open date tts da Dato åben
+opened by tts da Åbnet af
prio tts da Prio
priority tts da Prioritet
-reopen tts da Ã
ben igen
+reopen tts da Åben igen
status/date closed tts da Status/Dato lukket
subject tts da Emne
ticket tts da Melding
Ticket assigned to %1 tts da Melding tilegnet til %1
trouble ticket system common da Problem registrerings system
-update tts da Opdatér
+update tts da Opdatér
view all tickets tts da Se alle meldinger
view job detail tts da Se opgave detaljer
-view only open tickets tts da Se alle åbenstående meldinger
+view only open tickets tts da Se alle åbenstående meldinger
Index: phpgw_de.lang
===================================================================
RCS file: /cvsroot/phpgroupware/tts/setup/phpgw_de.lang,v
retrieving revision 1.8
retrieving revision 1.9
diff -u -b -r1.8 -r1.9
--- phpgw_de.lang 22 Feb 2006 06:10:02 -0000 1.8
+++ phpgw_de.lang 24 Oct 2006 00:50:09 -0000 1.9
@@ -1,6 +1,6 @@
-add new ticket tts de Neues Ticket hinzufügen
-add ticket tts de Ticket hinzufügen
-additional notes tts de Zusätzliche Anmerkungen
+add new ticket tts de Neues Ticket hinzufügen
+add ticket tts de Ticket hinzufügen
+additional notes tts de Zusätzliche Anmerkungen
admin options admin de Admin Optionen
assign to tts de zuweisen an
assigned from tts de Zugewiesen von
@@ -9,13 +9,13 @@
billable hours tts de Abrechenbare Stunden
billable hours rate tts de Abrechenbarer Stundensatz
Billable rate tts de Abrechenbarer Betrag
-close tts de SchlieÃen
+close tts de Schließen
Closed tts de Geschlossen
close date tts de Geschlossen am
date opened tts de Angelegt am
-Default assign to tts de Standardmässig zuweisen an
+Default assign to tts de Standardmässig zuweisen an
Default group tts de Standard Gruppe
-Default Priority tts de Standard Priorität
+Default Priority tts de Standard Priorität
create new ticket tts de Neues Ticket anlegen
deadline tts de Abgabetermin
Default assign to tts de Standard Zugewiesen an
@@ -23,19 +23,19 @@
details tts de Details
effort tts de Leistung
force tts de erzwungen
-Group ownership changed tts de Gruppen Eigentümer geändert
+Group ownership changed tts de Gruppen Eigentümer geändert
in progress tts de in Bearbeitung
new ticket tts de Neues Ticket
-No additional notes tts de Keine zusätzlichen Notizen gefunden
+No additional notes tts de Keine zusätzlichen Notizen gefunden
no tickets found tts de Keine Tickets gefunden
Open tts de Offen
open date tts de Angelegt am
-Opened tts de Geöffnet
+Opened tts de Geöffnet
opened by tts de Angelegt von
platform tts de Plattform
-Platform changed tts de Plattform geändert
+Platform changed tts de Plattform geändert
prio tts de Prio
-Priority changed tts de Priorität geändert
+Priority changed tts de Priorität geändert
Refresh every (seconds) tts de Aktualisieren jede (Sekunden)
Re-assigned tts de neu zuweisen
show new/updated tickets on main screen tts de Zeige
neue/aktualisierte Tickets auf dem Hauptschirm
@@ -43,7 +43,7 @@
ticket tts de Ticket
Tickets found tts de Tickets gefunden
tickets found %1 tts de %1 Tickets gefunden
-Ticket has been updated tts de Ticket wurde geändert
+Ticket has been updated tts de Ticket wurde geändert
tickets open %1 tts de offene tickets: %1
tickets total %1 tts de Tickets insgesamt: %1
Total billable tts de Gesammt abgerechnet
@@ -51,7 +51,7 @@
tts common de TTS
tts preferences tts de Trouble Ticket System - Einstellungen
type tts de Typ
-Type changed tts de Typ geändert
+Type changed tts de Typ geändert
Use email notification tts de Benutze e-Mail Benachrichtigung
view all tickets tts de Alle Tickets anzeigen
view job detail tts de Detailansicht
Index: phpgw_fi.lang
===================================================================
RCS file: /cvsroot/phpgroupware/tts/setup/phpgw_fi.lang,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -b -r1.3 -r1.4
--- phpgw_fi.lang 22 Feb 2006 06:28:01 -0000 1.3
+++ phpgw_fi.lang 24 Oct 2006 00:50:09 -0000 1.4
@@ -1,42 +1,42 @@
-add new ticket tts fi Lisää uusi tapaus
-add ticket tts fi Lisää tapaus
-additional notes tts fi Lisätietoja
-admin options admin fi Ylläpito
-assign to tts fi Aseta käsittelijäksi
-assigned from tts fi Edellinen käsittelijä
-assigned to tts fi Käsittelijä
+add new ticket tts fi Lisää uusi tapaus
+add ticket tts fi Lisää tapaus
+additional notes tts fi Lisätietoja
+admin options admin fi Ylläpito
+assign to tts fi Aseta käsittelijäksi
+assigned from tts fi Edellinen käsittelijä
+assigned to tts fi Käsittelijä
billable hours tts fi Laskutettavat tunnit
billable hours changed tts fi Laskutettavat tunnit muutettu
billable hours rate tts fi Tuntihinta
billable rate tts fi Hinta
billable rate changed tts fi Tuntihinta muutettu
category changed tts fi Luokka muutettu
-clear form tts fi Tyhjennä lomake
+clear form tts fi Tyhjennä lomake
closed tts fi Suljettu
create new ticket tts fi Luo uusi tapaus
creates a new ticket, returns ticket_id tts fi Luo uuden
tapauksen ja palauttaa ticket_id:n
-creates a struct of tickets tts fi Luo ryhmän tapauksia
-date opened tts fi Avauspäivä
+creates a struct of tickets tts fi Luo ryhmän tapauksia
+date opened tts fi Avauspäivä
detail tts fi Yksityiskohdat
-in progress tts fi Käsittelyssä
+in progress tts fi Käsittelyssä
new ticket tts fi Uusi tapaus
new value tts fi Uusi arvo
no tickets found tts fi Ei tapauksia.
-open date tts fi Avauspäivä
+open date tts fi Avauspäivä
opened by tts fi Avaaja
-prio tts fi Tärk
-priority tts fi Tärkeys
-priority changed tts fi Tärkeys muutettu
-status/date closed tts fi Tärkeys/Sulkemispäivä
+prio tts fi Tärk
+priority tts fi Tärkeys
+priority changed tts fi Tärkeys muutettu
+status/date closed tts fi Tärkeys/Sulkemispäivä
subject changed tts fi Aihe muutettu
ticket tts fi Tapaus
-ticket has been updated tts fi Tapaus päivitetty
+ticket has been updated tts fi Tapaus päivitetty
tickets open %1 tts fi Avoimia tapauksia %1
-tickets total %1 tts fi Tapauksia yhteensä %1
-trouble ticket system common fi Ongelmatapaus -järjestelmä
-tts common fi Ongelmatapaus -järjestelmä
-tts preferences tts fi Ongelmatapaus -järjestelmä - asetukset
-use email notification tts fi Lähetä huomautukset sähköpostilla
-view all tickets tts fi Näytä kaikki
-view job detail tts fi Näytä työn yksityiskohdat
-view only open tickets tts fi Näytä vain avoimet
+tickets total %1 tts fi Tapauksia yhteensä %1
+trouble ticket system common fi Ongelmatapaus -järjestelmä
+tts common fi Ongelmatapaus -järjestelmä
+tts preferences tts fi Ongelmatapaus -järjestelmä - asetukset
+use email notification tts fi Lähetä huomautukset sähköpostilla
+view all tickets tts fi Näytä kaikki
+view job detail tts fi Näytä työn yksityiskohdat
+view only open tickets tts fi Näytä vain avoimet
Index: phpgw_fr.lang
===================================================================
RCS file: /cvsroot/phpgroupware/tts/setup/phpgw_fr.lang,v
retrieving revision 1.9
retrieving revision 1.10
diff -u -b -r1.9 -r1.10
--- phpgw_fr.lang 22 Feb 2006 06:08:23 -0000 1.9
+++ phpgw_fr.lang 24 Oct 2006 00:50:09 -0000 1.10
@@ -3,71 +3,71 @@
add ticket tts fr Ajouter un ticket
additional notes tts fr Notes additionelles
admin options admin fr Options d'admin
-assign to tts fr Assigner Ã
-assigned from tts fr Assigné depuis
-assigned to tts fr Assigné Ã
+assign to tts fr Assigner à
+assigned from tts fr Assigné depuis
+assigned to tts fr Assigné à
attachment tts fr Attachement
-attachment changed tts fr Attachement changé
+attachment changed tts fr Attachement changé
billable hours tts fr Heures facturables
-billable hours changed tts fr Heures facturables changées
+billable hours changed tts fr Heures facturables changées
billable hours rate tts fr Taux d'heures facturables
billable rate tts fr Taux facturable
-billable rate changed tts fr Taux facturable changé
-category changed tts fr Catégorie changée
-clear form tts fr Réinitialiser le formulaire
-closed tts fr Fermé
-create new ticket tts fr Créer un nouveau ticket
-creates a new ticket, returns ticket_id tts fr Crée un
nouveau ticket, retourne l'id du ticket
-creates a struct of tickets tts fr Crée une structure de tickets
+billable rate changed tts fr Taux facturable changé
+category changed tts fr Catégorie changée
+clear form tts fr Réinitialiser le formulaire
+closed tts fr Fermé
+create new ticket tts fr Créer un nouveau ticket
+creates a new ticket, returns ticket_id tts fr Crée un nouveau
ticket, retourne l'id du ticket
+creates a struct of tickets tts fr Crée une structure de tickets
date opened tts fr Date d'ouverture
deadline tts fr Date butoir
-deadline changed tts fr Date butoir changée
-detail tts fr Détail
+deadline changed tts fr Date butoir changée
+detail tts fr Détail
effort tts fr Effort
-effort changed tts fr Effort changé
+effort changed tts fr Effort changé
force tts fr Force
-group ownership changed tts fr Propriété du groupe changée
+group ownership changed tts fr Propriété du groupe changée
in progress tts fr En progression
-latest note added tts fr Dernière note ajoutée
+latest note added tts fr Dernière note ajoutée
new ticket tts fr Nouveau ticket
new value tts fr Nouvelle valeur
no additional notes tts fr Pas de notes additionnelles
no notes for this ticket tts fr Pas de notes pour ce ticket
-no tickets found tts fr Pas de ticket trouvé
-not assigned tts fr Non assigné
+no tickets found tts fr Pas de ticket trouvé
+not assigned tts fr Non assigné
old value tts fr Ancienne valeur
open tts fr Ouvrir
open date tts fr Date d'ouverture
opened tts fr Ouvert
opened by tts fr Ouvert par
-original ticket details tts fr Détails du ticket original
+original ticket details tts fr Détails du ticket original
platform tts fr Plate-forme
-platform changed tts fr Plate-forme changée
+platform changed tts fr Plate-forme changée
prio tts fr Prio
-priority tts fr Priorité
-priority changed tts fr Priorité changée
-re-assigned tts fr Réassigné
+priority tts fr Priorité
+priority changed tts fr Priorité changée
+re-assigned tts fr Réassigné
re-opened tts fr Rouvert
returns a struct of a tickets history tts fr Retourne une structure
d'historique des tickets
returns a struct of values of a single ticket tts fr Retourne une
structure de valeurs d'un seul ticket
-returns the additional notes attached to a ticket tts fr
Retourne les notes additionnelles attachées à un ticket
+returns the additional notes attached to a ticket tts fr
Retourne les notes additionnelles attachées à un ticket
status/date closed tts fr Statut/Date de fermeture
-subject changed tts fr Sujet changé
+subject changed tts fr Sujet changé
test tts fr TEST
ticket tts fr Ticket
-ticket has been updated tts fr Le ticket a été mis à jour
-tickets found %1 tts fr Tickets trouvés %1
+ticket has been updated tts fr Le ticket a été mis à jour
+tickets found %1 tts fr Tickets trouvés %1
tickets open %1 tts fr Tickets ouverts %1
tickets total %1 tts fr Tickets total %1
-to go back to the tts index, click <a href= %1 >here</a> tts fr
Pour retourner à l'index de tts, cliquez <a href="%1">ici</a>
+to go back to the tts index, click <a href= %1 >here</a> tts fr
Pour retourner à l'index de tts, cliquez <a href="%1">ici</a>
total billable tts fr Total facturable
-trouble ticket system common fr Système de tickets d'incidents
-tts common fr Système de tickets d'incidents
-tts preferences tts fr Système de tickets d'incidents -
préférences
+trouble ticket system common fr Système de tickets d'incidents
+tts common fr Système de tickets d'incidents
+tts preferences tts fr Système de tickets d'incidents -
préférences
type tts fr Type
-type changed tts fr Type changé
-updates ticket tts fr Met à jour le ticket
+type changed tts fr Type changé
+updates ticket tts fr Met à jour le ticket
use email notification tts fr Utiliser la notification par EMail
view all tickets tts fr Voir tous les tickets
-view job detail tts fr Voir le détail du travail
+view job detail tts fr Voir le détail du travail
view only open tickets tts fr Voir seulement les tickets ouverts
Index: phpgw_it.lang
===================================================================
RCS file: /cvsroot/phpgroupware/tts/setup/phpgw_it.lang,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -b -r1.7 -r1.8
--- phpgw_it.lang 22 Feb 2006 06:30:25 -0000 1.7
+++ phpgw_it.lang 24 Oct 2006 00:50:09 -0000 1.8
@@ -20,7 +20,7 @@
date opened tts it Data apertura
detail tts it Dettagli
details tts it Dettagli
-group ownership changed tts it Cambiato gruppo di proprietÃ
+group ownership changed tts it Cambiato gruppo di proprietà
in progress tts it In esecuzione
new ticket tts it Nuovo Ticket
new value tts it Nuovo Valore
@@ -32,13 +32,13 @@
opened tts it Aperto
opened by tts it Aperto da
prio tts it Prio
-priority tts it PrioritÃ
-priority changed tts it Priorità cambiata
+priority tts it Priorità
+priority changed tts it Priorità cambiata
status tts it Status
status/date closed tts it Status/Data chiusura
subject changed tts it Oggetto cambiato
ticket tts it Ticket
-ticket has been updated tts it Il ticket è stato aggiornato
+ticket has been updated tts it Il ticket è stato aggiornato
tickets open %1 tts it Ticket aperti %1
tickets total %1 tts it Ticket totali %1
total billable tts it Totale Fatturabile
Index: phpgw_pl.lang
===================================================================
RCS file: /cvsroot/phpgroupware/tts/setup/phpgw_pl.lang,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -b -r1.3 -r1.4
--- phpgw_pl.lang 22 Feb 2006 09:20:43 -0000 1.3
+++ phpgw_pl.lang 24 Oct 2006 00:50:09 -0000 1.4
@@ -4,39 +4,39 @@
additional notes tts pl Uwagi dodatkowe
admin options admin pl Opcje administratora
assign to tts pl Przypisz do
-assigned from tts pl WysÅane przez
+assigned from tts pl Wys³ane przez
assigned to tts pl Przypisane do
billable hours tts pl
billable hours changed tts pl
billable hours rate tts pl
billable rate tts pl
billable rate changed tts pl
-category changed tts pl Zmieniono kategoriÄ
-clear form tts pl WyczyÅÄ formularz
+category changed tts pl Zmieniono kategoriê
+clear form tts pl Wyczy¶æ formularz
close tts pl Zamknij
-close date tts pl Data zamkniÄcia
-closed tts pl ZamkniÄty
+close date tts pl Data zamkniêcia
+closed tts pl Zamkniêty
create new ticket tts pl Tworzenie nowego problemu
creates a new ticket, returns ticket_id tts pl
creates a struct of tickets tts pl
date opened tts pl Data otwarcia
-default assign to tts pl DomyÅlne przypisanie do osoby
-default group tts pl DomyÅlna grupa
-default priority tts pl DomyÅlny priorytet
-detail tts pl SzczegóÅy
-details tts pl SzczegóÅy
-force tts pl WymuÅ
+default assign to tts pl Domy¶lne przypisanie do osoby
+default group tts pl Domy¶lna grupa
+default priority tts pl Domy¶lny priorytet
+detail tts pl Szczegó³y
+details tts pl Szczegó³y
+force tts pl Wymu¶
group tts pl Grupa
-group ownership changed tts pl Zmieniono grupÄ
+group ownership changed tts pl Zmieniono grupê
in progress tts pl W opracowaniu
new ticket tts pl Nowy problem
-new value tts pl Nowa wartoÅÄ
+new value tts pl Nowa warto¶æ
no additional notes tts pl Ne ma dodatkowych uwag
no subject tts pl Bez tematu
-no tickets found tts pl Nie znaleziono problemów
+no tickets found tts pl Nie znaleziono problemów
not assigned tts pl Nie przypisane
ok tts pl OK
-old value tts pl Poprzednia wartoÅÄ
+old value tts pl Poprzednia warto¶æ
open tts pl Otwarty
open date tts pl Data otwarcia
opened tts pl Otwarty
@@ -46,24 +46,24 @@
priority changed tts pl Zmieniono priorytet
re-assigned tts pl
re-opened tts pl Ponownie otwarty
-refresh every (seconds) tts pl CzÄstoÅÄ odÅwieżania (s)
-reopen tts pl Otwórz ponownie
-select one tts pl Wybierz jednÄ
-show new/updated tickets on main screen tts pl WyÅwietlaÄ
nowe/zaktualizowane problemy na stronie gÅównej?
-status/date closed tts pl Status/Data zamkniÄcia
+refresh every (seconds) tts pl Czêsto¶æ od¶wie¿ania (s)
+reopen tts pl Otwórz ponownie
+select one tts pl Wybierz jedn±
+show new/updated tickets on main screen tts pl Wy¶wietlaæ
nowe/zaktualizowane problemy na stronie g³ównej?
+status/date closed tts pl Status/Data zamkniêcia
subject tts pl Temat
subject changed tts pl Zmieniono temat
ticket tts pl Problem
ticket assigned to %1 tts pl Problem przypisany do %1
-ticket has been updated tts pl Problem zostaÅ zaktualizowany
-tickets open %1 tts pl Otwartych problemów %1
-tickets total %1 tts pl Wszystkich problemów %1
+ticket has been updated tts pl Problem zosta³ zaktualizowany
+tickets open %1 tts pl Otwartych problemów %1
+tickets total %1 tts pl Wszystkich problemów %1
total billable tts pl
-trouble ticket system common pl System monitorowania problemów
-tts common pl System monitorowania problemów
-tts preferences tts pl Preferencje systemu monitorowania
problemów
+trouble ticket system common pl System monitorowania problemów
+tts common pl System monitorowania problemów
+tts preferences tts pl Preferencje systemu monitorowania
problemów
update tts pl Aktualizuj
use email notification tts pl Powiadamiaj via e-mail
-view all tickets tts pl Pokaż wszystkie
-view job detail tts pl Widok szczegóÅowy zadania
-view only open tickets tts pl Pokaż tylko otwarte
+view all tickets tts pl Poka¿ wszystkie
+view job detail tts pl Widok szczegó³owy zadania
+view only open tickets tts pl Poka¿ tylko otwarte
Index: phpgw_pt.lang
===================================================================
RCS file: /cvsroot/phpgroupware/tts/setup/phpgw_pt.lang,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -b -r1.4 -r1.5
--- phpgw_pt.lang 22 Feb 2006 09:21:54 -0000 1.4
+++ phpgw_pt.lang 24 Oct 2006 00:50:09 -0000 1.5
@@ -1,8 +1,8 @@
-action tts pt Ação
+action tts pt Ação
additional notes tts pt Notas adicionais
add new ticket tts pt Adicionar um novo ticket
add ticket tts pt Adicionar ticket
-admin options admin pt Opções de administração
+admin options admin pt Opções de administração
assigned from tts pt Designado de
assigned to tts pt Designado para
assign to tts pt Designar a
@@ -12,22 +12,22 @@
billable rate changed tts pt Valor da taxa alterado
billable rate tts pt Valor da taxa
category changed tts pt Categoria alterada
-clear form tts pt Limpar formulário
+clear form tts pt Limpar formulário
closed tts pt Fechado
create new ticket tts pt Criar novo ticket
-creates a new ticket, returns ticket_id tts pt Cria um novo,
retorna o número de identificação do ticket
+creates a new ticket, returns ticket_id tts pt Cria um novo,
retorna o número de identificação do ticket
creates a struct of tickets tts pt Cria uma estrutura de tickets
date opened tts pt Data da abertura
detail tts pt Detalhes
-force tts pt Forçar
+force tts pt Forçar
group ownership changed tts pt Grupo alterado
in progress tts pt Em progresso
-latest note added tts pt Ãltima nota adicionada
+latest note added tts pt Última nota adicionada
new ticket tts pt Novo ticket
new value tts pt Novo valor
no additional notes tts pt Nenhuma nota adicional
no notes for this ticket tts pt Nenhuma nota para este ticket
-not assigned tts pt Não designado
+not assigned tts pt Não designado
no tickets found tts pt Nenhum ticket encontrado
old value tts pt Antigo Valor
open date tts pt Data de abertura
@@ -46,12 +46,12 @@
tickets open %1 tts pt Tickets abertos %1
tickets total %1 tts pt Total de tickets %1
ticket tts pt Ticket
-to go back to the tts index, click <a href= %1 >here</a> tts pt
Para voltar para a página principal do TTS, clique <a href="%1">aqui</a>
+to go back to the tts index, click <a href= %1 >here</a> tts pt
Para voltar para a página principal do TTS, clique <a href="%1">aqui</a>
total billable tts pt Total a cobrar
trouble ticket system common pt Sistema de tickets de processos
tts common pt Sistema de tickets de processos
-tts preferences tts pt Sistema de tickets de processos -
preferências
-use email notification tts pt Usar notificação por email
+tts preferences tts pt Sistema de tickets de processos -
preferências
+use email notification tts pt Usar notificação por email
view all tickets tts pt Exibir todos tickets
view job detail tts pt Exibir detalhe da tarefa
view only open tickets tts pt Exibir somente tickets abertos
Index: phpgw_tr.lang
===================================================================
RCS file: /cvsroot/phpgroupware/tts/setup/phpgw_tr.lang,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -b -r1.3 -r1.4
--- phpgw_tr.lang 22 Feb 2006 09:36:56 -0000 1.3
+++ phpgw_tr.lang 24 Oct 2006 00:50:09 -0000 1.4
@@ -1,73 +1,73 @@
-action tts tr Ä°Ålemi yap
+action tts tr Ýþlemi yap
add new ticket tts tr Yeni bir bilet ekle
add ticket tts tr Bilet ekle
additional notes tts tr Ek olan notlar
-admin options admin tr Yönetici seçenekleri
+admin options admin tr Yönetici seçenekleri
assign to tts tr Birine ata
-assigned from tts tr Birinden atanmıÅ
-assigned to tts tr Birine atanmıÅ
+assigned from tts tr Birinden atanmýþ
+assigned to tts tr Birine atanmýþ
attachment tts tr Ek
-attachment changed tts tr Ek deÄiÅti
+attachment changed tts tr Ek deðiþti
billable hours tts tr Hesaplanabilir saatler
-billable hours changed tts tr Hesaplanabilir saatler deÄiÅti
-billable hours rate tts tr Hesaplanabilir saat oranı
+billable hours changed tts tr Hesaplanabilir saatler deðiþti
+billable hours rate tts tr Hesaplanabilir saat oraný
billable rate tts tr Hesaplanabilir oran
-billable rate changed tts tr Hesaplanabilir oran deÄiÅti
-category changed tts tr Kategori deÄiÅti
+billable rate changed tts tr Hesaplanabilir oran deðiþti
+category changed tts tr Kategori deðiþti
clear form tts tr Belirtilen yerden sil
-closed tts tr Kapalı
-create new ticket tts tr Yeni bilet oluÅtur
-creates a new ticket, returns ticket_id tts tr Yeni bilet
oluÅturur, ticket_id döndürür
-creates a struct of tickets tts tr Bilet yapısı oluÅturur
-date opened tts tr Açık olan tarih
+closed tts tr Kapalý
+create new ticket tts tr Yeni bilet oluþtur
+creates a new ticket, returns ticket_id tts tr Yeni bilet
oluþturur, ticket_id döndürür
+creates a struct of tickets tts tr Bilet yapýsý oluþturur
+date opened tts tr Açýk olan tarih
deadline tts tr Son teslim tarihi
-deadline changed tts tr Son teslim tarihi deÄiÅti
+deadline changed tts tr Son teslim tarihi deðiþti
detail tts tr Detay
effort tts tr Efor
-effort changed tts tr Efor deÄiÅti
-force tts tr Güç
-group ownership changed tts tr Grup sahibi deÄiÅti
-in progress tts tr Ä°Ålem yapılıyor
+effort changed tts tr Efor deðiþti
+force tts tr Güç
+group ownership changed tts tr Grup sahibi deðiþti
+in progress tts tr Ýþlem yapýlýyor
latest note added tts tr Enson not eklendi
new ticket tts tr Yeni bilet
-new value tts tr Yede deÄer
+new value tts tr Yede deðer
no additional notes tts tr Ek not yok
-no notes for this ticket tts tr Bu bilet için not yok
-no tickets found tts tr Bilet bulunamadı.
-not assigned tts tr AtanmamıÅ
-old value tts tr Eski deÄer
-open tts tr Açık
-open date tts tr açık olan tarih
-opened tts tr Açıldı
-opened by tts tr tarafından açıldı
-original ticket details tts tr Orjinal bilet detayı
+no notes for this ticket tts tr Bu bilet için not yok
+no tickets found tts tr Bilet bulunamadý.
+not assigned tts tr Atanmamýþ
+old value tts tr Eski deðer
+open tts tr Açýk
+open date tts tr açýk olan tarih
+opened tts tr Açýldý
+opened by tts tr tarafýndan açýldý
+original ticket details tts tr Orjinal bilet detayý
platform tts tr Platform
-platform changed tts tr Platform deÄiÅti
+platform changed tts tr Platform deðiþti
prio tts tr Prio
-priority tts tr Ãncelik
-priority changed tts tr Ãncelik deÄiÅti
-re-assigned tts tr Tekrar atandı
-re-opened tts tr Tekrar açıldı
-returns a struct of a tickets history tts tr Biletin geçmiÅinin
yapısını döndürür
-returns a struct of values of a single ticket tts tr Bir biletin
deÄerinin yapısını döndürür
-returns the additional notes attached to a ticket tts tr Bilete
sonradan eklenen notları döndürür
-status/date closed tts tr Durum/Tarih kapalı
-subject changed tts tr BaÅlık deÄiÅti
+priority tts tr Öncelik
+priority changed tts tr Öncelik deðiþti
+re-assigned tts tr Tekrar atandý
+re-opened tts tr Tekrar açýldý
+returns a struct of a tickets history tts tr Biletin geçmiþinin
yapýsýný döndürür
+returns a struct of values of a single ticket tts tr Bir biletin
deðerinin yapýsýný döndürür
+returns the additional notes attached to a ticket tts tr Bilete
sonradan eklenen notlarý döndürür
+status/date closed tts tr Durum/Tarih kapalý
+subject changed tts tr Baþlýk deðiþti
test tts tr TEST
ticket tts tr Bilet
-ticket has been updated tts tr Bilet güncellendi
+ticket has been updated tts tr Bilet güncellendi
tickets found %1 tts tr %1 bilet bulundu
-tickets open %1 tts tr Açık olan biletler %1
+tickets open %1 tts tr Açýk olan biletler %1
tickets total %1 tts tr %1 tane toplam bilet
-to go back to the tts index, click <a href= %1 >here</a> tts tr
tts index'e geri dönmek için, <a href="%1">buraya</a> tıklayın
+to go back to the tts index, click <a href= %1 >here</a> tts tr
tts index'e geri dönmek için, <a href="%1">buraya</a> týklayýn
total billable tts tr Toplam hesaplanabilir
trouble ticket system common tr Bilet Sorun Sistemi
tts common tr Bilet Sorun Sistemi
tts preferences tts tr Bilet Sorun Sistemi - tercihler
type tts tr Tip
-type changed tts tr Tip deÄiÅti
-updates ticket tts tr Bileti günceller
-use email notification tts tr E-posta uyarısını kullan
-view all tickets tts tr Tüm biletleri gör
-view job detail tts tr Ä°Åin detayını gör
-view only open tickets tts tr Sadece açık biletleri gör
+type changed tts tr Tip deðiþti
+updates ticket tts tr Bileti günceller
+use email notification tts tr E-posta uyarýsýný kullan
+view all tickets tts tr Tüm biletleri gör
+view job detail tts tr Ýþin detayýný gör
+view only open tickets tts tr Sadece açýk biletleri gör
Index: setup.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/tts/setup/setup.inc.php,v
retrieving revision 1.13
retrieving revision 1.14
diff -u -b -r1.13 -r1.14
--- setup.inc.php 11 Mar 2006 23:20:47 -0000 1.13
+++ setup.inc.php 24 Oct 2006 00:50:09 -0000 1.14
@@ -6,7 +6,7 @@
* @license http://www.gnu.org/licenses/gpl.html GNU General Public
License
* @package tts
* @subpackage setup
- * @version $Id: setup.inc.php,v 1.13 2006/03/11 23:20:47 skwashd Exp $
+ * @version $Id: setup.inc.php,v 1.14 2006/10/24 00:50:09 skwashd Exp $
*/
/* Basic information about this app */
@@ -28,6 +28,9 @@
$setup_info['tts']['hooks'][] = 'preferences';
$setup_info['tts']['hooks'][] = 'settings';
$setup_info['tts']['hooks'][] = 'deleteaccount';
+ $setup_info['tts']['hooks']['cat_add'] = 'tts.tts_bo_hooks.cat_add';
+ $setup_info['tts']['hooks']['cat_delete'] =
'tts.tts_bo_hooks.cat_delete';
+ $setup_info['tts']['hooks']['cat_edit'] = 'tts.tts_bo_hooks.cat_edit';
/* Dependencies for this app to work */
$setup_info['tts']['depends'][] = array(
Index: tables_baseline.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/tts/setup/tables_baseline.inc.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -b -r1.2 -r1.3
--- tables_baseline.inc.php 10 May 2005 16:12:38 -0000 1.2
+++ tables_baseline.inc.php 24 Oct 2006 00:50:09 -0000 1.3
@@ -6,7 +6,7 @@
* @license http://www.gnu.org/licenses/gpl.html GNU General Public
License
* @package tts
* @subpackage setup
- * @version $Id: tables_baseline.inc.php,v 1.2 2005/05/10 16:12:38
powerstat Exp $
+ * @version $Id: tables_baseline.inc.php,v 1.3 2006/10/24 00:50:09
skwashd Exp $
*/
$phpgw_baseline = array(
Index: tables_current.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/tts/setup/tables_current.inc.php,v
retrieving revision 1.10
retrieving revision 1.11
diff -u -b -r1.10 -r1.11
--- tables_current.inc.php 10 May 2005 16:12:38 -0000 1.10
+++ tables_current.inc.php 24 Oct 2006 00:50:09 -0000 1.11
@@ -6,40 +6,40 @@
* @license http://www.gnu.org/licenses/gpl.html GNU General Public
License
* @package tts
* @subpackage setup
- * @version $Id: tables_current.inc.php,v 1.10 2005/05/10 16:12:38
powerstat Exp $
+ * @version $Id: tables_current.inc.php,v 1.11 2006/10/24 00:50:09
skwashd Exp $
*/
$phpgw_baseline = array(
'phpgw_tts_tickets' => array(
'fd' => array(
- 'ticket_id' => array('type' =>
'auto', 'nullable' => False),
- 'ticket_group' => array('type' =>
'varchar', 'precision' => '40', 'nullable' => True),
- 'ticket_priority' => array('type' =>
'int', 'precision' => '2', 'nullable' => False),
- 'ticket_owner' => array('type' =>
'varchar', 'precision' => '10', 'nullable' => True),
- 'ticket_assignedto' => array('type' =>
'varchar', 'precision' => '10', 'nullable' => True),
- 'ticket_subject' => array('type' =>
'varchar', 'precision' => '255', 'nullable' => True),
- 'ticket_category' => array('type' =>
'varchar', 'precision' => '25', 'nullable' => True),
- 'ticket_billable_hours' => array('type' =>
'decimal', 'precision' => '8', 'scale' => 2, 'nullable' => False),
- 'ticket_billable_rate' => array('type' =>
'decimal', 'precision' => '8', 'scale' => 2, 'nullable' => False),
- 'ticket_status' => array('type' =>
'char','precision' => '1', 'nullable' => False),
+ 'ticket_id' => array('type' =>
'auto','nullable' => False),
+ 'ticket_group' => array('type' =>
'int','precision' => '8','nullable' => True),
+ 'ticket_priority' => array('type' =>
'int','precision' => '2','nullable' => False),
+ 'ticket_owner' => array('type' =>
'int','precision' => '8','nullable' => True),
+ 'ticket_assignedto' => array('type' =>
'int','precision' => '4','nullable' => True),
+ 'ticket_subject' => array('type' =>
'varchar','precision' => '255','nullable' => True),
+ 'ticket_category' => array('type' =>
'int','precision' => '8','nullable' => True),
+ 'ticket_billable_hours' => array('type' =>
'decimal','precision' => '8','scale' => '2','nullable' => False),
+ 'ticket_billable_rate' => array('type' =>
'decimal','precision' => '8','scale' => '2','nullable' => False),
+ 'ticket_status' => array('type' =>
'char','precision' => '1','nullable' => False),
'ticket_details' => array('type' =>
'text','nullable' => False),
- 'ticket_type' => array('type' =>
'int', 'precision' => '2', 'nullable' => False),
- 'ticket_deadline' => array('type' =>
'varchar', 'precision' => '10', 'nullable' => False),
- 'ticket_effort' => array('type' =>
'varchar', 'precision' => '4', 'nullable' => False),
- 'ticket_platform' => array('type' =>
'int', 'precision' => '2', 'nullable' => False),
- 'ticket_attachment' => array('type' =>
'int', 'precision' => '2', 'nullable' => False),
- 'ticket_lastmod' => array('type' =>
'int', 'precision' => '4', 'nullable' => False)
+ 'ticket_type' => array('type' =>
'int','precision' => '2','nullable' => False),
+ 'ticket_deadline' => array('type' =>
'int','precision' => '8','nullable' => False),
+ 'ticket_effort' => array('type' =>
'varchar','precision' => '4','nullable' => False),
+ 'ticket_lastmod' => array('type' =>
'int','precision' => '8','nullable' => False),
+ 'ticket_lastmod_user' => array('type' =>
'int','precision' => '8','nullable' => False),
+ 'ticket_request_note' => array('type' =>
'varchar','precision' => '255','nullable' => True)
),
'pk' => array('ticket_id'),
- 'ix' => array(),
'fk' => array(),
+ 'ix' =>
array('ticket_group','ticket_owner','ticket_assignedto','ticket_subject','ticket_category','ticket_status','ticket_deadline'),
'uc' => array()
),
'phpgw_tts_views' => array(
'fd' => array(
- 'view_id' => array('type' => 'int',
'precision' => '4', 'nullable' => False),
- 'view_account_id' => array('type' =>
'varchar', 'precision' => '40', 'nullable' => True),
- 'view_time' => array('type' => 'int',
'precision' => '4', 'nullable' => False)
+ 'view_id' => array('type' => 'int','precision'
=> '4','nullable' => False),
+ 'view_account_id' => array('type' =>
'varchar','precision' => '40','nullable' => True),
+ 'view_time' => array('type' =>
'int','precision' => '4','nullable' => False)
),
'pk' => array(),
'ix' => array(),
Index: tables_update.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/tts/setup/tables_update.inc.php,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -b -r1.4 -r1.5
--- tables_update.inc.php 10 May 2005 16:12:38 -0000 1.4
+++ tables_update.inc.php 24 Oct 2006 00:50:09 -0000 1.5
@@ -6,7 +6,7 @@
* @license http://www.gnu.org/licenses/gpl.html GNU General Public
License
* @package tts
* @subpackage setup
- * @version $Id: tables_update.inc.php,v 1.4 2005/05/10 16:12:38
powerstat Exp $
+ * @version $Id: tables_update.inc.php,v 1.5 2006/10/24 00:50:09 skwashd
Exp $
*/
/* This is since the last release */
@@ -69,4 +69,95 @@
return $setup_info['tts']['currentver'];
}
+
+
+ $test[] = '0.9.16.002';
+ function tts_upgrade0_9_16_002()
+ {
+
$GLOBALS['phpgw_setup']->oProc->DropColumn('phpgw_tts_tickets',array(
+ 'fd' => array(
+ 'ticket_id' => array('type' =>
'auto','nullable' => False),
+ 'ticket_group' => array('type' =>
'varchar','precision' => '40','nullable' => True),
+ 'ticket_priority' => array('type' =>
'int','precision' => '2','nullable' => False),
+ 'ticket_owner' => array('type' =>
'varchar','precision' => '10','nullable' => True),
+ 'ticket_assignedto' => array('type' =>
'varchar','precision' => '10','nullable' => True),
+ 'ticket_subject' => array('type' =>
'varchar','precision' => '255','nullable' => True),
+ 'ticket_category' => array('type' =>
'varchar','precision' => '25','nullable' => True),
+ 'ticket_billable_hours' => array('type' =>
'decimal','precision' => '8','scale' => '2','nullable' => False),
+ 'ticket_billable_rate' => array('type' =>
'decimal','precision' => '8','scale' => '2','nullable' => False),
+ 'ticket_status' => array('type' =>
'char','precision' => '1','nullable' => False),
+ 'ticket_details' => array('type' =>
'text','nullable' => False),
+ 'ticket_type' => array('type' =>
'int','precision' => '2','nullable' => False),
+ 'ticket_deadline' => array('type' =>
'varchar','precision' => '10','nullable' => False),
+ 'ticket_effort' => array('type' =>
'varchar','precision' => '4','nullable' => False),
+ 'ticket_attachment' => array('type' =>
'int','precision' => '2','nullable' => False),
+ 'ticket_lastmod' => array('type' =>
'int','precision' => '4','nullable' => False)
+ ),
+ 'pk' => array('ticket_id'),
+ 'ix' => array(),
+ 'fk' => array(),
+ 'uc' => array()
+ ),'ticket_platform');
+
$GLOBALS['phpgw_setup']->oProc->DropColumn('phpgw_tts_tickets',array(
+ 'fd' => array(
+ 'ticket_id' => array('type' =>
'auto','nullable' => False),
+ 'ticket_group' => array('type' =>
'varchar','precision' => '40','nullable' => True),
+ 'ticket_priority' => array('type' =>
'int','precision' => '2','nullable' => False),
+ 'ticket_owner' => array('type' =>
'varchar','precision' => '10','nullable' => True),
+ 'ticket_assignedto' => array('type' =>
'varchar','precision' => '10','nullable' => True),
+ 'ticket_subject' => array('type' =>
'varchar','precision' => '255','nullable' => True),
+ 'ticket_category' => array('type' =>
'varchar','precision' => '25','nullable' => True),
+ 'ticket_billable_hours' => array('type' =>
'decimal','precision' => '8','scale' => '2','nullable' => False),
+ 'ticket_billable_rate' => array('type' =>
'decimal','precision' => '8','scale' => '2','nullable' => False),
+ 'ticket_status' => array('type' =>
'char','precision' => '1','nullable' => False),
+ 'ticket_details' => array('type' =>
'text','nullable' => False),
+ 'ticket_type' => array('type' =>
'int','precision' => '2','nullable' => False),
+ 'ticket_deadline' => array('type' =>
'varchar','precision' => '10','nullable' => False),
+ 'ticket_effort' => array('type' =>
'varchar','precision' => '4','nullable' => False),
+ 'ticket_lastmod' => array('type' =>
'int','precision' => '4','nullable' => False)
+ ),
+ 'pk' => array('ticket_id'),
+ 'ix' => array(),
+ 'fk' => array(),
+ 'uc' => array()
+ ),'ticket_attachment');
+
$GLOBALS['phpgw_setup']->oProc->AlterColumn('phpgw_tts_tickets','ticket_group',array(
+ 'type' => 'int',
+ 'precision' => '8',
+ 'nullable' => True
+ ));
+
$GLOBALS['phpgw_setup']->oProc->AlterColumn('phpgw_tts_tickets','ticket_owner',array(
+ 'type' => 'int',
+ 'precision' => '8',
+ 'nullable' => True
+ ));
+
$GLOBALS['phpgw_setup']->oProc->AlterColumn('phpgw_tts_tickets','ticket_assignedto',array(
+ 'type' => 'int',
+ 'precision' => '8',
+ 'nullable' => True
+ ));
+
$GLOBALS['phpgw_setup']->oProc->AlterColumn('phpgw_tts_tickets','ticket_category',array(
+ 'type' => 'int',
+ 'precision' => '8',
+ 'nullable' => True
+ ));
+
$GLOBALS['phpgw_setup']->oProc->AlterColumn('phpgw_tts_tickets','ticket_deadline',array(
+ 'type' => 'int',
+ 'precision' => '8',
+ 'nullable' => False
+ ));
+
$GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_tts_tickets','ticket_lastmod_user',array(
+ 'type' => 'int',
+ 'precision' => '4',
+ 'nullable' => False
+ ));
+
$GLOBALS['phpgw_setup']->oProc->AddColumn('phpgw_tts_tickets','ticket_request_note',array(
+ 'type' => 'varchar',
+ 'precision' => '255',
+ 'nullable' => True
+ ));
+
+ $GLOBALS['setup_info']['tts']['currentver'] = '0.9.17.500';
+ return $GLOBALS['setup_info']['tts']['currentver'];
+ }
?>
| [Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] tts/setup default_records.inc.php phpgw_ca.lang...,
Dave Hall <=