crear_base_resto

#!/usr/bin/env python
# -*- coding: utf-8 -*-
#
import sqlite3

conn = sqlite3.connect("resto.db")
cursor = conn.cursor()

query = "CREATE TABLE categoria(\
    id INTEGER PRIMARY KEY AUTOINCREMENT,\
    nombre TEXT UNIQUE NOT NULL\
    )"

cursor.execute(query)

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.execute(query)

conn.close()