/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: gustav.hartvigsson at gmail
  • Date: 2013-04-04 12:40:49 UTC
  • mfrom: (14.1.2 database)
  • Revision ID: gustav.hartvigsson@gmail.com-20130404124049-60z8zhwl2xitrogt
merged Wikxens stuff to use localhost db, and user.

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'