SlDatabase: Create Table

The CreateTable thing allows you to add tables to an existing database.


Syntax:

// Create the fields.
List<SlDatabase.TableFields> _Fields = new List<SlDatabase.TableFields>();
SlDatabase.TableFields _Field = new SlDatabase.TableFields();

_Field.Name = <NAME>;
_Field.DataType = <TYPE>;
_Fields.Add(_Field);



// Create the table.
SlDatabase _Database = new SlDatabase();
_Database.CreateTable("Users", <FIELDS>);

# NAME: The name of the field.
# TYPE: The type of data to use (SlDatabase.SqlDataTypes)
# FIELDS: The list that contains the fields to be added to the database.

Example:

SlDatabase _Database = new SlDatabase();
List<SlDatabase.TableFields> _Fields = new List<SlDatabase.TableFields>();
SlDatabase.TableFields _Field = new SlDatabase.TableFields();


_Field.Name = "ID";
_Field.DataType = SlDatabase.SqlDataTypes.Number;
_Fields.Add(_Field);

_Field.Name = "Name";
_Field.DataType = SlDatabase.SqlDataTypes.Text;
_Fields.Add(_Field);

_Field.Name = "Password";
_Field.DataType = SlDatabase.SqlDataTypes.Text;
_Fields.Add(_Field);


_Database.CreateTable("Users", _Fields);