Mercurial > p > roundup > code
diff roundup/backends/back_sqlite.py @ 1836:94e430ad4fdb
make the RDBMS common backend and the SQLite and MYsql backend create...
...and drop indexes for the basic columns - index multilinks, index id and
retired columns of all class tables.
| author | Anthony Baxter <anthonybaxter@users.sourceforge.net> |
|---|---|
| date | Tue, 07 Oct 2003 07:17:54 +0000 |
| parents | 2fc7d4a8c9e7 |
| children | f255363e6d97 |
line wrap: on
line diff
--- a/roundup/backends/back_sqlite.py Tue Oct 07 06:18:45 2003 +0000 +++ b/roundup/backends/back_sqlite.py Tue Oct 07 07:17:54 2003 +0000 @@ -1,4 +1,4 @@ -# $Id: back_sqlite.py,v 1.9 2003-03-06 06:03:51 richard Exp $ +# $Id: back_sqlite.py,v 1.10 2003-10-07 07:17:54 anthonybaxter Exp $ __doc__ = ''' See https://pysqlite.sourceforge.net/ for pysqlite info ''' @@ -32,6 +32,7 @@ self.database_schema = {} self.cursor.execute('create table schema (schema varchar)') self.cursor.execute('create table ids (name varchar, num integer)') + self.cursor.execute('create index ids_name_idx on ids(name)') def close(self): ''' Close off the connection.