File: test/out2-php

Recommend this page to a friend!
  Classes of Nikos M.  >  Dialect PHP SQL Query Builder  >  test/out2-php  >  Download  
File: test/out2-php
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-php
Date: 5 months ago
Size: 590 bytes
 

Contents

Class file image Download
Dialect.VERSION = 1.1.0

IF NOT EXISTS (SELECT * FROM sysobjects WHERE name=[new_table] AND xtype='U')
CREATE TABLE [new_table] (
id bigint(20) NOT NULL,
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 ''
)
GO

CREATE VIEW IF NOT EXISTS [new_view] (
id,
name
) AS SELECT id, name FROM another_table

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