Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Apr 28th, 2012  |  syntax: None  |  size: 0.30 KB  |  hits: 15  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. I need to link 2 tables but I'm baffled how (python/sqlite)
  2. """CREATE TABLE customer (id INTEGER PRIMARY KEY, name TEXT, percentage INTEGER)"""
  3.        
  4. """CREATE TABLE archive(week INTEGER, month TEXT, year VARCAR)"""
  5.        
  6. CREATE TABLE archive(customer integer references customer(id), week INTEGER,....)
create a new version of this paste RAW Paste Data