Navigation

← Previous Changeset
Next Changeset →

Changeset e65784fd7de3b5d9a7a20d612f029671d98de9b0

Timestamp:

05/11/08 13:10:59 (2 months ago)

Author:

Christopher Jung <bktheg@web.de>

git-committer:

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

git-parent:

[29e34b06ed0e5849e5608217f876112513827cf6]

git-author:

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

Message:

[sql] Versionsattribut in alle Tabellendefinitionen nachgezogen

Files:

db/tables/academy.sql (modified) (1 diff)
db/tables/ally.sql (modified) (1 diff)
db/tables/ally_posten.sql (modified) (1 diff)
db/tables/battles.sql (modified) (1 diff)
db/tables/battles_ships.sql (modified) (1 diff)
db/tables/factions_angebote.sql (modified) (1 diff)
db/tables/factions_shop_entries.sql (modified) (1 diff)
db/tables/factions_shop_orders.sql (modified) (1 diff)
db/tables/fz.sql (modified) (1 diff)
db/tables/gtu_warenkurse.sql (modified) (1 diff)
db/tables/gtu_zwischenlager.sql (modified) (1 diff)
db/tables/handel.sql (modified) (1 diff)
db/tables/jumps.sql (modified) (1 diff)
db/tables/logging.sql (modified) (1 diff)
db/tables/orders.sql (modified) (1 diff)
db/tables/sectors.sql (modified) (1 diff)
db/tables/sessions.sql (modified) (1 diff)
db/tables/ship_fleets.sql (modified) (1 diff)
db/tables/ship_loot.sql (modified) (1 diff)
db/tables/ship_types.sql (modified) (1 diff)
db/tables/ships.sql (modified) (1 diff)
db/tables/ships_lost.sql (modified) (1 diff)
db/tables/ships_modules.sql (modified) (1 diff)
db/tables/skn.sql (modified) (1 diff)
db/tables/skn_channels.sql (modified) (1 diff)
db/tables/skn_visits.sql (modified) (1 diff)
db/tables/smilies.sql (modified) (1 diff)
db/tables/stats_cargo.sql (modified) (1 diff)
db/tables/stats_gtu.sql (modified) (1 diff)
db/tables/stats_module_locations.sql (modified) (1 diff)
db/tables/stats_ships.sql (modified) (1 diff)
db/tables/stats_user_cargo.sql (modified) (1 diff)
db/tables/stats_verkaeufe.sql (modified) (1 diff)
db/tables/tasks.sql (modified) (1 diff)
db/tables/tradepost_buy_limit.sql (modified) (1 diff)
db/tables/tradepost_sell.sql (modified) (1 diff)
db/tables/transmissionen.sql (modified) (1 diff)
db/tables/user_moneytransfer.sql (modified) (1 diff)
db/tables/user_relations.sql (modified) (1 diff)
db/tables/user_values.sql (modified) (1 diff)
db/tables/users.sql (modified) (1 diff)
db/tables/versteigerungen.sql (modified) (1 diff)
db/tables/versteigerungen_pakete.sql (modified) (1 diff)
db/tables/weaponfactory.sql (modified) (1 diff)
db/tables/werften.sql (modified) (1 diff)

Legend:

: Unmodified
: Added
: Removed
: Modified
: Copied
: Moved

db/tables/academy.sql

re35d2b9	re65784f
4	4	`remain` tinyint(4) NOT NULL default '0',
5	5	`upgrade` varchar(10) NOT NULL default '',
	6	`version` int(10) unsigned not null default '0',
6	7	PRIMARY KEY (`col`)
7	8	) ENGINE=InnoDB DEFAULT CHARSET=utf8;

db/tables/ally.sql

r673ded2	re65784f
18	18	`destroyedShips` int(10) unsigned NOT NULL default '0',
19	19	`lostShips` int(10) unsigned NOT NULL default '0',
	20	`version` int(10) unsigned not null default '0',
20	21	PRIMARY KEY (`id`)
21	22	) ENGINE=InnoDB DEFAULT CHARSET=utf8;

db/tables/ally_posten.sql

rde17f74	re65784f
3	3	`ally` int(11) NOT NULL default '0',
4	4	`name` varchar(70) NOT NULL default 'Kein Name',
	5	`version` int(10) unsigned not null default '0',
5	6	PRIMARY KEY (`id`)
6	7	) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Die verschiedenen Posten der Allys';

db/tables/battles.sql

r1d608be	re65784f
26	26	`visibility` text character set latin1,
27	27	`quest` int(10) unsigned default NULL,
	28	`version` int(10) unsigned not null default '0',
28	29	PRIMARY KEY (`id`),
29	30	KEY `coords` (`x`,`y`,`system`)

db/tables/battles_ships.sql

r927e509	re65784f
13	13	`count` tinyint(3) unsigned NOT NULL default '1',
14	14	`newcount` tinyint(3) unsigned NOT NULL default '0',
	15	`version` int(10) unsigned not null default '0',
15	16	PRIMARY KEY (`shipid`),
16	17	KEY `battleid` (`battleid`)

db/tables/factions_angebote.sql

r425acaa	re65784f
5	5	`image` varchar(100) NOT NULL default '',
6	6	`description` text NOT NULL,
	7	`version` int(10) unsigned not null default '0',
7	8	PRIMARY KEY (`id`)
8	9	) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='GTU-Festpreisangebote';

db/tables/factions_shop_entries.sql

r425acaa	re65784f
6	6	`price` int(10) unsigned NOT NULL default '1',
7	7	`availability` tinyint(3) unsigned NOT NULL default '0',
	8	`version` int(10) unsigned not null default '0',
8	9	PRIMARY KEY (`id`),
9	10	KEY `faction_id` (`faction_id`)

db/tables/factions_shop_orders.sql

r59f888b	re65784f
8	8	`date` int(10) unsigned NOT NULL default '0',
9	9	`adddata` text,
	10	`version` int(10) unsigned not null default '0',
10	11	PRIMARY KEY (`id`),
11	12	KEY `shopentry_id` (`shopentry_id`),

db/tables/fz.sql

r253f8ca	re65784f
4	4	`forschung` int(11) NOT NULL default '0',
5	5	`dauer` int(11) NOT NULL default '0',
	6	`version` int(10) unsigned not null default '0',
6	7	PRIMARY KEY (`col`)
7	8	) ENGINE=InnoDB DEFAULT CHARSET=utf8;

db/tables/gtu_warenkurse.sql

r425acaa	re65784f
3	3	`name` varchar(30) NOT NULL default '',
4	4	`kurse` text NOT NULL,
	5	`version` int(10) unsigned not null default '0',
5	6	PRIMARY KEY (`place`)
6	7	) ENGINE=InnoDB DEFAULT CHARSET=utf8;

db/tables/gtu_zwischenlager.sql

r5170470	re65784f
8	8	`cargo2` text NOT NULL,
9	9	`cargo2need` text NOT NULL,
	10	`version` int(10) unsigned not null default '0',
10	11	PRIMARY KEY (`id`),
11	12	KEY `posten` (`posten`,`user1`,`user2`)

db/tables/handel.sql

rb007e02	re65784f
6	6	`bietet` text NOT NULL,
7	7	`comm` text NOT NULL,
	8	`version` int(10) unsigned not null default '0',
8	9	PRIMARY KEY (`id`)
9	10	) ENGINE=InnoDB DEFAULT CHARSET=utf8;

db/tables/jumps.sql

r39cd211	re65784f
5	5	`y` smallint(5) unsigned NOT NULL default '0',
6	6	`system` tinyint(3) unsigned NOT NULL default '0',
	7	`version` int(10) unsigned not null default '0',
7	8	PRIMARY KEY (`id`),
8	9	KEY `shipid` (`shipid`)

db/tables/logging.sql

r29e34b0	re65784f
7	7	`target` varchar(12) NOT NULL default '',
8	8	`data` text,
	9	`version` int(10) unsigned not null default '0',
9	10	PRIMARY KEY (`id`)
10	11	) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='Alg. Logging';

db/tables/orders.sql

r425acaa	re65784f
4	4	`tick` int(11) NOT NULL default '0',
5	5	`user` int(11) NOT NULL default '0',
	6	`version` int(10) unsigned not null default '0',
6	7	PRIMARY KEY (`id`)
7	8	) ENGINE=InnoDB DEFAULT CHARSET=utf8;

db/tables/sectors.sql

r425acaa	re65784f
5	5	`objects` int(11) NOT NULL default '0',
6	6	`onenter` text NOT NULL,
	7	`version` int(10) unsigned not null default '0',
7	8	PRIMARY KEY (`system`,`x`,`y`)
8	9	) ENGINE=InnoDB DEFAULT CHARSET=utf8;

db/tables/sessions.sql

r5189e17	re65784f
8	8	`tick` tinyint(3) unsigned NOT NULL default '0',
9	9	`attach` varchar(36) default NULL,
	10	`version` int(10) unsigned not null default '0',
10	11	PRIMARY KEY (`session`)
11	12	) ENGINE=InnoDB DEFAULT CHARSET=utf8;

db/tables/ship_fleets.sql

r425acaa	re65784f
2	2	`id` int(11) NOT NULL auto_increment,
3	3	`name` varchar(90) NOT NULL default '',
	4	`version` int(10) unsigned not null default '0',
4	5	PRIMARY KEY (`id`)
5	6	) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Die Flottenverbaende';

db/tables/ship_loot.sql

r0dde328	re65784f
8	8	`count` smallint(5) unsigned NOT NULL default '1',
9	9	`totalmax` smallint(6) NOT NULL default '-1',
	10	`version` int(10) unsigned not null default '0',
10	11	PRIMARY KEY (`id`),
11	12	KEY `shiptype` (`shiptype`),

db/tables/ship_types.sql

r390f9f1	re65784f
40	40	`pickingCost` INT NOT NULL default '0',
41	41	`marines` int unsigned NOT NULL default '0',
	42	`version` int(10) unsigned not null default '0',
42	43	PRIMARY KEY (`id`)
43	44	) ENGINE=InnoDB DEFAULT CHARSET=utf8;

db/tables/ships.sql

rf082126	re65784f
43	43	`startFighters` tinyint(3) unsigned NOT NULL default '1',
44	44	`marines` int unsigned NOT NULL default '0',
	45	`version` int(10) unsigned not null default '0',
45	46	PRIMARY KEY (`id`),
46	47	KEY `coords` (`x`,`y`,`system`),

db/tables/ships_lost.sql

r969ae09	re65784f
11	11	`battle` int(10) unsigned NOT NULL default '0',
12	12	`battlelog` varchar(120) NOT NULL default '',
	13	`version` int(10) unsigned not null default '0',
13	14	PRIMARY KEY (`id`),
14	15	KEY `owner` (`owner`),

db/tables/ships_modules.sql

r390f9f1	re65784f
35	35	`pickingCost` INT NOT NULL DEFAULT '0',
36	36	`marines` int unsigned NOT NULL default '0',
	37	`version` int(10) unsigned not null default '0',
37	38	PRIMARY KEY (`id`)
38	39	) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='modifizierte Schiffstypenwerte fuer "jedes" Schiff';

db/tables/skn.sql

r5189e17	re65784f
10	10	`tick` mediumint(8) unsigned NOT NULL default '0',
11	11	`channel` int(10) unsigned NOT NULL default '1',
	12	`version` int(10) unsigned not null default '0',
12	13	PRIMARY KEY (`post`),
13	14	KEY `channel` (`channel`)

db/tables/skn_channels.sql

r425acaa	re65784f
11	11	`readplayer` text NOT NULL,
12	12	`writeplayer` text NOT NULL,
	13	`version` int(10) unsigned not null default '0',
13	14	PRIMARY KEY (`id`),
14	15	KEY `allyowner` (`allyowner`)

db/tables/skn_visits.sql

r9cd5406	re65784f
4	4	`channel` int(11) unsigned NOT NULL default '0',
5	5	`time` int(10) unsigned NOT NULL default '0',
	6	`version` int(10) unsigned not null default '0',
6	7	PRIMARY KEY (`id`),
7	8	KEY `user` (`user`, `channel`)

db/tables/smilies.sql

r425acaa	re65784f
3	3	`tag` varchar(10) NOT NULL default '',
4	4	`image` varchar(40) NOT NULL default '',
	5	`version` int(10) unsigned not null default '0',
5	6	PRIMARY KEY (`id`)
6	7	) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Smilies';

db/tables/stats_cargo.sql

r425acaa	re65784f
2	2	`tick` int(11) NOT NULL auto_increment,
3	3	`cargo` text NOT NULL,
	4	`version` int(10) unsigned not null default '0',
4	5	PRIMARY KEY (`tick`)
5	6	) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Die Cargo-Statistik (Gesamtcargo)';

db/tables/stats_gtu.sql

r425acaa	re65784f
9	9	`ownername` varchar(255) NOT NULL default 'Galtracorp Unlimited',
10	10	`gtugew` double NOT NULL default '100',
	11	`version` int(10) unsigned not null default '0',
11	12	PRIMARY KEY (`id`),
12	13	KEY `preis` (`preis`)

db/tables/stats_module_locations.sql

r0aa6793	re65784f
4	4	`item_id` smallint(5) unsigned NOT NULL default '0',
5	5	`locations` varchar(85) NOT NULL default '',
	6	`version` int(10) unsigned not null default '0',
6	7	PRIMARY KEY (`id`),
7	8	KEY `user_id` (`user_id`)

db/tables/stats_ships.sql

r425acaa	re65784f
3	3	`shipcount` int(10) unsigned NOT NULL default '0',
4	4	`crewcount` int(10) unsigned NOT NULL default '0',
	5	`version` int(10) unsigned not null default '0',
5	6	PRIMARY KEY (`tick`)
6	7	) ENGINE=InnoDB DEFAULT CHARSET=utf8;

db/tables/stats_user_cargo.sql

rb767799	re65784f
2	2	`user_id` int(11) NOT NULL default '0',
3	3	`cargo` text NOT NULL,
	4	`version` int(10) unsigned not null default '0',
4	5	PRIMARY KEY (`user_id`)
5	6	) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Die User-Cargo-Stats';

db/tables/stats_verkaeufe.sql

r744d21c	re65784f
5	5	`system` tinyint(3) NOT NULL default '1',
6	6	`stats` varchar(120) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',
	7	`version` int(10) unsigned not null default '0',
7	8	PRIMARY KEY (`id`),
8	9	KEY `place` (`place`,`system`),

db/tables/tasks.sql

r425acaa	re65784f
7	7	`data2` varchar(60) NOT NULL default '',
8	8	`data3` varchar(60) NOT NULL default '',
	9	`version` int(10) unsigned not null default '0',
9	10	PRIMARY KEY (`taskid`),
10	11	KEY `type` (`type`,`time`,`data1`,`data2`,`data3`)

db/tables/tradepost_buy_limit.sql

rf82584a	re65784f
3	3	`resourceid` int(11) NOT NULL,
4	4	`limit` int(11) NOT NULL,
	5	`version` int(10) unsigned not null default '0',
5	6	PRIMARY KEY (`shipid`,`resourceid`)
6	7	) ENGINE=InnoDB DEFAULT CHARSET=utf8;

db/tables/tradepost_sell.sql

rb4e8ec6	re65784f
4	4	`price` int(11) NOT NULL,
5	5	`limit` int(11) NOT NULL,
	6	`version` int(10) unsigned not null default '0',
6	7	PRIMARY KEY (`shipid`,`resourceid`)
7	8	) ENGINE=InnoDB DEFAULT CHARSET=utf8;

db/tables/transmissionen.sql

ra867cb8	re65784f
10	10	`inhalt` text NOT NULL,
11	11	`kommentar` text NOT NULL default '',
	12	`version` int(10) unsigned not null default '0',
12	13	PRIMARY KEY (`id`),
13	14	KEY `empfaenger` (`empfaenger`,`gelesen`)

db/tables/user_moneytransfer.sql

r91e50d3	re65784f
8	8	`fake` tinyint(3) unsigned NOT NULL default '0',
9	9	`type` tinyint(3) unsigned NOT NULL default '0',
	10	`version` int(10) unsigned not null default '0',
10	11	PRIMARY KEY (`id`),
11	12	KEY `from` (`from`,`to`)

db/tables/user_relations.sql

r374bc13	re65784f
4	4	`target_id` int(11) NOT NULL default '0',
5	5	`status` tinyint(3) unsigned NOT NULL default '0',
	6	`version` int(10) unsigned not null default '0',
6	7	PRIMARY KEY (`id`),
7	8	KEY `user_id` (`user_id`,`target_id`)

db/tables/user_values.sql

r12ccb26	re65784f
4	4	`name` varchar(60) NOT NULL default '',
5	5	`value` varchar(40) NOT NULL default '',
	6	`version` int(10) unsigned not null default '0',
6	7	PRIMARY KEY (`id`),
7	8	KEY `id` (`user_id`,`name`)

db/tables/users.sql

r0041fab	re65784f
34	34	`lostShips` int(10) unsigned NOT NULL default '0',
35	35	`knownItems` text NOT NULL default '',
	36	`version` int(10) unsigned not null default '0',
36	37	PRIMARY KEY (`id`),
37	38	KEY `ally` (`ally`),

db/tables/versteigerungen.sql

rc118afd	re65784f
7	7	`bieter` int(11) NOT NULL default '-2',
8	8	`owner` int(11) NOT NULL default '-2',
	9	`version` int(10) unsigned not null default '0',
9	10	PRIMARY KEY (`id`)
10	11	) ENGINE=InnoDB DEFAULT CHARSET=utf8;

db/tables/versteigerungen_pakete.sql

r5b632cf	re65784f
6	6	`ships` text NOT NULL,
7	7	`cargo` text NOT NULL,
	8	`version` int(10) unsigned not null default '0',
8	9	PRIMARY KEY (`id`)
9	10	) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='gtu - pakete';

db/tables/weaponfactory.sql

ra3647fc	re65784f
3	3	`count` tinyint(3) unsigned NOT NULL default '0',
4	4	`produces` text NOT NULL,
	5	`version` int(10) unsigned not null default '0',
5	6	PRIMARY KEY (`col`)
6	7	) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Die Waffenfabriken';

db/tables/werften.sql

r9689aa5	re65784f
8	8	`linkedWerft` int(11) default null,
9	9	`komplex` tinyint(1) NOT NULL default '0',
	10	`version` int(10) unsigned not null default '0',
10	11	PRIMARY KEY (`id`),
11	12	KEY `col` (`col`),

Navigation

Changeset e65784fd7de3b5d9a7a20d612f029671d98de9b0

Legend:

Download in other formats: