summaryrefslogtreecommitdiffstats
path: root/nodelist_db_create.sql
blob: d114670166f2250d54789020e652ba24fbb8ae28 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
create table if not exists nodes 
                    (
                        address varchar(255) not null,
                        port int not null,
                        last_active int not null,
                        inactive_count int not null,
                        constraint pk primary key (address,port) on conflict replace 
                     );
insert into nodes values("picapica.im", 2299, 0, 0);  
insert into nodes values("91.202.255.68", 2299, 0, 0);
insert into nodes values("89.237.21.144", 2299, 0, 0);
insert into nodes values("89.31.112.34", 2299, 0, 0);
insert into nodes values("77.81.242.16", 2299, 0, 0);
insert into nodes values("159.253.18.46", 2299, 0, 0);
insert into nodes values("68.36.120.200", 2299, 0, 0);
insert into nodes values("picapica.ge", 2299, 0, 0);