equal
deleted
inserted
replaced
185 return sqltype |
185 return sqltype |
186 |
186 |
187 |
187 |
188 _SQL_SCHEMA = """ |
188 _SQL_SCHEMA = """ |
189 CREATE TABLE %(table)s ( |
189 CREATE TABLE %(table)s ( |
190 eid_from INTEGER NOT NULL, |
190 eid_from INTEGER NOT NULL REFERENCES entities (eid), |
191 eid_to INTEGER NOT NULL, |
191 eid_to INTEGER NOT NULL REFERENCES entities (eid), |
192 CONSTRAINT %(table)s_p_key PRIMARY KEY(eid_from, eid_to) |
192 CONSTRAINT %(table)s_p_key PRIMARY KEY(eid_from, eid_to) |
193 ); |
193 ); |
194 |
194 |
195 CREATE INDEX %(table)s_from_idx ON %(table)s(eid_from); |
195 CREATE INDEX %(table)s_from_idx ON %(table)s(eid_from); |
196 CREATE INDEX %(table)s_to_idx ON %(table)s(eid_to);""" |
196 CREATE INDEX %(table)s_to_idx ON %(table)s(eid_to);""" |