cubicweb/server/sources/native.py
changeset 11776 b49684ddd543
parent 11774 51c160677afe
child 11926 2deb9f6cbb7b
equal deleted inserted replaced
11775:39cf9e55ada8 11776:b49684ddd543
  1320     for sql in ("""
  1320     for sql in ("""
  1321 CREATE TABLE entities (
  1321 CREATE TABLE entities (
  1322   eid INTEGER PRIMARY KEY NOT NULL,
  1322   eid INTEGER PRIMARY KEY NOT NULL,
  1323   type VARCHAR(64) NOT NULL
  1323   type VARCHAR(64) NOT NULL
  1324 );;
  1324 );;
  1325 CREATE INDEX entities_type_idx ON entities(type);;
       
  1326 
  1325 
  1327 CREATE TABLE transactions (
  1326 CREATE TABLE transactions (
  1328   tx_uuid CHAR(32) PRIMARY KEY NOT NULL,
  1327   tx_uuid CHAR(32) PRIMARY KEY NOT NULL,
  1329   tx_user INTEGER NOT NULL,
  1328   tx_user INTEGER NOT NULL,
  1330   tx_time %s NOT NULL
  1329   tx_time %s NOT NULL