public void CreateDatabase()
{
SQLiteTransaction trans = connection.BeginTransaction();
try
{
string sqlSignTable =
@"CREATE TABLE IF NOT EXISTS [SignWord] (
[SignID] TEXT NOT NULL PRIMARY KEY,
[SignIndex] INTEGER NOT NULL,
[Chinese] TEXT NULL,
[English] TEXT NULL,
[Count] INTEGER NOT NULL
)";
string sqlSampleTable =
@"CREATE TABLE IF NOT EXISTS [SignSample] (
[index_ID] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
[SignID] TEXT NOT NULL,
[Signer] TEXT NOT NULL,
[FileName] TEXT NOT NULL,
[Intersected] INTEGER NOT NULL,
FOREIGN KEY(SignID) REFERENCES SignWord(SignID)
)";
string sqlDataTable =
@"CREATE TABLE IF NOT EXISTS [FrameData] (
[index_ID] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
[SampleIndex] INTEGER NOT NULL,
[FrameNumber] INTEGER NOT NULL,
SkeletonHeadX NUMERIC,
SkeletonHeadY NUMERIC,
SkeletonHeadZ NUMERIC,
SkeletonShoulderCenterX NUMERIC,
SkeletonShoulderCenterY NUMERIC,
SkeletonShoulderCenterZ NUMERIC,
SkeletonShoulderLeftX NUMERIC,
SkeletonShoulderLeftY NUMERIC,
SkeletonShoulderLeftZ NUMERIC,
SkeletonShoulderRightX NUMERIC,
SkeletonShoulderRightY NUMERIC,
SkeletonShoulderRightZ NUMERIC,
SkeletonSpineX NUMERIC,
SkeletonSpineY NUMERIC,
SkeletonSpineZ NUMERIC,
SkeletonHipCenterX NUMERIC,
SkeletonHipCenterY NUMERIC,
SkeletonHipCenterZ NUMERIC,
SkeletonHipLeftX NUMERIC,
SkeletonHipLeftY NUMERIC,
SkeletonHipLeftZ NUMERIC,
SkeletonHipRightX NUMERIC,
SkeletonHipRightY NUMERIC,
SkeletonHipRightZ NUMERIC,
SkeletonElbowLeftX NUMERIC,
SkeletonElbowLeftY NUMERIC,
SkeletonElbowLeftZ NUMERIC,
SkeletonWristLeftX NUMERIC,
SkeletonWristLeftY NUMERIC,
SkeletonWristLeftZ NUMERIC,
SkeletonHandLeftX NUMERIC,
SkeletonHandLeftY NUMERIC,
SkeletonHandLeftZ NUMERIC,
SkeletonElbowRightX NUMERIC,
SkeletonElbowRightY NUMERIC,
SkeletonElbowRightZ NUMERIC,
SkeletonWristRightX NUMERIC,
SkeletonWristRightY NUMERIC,
SkeletonWristRightZ NUMERIC,
SkeletonHandRightX NUMERIC,
SkeletonHandRightY NUMERIC,
SkeletonHandRightZ NUMERIC,
[RightHandHOG] BLOB ,
[LeftHandHOG] BLOB ,
RightMoG BLOB,
LeftMoG BLOB,
FOREIGN KEY(SampleIndex) REFERENCES SignSample(index_ID)
)";
SQLiteCommand createTable = new SQLiteCommand(sqlSignTable, connection);
createTable.ExecuteNonQuery();
createTable = new SQLiteCommand(sqlSampleTable, connection);
createTable.ExecuteNonQuery();
createTable = new SQLiteCommand(sqlDataTable, connection);
createTable.ExecuteNonQuery();
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
}