Subversion Repositories SmartDukaan

Rev

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

Rev 4897 Rev 4917
Line 55... Line 55...
55
    using_table_options(mysql_engine="InnoDB")
55
    using_table_options(mysql_engine="InnoDB")
56
    
56
    
57
class Item(Entity):
57
class Item(Entity):
58
    id = Field(Integer, primary_key=True, autoincrement=True)
58
    id = Field(Integer, primary_key=True, autoincrement=True)
59
    product_group = Field(String(100))
59
    product_group = Field(String(100))
60
    brand = Field(String(100))
60
    brand = Field(String(100), default='', server_default='')
61
    model_number = Field(String(50))
61
    model_number = Field(String(50), default='', server_default='')
62
    model_name = Field(String(50))
62
    model_name = Field(String(100), default='', server_default='')
63
    color = Field(String(20))
63
    color = Field(String(20), default='', server_default='')
64
    category = Field(Integer)
64
    category = Field(Integer, default=0, server_default="0")
65
    comments = Field(String(200))
65
    comments = Field(String(200))
66
    catalog_item_id = Field(Integer)
66
    catalog_item_id = Field(Integer)
67
    feature_id = Field(Integer)
67
    feature_id = Field(Integer)
68
    feature_description = Field(String(200))
68
    feature_description = Field(String(200))
69
    mrp = Field(Float)
69
    mrp = Field(Float)