XmKywDne

1ALTER TABLE MAN_USER
2ADD KARYAWAN_ID CHAR(10);
3
4IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[AUTH_TOKEN]') AND type IN ('U'))
5	DROP TABLE [dbo].[AUTH_TOKEN]
6GO
7
8CREATE TABLE [dbo].[AUTH_TOKEN] (
9  [AUTH_TOKEN_ID] varchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS  NOT NULL,
10  [USER_ID] int  NOT NULL,
11  [CLIENT_ID] int  NOT NULL,
12  [CREATED_AT] timestamp  NULL,
13  [EXPIRES_AT] datetime  NULL
14)
15GO
16
17ALTER TABLE [dbo].[AUTH_TOKEN] SET (LOCK_ESCALATION = TABLE)
18GO
19
20ALTER TABLE [dbo].[AUTH_TOKEN] ADD CONSTRAINT [PK__AUTH_TOK__6308A644D8ECCB32] PRIMARY KEY CLUSTERED ([AUTH_TOKEN_ID])
21WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
22ON [PRIMARY]
23GO
24
25IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[FOTO_LOKASI]') AND type IN ('U'))
26	DROP TABLE [dbo].[FOTO_LOKASI]
27GO
28
29CREATE TABLE [dbo].[FOTO_LOKASI] (
30  [FOTO_LOKASI_ID] int  NOT NULL,
31  [UKK_ID] char(11) COLLATE SQL_Latin1_General_CP1_CI_AS  NOT NULL,
32  [TAHAP] char(2) COLLATE SQL_Latin1_General_CP1_CI_AS  NOT NULL,
33  [KETERANGAN] varchar(60) COLLATE SQL_Latin1_General_CP1_CI_AS  NULL,
34  [GAMBAR] text COLLATE SQL_Latin1_General_CP1_CI_AS  NULL
35)
36GO
37
38ALTER TABLE [dbo].[FOTO_LOKASI] SET (LOCK_ESCALATION = TABLE)
39GO
40
41CREATE NONCLUSTERED INDEX [FKREF_16559]
42ON [dbo].[FOTO_LOKASI] (
43  [FOTO_LOKASI_ID] ASC
44)
45GO
46
47CREATE NONCLUSTERED INDEX [FKREF_19380]
48ON [dbo].[FOTO_LOKASI] (
49  [UKK_ID] ASC,
50  [TAHAP] ASC
51)
52GO
53
54ALTER TABLE [dbo].[FOTO_LOKASI] ADD CONSTRAINT [PK_FOTO_LOKASI] PRIMARY KEY CLUSTERED ([UKK_ID], [TAHAP])
55WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
56ON [PRIMARY]
57GO
58
59ALTER TABLE [dbo].[FOTO_LOKASI] ADD CONSTRAINT [FK_FOTO_LOKASI_ID_REF_194127_TAREG] FOREIGN KEY ([UKK_ID], [TAHAP]) REFERENCES [dbo].[TAREG] ([UKK_ID], [TAHAP]) ON DELETE NO ACTION ON UPDATE NO ACTION
60GO
61
62ALTER TABLE LEGALITAS
63ADD GAMBAR text NULL;
64GO
65
66ALTER TABLE FOTO_LOKASI
67ADD LAT DECIMAL(12,9) NULL,
68	LONG DECIMAL(12,9) NULL
69GO
70
71ALTER TABLE FORM_B
72ADD TTD TEXT NULL
73SELECT TOP 1 * FROM FORM_B;
74
75IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[AUTH_CLIENTS]') AND type IN ('U'))
76	DROP TABLE [dbo].[AUTH_CLIENTS]
77GO
78
79CREATE TABLE [dbo].[AUTH_CLIENTS] (
80  [ID] int  IDENTITY(1,1) NOT NULL,
81  [NAME] varchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS  NOT NULL,
82  [SECRET] varchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS  NOT NULL
83)
84GO
85
86ALTER TABLE [dbo].[AUTH_CLIENTS] SET (LOCK_ESCALATION = TABLE)
87GO
88
89SET IDENTITY_INSERT [dbo].[AUTH_CLIENTS] ON
90GO
91
92INSERT INTO [dbo].[AUTH_CLIENTS] ([ID], [NAME], [SECRET]) VALUES (N'1', N'Survey', N'811F2A14B9850C9D9C7562F29228754BFABBD03407FB41F00994180BD9DE98F2')
93GO
94
95SET IDENTITY_INSERT [dbo].[AUTH_CLIENTS] OFF
96GO
97
98ALTER TABLE [dbo].[AUTH_CLIENTS] ADD CONSTRAINT [PK__AUTH_CLI__3214EC27C1197480] PRIMARY KEY CLUSTERED ([ID])
99WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
100ON [PRIMARY]
101GO