[Bugin-hackers] bugin/sql mysql-0.60-0.65.sql,NONE,1.1 mysql.sql,1.25,1.26 mysql-0.60-0.61.sql,1.6,NONE

[<no...@us...>]

Update of /cvsroot/bugin/bugin/sql
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv5220

Modified Files:
	mysql.sql 
Added Files:
	mysql-0.60-0.65.sql 
Removed Files:
	mysql-0.60-0.61.sql 
Log Message:
Default templates are now read from the files, so no need to load them into the database.



--- NEW FILE: mysql-0.60-0.65.sql ---
--
-- updating table names
--
ALTER TABLE `category` RENAME `bugin_category`;
ALTER TABLE `config` RENAME `bugin_config`;
ALTER TABLE `modifications` RENAME `bugin_modifications`;
ALTER TABLE `priority` RENAME `bugin_priority`;
ALTER TABLE `projects` RENAME `bugin_projects`;
ALTER TABLE `status` RENAME `bugin_status`;
ALTER TABLE `tickets` RENAME `bugin_tickets`;
ALTER TABLE `udb` RENAME `bugin_users`;
ALTER TABLE `user_group` RENAME `bugin_groups`;
ALTER TABLE `acl` RENAME `bugin_acl`;

ALTER TABLE `bugin_users` ADD lang tinyint(3) unsigned NOT NULL default '1';
ALTER TABLE `bugin_trigger_rule` CHANGE `value` `value` TEXT NOT NULL;

--
-- Table structure for table 'bugin_lang'
--

CREATE TABLE bugin_lang (
  id tinyint(3) unsigned NOT NULL auto_increment,
  name char(2) NOT NULL default '',
  UNIQUE KEY id (id)
) TYPE=MyISAM;

--
-- Dumping data for table 'bugin_lang'
--


INSERT INTO bugin_lang VALUES (1,'en');
INSERT INTO bugin_lang VALUES (2,'de');
INSERT INTO bugin_lang VALUES (3,'sp');


--
-- Table structure for table 'bugin_templates'
--

CREATE TABLE bugin_templates (
  id int(11) NOT NULL auto_increment,
  name varchar(16) NOT NULL default '',
  value text NOT NULL,
  lang_id tinyint(3) unsigned NOT NULL default '0',
  UNIQUE KEY id (id)
) TYPE=MyISAM;


Index: mysql.sql
===================================================================
RCS file: /cvsroot/bugin/bugin/sql/mysql.sql,v
retrieving revision 1.25
retrieving revision 1.26
diff -C2 -d -r1.25 -r1.26
*** mysql.sql	3 Mar 2004 14:46:48 -0000	1.25
--- mysql.sql	9 Mar 2004 18:56:07 -0000	1.26
***************
*** 216,230 ****
  ) TYPE=MyISAM;
  
- --
- -- Dumping data for table 'bugin_templates'
- --
- 
- 
- INSERT INTO bugin_templates VALUES (1,'notification','Modification by %MOD_BY%:\r\n%MOD%\r\n-------------------------------------------------------------------\r\nAdditional Information:\r\nDescription: %DESC%\r\nCreator: %CREATOR%\r\nOwner: %OWNER%\r\nLong Description:\r\n%LONG_DESC%\r\n-------------------------------------------------------------------\r\nYou can view this ticket at\r\n%BASE_URL%?area=view&num=%NUM%\r\nYou may also reply to this message to add additional information\r\nto the ticket.',1);
- INSERT INTO bugin_templates VALUES (2,'notification','Aenderung durch %MOD_BY%:\r\n%MOD%\r\n-------------------------------------------------------------------\r\nZusaetzliche Information:\r\nBeschreibung: %DESC%\r\nAutor: %CREATOR%\r\nVerantwortlicher: %OWNER%\r\nAusfuehrliche Beschreibung:\r\n%LONG_DESC%\r\n-------------------------------------------------------------------\r\nDu kannst dieses Ticket betrachten unter\r\n%BASE_URL%?area=view&num=%NUM%\r\nWenn Du weitere Informationen zu diesem Ticket hinzufuegen willst\r\nbrauchst Du nur auf diese EMail zu antworten.',2);
- INSERT INTO bugin_templates VALUES (3,'notify_subj','Ticket #%NUM% has been %ACTION% (%DESC%) {TRACK:%NUM%}',1);
- INSERT INTO bugin_templates VALUES (4,'signup_email','An account has been created for you in the %SYSTEM_NAME%\r\nticket tracking system.\r\n\r\nUsername: %UNAME%\r\nPassword: %PASS%\r\n\r\nYou can sign into the system at:\r\n%BASE_URL%\r\n',1);
- INSERT INTO bugin_templates VALUES (5,'signup_email','Ein neuer Account wurde fuer Dich im %SYSTEM_NAME%\r\nTicket System angelegt.\r\n\r\nUsername: %UNAME%\r\nPasswort: %PASS%\r\n\r\nDu kannst Dich einloggen unter:\r\n%BASE_URL%',2);
- INSERT INTO bugin_templates VALUES (6,'notify_subj','Ticket #%NUM% wurde %ACTION% (%DESC%) {TRACK:%NUM%}',2);
  
  --
--- 216,219 ----

--- mysql-0.60-0.61.sql DELETED ---