test

1
CREATE DATABASE if not exists onlinebookstore;
2

3
\c onlinebookstore
4

5
CREATE TABLE if not exists books 
6
  ( 
7
     barcode   VARCHAR(100) PRIMARY KEY, 
8
     name      TEXT NOT NULL, 
9
     author    VARCHAR(100) NOT NULL, 
10
     price     INT, 
11
     quantity  REAL
12
  ); 
13
  
14
  CREATE TABLE if not exists users
15
  ( 
16
     username  VARCHAR(100) PRIMARY KEY, 
17
     password  VARCHAR(100) NOT NULL, 
18
     firstname VARCHAR(100) NOT NULL, 
19
     lastname  VARCHAR(100) NOT NULL, 
20
     address   TEXT NOT NULL, 
21
     phone     VARCHAR(100) NOT NULL, 
22
     mailid    VARCHAR(100) NOT NULL,
23
     usertype  INT
24
  );