diff options
Diffstat (limited to 'testing/hosts/default/etc/pts/tables.sql')
| -rw-r--r-- | testing/hosts/default/etc/pts/tables.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/testing/hosts/default/etc/pts/tables.sql b/testing/hosts/default/etc/pts/tables.sql index 4cc959e09..85db3188a 100644 --- a/testing/hosts/default/etc/pts/tables.sql +++ b/testing/hosts/default/etc/pts/tables.sql @@ -232,3 +232,12 @@ CREATE TABLE identities ( UNIQUE (type, value) ); +DROP TABLE IF EXISTS regids; +CREATE TABLE regids ( + id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + name TEXT NOT NULL +); +DROP INDEX IF EXISTS regids_name; +CREATE INDEX regids_name ON regids ( + name +); |