root/db/tables/ally_posten_create.sql

Revision f328b74996d55e5c1c40dc0bd3c12de224a1e75c, 316 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 `ally_posten` (
2   `id` int(11) NOT NULL auto_increment,
3   `ally` int(11) NOT NULL default '0',
4   `name` varchar(70) NOT NULL default 'Kein Name',
5   `version` int(10) unsigned not null default '0',
6   PRIMARY KEY  (`id`)
7 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Die verschiedenen Posten der Allys';
Note: See TracBrowser for help on using the browser.