hVGufCkT

1Täs taas hieman advanced systeemi :D
2DROP DATABASE IF EXISTS koulutus_database;
3CREATE DATABASE IF NOT EXISTS koulutus_database;
4
5CREATE TABLE IF NOT EXISTS users
6(
7    user_id INT(11) AUTO_INCREMENT PRIMARY KEY NOT NULL,
8    user_displayname VARCHAR(40) NOT NULL,
9    user_firstname VARCHAR(30) NOT NULL,
10    user_lastname VARCHAR(30) NOT NULL,
11    user_joindate TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP(),
12    user_email VARCHAR(30) NOT NULL,
13    user_password VARCHAR(255) NOT NULL
14);
15INSERT INTO users(`user_id`,`user_displayname`,`user_firstname`,`user_lastname`,`user_joindate`,`user_email`,`user_password`)
16VALUES (null, "someDisplayName","my","awesomename", null, "myawesome@email.com", "<someHashhere>");#Point being on the DATE function. koska SQLi uus versio on kiva: CURRENT_DATE() ei ole valid default value.  user_joindate value can be CURRENT_TIMESTAMP()