Advertisement
Guest User

Untitled

a guest
Feb 23rd, 2019
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.73 KB | None | 0 0
  1. propel reverse "mysql:host=localhost;dbname=MyVanLog;user=**;password=**"
  2.  
  3. <table name="LogEntries" idMethod="native" phpName="Logentries">
  4. <column name="LogEntryId" phpName="Logentryid" type="INTEGER" primaryKey="true" autoIncrement="true" required="true"/>
  5. <column name="UserId" phpName="Userid" type="INTEGER" primaryKey="true" required="true"/>
  6. <column name="RvId" phpName="Rvid" type="INTEGER" primaryKey="true" required="true"/>
  7. <column name="Title" phpName="Title" type="VARCHAR" size="45" required="true"/>
  8. <column name="Description" phpName="Description" type="CLOB"/>
  9. <column name="Longitude" phpName="Longitude" type="DECIMAL" size="10" scale="8"/>
  10. <column name="Latitude" phpName="Latitude" type="DECIMAL" size="10" scale="8"/>
  11. <column name="Temperature" phpName="Temperature" type="DECIMAL" size="3" scale="1"/>
  12. <column name="Private" phpName="Private" type="VARCHAR" size="1" sqlType="bit(1)" required="true"/>
  13. <column name="CreatedOnUTC" phpName="Createdonutc" type="TIMESTAMP" required="true"/>
  14. <column name="ModifiedOnUTC" phpName="Modifiedonutc" type="TIMESTAMP" required="true"/>
  15. <foreign-key foreignTable="Users" name="FK_36">
  16. <reference local="UserId" foreign="UserId"/>
  17. </foreign-key>
  18. <foreign-key foreignTable="Rvs" name="FK_40">
  19. <reference local="RvId" foreign="RvId"/>
  20. <reference local="UserId" foreign="UserId"/>
  21. </foreign-key>
  22. <index name="fkIdx_36">
  23. <index-column name="UserId"/>
  24. </index>
  25. <index name="fkIdx_40">
  26. <index-column name="RvId"/>
  27. <index-column name="UserId"/>
  28. </index>
  29. <vendor type="mysql">
  30. <parameter name="Engine" value="InnoDB"/>
  31. </vendor>
  32.  
  33. /**
  34. * Get the [fuelpriceinvalid] column value.
  35. *
  36. * @return string
  37. */
  38. public function getFuelpriceinvalid()
  39. {
  40. return $this->fuelpriceinvalid;
  41. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement