diff options
Diffstat (limited to 'db/data.sql')
| -rw-r--r-- | db/data.sql | 84 |
1 files changed, 42 insertions, 42 deletions
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' |