<s> """<STR_LIT>""" <EOL> from __future__ import print_function <EOL> from __future__ import unicode_literals <EOL> from __future__ import division <EOL> from pytz import timezone <EOL> from datetime import datetime <EOL> from sqlalchemy import * <EOL> from pycopia . db . types import * <EOL> UTC = timezone ( '<STR_LIT>' ) <EOL> def time_now ( ) : <EOL> return datetime . now ( UTC ) <EOL> def default_active ( ) : <EOL> return True <EOL> def default_inactive ( ) : <EOL> return False <EOL> def default_obj ( x ) : <EOL> return lambda : x <EOL> metadata = MetaData ( ) <EOL> auth_message = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT:message>' , TEXT ( length = None , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' , <EOL> onupdate = "<STR_LIT>" , ondelete = "<STR_LIT>" ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , auth_message . c . user_id , unique = False ) <EOL> client_session = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT:data>' , PickleText ( ) , primary_key = False , nullable = False , default = default_obj ( { } ) ) , <EOL> Column ( '<STR_LIT>' , TIMESTAMP ( timezone = True ) , primary_key = False , nullable = False ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , client_session . c . session_key , unique = True ) <EOL> project_category = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT:name>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , project_category . c . name , unique = True ) <EOL> config = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT:name>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT:value>' , PickleText ( ) , primary_key = False , nullable = True , default = default_obj ( None ) ) , <EOL> Column ( '<STR_LIT>' , TEXT ( length = None , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' , <EOL> onupdate = "<STR_LIT>" , ondelete = "<STR_LIT>" ) , <EOL> UniqueConstraint ( "<STR_LIT:name>" , "<STR_LIT>" ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , config . c . testcase_id , unique = False ) <EOL> Index ( '<STR_LIT>' , config . c . name , config . c . parent_id , unique = True ) <EOL> Index ( '<STR_LIT>' , config . c . parent_id , unique = False ) <EOL> Index ( '<STR_LIT>' , config . c . user_id , unique = False ) <EOL> Index ( '<STR_LIT>' , config . c . testsuite_id , unique = False ) <EOL> contacts = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT:15> , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT:50> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT:50> , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT:50> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT:title>' , VARCHAR ( length = <NUM_LIT:50> , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT:100> , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT:email>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , TEXT ( length = None , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' , <EOL> onupdate = "<STR_LIT>" , ondelete = "<STR_LIT>" ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , contacts . c . address_id , unique = False ) <EOL> Index ( '<STR_LIT>' , contacts . c . lastname , unique = False ) <EOL> Index ( '<STR_LIT>' , contacts . c . user_id , unique = False ) <EOL> corp_attribute_type = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT:name>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT:description>' , TEXT ( length = None , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , ValueType ( ) , primary_key = False , nullable = False , default = ValueType . get_default ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , corp_attribute_type . c . name , unique = True ) <EOL> corp_attributes = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT:value>' , PickleText ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> UniqueConstraint ( "<STR_LIT>" , "<STR_LIT>" ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , corp_attributes . c . type_id , unique = False ) <EOL> Index ( '<STR_LIT>' , corp_attributes . c . corporation_id , unique = False ) <EOL> account_ids = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT:password>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , TEXT ( length = None , convert_unicode = False ) , primary_key = False ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , account_ids . c . identifier , unique = False ) <EOL> addresses = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT:address>' , TEXT ( length = None , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , TEXT ( length = None , convert_unicode = False ) , primary_key = False , nullable = True ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False , nullable = True ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False , nullable = True ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT:15> , convert_unicode = False ) , primary_key = False , nullable = True ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , addresses . c . country_id , unique = False ) <EOL> capability_group = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT:name>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , capability_group . c . name , unique = True ) <EOL> capability_type = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT:name>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT:description>' , TEXT ( length = None , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , ValueType ( ) , primary_key = False , nullable = False , default = ValueType . get_default ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , capability_type . c . name , unique = True ) <EOL> Index ( '<STR_LIT>' , capability_type . c . group_id , unique = False ) <EOL> capability = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT:value>' , PickleText ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' , <EOL> onupdate = "<STR_LIT>" , ondelete = "<STR_LIT>" ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , capability . c . equipment_id , unique = False ) <EOL> Index ( '<STR_LIT>' , capability . c . type_id , unique = False ) <EOL> location = Table ( '<STR_LIT:location>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' , <EOL> onupdate = "<STR_LIT>" , ondelete = "<STR_LIT>" ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , location . c . address_id , unique = False ) <EOL> Index ( '<STR_LIT>' , location . c . contact_id , unique = False ) <EOL> attribute_type = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT:name>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT:description>' , TEXT ( length = None , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , ValueType ( ) , primary_key = False , nullable = False , default = ValueType . get_default ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , attribute_type . c . name , unique = True ) <EOL> software_attributes = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT:value>' , PickleText ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> UniqueConstraint ( "<STR_LIT>" , "<STR_LIT>" ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , software_attributes . c . software_id , unique = False ) <EOL> Index ( '<STR_LIT>' , software_attributes . c . type_id , unique = False ) <EOL> environmentattribute_type = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT:name>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT:description>' , TEXT ( length = None , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , ValueType ( ) , primary_key = False , nullable = False , default = ValueType . get_default ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , environmentattribute_type . c . name , unique = True ) <EOL> environment_attributes = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT:value>' , PickleText ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> UniqueConstraint ( "<STR_LIT>" , "<STR_LIT>" ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , environment_attributes . c . environment_id , unique = False ) <EOL> Index ( '<STR_LIT>' , environment_attributes . c . type_id , unique = False ) <EOL> test_jobs = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT:name>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False , <EOL> nullable = False , default = default_obj ( "<STR_LIT:email>" ) ) , <EOL> Column ( '<STR_LIT>' , TEXT ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , BOOLEAN ( ) , primary_key = False , nullable = False , default = default_inactive ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' , <EOL> onupdate = "<STR_LIT>" , ondelete = "<STR_LIT>" ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , test_jobs . c . user_id , unique = False ) <EOL> Index ( '<STR_LIT>' , test_jobs . c . testsuite_id , unique = False ) <EOL> Index ( '<STR_LIT>' , test_jobs . c . name , unique = False ) <EOL> Index ( '<STR_LIT>' , test_jobs . c . schedule_id , unique = False ) <EOL> Index ( '<STR_LIT>' , test_jobs . c . environment_id , unique = False ) <EOL> Index ( '<STR_LIT>' , test_jobs . c . name , test_jobs . c . user_id , unique = True ) <EOL> schedule = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT:name>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' , <EOL> onupdate = "<STR_LIT>" , ondelete = "<STR_LIT>" ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , schedule . c . user_id , unique = False ) <EOL> test_results_data = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT:data>' , JsonText ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT:255> , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' , <EOL> onupdate = "<STR_LIT>" , ondelete = "<STR_LIT>" ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , test_results_data . c . id , unique = True ) <EOL> Index ( '<STR_LIT>' , test_results_data . c . test_results_id , unique = True ) <EOL> test_results = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT:255> , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT:255> , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , TestObjectType ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , TIMESTAMP ( timezone = True ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , TIMESTAMP ( timezone = True ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT:255> , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT:result>' , TestResultType ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , TEXT ( length = None , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT:255> , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT:255> , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , TEXT ( length = None , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , BOOLEAN ( ) , primary_key = False , nullable = False , default = default_active ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' , <EOL> onupdate = "<STR_LIT>" , ondelete = "<STR_LIT>" ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , test_results . c . testcase_id , unique = False ) <EOL> Index ( '<STR_LIT>' , test_results . c . build_id , unique = False ) <EOL> Index ( '<STR_LIT>' , test_results . c . parent_id , unique = False ) <EOL> Index ( '<STR_LIT>' , test_results . c . tester_id , unique = False ) <EOL> Index ( '<STR_LIT>' , test_results . c . testimplementation , unique = False ) <EOL> Index ( '<STR_LIT>' , test_results . c . environment_id , unique = False ) <EOL> Index ( '<STR_LIT>' , test_results . c . testsuite_id , unique = False ) <EOL> traps = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT>' , TIMESTAMP ( timezone = True ) , primary_key = False , nullable = False , <EOL> default = time_now ) , <EOL> Column ( '<STR_LIT>' , PickleText ( ) , primary_key = False , nullable = False ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , traps . c . id , unique = True ) <EOL> cookies = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT:name>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT:value>' , TEXT ( length = None , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT:255> , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT:255> , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT:path>' , VARCHAR ( length = <NUM_LIT:255> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT:version>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , BOOLEAN ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , TIMESTAMP ( timezone = True ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , BOOLEAN ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT:255> , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT:port>' , VARCHAR ( length = <NUM_LIT:255> , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' , <EOL> onupdate = "<STR_LIT>" , ondelete = "<STR_LIT>" ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , cookies . c . user_id , unique = False ) <EOL> auth_group_permissions = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , auth_group_permissions . c . group_id , auth_group_permissions . c . permission_id , unique = True ) <EOL> auth_user_groups = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' , <EOL> onupdate = "<STR_LIT>" , ondelete = "<STR_LIT>" ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , auth_user_groups . c . user_id , auth_user_groups . c . group_id , unique = True ) <EOL> auth_group = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT:name>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , auth_group . c . name , unique = True ) <EOL> auth_permission = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT:name>' , VARCHAR ( length = <NUM_LIT:50> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT:description>' , TEXT ( convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> schema = '<STR_LIT>' ) <EOL> auth_user_user_permissions = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' , <EOL> onupdate = "<STR_LIT>" , ondelete = "<STR_LIT>" ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , auth_user_user_permissions . c . user_id , auth_user_user_permissions . c . permission_id , unique = True ) <EOL> auth_user = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT:username>' , VARCHAR ( length = <NUM_LIT:30> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT:30> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT:30> , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT:30> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT:email>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , BOOLEAN ( ) , primary_key = False , nullable = False , default = default_active ) , <EOL> Column ( '<STR_LIT>' , BOOLEAN ( ) , primary_key = False , nullable = False , default = default_active ) , <EOL> Column ( '<STR_LIT>' , BOOLEAN ( ) , primary_key = False , nullable = False , default = default_inactive ) , <EOL> Column ( '<STR_LIT>' , TIMESTAMP ( timezone = True ) , primary_key = False , nullable = False , <EOL> onupdate = time_now , default = time_now ) , <EOL> Column ( '<STR_LIT>' , TIMESTAMP ( timezone = True ) , primary_key = False , nullable = False , default = time_now ) , <EOL> Column ( '<STR_LIT:password>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT:20> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , auth_user . c . username , unique = True ) <EOL> components_suites = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , components_suites . c . component_id , components_suites . c . testsuite_id , unique = True ) <EOL> projects = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT:name>' , VARCHAR ( length = <NUM_LIT:255> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT:description>' , TEXT ( length = None , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , TIMESTAMP ( timezone = True ) , primary_key = False , nullable = False , default = time_now ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' , <EOL> onupdate = "<STR_LIT>" , ondelete = "<STR_LIT>" ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , projects . c . name , unique = True ) <EOL> Index ( '<STR_LIT>' , projects . c . leader_id , unique = False ) <EOL> Index ( '<STR_LIT>' , projects . c . category_id , unique = False ) <EOL> projects_components = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , projects_components . c . project_id , projects_components . c . component_id , unique = True ) <EOL> components = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT:name>' , VARCHAR ( length = <NUM_LIT:255> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT:description>' , TEXT ( length = None , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , TIMESTAMP ( timezone = True ) , primary_key = False , nullable = False , default = time_now ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , components . c . name , unique = True ) <EOL> test_cases_areas = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , test_cases_areas . c . testcase_id , test_cases_areas . c . functionalarea_id , unique = True ) <EOL> test_cases = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT:name>' , VARCHAR ( length = <NUM_LIT:255> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , TIMESTAMP ( timezone = True ) , primary_key = False , nullable = False , <EOL> onupdate = time_now , default = time_now ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , TEXT ( length = None , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , TEXT ( length = None , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , TEXT ( length = None , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , TEXT ( length = None , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , TEXT ( length = None , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , TEXT ( length = None , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , PriorityType ( ) , primary_key = False , nullable = False , default = PriorityType . get_default ) , <EOL> Column ( '<STR_LIT>' , TestCaseType ( ) , primary_key = False , nullable = False , default = TestCaseType . get_default ) , <EOL> Column ( '<STR_LIT:status>' , TestCaseStatus ( ) , primary_key = False , nullable = False , default = TestCaseStatus . get_default ) , <EOL> Column ( '<STR_LIT>' , BOOLEAN ( ) , primary_key = False , nullable = False , default = default_inactive ) , <EOL> Column ( '<STR_LIT>' , BOOLEAN ( ) , primary_key = False , nullable = False , default = default_inactive ) , <EOL> Column ( '<STR_LIT>' , BOOLEAN ( ) , primary_key = False , nullable = False , default = default_active ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT:255> , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTERVAL ( ) , primary_key = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' , <EOL> onupdate = "<STR_LIT>" , ondelete = "<STR_LIT>" ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' , <EOL> onupdate = "<STR_LIT>" , ondelete = "<STR_LIT>" ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' , <EOL> onupdate = "<STR_LIT>" , ondelete = "<STR_LIT>" ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' , <EOL> onupdate = "<STR_LIT>" , ondelete = "<STR_LIT>" ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' , <EOL> onupdate = "<STR_LIT>" , ondelete = "<STR_LIT>" ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , test_cases . c . lastchangeauthor_id , unique = False ) <EOL> Index ( '<STR_LIT>' , test_cases . c . reviewer_id , unique = False ) <EOL> Index ( '<STR_LIT>' , test_cases . c . testimplementation , unique = False ) <EOL> Index ( '<STR_LIT>' , test_cases . c . author_id , unique = False ) <EOL> Index ( '<STR_LIT>' , test_cases . c . name , unique = True ) <EOL> Index ( '<STR_LIT>' , test_cases . c . tester_id , unique = False ) <EOL> Index ( '<STR_LIT>' , test_cases . c . reference_id , unique = False ) <EOL> test_cases_prerequisites = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , <EOL> name = '<STR_LIT>' ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , <EOL> test_cases_prerequisites . c . testcase_id , test_cases_prerequisites . c . prerequisite_id , unique = True ) <EOL> test_suites = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT:name>' , VARCHAR ( length = <NUM_LIT:255> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , BOOLEAN ( ) , primary_key = False , nullable = False , default = default_active ) , <EOL> Column ( '<STR_LIT>' , TIMESTAMP ( timezone = True ) , primary_key = False , nullable = False , <EOL> onupdate = time_now , default = time_now ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT:255> , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , TEXT ( length = None , convert_unicode = False ) , primary_key = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' , <EOL> onupdate = "<STR_LIT>" , ondelete = "<STR_LIT>" ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' , <EOL> onupdate = "<STR_LIT>" , ondelete = "<STR_LIT>" ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , test_suites . c . lastchangeauthor_id , unique = False ) <EOL> Index ( '<STR_LIT>' , test_suites . c . name , unique = True ) <EOL> Index ( '<STR_LIT>' , test_suites . c . project_id , unique = False ) <EOL> Index ( '<STR_LIT>' , test_suites . c . suiteimplementation , unique = False ) <EOL> test_suites_testcases = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , test_suites_testcases . c . testsuite_id , test_suites_testcases . c . testcase_id , unique = True ) <EOL> use_cases = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT:name>' , VARCHAR ( length = <NUM_LIT:255> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , TEXT ( length = None , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , TEXT ( length = None , convert_unicode = False ) , primary_key = False ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , use_cases . c . name , unique = True ) <EOL> risk_factors = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT:description>' , TEXT ( convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , PriorityType ( ) , primary_key = False , nullable = False , default = PriorityType . get_default ) , <EOL> Column ( '<STR_LIT>' , LikelihoodType ( ) , primary_key = False , nullable = False , default = LikelihoodType . get_default ) , <EOL> Column ( '<STR_LIT>' , SeverityType ( ) , primary_key = False , nullable = False , default = SeverityType . get_default ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , <EOL> name = '<STR_LIT>' , ondelete = "<STR_LIT>" ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , <EOL> name = '<STR_LIT>' , ondelete = "<STR_LIT>" ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , <EOL> name = '<STR_LIT>' ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , risk_factors . c . testcase_id , unique = False ) <EOL> Index ( '<STR_LIT>' , risk_factors . c . requirement_id , unique = False ) <EOL> Index ( '<STR_LIT>' , risk_factors . c . risk_category_id , unique = False ) <EOL> risk_category = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT:name>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , nullable = False ) , <EOL> Column ( '<STR_LIT:description>' , TEXT ( convert_unicode = False ) , primary_key = False ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , risk_category . c . name , unique = True ) <EOL> requirement_ref = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT:255> ) , primary_key = False ) , <EOL> Column ( '<STR_LIT:description>' , TEXT ( convert_unicode = False ) , primary_key = False ) , <EOL> schema = '<STR_LIT>' ) <EOL> country_codes = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT:name>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT:4> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , country_codes . c . isocode , unique = True ) <EOL> test_suites_suites = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , test_suites_suites . c . from_testsuite_id , test_suites_suites . c . to_testsuite_id , unique = True ) <EOL> country_sets = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT:name>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , country_sets . c . name , unique = True ) <EOL> country_sets_countries = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , country_sets_countries . c . countryset_id , country_sets_countries . c . country_id , unique = True ) <EOL> language_sets = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT:name>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , language_sets . c . name , unique = True ) <EOL> language_sets_languages = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , language_sets_languages . c . languageset_id , language_sets_languages . c . language_id , unique = True ) <EOL> corporations_services = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , corporations_services . c . corporation_id , corporations_services . c . functionalarea_id , unique = True ) <EOL> functional_area = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT:name>' , VARCHAR ( length = <NUM_LIT:255> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT:description>' , VARCHAR ( length = <NUM_LIT:255> , convert_unicode = False ) , primary_key = False ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , functional_area . c . name , unique = True ) <EOL> software_variants = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , software_variants . c . software_id , software_variants . c . softwarevariant_id , unique = True ) <EOL> software_variant = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT:name>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , software_variant . c . name , unique = True ) <EOL> Index ( '<STR_LIT>' , software_variant . c . language_id , unique = False ) <EOL> Index ( '<STR_LIT>' , software_variant . c . country_id , unique = False ) <EOL> language_codes = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT:name>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT:6> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , language_codes . c . isocode , unique = True ) <EOL> Index ( '<STR_LIT>' , language_codes . c . name , unique = True ) <EOL> networks = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT:name>' , VARCHAR ( length = <NUM_LIT:64> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False , server_default = "<STR_LIT:1>" ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , Cidr ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , TEXT ( length = None , convert_unicode = False ) , primary_key = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' , <EOL> ondelete = "<STR_LIT>" ) , <EOL> CheckConstraint ( '<STR_LIT>' , name = '<STR_LIT>' ) , <EOL> CheckConstraint ( '<STR_LIT>' , name = '<STR_LIT>' ) , <EOL> schema = '<STR_LIT>' ) <EOL> equipment = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT:name>' , VARCHAR ( length = <NUM_LIT:255> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT:255> , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , TEXT ( length = None , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , TIMESTAMP ( timezone = True ) , primary_key = False , default = time_now ) , <EOL> Column ( '<STR_LIT>' , TEXT ( length = None , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , BOOLEAN ( ) , primary_key = False , nullable = False , default = default_active ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' , <EOL> onupdate = "<STR_LIT>" , ondelete = "<STR_LIT>" ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , equipment . c . model_id , unique = False ) <EOL> Index ( '<STR_LIT>' , equipment . c . language_id , unique = False ) <EOL> Index ( '<STR_LIT>' , equipment . c . owner_id , unique = False ) <EOL> Index ( '<STR_LIT>' , equipment . c . vendor_id , unique = False ) <EOL> Index ( '<STR_LIT>' , equipment . c . location_id , unique = False ) <EOL> Index ( '<STR_LIT>' , equipment . c . account_id , unique = False ) <EOL> Index ( '<STR_LIT>' , equipment . c . parent_id , unique = False ) <EOL> interface_type = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT:name>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> schema = '<STR_LIT>' ) <EOL> interfaces = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT:name>' , VARCHAR ( length = <NUM_LIT:64> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT:64> , convert_unicode = False ) ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT:description>' , TEXT ( convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , MACADDR ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , Inet ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT:status>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , interfaces . c . parent_id , unique = False ) <EOL> Index ( '<STR_LIT>' , interfaces . c . equipment_id , unique = False ) <EOL> Index ( '<STR_LIT>' , interfaces . c . interface_type_id , unique = False ) <EOL> Index ( '<STR_LIT>' , interfaces . c . network_id , unique = False ) <EOL> equipment_attributes = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT:value>' , PickleText ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> UniqueConstraint ( "<STR_LIT>" , "<STR_LIT>" ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , equipment_attributes . c . type_id , unique = False ) <EOL> Index ( '<STR_LIT>' , equipment_attributes . c . equipment_id , unique = False ) <EOL> equipment_model_attributes = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT:value>' , PickleText ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> UniqueConstraint ( "<STR_LIT>" , "<STR_LIT>" ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , equipment_model_attributes . c . type_id , unique = False ) <EOL> Index ( '<STR_LIT>' , equipment_model_attributes . c . equipmentmodel_id , unique = False ) <EOL> equipment_subcomponents = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , equipment_subcomponents . c . from_equipment_id , equipment_subcomponents . c . to_equipment_id , unique = True ) <EOL> equipment_software = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , equipment_software . c . equipment_id , equipment_software . c . software_id , unique = True ) <EOL> equipment_category = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT:name>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , equipment_category . c . name , unique = True ) <EOL> equipment_model = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT:name>' , VARCHAR ( length = <NUM_LIT:255> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT:255> , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , VARCHAR ( length = <NUM_LIT:255> , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , TEXT ( length = None , convert_unicode = False ) , primary_key = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , equipment_model . c . category_id , unique = False ) <EOL> Index ( '<STR_LIT>' , equipment_model . c . manufacturer_id , unique = False ) <EOL> Index ( '<STR_LIT>' , equipment_model . c . manufacturer_id , equipment_model . c . name , unique = True ) <EOL> equipment_model_embeddedsoftware = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , equipment_model_embeddedsoftware . c . equipmentmodel_id , equipment_model_embeddedsoftware . c . software_id , unique = True ) <EOL> software = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT:name>' , VARCHAR ( length = <NUM_LIT:255> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , software . c . manufacturer_id , unique = False ) <EOL> Index ( '<STR_LIT>' , software . c . name , unique = True ) <EOL> Index ( '<STR_LIT>' , software . c . vendor_id , unique = False ) <EOL> Index ( '<STR_LIT>' , software . c . category_id , unique = False ) <EOL> project_versions = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False , default = default_obj ( <NUM_LIT:1> ) ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False , default = default_obj ( <NUM_LIT:0> ) ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False , default = default_obj ( <NUM_LIT:0> ) ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , BOOLEAN ( ) , primary_key = False , nullable = False , default = default_active ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , <EOL> name = '<STR_LIT>' ) , <EOL> UniqueConstraint ( "<STR_LIT>" , "<STR_LIT>" , "<STR_LIT>" , "<STR_LIT>" , "<STR_LIT>" , <EOL> name = "<STR_LIT>" ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , project_versions . c . project_id , unique = False ) <EOL> corporations = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT:name>' , VARCHAR ( length = <NUM_LIT:255> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , TEXT ( length = None , convert_unicode = False ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , corporations . c . parent_id , unique = False ) <EOL> Index ( '<STR_LIT>' , corporations . c . name , unique = False ) <EOL> Index ( '<STR_LIT>' , corporations . c . country_id , unique = False ) <EOL> Index ( '<STR_LIT>' , corporations . c . contact_id , unique = False ) <EOL> Index ( '<STR_LIT>' , corporations . c . address_id , unique = False ) <EOL> Index ( '<STR_LIT>' , corporations . c . name , corporations . c . country_id , unique = True ) <EOL> environments = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT:name>' , VARCHAR ( length = <NUM_LIT:255> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' , <EOL> onupdate = "<STR_LIT>" , ondelete = "<STR_LIT>" ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , environments . c . name , unique = True ) <EOL> Index ( '<STR_LIT>' , environments . c . owner_id , unique = False ) <EOL> testequipment = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , BOOLEAN ( ) , primary_key = False , nullable = False , default = default_inactive ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' , <EOL> onupdate = "<STR_LIT>" , ondelete = "<STR_LIT>" ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' , <EOL> onupdate = "<STR_LIT>" , ondelete = "<STR_LIT>" ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , testequipment . c . equipment_id , unique = False ) <EOL> Index ( '<STR_LIT>' , testequipment . c . environment_id , unique = False ) <EOL> testequipment_roles = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT>' , INTEGER ( ) , primary_key = False , nullable = False ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> ForeignKeyConstraint ( [ '<STR_LIT>' ] , [ '<STR_LIT>' ] , name = '<STR_LIT>' ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , testequipment_roles . c . testequipment_id , testequipment_roles . c . softwarecategory_id , unique = True ) <EOL> software_category = Table ( '<STR_LIT>' , metadata , <EOL> Column ( '<STR_LIT:id>' , INTEGER ( ) , primary_key = True , nullable = False ) , <EOL> Column ( '<STR_LIT:name>' , VARCHAR ( length = <NUM_LIT> , convert_unicode = False ) , primary_key = False , nullable = False ) , <EOL> Column ( '<STR_LIT:description>' , TEXT ( length = None , convert_unicode = False ) , primary_key = False ) , <EOL> schema = '<STR_LIT>' ) <EOL> Index ( '<STR_LIT>' , software_category . c . name , unique = True ) <EOL> if __name__ == '<STR_LIT:__main__>' : <EOL> import sys <EOL> from pycopia import autodebug <EOL> from pycopia import getopt <EOL> from sqlalchemy import create_engine <EOL> tname = None <EOL> opts , longopts , args = getopt . getopt ( sys . argv [ <NUM_LIT:1> : ] , "<STR_LIT>" ) <EOL> try : <EOL> url = args [ <NUM_LIT:0> ] <EOL> except IndexError : <EOL> print ( "<STR_LIT>" ) <EOL> print ( "<STR_LIT>" ) <EOL> else : <EOL> db = create_engine ( unicode ( url ) ) <EOL> metadata . bind = db <EOL> if len ( args ) > <NUM_LIT:1> : <EOL> for tname in args [ <NUM_LIT:1> : ] : <EOL> tbl = getattr ( sys . modules [ __name__ ] , tname ) <EOL> print ( tbl ) <EOL> tbl . drop ( checkfirst = True ) <EOL> tbl . create ( ) <EOL> else : <EOL> print ( "<STR_LIT>" , url ) <EOL> metadata . create_all ( ) </s>
