dbschemaextra

var MobsqlSchemaExtra = mobsql.SchemaExtra{
	Views: []mobsql.View{
		{Name: "_vstopparent", Doc: "Mapping of stops to their parent stops", SQLCreateStatement: string(_vstopparent)},
		{Name: "_vconnd", Doc: "CSA timetable", SQLCreateStatement: string(_vconnd)},
		{Name: "_vconndverbose", Doc: "CSA timetable (with verbose joins)", SQLCreateStatement: string(_vconndverbose)},
		{Name: "_vconndverbosewithextensions", Doc: "CSA timetable (with verbose joins AND go extensions)", SQLCreateStatement: string(_vconndverbosewithextensions)},
		{Name: "_vcaltoservice", Doc: "Maps calendar dates individually to valid service id", SQLCreateStatement: string(_vcaltoservice)},
		{Name: "_vtransferstbl", Doc: "Transfers table added with from/to idu (parents)", SQLCreateStatement: string(_vtransferstbl)},
		{Name: "_vtransfersgen", Doc: "Transfers table generated from stops self-join", SQLCreateStatement: string(_vtransfersgen)},
	},
	TablesComputed: []mobsql.ComputedTable{
		{
			Doc:           `Computed table for the _cvconnd view`,
			View:          `_vconnd`,
			CacheOnTables: []string{"stop_times", "trips", "stops", "routes"},
			TableSpec: mobsql.TableSpec{
				Table:     "_cvconnd",
				Indexes:   [][]string{{"source", "service_id", "from_stop_time"}},
				UniqueSet: []string{"source", "conn_id"},
				Columns: []mobsql.LoadColumn{
					{Column: "source", DType: mobsql.DTypeInt, Required: true},
					{Column: "conn_id", DType: mobsql.DTypeText, Required: true},
					{Column: "trip_id", DType: mobsql.DTypeText, Required: true},
					{Column: "service_id", DType: mobsql.DTypeText, Required: true},
					{Column: "from_stop_id", DType: mobsql.DTypeText, Required: true},
					{Column: "from_stop_idu", DType: mobsql.DTypeText, Required: true},
					{Column: "from_stop_sidu", DType: mobsql.DTypeText, Required: true},
					{Column: "from_stop_time", DType: mobsql.DTypeInt, Required: true},
					{Column: "from_stop_sequence", DType: mobsql.DTypeInt, Required: true},
					{Column: "to_stop_id", DType: mobsql.DTypeText, Required: true},
					{Column: "to_stop_idu", DType: mobsql.DTypeText, Required: true},
					{Column: "to_stop_sidu", DType: mobsql.DTypeText, Required: true},
					{Column: "to_stop_time", DType: mobsql.DTypeInt, Required: true},
					{Column: "to_stop_sequence", DType: mobsql.DTypeInt, Required: true},
				},
			},
		},
		{
			View:          "_vstopparent",
			SourcePair:    false,
			CacheOnTables: []string{"stops"},
			TableSpec: mobsql.TableSpec{
				Table: "_cvstopparent",
				Columns: []mobsql.LoadColumn{
					{Column: "source", DType: mobsql.DTypeInt, Required: true},
					{Column: "stop_id", DType: mobsql.DTypeText, Required: true},
					{Column: "parent_station", DType: mobsql.DTypeText, Required: true},
				},
			},
		},
		{
			View:          "_vtransfersgen",
			SourcePair:    false,
			CacheOnTables: []string{"stops"},
			TableSpec: mobsql.TableSpec{
				Table: "_cvtransfersgen",
				Columns: []mobsql.LoadColumn{
					{Column: "transfer_category", DType: mobsql.DTypeText, Required: true},
					{Column: "source", DType: mobsql.DTypeInt, Required: true},
					{Column: "source_pair", DType: mobsql.DTypeInt, Required: true},
					{Column: "from_stop_id", DType: mobsql.DTypeText, Required: true},
					{Column: "to_stop_id", DType: mobsql.DTypeText, Required: true},
					{Column: "from_stop_idu", DType: mobsql.DTypeText, Required: true},
					{Column: "to_stop_idu", DType: mobsql.DTypeText, Required: true},
					{Column: "from_stop_sidu", DType: mobsql.DTypeText, Required: true},
					{Column: "to_stop_sidu", DType: mobsql.DTypeText, Required: true},
					{Column: "transfer_type", DType: mobsql.DTypeInt},
					{Column: "min_transfer_time", DType: mobsql.DTypeInt},
					{Column: "dist_km", DType: mobsql.DTypeReal},
				},
			},
		},
	},
}