6 lines
497 B
Bash
Executable file
6 lines
497 B
Bash
Executable file
#!/bin/bash
|
|
sqlite3 ruscodb "create table users (username TEXT, password TEXT);"
|
|
sqlite3 ruscodb "insert into users (username, password) VALUES ('gabibbo','test');"
|
|
sqlite3 ruscodb "create table ruschi (id INTEGER PRIMARY KEY AUTOINCREMENT, type TEXT, nome TEXT, descrizione VARCHAR, foto TEXT, lat REAL, lng REAL);"
|
|
sqlite3 ruscodb "INSERT INTO ruschi (type, nome, descrizione, foto, lat, lng) VALUES ('random_type', 'random_nome', 'random_descrizione', 'random_foto.jpg', RANDOM(), RANDOM());"
|
|
|