<prompt> Andika hati ya SQL inayounda schema ya hifadhidata ya jukwaa la msingi la biashara ya mtandaoni yenye majedwali ya bidhaa, wateja na maagizo.  <response>: sql-- Unda hifadhidata ya e-commerceTUNZA DATABASE ecommerce;-- Tumia hifadhidata iliyoundwaTUMIA ecommerce;- Unda meza ya bidhaaTUNZA bidhaa za TABLE id INT AUTO_INCREMENT FUNGUO YA MSINGI, jina VARCHAR255 SI UFUPI, maelezo TEXT, bei DECIMAL10, 2 SIO BATILI, wingi INT NOT NULL, picha_url VARCHAR255;-- Unda meza ya watejaTUNZA wateja wa TABLE id INT AUTO_INCREMENT FUNGUO YA MSINGI, first_name VARCHAR50 NOT NULL, jina_la mwisho VARCHAR50 SI UFUPI, barua pepe VARCHAR100 UNIQUE NOT NULL, nambari_ya_simu VARCHAR20, anwani VARCHAR255, mji VARCHAR100, jimbo VARCHAR100, zip_code VARCHAR10, nchi VARCHAR100;- Unda meza ya maagizoTUNZA maagizo ya TABLE id INT AUTO_INCREMENT FUNGUO YA MSINGI, kitambulisho cha mteja INT NOT NULL, tarehe_ya kuagiza DATETIME DEFAULT CURRENT_TIMESTAMP, hali ENUMinasubiri, inachakata, imesafirishwa, imewasilishwa, imeghairiwa SIO BATILI, jumla_kiasi DECIMAL10, 2 SIO BATILI, UFUNGUO WA NJE ID_ya_mteja MAREJEO watejaid;-- Tengeneza jedwali la_vipengeeUTENGENEZA vitu_vya_kuagiza TABLE id INT AUTO_INCREMENT FUNGUO YA MSINGI, order_id INT NOT NULL, product_id INT NOT NULL, wingi INT NOT NULL, bei DECIMAL10, 2 SIO BATILI, UFUNGUO WA NJE oda_id MAREJEO maagizoid, UFUNGUO WA KIGENI id_ya_bidhaa MAREJEO bidhaaid; 