# contests
INSERT INTO contests VALUES (1, "Alva's college", "Ananth subray", STR_TO_DATE("25-01-2020 08:56", "%d-%m-%Y %H:%i:%s"), STR_TO_DATE("02-12-2019 14:16", "%d-%m-%Y %H:%i:%s"), STR_TO_DATE("30-12-2019 14:16", "%d-%m-%Y %H:%i:%s"), STR_TO_DATE("30-12-2019 11:16", "%d-%m-%Y %H:%i:%s"), false, 3, 1, "Kn");
INSERT INTO contests VALUES (2, "Robimass", "Jayantanth", STR_TO_DATE("28-01-2020 23:42", "%d-%m-%Y %H:%i:%s"), STR_TO_DATE("02-05-2019 05:09", "%d-%m-%Y %H:%i:%s"), STR_TO_DATE("16-07-2019 05:10", "%d-%m-%Y %H:%i:%s"), STR_TO_DATE("15-07-2019 12:16", "%d-%m-%Y %H:%i:%s"), false, 3, 1, "bn");

# contestAdmins
INSERT into ContestAdmin VALUES (1, "Ananth subray");
INSERT into ContestAdmin VALUES (2, "Jayantanth");
INSERT into ContestAdmin VALUES (2, "Ashwin");

# IndexPages
INSERT INTO IndexPages VALUES (1, "Index:ಮಾಲತಿ.djvu", "೧", 1);
INSERT INTO IndexPages VALUES (2, "Index:ಮಾಲತಿ.djvu", "೨", 0);
INSERT INTO IndexPages VALUES (3, "Index:ಮಾಲತಿ.djvu", "೩", 0);
INSERT INTO IndexPages VALUES (4, "Index:ಮಾಲತಿ.djvu", "೪", 0);
INSERT INTO IndexPages VALUES (5, "Index:ಮಾಲತಿ.djvu", "೫", 4);
INSERT INTO IndexPages VALUES (6, "Index:ಮಾಲತಿ.djvu", "೬", 4);
INSERT INTO IndexPages VALUES (7, "Index:ಮಾಲತಿ.djvu", "೭", 1);
INSERT INTO IndexPages VALUES (8, "নির্ঘণ্ট:গল্পগুচ্ছ (প্রথম খণ্ড).djvu", "৩১", 4);
INSERT INTO IndexPages VALUES (9, "নির্ঘণ্ট:গল্পগুচ্ছ (প্রথম খণ্ড).djvu", "৩১১", 0);
INSERT INTO IndexPages VALUES (10, "নির্ঘণ্ট:গল্পগুচ্ছ (দ্বিতীয় খণ্ড).djvu", "১", 1);
INSERT INTO IndexPages VALUES (11, "Index:ಮಾಲತಿ.djvu", "೭೬", 1);

# Insert to ContestIndices
INSERT INTO ContestIndices (id, cid, idbp, proofreader, proofread_time, p_revision_id) VALUES (1, 1, 1, "RammanojPotla", STR_TO_DATE("28-12-2019 23:42", "%d-%m-%Y %H:%i:%s"), 1);
INSERT INTO ContestIndices (id, cid, idbp, proofreader, proofread_time, validator, validate_time, p_revision_id, v_revision_id) VALUES (2, 1, 5, "GopaVasanth", STR_TO_DATE("27-12-2019 23:42", "%d-%m-%Y %H:%i:%s"), "Anand", STR_TO_DATE("28-12-2019 22:42", "%d-%m-%Y %H:%i:%s"), 1, 1);
INSERT INTO ContestIndices (id, cid, idbp, proofreader, proofread_time, validator, validate_time, p_revision_id, v_revision_id) VALUES (3, 1, 6, "Anand", STR_TO_DATE("28-12-2019 23:42", "%d-%m-%Y %H:%i:%s"), "RammanojPotla", STR_TO_DATE("29-12-2019 23:42", "%d-%m-%Y %H:%i:%s"), 1, 1);
INSERT INTO ContestIndices (id, cid, idbp, proofreader, proofread_time, p_revision_id) VALUES (4, 1, 7, "Vasanth", STR_TO_DATE("28-12-2019 1:42", "%d-%m-%Y %H:%i:%s"), 1);
INSERT INTO ContestIndices (id, cid, idbp, proofreader, proofread_time, p_revision_id) VALUES (5, 1, 8, "RammanojPotla", STR_TO_DATE("25-12-2019 1:42", "%d-%m-%Y %H:%i:%s"), 1);
INSERT INTO ContestIndices (id, cid, idbp, validator, validate_time, v_revision_id) VALUES (6, 2, 8, "Jay", STR_TO_DATE("06-06-2019 1:42", "%d-%m-%Y %H:%i:%s"), 2);
INSERT INTO ContestIndices (id, cid, idbp, proofreader, proofread_time, p_revision_id) VALUES (7, 2, 10, "Prakash", STR_TO_DATE("07-06-2019 1:42", "%d-%m-%Y %H:%i:%s"), 1);
INSERT INTO ContestIndices (id, cid, idbp, proofreader, proofread_time, p_revision_id) VALUES (8, 2, 11, "Jayantanth", STR_TO_DATE("04-06-2019 1:42", "%d-%m-%Y %H:%i:%s"), 1);


# Insert into UnlistedUser
INSERT INTO UnlistedUser VALUES (2, "Jayantanth");