import os 
import sys 
from sqlalchemy import create_engine, Column, ForeignKey, Integer, String 
from sqlalchemy.orm import relationship 
from sqlalchemy.ext.declarative import declarative_base 

Base = declarative_base()

class Connectivity(Base):
	__tablename__ = 'connectivity'
	# define the columns for the table
	segment = Column(String(250),nullable=False)
	bridge_name = Column(String(250), nullable=False)
	port_id = Column(String(250),primary_key=True)
	location = Column(String(250))

# Create engine that stores data in the local directory's 
engine = create_engine('sqlite:///wim_info.db')

# Create the Table 
Base.metadata.create_all(engine)	

import os 
import sys 
from sqlalchemy import create_engine, Column, ForeignKey, Integer, String 
from sqlalchemy.orm import relationship 
from sqlalchemy.ext.declarative import declarative_base 

Base = declarative_base()

class Connectivity(Base):
	__tablename__ = 'connectivity'
	# define the columns for the table
	segment = Column(String(250),nullable=False)
	bridge_name = Column(String(250), nullable=False)
	port_id = Column(String(250))
	location = Column(String(250))

# Create engine that stores data in the local directory's 
engine = create_engine('sqlite:///wim_info.db')

# Create the Table 
Base.metadata.create_all(engine)	

remove primary key constraint