buildings_create.sql

Revision f328b74996d55e5c1c40dc0bd3c12de224a1e75c, 1.1 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 `buildings` (
2	`id` int(11) NOT NULL auto_increment,
3	`name` varchar(50) NOT NULL default 'Noname',
4	`picture` varchar(60) NOT NULL default '',
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,',
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,',
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,',
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	`perplanet` tinyint(3) unsigned NOT NULL default '0',
15	`perowner` tinyint(3) unsigned NOT NULL default '0',
16	`category` tinyint(3) unsigned NOT NULL default '4',
17	`ucomplex` tinyint(3) unsigned NOT NULL default '0',
18	`deakable` tinyint(1) unsigned NOT NULL default '1',
19	`module` varchar(60) NOT NULL default 'net.driftingsouls.ds2.server.bases.DefaultBuilding',
20	PRIMARY KEY (`id`),
21	KEY `category` (`category`)
22	) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Note: See TracBrowser for help on using the browser.