public function Create(\Database $db)
{
$db->createField(TableAttendance::EVENT_ID, "Varchar(40)", "NOT NULL");
$db->createField(TableAttendance::USER_ID, "Varchar(40)", "NOT NULL");
$db->createField("CONSTRAINT pk_event_goer ", "PRIMARY KEY (" . TableAttendance::EVENT_ID . "," . TableAttendance::USER_ID . ")", "");
$db->createTable(TableAttendance::TableName);
}
public function Create(\Database $db)
{
if ($db == null) {
$db = new Database();
}
//create the table
$db->createField(EventTable::Id, "Varchar(40)", "PRIMARY KEY");
$db->createField(EventTable::Privacy, "Varchar(50)", "Not Null");
$db->createField(EventTable::Status, "int", "DEFAULT 0");
$db->createField(EventTable::CreatorId, "Varchar(40)", "NOT NULL");
$db->createField(EventTable::Title, "Varchar(50)", "NOT NULL");
$db->createField(EventTable::Venue, "Varchar(40)", " Not null");
$db->createField(EventTable::CreateDate, "Varchar(40)", "NOT NULL");
$db->createField(EventTable::Description, "Text", "");
$db->createField(EventTable::StartDate, " Varchar(40)", "NOT NULL");
$db->createField(EventTable::Going, "int", "default 0");
$db->createField(EventTable::SeachableKeywords, "Text", "");
$db->createField(EventTable::CurrencyCountry, "Varchar(50)", "");
$db->createField(EventTable::Image, " Varchar(50)", "");
$db->createField(EventTable::Fees, "DOUBLE(16,2)", "default 0.0");
//$db->createFields(EventTable::StartTime, "Varchar(40)", "NOT NULL");
$db->createField(EventTable::Duration, "Varchar(50)", "Not Null");
$db->createField("FULLTEXT KEY " . EventTable::Title, "(" . EventTable::Title . "," . EventTable::Description . "," . EventTable::SeachableKeywords . "," . EventTable::Venue . ")", "");
$db->createTable(EventTable::TableName);
}
/**
* Create a new field on a table.
* @param string $table Name of the table.
* @param string $field Name of the field to add.
* @param string $spec The field specification, eg 'INTEGER NOT NULL'
*/
static function createField($table, $field, $spec)
{
return DB::$globalConn->createField($table, $field, $spec);
}
