Subversion Repositories SmartDukaan

Rev

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

Rev 18586 Rev 18591
Line 639... Line 639...
639
    sequence = Field(Integer, default=0)
639
    sequence = Field(Integer, default=0)
640
    invoiceFormat = Field(Integer, default=1)
640
    invoiceFormat = Field(Integer, default=1)
641
    using_options(shortnames=True)
641
    using_options(shortnames=True)
642
    using_table_options(mysql_engine="InnoDB")
642
    using_table_options(mysql_engine="InnoDB")
643
 
643
 
644
class Creditors(Entity):
644
class Creditor(Entity):
645
    id = Field(Integer, primary_key=True, autoincrement=True)
645
    id = Field(Integer, primary_key=True, autoincrement=True)
646
    name = Field(String(64))
646
    name = Field(String(64))
647
    active = Field(Boolean)
647
    active = Field(Boolean)
648
    updated = Field(DateTime, onupdate=datetime.datetime.now)
648
    updated = Field(DateTime, onupdate=datetime.datetime.now)
649
    created = Field(DateTime,default = datetime.datetime.now)
649
    created = Field(DateTime,default = datetime.datetime.now)
650
    using_options(shortnames=True)
650
    using_options(shortnames=True)
651
    using_table_options(mysql_engine="InnoDB")
651
    using_table_options(mysql_engine="InnoDB")
652
 
652
 
653
class UserSanctions(Entity):
653
class UserSanction(Entity):
654
    id = Field(Integer, primary_key=True, autoincrement=True)
654
    id = Field(Integer, primary_key=True, autoincrement=True)
655
    user_id = Field(Integer)
655
    user_id = Field(Integer)
656
    creditor_id = Field(Integer)
656
    creditor_id = Field(Integer)
657
    user_ref_id = String(24)
657
    user_ref_id = String(24)
658
    credit_limit = Field(Float)
658
    credit_limit = Field(Float)