root/db/tables/factions_angebote_create.sql

Revision f328b74996d55e5c1c40dc0bd3c12de224a1e75c, 392 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_angebote` (
2   `id` tinyint(3) unsigned NOT NULL auto_increment,
3   `faction` int(11) NOT NULL default '-2',
4   `title` varchar(40) NOT NULL default '',
5   `image` varchar(100) NOT NULL default '',
6   `description` text NOT NULL,
7   `version` int(10) unsigned not null default '0',
8   PRIMARY KEY  (`id`)
9 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='GTU-Festpreisangebote';
Note: See TracBrowser for help on using the browser.