Changeset 8825186da57192b768ef1737599778a4c84a1776

Timestamp:

05/05/07 14:40:29 (1 year ago)

Author:

Christopher Jung <bktheg@web.de>

git-committer:

Christopher Jung <bktheg@web.de> 1178368829 +0200

git-parent:

[cd77adf4ce331fbfadcbaa0f3fbc0e844d60d87f]

git-author:

Christopher Jung <bktheg@web.de> 1178368829 +0200

Message:

Einige SQL-Fehler behoben

Files:

• db/tables/bases.sql (modified) (1 diff)
• db/tables/users.sql (modified) (1 diff)
• db/updates.xml (modified) (1 diff)

db/tables/bases.sql

@@ -18 +18 @@
-  `maxtiles` smallint(6) NOT NULL default '0',
-  `size` tinyint(3) unsigned NOT NULL default '0',
-
-
-
+ default ''
+ default ''
+ default ''
-  `coreactive` tinyint(3) unsigned NOT NULL default '0',
-
+ default ''
-  PRIMARY KEY  (`id`),
-  KEY `owner` (`owner`,`id`),

db/tables/users.sql

@@ -33 +33 @@
-  `destroyedShips` int(10) unsigned NOT NULL default '0',
-  `lostShips` int(10) unsigned NOT NULL default '0',
-
+ default ''
-  PRIMARY KEY  (`id`),
-  KEY `ally` (`ally`),

db/updates.xml

@@ -252 +252 @@
-                ALTER TABLE `ships` CHANGE `destcom` `destcom` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default '';
-        ]]></update>
+        <update type="structure" datum="2007-05-05"><![CDATA[
+                ALTER TABLE `bases` CHANGE `terrain` `terrain` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default '';
+                ALTER TABLE `bases` CHANGE `bebauung` `bebauung` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default '';
+                ALTER TABLE `bases` CHANGE `active` `active` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default '';
+                ALTER TABLE `bases` CHANGE `autogtuacts` `autogtuacts` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default '';
+                ALTER TABLE `users` CHANGE `knownItems` `knownItems` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default '';
+        ]]></update>
-</updates>