::ActiveRecord::Schema.define do create_table :api_users, :force => true do |t| t.string :name t.string :api_key end create_table :articles, :force => true do |t| t.string :title t.string :author t.text :body t.timestamps t.datetime :published_at t.boolean :deleted t.datetime :deleted_at t.string :slug t.integer :original_id end create_table :article_publications, :force => true do |t| t.integer :article_id t.integer :publication_id end create_table :bookmarks, :force => true do |t| t.string :title t.boolean :shared t.string :uri t.text :tags end create_table :comments, :force => true do |t| t.text :body t.integer :user_id t.timestamps end create_table :images, :force => true, :id => false do |t| t.string :md5hash, :length => 32 t.string :title t.text :description, :length => 1024 t.integer :width t.integer :height t.string :format t.time :taken_at end add_index :images, :md5hash, :unique => true create_table :network_nodes, :force => true do |t| t.string :ip_address t.integer :cidr_subnet_bits t.string :node_uuid end create_table :paragraphs, :force => true do |t| t.string :text t.integer :article_id t.timestamps end create_table :people, :force => true do |t| t.string :name t.text :positions t.text :inventions t.time :birthday t.text :interests t.string :password end create_table :software_packages, :force => true do |t| t.integer :node_number t.string :source_path t.string :destination_path t.string :product t.string :version t.datetime :released_at t.boolean :security_update t.datetime :installed_at t.string :installed_by end create_table :tickets, :force => true do |t| t.string :title t.text :body t.integer :status end create_table :tracks, :force => true do |t| t.string :artist t.string :name t.string :album t.string :musicbrainz_hash end add_index :tracks, [:artist, :album] add_index :tracks, :name add_index :tracks, :musicbrainz_hash, :unique => true create_table :tshirts, :force => true do |t| t.string :writing t.boolean :has_picture t.text :picture t.text :color t.text :size end create_table :users, :force => true, :id => false, :primary_key => :name do |t| t.string :name t.integer :age t.text :summary t.text :description t.boolean :admin t.integer :parent_id t.string :referrer_id end end