You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
5 lines
402 B
Bash
5 lines
402 B
Bash
#!/bin/sh
|
|
DBFILE="$1.cli.db"
|
|
sqlite3 $DBFILE 'create table if not exists followers (user integer, follower integer)'
|
|
sqlite3 $DBFILE '.mode tabs' ".import $1 followers"
|
|
sqlite3 $DBFILE 'create index if not exists followers_user ON followers(user);' 'create index if not exists followers_follower on followers(follower);' 'create unique index if not exists followers_unique on followers(user,follower);' |