19 lines
610 B
MySQL
19 lines
610 B
MySQL
|
CREATE TABLE users (
|
||
|
|
id SERIAL PRIMARY KEY,
|
||
|
|
username VARCHAR(256) NOT NULL,
|
||
|
|
password VARCHAR(256) NOT NULL,
|
||
|
|
securitycode VARCHAR(3) NOT NULL,
|
||
|
|
timestamp TIMESTAMP NOT NULL
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE TABLE implants (
|
||
|
|
id SERIAL PRIMARY KEY,
|
||
|
|
name VARCHAR(256) NOT NULL,
|
||
|
|
info VARCHAR(256) NOT NULL,
|
||
|
|
ownername VARCHAR(256) NOT NULL,
|
||
|
|
timestamp TIMESTAMP NOT NULL
|
||
|
|
);
|
||
|
|
|
||
|
|
ALTER TABLE users ALTER COLUMN timestamp SET DEFAULT now();
|
||
|
|
ALTER TABLE implants ALTER COLUMN timestamp SET DEFAULT now();
|