public void CreateTable(string tableName)
{
defaultTable = tableName.RemoveNonAlphaNumeric().ToLower();
table = new SQLiteTable(tableName);
table.AddColumn(new SQLiteColumn("ID", true));
table.AddColumn(new SQLiteColumn("Command", ColType.Text));
table.AddColumn(new SQLiteColumn("Code", ColType.Text));
sqlite.CreateTable(table);
}
public void CreateTable(string tableName)
{
defaultTable = tableName;
table = new SQLiteTable(tableName);
table.AddColumn(new SQLiteColumn("ID", true));
table.AddColumn(new SQLiteColumn("Name", ColType.Text));
table.AddColumn(new SQLiteColumn("Value", ColType.Text));
table.AddColumn(new SQLiteColumn("Code", ColType.Text));
sqlite.CreateTable(table);
}
public void CreateTable(string tableName)
{
defaultTable = tableName;
table = new SQLiteTable(tableName);
table.AddColumn(new SQLiteColumn("ID", true));
table.AddColumn(new SQLiteColumn("SourceCount", ColType.Text));
table.AddColumn(new SQLiteColumn("Code", ColType.Text));
table.AddColumn(new SQLiteColumn("SourceType", ColType.Text));
table.AddColumn(new SQLiteColumn("Details", ColType.Text));
sqlite.CreateTable(table);
}
public void CreateTable(string tableName)
{
defaultTable = tableName;
table = new SQLiteTable(tableName);
table.AddColumn(new SQLiteColumn("Details", ColType.DateTime));
table.AddColumn(new SQLiteColumn("Description", ColType.Text));
table.AddColumn(new SQLiteColumn("Type", ColType.Integer));
table.AddColumn(new SQLiteColumn("Category", ColType.Text));
table.AddColumn(new SQLiteColumn("Method", ColType.Text));
sqliteHelper.CreateTable(table);
}
public void CreateTable(string tableName)
{
defaultTable = tableName;
table = new SQLiteTable(tableName);
table.AddColumn(new SQLiteColumn("ID", true));
table.AddColumn(new SQLiteColumn("Name", ColType.Text));
table.AddColumn(new SQLiteColumn("WorkspaceTable", ColType.Text));
table.AddColumn(new SQLiteColumn("FileCount", ColType.Integer));
table.AddColumn(new SQLiteColumn("ValidFiles", ColType.Integer));
table.AddColumn(new SQLiteColumn("Directory", ColType.Text));
table.AddColumn(new SQLiteColumn("Code", ColType.Text));
table.AddColumn(new SQLiteColumn("Comment", ColType.Text));
table.AddColumn(new SQLiteColumn("LastDateUnbind", ColType.Text));
sqlite.CreateTable(table);
}
public void CreateTable(string tableName)
{
defaultTable = tableName;
table = new SQLiteTable(tableName);
table.AddColumn(new SQLiteColumn("ID", true));
table.AddColumn(new SQLiteColumn("Name", ColType.Text));
table.AddColumn(new SQLiteColumn("Value", ColType.Text));
table.AddColumn(new SQLiteColumn("Count", ColType.Integer));
table.AddColumn(new SQLiteColumn("Code", ColType.Text));
table.AddColumn(new SQLiteColumn("Comment", ColType.Text));
table.AddColumn(new SQLiteColumn("LastDateModified", ColType.Text));
sqlite.CreateTable(table);
}
public void CreateTable(string tableName)
{
defaultTable = tableName.RemoveNonAlphaNumeric().ToLower();
table = new SQLiteTable(tableName);
table.AddColumn(new SQLiteColumn("ID", true));
table.AddColumn(new SQLiteColumn("Description", ColType.Text));
table.AddColumn(new SQLiteColumn("IPAddress", ColType.Text));
table.AddColumn(new SQLiteColumn("Path", ColType.Text));
table.AddColumn(new SQLiteColumn("AutoBind", ColType.Integer));
table.AddColumn(new SQLiteColumn("Code", ColType.Text));
sqlite.CreateTable(table);
}