-- 2. Create 'Vartotojai' (Users) table CREATE TABLE vartotojai ( id INT AUTO_INCREMENT PRIMARY KEY, vardas VARCHAR(50) NOT NULL, pavarde VARCHAR(50) NOT NULL, el_pastas VARCHAR(100) UNIQUE NOT NULL, slaptazodis VARCHAR(255) NOT NULL, sukurta_data TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); -- 3. Create 'Kategorijos' (Categories) table CREATE TABLE kategorijos ( id INT AUTO_INCREMENT PRIMARY KEY, pavadinimas VARCHAR(100) NOT NULL, aprasymas TEXT ); -- 4. Create 'Prekes' (Products) table with a Foreign Key CREATE TABLE prekes ( id INT AUTO_INCREMENT PRIMARY KEY, kategorija_id INT, pavadinimas VARCHAR(100) NOT NULL, kaina DECIMAL(10, 2) NOT NULL, kiekis INT DEFAULT 0, ar_aktyvus BOOLEAN DEFAULT TRUE, FOREIGN KEY (kategorija_id) REFERENCES kategorijos(id) ON DELETE SET NULL ); Use code with caution. Copied to clipboard 3. Data Population (Seed Data) Add initial "seed" data to verify the database structure.
: If building a CMS, you might implement a "draft" system by adding an IsFinal or Status column to your tables to distinguish between published and unpublished entries. Duombaze.sql
: For larger datasets, consider adding indexes to columns frequently used in WHERE clauses to improve performance. Create 'Prekes' (Products) table with a Foreign Key
: Always use NOT NULL for required fields and UNIQUE for identifiers like emails to prevent duplicates. : If building a CMS, you might implement
Including common queries can serve as documentation for other developers. You can also use tools like dbForge Documenter to generate comprehensive documentation in HTML or PDF formats.