/extremedating/trunk

To get this branch, use:
bzr branch http://gegoxaren.bato24.eu/bzr/extremedating/trunk

« back to all changes in this revision

Viewing changes to php/db.php

  • Committer: Gustav Hatvigsson
  • Date: 2013-04-13 22:52:52 UTC
  • mfrom: (41 extremedating)
  • mto: This revision was merged to the branch mainline in revision 43.
  • Revision ID: gustav.hartvigsson@gmail.com-20130413225252-1ubhpidinnqmvhve
merge

Show diffs side-by-side

added added

removed removed

Lines of Context:
php/db.php
99
99
    PRIMARY KEY(loginName, foodType)
100
100
    );
101
101
  "); 
 
102
  
 
103
        $db->exec("
 
104
                CREATE TABLE IF NOT EXISTS dateInterests(
 
105
                user1 varchar(64),
 
106
                user2 varchar(64),
 
107
                FOREIGN KEY(user1) REFERENCES USERS(loginName),
 
108
                FOREIGN KEY(user2) REFERENCES USERS(loginName),
 
109
                PRIMARY KEY(user1, user2)
 
110
                );
 
111
        ");
102
112
} catch (PDOException $err) {
103
113
  echo $err;
104
114
}