Database location

Like other Camping applications, Parkplace will create a database file at ~/.parkplace/park.db in your home directory.

Data model for Park Place

Tables created by Park Place:

  create_table :parkplace_bits do |t|
      t.column :id,        :integer,  :null => false
      t.column :owner_id,  :integer
      t.column :parent_id, :integer
      t.column :lft,       :integer
      t.column :rgt,       :integer
      t.column :type,      :string,   :limit => 6
      t.column :name,      :string,   :limit => 255
      t.column :created_at, :timestamp
      t.column :updated_at, :timestamp
      t.column :access,    :integer
      t.column :meta,      :text
      t.column :obj,       :text
  end
  create_table :parkplace_users do |t|
      t.column :id,             :integer,  :null => false
      t.column :login,          :string,   :limit => 40
      t.column :password,       :string,   :limit => 40
      t.column :email,          :string,   :limit => 64
      t.column :key,            :string,   :limit => 64
      t.column :secret,         :string,   :limit => 64
      t.column :created_at,     :datetime
      t.column :activated_at,   :datetime
      t.column :deleted,        :integer, :default => 0
  end
  create_table :parkplace_bits_users do |t|
      t.column :bit_id,  :integer
      t.column :user_id, :integer
      t.column :access,  :integer
  end