Subversion Repositories SmartDukaan

Rev

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

Rev 15245 Rev 15254
Line 118... Line 118...
118 
class Retailers(Entity):
 118 
class Retailers(Entity):
119 
    id = Field(Integer(unsigned=True), primary_key=True)
 119 
    id = Field(Integer(unsigned=True), primary_key=True)
120 
    identifier = Field(String(128))
 120 
    identifier = Field(String(128))
121 
    title = Field(String(256))
 121 
    title = Field(String(256))
122 
    address = Field(String(512))
 122 
    address = Field(String(512))
- 
 
 123 
    address_new = Field(String(512))
123 
    agent_id=Field(Integer(unsigned=True))
 124 
    agent_id=Field(Integer(unsigned=True))
124 
    contact1 = Field(String(10))
 125 
    contact1 = Field(String(10))
125 
    contact2 = Field(String(10))
 126 
    contact2 = Field(String(10))
126 
    pin = Field(String(6))
 127 
    pin = Field(String(6))
- 
 
 128 
    cod_limit = Field(Integer(10))
127 
    state = Field(String(48))
 129 
    state = Field(String(48))
128 
    status = Field(String(20))
 130 
    status = Field(String(20))
129 
    is_elavated = Field(Boolean)
 131 
    is_elavated = Field(Boolean)
130 
    retry_count = Field(Integer(3))
 132 
    retry_count = Field(Integer(3))
131 
    invalid_retry_count = Field(Integer(3))
 133 
    invalid_retry_count = Field(Integer(3))
Line 137... Line 139...
137 
    disposition = Field(String(32))
 139 
    disposition = Field(String(32))
138 
    modified = Field(DateTime, default=func.now(), onupdate=func.now())
 140 
    modified = Field(DateTime, default=func.now(), onupdate=func.now())
139 
    using_options(shortnames=True)
 141 
    using_options(shortnames=True)
140 
    using_table_options(mysql_engine="InnoDB")
 142 
    using_table_options(mysql_engine="InnoDB")
141 
 
 143 
 
- 
 
 144 
class RetailerContacts(Entity):
- 
 
 145 
    id = Field(Integer(unsigned=True), primary_key=True)
- 
 
 146 
    retailer_id = Field(Integer(unsigned=True))
- 
 
 147 
    agent_id = Field(Integer(unsigned=True))
- 
 
 148 
    mobile_number = Field(String(10))
- 
 
 149 
    contact_type = Field(Enum('sms', 'call'))
- 
 
 150 
    call_type = Field(String(10))
- 
 
 151 
    created = Field(DateTime,default=func.now())
- 
 
 152 
    using_options(shortnames=True)
- 
 
 153 
    using_table_options(mysql_engine="InnoDB")
- 
 
 154
- 
 
 155 
 
142 
class CallHistory(Entity):
 156 
class CallHistory(Entity):
143 
    id = Field(Integer(unsigned=True), primary_key=True)
 157 
    id = Field(Integer(unsigned=True), primary_key=True)
144 
    retailer_id = Field(Integer(unsigned=True))
 158 
    retailer_id = Field(Integer(unsigned=True))
145 
    agent_id = Field(Integer(unsigned=True))
 159 
    agent_id = Field(Integer(unsigned=True))
146 
    mobile_number = Field(String(10))
 160 
    mobile_number = Field(String(10))
Line 164... Line 178...
164 
    using_options(shortnames=True)
 178 
    using_options(shortnames=True)
165 
    using_table_options(mysql_engine="InnoDB")
 179 
    using_table_options(mysql_engine="InnoDB")
166
180
167 
class RetailerLinks(Entity):
 181 
class RetailerLinks(Entity):
168 
    id = Field(Integer(unsigned=True), primary_key=True)
 182 
    id = Field(Integer(unsigned=True), primary_key=True)
169 
    retailer_id = Field(Integer(unsigned=True))
 183 
    retailer_id = Field(Integer(unsigned=True), unique=True)
170 
    agent_id = Field(Integer(unsigned=True))
 184 
    agent_id = Field(Integer(unsigned=True))
171 
    code = Field(String(10), unique=True)
 185 
    code = Field(String(10), unique=True)
172 
    is_activated = Field(Boolean)
 186 
    is_activated = Field(Boolean)
173 
    activated = Field(DateTime,onupdate=func.now())
 187 
    activated = Field(DateTime,onupdate=func.now())
- 
 
 188 
    user_id = Field(unsigned=True)
- 
 
 189 
    mapped_contact = Field(String)
174 
    created = Field(DateTime,default=func.now())
 190 
    created = Field(DateTime,default=func.now())
175 
    using_options(shortnames=True)
 191 
    using_options(shortnames=True)
176 
    using_table_options(mysql_engine="InnoDB")
 192 
    using_table_options(mysql_engine="InnoDB")
177
193
178 
class Activation_Codes(Entity):
 194 
class Activation_Codes(Entity):