/lenasys/0.1

To get this branch, use:
bzr branch http://gegoxaren.bato24.eu/bzr/lenasys/0.1

« back to all changes in this revision

Viewing changes to trunk/DuggaSys/log.sql

  • Committer: Henrik G.
  • Date: 2013-03-26 23:22:55 UTC
  • Revision ID: henrik.gustavsson@his.se-20130326232255-ik6snyatlbkf3zs1
First seed of Lenasys ... Needs to be Organized Further

Show diffs side-by-side

added added

removed removed

Lines of Context:
trunk/DuggaSys/log.sql
 
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;
 
 
b'\\ No newline at end of file'