Mercurial > p > roundup > code
comparison roundup/backends/back_postgresql.py @ 2722:8140fb128088 maint-0.7
merge from HEAD
| author | Richard Jones <richard@users.sourceforge.net> |
|---|---|
| date | Thu, 07 Oct 2004 06:33:57 +0000 |
| parents | e4f06fcbbc89 |
| children | 4dd01588db90 |
comparison
equal
deleted
inserted
replaced
| 2718:b97aa2a9a504 | 2722:8140fb128088 |
|---|---|
| 120 self.create_version_2_tables() | 120 self.create_version_2_tables() |
| 121 | 121 |
| 122 def create_version_2_tables(self): | 122 def create_version_2_tables(self): |
| 123 # OTK store | 123 # OTK store |
| 124 self.cursor.execute('''CREATE TABLE otks (otk_key VARCHAR(255), | 124 self.cursor.execute('''CREATE TABLE otks (otk_key VARCHAR(255), |
| 125 otk_value VARCHAR(255), otk_time REAL)''') | 125 otk_value TEXT, otk_time REAL)''') |
| 126 self.cursor.execute('CREATE INDEX otks_key_idx ON otks(otk_key)') | 126 self.cursor.execute('CREATE INDEX otks_key_idx ON otks(otk_key)') |
| 127 | 127 |
| 128 # Sessions store | 128 # Sessions store |
| 129 self.cursor.execute('''CREATE TABLE sessions ( | 129 self.cursor.execute('''CREATE TABLE sessions ( |
| 130 session_key VARCHAR(255), session_time REAL, | 130 session_key VARCHAR(255), session_time REAL, |
| 131 session_value VARCHAR(255))''') | 131 session_value TEXT)''') |
| 132 self.cursor.execute('''CREATE INDEX sessions_key_idx ON | 132 self.cursor.execute('''CREATE INDEX sessions_key_idx ON |
| 133 sessions(session_key)''') | 133 sessions(session_key)''') |
| 134 | 134 |
| 135 # full-text indexing store | 135 # full-text indexing store |
| 136 self.cursor.execute('CREATE SEQUENCE ___textids_ids') | 136 self.cursor.execute('CREATE SEQUENCE ___textids_ids') |