bzr branch
http://gegoxaren.bato24.eu/bzr/lenasys/trunk
|
1
by Henrik G.
First seed of Lenasys ... Needs to be Organized Further |
1 |
CREATE TABLE userLoginsLog( |
2 |
id INTEGER AUTO_INCREMENT, |
|
3 |
loginName VARCHAR(16), |
|
4 |
userAgent VARCHAR(1024), /*$_SERVER['HTTP_USER_AGENT']*/ |
|
5 |
userIP VARCHAR(20), /*$_SERVER['REMOTE_ADDR']*/ |
|
6 |
DateTime TIMESTAMP, |
|
7 |
success VARCHAR(25), |
|
8 |
courseName VARCHAR(100), |
|
9 |
courseOccasion VARCHAR(25), |
|
10 |
quizNr INTEGER, |
|
11 |
PRIMARY KEY(id) |
|
12 |
) ENGINE=INNODB CHARACTER SET utf8 COLLATE utf8_swedish_ci; |