Piyush3dB · February 27, 2019 07:43
diff --git a/readme b/readme
 sqlite3
 .read schema.sql
 .read insert.sql
 .tables
 .schema
 .save sakila.db
 .quit


 SELECT name FROM sqlite_master WHERE type='table' ORDER BY name;

 .mode line
 .mode column
 .headers on

 PRAGMA table_info(table_name);





 #
 # Creating Tables
 #

 CREATE TABLE account(
    user_id serial PRIMARY KEY,
    username VARCHAR(50) UNIQUE NOT NULL,
    password VARCHAR(50) NOT NULL,
    email VARCHAR(355) UNIQUE NOT NULL,
    created_on TIMESTAMP NOT NULL,
    last_login TIMESTAMP
 );


 CREATE TABLE role(
    role_id serial PRIMARY KEY,
    role_name VARCHAR(255) UNIQUE NOT NULL
 );




diff --git a/sakila.db b/sakila.db
diff --git a/sqlite-sakila-delete-data.sql b/sqlite-sakila-delete-data.sql
diff --git a/sqlite-sakila-drop-objects.sql b/sqlite-sakila-drop-objects.sql
diff --git a/sqlite-sakila-insert-data.sql b/sqlite-sakila-insert-data.sql
diff --git a/sqlite-sakila-schema.sql b/sqlite-sakila-schema.sql
	sqlite3
	.read schema.sql
	.read insert.sql
	.tables
	.schema
	.save sakila.db
	.quit


	SELECT name FROM sqlite_master WHERE type='table' ORDER BY name;

	.mode line
	.mode column
	.headers on

	PRAGMA table_info(table_name);





	#
	# Creating Tables
	#

	CREATE TABLE account(
	user_id serial PRIMARY KEY,
	username VARCHAR(50) UNIQUE NOT NULL,
	password VARCHAR(50) NOT NULL,
	email VARCHAR(355) UNIQUE NOT NULL,
	created_on TIMESTAMP NOT NULL,
	last_login TIMESTAMP
	);


	CREATE TABLE role(
	role_id serial PRIMARY KEY,
	role_name VARCHAR(255) UNIQUE NOT NULL
	);