/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 11:58:44 UTC
  • mto: This revision was merged to the branch mainline in revision 15.
  • Revision ID: wikxen@gmail.com-20130404115844-9r4u16eths3v9ivw
moved db.sql to the root folder

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
 
 
8
5
/* Students */
9
6
CREATE TABLE Student(
10
7
    ssn CHAR(11), /*YYMMDD-XXXX*/
148
145
BEGIN
149
146
   SELECT userName,passw,userType FROM QSystemUser WHERE userName=userName AND passw=userPassword;
150
147
END;
151
 
//
 
 
b'\\ No newline at end of file'
 
148
//
 
149
DELIMITER ;
 
150
 
 
151
;
 
 
b'\\ No newline at end of file'