|
Revision f328b74996d55e5c1c40dc0bd3c12de224a1e75c, 0.6 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 `forschungen` ( |
|---|
| 2 |
`id` int(11) NOT NULL auto_increment, |
|---|
| 3 |
`name` varchar(60) NOT NULL default '', |
|---|
| 4 |
`req1` int(11) NOT NULL default '0', |
|---|
| 5 |
`req2` int(11) NOT NULL default '0', |
|---|
| 6 |
`req3` int(11) NOT NULL default '0', |
|---|
| 7 |
`time` int(11) NOT NULL default '0', |
|---|
| 8 |
`costs` varchar(120) NOT NULL default '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', |
|---|
| 9 |
`descrip` text NOT NULL, |
|---|
| 10 |
`race` tinyint(4) NOT NULL default '0', |
|---|
| 11 |
`visibility` tinyint(4) NOT NULL default '1', |
|---|
| 12 |
`flags` varchar(60) NOT NULL default '', |
|---|
| 13 |
PRIMARY KEY (`id`) |
|---|
| 14 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|---|
