InsercionDatos

InsercionDatos.sql

-- Inserción Datos en SQL Lite
INSERT INTO Ciudades VALUES
	(76001, "Cali"),
	(5001, "Medellin"),
	(10001, "Bogota"),
	(8001, "Barranquillas"),
	(13001, "Cartagena")
;

INSERT INTO Clientes VALUES
	(890521458, "Lebis", "Calle Nueva", "321555897",  76001),
	(890521554, "Medellintejer", "Calle Vieja", "3125892256", 5001),
	(890521548, "Teni", "Parque Berrio", "313569854", 10001),
	(890005487, "Colombianino", "Floresta", "3254689963", 13001),
	(890000029, "Cheviñon", "Manrique", "325669898", 13001),
	(890154858, "Catapila", "Trianon", "326555989", 76001),
	(890555889, "Totoro", "La Playa", "3203668898", 10001),
	(890555858, "Jef", "Mayorca", "3135558997", 76001),
	(890555986, "Punto Negro", "Poblado", "3203696658", 5001),
	(890555598, "Disel", "Envigado", "3506985545", 5001),
	(890555558, "La Cara del Norte", "San Pedro", "3203698874", 76001),
	(890555258, "Arturito Carrera", "Circunvalar", "3135559897", 76001),
	(890569887, "Estudio EFE", "Altos de San Mateo", "3056698787", 76001),
	(890552566, "Naik", "La Cumbre", "3120256987", 8001),
	(890254587, "Ramirez", "Señorial", "3132059987", 5001),
	(890550655, "Tigrenisa", "El Alferez", "3302569987", 8001)
;

INSERT INTO Empresas VALUES
	(980202112, "COONORTE"),
	(980508998, "TRANSPORTES SUROESTE"),
	(980508089, "RAPIDO OCHOA"),
	(980505989, "SERVIENTREGA"),
	(980505528, "DHL"),
	(980505880, "UPS"),
	(980505898, "COORDINADORA"),
	(980505745, "ENVIA")
;
	
INSERT INTO Conductores VALUES
	(1013555889, "Jose", "Jose", 980202112 ),
	(1013555998, "Vicente", "Fernandez", 980508998 ),
	(1013554689, "Alejandro", "Fernandez", 980508089 ),
	(1013559897, "Enrique", "Iglesias", 980505989 ),
	(1013559799, "Ricardo", "Montaner", 980505528 ),
	(1013598989, "Laura", "Pausini", 980505880 ),
	(1013569898, "Miguel", "Bose", 980505898 ),
	(1013565987, "Monica", "Naranjo", 980505745) 
;
	
INSERT INTO Productos VALUES
	(NULL, "ALGODON RECICLAJE", 10000),
	(NULL, "ALGODON INDIO", 20000),
	(NULL, "ALGODON AMERICANO", 15000),
	(NULL, "ALGODON EGIPCIO", 35000)
;
	
INSERT INTO Despachos VALUES
	(NULL, 20220101, 500, 1000, 1, 890521458, 1013555889),
	(NULL, 20220201, 600, 2000, 2, 890521458, 1013555889),
	(NULL, 20220430, 100, 500, 3, 890521458, 1013555889),
	(NULL, 20220430, 700, 1000, 4, 890521458, 1013555889),
	(NULL, 20220101, 800, 1100, 1, 890521554, 1013555998),
	(NULL, 20220130, 900, 1200, 2, 890521554, 1013555998),
	(NULL, 20220202, 1000, 1300, 3, 890521554, 1013555998),
	(NULL, 20220225, 1100, 1400, 4, 890521554, 1013555998),
	(NULL, 20220101, 500, 1000, 1, 890521548, 1013554689),
	(NULL, 20220101, 600, 1200, 2, 890521548, 1013554689),
	(NULL, 20220101, 400, 800, 3, 890521548, 1013554689),
	(NULL, 20220101, 300, 600, 4, 890521548, 1013554689),
	(NULL, 20220101, 300, 600, 1, 890000029, 1013559897),
	(NULL, 20220101, 1000, 2000, 2, 890000029, 1013559897),
	(NULL, 20220301, 1200, 2400, 3, 890000029, 1013559897),
	(NULL, 20220330, 900, 1800, 4, 890000029, 1013559897),
	(NULL, 20220701, 100, 200, 1, 890154858, 1013559799),
	(NULL, 20220730, 200, 400, 2, 890154858, 1013559799),
	(NULL, 20220701, 300, 600, 3, 890154858, 1013559799),
	(NULL, 20220801, 400, 800, 4, 890154858, 1013559799),
	(NULL, 20220601, 600, 1200, 1, 890555889, 1013598989),
	(NULL, 20220501, 700, 1400, 2, 890555889, 1013598989),
	(NULL, 20220530, 800, 1600, 3, 890555889, 1013598989),
	(NULL, 20220415, 900, 1800, 4, 890555889, 1013598989),
	(NULL, 20220202, 700, 1400, 1, 890555858, 1013569898),
	(NULL, 20220303, 750, 1500, 2, 890555858, 1013569898),
	(NULL, 20220430, 650, 1300, 3, 890555858, 1013569898),
	(NULL, 20220115, 900, 1800, 4, 890555858, 1013569898),
	(NULL, 20220101, 900, 1800, 1, 890555986, 1013565987),
	(NULL, 20220630, 600, 1200, 2, 890555986, 1013565987),
	(NULL, 20220530, 100, 200, 3, 890555986, 1013565987),
	(NULL, 20220501, 50, 100, 4, 890555986, 1013565987),
	(NULL, 20220202, 1200, 2400, 1, 890555598, 1013555889),
	(NULL, 20220430, 100, 200, 2, 890555598, 1013555889),
	(NULL, 20220530, 300, 300, 3, 890555598, 1013555889),
	(NULL, 20220801, 500, 1000, 4, 890555598, 1013555889),
	(NULL, 20220801, 500, 1000, 1, 890555558, 1013555998),
	(NULL, 20220630, 100, 200, 2, 890555558, 1013555998),
	(NULL, 20220101, 550, 1100, 3, 890555558, 1013555998),
	(NULL, 20220701, 350, 700, 4, 890555558, 1013555998),
	(NULL, 20220701, 400, 800, 1, 890555258, 1013554689),
	(NULL, 20220515, 500, 1000, 2, 890555258, 1013554689),
	(NULL, 20220630, 800, 1600, 3, 890555258, 1013554689),
	(NULL, 20220130, 1000, 2000, 4, 890555258, 1013554689),
	(NULL, 20220130, 1000, 2000, 1, 890569887, 1013559897),
	(NULL, 20220615, 500, 1000, 2, 890569887, 1013559897),
	(NULL, 20220115, 600, 1200, 3, 890569887, 1013559897),
	(NULL, 20220315, 700, 1400, 4, 890569887, 1013559897),
	(NULL, 20220315, 700, 1400, 1, 890552566, 1013559799),
	(NULL, 20220630, 800, 1600, 2, 890552566, 1013559799),
	(NULL, 20220415, 850, 1700, 3, 890552566, 1013559799),
	(NULL, 20220130, 950, 1800, 4, 890552566, 1013559799),
	(NULL, 20220130, 800, 6000, 1, 890254587, 1013598989),
	(NULL, 20220401, 950, 1800, 2, 890254587, 1013598989),
	(NULL, 20220501, 200, 400, 3, 890254587, 1013598989),
	(NULL, 20220801, 100, 200, 4, 890254587, 1013598989),
	(NULL, 20220801, 100, 200, 1, 890550655, 1013569898),
	(NULL, 20220701, 1000, 2000, 2, 890550655, 1013569898),
	(NULL, 20220601, 400, 800, 3, 890550655, 1013569898),
	(NULL, 20220501, 50, 100, 4, 890550655, 1013569898)