protected function handleIndexKeys(CreateTable $schema) { $indexes = $schema->getIndexes(); if (empty($indexes)) { return array(); } $sql = array(); $table = $schema->getTableName(); foreach ($indexes as $name => $columns) { $sql[] = 'CREATE INDEX ' . $this->wrap($table . '_' . $name) . ' ON ' . $this->wrap($table) . '(' . $this->wrapArray($columns) . ')'; } return $sql; }
<?php $table = new CreateTable("parq_form"); $table->AddColumn('id')->SetAutoIncrement(); $table->AddColumn('userID')->MakeInt()->AddKey('unique'); $table->AddColumn('DateCompleted')->MakeInt()->DefaultValue(0); $table->AddColumn('completed')->MakeBool()->DefaultValue('false'); $table->AddColumn('q1_1')->MakeInt(); $table->AddColumn('q1_2')->MakeInt(); $table->AddColumn('q1_3')->MakeInt(); $table->AddColumn('q1_4')->MakeInt(); $table->AddColumn('q1_5')->MakeInt(); $table->AddColumn('q1_6')->MakeInt(); $table->AddColumn('q1_7')->MakeInt(); $table->AddColumn('q2_1')->MakeInt()->DefaultValue(-1); $table->AddColumn('q2_1_1')->MakeInt()->DefaultValue(-1); $table->AddColumn('q2_1_2')->MakeInt()->DefaultValue(-1); $table->AddColumn('q2_1_3')->MakeInt()->DefaultValue(-1); $table->AddColumn('q2_2')->MakeInt()->DefaultValue(-1); $table->AddColumn('q2_2_1')->MakeInt()->DefaultValue(-1); $table->AddColumn('q2_2_2')->MakeInt()->DefaultValue(-1); $table->AddColumn('q2_3')->MakeInt()->DefaultValue(-1); $table->AddColumn('q2_3_1')->MakeInt()->DefaultValue(-1); $table->AddColumn('q2_3_2')->MakeInt()->DefaultValue(-1); $table->AddColumn('q2_3_3')->MakeInt()->DefaultValue(-1); $table->AddColumn('q2_3_4')->MakeInt()->DefaultValue(-1); $table->AddColumn('q2_3_5')->MakeInt()->DefaultValue(-1); $table->AddColumn('q2_4')->MakeInt()->DefaultValue(-1); $table->AddColumn('q2_4_1')->MakeInt()->DefaultValue(-1); $table->AddColumn('q2_4_2')->MakeInt()->DefaultValue(-1); $table->AddColumn('q2_4_3')->MakeInt()->DefaultValue(-1);
<?php $name = "users"; $table = new CreateTable($name); $table->AddColumn('id')->SetAutoIncrement(); $table->AddColumn('email')->MakeVarChar(100)->AddKey('unique'); $table->AddColumn('password')->MakeVarChar(100); $table->AddColumn('pLevel')->MakeInt()->DefaultValue('1'); $table->AddColumn('created')->MakeInt(); $table->AddColumn('NextAssessment')->MakeInt()->DefaultValue(0); $table->AddColumn('activated')->MakeBool()->DefaultValue('false'); $table->AddColumn('salt')->MakeVarChar(100)->DefaultValue(bin2hex(mcrypt_create_iv(22, MCRYPT_DEV_URANDOM))); $table->AddColumn('salt_time')->MakeInt()->DefaultValue(0); $population = array(); $population[] = QueryFactory::Build("insert")->Into($name)->Set(["email", "*****@*****.**"], ["password", "\$2y\$11\$593EkWGKJ.1dkCN/ivW1OOOf180ijPxRPyaUr7w79fWFJmQUNietK"], ["created", "UNIX_TIMESTAMP()"], ["pLevel", 3], ["activated", 1]); return [$table, $population];
<?php $name = "schedule"; $table = new CreateTable($name); $table->AddColumn('id')->SetAutoIncrement(); $table->AddColumn('name')->MakeVarChar(100)->AddKey('unique'); $table->AddColumn('frequency')->MakeVarChar(100); $table->AddColumn('lastRun')->MakeInt(); $population = array(); $population[] = QueryFactory::Build("insert")->Into($name)->Set(["name", "manageUsers.php"], ["frequency", "+1 minute"], ["lastRun", "UNIX_TIMESTAMP()"]); $population[] = QueryFactory::Build("insert")->Into($name)->Set(["name", "test.php"], ["frequency", "+3 months"], ["lastRun", "UNIX_TIMESTAMP()"]); //$population[] = QueryFactory::Build("insert")->Into($name)->Set(["name", "activationTimer.php"], ["frequency", "+12 hours"], ["lastRun", "UNIX_TIMESTAMP()"]); return [$table, $population];
<?php $name = basename(__FILE__, ".php"); $table = new CreateTable($name); $table->AddColumn("id")->SetAutoIncrement(); $table->AddColumn("title")->MakeVarChar(100); $table->AddColumn("content")->MakeText(); $table->AddColumn("created")->MakeInt(); $table->AddColumn("updated")->MakeInt(); $table->AddColumn("viewby")->MakeTinyInt()->DefaultValue(0); $info = array(); $insert = QueryFactory::Build("insert"); $info[] = $insert->Into($name)->Set(["title", 'Welcome to Sit and Be Fit "Feel the difference" Project!'], ["content", '<p>Welcome to the Feel the Difference project website. We are reaching' . 'out to adults 55+ and/or those managing chronic conditions with an invitation' . 'to participate in an important research study to determine the effectiveness' . 'of the Sit and Be Fit exercise program</p>' . '<iframe width="100%" height="360" src="https://www.youtube.com/embed/31Ew1ogQqpE" frameborder="0" allowfullscreen></iframe>'], ["created", "UNIX_TIMESTAMP()"], ["viewby", UserLevel::Anon]); return [$table, $info];
<?php $table = new CreateTable("questionnairep1_form"); $table->AddColumn('id')->SetAutoIncrement(); $table->AddColumn('userID')->MakeInt()->AddKey('unique'); $table->AddColumn('completed')->MakeBool()->DefaultValue('false'); $table->AddColumn('q1')->MakeInt(); $table->AddColumn('q2')->MakeInt(); $table->AddColumn('q3')->MakeInt(); $table->AddColumn('q4')->MakeInt(); $table->AddColumn('q5')->MakeInt(); $table->AddColumn('q6')->MakeInt(); $table->AddColumn('q7')->MakeInt(); $table->AddColumn('q8')->MakeInt(); $table->AddColumn('q9')->MakeInt(); $table->AddColumn('q10')->MakeInt(); $table->AddColumn('q11')->MakeInt(); $table->AddColumn('q12')->MakeInt(); $table->AddColumn('q13')->MakeInt(); $table->AddColumn('q14')->MakeInt(); $table->AddColumn('q15')->MakeInt(); $table->AddColumn('q16')->MakeInt(); $table->AddColumn('q17')->MakeInt(); $table->AddColumn('q18')->MakeInt(); $table->AddColumn('q19')->MakeInt(); $table->AddColumn('q20')->MakeInt(); $table->AddColumn('q21')->MakeInt(); $table->AddColumn('q22')->MakeVarChar(500)->DefaultValue("none"); $table->AddColumn('q23')->MakeInt(); $table->AddColumn('q24')->MakeInt(); $table->AddColumn('q25')->MakeInt();
<?php $name = "forgotPasswordTimeout"; $table = new CreateTable($name); $table->AddColumn('id')->SetAutoIncrement(); $table->AddColumn('creationTime')->MakeVarChar(100); $table->AddColumn('hash')->MakeVarChar(100)->AddKey('unique'); $population = array(); $population[] = QueryFactory::Build("insert")->Into($name)->Set(["id", "0"], ["creationTime", "0"], ["hash", "0"]); return [$table, $population];
public function remove_index($column_name) { $columns = is_array($column_name) ? $column_name : array($column_name); $index_name = CreateTable::index_name($this->table_name, $columns); array_push($this->columns, $this->alter_table_sql() . 'DROP INDEX ' . $index_name); }
<?php $name = "settings"; $table = new CreateTable($name); //$table->AddColumn('id')->SetAutoIncrement(); $table->AddColumn('name')->MakeVarChar(100)->AddKey('unique'); $table->AddColumn('value')->MakeVarchar(100); // +1 day or something like that $table->AddColumn('enabled')->MakeBool()->DefaultValue('true'); $population = array(); $population[] = QueryFactory::Build("insert")->Into($name)->Set(["name", "forgotpassword"], ["value", "+ 50 seconds"], ["enabled", 1]); $population[] = QueryFactory::Build("insert")->Into($name)->Set(["name", "ttl_activation"], ["value", "+1 day"]); $population[] = QueryFactory::Build("insert")->Into($name)->Set(["name", "ttl_form"], ["value", "+1 month"]); $population[] = QueryFactory::Build("insert")->Into($name)->Set(["name", "ttl_assessment_choice"], ["value", "+2 week"]); $population[] = QueryFactory::Build("insert")->Into($name)->Set(["name", "ttl_assessment_complete"], ["value", "+1 month"]); $population[] = QueryFactory::Build("insert")->Into($name)->Set(["name", "ttl_assessment_frequency"], ["value", "+3 month"]); return [$table, $population];
<?php $table = new CreateTable("enrollment_form"); $table->AddColumn('id')->SetAutoIncrement(); $table->AddColumn('userID')->MakeInt()->AddKey('unique'); $table->AddColumn('DateCompleted')->MakeInt()->DefaultValue(0); $table->AddColumn('completed')->MakeBool()->DefaultValue('false'); $table->AddColumn('lastName')->MakeVarChar(50); $table->AddColumn('firstName')->MakeVarChar(50); $table->AddColumn('streetAddress')->MakeVarChar(150); $table->AddColumn('city')->MakeVarChar(50); $table->AddColumn('phone')->MakeVarChar(20); $table->AddColumn('email')->MakeVarChar(100)->AddKey('unique'); $table->AddColumn('dob')->MakeVarChar(11)->DefaultValue('false'); $table->AddColumn('gender')->MakeBool(); $table->AddColumn('healthHistory')->MakeVarChar(500)->DefaultValue('false'); $table->AddColumn('watchSbf')->MakeBool()->DefaultValue('false'); $table->AddColumn('HowManyTimesAWeek')->MakeInt()->DefaultValue(0); $table->AddColumn('controlGroup')->MakeBool()->DefaultValue('false'); $table->AddColumn('experimentalGroup')->MakeVarChar(4)->DefaultValue('false'); return [$table, []];
<?php $name = basename(__FILE__, ".php"); $table = new CreateTable($name); $table->AddColumn('id')->SetAutoIncrement(); $table->AddColumn('name')->MakeVarChar(20)->AddKey('unique'); $table->AddColumn('page')->MakeVarChar(30)->DefaultValue("index.php"); $table->AddColumn('pLevel')->MakeInt(); $populate = array(); $populate[] = QueryFactory::Build("insert")->Into($name)->Set(["name", "Home"], ["page", "index.php"]); $populate[] = QueryFactory::Build("insert")->Into($name)->Set(["name", "About"], ["page", "about.php"]); $populate[] = QueryFactory::Build("insert")->Into($name)->Set(["name", "Contact"], ["page", "contact.php"]); $populate[] = QueryFactory::Build("insert")->Into($name)->Set(["name", "FAQ"], ["page", "faq.php"]); $populate[] = QueryFactory::Build("insert")->Into($name)->Set(["name", "Assessments"], ["page", "assessments.php"]); $populate[] = QueryFactory::Build("insert")->Into($name)->Set(["name", "Register"], ["page", "register.php"]); $populate[] = QueryFactory::Build("insert")->Into($name)->Set(["name", "Profile"], ["page", "profile.php"], ["pLevel", 1]); $populate[] = QueryFactory::Build("insert")->Into($name)->Set(["name", "ParQ Form"], ["page", "parQ.php"], ["pLevel", 1]); $populate[] = QueryFactory::Build("insert")->Into($name)->Set(["name", "Logout"], ["page", "logout.php"], ["pLevel", 1]); return [$table, $populate];
<?php // -2 is default of user doesn't want $table = new CreateTable("assessments"); $table->AddColumn('id')->SetAutoIncrement(); $table->AddColumn('userid')->MakeInt(); $table->AddColumn('TestNumber')->MakeInt()->DefaultValue(1); $table->AddColumn('DateCompleted')->MakeInt()->DefaultValue(0); $table->AddColumn('Chairstand')->MakeInt()->DefaultValue(-2); $table->AddColumn('ArmCurl')->MakeInt()->DefaultValue(-2); $table->AddColumn('StepTest')->MakeInt()->DefaultValue(-2); $table->AddColumn('FootUpAndGo')->MakeInt()->DefaultValue(-2); $table->AddColumn('leftunilateralbalancetest')->MakeInt()->DefaultValue(-2); $table->AddColumn('rightunilateralbalancetest')->MakeInt()->DefaultValue(-2); $table->AddColumn('FunctionalReach')->MakeInt()->DefaultValue(-2); $table->AddColumn('reminded')->MakeBool()->DefaultValue('false'); return [$table, []];
/** * Add a table. * * @access public * @param array $dats Values to add * @param array $parameters Parameters to use * @deprecated */ public function fAddTable($dats, $parameters = '') { $table = CreateTable::getInstance(); $table->createTable($dats, $parameters); $this->_wordDocumentC .= (string) $table; }
<?php $table = new CreateTable("questionnaire_form"); $table->AddColumn('id')->SetAutoIncrement(); $table->AddColumn('userID')->MakeInt()->AddKey('unique'); $table->AddColumn('DateCompleted')->MakeInt()->DefaultValue(0); $table->AddColumn('completed')->MakeBool()->DefaultValue('false'); $table->AddColumn('q1')->MakeInt(); $table->AddColumn('q2')->MakeInt(); $table->AddColumn('q3')->MakeInt(); $table->AddColumn('q4')->MakeInt(); $table->AddColumn('q5')->MakeInt(); $table->AddColumn('q6')->MakeInt(); $table->AddColumn('q7')->MakeInt(); $table->AddColumn('q8')->MakeInt(); $table->AddColumn('q9')->MakeInt(); $table->AddColumn('q10')->MakeInt(); $table->AddColumn('q11')->MakeInt(); $table->AddColumn('q12')->MakeInt(); $table->AddColumn('q13')->MakeInt(); $table->AddColumn('q14')->MakeInt(); $table->AddColumn('q15')->MakeInt(); $table->AddColumn('q16')->MakeInt(); $table->AddColumn('q17')->MakeInt(); $table->AddColumn('q18')->MakeInt(); $table->AddColumn('q19')->MakeInt(); $table->AddColumn('q20')->MakeInt(); $table->AddColumn('q21')->MakeInt(); $table->AddColumn('q22')->MakeVarChar(500)->DefaultValue("none"); $table->AddColumn('q23')->MakeInt(); $table->AddColumn('q24')->MakeInt();
<?php /** * (根据身份验证为user_teaching_office可用)创建任务列表(包括多行和单行) */ error_reporting(0); require_once './classes/class_create_table.php'; require_once './classes/class_insert_table.php'; $tableName = $_POST["tableName"]; $jsonData = $_POST["jsonData"]; session_start(); $ident = $_SESSION['id']; $createNewTable = new CreateTable(); $createNewTable->create($tableName, $ident, $jsonData); $insert = new InsertTable(); $insert->insertT($tableName, $jsonData);
<?php $name = "groups"; $table = new CreateTable($name); $table->AddColumn('id')->SetAutoIncrement(); $table->AddColumn('name')->MakeVarChar(100)->AddKey('unique'); $table->AddColumn('level')->MakeInt()->DefaultValue('1'); $population = array(); return [$table, $population];