Esempio n. 1
0
        public void CreateTable00()
        {
            var statement = Sql.CreateTable("BigTable00", true)
                            .Columns(
                TableColumn.Int("id").PrimaryKey().NotNull().AutoIncrement(),
                TableColumn.BigInt("bigint").Default(1L).Null()
                );

            var mysql = provider.GenerateStatement(statement);

            Assert.AreEqual("CREATE TABLE IF NOT EXISTS `BigTable00` ( `id` INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, `bigint` BIGINT NULL DEFAULT 1 );", mysql);
        }