INSERT

/* Création d'un utilisateur porteur de projet avec 1 projet + 2 contreparties */

INSERT INTO `user` (`id`, `email`, `pseudo`, `date`, `password`, `mail_valid`) VALUES (NULL, 'perlimpimpin@elysee.fr', 'manumacron', CURRENT_TIMESTAMP, 'mypassword', '0');


/* Modifier le id_user en mettant le même que le user crée ci-dessus */
INSERT INTO `project_holder` (`id`, `date`, `id_user`, `name`, `first_name`, `avatar`, `iban`, `siret`, `kbis`, `phone`, `status`, `ident_card`, `active`) VALUES (NULL, CURRENT_TIMESTAMP, 'ECRIRE ICI LE ID USER', 'MACRON', 'Emmanuel', '/assets/img/default.png', 'FR7630004017900000056897248', '51136363200049', '/uploaded/kbisndi.pdf', '0698810574', 'Entreprise', '/uploaded/cnindi.pdf', '1');

INSERT INTO `project` (`id`, `id_project_holder`, `date`, `title`, `short_description`, `description`, `picture1`, `picture2`, `picture3`, `sponsors`, `amount`, `little_picture`, `dead_line`, `launch_date`, `website`, `facebook`, `twitter`, `instagram`, `linkedin`, `nb_jobs`, `end_funding_date`, `step_form`, `general_interest`, `active`) VALUES (NULL, 'ECRIRE ICI LE ID PROJECT HOLDER', CURRENT_TIMESTAMP, 'Bottines chics et solidaires', 'Help us to launch of our first winter collection of chic and social boots designed in Paris and handcrafted in Mexico !', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin imperdiet tortor sed odio pharetra, at convallis justo ornare. Suspendisse potenti. Vivamus semper pellentesque massa a efficitur. Suspendisse porttitor non leo non varius. Praesent quam dolor, finibus non rutrum quis, egestas vitae metus. Donec fermentum, tortor at elementum ultricies, mi ante pretium orci, eu facilisis enim est eu turpis. Vivamus ornare lorem ut quam luctus, et rhoncus massa scelerisque. Pellentesque maximus, diam nec porttitor cursus, mauris lorem euismod mauris, in venenatis ex nulla non purus. Fusce ultrices maximus aliquam. Sed laoreet ipsum sem, tincidunt fermentum erat faucibus ultrices. Nulla euismod quam ut velit pellentesque, et elementum metus eleifend. Cras ut mi vel est tincidunt pellentesque. Vivamus feugiat scelerisque orci, sit amet hendrerit turpis dignissim sit amet. Nulla aliquet ipsum vel enim posuere, sit amet lobortis sapien ultrices. Suspendisse mollis rhoncus sem, vel aliquam erat iaculis lacinia. Proin feugiat lorem et bibendum ornare. ', 'assets/img/pic1.jpg', 'assets/img/pic2.jpg', 'assets/img/pic3.jpg', 'Crédit apporté par le conseil régional : 6000 €', '9000', 'assets/img/littlepic.jpg', '2017-11-15', '2017-10-31', 'https://www.tapatia.co/', 'https://www.facebook.com/tapatia.co', 'https://www.twitter.com/tapatia', 'https://www.instagram.com/tapatiabrand/', 'https:/linkedin.fr/tapiata', '2', NULL, '0', '0', '1');

INSERT INTO `pledge` (`id`, `id_project`, `amount`, `description`, `qty_max`, `picture`) VALUES (NULL, 'ECRIRE ICI LE ID PROJECT', '30', 'Un grand MERCI + un accessoire artisanal Huichol au choix: marque-page ou bracelet ou porte-clé. ', '50', '/assets/img/pledge_default.png');

INSERT INTO `pledge` (`id`, `id_project`, `amount`, `description`, `qty_max`, `picture`) VALUES (NULL, 'ECRIRE ICI LE MEME ID PROJECT QUE DESSUS', '139', 'A big THANK YOU + one pair of Women boots "Mazamitla" (regular price after the campaign : 229€). 4 colours : beige, burgundy, brown, black. Sizes from 36 to 41. We will contact you by email for the size and the colour. Shipping cost included for France ! 5€ for the European Union 10€ for the rest of the world', '20', '/assets/img/pledge_default.png');