diff options
Diffstat (limited to 'nodelist_db_create.sql')
| -rw-r--r-- | nodelist_db_create.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/nodelist_db_create.sql b/nodelist_db_create.sql new file mode 100644 index 0000000..c7c94dd --- /dev/null +++ b/nodelist_db_create.sql @@ -0,0 +1,13 @@ +-- create table schema and insert initial node addresses + +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("picapica.ge", 2299, 0, 0); + |