schema.sql

DROP TABLE IF EXISTS Events;

CREATE TABLE Events(
    ID INTEGER PRIMARY KEY AUTOINCREMENT,
    _TITLE TEXT NOT NULL DEFAULT "Protest",
    _DESCRIPTION TEXT NOT NULL DEFAULT "Default Text",
    _TYPE TEXT,
    _ORGANIZER TEXT NOT NULL,
    _TIME DATE NOT NULL,
    _LOCATION TEXT NOT NULL
);

INSERT INTO Events (ID, _TITLE, _DESCRIPTION, _TYPE, _ORGANIZER, _TIME, _LOCATION) VALUES
(1, "Launch of Militarism Pamphlet", "The CYM are launching their new pamphlet on the rise of militarism. 2pm.", "Book Launch", "cym", '2025-02-14', "51.8979, -8.4706"),
(2, "Housing Justice Protest", "Join us in demanding affordable housing and tenants' rights in Cork City Centre.", "Protest", "sri", '2025-03-01', "51.8985, -8.4756"),
(3, "Marxist Reading Circle: Capital Vol. 1", "Weekly study session focusing on Chapter 3 of Marx's Capital. Bring your notes!", "Reading Group", "cpi", '2025-03-07', "51.8937, -8.4945"),
(4, "Solidarity Fundraiser for Gaza", "Community gathering and fundraiser for humanitarian relief efforts in Gaza.", "Fundraiser", "tromlach", '2025-03-10', "51.8976, -8.4761"),
(5, "Workers’ Rights Workshop", "Practical session on organizing your workplace and knowing your rights under Irish law.", "Workshop", "irsp", '2025-03-15', "53.3480, -6.2546"),
(6, "Film Screening: The Wind That Shakes the Barley", "A discussion follows on anti-imperialist struggles and their relevance today.", "Film Screening", "cpi", '2025-03-21', "51.8956, -8.4760"),
(7, "Public Talk: Climate Change and Capitalism", "Speaker panel discussing the root causes of the ecological crisis.", "Public Talk", "sri", '2025-03-25', "51.8980, -8.4750"),
(8, "Free Breakfast for Children Launch", "Community breakfast initiative inspired by the Black Panther Party.", "Community Event", "cym", '2025-04-01', "51.9123, -8.4974"),
(9, "May Day Organizing Meeting", "Preparations for the annual workers’ demonstration on May Day.", "Meeting", "tromlach", '2025-04-10', "51.8985, -8.4720"),
(10, "Book Club: The Wretched of the Earth", "Monthly radical reading circle focusing on Fanon's decolonial analysis.", "Book Club", "irsp", '2025-04-12', "51.8951, -8.4657"),
(11, "Tenant Solidarity Rally", "Gathering in support of evicted families and renters facing exploitation.", "Protest", "sri", '2025-04-20', "51.8975, -8.4708"),
(12, "Workshop on Political Education", "Learn how to facilitate Marxist education sessions in your community.", "Workshop", "cym", '2025-04-25', "51.8910, -8.4931"),
(13, "Poster-Making for May Day", "Creative evening preparing protest banners and posters.", "Workshop", "tromlach", '2025-04-27', "51.8969, -8.4762"),
(14, "Film Night: Land and Freedom", "Screening and discussion on class struggle in the Spanish Civil War.", "Film Screening", "cpi", '2025-04-29', "51.8970, -8.4748"),
(15, "Community Food Drive", "Collecting non-perishable food for struggling families in the northside.", "Mutual Aid", "irsp", '2025-05-02', "51.9130, -8.4869"),
(16, "May Day March", "Annual celebration of international workers’ solidarity.", "March", "sri", '2025-05-01', "51.8972, -8.4756"),
(17, "Panel: Women in the Irish Left", "Discussion featuring activists from across left organizations.", "Panel", "tromlach", '2025-05-09', "51.8987, -8.4768"),
(18, "Trade Union Organizing 101", "Introductory class on building strength in your workplace.", "Workshop", "cpi", '2025-05-15', "53.3498, -6.2603"),
(19, "Public Talk: Housing as a Human Right", "Examining capitalist control of land and property in Ireland.", "Public Talk", "sri", '2025-05-20', "51.8990, -8.4721"),
(20, "Solidarity Night for Striking Bus Drivers", "Music, speeches, and fundraising for striking transport workers.", "Fundraiser", "irsp", '2025-05-25', "51.8993, -8.4740"),

-- Dublin-based events (21–40)
(21, "Rally for Palestinian Liberation", "Join a mass demonstration in solidarity with Palestine.", "Protest", "sri", '2025-06-01', "53.3498, -6.2603"),
(22, "Reading Group: Lenin’s What Is to Be Done?", "Political study group exploring Lenin’s theory of organization.", "Reading Group", "cym", '2025-06-05', "53.3438, -6.2546"),
(23, "Trade Union Forum", "Discussion among rank-and-file trade unionists on grassroots strategy.", "Panel", "cpi", '2025-06-10', "53.3475, -6.2591"),
(24, "Screening: Sorry to Bother You", "Film and discussion on labor, race, and capitalism.", "Film Screening", "tromlach", '2025-06-15', "53.3392, -6.2601"),
(25, "Public Lecture: The History of the Irish Left", "Tracing revolutionary movements from Larkin to Connolly.", "Public Talk", "irsp", '2025-06-20', "53.3505, -6.2665"),
(26, "Dublin Housing March", "Mobilization for public housing and rent control legislation.", "March", "sri", '2025-07-01', "53.3480, -6.2546"),
(27, "Book Launch: Red Horizon", "Launch of new anthology on working-class literature in Ireland.", "Book Launch", "cpi", '2025-07-07', "53.3435, -6.2561"),
(28, "Workshop: Organizing Tenants’ Unions", "Learn how to build power in your community.", "Workshop", "cym", '2025-07-15', "53.3490, -6.2605"),
(29, "Fundraiser: Solidarity Night for Strikers", "Live music to raise funds for striking health workers.", "Fundraiser", "tromlach", '2025-07-20', "53.3456, -6.2621"),
(30, "Political Education Session: Dialectical Thinking", "Intro to dialectics in political and material analysis.", "Workshop", "cpi", '2025-07-25', "53.3488, -6.2620"),
(31, "Community Free Store", "Free clothes, books, and essentials for anyone in need.", "Mutual Aid", "irsp", '2025-08-01', "53.3422, -6.2675"),
(32, "Panel: Youth and Class Struggle", "Youth activists discuss organizing today.", "Panel", "cym", '2025-08-10', "53.3494, -6.2607"),
(33, "Feminist Reading Circle", "Exploring Marxist feminism and social reproduction theory.", "Reading Group", "tromlach", '2025-08-20', "53.3419, -6.2600"),
(34, "Anti-Racism March", "Stand against racism and fascism in Ireland.", "Protest", "sri", '2025-08-25', "53.3470, -6.2595"),
(35, "Irish Socialist Film Night", "Classic documentary screening: ‘Rocky Road to Dublin’.", "Film Screening", "cpi", '2025-08-29', "53.3478, -6.2609"),
(36, "Teach-In: The National Question Today", "Examining partition, sovereignty, and socialism.", "Teach-In", "irsp", '2025-09-01', "53.3462, -6.2578"),
(37, "Poster Workshop for Housing March", "Design and print posters for the upcoming protest.", "Workshop", "tromlach", '2025-09-10', "53.3458, -6.2622"),
(38, "Solidarity BBQ", "Community BBQ in support of striking workers.", "Community Event", "cym", '2025-09-15', "53.3499, -6.2612"),
(39, "Public Debate: Class vs. Identity Politics", "A critical discussion hosted by activists and academics.", "Debate", "sri", '2025-09-20', "53.3432, -6.2655"),
(40, "Film Night: Pride", "Screening of the 2014 film celebrating LGBT miners’ solidarity.", "Film Screening", "cpi", '2025-09-25', "53.3429, -6.2560"),

-- Scattered events across Ireland (41–100)
(41, "Galway Socialist Picnic", "A relaxed community meet-up for activists and friends.", "Community Event", "tromlach", '2025-06-14', "53.2707, -9.0568"),
(42, "Limerick Workers’ Assembly", "Discussion on regional trade union activity.", "Meeting", "cpi", '2025-06-20', "52.6638, -8.6267"),
(43, "Belfast March Against Austerity", "Protest against cuts to public services.", "March", "sri", '2025-06-28', "54.5970, -5.9301"),
(44, "Derry Peace and Justice Vigil", "Solidarity gathering for global peace.", "Vigil", "cym", '2025-07-02', "54.9971, -7.3090"),
(45, "Sligo Environmental Action Day", "Youth-led direct action against corporate pollution.", "Protest", "tromlach", '2025-07-08', "54.2697, -8.4694"),
(46, "Waterford Socialist Reading Group", "Reading Marx’s Critique of the Gotha Programme.", "Reading Group", "cpi", '2025-07-12', "52.2593, -7.1101"),
(47, "Tralee Free Breakfast Morning", "Serving breakfast to children and the elderly.", "Community Event", "irsp", '2025-07-18', "52.2716, -9.6982"),
(48, "Ennis Mutual Aid Meeting", "Local network meeting for solidarity initiatives.", "Meeting", "sri", '2025-07-22', "52.8467, -8.9800"),
(49, "Galway Film Screening: The Revolution Will Not Be Televised", "Venezuelan documentary with discussion.", "Film Screening", "cym", '2025-07-26', "53.2734, -9.0518"),
(50, "Limerick Food Solidarity Drive", "Community food collection and redistribution.", "Mutual Aid", "irsp", '2025-08-01', "52.6623, -8.6272"),
(51, "Athlone Public Talk: Trade Unionism Today", "Exploring the challenges facing unions in 2025.", "Public Talk", "cpi", '2025-08-05', "53.4239, -7.9407"),
(52, "Belfast Anti-War March", "Mobilization against NATO and imperialist expansion.", "Protest", "sri", '2025-08-11', "54.6010, -5.9285"),
(53, "Letterkenny Reading Group: Marx and Ecology", "Discussing metabolic rift and climate.", "Reading Group", "tromlach", '2025-08-16', "54.9542, -7.7345"),
(54, "Galway Mutual Aid Workshop", "Training in community self-organization.", "Workshop", "cym", '2025-08-21', "53.2762, -9.0515"),
(55, "Cavan Workers’ Cooperative Meetup", "Learning from cooperative models of production.", "Meeting", "cpi", '2025-08-26', "53.9908, -7.3606"),
(56, "Drogheda Housing Action Rally", "Demanding social housing expansion.", "Protest", "sri", '2025-09-02', "53.7170, -6.3475"),
(57, "Waterford Solidarity Concert", "Fundraising gig for striking nurses.", "Fundraiser", "irsp", '2025-09-06', "52.2604, -7.1100"),
(58, "Galway Climate and Class Panel", "Discussing eco-socialist approaches to climate.", "Panel", "tromlach", '2025-09-10', "53.2743, -9.0490"),
(59, "Kilkenny Reading Circle: Gramsci and Hegemony", "Discussion group on cultural struggle.", "Reading Group", "cpi", '2025-09-14', "52.6541, -7.2523"),
(60, "Belfast Political Education Night", "Interactive session on anti-imperialist theory.", "Workshop", "cym", '2025-09-18', "54.6022, -5.9299"),
(61, "Clonmel Community Meeting", "Residents organizing against rent hikes.", "Meeting", "sri", '2025-09-22', "52.3555, -7.7039"),
(62, "Cork Film Night: Persepolis", "Animated film on revolution and exile.", "Film Screening", "tromlach", '2025-09-26', "51.8977, -8.4729"),
(63, "Galway May Day Social", "Evening gathering following the May Day march.", "Social", "cpi", '2025-10-01', "53.2738, -9.0523"),
(64, "Belfast Free School Launch", "Community education initiative on socialist history.", "Launch", "irsp", '2025-10-05', "54.6020, -5.9295"),
(65, "Tralee Climate Action Forum", "Panel discussion on rural sustainability.", "Panel", "sri", '2025-10-09', "52.2697, -9.7030"),
(66, "Sligo Protest for Healthcare Funding", "Demanding investment in public health.", "Protest", "tromlach", '2025-10-13', "54.2702, -8.4688"),
(67, "Limerick Solidarity BBQ", "Food, music, and community solidarity.", "Community Event", "cym", '2025-10-17', "52.6613, -8.6261"),
(68, "Letterkenny Anti-Fascist Workshop", "Training in community defense and solidarity.", "Workshop", "cpi", '2025-10-21', "54.9527, -7.7348"),
(69, "Galway Labour History Talk", "Local historian presents the history of Galway trade unions.", "Public Talk", "tromlach", '2025-10-25', "53.2726, -9.0541"),
(70, "Waterford May Day March", "Regional celebration of workers’ day.", "March", "sri", '2025-11-01', "52.2618, -7.1060"),
(71, "Ennis Cultural Night", "Poetry and music celebrating working-class voices.", "Cultural Event", "cym", '2025-11-05', "52.8432, -8.9825"),
(72, "Cork Radical Book Fair", "Stalls, talks, and discussions on radical publishing.", "Book Fair", "cpi", '2025-11-09', "51.8970, -8.4752"),
(73, "Galway Free Store Day", "Sharing essentials freely among the community.", "Mutual Aid", "irsp", '2025-11-13', "53.2732, -9.0550"),
(74, "Belfast May Day Rally", "Annual demonstration for workers’ rights.", "March", "sri", '2025-11-17', "54.6025, -5.9281"),
(75, "Derry Socialist Film Club", "Screening of 'The Battle of Algiers'.", "Film Screening", "tromlach", '2025-11-21', "54.9968, -7.3100"),
(76, "Sligo Radical History Walk", "Guided walk exploring Sligo’s socialist past.", "Tour", "cpi", '2025-11-25', "54.2688, -8.4731"),
(77, "Limerick Free Breakfast Program", "Serving free breakfast to children before school.", "Community Event", "cym", '2025-11-29', "52.6620, -8.6250"),
(78, "Tralee Trade Union Skills Workshop", "Session on negotiation and solidarity tactics.", "Workshop", "irsp", '2025-12-03', "52.2724, -9.6998"),
(79, "Cavan Solidarity March", "Standing with asylum seekers and refugees.", "Protest", "sri", '2025-12-07', "53.9919, -7.3611"),
(80, "Waterford Socialist Picnic", "Outdoor gathering for local activists and families.", "Community Event", "tromlach", '2025-12-11', "52.2591, -7.1108"),
(81, "Galway Cooperative Fair", "Showcasing worker-owned cooperatives and local producers.", "Fair", "cpi", '2025-12-15', "53.2729, -9.0517"),
(82, "Derry Panel on Anti-Imperialism", "Debate on global resistance to imperialism.", "Panel", "irsp", '2025-12-19', "54.9975, -7.3087"),
(83, "Limerick Anti-Racism Workshop", "Training for activists to combat racism in Ireland.", "Workshop", "tromlach", '2025-12-23', "52.6610, -8.6269"),
(84, "Letterkenny Solidarity March", "Community march against austerity and inequality.", "March", "sri", '2025-12-27', "54.9517, -7.7351"),
(85, "Galway Study Group: Rosa Luxemburg", "Discussing revolutionary democracy and spontaneity.", "Reading Group", "cym", '2025-12-29', "53.2735, -9.0521"),
(86, "Belfast Radical Publishing Fair", "Independent publishers and booksellers showcase socialist literature.", "Book Fair", "cpi", '2025-12-30', "54.6018, -5.9288"),
(87, "Ennis Solidarity Music Night", "Live folk and protest songs to support a strike fund.", "Fundraiser", "irsp", '2025-12-31', "52.8450, -8.9833"),
(88, "Tralee Film Night: Bread and Roses", "Screening about immigrant janitors’ strike.", "Film Screening", "sri", '2025-06-03', "52.2703, -9.7005"),
(89, "Galway Marxist Economics Seminar", "Exploring the labor theory of value.", "Seminar", "cpi", '2025-06-07', "53.2737, -9.0506"),
(90, "Limerick Art for the People Exhibition", "Art show highlighting social struggle themes.", "Exhibition", "tromlach", '2025-06-11', "52.6629, -8.6262"),
(91, "Waterford Anti-Eviction Rally", "Standing with tenants facing eviction.", "Protest", "sri", '2025-06-17', "52.2614, -7.1072"),
(92, "Cork Radical History Lecture", "Talk on the legacy of Irish socialist movements.", "Public Talk", "cpi", '2025-06-23', "51.8981, -8.4755"),
(93, "Galway Volunteer Day", "Organizing mutual aid and solidarity work.", "Community Event", "cym", '2025-06-29', "53.2731, -9.0520"),
(94, "Derry Commemoration of Connolly", "Annual remembrance and wreath laying.", "Commemoration", "irsp", '2025-07-04', "54.9973, -7.3085"),
(95, "Belfast Climate March", "Join us to demand a just transition.", "March", "sri", '2025-07-09', "54.6009, -5.9291"),
(96, "Tralee Reading Circle: Engels on the Family", "Study group on Engels’ analysis of private property and gender.", "Reading Group", "tromlach", '2025-07-13', "52.2712, -9.6994"),
(97, "Galway Solidarity Café", "Open café space for political discussion and networking.", "Community Event", "cym", '2025-07-17', "53.2725, -9.0532"),
(98, "Limerick Workers’ Assembly", "Coordination meeting for union activists.", "Meeting", "cpi", '2025-07-21', "52.6624, -8.6271"),
(99, "Sligo Anti-War Vigil", "Silent vigil against militarism and occupation.", "Vigil", "sri", '2025-07-25', "54.2700, -8.4710"),
(100, "Waterford Marxist Film Night", "Screening of 'Battleship Potemkin' with analysis.", "Film Screening", "cpi", '2025-07-29', "52.2598, -7.1102");

DROP TABLE IF EXISTS Organizations;

CREATE TABLE Organizations(
    ID INTEGER PRIMARY KEY AUTOINCREMENT,
    _NAME TEXT NOT NULL DEFAULT "Protest",
    _TYPE TEXT NOT NULL DEFAULT "Political Party"
);

INSERT INTO Organizations(ID, _NAME, _TYPE) VALUES
(0, "Social Rights Ireland", "Political Organization"),
(1, "Connolly Youth Movement", "Political Movement");

DROP TABLE IF EXISTS Users;

CREATE TABLE Users(
    ID INTEGER PRIMARY KEY AUTOINCREMENT,
    _USERNAME TEXT NOT NULL,
    _PASSWORD TEXT NOT NULL,
    _ORGANIZATION INTEGER NOT NULL DEFAULT 0
);

INSERT INTO Users(_USERNAME, _PASSWORD, _ORGANIZATION) VALUES
("cym", "scrypt:32768:8:1$RYuiN81j1RjUGvUV$a5f4bc3c1a4aa11678df97b1b62d89bcf5b9d51df4dbf85d996d6087aa89605a37d16cda7a9a7bcf019f7c5f259a72141da5c167b4208637613113f7a24a4ded", 1);