|
Revision f328b74996d55e5c1c40dc0bd3c12de224a1e75c, 490 bytes
(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 `factions_shop_entries` ( |
|---|
| 2 |
`id` smallint(5) unsigned NOT NULL auto_increment, |
|---|
| 3 |
`faction_id` int(11) NOT NULL default '-2', |
|---|
| 4 |
`type` tinyint(3) unsigned NOT NULL default '0', |
|---|
| 5 |
`resource` varchar(10) NOT NULL default '', |
|---|
| 6 |
`price` int(10) unsigned NOT NULL default '1', |
|---|
| 7 |
`availability` tinyint(3) unsigned NOT NULL default '0', |
|---|
| 8 |
`version` int(10) unsigned not null default '0', |
|---|
| 9 |
PRIMARY KEY (`id`), |
|---|
| 10 |
KEY `faction_id` (`faction_id`) |
|---|
| 11 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
|---|
