Page MenuHomePhorge

v7.py
No OneTemporary

def patch(cur):
cur.execute('''
CREATE TABLE label_new (
id INTEGER PRIMARY KEY,
name TEXT NOT NULL UNIQUE COLLATE NOCASE,
hide BOOLEAN
)
''')
cur.execute('''
INSERT INTO label_new (id, name)
SELECT id, name FROM label
''')
cur.execute('DROP TABLE label')
cur.execute('ALTER TABLE label_new RENAME TO label')

File Metadata

Mime Type
text/x-script.python
Expires
Sun, Sep 20, 10:16 PM (17 h, 38 m ago)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
3536
Default Alt Text
v7.py (415 B)

Event Timeline