Page MenuHomePhabricator
Files F35160367

DML Insert.sql
Rammanojpotla (Rammanojpotla)
Actions

Authored By
Rammanojpotla
May 21 2022, 11:34 AM
Size
3 KB
Referenced Files
None
Subscribers
None

DML Insert.sql
View Options

# 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");

File Metadata

Mime Type
text/plain
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
9458195
Default Alt Text
DML Insert.sql (3 KB)

Event Timeline

Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits