Tracks SQL

erb

tags

field :tag_name

other

        cd ~/dev/tracks/db
        sqlite3 tracks.db
        

        sqlite> .tables
        contexts                                               
        dependencies                                           
        notes                                                  
        open_id_authentication_associations                    
        open_id_authentication_nonces                          
        preferences                                            
        projects                                               
        recurring_todos                                        
        schema_migrations                  
        sessions                           
        taggings                           
        tags                               
        todos                              
        tolk_locales                       
        tolk_phrases                       
        tolk_translations                  
        users                              
        

        sqlite3 tracks.db '.schema projects'
        
        CREATE TABLE "projects" (
          "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, 
          "name" varchar(255) NOT NULL, 
          "position" integer, 
          "user_id" integer DEFAULT 1, 
          "description" text, 
          "state" varchar(20) NOT NULL, 
          "created_at" datetime, 
          "updated_at" datetime, 
          "default_context_id" integer, 
          "completed_at" datetime, 
          "default_tags" varchar(255), 
          "last_reviewed" datetime
        
        CREATE INDEX 
          "index_projects_on_user_id" ON "projects" 
            ("user_id");
        CREATE INDEX 
          "index_projects_on_user_id_and_name" ON "projects" 
            ("user_id", "name");
        CREATE INDEX 
          "index_projects_on_state" ON "projects" 
            ("state");
        CREATE INDEX 
          "index_projects_on_user_id_and_state" ON "projects" 
            ("user_id", "state");
        );