All pastes #347873 Raw Edit

Anonymous

public text v1 · immutable
·published 2007-02-09 19:37 UTC
rendered paste body
	# flexsql: meta / select
	# flexsql: documents / insert
	# xtossql: publishers / insert
	# xtossql: document_fixtures / insert
	# xtossql: documents / insert
	# flexsql: content / insert
	# xtossql: contents / insert
	# xtossql: document_classes / get ID of most recently created row for xtoss_document_classes
	# flexsql: events / insert
	# xtossql: events / insert
	# xtossql: events / update
	# xtossql: events_documents / insert
	# xtossql: events_documents / delete
	# flexsql: events / select
	# xtossql: events / select with recency
	# xtosssql: events / id select
	# xtosssql: events / select
	# xtossql: site / select
	# xtossql: events_documents /id select
	# xtossql: sites / insert
	# flexsql: map_event_fixture / select
	# flexsql: documents / delete
	# flexsql: documents / update
	# xtossql: documents / update
	# flexsql: content / update
	# xtossql: document_contents / update
	# flexsql: documents / select
	# xtossql: publishers / update
	# xtossql: document_fixtures / select
	# xtossql: document_classes, document_fixtures / select
	# xtossql: document_classes / insert
	# xtossql: documents / select
	# xtossql: latest_revisions / delete
	# xtossql: latest_revisions / select
	# xtossql: latest_revisions / insert
	# xtossql: latest_revisions / update
	# flexsql: map_revision_document / delete
	# flexsql: map_revision_document / select
	# flexsql: map_revision_document / insert
	# flexsql: map_revision_document / update
	# flexsql: events / select (count event_id's)
	# flexsql: map_event_fixture / insert
	# flexsql: map_event_fixture / delete
	# xtossql: document_fixtures_events / select
	# xtossql: document_fixtures_events / insert
	# xtossql: document_fixtures_events / delete
	# flexsql: refdyn_player / insert
	# flexsql: refdyn_player / select
	# flexsql: map_doc_level / select
	# flexsql: map_doc_level / insert
	# xtossql: teams_documents / delete
	# xtossql: teams / select
	# xtossql: persons_documents / delete
	# xtossql: persons / select
	# xtossql: persons_documents / insert
	# xtossql: persons / insert
	# xtossql: persons / select
	# xtossql: teams / select -- get ID of most recently created row
	# xtossql: teams / insert
	# xtossql: display_names / insert
	# xtossql: teams_documents / insert
	# xtossql: affiliations / select -- get ID of most recently created row
	# xtossql: affiliations / insert
	# xtossql: affiliations_documents / delete
	# xtossql: affiliations / select
	# xtossql: affiliations_documents / insert
	# xtossql: participants_events / select
	# xtosssql: participants_events / update
	# xtossql: participants_events / insert
	# xtossql: participants_events / delete
	# xtossql: periods / select
	# xtossql: periods / insert
	# xtossql: periods / update
	# xtossql: periods / delete
	# flexsql: map_event_level / select
	# flexsql: map_event_level / insert
	# xtossql: affiliations_events / select
	# xtossql: affiliations_events / insert
	# xtossql: affiliations_events / delete
	# xtossql: affiliations, affiliations_events / select
	# xtossql: seasons / select
	# xtossql: seasons / insert
	# xtossql: sub_seasons / select
	# xtossql: sub_seasons / insert
	# xtossql: events_sub_seasons / delete
	# xtossql: events_sub_seasons / insert
	# xtossql: seasons / select -- get latest ID
	# xtossql: sub_seasons / select -- get latest ID
	# flexsql: map_event_result / select
	# flexsql: map_event_result / insert
	# flexsql: map_event_result_subscore / delete
	# flexsql: map_event_result_subscore / insert
	# flexsql: map_event_award / delete
	# flexsql: map_event_award / insert
	# flexsql: map_event_weather / select
	# flexsql: map_event_weather / insert
	# flexsql: map_event_weather / update
	# flexsql: injuries / update
	# flexsql: injuries / select
	# flexsql: injuries / insert
	# flexsql: injuries / insert -- healthy