1457 %s |
1457 %s |
1458 |
1458 |
1459 CREATE TABLE entities ( |
1459 CREATE TABLE entities ( |
1460 eid INTEGER PRIMARY KEY NOT NULL, |
1460 eid INTEGER PRIMARY KEY NOT NULL, |
1461 type VARCHAR(64) NOT NULL, |
1461 type VARCHAR(64) NOT NULL, |
1462 source VARCHAR(64) NOT NULL, |
1462 source VARCHAR(128) NOT NULL, |
1463 asource VARCHAR(64) NOT NULL, |
1463 asource VARCHAR(128) NOT NULL, |
1464 mtime %s NOT NULL, |
1464 mtime %s NOT NULL, |
1465 extid VARCHAR(256) |
1465 extid VARCHAR(256) |
1466 );; |
1466 );; |
1467 CREATE INDEX entities_type_idx ON entities(type);; |
1467 CREATE INDEX entities_type_idx ON entities(type);; |
1468 CREATE INDEX entities_mtime_idx ON entities(mtime);; |
1468 CREATE INDEX entities_mtime_idx ON entities(mtime);; |
1469 CREATE INDEX entities_extid_idx ON entities(extid);; |
1469 CREATE INDEX entities_extid_idx ON entities(extid);; |
1470 |
1470 |
1471 CREATE TABLE deleted_entities ( |
1471 CREATE TABLE deleted_entities ( |
1472 eid INTEGER PRIMARY KEY NOT NULL, |
1472 eid INTEGER PRIMARY KEY NOT NULL, |
1473 type VARCHAR(64) NOT NULL, |
1473 type VARCHAR(64) NOT NULL, |
1474 source VARCHAR(64) NOT NULL, |
1474 source VARCHAR(128) NOT NULL, |
1475 dtime %s NOT NULL, |
1475 dtime %s NOT NULL, |
1476 extid VARCHAR(256) |
1476 extid VARCHAR(256) |
1477 );; |
1477 );; |
1478 CREATE INDEX deleted_entities_type_idx ON deleted_entities(type);; |
1478 CREATE INDEX deleted_entities_type_idx ON deleted_entities(type);; |
1479 CREATE INDEX deleted_entities_dtime_idx ON deleted_entities(dtime);; |
1479 CREATE INDEX deleted_entities_dtime_idx ON deleted_entities(dtime);; |