SQLite format 3@  {{@!%AJohn Kunzejakjak@ucop.edufoobar2008-07-25 09:53:44.726565A!%AEd Summersedsuedsu@loc.govapollo2008-07-25 09:53:44.725333 WWWAAACalifornia Digital Librarycdl2008-07-25 09:53:44.7293672008-07-25 09:53:44.729406N+AAAmerican Memoryammem2008-07-25 09:53:44.7283712008-07-25 09:53:44.728415   _LwtableusersusersCREATE TABLE users ( id INTEGER NOT NULL, name TEXT NOT NULL, username TEXT NOT NULL, email TEXT NOT NULL, password TEXT NOT NULL, created TIMESTAMP, PRIMARY KEY (id) )>##CtablecollectionscollectionsCREATE TABLE collections ( id INTEGER NOT NULL, name TEXT NOT NULL, code TEXT NOT NULL, created TIMESTAMP, updated TIMESTAMP, PRIMARY KEY (id) )UUtableusers_collections__collections_usersusers_collections__collections_usersCREATE TABLE users_collections__collections_users ( users_id INTEGER NOT NULL, collections_id INTEGER NOT NULL, PRIMARY KEY (users_id, collections_id), CONSTRAINT users_collections_fk FOREIGN KEY(users_id) REFERENCES users (id), CONSTRAINT collections_users_fk FOREIGN KEY(collections_id) REFERENCES collections (id) ) aa )UMAAultima-bag.zip8e7267fb-178f-4b28-8c73-819c2b3d51adbc179152e6bd460f30c8ec27864eaeect2008-07-25 10:20:22.7502052008-07-25 10:20:22.750288created 5Zg9indexix_packages_creator_idpackages CREATE INDEX ix_packages_creator_id ON packages (creator_id)p?indexix_packages_collection_idpackages CREATE INDEX ix_packages_collection_id ON packages (collection_id)g{Uindexsqlite_autoindex_users_collections__collections_users_1users_collections__collections_usersHctablepackagespackagesCREATE TABLE packages ( id INTEGER NOT NULL, filename TEXT NOT NULL, uuid TEXT NOT NULL, md5 TEXT, bytes INTEGER, created TIMESTAMP, updated TIMESTAMP, status TEXT, creator_id INTEGER, collection_id INTEGER, PRIMARY KEY (id), CONSTRAINT packages_creator_id_fk FOREIGN KEY(creator_id) REFERENCES users (id), CONSTRAINT packages_collection_id_fk FOREIGN KEY(collection_id) REFERENCES collections (id) )