ExecuteSQLCreateTable - Revision history

ThePiotrek at 15:13, 4 October 2016

2016-10-04T15:13:10Z

← Older revision		Revision as of 15:13, 4 October 2016
Line 7:		Line 7:
	The executed SQL query is the following:		The executed SQL query is the following:

	<syntaxhighlight lang="lua">CREATE TABLE IF NOT EXISTS ~~<table>~~ ( <definition> )</syntaxhighlight>		<syntaxhighlight lang="lua">CREATE TABLE IF NOT EXISTS tableName ( definition )</syntaxhighlight>

	==Syntax==		==Syntax==

ThePiotrek at 15:12, 4 October 2016

2016-10-04T15:12:37Z

← Older revision		Revision as of 15:12, 4 October 2016
Line 7:		Line 7:
	The executed SQL query is the following:		The executed SQL query is the following:

	<syntaxhighlight lang="lua">~~[sql]~~CREATE TABLE IF NOT EXISTS <table> ( <definition> )</syntaxhighlight>		<syntaxhighlight lang="lua">CREATE TABLE IF NOT EXISTS <table> ( <definition> )</syntaxhighlight>

	==Syntax==		==Syntax==

AlexTMjugador: Changed "DeprecatedWithAlt" template to "Deprecated"

2015-02-13T16:24:03Z

Changed "DeprecatedWithAlt" template to "Deprecated"

← Older revision		Revision as of 16:24, 13 February 2015
Line 1:		Line 1:
	__NOTOC__		__NOTOC__
	{{Server function}}		{{Server function}}
	{{~~DeprecatedWithAlt~~\|executeSQLQuery\|See the examples at executeSQLQuery for equivalent CREATE TABLE usage}}		{{Deprecated\|executeSQLQuery\|See the examples at executeSQLQuery for equivalent CREATE TABLE usage.}}

	This function creates a table in the database. It doesn't do anything when the table already exists. You can use this function in the loading or initialisation step of your script to ensure all the necessary tables that you use actually exist.		This function creates a table in the database. It doesn't do anything when the table already exists. You can use this function in the loading or initialisation step of your script to ensure all the necessary tables that you use actually exist.

Ccw: /* Example */

2015-02-11T16:39:56Z

Example

← Older revision		Revision as of 16:39, 11 February 2015
Line 27:		Line 27:
	executeSQLCreateTable ( "players", "clothes_head_texture TEXT, clothes_head_model TEXT, player TEXT" )		executeSQLCreateTable ( "players", "clothes_head_texture TEXT, clothes_head_model TEXT, player TEXT" )
	end		end
	addEventHandler ( "onResourceStart", getResourceRootElement(~~getThisResource()~~),createSQLOnStart )		addEventHandler ( "onResourceStart", getResourceRootElement(),createSQLOnStart )

	</syntaxhighlight>		</syntaxhighlight>

Ccw at 21:21, 20 July 2012

2012-07-20T21:21:32Z

← Older revision		Revision as of 21:21, 20 July 2012
Line 1:		Line 1:
	__NOTOC__		__NOTOC__
	{{Server function}}		{{Server function}}
			{{DeprecatedWithAlt\|executeSQLQuery\|See the examples at executeSQLQuery for equivalent CREATE TABLE usage}}
	This function creates a table in the database. It doesn't do anything when the table already exists. You can use this function in the loading or initialisation step of your script to ensure all the necessary tables that you use actually exist.		This function creates a table in the database. It doesn't do anything when the table already exists. You can use this function in the loading or initialisation step of your script to ensure all the necessary tables that you use actually exist.

Talidan at 14:45, 26 August 2007

2007-08-26T14:45:38Z

← Older revision		Revision as of 14:45, 26 August 2007
Line 18:		Line 18:
	===Returns===		===Returns===
	The function returns ''true'' on success, and ''false'' on failure.		The function returns ''true'' on success, and ''false'' on failure.


	==Example==		==Example==
			This example creates a SQL table when the resource starts.
	<syntaxhighlight lang="lua">		<syntaxhighlight lang="lua">
	function ~~onMapLoad~~ ()		function createSQLOnStart ()
	-- create our table, if it doesn't already exist		-- create our table, if it doesn't already exist
	executeSQLCreateTable ( "players", "clothes_head_texture TEXT, clothes_head_model TEXT, player TEXT" )		executeSQLCreateTable ( "players", "clothes_head_texture TEXT, clothes_head_model TEXT, player TEXT" )
	end		end
			addEventHandler ( "onResourceStart", getResourceRootElement(getThisResource()),createSQLOnStart )

	</syntaxhighlight>		</syntaxhighlight>

Arc at 12:25, 21 August 2007

2007-08-21T12:25:06Z

← Older revision		Revision as of 12:25, 21 August 2007
Line 9:		Line 9:
	==Syntax==		==Syntax==
	<syntaxhighlight lang="lua">		<syntaxhighlight lang="lua">
	bool executeSQLCreateTable ( string ~~table~~, string definition )		bool executeSQLCreateTable ( string tableName, string definition )
	</syntaxhighlight>		</syntaxhighlight>

	===Required Arguments===		===Required Arguments===
	*'''~~table~~:''' The name of the table you want to create.		*'''tableName:''' The name of the table you want to create.
	*'''definition:''' The definition of the table, this includes the column definitions and constraints in SQL syntax. For each column definition, you start with the name (without any spaces), optionally followed by the [http://www.sqlite.org/datatype3.html SQL data type] and constraint (all separated by spaces). Each column definition is separated by a comma (,) (e.g. ''field1,field2,field3'' or ''field1 INTEGER,field2 TEXT'' as definition). Please refer to the [http://www.sqlite.org/lang_createtable.html SQLite SQL documentation] for more information on creating even more complex tables.		*'''definition:''' The definition of the table, this includes the column definitions and constraints in SQL syntax. For each column definition, you start with the name (without any spaces), optionally followed by the [http://www.sqlite.org/datatype3.html SQL data type] and constraint (all separated by spaces). Each column definition is separated by a comma (,) (e.g. ''field1,field2,field3'' or ''field1 INTEGER,field2 TEXT'' as definition). Please refer to the [http://www.sqlite.org/lang_createtable.html SQLite SQL documentation] for more information on creating even more complex tables.

	===Returns===		===Returns===
	The function returns ~~a ''boolean'' which is~~ ''true'' on success, and ''false'' on failure.		The function returns ''true'' on success, and ''false'' on failure.

Erorr404 at 01:45, 5 August 2007

2007-08-05T01:45:35Z

← Older revision		Revision as of 01:45, 5 August 2007
Line 1:		Line 1:
	__NOTOC__		__NOTOC__
			{{Server function}}
	This function creates a table in the database. It doesn't do anything when the table already exists. You can use this function in the loading or initialisation step of your script to ensure all the necessary tables that you use actually exist.		This function creates a table in the database. It doesn't do anything when the table already exists. You can use this function in the loading or initialisation step of your script to ensure all the necessary tables that you use actually exist.

IJs at 16:16, 23 September 2006

2006-09-23T16:16:52Z

← Older revision		Revision as of 16:16, 23 September 2006
Line 8:		Line 8:
	==Syntax==		==Syntax==
	<syntaxhighlight lang="lua">		<syntaxhighlight lang="lua">
	~~nil~~ executeSQLCreateTable ( string table, string definition )		bool executeSQLCreateTable ( string table, string definition )
	</syntaxhighlight>		</syntaxhighlight>

Line 16:		Line 16:

	===Returns===		===Returns===
	The function ~~doesn~~'~~t return anything~~.		The function returns a ''boolean'' which is ''true'' on success, and ''false'' on failure.

IJs: /* Example */

2006-09-23T15:29:38Z

Example

← Older revision		Revision as of 15:29, 23 September 2006
Line 25:		Line 25:
	executeSQLCreateTable ( "players", "clothes_head_texture TEXT, clothes_head_model TEXT, player TEXT" )		executeSQLCreateTable ( "players", "clothes_head_texture TEXT, clothes_head_model TEXT, player TEXT" )
	end		end

	</syntaxhighlight>		</syntaxhighlight>

	==See Also==		==See Also==
	{{Registry_functions}}		{{Registry_functions}}