From 2e3ceb247fa63db0bbf9ba71f06be50eeda74445 Mon Sep 17 00:00:00 2001 From: Michael McVady Date: Sun, 29 Oct 2023 16:45:51 -0500 Subject: Refactor: `post` -> `entry` --- db/data.sql | 84 ++++++++++++++++++++++++++++++------------------------------- 1 file changed, 42 insertions(+), 42 deletions(-) (limited to 'db/data.sql') diff --git a/db/data.sql b/db/data.sql index b9b0b61..f1c426d 100644 --- a/db/data.sql +++ b/db/data.sql @@ -1,5 +1,5 @@ -INSERT INTO posts ( +INSERT INTO entries ( id, -- draft, title, @@ -649,47 +649,47 @@ And now to test that packaging works by packaging a project: ( 'b2fa3458-5457-4ade-8ce4-bd973bce7da5', 'SQLite Cheat Sheet', - 'Some notes on using SQLite - -Opening a database - - mcvady@b:/tmp$ sqlite3 sqlite.db - -Show tables - - sqlite> .tables - seq name file - --- --------------- ---------------------------------------------------------- - 0 main /tmp/sqlite.db - sqlite> .tables - acc globalblacklist purplemap - active_watchers grp re_grp - address htable rls_presentity - aliases imc_members rls_watchers - carrier_name imc_rooms sca_subscriptions - carrierfailureroute lcr_gw silo - carrierroute lcr_rule sip_trace - cpl lcr_rule_target speed_dial - -Describe a table - - sqlite> .schema TABLENAME - -Create a table - - sqlite> CREATE TABLE connection(connection_id BIGINT, username STRING); - -Insert into a table - - sqlite> INSERT INTO connection (connection_id, username) VALUES (1, ''mcvady''); - -Dump output into a file - - sqlite> .output SCHEMA_DUMP - sqlite> .schema - -Run SQL commands from file into a DB - + 'Some notes on using SQLite + +Opening a database + + mcvady@b:/tmp$ sqlite3 sqlite.db + +Show tables + + sqlite> .tables + seq name file + --- --------------- ---------------------------------------------------------- + 0 main /tmp/sqlite.db + sqlite> .tables + acc globalblacklist purplemap + active_watchers grp re_grp + address htable rls_presentity + aliases imc_members rls_watchers + carrier_name imc_rooms sca_subscriptions + carrierfailureroute lcr_gw silo + carrierroute lcr_rule sip_trace + cpl lcr_rule_target speed_dial + +Describe a table + + sqlite> .schema TABLENAME + +Create a table + + sqlite> CREATE TABLE connection(connection_id BIGINT, username STRING); + +Insert into a table + + sqlite> INSERT INTO connection (connection_id, username) VALUES (1, ''mcvady''); + +Dump output into a file + + sqlite> .output SCHEMA_DUMP + sqlite> .schema + +Run SQL commands from file into a DB + $ sqlite3 sqlite3.db < schema.sql', '2015-10-14 00:00:00', '2015-10-14 00:00:00' -- cgit v1.2.3