cores_create.sql

Revision f328b74996d55e5c1c40dc0bd3c12de224a1e75c, 0.7 kB (checked in by Christopher Jung <bktheg@web.de>, 6 months ago)
[ref] SQL-Skripte aufgetrennt in seperate CREATE, ALTER und INSERT Teile.
Property mode set to `100644`

Line
1	CREATE TABLE `cores` (
2	`id` int(11) NOT NULL auto_increment,
3	`name` varchar(50) NOT NULL default 'Noname',
4	`astitype` tinyint(3) unsigned NOT NULL default '1',
5	`buildcosts` 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',
6	`consumes` 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	`produces` 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',
8	`arbeiter` int(11) NOT NULL default '0',
9	`ever` int(11) NOT NULL default '0',
10	`eprodu` int(11) NOT NULL default '0',
11	`bewohner` int(11) NOT NULL default '0',
12	`techreq` int(11) NOT NULL default '0',
13	`eps` int(11) NOT NULL default '0',
14	PRIMARY KEY (`id`)
15	) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Note: See TracBrowser for help on using the browser.