SQLite format 3 @ .
?^
B 8Ed \%/sindexnumber_indexnumber_key_valuesCREATE INDEX number_index ON number_key_values(key)T!+kindextext_indextext_key_valuesCREATE INDEX text_index ON text_key_values(key)<Sindexkey_indexkeysCREATE INDEX key_index ON keys(key)H
']indexspecies_indexspeciesCREATE INDEX species_index ON species(Z)W-uindexcalculator_indexsystems
CREATE INDEX calculator_index ON systems(calculator)Q)mindexusername_indexsystemsCREATE INDEX username_index ON systems(username)H
#aindexctime_indexsystemsCREATE INDEX ctime_index ON systems(ctime)T +qindexunique_id_indexsystems
CREATE INDEX unique_id_index ON systems(unique_id)[##tableinformationinformation CREATE TABLE information (
name TEXT,
value TEXT)*//tablenumber_key_valuesnumber_key_valuesCREATE TABLE number_key_values (
key TEXT,
value REAL,
id INTEGER,
FOREIGN KEY (id) REFERENCES systems(id))$++tabletext_key_valuestext_key_valuesCREATE TABLE text_key_values (
key TEXT,
value TEXT,
id INTEGER,
FOREIGN KEY (id) REFERENCES systems(id))sItablekeyskeysCREATE TABLE keys (
key TEXT,
id INTEGER,
FOREIGN KEY (id) REFERENCES systems(id))otablespeciesspeciesCREATE TABLE species (
Z INTEGER,
n INTEGER,
id INTEGER,
FOREIGN KEY (id) REFERENCES systems(id))P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)etablesystemssystemsCREATE TABLE systems (
id INTEGER PRIMARY KEY AUTOINCREMENT, -- ID's, timestamps and user name
unique_id TEXT UNIQUE,
ctime REAL,
mtime REAL,
username TEXT,
numbers BLOB, -- stuff that defines an Atoms object
positions BLOB,
cell BLOB,
pbc INTEGER,
initial_magmoms BLOB,
initial_charges BLOB,
masses BLOB,
tags BLOB,
momenta BLOB,
constraints TEXT, -- constraints and calculator
calculator TEXT,
calculator_parameters TEXT,
energy REAL, -- calculated properties
free_energy REAL,
forces BLOB,
stress BLOB,
dipole BLOB,
magmoms BLOB,
magmom REAL,
charges BLOB,
key_value_pairs TEXT, -- key-value pairs and data as json
data BLOB,
natoms INTEGER, -- stuff for making queries faster
fmax REAL,
smax REAL,
volume REAL,
mass REAL,
charge REAL)-A indexsqlite_autoindex_systems_1systems
e e ( M|, {,l c a0da3521c335a100edd3c66c5cdbd491@7~k@9Sxhecc O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O cՐ?[ Ac?D$]S*@ҩ+@7ۜ@_L&@F6@body@_L&@?ܵ$@V/@KԲE'@ m9@7ۜ@_L&@Cf!@@k &@cՐ@-C6
?k &@ek}$@˾+@KԲE'@@@k &@3hp*@V/@KԲE'@cՐ?[ Ac?䠄V"@&:@H@L1"@h@z3@L1"@ m9@t@(
<@F6@DQOi@!J@cՐ@?(
<@S:X@//>@(
<@GȰ!@鷯c@:dw@N]!@G ^/X?!J@6~$@WI@:dw@c]K'@鷯c@:dw@%j@ /@ cn@F6@B 3m@ cn@*Wx@ cn@'@ /@ cn@
K