I have this table and SQL LITE crashes on windows when I try to create using
exec sql.  System just stops responding.

 

CREATE TABLE Bridge (_id INTEGER PRIMARY KEY,

StateCode INTEGER,

StructureNumber TEXT,

InventoryRoute TEXT,

RecordType TEXT,

RouteSigningPrefix INTEGER,

LevelOfService INTEGER,

RouteNumber TEXT,

DirectionalSuffix INTEGER,

HighwayAgencyDistrict TEXT,

CountyCode INTEGER,

PlaceCode TEXT,

FeaturesIntersected TEXT,

FeaturesIntersected2 TEXT,

CriticalFacility TEXT,

FacilityCarried TEXT,

Location TEXT,

MinVertClearance TEXT,

Kilometerpoint TEXT,

BaseHighwayNetwork INTEGER,

SubrouteNumber TEXT,

LRSInventoryRoute TEXT,

SubrouteNumber TEXT,

Latitude TEXT,

Longitude TEXT,

BypassLength TEXT,

Toll TEXT,

MaintResponsibility TEXT,

Owner TEXT,

FunctionalClass TEXT,

YearBuilt INTEGER,

LanesOnStructure INTEGER,

LanesOnStructure2 INTEGER,

LanesUnderStructure INTEGER,

AverageDailyTraffic INTEGER,

YearOfAverageDailyTraffic INTEGER,

DesignLoad INTEGER,

ApproachRoadwayWidth NUMERIC,

BridgeMedian INTEGER,

Skew INTEGER,

StructureFlared INTEGER,

TrafficSafetyFeatures TEXT,

BridgeRailings TEXT,

Transitions TEXT,

ApproachGuardrail TEXT,

ApproachGuardrailEnds TEXT,

HistoricalSignicance TEXT,

NavigationControl TEXT,

NavigationVerticalClearance TEXT,

NavigationHorizontalClearance TEXT,

StructureOpen TEXT,

TypeOfService TEXT,

TypeofServiceBridge TEXT,

TypeofServiceUnder TEXT,

StructureType TEXT,

KindOfMaterial TEXT,

TypeOfDesign TEXT,

StructureTypeApproach TEXT,

KindOfMaterialApproach TEXT,

TypeOfDesignApproach TEXT,

NumberOfSpans INTEGER,

NumberOfApproachSpans INTEGER,

TotalHorzClearance NUMERIC,

LengthOfMaximumSpan NUMERIC,

StructureLength NUMERIC,

CurbSidewalkWidths NUMERIC,

LeftCurbSidewalkWidth NUMERIC,

RightCurbSidewalkWidth NUMERIC,

BridgeRoadwayWidth NUMERIC,

DeckWidth NUMERIC,

MinVertClear NUMERIC,

MinimumVerticalUnderclearance NUMERIC,

ReferenceFeature TEXT,

MinimumVerticalUnderclearance2 NUMERIC,

MinLateralUnderclearRight NUMERIC,

ReferenceFeature2 TEXT,

MinimumLateralUnderclearance NUMERIC,

MinLateralUnderclearLeft NUMERIC,

Deck TEXT,

Superstructure TEXT,

Substructure TEXT,

ChannelProtection TEXT,

Culverts TEXT,

MethodUsedToDetermineOperatingRating TEXT,

OperatingRating TEXT,

MethodUsedToDetermineInventoryRating TEXT,

InventoryRating TEXT,

StructuralEvaluation TEXT,

DeckGeometry TEXT,

UnderclearVerticalHorizontal TEXT,

BridgePosting TEXT,

WaterwayAdequacy TEXT,

ApproachRoadwayAlignment TEXT,

TypeOfWork TEXT,

TypeOfWorkProposed TEXT,

WorkDoneBy TEXT,

LengthOfStructureImprovement TEXT,

InspectionDate TEXT,

DesignatedInspectionFrequency TEXT,

CriticalFeatureInspection TEXT,

FractureCriticalDetails TEXT,

UnderwaterInspection TEXT,

OtherSpecialInspection TEXT,

CriticalFeatureInspectionDates TEXT,

FractureCriticalDetailsDate TEXT,

UnderwaterInspectionDate TEXT,

OtherSpecialInspectionDate TEXT,

BridgeImprovementCost NUMERIC,

RoadwayImprovementCost NUMERIC,

TotalProjectCost NUMERIC,

YearOfImprovementCostEstimate INTEGER,

BorderBridge TEXT,

NeighboringStateCode TEXT,

PercentResponsibility TEXT,

BorderBridgeStructureNumber INTEGER,

STRAHNETHighwayDesignation TEXT,

ParallelStructureDesignation TEXT,

DirectionOfTraffic TEXT,

TemporaryStructureDesignation TEXT,

HighwaySystemOfInventoryRoute TEXT,

FederalLandsHighways TEXT,

YearReconstructed INTEGER,

DeckStructureType TEXT,

WearingSurfaceSystem TEXT,

TypeOfWearingSurface TEXT,

TypeOfMembrane TEXT,

DeckProtection TEXT,

AverageDailyTruckTraffic NUMERIC,

DesignatedNationalNetwork TEXT,

PierProtection TEXT,

NBISBridgeLength NUMERIC,

SCOURCriticalBridges TEXT,

FutureAverageDailyTraffic NUMERIC,

YearOfFutureAvgDailyTraffic INTEGER,

MinNavigationVerticalClearanceVerticaLiftBridge NUMERIC,

FederalAgencyIndicator TEXT,

WashingtonHeadquartersUse TEXT,

StatusWith10yrRule TEXT,

AsteriskFieldInSR TEXT,

SufficiencyRating TEXT,

StatusWithout10yrRule TEXT);

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to