Changeset df0de6b00bf98a4523f1f1d8423fecff2b67face

Show
Ignore:
Timestamp:
05/01/07 13:37:11 (1 year ago)
Author:
Christopher Jung <bktheg@web.de>
git-committer:
Christopher Jung <bktheg@web.de> 1178019431 +0200
git-parent:

[b3b8b5733533d23a052c2bb6e23893033e1c25d0]

git-author:
Christopher Jung <bktheg@web.de> 1178019431 +0200
Message:

Defaultwert fuer transmissionen.kommentar ergaenzt

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • db/tables/transmissionen.sql

    rbeedc3b rdf0de6b  
    99  `flags` int(11) NOT NULL default '0', 
    1010  `inhalt` text NOT NULL, 
    11   `kommentar` text NOT NULL
     11  `kommentar` text NOT NULL default ''
    1212  PRIMARY KEY  (`id`), 
    1313  KEY `empfaenger` (`empfaenger`,`gelesen`) 
  • db/updates.xml

    r6af2de0 rdf0de6b  
    249249                ALTER TABLE ships DROP INDEX owner, ADD INDEX owner ( owner , id ); 
    250250                ALTER TABLE bases DROP INDEX owner, ADD INDEX owner ( owner , id ); 
     251                ALTER TABLE `transmissionen` CHANGE `kommentar` `kommentar` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default '' 
    251252        ]]></update> 
    252253</updates>