COMMAND LINE INTERFACE
=========================
sqlite3 database
.tables
.schema domain_name
.quit



CRUD
==========
CREATE TABLE domain_name( id INTEGER PRIMARY KEY, name TEXT, rating INTEGER DEFAULT 0, total_count INTEGER DEFAULT 0, average INTEGER DEFAULT 0);
SELECT * FROM posts WHERE title LIKE ? ORDER BY id DESC LIMIT 10 OFFSET 0
SELECT COUNT(*) as count FROM posts WHERE title LIKE '%hello%'
INSERT INTO posts (title, content) VALUES (?, ?)
UPDATE posts SET title = ?, content = ? WHERE id = ?
DELETE FROM posts WHERE id = ?


Add an id column, by create a temporary table, inserting old data, then dropping
================================
CREATE TABLE domain_name_swap( id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, rating INTEGER DEFAULT 0, total_count INTEGER DEFAULT 0, average INTEGER DEFAULT 0, views INTEGER DEFAULT 0, lookup INTEGER DEFAULT 0,nsfw_status INTEGER DEFAULT 0);

INSERT INTO domain_name_swap(name, rating,total_count,average) SELECT name, rating,total_count,average from domain_name;

delete from domain_name;
#delete from sqlite_sequence where name='domain_name'; if autoincrement

INSERT INTO domain_name(name, rating,total_count,average,views,lookup) SELECT name, rating,total_count,average,views,lookup FROM domain_name_swap;

drop table domain_name_swap;

vacuum



ADD COLUMNS TO EXISTING TABLE
================================
ALTER TABLE domain_name ADD COLUMN nsfw_status INTEGER DEFAULT 0
ALTER TABLE domain_name ADD COLUMN active_status INTEGER DEFAULT 1;
ALTER TABLE domain_name ADD COLUMN favicon_ico TEXT;
ALTER TABLE domain_name ADD COLUMN thumbnail_64 TEXT;


CREATE INDEX TO SPEED UP DATABASE
======================================
create index domain_name_id_idx on domain_name(id);
create index domain_name_name_idx on domain_name(name);