diff options
| author | me_desk <me_desk@fb96df88-216d-11de-830c-f3023f12d8ac> | 2012-08-13 22:34:10 +0000 |
|---|---|---|
| committer | me_desk <me_desk@fb96df88-216d-11de-830c-f3023f12d8ac> | 2012-08-13 22:34:10 +0000 |
| commit | 55ef99afd7118414c7379ab4de9d4bf6bce94b01 (patch) | |
| tree | b87cabc7e338e3d5a81eb1200e431ac33c5f13f3 /nodelist_db_create.sql | |
| parent | 66a561c45becb9b193353f97a22afdd88de3869b (diff) | |
| download | pica-pica-55ef99afd7118414c7379ab4de9d4bf6bce94b01.tar.gz pica-pica-55ef99afd7118414c7379ab4de9d4bf6bce94b01.zip | |
creating initial database during build process; README and LICENSE files added
git-svn-id: svn://localhost/project_picapica/trunk@163 fb96df88-216d-11de-830c-f3023f12d8ac
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); + |