Changes between Version 2 and Version 3 of StoreRegistration


Ignore:
Timestamp:
12/30/25 15:21:51 (13 hours ago)
Author:
235018
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • StoreRegistration

    v2 v3  
    1212
    1313{{{#!sql
    14 INSERT INTO personal (id, first_name, last_name, ssn, email, password)
    15 VALUES ('0010001', 'Anna', 'Ivanova', '1234567890123', 'anna@store.com
    16 ', 'hashed_pw');
     14INSERT INTO personal (id, first_name, last_name, ssn, email, password) VALUES
     15('0010001', 'Anna', 'Ivanova', '1234567890123', 'anna@store.com', 'hashed_pw');
    1716
    1817}}}
    … …  
    2120
    2221{{{#!sql
    23 INSERT INTO boss (boss_ID)
    24 VALUES ('0010001');
     22INSERT INTO boss (boss_ID) VALUES
     23('0010001');
    2524
    2625}}}
    … …  
    2928
    3029{{{#!sql
    31 INSERT INTO works_in_store (personal_ID, store_ID)
    32 VALUES ('0010001', '001');
     30INSERT INTO works_in_store (personal_ID, store_ID) VALUES
     31('0010001', '001');
    3332
    3433}}}
    … …  
    3837
    3938{{{#!sql
    40 INSERT INTO store (store_ID, name, date_of_founding, physical_address, store_email)
    41 VALUES ('001', 'HandCraft001', '2024-01-01',
    42 'st.Main num.5, Skopje 1000, MK',
    43 'store001@shop.com
    44 ');
     39INSERT INTO store (store_ID, name, date_of_founding, physical_address, store_email) VALUES
     40('001', 'HandCraft001', '2024-01-01', 'st.Main num.5, Skopje 1000, MK', 'store001@shop.com');
    4541
    4642}}}