PHP CreateTable, shadowsocks-panel Beispiele

Beispiel #1

Datei: PostgreSQL.php Projekt: Textalk/opis-database

 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;
 }

Beispiel #2

Datei: parq_form.php Projekt: sam25/website

<?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);

Beispiel #3

Datei: users.php Projekt: sam25/website

<?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];

Beispiel #4

Datei: schedule.php Projekt: sam25/website

<?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];

Beispiel #5

Datei: articles.php Projekt: sam25/website

<?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];

Beispiel #6

Datei: questionnairep1_form.php Projekt: sam25/website

<?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();

Beispiel #7

Datei: forgotPasswordTimeout.php Projekt: sam25/website

<?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];

Beispiel #8

Datei: alter_table.php Projekt: scottdavis/active_php

 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);
 }

Beispiel #9

Datei: settings.php Projekt: sam25/website

<?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];

Beispiel #10

Datei: enrollment_form.php Projekt: sam25/website

<?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, []];

Beispiel #11

Datei: menu.php Projekt: sam25/website

<?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];

Beispiel #12

Datei: assessments.php Projekt: sam25/website

<?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, []];

Beispiel #13

Datei: CreateDocx.inc.php Projekt: aodkrisda/PHP-Digital-Format-Convert-Epub-Mobi-PDF

 /**
  * 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;
 }

Beispiel #14

Datei: questionnaire_form.php Projekt: sam25/website

<?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();

Beispiel #15

Datei: create_table.php Projekt: jdlw/TeacherClass

<?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);

Beispiel #16

Datei: groups.php Projekt: sam25/website

<?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];