/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 db.sql

  • Committer: Erik Wikström
  • Date: 2013-04-04 12:31:59 UTC
  • mto: This revision was merged to the branch mainline in revision 15.
  • Revision ID: wikxen@gmail.com-20130404123159-g2ql2hfdyuaq00bd
Added user creation to db.sql, and switched to use the database on localhost

Show diffs side-by-side

added added

removed removed

Lines of Context:
db.sql
2
2
CREATE DATABASE dsystem;
3
3
USE dsystem;
4
4
 
 
5
CREATE USER 'dbsk'@'localhost' IDENTIFIED BY 'Tomten2009';
 
6
GRANT ALL PRIVILEGES ON 'dsystem'.* TO 'dbsk'@'localhost' WITH GRANT OPTION;
 
7
 
5
8
/* Students */
6
9
CREATE TABLE Student(
7
10
    ssn CHAR(11), /*YYMMDD-XXXX*/
145
148
BEGIN
146
149
   SELECT userName,passw,userType FROM QSystemUser WHERE userName=userName AND passw=userPassword;
147
150
END;
148
 
//
149
 
DELIMITER ;
150
 
 
151
 
;
 
 
b'\\ No newline at end of file'
 
151
//
 
 
b'\\ No newline at end of file'