Node_First/create-table.js at main · fnguedes/Node_First · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

import { sql } from './db.js';

// sql`DROP TABLE IF EXISTS videos`
//    .then(() => {
//       console.log('Tabela apagada')
//    })

sql`
   CREATE TABLE videos (
        id TEXT PRIMARY KEY,
        title TEXT,
        description TEXT,
        duration INTEGER
      );`
   .then(() => {
      console.log('Tabela criada ')
   })