Mercurial > p > roundup > code
comparison roundup/backends/back_postgresql.py @ 2721:1cd01cf106e1
extend OTK and session table value cols to TEXT [SF#1031271]
| author | Richard Jones <richard@users.sourceforge.net> |
|---|---|
| date | Thu, 07 Oct 2004 06:30:20 +0000 |
| parents | 921780161fb9 |
| children | 402d6d556558 |
comparison
equal
deleted
inserted
replaced
| 2720:15d945dff53d | 2721:1cd01cf106e1 |
|---|---|
| 111 self.create_version_2_tables() | 111 self.create_version_2_tables() |
| 112 | 112 |
| 113 def create_version_2_tables(self): | 113 def create_version_2_tables(self): |
| 114 # OTK store | 114 # OTK store |
| 115 self.sql('''CREATE TABLE otks (otk_key VARCHAR(255), | 115 self.sql('''CREATE TABLE otks (otk_key VARCHAR(255), |
| 116 otk_value VARCHAR(255), otk_time REAL)''') | 116 otk_value TEXT, otk_time REAL)''') |
| 117 self.sql('CREATE INDEX otks_key_idx ON otks(otk_key)') | 117 self.sql('CREATE INDEX otks_key_idx ON otks(otk_key)') |
| 118 | 118 |
| 119 # Sessions store | 119 # Sessions store |
| 120 self.sql('''CREATE TABLE sessions ( | 120 self.sql('''CREATE TABLE sessions ( |
| 121 session_key VARCHAR(255), session_time REAL, | 121 session_key VARCHAR(255), session_time REAL, |
| 122 session_value VARCHAR(255))''') | 122 session_value TEXT)''') |
| 123 self.sql('''CREATE INDEX sessions_key_idx ON | 123 self.sql('''CREATE INDEX sessions_key_idx ON |
| 124 sessions(session_key)''') | 124 sessions(session_key)''') |
| 125 | 125 |
| 126 # full-text indexing store | 126 # full-text indexing store |
| 127 self.sql('CREATE SEQUENCE ___textids_ids') | 127 self.sql('CREATE SEQUENCE ___textids_ids') |