File: test/out2-js

Recommend this page to a friend!
  Classes of Nikos M.  >  Dialect PHP SQL Query Builder  >  test/out2-js  >  Download  
File: test/out2-js
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: Dialect PHP SQL Query Builder
Build SQL queries from templates
Author: By
Last change: Update of test/out2-js
Date: 5 months ago
Size: 649 bytes
 

Contents

Class file image Download
Dialect.VERSION = 1.1.0

CREATE TABLE IF NOT EXISTS `new_table` (
id bigint(20) NOT NULL AUTO_INCREMENT,
name tinytext NOT NULL DEFAULT '',
categoryid bigint(20) NOT NULL DEFAULT 0,
companyid bigint(20) NOT NULL DEFAULT 0,
fields text NOT NULL DEFAULT '',
start datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
end datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
status tinyint(8) unsigned NOT NULL DEFAULT 0,
extra text NOT NULL DEFAULT '',
KEY categoryid  (categoryid),
KEY companyid  (companyid),
CONSTRAINT constraint_name UNIQUE KEY id  (id)
) COLLATE=utf8_general_ci

CREATE VIEW `new_view` (
id,
name
) AS SELECT id, name FROM another_table

For more information send a message to info at phpclasses dot org.