db.sqlar_skeleton: Initialize the SQLite archive schema
In blueraleigh/db: An R interface to SQLite

db.sqlar_skeleton

R Documentation

Initialize the SQLite archive schema

Description

Initialize the SQLite archive schema

Usage

db.sqlar_skeleton(db, name)

Arguments

`db`	The database connection. S4 object of class "database".
`name`	The name of the SQLite archive table.

Details

This has a side effect of creating a table named "sqlar" in the database file pointed to by db. The sqlar table has the following schema:

    CREATE TABLE sqlar(
        name  TEXT PRIMARY KEY, -- name of the file
        mode  INTEGER,          -- access permissions
        mtime INTEGER,          -- last modification time
        sz    INTEGER,          -- original file size
        data  BLOB              -- compressed content
    );