gistfile1.sql

CREATE TABLE portage_packages (                                                 
        internal_db_package_id INTEGER PRIMARY KEY AUTOINCREMENT,               
        portage_package_key TEXT,                                               
        DEFINED_PHASES TEXT,                                                    
        DEPEND TEXT,                                                            
        DESCRIPTION TEXT,                                                       
        EAPI TEXT,                                                              
        HOMEPAGE TEXT,                                                          
        INHERITED TEXT,                                                         
        IUSE TEXT,                                                              
        KEYWORDS TEXT,                                                          
        LICENSE TEXT,                                                           
        PDEPEND TEXT,                                                           
        PROPERTIES TEXT,                                                        
        PROVIDE TEXT,                                                           
        RDEPEND TEXT,                                                           
        REQUIRED_USE TEXT,                                                      
        RESTRICT TEXT,                                                          
        SLOT TEXT,                                                              
        SRC_URI TEXT,                                                           
        _eclasses_ TEXT,                                                        
        _mtime_ TEXT,                                                           
        HDEPEND TEXT,                                                           
        UNIQUE(portage_package_key)                                             
);

CREATE TABLE sqlite_sequence(name,seq);