Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/usr/bin/env python
- # -*- coding: utf-8 -*-
- #
- import sqlite3
- conn = sqlite3.connect("restaurante.db")
- query = "CREATE TABLE categoria(\
- id INTEGER PRIMARY KEY AUTOINCREMENT,\
- nombre TEXT UNIQUE NOT NULL\
- )"
- cursor = conn.cursor()
- cursor.execute(query)
- conn.commit()
- query = "CREATE TABLE platos(\
- id INTEGER PRIMARY KEY AUTOINCREMENT,\
- nombre TEXT UNIQUE NOT NULL,\
- id_categoria INTEGER NOT NULL,\
- FOREIGN KEY(id_categoria) REFERENCES categoria(id)\
- )"
- cursor = conn.cursor()
- cursor.execute(query)
- conn.commit()
- conn.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement