Subversion Repositories SmartDukaan

Rev

Rev 1845 | Rev 1976 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 1845 Rev 1859
Line 179... Line 179...
179
    using_table_options(mysql_engine="InnoDB")
179
    using_table_options(mysql_engine="InnoDB")
180
 
180
 
181
class MasterAffiliate(Entity):
181
class MasterAffiliate(Entity):
182
    id = Field(Integer, primary_key=True, autoincrement=True)
182
    id = Field(Integer, primary_key=True, autoincrement=True)
183
    name = Field(String(100), unique=True)
183
    name = Field(String(100), unique=True)
-
 
184
    added_on = Field(DateTime)
184
    affiliates = OneToMany("Affiliate")
185
    affiliates = OneToMany("Affiliate")
185
    using_options(shortnames=True)
186
    using_options(shortnames=True)
186
    using_table_options(mysql_engine="InnoDB")
187
    using_table_options(mysql_engine="InnoDB")
187
 
188
 
188
class Affiliate(Entity):
189
class Affiliate(Entity):
189
    id = Field(Integer, primary_key=True, autoincrement=True)
190
    id = Field(Integer, primary_key=True, autoincrement=True)
190
    master_affiliate = ManyToOne("MasterAffiliate")
191
    master_affiliate = ManyToOne("MasterAffiliate")
191
    name = Field(String(100), unique=True)
192
    name = Field(String(100), unique=True)
192
    url = Field(String(200))
193
    url = Field(String(200))
-
 
194
    added_on = Field(DateTime)
193
    trackers = OneToMany("Tracker")
195
    trackers = OneToMany("Tracker")
194
    using_options(shortnames=True)
196
    using_options(shortnames=True)
195
    using_table_options(mysql_engine="InnoDB")
197
    using_table_options(mysql_engine="InnoDB")
196
 
198
 
197
class Tracker(Entity):
199
class Tracker(Entity):
198
    id = Field(Integer, primary_key=True, autoincrement=True)
200
    id = Field(Integer, primary_key=True, autoincrement=True)
-
 
201
    added_on = Field(DateTime)
199
    affiliate = ManyToOne("Affiliate")
202
    affiliate = ManyToOne("Affiliate")
200
    tracklogs = OneToMany("TrackLog")
203
    tracklogs = OneToMany("TrackLog")
201
    using_options(shortnames=True)
204
    using_options(shortnames=True)
202
    using_table_options(mysql_engine="InnoDB")
205
    using_table_options(mysql_engine="InnoDB")
203
 
206
 
204
class TrackLog(Entity):
207
class TrackLog(Entity):
205
    id = Field(Integer, primary_key=True, autoincrement=True)
208
    id = Field(Integer, primary_key=True, autoincrement=True)
-
 
209
    added_on = Field(DateTime)
206
    tracker = ManyToOne("Tracker")
210
    tracker = ManyToOne("Tracker")
207
    user_id = Field(Integer)
211
    user_id = Field(Integer)
208
    event = Field(String(100))
212
    event = Field(String(100))
209
    url = Field(String(200))
213
    url = Field(String(200))
210
    data = Field(String(200))
214
    data = Field(String(200))