{"action":"created","issue":{"url":"https://api.github.com/repos/ErikEJ/SqlCeToolbox/issues/26","labels_url":"https://api.github.com/repos/ErikEJ/SqlCeToolbox/issues/26/labels{/name}","comments_url":"https://api.github.com/repos/ErikEJ/SqlCeToolbox/issues/26/comments","events_url":"https://api.github.com/repos/ErikEJ/SqlCeToolbox/issues/26/events","html_url":"https://github.com/ErikEJ/SqlCeToolbox/issues/26","id":126446198,"number":26,"title":"Empty default values in create table","user":{"login":"midnait","id":7293602,"avatar_url":"https://avatars.githubusercontent.com/u/7293602?v=3","gravatar_id":"","url":"https://api.github.com/users/midnait","html_url":"https://github.com/midnait","followers_url":"https://api.github.com/users/midnait/followers","following_url":"https://api.github.com/users/midnait/following{/other_user}","gists_url":"https://api.github.com/users/midnait/gists{/gist_id}","starred_url":"https://api.github.com/users/midnait/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/midnait/subscriptions","organizations_url":"https://api.github.com/users/midnait/orgs","repos_url":"https://api.github.com/users/midnait/repos","events_url":"https://api.github.com/users/midnait/events{/privacy}","received_events_url":"https://api.github.com/users/midnait/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2016-01-13T15:41:35Z","updated_at":"2016-01-17T16:53:46Z","closed_at":null,"body":"Hi Erik\r\n\r\nVS Community 2015 Update 1 + SQLCEToolbox 4.4.0.4 + db CE4.0\r\nBuild Table (beta) + field with default value\r\n\r\nSQL generated with empty default value:\r\n\r\n-- Script Date: 13/01/2016 10:55  - ErikEJ.SqlCeScripting version 3.5.2.56\r\nCREATE TABLE Faucet (\r\n  [Id] int IDENTITY (1,1) NOT NULL\r\n, [Guid] uniqueidentifier DEFAULT  NOT NULL\r\n, [Nome] nvarchar(100) NOT NULL\r\n, [Endereco] nvarchar(255) NOT NULL\r\n, [DataCadastro] datetime DEFAULT  NOT NULL\r\n, [DataUltimaAnalise] datetime NULL\r\n, [DataUltimoAcesso] datetime NULL\r\n, [DataProximoAcesso] datetime DEFAULT  NOT NULL\r\n, [RecompensaMinima] smallint NULL\r\n, [UltimaRecompensa] smallint NULL\r\n, [Saldo] int NULL\r\n, [EntregaRecompensa] tinyint DEFAULT  NOT NULL\r\n, [Rede] tinyint DEFAULT  NOT NULL\r\n, [Moeda] tinyint DEFAULT  NOT NULL\r\n, [IntervaloTempo] smallint NULL\r\n, [DetectarIntervalo] bit DEFAULT  NOT NULL\r\n, [DetectarRecompensa] bit DEFAULT  NOT NULL\r\n, [DetectarSaldo] bit DEFAULT  NOT NULL\r\n, [DetectarSaque] bit DEFAULT  NOT NULL\r\n, [Avaliacao] tinyint DEFAULT  NOT NULL\r\n, [AvisarTempo] bit DEFAULT  NOT NULL\r\n, [Idioma] tinyint DEFAULT  NOT NULL\r\n, [ManterAberto] bit DEFAULT  NOT NULL\r\n, [Observacoes] ntext NOT NULL\r\n, [PrecisaVerificar] bit DEFAULT  NOT NULL\r\n, [Problemas] nvarchar(255) NULL\r\n, [TemFundo] bit DEFAULT  NOT NULL\r\n, [TemLogin] bit DEFAULT  NOT NULL\r\n, [TemProblemas] bit DEFAULT  NOT NULL\r\n, [TemReferido] bit DEFAULT  NOT NULL\r\n, [TesteHumano] smallint DEFAULT  NOT NULL\r\n);\r\nGO\r\nALTER TABLE [Faucet] ADD CONSTRAINT [PK_Faucet] PRIMARY KEY ([Id]);\r\nGO\r\n\r\nMy default values in Build Table: NEWID(), GETDATE() and 0 / 1.\r\n\r\nHugs.\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/ErikEJ/SqlCeToolbox/issues/comments/172350783","html_url":"https://github.com/ErikEJ/SqlCeToolbox/issues/26#issuecomment-172350783","issue_url":"https://api.github.com/repos/ErikEJ/SqlCeToolbox/issues/26","id":172350783,"user":{"login":"midnait","id":7293602,"avatar_url":"https://avatars.githubusercontent.com/u/7293602?v=3","gravatar_id":"","url":"https://api.github.com/users/midnait","html_url":"https://github.com/midnait","followers_url":"https://api.github.com/users/midnait/followers","following_url":"https://api.github.com/users/midnait/following{/other_user}","gists_url":"https://api.github.com/users/midnait/gists{/gist_id}","starred_url":"https://api.github.com/users/midnait/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/midnait/subscriptions","organizations_url":"https://api.github.com/users/midnait/orgs","repos_url":"https://api.github.com/users/midnait/repos","events_url":"https://api.github.com/users/midnait/events{/privacy}","received_events_url":"https://api.github.com/users/midnait/received_events","type":"User","site_admin":false},"created_at":"2016-01-17T16:53:46Z","updated_at":"2016-01-17T16:53:46Z","body":"Hi @ErikEJ \r\n\r\nYes, \"default value\" fixed in build 4.4.0.12.\r\n\r\nTks a lot."}}