Untitled

Alter table `PersonType` add Constraint `Hej` Foreign Key (`PersonTypeID`) references `Person` (`PersonTypeID`) on delete restrict on update restrict;

INSERT INTO `Person` (
`PersonID`,
`PersonNumer`,
`Title`,
`FirstName`,
`LastName`,
`CompanyName`,
`Active`,
`PartnerReferenceID`,
`ParentPersonID`,
`AllowCommercial`,
`Created`,
`Changed`,
`ChangedByPersonID`,
`AgreementID`,
`AgreementTypeID`,
`PersonTypeID`)

values(
0,
0,
'Mr.',
'Kasper',
'Sandin',
'LOL',
0,
0,
0,
0,
NOW(),
NOW(),
0,
0,
0,
0);


INSERT INTO `PersonType`
(`PersonTypeID`,
`Name`,
`Description`)

values(0,
'CoolGuy',
'A very cool guy');

DELETE FROM `Person` WHERE 1;