Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create table bestand.geraet
- (seriennr int(30) not null primary key,
- anlagenummer int(30) not null,
- macadresse varchar(17),
- bemerkungen varchar(100),
- liefernr int not null,
- personalnr int,
- status enum("auf Lager", "im Einsatz") default "auf Lager" not null);
- explain bestand.geraet
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement