---
detect_relations: true

FwlUser:
 actAs:
  Timestampable: ~
 columns:
  id:
   type: integer
   notnull: true
   primary: true
   autoincrement: true
   unique: true
  username:
   type: string(50)
   notnull: true
   unique: true
  password:
   type: string(32)
   notnull: true
  salt:
   type: string(5)
   notnull: true
  email:
   type: string(100)
   notnull: true
  name_first:
   type: string(100)
   notnull: true
  name_last:
   type: string(100)
   notnull: true
  name_middle:
   type: string(100)
  country:
   type: integer
  state:
   type: varchar(200)
  city:
   type: varchar(200)
  address:
   type: varchar(200)
  address2:
   type: varchar(200)
  zipcode:
   type: varchar(20)
  phone:
   type: varchar(20)
  status:
   type: enum
   values: [active,suspended,cancelled,unverified,banned,moderated]

FwlProject:
 actAs:
  Timestampable: ~
 columns:
  id:
   type: integer
   notnull: true
   primary: true
   autoincrement: true
   unique: true
  title:
   type: string(255)
   notnull: true
  description:
   type: clob
   notnull: true
  visible:
   type: boolean
   default: true
  date_starts:
   type: timestamp
   notnull: true
  date_ends:
   type: timestamp
   notnull: true
  user_id:
   type: integer
   notnull: true
  status:
   type: enum
   values: [draft,open,closed,expired,delisted,wait_approval,approval_accepted,frozen,finished,archived]
 relations:
  Categories:
   class: FwlCategory
   refClass: FwlProjectCategory
   foreignAlias: ProjectCategories

FwlCategory:
 actAs:
  Timestampable: ~
 columns:
  id:
   type: integer
   notnull: true
   primary: true
   autoincrement: true
   unique: true
  parent_id:
   type: integer
   notnull: true
   default: 0
  title:
   type: string(255)
   notnull: true
  visible:
   type: boolean
   default: true
  sorting:
   type: integer
   default: 1

FwlProjectCategory:
 columns:
  project_id:
   type: integer
   primary: true
  category_id:
   type: integer
   primary: true
 relations:
  FwlProject:
   local: project_id
   foreignAlias: FwlProjectCategories
  FwlCategory:
   local: category_id
   foreignAlias: FwlProjectCategories

--- fixtures
---
FwlUser:
  admin:
    id: 1
    username: admin
    salt: !TOIR
    password: 25dfe310420a57feb2a29edc691ba23f
    email: serg.buslovsky@gmail.com
    name_first: Serg
    name_last: Buslovsky
    status: active
  user1:
    id: 2
    username: user1
    salt: !T23A
    password: 3932904a39f13e6c1add64d35c6cee61
    email: user1@gmail.com
    name_first: User
    name_last: First
    status: active

FwlCategory:
  design:
    id: 1
    title: Design
  logo_design:
    id: 4
    parent_id: 1
    title: Logo Design
  programming:
    id: 2
    title: Programming
  management:
    id: 3
    title: Management

FwlProject:
  project1:
    title: First Test Project
    description: |
     some info
     about project1
    user_id: 2
    Categories: [design, logo_design]
  project2:
    title: Second Test Project
    description: |
     about project2
     some info
    user_id: 2