testData.sql

-- Insert Into User Table --
INSERT INTO PixelGram.tbl_user VALUES (1, 'thomas', 'thomas@yates.com', 'pbkdf2:sha1:1000$Ncic2XNs$805e1cd6eaa8a74fbfa3777f062fc48f8f5440ea');
INSERT INTO PixelGram.tbl_user VALUES (2, 'james', 'james@bream.com', 'pbkdf2:sha1:1000$r69rBdOG$86aaf5987dc73336c0c1dc29fd7d6b82c28b044c');
INSERT INTO PixelGram.tbl_user VALUES (3, 'Elena', 'elena@tsanacheva.com', 'pbkdf2:sha1:1000$KEpyTNkH$8389199fea718d0d4a0758893fe888687dcb4c15');

-- Insert Into Post Table --
INSERT INTO PixelGram.tbl_post VALUES (1, 'test1', 'Posting Test 1', 1, '2016-03-28 08:11:55', NULL);
INSERT INTO PixelGram.tbl_post VALUES (2, 'test2', 'Posting Test 2', 1, '2016-03-28 10:04:31', NULL);
INSERT INTO PixelGram.tbl_post VALUES (3, 'test3', 'Posting Test 3', 1, '2016-03-28 16:24:13', NULL);
INSERT INTO PixelGram.tbl_post VALUES (4, 'test1', 'Posting Test 1', 2, '2016-03-21 09:12:25', NULL);
INSERT INTO PixelGram.tbl_post VALUES (5, 'test2', 'Posting Test 2', 2, '2016-03-22 10:59:10', NULL);
INSERT INTO PixelGram.tbl_post VALUES (6, 'test3', 'Posting Test 3', 2, '2016-03-20 15:55:25', NULL);
INSERT INTO PixelGram.tbl_post VALUES (7, 'test1', 'Posting Test 1', 3, '2016-03-22 04:37:59', NULL);
INSERT INTO PixelGram.tbl_post VALUES (8, 'test2', 'Posting Test 2', 3, '2016-03-18 07:42:31', NULL);
INSERT INTO PixelGram.tbl_post VALUES (9, 'test3', 'Posting Test 3', 3, '2016-03-22 21:57:02', NULL);