summaryrefslogtreecommitdiffstats
path: root/nodelist_db_create.sql
blob: 5efb336c95dab3e8425bf85e613742e27ac00e59 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
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", 2233, 0, 0);
insert into nodes values("159.253.18.46", 2299, 0, 0);
insert into nodes values("picapica.im", 2299, 0, 0);  
insert into nodes values("89.31.112.34", 2299, 0, 0);
insert into nodes values("picapica.ge", 2299, 0, 0);