FilesExpand file tree

 main

/

create_db.bash

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

14 lines (10 loc) · 292 Bytes

 main

/

create_db.bash

Copy path

Top

File metadata and controls

• Code
• Blame

14 lines (10 loc) · 292 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

#!/bin/bash

DB_NAME="tasks.db"

SQL_CREATE_TABLE="CREATE TABLE tasks (

id TEXT PRIMARY KEY NOT NULL,

name TEXT NOT NULL,

createdDate DATETIME DEFAULT CURRENT_TIMESTAMP,

status TEXT NOT NULL

);"

echo "Criando banco de dados: $DB_NAME..."

sqlite3 $DB_NAME "$SQL_CREATE_TABLE"