/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: Daniel Johansson
  • Date: 2013-04-14 05:10:39 UTC
  • Revision ID: maila@danieljohansson.nu-20130414051039-rs72wxozzalakqtu
added support for accepts and declines in a ugly way

Show diffs side-by-side

added added

removed removed

Lines of Context:
php/db.php
104
104
                CREATE TABLE IF NOT EXISTS dateInterests(
105
105
                user1 varchar(64),
106
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
 
        ");
 
107
                FOREIGN KEY(user1) REFERENCES Users(loginName),
 
108
                FOREIGN KEY(user2) REFERENCES Users(loginName),
 
109
                PRIMARY KEY(user1, user2)
 
110
                );
 
111
        ");
 
112
        
 
113
        $db->exec("
 
114
                CREATE TABLE IF NOT EXISTS planLunch(
 
115
                user1 varchar(64),
 
116
                user2 varchar(64),
 
117
                message varchar(1024),
 
118
                date datetime,
 
119
                accepted bool,
 
120
                FOREIGN KEY(user1) REFERENCES Users(loginName),
 
121
                FOREIGN KEY(user2) REFERENCES Users(loginName),
 
122
                PRIMARY KEY(user1, user2)
 
123
                );
 
124
        ");
 
125
        
112
126
} catch (PDOException $err) {
113
127
  echo $err;
114
128
}