PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE IF NOT EXISTS "action_text_rich_texts" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "body" text, "record_type" varchar NOT NULL, "record_id" bigint NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL);
CREATE TABLE IF NOT EXISTS "active_storage_blobs" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "key" varchar NOT NULL, "filename" varchar NOT NULL, "content_type" varchar, "metadata" text, "service_name" varchar NOT NULL, "byte_size" bigint NOT NULL, "checksum" varchar, "created_at" datetime(6) NOT NULL);
CREATE TABLE IF NOT EXISTS "ages" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "category" varchar, "description" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL);
INSERT INTO ages VALUES(1,'J','< 17','2025-05-08 10:54:30.363502','2025-05-08 10:54:30.363502');
INSERT INTO ages VALUES(2,'A','18-35','2025-05-08 10:54:30.369073','2025-05-08 10:54:30.369073');
INSERT INTO ages VALUES(3,'A1','36-45','2025-05-08 10:54:30.372029','2025-05-08 10:54:30.372029');
INSERT INTO ages VALUES(4,'B','46-54','2025-05-08 10:54:30.374194','2025-05-08 10:54:30.374194');
INSERT INTO ages VALUES(5,'B1','55-65','2025-05-08 10:54:30.375962','2025-05-08 10:54:30.375962');
INSERT INTO ages VALUES(6,'C','66-75','2025-05-08 10:54:30.377771','2025-05-08 10:54:30.377771');
INSERT INTO ages VALUES(7,'C1','76-85','2025-05-08 10:54:30.379957','2025-05-08 10:54:30.379957');
INSERT INTO ages VALUES(8,'D','86+','2025-05-08 10:54:30.381993','2025-05-08 10:54:30.381993');
CREATE TABLE IF NOT EXISTS "billables" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar, "name" varchar, "price" decimal(7,2), "order" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "couples" boolean DEFAULT 0);
CREATE TABLE IF NOT EXISTS "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "order" integer, "day" varchar, "time" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "ballrooms" integer, "max_heat_size" integer, "routines" boolean, "duration" integer, "cost_override" decimal(7,2), "pro" boolean DEFAULT 0, "locked" boolean, "studio_cost_override" decimal(7,2), "split" varchar);
CREATE TABLE IF NOT EXISTS "feedbacks" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "order" integer, "value" varchar, "abbr" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL);
CREATE TABLE IF NOT EXISTS "levels" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL);
INSERT INTO levels VALUES(1,'Newcomer','2025-05-08 10:54:30.395814','2025-05-08 10:54:30.395814');
INSERT INTO levels VALUES(2,'Assoc. Bronze','2025-05-08 10:54:30.399813','2025-05-08 10:54:30.399813');
INSERT INTO levels VALUES(3,'Full Bronze','2025-05-08 10:54:30.401502','2025-05-08 10:54:30.401502');
INSERT INTO levels VALUES(4,'Assoc. Silver','2025-05-08 10:54:30.404793','2025-05-08 10:54:30.404793');
INSERT INTO levels VALUES(5,'Full Silver','2025-05-08 10:54:30.408724','2025-05-08 10:54:30.408724');
INSERT INTO levels VALUES(6,'Assoc. Gold','2025-05-08 10:54:30.412990','2025-05-08 10:54:30.412990');
INSERT INTO levels VALUES(7,'Full Gold','2025-05-08 10:54:30.421432','2025-05-08 10:54:30.421432');
CREATE TABLE IF NOT EXISTS "regions" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar, "code" varchar, "location" varchar, "latitude" float, "longitude" float, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL);
CREATE TABLE IF NOT EXISTS "users" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "userid" varchar, "password" varchar, "email" varchar, "name1" varchar, "name2" varchar, "token" varchar, "link" varchar, "sites" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL);
CREATE TABLE IF NOT EXISTS "active_storage_attachments" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "record_type" varchar NOT NULL, "record_id" bigint NOT NULL, "blob_id" bigint NOT NULL, "created_at" datetime(6) NOT NULL, CONSTRAINT "fk_rails_c3b3935057"
FOREIGN KEY ("blob_id")
  REFERENCES "active_storage_blobs" ("id")
);
CREATE TABLE IF NOT EXISTS "active_storage_variant_records" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "blob_id" bigint NOT NULL, "variation_digest" varchar NOT NULL, CONSTRAINT "fk_rails_993965df05"
FOREIGN KEY ("blob_id")
  REFERENCES "active_storage_blobs" ("id")
);
CREATE TABLE IF NOT EXISTS "age_costs" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "age_id" integer NOT NULL, "heat_cost" decimal(7,2), "solo_cost" decimal(7,2), "multi_cost" decimal(7,2), "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, CONSTRAINT "fk_rails_adbcea596f"
FOREIGN KEY ("age_id")
  REFERENCES "ages" ("id")
);
CREATE TABLE IF NOT EXISTS "cat_extensions" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "category_id" integer NOT NULL, "start_heat" integer, "part" integer, "order" integer, "day" varchar, "time" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "duration" integer, CONSTRAINT "fk_rails_fda0eb00b0"
FOREIGN KEY ("category_id")
  REFERENCES "categories" ("id")
);
CREATE TABLE IF NOT EXISTS "dances" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "open_category_id" integer, "closed_category_id" integer, "order" integer, "solo_category_id" integer, "multi_category_id" integer, "heat_length" integer, "row" integer, "col" integer, "cost_override" decimal(7,2), "pro_open_category_id" integer, "pro_closed_category_id" integer, "pro_solo_category_id" integer, "pro_multi_category_id" integer, "semi_finals" boolean DEFAULT 0, "limit" integer, CONSTRAINT "fk_rails_efaaf34809"
FOREIGN KEY ("pro_solo_category_id")
  REFERENCES "categories" ("id")
, CONSTRAINT "fk_rails_a72388b9e3"
FOREIGN KEY ("pro_multi_category_id")
  REFERENCES "categories" ("id")
, CONSTRAINT "fk_rails_644cc2a7ac"
FOREIGN KEY ("open_category_id")
  REFERENCES "categories" ("id")
, CONSTRAINT "fk_rails_554eda2935"
FOREIGN KEY ("closed_category_id")
  REFERENCES "categories" ("id")
, CONSTRAINT "fk_rails_c8a6cf7eac"
FOREIGN KEY ("multi_category_id")
  REFERENCES "categories" ("id")
, CONSTRAINT "fk_rails_0d39d088ac"
FOREIGN KEY ("pro_closed_category_id")
  REFERENCES "categories" ("id")
, CONSTRAINT "fk_rails_60c33dc1c5"
FOREIGN KEY ("pro_open_category_id")
  REFERENCES "categories" ("id")
, CONSTRAINT "fk_rails_e0d2797603"
FOREIGN KEY ("solo_category_id")
  REFERENCES "categories" ("id")
);
INSERT INTO dances VALUES(1,'Waltz','2025-05-08 10:54:30.469553','2025-05-08 10:54:30.469553',NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL);
INSERT INTO dances VALUES(2,'Fox Trot','2025-05-08 10:54:30.492470','2025-05-08 10:54:30.492470',NULL,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL);
INSERT INTO dances VALUES(3,'Tango','2025-05-08 10:54:30.500411','2025-05-08 10:54:30.500411',NULL,NULL,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL);
INSERT INTO dances VALUES(4,'V. Waltz','2025-05-08 10:54:30.511493','2025-05-08 10:54:30.511493',NULL,NULL,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL);
INSERT INTO dances VALUES(5,'Quickstep','2025-05-08 10:54:30.515706','2025-05-08 10:54:30.515706',NULL,NULL,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL);
INSERT INTO dances VALUES(6,'Peabody','2025-05-08 10:54:30.519556','2025-05-08 10:54:30.519556',NULL,NULL,6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL);
INSERT INTO dances VALUES(7,'Arg. Tango','2025-05-08 10:54:30.524392','2025-05-08 10:54:30.524392',NULL,NULL,7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL);
INSERT INTO dances VALUES(8,'Salsa','2025-05-08 10:54:30.528004','2025-05-08 10:54:30.528004',NULL,NULL,8,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL);
INSERT INTO dances VALUES(9,'Rumba','2025-05-08 10:54:30.534172','2025-05-08 10:54:30.534172',NULL,NULL,9,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL);
INSERT INTO dances VALUES(10,'Cha Cha','2025-05-08 10:54:30.537572','2025-05-08 10:54:30.537572',NULL,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL);
INSERT INTO dances VALUES(11,'Merengue','2025-05-08 10:54:30.540531','2025-05-08 10:54:30.540531',NULL,NULL,11,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL);
INSERT INTO dances VALUES(12,'Samba','2025-05-08 10:54:30.544817','2025-05-08 10:54:30.544817',NULL,NULL,12,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL);
INSERT INTO dances VALUES(13,'Bolero','2025-05-08 10:54:30.548150','2025-05-08 10:54:30.548150',NULL,NULL,13,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL);
INSERT INTO dances VALUES(14,'Paso Doble','2025-05-08 10:54:30.552969','2025-05-08 10:54:30.552969',NULL,NULL,14,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL);
INSERT INTO dances VALUES(15,'Mambo','2025-05-08 10:54:30.560266','2025-05-08 10:54:30.560266',NULL,NULL,15,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL);
INSERT INTO dances VALUES(16,'WCS','2025-05-08 10:54:30.563869','2025-05-08 10:54:30.563869',NULL,NULL,16,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL);
INSERT INTO dances VALUES(17,'Bachata','2025-05-08 10:54:30.567396','2025-05-08 10:54:30.567396',NULL,NULL,17,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL);
INSERT INTO dances VALUES(18,'ECS','2025-05-08 10:54:30.570967','2025-05-08 10:54:30.570967',NULL,NULL,18,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL);
INSERT INTO dances VALUES(19,'Hustle','2025-05-08 10:54:30.578157','2025-05-08 10:54:30.578157',NULL,NULL,19,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL);
INSERT INTO dances VALUES(20,'CW Swing','2025-05-08 10:54:30.581575','2025-05-08 10:54:30.581575',NULL,NULL,20,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL);
INSERT INTO dances VALUES(21,'Lindy Hop','2025-05-08 10:54:30.584098','2025-05-08 10:54:30.584098',NULL,NULL,21,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL);
INSERT INTO dances VALUES(22,'CW Waltz','2025-05-08 10:54:30.586878','2025-05-08 10:54:30.586878',NULL,NULL,22,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL);
INSERT INTO dances VALUES(23,'CW Cha Cha','2025-05-08 10:54:30.590245','2025-05-08 10:54:30.590245',NULL,NULL,23,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL);
INSERT INTO dances VALUES(24,'NC2','2025-05-08 10:54:30.594592','2025-05-08 10:54:30.594592',NULL,NULL,24,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL);
INSERT INTO dances VALUES(25,'CW Two Step','2025-05-08 10:54:30.598243','2025-05-08 10:54:30.598243',NULL,NULL,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL);
INSERT INTO dances VALUES(26,'CW Three Step','2025-05-08 10:54:30.601669','2025-05-08 10:54:30.601669',NULL,NULL,26,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL);
INSERT INTO dances VALUES(27,'CW Shuffle','2025-05-08 10:54:30.605169','2025-05-08 10:54:30.605169',NULL,NULL,27,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL);
INSERT INTO dances VALUES(28,'Swing','2025-05-08 10:54:30.608789','2025-05-08 10:54:30.608789',NULL,NULL,28,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL);
INSERT INTO dances VALUES(29,'4 Count','2025-05-08 10:54:30.613932','2025-05-08 10:54:30.613932',NULL,NULL,29,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL);
INSERT INTO dances VALUES(30,'Polka','2025-05-08 10:54:30.619373','2025-05-08 10:54:30.619373',NULL,NULL,30,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL);
CREATE TABLE IF NOT EXISTS "entries" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "age_id" integer NOT NULL, "level_id" integer NOT NULL, "lead_id" integer NOT NULL, "follow_id" integer NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "instructor_id" integer, CONSTRAINT "fk_rails_41604fefcd"
FOREIGN KEY ("instructor_id")
  REFERENCES "people" ("id")
, CONSTRAINT "fk_rails_0e8c121ba1"
FOREIGN KEY ("level_id")
  REFERENCES "levels" ("id")
, CONSTRAINT "fk_rails_1473a8d842"
FOREIGN KEY ("age_id")
  REFERENCES "ages" ("id")
, CONSTRAINT "fk_rails_48a5b954b2"
FOREIGN KEY ("follow_id")
  REFERENCES "people" ("id")
, CONSTRAINT "fk_rails_b40855fc29"
FOREIGN KEY ("lead_id")
  REFERENCES "people" ("id")
);
CREATE TABLE IF NOT EXISTS "events" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "location" varchar, "date" varchar, "heat_range_cat" integer, "heat_range_level" integer, "heat_range_age" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "intermix" boolean DEFAULT 1, "current_heat" integer, "ballrooms" integer DEFAULT 1, "heat_length" integer, "heat_cost" decimal(7,2), "solo_cost" decimal(7,2), "multi_cost" decimal(7,2), "email" varchar, "max_heat_size" integer, "package_required" boolean DEFAULT 1, "backnums" boolean DEFAULT 1, "track_ages" boolean DEFAULT 1, "column_order" integer DEFAULT 1, "open_scoring" varchar DEFAULT '1', "solo_length" integer, "theme" varchar, "locked" boolean DEFAULT 0, "student_package_description" varchar, "payment_due" varchar, "multi_scoring" varchar DEFAULT '1', "judge_comments" boolean DEFAULT 0, "agenda_based_entries" boolean DEFAULT 0, "pro_heats" boolean DEFAULT 0, "assign_judges" integer DEFAULT 0, "font_size" varchar DEFAULT '100%', "include_times" boolean DEFAULT 1, "include_open" boolean DEFAULT 1, "include_closed" boolean DEFAULT 1, "solo_level_id" integer, "print_studio_heats" boolean DEFAULT 0, "font_family" varchar DEFAULT 'Helvetica, Arial', "independent_instructors" boolean DEFAULT 0, "closed_scoring" varchar DEFAULT 'G', "heat_order" varchar DEFAULT 'L', "dance_limit" integer, "counter_color" varchar DEFAULT '#FFFFFF', "pro_heat_cost" decimal(7,2), "pro_solo_cost" decimal(7,2), "pro_multi_cost" decimal(7,2), "strict_scoring" boolean DEFAULT 0, "pro_am" varchar DEFAULT 'G', "solo_scoring" varchar DEFAULT '1', CONSTRAINT "fk_rails_353c42da39"
FOREIGN KEY ("solo_level_id")
  REFERENCES "levels" ("id")
);
INSERT INTO events VALUES(1,'Showcase','TBD',NULL,0,3,7,'2025-05-08 10:54:30.286121','2025-05-08 10:54:30.286121',1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,1,'1',NULL,NULL,0,NULL,NULL,'1',0,0,0,0,'100%',1,1,1,NULL,0,'Helvetica, Arial',0,'G','L',NULL,'#FFFFFF',NULL,NULL,NULL,0,'G','1');
CREATE TABLE IF NOT EXISTS "formations" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "person_id" integer NOT NULL, "solo_id" integer NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "on_floor" boolean DEFAULT 1, CONSTRAINT "fk_rails_f20cf47ef6"
FOREIGN KEY ("person_id")
  REFERENCES "people" ("id")
, CONSTRAINT "fk_rails_e788fbf735"
FOREIGN KEY ("solo_id")
  REFERENCES "solos" ("id")
);
CREATE TABLE IF NOT EXISTS "heats" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "number" float, "category" varchar, "dance_id" integer NOT NULL, "entry_id" integer NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "ballroom" varchar, "prev_number" float, CONSTRAINT "fk_rails_1032ada29d"
FOREIGN KEY ("dance_id")
  REFERENCES "dances" ("id")
, CONSTRAINT "fk_rails_297e667660"
FOREIGN KEY ("entry_id")
  REFERENCES "entries" ("id")
);
CREATE TABLE IF NOT EXISTS "judges" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "person_id" integer NOT NULL, "sort" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "show_assignments" varchar DEFAULT 'first' NOT NULL, "present" boolean DEFAULT 1 NOT NULL, "ballroom" varchar DEFAULT 'Both' NOT NULL, "review_solos" varchar DEFAULT 'All', CONSTRAINT "fk_rails_226026eca9"
FOREIGN KEY ("person_id")
  REFERENCES "people" ("id")
);
CREATE TABLE IF NOT EXISTS "locations" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "key" varchar, "name" varchar, "logo" varchar, "latitude" float, "longitude" float, "user_id" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "region" varchar, "sisters" varchar, "trust_level" integer DEFAULT 0, "locale" varchar DEFAULT 'en_US', CONSTRAINT "fk_rails_5e107925c6"
FOREIGN KEY ("user_id")
  REFERENCES "users" ("id")
);
CREATE TABLE IF NOT EXISTS "multis" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer NOT NULL, "dance_id" integer NOT NULL, "slot" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, CONSTRAINT "fk_rails_5f0ab7bd74"
FOREIGN KEY ("dance_id")
  REFERENCES "dances" ("id")
, CONSTRAINT "fk_rails_2ef82a9a07"
FOREIGN KEY ("parent_id")
  REFERENCES "dances" ("id")
);
CREATE TABLE IF NOT EXISTS "package_includes" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "package_id" integer NOT NULL, "option_id" integer NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, CONSTRAINT "fk_rails_4b0115715f"
FOREIGN KEY ("option_id")
  REFERENCES "billables" ("id")
, CONSTRAINT "fk_rails_bf7e60660c"
FOREIGN KEY ("package_id")
  REFERENCES "billables" ("id")
);
CREATE TABLE IF NOT EXISTS "people" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "studio_id" integer, "type" varchar, "back" integer, "level_id" integer, "age_id" integer, "role" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "exclude_id" integer, "package_id" integer, "independent" boolean DEFAULT 0, "invoice_to_id" integer, "available" varchar, CONSTRAINT "fk_rails_3465b321b7"
FOREIGN KEY ("invoice_to_id")
  REFERENCES "people" ("id")
, CONSTRAINT "fk_rails_8e98466fd8"
FOREIGN KEY ("level_id")
  REFERENCES "levels" ("id")
, CONSTRAINT "fk_rails_b309eae9fc"
FOREIGN KEY ("age_id")
  REFERENCES "ages" ("id")
, CONSTRAINT "fk_rails_0c600b2fd9"
FOREIGN KEY ("package_id")
  REFERENCES "billables" ("id")
, CONSTRAINT "fk_rails_6039193ecf"
FOREIGN KEY ("exclude_id")
  REFERENCES "people" ("id")
, CONSTRAINT "fk_rails_2e4d98b701"
FOREIGN KEY ("studio_id")
  REFERENCES "studios" ("id")
);
CREATE TABLE IF NOT EXISTS "person_options" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "person_id" integer NOT NULL, "option_id" integer NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, CONSTRAINT "fk_rails_885b701507"
FOREIGN KEY ("option_id")
  REFERENCES "billables" ("id")
, CONSTRAINT "fk_rails_5b7e3c91fa"
FOREIGN KEY ("person_id")
  REFERENCES "people" ("id")
);
CREATE TABLE IF NOT EXISTS "scores" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "judge_id" integer NOT NULL, "heat_id" integer NOT NULL, "value" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "slot" integer, "comments" varchar, "good" varchar, "bad" varchar, CONSTRAINT "fk_rails_daa05f37c9"
FOREIGN KEY ("heat_id")
  REFERENCES "heats" ("id")
, CONSTRAINT "fk_rails_017a0f7b77"
FOREIGN KEY ("judge_id")
  REFERENCES "people" ("id")
);
CREATE TABLE IF NOT EXISTS "showcases" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "year" integer, "key" varchar, "name" varchar, "location_id" integer NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "order" integer, CONSTRAINT "fk_rails_db0b14f076"
FOREIGN KEY ("location_id")
  REFERENCES "locations" ("id")
);
CREATE TABLE IF NOT EXISTS "solos" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "heat_id" integer NOT NULL, "combo_dance_id" integer, "order" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "song" varchar, "artist" varchar, "category_override_id" integer, CONSTRAINT "fk_rails_252e198306"
FOREIGN KEY ("combo_dance_id")
  REFERENCES "dances" ("id")
, CONSTRAINT "fk_rails_c780c08f0b"
FOREIGN KEY ("category_override_id")
  REFERENCES "categories" ("id")
, CONSTRAINT "fk_rails_30394335b1"
FOREIGN KEY ("heat_id")
  REFERENCES "heats" ("id")
);
CREATE TABLE IF NOT EXISTS "songs" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "dance_id" integer NOT NULL, "order" integer, "title" varchar, "artist" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, CONSTRAINT "fk_rails_778db28f5b"
FOREIGN KEY ("dance_id")
  REFERENCES "dances" ("id")
);
CREATE TABLE IF NOT EXISTS "studio_pairs" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "studio1_id" integer NOT NULL, "studio2_id" integer NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, CONSTRAINT "fk_rails_06efca38af"
FOREIGN KEY ("studio1_id")
  REFERENCES "studios" ("id")
, CONSTRAINT "fk_rails_e50bcb4389"
FOREIGN KEY ("studio2_id")
  REFERENCES "studios" ("id")
);
CREATE TABLE IF NOT EXISTS "studios" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "tables" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "heat_cost" decimal(7,2), "solo_cost" decimal(7,2), "multi_cost" decimal(7,2), "email" varchar, "default_student_package_id" integer, "default_professional_package_id" integer, "default_guest_package_id" integer, "student_registration_cost" decimal(7,2), "student_heat_cost" decimal(7,2), "student_solo_cost" decimal(7,2), "student_multi_cost" decimal(7,2), "ballroom" varchar, CONSTRAINT "fk_rails_225cf92a86"
FOREIGN KEY ("default_professional_package_id")
  REFERENCES "billables" ("id")
, CONSTRAINT "fk_rails_7b6d29b5e9"
FOREIGN KEY ("default_guest_package_id")
  REFERENCES "billables" ("id")
, CONSTRAINT "fk_rails_2dd7380d43"
FOREIGN KEY ("default_student_package_id")
  REFERENCES "billables" ("id")
);
INSERT INTO studios VALUES(0,'Event Staff',NULL,'2025-05-08 10:54:30.335807','2025-05-08 10:54:30.335807',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
CREATE TABLE IF NOT EXISTS "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY);
INSERT INTO schema_migrations VALUES('20250407144301');
INSERT INTO schema_migrations VALUES('20250329010216');
INSERT INTO schema_migrations VALUES('20250307070551');
INSERT INTO schema_migrations VALUES('20250307070516');
INSERT INTO schema_migrations VALUES('20250222014457');
INSERT INTO schema_migrations VALUES('20250128222542');
INSERT INTO schema_migrations VALUES('20250126024112');
INSERT INTO schema_migrations VALUES('20241230174102');
INSERT INTO schema_migrations VALUES('20241010143111');
INSERT INTO schema_migrations VALUES('20241002125818');
INSERT INTO schema_migrations VALUES('20241001130746');
INSERT INTO schema_migrations VALUES('20240831131433');
INSERT INTO schema_migrations VALUES('20240822010045');
INSERT INTO schema_migrations VALUES('20240804224317');
INSERT INTO schema_migrations VALUES('20240708213142');
INSERT INTO schema_migrations VALUES('20240708205904');
INSERT INTO schema_migrations VALUES('20240529200032');
INSERT INTO schema_migrations VALUES('20240512170708');
INSERT INTO schema_migrations VALUES('20240425003705');
INSERT INTO schema_migrations VALUES('20240324222321');
INSERT INTO schema_migrations VALUES('20240310223701');
INSERT INTO schema_migrations VALUES('20240229134705');
INSERT INTO schema_migrations VALUES('20240226132621');
INSERT INTO schema_migrations VALUES('20240219210158');
INSERT INTO schema_migrations VALUES('20240129193921');
INSERT INTO schema_migrations VALUES('20240120160513');
INSERT INTO schema_migrations VALUES('20240116131352');
INSERT INTO schema_migrations VALUES('20240109224242');
INSERT INTO schema_migrations VALUES('20231227064854');
INSERT INTO schema_migrations VALUES('20231220195604');
INSERT INTO schema_migrations VALUES('20231207142159');
INSERT INTO schema_migrations VALUES('20231115014415');
INSERT INTO schema_migrations VALUES('20231028131227');
INSERT INTO schema_migrations VALUES('20231027142506');
INSERT INTO schema_migrations VALUES('20231027142420');
INSERT INTO schema_migrations VALUES('20231025173707');
INSERT INTO schema_migrations VALUES('20231010012726');
INSERT INTO schema_migrations VALUES('20231001165834');
INSERT INTO schema_migrations VALUES('20230930144237');
INSERT INTO schema_migrations VALUES('20230923182922');
INSERT INTO schema_migrations VALUES('20230909234512');
INSERT INTO schema_migrations VALUES('20230901183948');
INSERT INTO schema_migrations VALUES('20230603231658');
INSERT INTO schema_migrations VALUES('20230430173328');
INSERT INTO schema_migrations VALUES('20230323024334');
INSERT INTO schema_migrations VALUES('20230124233129');
INSERT INTO schema_migrations VALUES('20230119174433');
INSERT INTO schema_migrations VALUES('20230119173959');
INSERT INTO schema_migrations VALUES('20221015184926');
INSERT INTO schema_migrations VALUES('20220910184733');
INSERT INTO schema_migrations VALUES('20220902165123');
INSERT INTO schema_migrations VALUES('20220824111138');
INSERT INTO schema_migrations VALUES('20220818222750');
INSERT INTO schema_migrations VALUES('20220802135733');
INSERT INTO schema_migrations VALUES('20220727000152');
INSERT INTO schema_migrations VALUES('20220723202802');
INSERT INTO schema_migrations VALUES('20220714122632');
INSERT INTO schema_migrations VALUES('20220712234830');
INSERT INTO schema_migrations VALUES('20220629150139');
INSERT INTO schema_migrations VALUES('20220622141547');
INSERT INTO schema_migrations VALUES('20220622011356');
INSERT INTO schema_migrations VALUES('20220616181115');
INSERT INTO schema_migrations VALUES('20220613132933');
INSERT INTO schema_migrations VALUES('20220611163304');
INSERT INTO schema_migrations VALUES('20220610120655');
INSERT INTO schema_migrations VALUES('20220604141131');
INSERT INTO schema_migrations VALUES('20220527143539');
INSERT INTO schema_migrations VALUES('20220519134900');
INSERT INTO schema_migrations VALUES('20220517173618');
INSERT INTO schema_migrations VALUES('20220516162358');
INSERT INTO schema_migrations VALUES('20220510161408');
INSERT INTO schema_migrations VALUES('20220510132924');
INSERT INTO schema_migrations VALUES('20220510132923');
INSERT INTO schema_migrations VALUES('20220509185821');
INSERT INTO schema_migrations VALUES('20220507162016');
INSERT INTO schema_migrations VALUES('20220501163652');
INSERT INTO schema_migrations VALUES('20220501163609');
INSERT INTO schema_migrations VALUES('20220501162747');
INSERT INTO schema_migrations VALUES('20220427225436');
INSERT INTO schema_migrations VALUES('20220427002212');
INSERT INTO schema_migrations VALUES('20220425210448');
INSERT INTO schema_migrations VALUES('20220421144933');
INSERT INTO schema_migrations VALUES('20220421013549');
INSERT INTO schema_migrations VALUES('20220310220503');
INSERT INTO schema_migrations VALUES('20220301223832');
INSERT INTO schema_migrations VALUES('20220223032029');
INSERT INTO schema_migrations VALUES('20220218152002');
INSERT INTO schema_migrations VALUES('20220217003153');
INSERT INTO schema_migrations VALUES('20220214194448');
INSERT INTO schema_migrations VALUES('20220212171521');
INSERT INTO schema_migrations VALUES('20220212001802');
INSERT INTO schema_migrations VALUES('20220208221606');
INSERT INTO schema_migrations VALUES('20220206193854');
INSERT INTO schema_migrations VALUES('20220206193836');
INSERT INTO schema_migrations VALUES('20220206180026');
INSERT INTO schema_migrations VALUES('20220202153834');
INSERT INTO schema_migrations VALUES('20220124133957');
INSERT INTO schema_migrations VALUES('20220122173243');
INSERT INTO schema_migrations VALUES('20220122173242');
INSERT INTO schema_migrations VALUES('20220122173241');
INSERT INTO schema_migrations VALUES('20220122173240');
CREATE TABLE IF NOT EXISTS "ar_internal_metadata" ("key" varchar NOT NULL PRIMARY KEY, "value" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL);
INSERT INTO ar_internal_metadata VALUES('environment','production','2025-05-08 10:54:30.061065','2025-05-08 10:54:30.061069');
INSERT INTO ar_internal_metadata VALUES('schema_sha1','435cd8135301c07bcb7a170659cfafb06810a544','2025-05-08 10:54:30.078022','2025-05-08 10:54:30.078024');
DELETE FROM sqlite_sequence;
INSERT INTO sqlite_sequence VALUES('active_storage_attachments',0);
INSERT INTO sqlite_sequence VALUES('active_storage_variant_records',0);
INSERT INTO sqlite_sequence VALUES('age_costs',0);
INSERT INTO sqlite_sequence VALUES('cat_extensions',0);
INSERT INTO sqlite_sequence VALUES('dances',30);
INSERT INTO sqlite_sequence VALUES('entries',0);
INSERT INTO sqlite_sequence VALUES('events',1);
INSERT INTO sqlite_sequence VALUES('formations',0);
INSERT INTO sqlite_sequence VALUES('heats',0);
INSERT INTO sqlite_sequence VALUES('judges',0);
INSERT INTO sqlite_sequence VALUES('locations',0);
INSERT INTO sqlite_sequence VALUES('multis',0);
INSERT INTO sqlite_sequence VALUES('package_includes',0);
INSERT INTO sqlite_sequence VALUES('people',0);
INSERT INTO sqlite_sequence VALUES('person_options',0);
INSERT INTO sqlite_sequence VALUES('scores',0);
INSERT INTO sqlite_sequence VALUES('showcases',0);
INSERT INTO sqlite_sequence VALUES('solos',0);
INSERT INTO sqlite_sequence VALUES('songs',0);
INSERT INTO sqlite_sequence VALUES('studio_pairs',0);
INSERT INTO sqlite_sequence VALUES('studios',0);
INSERT INTO sqlite_sequence VALUES('ages',8);
INSERT INTO sqlite_sequence VALUES('levels',7);
CREATE UNIQUE INDEX "index_action_text_rich_texts_uniqueness" ON "action_text_rich_texts" ("record_type", "record_id", "name");
CREATE UNIQUE INDEX "index_active_storage_blobs_on_key" ON "active_storage_blobs" ("key");
CREATE INDEX "index_active_storage_attachments_on_blob_id" ON "active_storage_attachments" ("blob_id");
CREATE UNIQUE INDEX "index_active_storage_attachments_uniqueness" ON "active_storage_attachments" ("record_type", "record_id", "name", "blob_id");
CREATE UNIQUE INDEX "index_active_storage_variant_records_uniqueness" ON "active_storage_variant_records" ("blob_id", "variation_digest");
CREATE INDEX "index_age_costs_on_age_id" ON "age_costs" ("age_id");
CREATE INDEX "index_cat_extensions_on_category_id" ON "cat_extensions" ("category_id");
CREATE INDEX "index_dances_on_closed_category_id" ON "dances" ("closed_category_id");
CREATE INDEX "index_dances_on_multi_category_id" ON "dances" ("multi_category_id");
CREATE INDEX "index_dances_on_open_category_id" ON "dances" ("open_category_id");
CREATE INDEX "index_dances_on_pro_closed_category_id" ON "dances" ("pro_closed_category_id");
CREATE INDEX "index_dances_on_pro_multi_category_id" ON "dances" ("pro_multi_category_id");
CREATE INDEX "index_dances_on_pro_open_category_id" ON "dances" ("pro_open_category_id");
CREATE INDEX "index_dances_on_pro_solo_category_id" ON "dances" ("pro_solo_category_id");
CREATE INDEX "index_dances_on_solo_category_id" ON "dances" ("solo_category_id");
CREATE INDEX "index_entries_on_age_id" ON "entries" ("age_id");
CREATE INDEX "index_entries_on_follow_id" ON "entries" ("follow_id");
CREATE INDEX "index_entries_on_instructor_id" ON "entries" ("instructor_id");
CREATE INDEX "index_entries_on_lead_id" ON "entries" ("lead_id");
CREATE INDEX "index_entries_on_level_id" ON "entries" ("level_id");
CREATE INDEX "index_events_on_solo_level_id" ON "events" ("solo_level_id");
CREATE INDEX "index_formations_on_person_id" ON "formations" ("person_id");
CREATE INDEX "index_formations_on_solo_id" ON "formations" ("solo_id");
CREATE INDEX "index_heats_on_dance_id" ON "heats" ("dance_id");
CREATE INDEX "index_heats_on_entry_id" ON "heats" ("entry_id");
CREATE INDEX "index_judges_on_person_id" ON "judges" ("person_id");
CREATE INDEX "index_locations_on_user_id" ON "locations" ("user_id");
CREATE INDEX "index_multis_on_dance_id" ON "multis" ("dance_id");
CREATE INDEX "index_multis_on_parent_id" ON "multis" ("parent_id");
CREATE INDEX "index_package_includes_on_option_id" ON "package_includes" ("option_id");
CREATE INDEX "index_package_includes_on_package_id" ON "package_includes" ("package_id");
CREATE INDEX "index_people_on_age_id" ON "people" ("age_id");
CREATE INDEX "index_people_on_exclude_id" ON "people" ("exclude_id");
CREATE INDEX "index_people_on_invoice_to_id" ON "people" ("invoice_to_id");
CREATE INDEX "index_people_on_level_id" ON "people" ("level_id");
CREATE INDEX "index_people_on_package_id" ON "people" ("package_id");
CREATE INDEX "index_people_on_studio_id" ON "people" ("studio_id");
CREATE INDEX "index_person_options_on_option_id" ON "person_options" ("option_id");
CREATE INDEX "index_person_options_on_person_id" ON "person_options" ("person_id");
CREATE INDEX "index_scores_on_heat_id" ON "scores" ("heat_id");
CREATE INDEX "index_scores_on_judge_id" ON "scores" ("judge_id");
CREATE INDEX "index_showcases_on_location_id" ON "showcases" ("location_id");
CREATE INDEX "index_solos_on_category_override_id" ON "solos" ("category_override_id");
CREATE INDEX "index_solos_on_combo_dance_id" ON "solos" ("combo_dance_id");
CREATE INDEX "index_solos_on_heat_id" ON "solos" ("heat_id");
CREATE INDEX "index_songs_on_dance_id" ON "songs" ("dance_id");
CREATE INDEX "index_studio_pairs_on_studio1_id" ON "studio_pairs" ("studio1_id");
CREATE INDEX "index_studio_pairs_on_studio2_id" ON "studio_pairs" ("studio2_id");
CREATE INDEX "index_studios_on_default_guest_package_id" ON "studios" ("default_guest_package_id");
CREATE INDEX "index_studios_on_default_professional_package_id" ON "studios" ("default_professional_package_id");
CREATE INDEX "index_studios_on_default_student_package_id" ON "studios" ("default_student_package_id");
COMMIT;