donpdonp/ircbr - Change JQP3ZAZUH7QEYXBTXJQVEC7BYGLTJ2ADN7OMA4BA2VWSMDEQOPVAC

sql fix

Created by on March 11, 2021

JQP3ZAZUH7QEYXBTXJQVEC7BYGLTJ2ADN7OMA4BA2VWSMDEQOPVAC

Dependencies

[2] ZCKVRPIBVIHJDJYHNIUUKSYPHNMC45YXGQKXMW4GGTKJEZSALGGQC
[3] 3ZE4YIXX3UAKYLD2EJSIX2DPHFUOF3TOUKBPHG4UKX4UOP7DPSEQC
[4] P55KFFWQA4XHWREYQ7OTR2EP2SFWHORAT4YKH22OZMYVNZUZQC6AC
[5] FZ626I2UNMFW4CQRQYE4PPAKU4ZNM2K4INLWMNWHR6JHOTZPF7UQC

In channels

main

Change contents

Replacement in src/db/db.v at line 25 [3.13]

B:BD[3.245] → [4.0:113]

B:BD[4.113] → [2.0:200]

	dbo.exec_oneshot('create table irc_servers if not exists (netname text primary key, hostname text, nick text)')
	dbo.exec_oneshot('create table irc_channels if not exists (chanel text primary key, netname text)')
	dbo.exec_oneshot('create table matrix_rooms if not exists (room_id text primary key, name text)')

[3.245]

[5.39]

	dbo.exec_oneshot('create table if not exists irc_servers (netname text primary key, hostname text, nick text)')
	dbo.exec_oneshot('create table if not exists irc_channels (chanel text primary key, netname text)')
	dbo.exec_oneshot('create table if not exists matrix_rooms (room_id text primary key, name text)')