CMS Made Simple Forums

Code: Select all

	function Install()
	{
		
		// Typical Database Initialization
		$db = &$this->cms->db;
		
		// mysql-specific, but ignored by other database
		$taboptarray = array('mysql' => 'TYPE=MyISAM');
		$dict = NewDataDictionary($db);
		
		// CONTACTS table

    // table schema description
    $flds = "
			id I KEY,
			name C(80),
			email C(80),
			position C(80)
			";

		// create it. This should do error checking, but I'm a lazy sod.
		$sqlarray = $dict->CreateTableSQL(cms_db_prefix()."module_testmodule_contacts",
				$flds, $taboptarray);
		$dict->ExecuteSQLArray($sqlarray);

		// create a sequence
		$db->CreateSequence(cms_db_prefix()."module_testmodule_contacts_seq");

		// CONTACTGROUPS table

		// table schema description
    $flds = "
			id I KEY,
			group C(80),
			contact I
			";

		// create it. This should do error checking, but I'm a lazy sod.
		$sqlarray = $dict->CreateTableSQL(cms_db_prefix()."module_testmodule_contactgroups",
				$flds, $taboptarray);
		$dict->ExecuteSQLArray($sqlarray);

		// create a sequence
		$db->CreateSequence(cms_db_prefix()."module_testmodule_contactgroups_seq");
	
		
		// permissions
		

		// put mention into the admin log
		$this->Audit( 0, $this->Lang('friendlyname'), $this->Lang('installed',$this->GetVersion()));
	}