yiming/17168ERP
1
0
Fork 0
Code Issues Pull Requests 1 Actions Packages Projects Releases Wiki Activity
Files
dapper
17168ERP/data/17168erp.sql
minom 63ca92e470 sql script
2026-03-04 17:57:39 +08:00

4223 lines
183 KiB
Transact-SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
/*
Navicat Premium Dump SQL
Source Server : jx252
Source Server Type : SQL Server
Source Server Version : 16004210 (16.00.4210)
Source Host : 192.168.2.252:1433
Source Catalog : 17168erp_c
Source Schema : dbo
Target Server Type : SQL Server
Target Server Version : 16004210 (16.00.4210)
File Encoding : 65001
Date: 04/03/2026 17:55:29
*/
-- ----------------------------
-- Table structure for accounting
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[accounting]') AND type IN ('U'))
DROP TABLE [dbo].[accounting]
GO
CREATE TABLE [dbo].[accounting] (
[num] int IDENTITY(1,1) NOT NULL,
[uptime] datetime DEFAULT CONVERT([varchar],getdate(),(111)) NULL,
[category] int NULL,
[kind] int NULL,
[kind2] int NULL,
[price] real NULL,
[tax] real NULL,
[demo] nvarchar(max) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[mem_num] int NULL,
[debtor] nvarchar(20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[activity_num] int NULL,
[excerpt] nvarchar(max) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[reg_time] datetime DEFAULT getdate() NULL,
[pro_order_detail_num] int NULL
)
GO
ALTER TABLE [dbo].[accounting] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'收支管理主檔',
'SCHEMA', N'dbo',
'TABLE', N'accounting'
GO
-- ----------------------------
-- Records of accounting
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [dbo].[accounting] ON
GO
SET IDENTITY_INSERT [dbo].[accounting] OFF
GO
COMMIT
GO
-- ----------------------------
-- Table structure for accounting_files
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[accounting_files]') AND type IN ('U'))
DROP TABLE [dbo].[accounting_files]
GO
CREATE TABLE [dbo].[accounting_files] (
[num] int IDENTITY(1,1) NOT NULL,
[accounting_num] int NULL,
[reg_time] datetime DEFAULT getdate() NULL,
[pic1] nvarchar(50) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[pic1_name] nvarchar(150) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
)
GO
ALTER TABLE [dbo].[accounting_files] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'收支附件檔',
'SCHEMA', N'dbo',
'TABLE', N'accounting_files'
GO
-- ----------------------------
-- Records of accounting_files
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [dbo].[accounting_files] ON
GO
SET IDENTITY_INSERT [dbo].[accounting_files] OFF
GO
COMMIT
GO
-- ----------------------------
-- Table structure for accounting_kind
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[accounting_kind]') AND type IN ('U'))
DROP TABLE [dbo].[accounting_kind]
GO
CREATE TABLE [dbo].[accounting_kind] (
[num] int IDENTITY(1,1) NOT NULL,
[kind] nvarchar(100) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[root] int DEFAULT 0 NULL,
[range] int NULL,
[demo] nvarchar(max) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[title] nvarchar(30) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
)
GO
ALTER TABLE [dbo].[accounting_kind] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'收支項目維護',
'SCHEMA', N'dbo',
'TABLE', N'accounting_kind'
GO
-- ----------------------------
-- Records of accounting_kind
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [dbo].[accounting_kind] ON
GO
SET IDENTITY_INSERT [dbo].[accounting_kind] OFF
GO
COMMIT
GO
-- ----------------------------
-- Table structure for accounting_kind2
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[accounting_kind2]') AND type IN ('U'))
DROP TABLE [dbo].[accounting_kind2]
GO
CREATE TABLE [dbo].[accounting_kind2] (
[num] int IDENTITY(1,1) NOT NULL,
[kind] nvarchar(100) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[root] int DEFAULT 0 NULL,
[range] int NULL,
[demo] nvarchar(max) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[title] nvarchar(30) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[bank_name] nvarchar(30) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[bank_code] nvarchar(30) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[bank_id] nvarchar(30) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[record_payment] nvarchar(1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
)
GO
ALTER TABLE [dbo].[accounting_kind2] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'收支帳戶維護',
'SCHEMA', N'dbo',
'TABLE', N'accounting_kind2'
GO
-- ----------------------------
-- Records of accounting_kind2
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [dbo].[accounting_kind2] ON
GO
SET IDENTITY_INSERT [dbo].[accounting_kind2] OFF
GO
COMMIT
GO
-- ----------------------------
-- Table structure for act_bom
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[act_bom]') AND type IN ('U'))
DROP TABLE [dbo].[act_bom]
GO
CREATE TABLE [dbo].[act_bom] (
[num] int IDENTITY(1,1) NOT NULL,
[package_num] int NULL,
[item_num] int NULL,
[item_type] int NULL,
[group_name] nvarchar(100) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[optional] bit NULL,
[qty] int NULL,
[memo] nvarchar(max) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
)
GO
ALTER TABLE [dbo].[act_bom] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'組合品項(功德主)',
'SCHEMA', N'dbo',
'TABLE', N'act_bom'
GO
-- ----------------------------
-- Records of act_bom
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [dbo].[act_bom] ON
GO
SET IDENTITY_INSERT [dbo].[act_bom] OFF
GO
COMMIT
GO
-- ----------------------------
-- Table structure for actItem
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[actItem]') AND type IN ('U'))
DROP TABLE [dbo].[actItem]
GO
CREATE TABLE [dbo].[actItem] (
[num] int IDENTITY(1,1) NOT NULL,
[partno] nvarchar(100) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[subject] nvarchar(100) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[print_init] nvarchar(100) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[kind] int NULL,
[price] real NULL,
[status] nvarchar(1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[demo] nvarchar(max) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[extend] nvarchar(1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[cycle] int NULL,
[category] int NULL,
[customize_data] nvarchar(max) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[reg_time] datetime DEFAULT getdate() NULL,
[is_reconcile] nvarchar(1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
)
GO
ALTER TABLE [dbo].[actItem] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'品項管理主檔',
'SCHEMA', N'dbo',
'TABLE', N'actItem'
GO
-- ----------------------------
-- Records of actItem
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [dbo].[actItem] ON
GO
INSERT INTO [dbo].[actItem] ([num], [partno], [subject], [print_init], [kind], [price], [status], [demo], [extend], [cycle], [category], [customize_data], [reg_time], [is_reconcile]) VALUES (N'14', N'', N'總懺主', N'總懺', N'39', N'1000000', N'Y', N'', N'N', NULL, N'1', N'', NULL, N'N')
GO
INSERT INTO [dbo].[actItem] ([num], [partno], [subject], [print_init], [kind], [price], [status], [demo], [extend], [cycle], [category], [customize_data], [reg_time], [is_reconcile]) VALUES (N'15', N'', N'消災-大牌位', N'大X', N'40', N'10000', N'Y', N'', N'N', NULL, N'1', N'', NULL, N'N')
GO
INSERT INTO [dbo].[actItem] ([num], [partno], [subject], [print_init], [kind], [price], [status], [demo], [extend], [cycle], [category], [customize_data], [reg_time], [is_reconcile]) VALUES (N'16', N'', N'超薦-大牌位', N'大S', N'40', N'10000', N'Y', N'', N'N', NULL, N'1', N'', NULL, N'N')
GO
SET IDENTITY_INSERT [dbo].[actItem] OFF
GO
COMMIT
GO
-- ----------------------------
-- Table structure for actItem_files
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[actItem_files]') AND type IN ('U'))
DROP TABLE [dbo].[actItem_files]
GO
CREATE TABLE [dbo].[actItem_files] (
[num] int IDENTITY(1,1) NOT NULL,
[actItem_num] int NOT NULL,
[files_num] int NOT NULL,
[reg_time] datetime DEFAULT getdate() NULL
)
GO
ALTER TABLE [dbo].[actItem_files] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'品項相關文件檔',
'SCHEMA', N'dbo',
'TABLE', N'actItem_files'
GO
-- ----------------------------
-- Records of actItem_files
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [dbo].[actItem_files] ON
GO
SET IDENTITY_INSERT [dbo].[actItem_files] OFF
GO
COMMIT
GO
-- ----------------------------
-- Table structure for actItem_kind
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[actItem_kind]') AND type IN ('U'))
DROP TABLE [dbo].[actItem_kind]
GO
CREATE TABLE [dbo].[actItem_kind] (
[num] int IDENTITY(1,1) NOT NULL,
[kind] nvarchar(100) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[root] int DEFAULT 0 NULL,
[range] int NULL,
[demo] nvarchar(max) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[status] nvarchar(1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
)
GO
ALTER TABLE [dbo].[actItem_kind] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'品項分類管理',
'SCHEMA', N'dbo',
'TABLE', N'actItem_kind'
GO
-- ----------------------------
-- Records of actItem_kind
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [dbo].[actItem_kind] ON
GO
INSERT INTO [dbo].[actItem_kind] ([num], [kind], [root], [range], [demo], [status]) VALUES (N'38', N'功德', N'0', N'1', N'', N'Y')
GO
INSERT INTO [dbo].[actItem_kind] ([num], [kind], [root], [range], [demo], [status]) VALUES (N'39', N'功德主', N'38', N'1', N'', N'Y')
GO
INSERT INTO [dbo].[actItem_kind] ([num], [kind], [root], [range], [demo], [status]) VALUES (N'40', N'牌位', N'38', N'2', N'', N'Y')
GO
SET IDENTITY_INSERT [dbo].[actItem_kind] OFF
GO
COMMIT
GO
-- ----------------------------
-- Table structure for activity
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[activity]') AND type IN ('U'))
DROP TABLE [dbo].[activity]
GO
CREATE TABLE [dbo].[activity] (
[num] int IDENTITY(1,1) NOT NULL,
[kind] int NULL,
[subject] nvarchar(100) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[print_init] nvarchar(100) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[address] nvarchar(200) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[startDate_solar] datetime NULL,
[endDate_solar] datetime NULL,
[hall] nvarchar(50) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[start_sexagenary] nvarchar(2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[end_sexagenary] nvarchar(2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[monk] nvarchar(50) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[startDate_lunar] datetime NULL,
[endDate_lunar] datetime NULL,
[dueDate] datetime NULL,
[demo] nvarchar(max) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[reg_time] datetime DEFAULT getdate() NULL,
[customize_data] nvarchar(max) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[category_kind] int NULL
)
GO
ALTER TABLE [dbo].[activity] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'活動主檔',
'SCHEMA', N'dbo',
'TABLE', N'activity'
GO
-- ----------------------------
-- Records of activity
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [dbo].[activity] ON
GO
INSERT INTO [dbo].[activity] ([num], [kind], [subject], [print_init], [address], [startDate_solar], [endDate_solar], [hall], [start_sexagenary], [end_sexagenary], [monk], [startDate_lunar], [endDate_lunar], [dueDate], [demo], [reg_time], [customize_data], [category_kind]) VALUES (N'6', N'15', N'115年梁皇寶懺法會', NULL, NULL, N'2027-02-19 00:00:00.000', N'2027-02-27 00:00:00.000', NULL, NULL, NULL, NULL, NULL, NULL, N'2026-02-18 00:00:00.000', NULL, N'2026-02-24 15:21:19.100', NULL, N'16')
GO
SET IDENTITY_INSERT [dbo].[activity] OFF
GO
COMMIT
GO
-- ----------------------------
-- Table structure for activity_category_kind
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[activity_category_kind]') AND type IN ('U'))
DROP TABLE [dbo].[activity_category_kind]
GO
CREATE TABLE [dbo].[activity_category_kind] (
[num] int IDENTITY(1,1) NOT NULL,
[kind] nvarchar(100) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[root] int DEFAULT 0 NULL,
[range] int NULL
)
GO
ALTER TABLE [dbo].[activity_category_kind] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'活動主類型',
'SCHEMA', N'dbo',
'TABLE', N'activity_category_kind'
GO
-- ----------------------------
-- Records of activity_category_kind
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [dbo].[activity_category_kind] ON
GO
INSERT INTO [dbo].[activity_category_kind] ([num], [kind], [root], [range]) VALUES (N'15', N'道場法會', N'0', N'1')
GO
INSERT INTO [dbo].[activity_category_kind] ([num], [kind], [root], [range]) VALUES (N'16', N'常年性', N'15', N'1')
GO
SET IDENTITY_INSERT [dbo].[activity_category_kind] OFF
GO
COMMIT
GO
-- ----------------------------
-- Table structure for activity_check
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[activity_check]') AND type IN ('U'))
DROP TABLE [dbo].[activity_check]
GO
CREATE TABLE [dbo].[activity_check] (
[num] int IDENTITY(1,1) NOT NULL,
[f_num] int NULL,
[activity_num] int NULL,
[reg_time] datetime DEFAULT getdate() NULL,
[status] int NULL,
[qty] int NULL
)
GO
ALTER TABLE [dbo].[activity_check] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'活動報到檔',
'SCHEMA', N'dbo',
'TABLE', N'activity_check'
GO
-- ----------------------------
-- Records of activity_check
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [dbo].[activity_check] ON
GO
SET IDENTITY_INSERT [dbo].[activity_check] OFF
GO
COMMIT
GO
-- ----------------------------
-- Table structure for activity_kind
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[activity_kind]') AND type IN ('U'))
DROP TABLE [dbo].[activity_kind]
GO
CREATE TABLE [dbo].[activity_kind] (
[num] int IDENTITY(1,1) NOT NULL,
[kind] nvarchar(100) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[root] int DEFAULT 0 NULL,
[range] int NULL,
[demo] nvarchar(max) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[calendar] nvarchar(2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[month] int NULL,
[day] int NULL
)
GO
ALTER TABLE [dbo].[activity_kind] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'活動詳細分類',
'SCHEMA', N'dbo',
'TABLE', N'activity_kind'
GO
-- ----------------------------
-- Records of activity_kind
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [dbo].[activity_kind] ON
GO
INSERT INTO [dbo].[activity_kind] ([num], [kind], [root], [range], [demo], [calendar], [month], [day]) VALUES (N'13', N'道場法會', N'0', N'1', N'', NULL, NULL, NULL)
GO
INSERT INTO [dbo].[activity_kind] ([num], [kind], [root], [range], [demo], [calendar], [month], [day]) VALUES (N'14', N'常年性', N'13', N'1', N'', NULL, NULL, NULL)
GO
INSERT INTO [dbo].[activity_kind] ([num], [kind], [root], [range], [demo], [calendar], [month], [day]) VALUES (N'15', N'梁皇寶懺法會', N'14', N'1', N'', N'國曆', N'2', N'19')
GO
SET IDENTITY_INSERT [dbo].[activity_kind] OFF
GO
COMMIT
GO
-- ----------------------------
-- Table structure for activity_kind_detail
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[activity_kind_detail]') AND type IN ('U'))
DROP TABLE [dbo].[activity_kind_detail]
GO
CREATE TABLE [dbo].[activity_kind_detail] (
[num] int IDENTITY(1,1) NOT NULL,
[activity_kind_num] int NOT NULL,
[actItem_num] int NOT NULL,
[price] real NULL,
[qty] int NULL,
[reg_time] datetime DEFAULT getdate() NULL
)
GO
ALTER TABLE [dbo].[activity_kind_detail] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'活動分類-相關品項',
'SCHEMA', N'dbo',
'TABLE', N'activity_kind_detail'
GO
-- ----------------------------
-- Records of activity_kind_detail
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [dbo].[activity_kind_detail] ON
GO
INSERT INTO [dbo].[activity_kind_detail] ([num], [activity_kind_num], [actItem_num], [price], [qty], [reg_time]) VALUES (N'12', N'15', N'14', N'1000000', N'0', N'2026-02-24 15:19:49.563')
GO
INSERT INTO [dbo].[activity_kind_detail] ([num], [activity_kind_num], [actItem_num], [price], [qty], [reg_time]) VALUES (N'13', N'15', N'15', N'10000', N'0', N'2026-02-24 15:20:02.440')
GO
INSERT INTO [dbo].[activity_kind_detail] ([num], [activity_kind_num], [actItem_num], [price], [qty], [reg_time]) VALUES (N'14', N'15', N'16', N'10000', N'0', N'2026-02-24 15:20:13.397')
GO
SET IDENTITY_INSERT [dbo].[activity_kind_detail] OFF
GO
COMMIT
GO
-- ----------------------------
-- Table structure for activity_relating
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[activity_relating]') AND type IN ('U'))
DROP TABLE [dbo].[activity_relating]
GO
CREATE TABLE [dbo].[activity_relating] (
[num] int IDENTITY(1,1) NOT NULL,
[activity_num] int NOT NULL,
[actItem_num] int NOT NULL,
[price] real NULL,
[qty] int NULL,
[reg_time] datetime DEFAULT getdate() NULL
)
GO
ALTER TABLE [dbo].[activity_relating] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'活動主檔-相關品項',
'SCHEMA', N'dbo',
'TABLE', N'activity_relating'
GO
-- ----------------------------
-- Records of activity_relating
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [dbo].[activity_relating] ON
GO
SET IDENTITY_INSERT [dbo].[activity_relating] OFF
GO
COMMIT
GO
-- ----------------------------
-- Table structure for activity_spares
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[activity_spares]') AND type IN ('U'))
DROP TABLE [dbo].[activity_spares]
GO
CREATE TABLE [dbo].[activity_spares] (
[num] int IDENTITY(1,1) NOT NULL,
[activity_num] int NOT NULL,
[actItem_num] int NOT NULL,
[qty1] int NULL,
[qty2] int NULL,
[demo] nvarchar(max) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[reg_time] datetime DEFAULT getdate() NULL
)
GO
ALTER TABLE [dbo].[activity_spares] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'活動主檔-相關備品',
'SCHEMA', N'dbo',
'TABLE', N'activity_spares'
GO
-- ----------------------------
-- Records of activity_spares
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [dbo].[activity_spares] ON
GO
SET IDENTITY_INSERT [dbo].[activity_spares] OFF
GO
COMMIT
GO
-- ----------------------------
-- Table structure for admin
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[admin]') AND type IN ('U'))
DROP TABLE [dbo].[admin]
GO
CREATE TABLE [dbo].[admin] (
[num] int IDENTITY(1,1) NOT NULL,
[u_id] nvarchar(50) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[u_password] nvarchar(max) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[u_name] nvarchar(50) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[sex] nvarchar(2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[kind] nvarchar(10) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[phone1] nvarchar(50) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[phone2] nvarchar(50) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[birthday] datetime NULL,
[email] nvarchar(200) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[city] nvarchar(10) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[area] nvarchar(50) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[address] nvarchar(255) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[uid] nvarchar(20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[demo] nvarchar(max) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[power] nvarchar(3) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[online] bit NOT NULL,
[reg_time] datetime DEFAULT getdate() NULL,
[login_time] datetime NULL,
[login_ip] nvarchar(50) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[login_code] nvarchar(10) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[adwidth] nvarchar(10) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[wrp_news] nvarchar(1) COLLATE Chinese_Taiwan_Stroke_CI_AS DEFAULT N'Y' NULL,
[wrp_bar] nvarchar(1) COLLATE Chinese_Taiwan_Stroke_CI_AS DEFAULT N'Y' NULL,
[gauth_key] nvarchar(max) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[gauth_enabled] bit NULL
)
GO
ALTER TABLE [dbo].[admin] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'使用者管理',
'SCHEMA', N'dbo',
'TABLE', N'admin'
GO
-- ----------------------------
-- Records of admin
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [dbo].[admin] ON
GO
INSERT INTO [dbo].[admin] ([num], [u_id], [u_password], [u_name], [sex], [kind], [phone1], [phone2], [birthday], [email], [city], [area], [address], [uid], [demo], [power], [online], [reg_time], [login_time], [login_ip], [login_code], [adwidth], [wrp_news], [wrp_bar], [gauth_key], [gauth_enabled]) VALUES (N'1', N'17168ERP', N'JKUkMX4iye481EA+1Of7ew=', N'總管理者', N'男', N'管理者', N'', N'', NULL, N'', NULL, NULL, NULL, NULL, N'', N'EZ', N'1', N'2022-02-08 17:37:57.513', N'2026-02-23 16:58:38.000', N'210.61.157.21', N'bsmfd7q7yj', NULL, N'Y', N'Y', NULL, NULL)
GO
INSERT INTO [dbo].[admin] ([num], [u_id], [u_password], [u_name], [sex], [kind], [phone1], [phone2], [birthday], [email], [city], [area], [address], [uid], [demo], [power], [online], [reg_time], [login_time], [login_ip], [login_code], [adwidth], [wrp_news], [wrp_bar], [gauth_key], [gauth_enabled]) VALUES (N'20', N'user01', N'zryjcTZlc9lwlLyN+b/57D370mcSAgfBJ==', N'測試專員', N'男', N'管理者', N'', N'', NULL, N'', NULL, NULL, NULL, NULL, N'', N'01', N'1', N'2026-01-30 07:01:06.920', N'2026-02-24 11:17:55.000', N'127.0.0.1', N'9nndbbbxuy', NULL, N'Y', N'Y', NULL, N'0')
GO
SET IDENTITY_INSERT [dbo].[admin] OFF
GO
COMMIT
GO
-- ----------------------------
-- Table structure for admin_group
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[admin_group]') AND type IN ('U'))
DROP TABLE [dbo].[admin_group]
GO
CREATE TABLE [dbo].[admin_group] (
[g_name] nvarchar(3) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[items] nvarchar(255) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[demo] nvarchar(100) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
)
GO
ALTER TABLE [dbo].[admin_group] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'群組資料',
'SCHEMA', N'dbo',
'TABLE', N'admin_group'
GO
-- ----------------------------
-- Records of admin_group
-- ----------------------------
BEGIN TRANSACTION
GO
INSERT INTO [dbo].[admin_group] ([g_name], [items], [demo]) VALUES (N'01', N'36,37,51,52,28,54,29,31,58,34,35,63,38,39,57,64,83,84,65,74,66,67,68,80,69,70,73,71,72,85,86,55,56,79,82,81,78,75,77,76,', N'測試群組')
GO
INSERT INTO [dbo].[admin_group] ([g_name], [items], [demo]) VALUES (N'A', N'36,37,51,52,28,54,29,31,58,34,35,63,38,39,57,64,83,84,65,74,66,67,68,69,70,73,71,72,85,86,55,56,79,82,81,78,75,77,76,4,5,7,10,46,47,49,50,1,2,3,9,8,11,12,23,53,24,25,26,27,40,41,62,42,20,22,21,30,43,44,45,48,59,61,60,87,', N'最大管理者')
GO
INSERT INTO [dbo].[admin_group] ([g_name], [items], [demo]) VALUES (N'A01', N'4,7,10,1,2,3,9,8,11,12,', N'人事')
GO
INSERT INTO [dbo].[admin_group] ([g_name], [items], [demo]) VALUES (N'A02', N'28,38,40,55,29,54,39,41,42,56,', N'志工')
GO
INSERT INTO [dbo].[admin_group] ([g_name], [items], [demo]) VALUES (N'A03', N'36,37,51,52,28,54,29,31,58,34,35,63,38,39,57,64,83,84,65,74,66,67,68,80,69,70,73,71,72,85,86,55,56,79,82,81,78,75,77,76,4,5,7,10,46,47,49,50,1,2,3,9,8,11,12,23,53,24,25,26,27,40,41,62,42,20,22,21,30,43,44,45,48,59,61,60,87,', N'總管理員')
GO
INSERT INTO [dbo].[admin_group] ([g_name], [items], [demo]) VALUES (N'A04', N'43,44,45,48,', N'練習用')
GO
INSERT INTO [dbo].[admin_group] ([g_name], [items], [demo]) VALUES (N'B01', N'1,2,3,9,8,11,12,23,53,24,25,26,27,36,51,52,37,28,29,54,31,58,34,35,38,39,57,', N'功能群組-牌位')
GO
INSERT INTO [dbo].[admin_group] ([g_name], [items], [demo]) VALUES (N'EZ', N'36,37,51,52,28,54,29,31,58,34,35,63,38,39,57,64,83,84,65,74,66,67,68,69,70,71,72,55,56,75,4,5,7,10,46,47,49,50,1,2,3,9,8,11,12,23,53,24,25,26,27,40,41,62,42,20,22,21,30,43,44,45,48,59,61,60,87,', N'系統管理者')
GO
INSERT INTO [dbo].[admin_group] ([g_name], [items], [demo]) VALUES (N'tg', N'7,1,2,3,9,8,11,12,23,53,24,25,26,27,20,22,21,30,28,29,54,31,34,35,38,39,43,44,45,48,36,51,52,37,40,41,42,55,56,46,47,49,50,', N'testgroup')
GO
COMMIT
GO
-- ----------------------------
-- Table structure for admin_log
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[admin_log]') AND type IN ('U'))
DROP TABLE [dbo].[admin_log]
GO
CREATE TABLE [dbo].[admin_log] (
[num] int IDENTITY(1,1) NOT NULL,
[u_id] nvarchar(50) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[login_time] datetime DEFAULT getdate() NULL,
[login_ip] nvarchar(50) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[status] int NULL,
[agent] nvarchar(5) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[word] nvarchar(max) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[systems] int NULL
)
GO
ALTER TABLE [dbo].[admin_log] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'登入記錄查詢',
'SCHEMA', N'dbo',
'TABLE', N'admin_log'
GO
-- ----------------------------
-- Records of admin_log
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [dbo].[admin_log] ON
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'1', N'17168ERP', N'2026-01-30 14:56:52.000', N'210.61.157.21', N'1', N'電腦', N'登入成功', NULL)
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'2', N'17168ERP', N'2026-01-30 15:00:08.943', N'210.61.157.21', N'4', N'電腦', N'使用者：<a href="javascript:void(0)" class="btn btn-default btn-sm btn-log" onclick="msgbox($(this).parent().find(''div.d-none'').html())" >查看清單</a><div class="d-none">用戶1<br>用戶2<br>用戶3<br>Lottie<br>tracy<br>A君<br>舒安<br>路人乙<br>琪美姊姊<br>志工<br>淑惠<br>練習<br>huangkj<br>黄开杰</div>', N'13')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'3', N'17168ERP', N'2026-01-30 15:01:06.930', N'210.61.157.21', N'2', N'電腦', N'使用者：user01', N'13')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'4', N'user01', N'2026-01-30 15:06:18.000', N'210.61.157.21', N'1', N'電腦', N'登入成功', NULL)
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'5', N'17168ERP', N'2026-01-30 15:07:27.000', N'210.61.157.21', N'1', N'電腦', N'登入成功', NULL)
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'6', N'17168ERP', N'2026-01-30 15:12:03.820', N'210.61.157.21', N'3', N'電腦', N'使用者：user01', N'13')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'7', N'user01', N'2026-01-30 15:12:34.000', N'210.61.157.21', N'1', N'電腦', N'登入成功', NULL)
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'8', N'17168ERP', N'2026-01-30 15:13:14.000', N'210.61.157.21', N'1', N'電腦', N'登入成功', NULL)
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'9', N'17168ERP', N'2026-01-30 15:14:22.750', N'210.61.157.21', N'3', N'電腦', N'變更密碼：user01', N'13')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'10', N'user01', N'2026-01-30 15:16:01.000', N'210.61.157.21', N'1', N'電腦', N'登入成功', NULL)
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'11', N'user01', N'2026-02-02 10:28:22.000', N'210.61.157.21', N'1', N'電腦', N'帳號或密碼錯誤', NULL)
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'12', N'user01', N'2026-02-02 10:28:44.000', N'210.61.157.21', N'1', N'電腦', N'登入成功', NULL)
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'13', N'user01', N'2026-02-02 13:57:41.480', N'210.61.157.21', N'3', N'電腦', N'分類：法會', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'14', N'user01', N'2026-02-02 13:58:43.467', N'210.61.157.21', N'3', N'電腦', N'分類：功德', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'15', N'user01', N'2026-02-02 13:59:16.623', N'210.61.157.21', N'3', N'電腦', N'分類：牌位', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'16', N'user01', N'2026-02-02 13:59:35.750', N'210.61.157.21', N'3', N'電腦', N'分類：消災', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'17', N'user01', N'2026-02-02 13:59:54.287', N'210.61.157.21', N'3', N'電腦', N'分類：超薦', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'18', N'user01', N'2026-02-02 14:00:21.083', N'210.61.157.21', N'3', N'電腦', N'分類：消災大牌位', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'19', N'user01', N'2026-02-02 14:00:31.117', N'210.61.157.21', N'3', N'電腦', N'分類：超薦大牌位', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'20', N'user01', N'2026-02-02 14:01:01.150', N'210.61.157.21', N'3', N'電腦', N'分類：消災', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'21', N'user01', N'2026-02-02 14:01:09.580', N'210.61.157.21', N'3', N'電腦', N'分類：超薦', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'22', N'user01', N'2026-02-02 14:01:55.370', N'210.61.157.21', N'3', N'電腦', N'分類：點燈', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'23', N'user01', N'2026-02-02 14:02:07.893', N'210.61.157.21', N'3', N'電腦', N'分類：打齋', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'24', N'user01', N'2026-02-02 14:05:35.670', N'210.61.157.21', N'2', N'電腦', N'總懺主', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'25', N'user01', N'2026-02-02 14:06:55.037', N'210.61.157.21', N'2', N'電腦', N'總功德主', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'26', N'user01', N'2026-02-02 14:07:27.863', N'210.61.157.21', N'2', N'電腦', N'消災大牌位', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'27', N'user01', N'2026-02-02 14:08:07.463', N'210.61.157.21', N'2', N'電腦', N'消災中牌位', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'28', N'user01', N'2026-02-02 14:08:24.200', N'210.61.157.21', N'3', N'電腦', N'消災大牌位', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'29', N'user01', N'2026-02-02 14:08:54.513', N'210.61.157.21', N'2', N'電腦', N'消災小牌位', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'30', N'user01', N'2026-02-02 14:09:28.147', N'210.61.157.21', N'2', N'電腦', N'消災隨喜', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'31', N'user01', N'2026-02-02 14:09:58.983', N'210.61.157.21', N'2', N'電腦', N'超薦大牌位', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'32', N'user01', N'2026-02-02 14:10:26.297', N'210.61.157.21', N'2', N'電腦', N'超薦中牌位', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'33', N'user01', N'2026-02-02 14:11:03.833', N'210.61.157.21', N'2', N'電腦', N'超薦小牌位', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'34', N'user01', N'2026-02-02 14:11:15.627', N'210.61.157.21', N'3', N'電腦', N'超薦大牌位', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'35', N'user01', N'2026-02-02 14:11:23.910', N'210.61.157.21', N'3', N'電腦', N'超薦中牌位', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'36', N'user01', N'2026-02-02 14:11:32.407', N'210.61.157.21', N'3', N'電腦', N'超薦小牌位', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'37', N'user01', N'2026-02-02 14:11:59.920', N'210.61.157.21', N'2', N'電腦', N'超薦隨喜', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'38', N'user01', N'2026-02-02 14:14:43.463', N'210.61.157.21', N'3', N'電腦', N'總功德主', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'39', N'user01', N'2026-02-02 14:15:36.983', N'210.61.157.21', N'3', N'電腦', N'總懺主', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'40', N'user01', N'2026-02-02 14:18:06.403', N'210.61.157.21', N'2', N'電腦', N'陳一二', N'2')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'41', N'user01', N'2026-02-02 14:22:24.587', N'210.61.157.21', N'3', N'電腦', N'M2026020200001陳一二', N'2')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'42', N'user01', N'2026-02-02 14:23:05.073', N'210.61.157.21', N'2', N'電腦', N'主類型：法會', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'43', N'user01', N'2026-02-02 14:23:31.317', N'210.61.157.21', N'2', N'電腦', N'主類型：梁皇', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'44', N'user01', N'2026-02-02 14:23:48.640', N'210.61.157.21', N'2', N'電腦', N'主類型：水陸', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'45', N'user01', N'2026-02-02 14:24:44.300', N'210.61.157.21', N'2', N'電腦', N'詳細分類：梁皇法會', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'46', N'user01', N'2026-02-02 14:28:33.543', N'210.61.157.21', N'3', N'電腦', N'詳細分類：梁皇法會', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'47', N'user01', N'2026-02-02 14:29:04.453', N'210.61.157.21', N'3', N'電腦', N'詳細分類：梁皇法會', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'48', N'user01', N'2026-02-02 14:35:33.970', N'210.61.157.21', N'2', N'電腦', N'詳細分類：水陸法會', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'49', N'user01', N'2026-02-02 14:37:56.570', N'210.61.157.21', N'2', N'電腦', N'115年梁皇法會', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'50', N'user01', N'2026-02-02 14:39:12.333', N'210.61.157.21', N'3', N'電腦', N'115年梁皇法會', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'51', N'user01', N'2026-02-02 14:40:29.967', N'210.61.157.21', N'3', N'電腦', N'115年梁皇法會', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'52', N'user01', N'2026-02-02 14:40:45.217', N'210.61.157.21', N'3', N'電腦', N'115年梁皇法會', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'53', N'user01', N'2026-02-02 14:41:48.523', N'210.61.157.21', N'2', N'電腦', N'AA2602020001', N'4')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'54', N'user01', N'2026-02-02 14:44:39.307', N'210.61.157.21', N'3', N'電腦', N'AA2602020001', N'4')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'55', N'user01', N'2026-02-02 14:45:16.613', N'210.61.157.21', N'3', N'電腦', N'M2026020200001陳一二', N'2')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'56', N'user01', N'2026-02-02 14:47:38.017', N'210.61.157.21', N'3', N'電腦', N'AA2602020001', N'4')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'57', N'user01', N'2026-02-02 14:50:55.590', N'210.61.157.21', N'2', N'電腦', N'115年水陸法會', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'58', N'user01', N'2026-02-02 14:51:32.800', N'210.61.157.21', N'3', N'電腦', N'115年水陸法會', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'59', N'user01', N'2026-02-02 14:51:56.477', N'210.61.157.21', N'2', N'電腦', N'AA2602020002', N'4')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'60', N'user01', N'2026-02-02 14:53:46.337', N'210.61.157.21', N'3', N'電腦', N'AA2602020002', N'4')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'61', N'17168ERP', N'2026-02-03 08:19:29.000', N'49.215.88.30', N'1', N'手機', N'登入成功', NULL)
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'62', N'user01', N'2026-02-03 14:02:29.000', N'210.61.157.21', N'1', N'電腦', N'登入成功', NULL)
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'63', N'user01', N'2026-02-04 08:46:38.000', N'210.61.157.21', N'1', N'電腦', N'登入成功', NULL)
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'64', N'user01', N'2026-02-04 10:25:40.000', N'210.61.157.21', N'1', N'電腦', N'登入成功', NULL)
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'65', N'user01', N'2026-02-04 11:56:10.487', N'210.61.157.21', N'2', N'電腦', N'Excel匯入：<a href="javascript:void(0)" class="btn btn-default btn-sm btn-log" onclick="msgbox($(this).parent().find(''div.d-none'').html())" >查看清單</a><div class="d-none">1150204001男一號<br>1150204002男二號<br>1150204003男三號<br>1150204004女一號<br>1150204005女二號<br>1150204006女三號</div>', N'2')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'66', N'user01', N'2026-02-04 11:58:11.440', N'210.61.157.21', N'6', N'電腦', N'<a href="javascript:void(0)" class="btn btn-default btn-sm btn-log" onclick="msgbox($(this).parent().find(''div.d-none'').html())" >查看清單</a><div class="d-none">1150204006女三號<br>1150204005女二號<br>1150204004女一號<br>1150204003男三號<br>1150204002男二號<br>1150204001男一號<br>M2026020200001陳一二</div>', N'2')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'67', N'user01', N'2026-02-04 11:58:48.503', N'210.61.157.21', N'6', N'電腦', N'<a href="javascript:void(0)" class="btn btn-default btn-sm btn-log" onclick="msgbox($(this).parent().find(''div.d-none'').html())" >查看清單</a><div class="d-none">1150204006女三號<br>1150204005女二號<br>1150204004女一號<br>1150204003男三號<br>1150204002男二號<br>1150204001男一號<br>M2026020200001陳一二</div>', N'2')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'68', N'user01', N'2026-02-04 11:58:53.287', N'210.61.157.21', N'6', N'電腦', N'<a href="javascript:void(0)" class="btn btn-default btn-sm btn-log" onclick="msgbox($(this).parent().find(''div.d-none'').html())" >查看清單</a><div class="d-none">1150204006女三號<br>1150204005女二號<br>1150204004女一號<br>1150204003男三號<br>1150204002男二號<br>1150204001男一號<br>M2026020200001陳一二</div>', N'2')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'69', N'user01', N'2026-02-04 13:43:23.863', N'210.61.157.21', N'2', N'電腦', N'女四號', N'2')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'70', N'user01', N'2026-02-04 16:02:01.447', N'210.61.157.21', N'3', N'電腦', N'F2026020400001女四號', N'2')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'71', N'user01', N'2026-02-04 16:03:37.347', N'210.61.157.21', N'6', N'電腦', N'<a href="javascript:void(0)" class="btn btn-default btn-sm btn-log" onclick="msgbox($(this).parent().find(''div.d-none'').html())" >查看清單</a><div class="d-none">F2026020400001女四號<br>1150204006女三號<br>1150204005女二號<br>1150204004女一號<br>1150204003男三號<br>1150204002男二號<br>1150204001男一號<br>M2026020200001陳一二</div>', N'2')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'72', N'user01', N'2026-02-04 16:04:48.783', N'210.61.157.21', N'3', N'電腦', N'F2026020400001女四號', N'2')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'73', N'user01', N'2026-02-04 16:04:51.933', N'210.61.157.21', N'3', N'電腦', N'F2026020400001女四號', N'2')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'74', N'user01', N'2026-02-04 16:05:07.790', N'210.61.157.21', N'3', N'電腦', N'F2026020400001女四號', N'2')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'75', N'user01', N'2026-02-04 16:26:12.800', N'210.61.157.21', N'3', N'電腦', N'F2026020400001女四號', N'2')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'76', N'user01', N'2026-02-04 16:26:38.673', N'210.61.157.21', N'6', N'電腦', N'<a href="javascript:void(0)" class="btn btn-default btn-sm btn-log" onclick="msgbox($(this).parent().find(''div.d-none'').html())" >查看清單</a><div class="d-none">F2026020400001女四號<br>1150204006女三號<br>1150204005女二號<br>1150204004女一號<br>1150204003男三號<br>1150204002男二號<br>1150204001男一號<br>M2026020200001陳一二</div>', N'2')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'77', N'user01', N'2026-02-04 16:27:07.533', N'210.61.157.21', N'3', N'電腦', N'F2026020400001女四號', N'2')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'78', N'user01', N'2026-02-04 17:07:26.393', N'210.61.157.21', N'2', N'電腦', N'hk4g4', N'7')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'79', N'user01', N'2026-02-04 17:07:47.503', N'210.61.157.21', N'3', N'電腦', N'hk4g4', N'7')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'80', N'user01', N'2026-02-04 17:07:53.893', N'210.61.157.21', N'3', N'電腦', N'[標準L2B]大牌位-佛力超薦-往生蓮位-特-A3(直)', N'7')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'81', N'user01', N'2026-02-04 17:08:30.643', N'210.61.157.21', N'3', N'電腦', N'[標準L2B]大牌位-佛力超薦-往生蓮位-特-A3(測)', N'7')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'82', N'user01', N'2026-02-04 17:10:23.250', N'210.61.157.21', N'3', N'電腦', N'[標準L2B]大牌位-佛力超薦-往生蓮位-特-A3(測)', N'7')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'83', N'user01', N'2026-02-04 17:17:34.397', N'210.61.157.21', N'3', N'電腦', N'[標準L2B]大牌位-佛力超薦-往生蓮位-特-A3(測)', N'7')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'84', N'user01', N'2026-02-04 17:19:40.507', N'210.61.157.21', N'3', N'電腦', N'超薦大牌位', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'85', N'user01', N'2026-02-05 14:10:03.000', N'210.61.157.21', N'1', N'電腦', N'登入成功', NULL)
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'86', N'user01', N'2026-02-05 15:59:36.000', N'210.61.157.21', N'1', N'電腦', N'登入成功', NULL)
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'87', N'user01', N'2026-02-05 17:04:34.013', N'210.61.157.21', N'3', N'電腦', N'分類：1', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'88', N'user01', N'2026-02-05 17:04:48.403', N'210.61.157.21', N'3', N'電腦', N'分類：1', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'89', N'user01', N'2026-02-06 08:01:37.000', N'210.61.157.21', N'1', N'電腦', N'登入成功', NULL)
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'90', N'user01', N'2026-02-06 08:02:17.000', N'210.61.157.21', N'1', N'電腦', N'登入成功', NULL)
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'91', N'user01', N'2026-02-06 08:39:59.000', N'210.61.157.21', N'1', N'電腦', N'登入成功', NULL)
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'92', N'user01', N'2026-02-06 17:16:29.057', N'210.61.157.21', N'3', N'電腦', N'分類：功德', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'93', N'user01', N'2026-02-06 17:16:37.523', N'210.61.157.21', N'3', N'電腦', N'分類：功德', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'94', N'user01', N'2026-02-06 17:22:37.073', N'210.61.157.21', N'3', N'電腦', N'超薦隨喜', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'95', N'user01', N'2026-02-06 17:22:49.787', N'210.61.157.21', N'3', N'電腦', N'超薦隨喜', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'96', N'user01', N'2026-02-06 17:37:27.000', N'210.61.157.21', N'1', N'電腦', N'登入成功', NULL)
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'97', N'user01', N'2026-02-06 17:38:00.127', N'210.61.157.21', N'3', N'電腦', N'F2026020400001女四號', N'2')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'98', N'user01', N'2026-02-06 17:42:59.680', N'210.61.157.21', N'3', N'電腦', N'主類型：水陸123', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'99', N'user01', N'2026-02-06 17:43:21.707', N'210.61.157.21', N'2', N'電腦', N'詳細分類：水陸法會123', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'100', N'user01', N'2026-02-09 10:19:09.250', N'210.61.157.21', N'3', N'電腦', N'主類型：水陸', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'101', N'user01', N'2026-02-09 10:20:45.977', N'210.61.157.21', N'4', N'電腦', N'詳細分類：水陸法會123', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'102', N'user01', N'2026-02-09 10:22:32.370', N'210.61.157.21', N'3', N'電腦', N'分類：法會', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'103', N'user01', N'2026-02-09 10:22:51.453', N'210.61.157.21', N'3', N'電腦', N'分類：法會', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'104', N'user01', N'2026-02-09 10:23:11.690', N'210.61.157.21', N'3', N'電腦', N'分類：法會', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'105', N'user01', N'2026-02-09 10:23:16.920', N'210.61.157.21', N'3', N'電腦', N'分類：法會', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'106', N'user01', N'2026-02-09 10:23:19.967', N'210.61.157.21', N'3', N'電腦', N'分類：法會', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'107', N'user01', N'2026-02-09 10:23:25.220', N'210.61.157.21', N'3', N'電腦', N'分類：法會', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'108', N'user01', N'2026-02-09 10:23:56.300', N'210.61.157.21', N'3', N'電腦', N'分類：牌位', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'109', N'user01', N'2026-02-09 10:24:04.387', N'210.61.157.21', N'3', N'電腦', N'分類：功德', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'110', N'user01', N'2026-02-09 10:24:17.787', N'210.61.157.21', N'3', N'電腦', N'分類：消災', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'111', N'user01', N'2026-02-09 10:24:25.040', N'210.61.157.21', N'3', N'電腦', N'分類：超薦', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'112', N'user01', N'2026-02-09 10:24:33.123', N'210.61.157.21', N'3', N'電腦', N'分類：超冤', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'113', N'user01', N'2026-02-09 10:24:42.907', N'210.61.157.21', N'3', N'電腦', N'分類：點燈', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'114', N'user01', N'2026-02-09 10:24:52.753', N'210.61.157.21', N'3', N'電腦', N'分類：打齋', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'115', N'user01', N'2026-02-09 10:33:18.307', N'210.61.157.21', N'4', N'電腦', N'主類型：法會', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'116', N'user01', N'2026-02-09 10:33:36.863', N'210.61.157.21', N'2', N'電腦', N'主類型：法會', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'117', N'user01', N'2026-02-09 10:33:54.853', N'210.61.157.21', N'2', N'電腦', N'主類型：梁皇', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'118', N'user01', N'2026-02-09 10:34:11.220', N'210.61.157.21', N'3', N'電腦', N'主類型：梁皇法會', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'119', N'user01', N'2026-02-09 10:34:24.383', N'210.61.157.21', N'4', N'電腦', N'詳細分類：梁皇法會', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'120', N'user01', N'2026-02-09 10:36:56.937', N'210.61.157.21', N'2', N'電腦', N'詳細分類：梁皇法會', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'121', N'user01', N'2026-02-09 10:55:21.807', N'210.61.157.21', N'3', N'電腦', N'分類：法會', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'122', N'user01', N'2026-02-09 11:01:35.370', N'210.61.157.21', N'3', N'電腦', N'分類：功德', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'123', N'user01', N'2026-02-09 11:01:42.970', N'210.61.157.21', N'3', N'電腦', N'分類：牌位', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'124', N'user01', N'2026-02-09 11:02:51.873', N'210.61.157.21', N'3', N'電腦', N'分類：打齋', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'125', N'user01', N'2026-02-09 11:02:58.973', N'210.61.157.21', N'3', N'電腦', N'分類：點燈', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'126', N'user01', N'2026-02-09 11:03:06.813', N'210.61.157.21', N'3', N'電腦', N'分類：消災', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'127', N'user01', N'2026-02-09 11:03:10.967', N'210.61.157.21', N'3', N'電腦', N'分類：超薦', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'128', N'user01', N'2026-02-09 11:03:16.203', N'210.61.157.21', N'3', N'電腦', N'分類：超冤', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'129', N'user01', N'2026-02-09 11:10:03.343', N'210.61.157.21', N'2', N'電腦', N'消災-隨喜牌位', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'130', N'user01', N'2026-02-09 11:10:41.287', N'210.61.157.21', N'2', N'電腦', N'主類型：法會', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'131', N'user01', N'2026-02-09 11:11:04.530', N'210.61.157.21', N'2', N'電腦', N'主類型：梁皇法會', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'132', N'user01', N'2026-02-09 11:14:18.153', N'210.61.157.21', N'4', N'電腦', N'主類型：梁皇法會', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'133', N'user01', N'2026-02-09 11:14:21.777', N'210.61.157.21', N'4', N'電腦', N'主類型：法會', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'134', N'user01', N'2026-02-09 11:14:30.380', N'210.61.157.21', N'2', N'電腦', N'主類型：基金會活動', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'135', N'user01', N'2026-02-09 11:14:36.953', N'210.61.157.21', N'2', N'電腦', N'主類型：道場活動', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'136', N'user01', N'2026-02-09 11:14:44.990', N'210.61.157.21', N'2', N'電腦', N'主類型：法會', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'137', N'user01', N'2026-02-09 11:22:27.450', N'210.61.157.21', N'2', N'電腦', N'詳細分類：法會', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'138', N'user01', N'2026-02-09 11:23:20.033', N'210.61.157.21', N'4', N'電腦', N'詳細分類：法會', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'139', N'user01', N'2026-02-09 11:23:33.767', N'210.61.157.21', N'2', N'電腦', N'詳細分類：梁皇法會', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'140', N'user01', N'2026-02-09 11:23:45.853', N'210.61.157.21', N'3', N'電腦', N'詳細分類：法會', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'141', N'user01', N'2026-02-09 11:23:52.337', N'210.61.157.21', N'2', N'電腦', N'詳細分類：梁皇法會', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'142', N'user01', N'2026-02-09 11:30:24.053', N'210.61.157.21', N'2', N'電腦', N'115年梁皇法會', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'143', N'user01', N'2026-02-09 11:32:13.697', N'210.61.157.21', N'2', N'電腦', N'男眾壹', N'2')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'144', N'user01', N'2026-02-09 11:34:05.193', N'210.61.157.21', N'2', N'電腦', N'AA2602090001', N'4')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'145', N'user01', N'2026-02-09 14:34:50.470', N'210.61.157.21', N'3', N'電腦', N'分類：法會', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'146', N'user01', N'2026-02-09 14:35:04.043', N'210.61.157.21', N'3', N'電腦', N'分類：功德', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'147', N'user01', N'2026-02-09 14:35:10.560', N'210.61.157.21', N'3', N'電腦', N'分類：牌位', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'148', N'user01', N'2026-02-09 14:35:19.727', N'210.61.157.21', N'3', N'電腦', N'分類：點燈', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'149', N'user01', N'2026-02-09 14:35:23.950', N'210.61.157.21', N'3', N'電腦', N'分類：打齋', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'150', N'user01', N'2026-02-09 14:35:35.663', N'210.61.157.21', N'3', N'電腦', N'分類：消災', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'151', N'user01', N'2026-02-09 14:35:39.973', N'210.61.157.21', N'3', N'電腦', N'分類：超薦', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'152', N'user01', N'2026-02-09 14:35:45.930', N'210.61.157.21', N'3', N'電腦', N'分類：超冤', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'153', N'user01', N'2026-02-09 14:36:29.273', N'210.61.157.21', N'2', N'電腦', N'消災-隨喜牌位', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'154', N'user01', N'2026-02-09 14:37:23.763', N'210.61.157.21', N'2', N'電腦', N'超薦-隨喜牌位', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'155', N'user01', N'2026-02-09 14:37:58.370', N'210.61.157.21', N'3', N'電腦', N'消災-隨喜牌位', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'156', N'user01', N'2026-02-09 14:38:08.333', N'210.61.157.21', N'3', N'電腦', N'超薦-隨喜牌位', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'157', N'user01', N'2026-02-09 14:38:10.827', N'210.61.157.21', N'3', N'電腦', N'消災-隨喜牌位', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'158', N'user01', N'2026-02-09 14:38:14.083', N'210.61.157.21', N'3', N'電腦', N'超薦-隨喜牌位', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'159', N'user01', N'2026-02-09 14:40:45.820', N'210.61.157.21', N'2', N'電腦', N'主類型：道場活動', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'160', N'user01', N'2026-02-09 14:40:58.023', N'210.61.157.21', N'2', N'電腦', N'主類型：法會', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'161', N'user01', N'2026-02-09 14:41:08.780', N'210.61.157.21', N'2', N'電腦', N'詳細分類：法會', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'162', N'user01', N'2026-02-09 14:41:34.717', N'210.61.157.21', N'2', N'電腦', N'詳細分類：梁皇法會', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'163', N'user01', N'2026-02-09 14:42:43.133', N'210.61.157.21', N'2', N'電腦', N'115年梁皇法會', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'164', N'user01', N'2026-02-09 14:45:02.690', N'210.61.157.21', N'2', N'電腦', N'陳甲壹', N'2')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'165', N'user01', N'2026-02-09 14:46:33.697', N'210.61.157.21', N'2', N'電腦', N'AA2602090002', N'4')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'166', N'user01', N'2026-02-10 08:16:52.000', N'210.61.157.21', N'1', N'電腦', N'登入成功', NULL)
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'167', N'user01', N'2026-02-23 11:40:09.000', N'127.0.0.1', N'1', N'電腦', N'帳號或密碼錯誤', NULL)
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'168', N'user01', N'2026-02-23 11:40:28.000', N'127.0.0.1', N'1', N'電腦', N'登入成功', NULL)
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'169', N'user01', N'2026-02-23 14:04:11.000', N'210.61.157.21', N'1', N'電腦', N'登入成功', NULL)
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'170', N'user01', N'2026-02-23 14:15:38.000', N'127.0.0.1', N'1', N'電腦', N'登入成功', NULL)
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'171', N'user01', N'2026-02-23 14:32:22.000', N'210.61.157.21', N'1', N'電腦', N'登入成功', NULL)
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'172', N'user01', N'2026-02-23 16:44:06.000', N'127.0.0.1', N'1', N'電腦', N'登入成功', NULL)
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'173', N'17168ERP', N'2026-02-23 16:58:38.000', N'210.61.157.21', N'1', N'電腦', N'登入成功', NULL)
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'174', N'user01', N'2026-02-24 11:17:55.000', N'127.0.0.1', N'1', N'電腦', N'登入成功', NULL)
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'175', N'user01', N'2026-02-24 14:46:51.983', N'210.61.157.21', N'3', N'電腦', N'分類：功德', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'176', N'user01', N'2026-02-24 14:47:04.787', N'210.61.157.21', N'3', N'電腦', N'分類：功德主', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'177', N'user01', N'2026-02-24 14:47:15.353', N'210.61.157.21', N'3', N'電腦', N'分類：牌位', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'178', N'user01', N'2026-02-24 14:52:11.047', N'210.61.157.21', N'3', N'電腦', N'分類：功德', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'179', N'user01', N'2026-02-24 14:52:21.800', N'210.61.157.21', N'3', N'電腦', N'分類：功德主', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'180', N'user01', N'2026-02-24 14:52:34.317', N'210.61.157.21', N'3', N'電腦', N'分類：牌位', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'181', N'user01', N'2026-02-24 14:53:29.613', N'210.61.157.21', N'2', N'電腦', N'總懺主', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'182', N'user01', N'2026-02-24 14:54:13.900', N'210.61.157.21', N'2', N'電腦', N'消災-大牌位', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'183', N'user01', N'2026-02-24 14:54:49.927', N'210.61.157.21', N'2', N'電腦', N'超薦-大牌位', N'6')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'184', N'user01', N'2026-02-24 15:04:53.410', N'210.61.157.21', N'2', N'電腦', N'主類型：道場法會', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'185', N'user01', N'2026-02-24 15:05:14.080', N'210.61.157.21', N'2', N'電腦', N'主類型：常年性', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'186', N'user01', N'2026-02-24 15:05:43.797', N'210.61.157.21', N'2', N'電腦', N'詳細分類：道場法會', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'187', N'user01', N'2026-02-24 15:05:59.263', N'210.61.157.21', N'2', N'電腦', N'詳細分類：常年性', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'188', N'user01', N'2026-02-24 15:06:28.333', N'210.61.157.21', N'2', N'電腦', N'詳細分類：梁皇寶懺法會', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'189', N'user01', N'2026-02-24 15:07:39.883', N'210.61.157.21', N'2', N'電腦', N'115年梁皇寶懺法會', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'190', N'user01', N'2026-02-24 15:18:14.407', N'210.61.157.21', N'2', N'電腦', N'主類型：道場法會', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'191', N'user01', N'2026-02-24 15:18:27.650', N'210.61.157.21', N'2', N'電腦', N'主類型：常年性', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'192', N'user01', N'2026-02-24 15:18:52.757', N'210.61.157.21', N'2', N'電腦', N'詳細分類：道場法會', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'193', N'user01', N'2026-02-24 15:19:05.867', N'210.61.157.21', N'2', N'電腦', N'詳細分類：常年性', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'194', N'user01', N'2026-02-24 15:19:31.053', N'210.61.157.21', N'2', N'電腦', N'詳細分類：梁皇寶懺法會', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'195', N'user01', N'2026-02-24 15:21:19.120', N'210.61.157.21', N'2', N'電腦', N'115年梁皇寶懺法會', N'3')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'196', N'user01', N'2026-02-24 15:26:34.340', N'210.61.157.21', N'2', N'電腦', N'陳甲壹', N'2')
GO
INSERT INTO [dbo].[admin_log] ([num], [u_id], [login_time], [login_ip], [status], [agent], [word], [systems]) VALUES (N'197', N'user01', N'2026-02-24 15:35:54.063', N'210.61.157.21', N'2', N'電腦', N'AA2602240001', N'4')
GO
SET IDENTITY_INSERT [dbo].[admin_log] OFF
GO
COMMIT
GO
-- ----------------------------
-- Table structure for AncestralTabletArea
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[AncestralTabletArea]') AND type IN ('U'))
DROP TABLE [dbo].[AncestralTabletArea]
GO
CREATE TABLE [dbo].[AncestralTabletArea] (
[AreaId] int IDENTITY(1,1) NOT NULL,
[AreaName] nvarchar(10) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[AreaCode] nvarchar(20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[ParentAreaId] int NULL,
[AreaType] nvarchar(10) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Price] int NULL,
[SortOrder] int NULL,
[IsDisabled] bit DEFAULT 0 NOT NULL,
[Description] nvarchar(200) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
)
GO
ALTER TABLE [dbo].[AncestralTabletArea] SET (LOCK_ESCALATION = TABLE)
GO
-- ----------------------------
-- Records of AncestralTabletArea
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [dbo].[AncestralTabletArea] ON
GO
SET IDENTITY_INSERT [dbo].[AncestralTabletArea] OFF
GO
COMMIT
GO
-- ----------------------------
-- Table structure for AncestralTabletPosition
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[AncestralTabletPosition]') AND type IN ('U'))
DROP TABLE [dbo].[AncestralTabletPosition]
GO
CREATE TABLE [dbo].[AncestralTabletPosition] (
[PositionId] int IDENTITY(1,1) NOT NULL,
[AreaId] int NOT NULL,
[PositionCode] nvarchar(20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[PositionName] nvarchar(50) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Price] int NULL,
[StatusCode] nvarchar(20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Description] nvarchar(200) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[RowNo] int NULL,
[ColumnNo] int NULL
)
GO
ALTER TABLE [dbo].[AncestralTabletPosition] SET (LOCK_ESCALATION = TABLE)
GO
-- ----------------------------
-- Records of AncestralTabletPosition
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [dbo].[AncestralTabletPosition] ON
GO
SET IDENTITY_INSERT [dbo].[AncestralTabletPosition] OFF
GO
COMMIT
GO
-- ----------------------------
-- Table structure for AncestralTabletPositionRecord
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[AncestralTabletPositionRecord]') AND type IN ('U'))
DROP TABLE [dbo].[AncestralTabletPositionRecord]
GO
CREATE TABLE [dbo].[AncestralTabletPositionRecord] (
[RecordId] int IDENTITY(1,1) NOT NULL,
[RegistrantCode] nvarchar(20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[NPTitle] nvarchar(30) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[NPStandDate] date NOT NULL,
[NPYangShang] nvarchar(20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[WPContent] nvarchar(1000) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[CreatedAt] datetime DEFAULT getdate() NOT NULL,
[UpdatedAt] datetime NULL
)
GO
ALTER TABLE [dbo].[AncestralTabletPositionRecord] SET (LOCK_ESCALATION = TABLE)
GO
-- ----------------------------
-- Records of AncestralTabletPositionRecord
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [dbo].[AncestralTabletPositionRecord] ON
GO
SET IDENTITY_INSERT [dbo].[AncestralTabletPositionRecord] OFF
GO
COMMIT
GO
-- ----------------------------
-- Table structure for AncestralTabletRegistrant
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[AncestralTabletRegistrant]') AND type IN ('U'))
DROP TABLE [dbo].[AncestralTabletRegistrant]
GO
CREATE TABLE [dbo].[AncestralTabletRegistrant] (
[RegistrantCode] nvarchar(20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[Name] nvarchar(50) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[Phone] nvarchar(50) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Address] nvarchar(60) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[RegisterDate] date NOT NULL,
[Price] int NULL,
[PositionId] int NULL,
[StartDate] date NOT NULL,
[EndDate] date NULL,
[IsLongTerm] bit DEFAULT 0 NOT NULL,
[IsActive] bit DEFAULT 1 NOT NULL,
[CreatedAt] datetime DEFAULT getdate() NOT NULL,
[UpdatedAt] datetime NULL,
[IsEnd] bit DEFAULT 0 NOT NULL
)
GO
ALTER TABLE [dbo].[AncestralTabletRegistrant] SET (LOCK_ESCALATION = TABLE)
GO
-- ----------------------------
-- Records of AncestralTabletRegistrant
-- ----------------------------
BEGIN TRANSACTION
GO
COMMIT
GO
-- ----------------------------
-- Table structure for AncestralTabletStatus
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[AncestralTabletStatus]') AND type IN ('U'))
DROP TABLE [dbo].[AncestralTabletStatus]
GO
CREATE TABLE [dbo].[AncestralTabletStatus] (
[StatusCode] nvarchar(20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[StatusName] nvarchar(20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[StatusType] nvarchar(20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL
)
GO
ALTER TABLE [dbo].[AncestralTabletStatus] SET (LOCK_ESCALATION = TABLE)
GO
-- ----------------------------
-- Records of AncestralTabletStatus
-- ----------------------------
BEGIN TRANSACTION
GO
INSERT INTO [dbo].[AncestralTabletStatus] ([StatusCode], [StatusName], [StatusType]) VALUES (N'available', N'可用', N'Position')
GO
INSERT INTO [dbo].[AncestralTabletStatus] ([StatusCode], [StatusName], [StatusType]) VALUES (N'maintenance', N'維護中', N'Position')
GO
INSERT INTO [dbo].[AncestralTabletStatus] ([StatusCode], [StatusName], [StatusType]) VALUES (N'used', N'已使用', N'Position')
GO
COMMIT
GO
-- ----------------------------
-- Table structure for appellation
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[appellation]') AND type IN ('U'))
DROP TABLE [dbo].[appellation]
GO
CREATE TABLE [dbo].[appellation] (
[num] int IDENTITY(1,1) NOT NULL,
[title] nvarchar(10) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
)
GO
ALTER TABLE [dbo].[appellation] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'(新)',
'SCHEMA', N'dbo',
'TABLE', N'appellation'
GO
-- ----------------------------
-- Records of appellation
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [dbo].[appellation] ON
GO
SET IDENTITY_INSERT [dbo].[appellation] OFF
GO
COMMIT
GO
-- ----------------------------
-- Table structure for bed_kind
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[bed_kind]') AND type IN ('U'))
DROP TABLE [dbo].[bed_kind]
GO
CREATE TABLE [dbo].[bed_kind] (
[num] int IDENTITY(1,1) NOT NULL,
[kind] nvarchar(100) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[root] int DEFAULT 0 NULL,
[range] int NULL,
[demo] nvarchar(max) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[sex] nvarchar(2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
)
GO
ALTER TABLE [dbo].[bed_kind] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'房間管理主檔',
'SCHEMA', N'dbo',
'TABLE', N'bed_kind'
GO
-- ----------------------------
-- Records of bed_kind
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [dbo].[bed_kind] ON
GO
SET IDENTITY_INSERT [dbo].[bed_kind] OFF
GO
COMMIT
GO
-- ----------------------------
-- Table structure for bed_kind_detail
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[bed_kind_detail]') AND type IN ('U'))
DROP TABLE [dbo].[bed_kind_detail]
GO
CREATE TABLE [dbo].[bed_kind_detail] (
[num] int IDENTITY(1,1) NOT NULL,
[bed_kind_id] int NULL,
[bed_name] nvarchar(50) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[bed_type] int NULL,
[demo] nvarchar(max) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
)
GO
ALTER TABLE [dbo].[bed_kind_detail] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'房間管理-床位明細',
'SCHEMA', N'dbo',
'TABLE', N'bed_kind_detail'
GO
-- ----------------------------
-- Records of bed_kind_detail
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [dbo].[bed_kind_detail] ON
GO
SET IDENTITY_INSERT [dbo].[bed_kind_detail] OFF
GO
COMMIT
GO
-- ----------------------------
-- Table structure for bed_order
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[bed_order]') AND type IN ('U'))
DROP TABLE [dbo].[bed_order]
GO
CREATE TABLE [dbo].[bed_order] (
[bed_order_no] nvarchar(20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[order_no] nvarchar(20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[o_detail_id] int NULL,
[start_date] datetime NULL,
[end_date] datetime NULL,
[phone] nvarchar(max) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[keyin1] nvarchar(2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[demo] nvarchar(max) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[reg_time] datetime DEFAULT getdate() NULL
)
GO
ALTER TABLE [dbo].[bed_order] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'報名-掛單主檔',
'SCHEMA', N'dbo',
'TABLE', N'bed_order'
GO
-- ----------------------------
-- Records of bed_order
-- ----------------------------
BEGIN TRANSACTION
GO
COMMIT
GO
-- ----------------------------
-- Table structure for bed_order_detail
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[bed_order_detail]') AND type IN ('U'))
DROP TABLE [dbo].[bed_order_detail]
GO
CREATE TABLE [dbo].[bed_order_detail] (
[num] int IDENTITY(1,1) NOT NULL,
[bed_order_no] nvarchar(20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[checkIn_date] datetime NULL,
[bed_kind1] int NULL,
[bed_kind2] int NULL,
[bed_kind_detail_id] int NULL,
[license] nvarchar(10) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
)
GO
ALTER TABLE [dbo].[bed_order_detail] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'報名-掛單明細',
'SCHEMA', N'dbo',
'TABLE', N'bed_order_detail'
GO
-- ----------------------------
-- Records of bed_order_detail
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [dbo].[bed_order_detail] ON
GO
SET IDENTITY_INSERT [dbo].[bed_order_detail] OFF
GO
COMMIT
GO
-- ----------------------------
-- Table structure for company
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[company]') AND type IN ('U'))
DROP TABLE [dbo].[company]
GO
CREATE TABLE [dbo].[company] (
[num] int IDENTITY(1,1) NOT NULL,
[com_name] nvarchar(20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[com_mail] nvarchar(200) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[bcc_mail] nvarchar(max) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[pic_url] nvarchar(200) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[menu] bit NULL,
[log_class] bit NULL,
[log_menu] nvarchar(20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[last_order_no] nvarchar(20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[adwidth] nvarchar(10) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[wrp_news] nvarchar(1) COLLATE Chinese_Taiwan_Stroke_CI_AS DEFAULT N'Y' NULL,
[wrp_bar] nvarchar(1) COLLATE Chinese_Taiwan_Stroke_CI_AS DEFAULT N'Y' NULL,
[smtp_url] nvarchar(50) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[smtp_port] nvarchar(10) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[smtp_ssl] nvarchar(1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[smtp_user] nvarchar(50) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[smtp_password] nvarchar(max) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[smtp_def] nvarchar(1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[use_sender] nvarchar(1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[bed_order_no] nvarchar(20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
)
GO
ALTER TABLE [dbo].[company] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'後台設定檔',
'SCHEMA', N'dbo',
'TABLE', N'company'
GO
-- ----------------------------
-- Records of company
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [dbo].[company] ON
GO
INSERT INTO [dbo].[company] ([num], [com_name], [com_mail], [bcc_mail], [pic_url], [menu], [log_class], [log_menu], [last_order_no], [adwidth], [wrp_news], [wrp_bar], [smtp_url], [smtp_port], [smtp_ssl], [smtp_user], [smtp_password], [smtp_def], [use_sender], [bed_order_no]) VALUES (N'1', N'道場管理', N'jsc.main001@gmail.com', N'', N'https://demo2.eztrust.tw/17168ERP', N'0', N'1', N'', N'AA2602240001', N'1000px', N'Y', N'Y', N'msa.hinet.net', N'25', N'N', N'17168erp', N'Zfo0mDh1+hKem67XYviQQA=', N'', N'N', N'ED2305120001')
GO
SET IDENTITY_INSERT [dbo].[company] OFF
GO
COMMIT
GO
-- ----------------------------
-- Table structure for country
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[country]') AND type IN ('U'))
DROP TABLE [dbo].[country]
GO
CREATE TABLE [dbo].[country] (
[ID] nvarchar(5) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[ID2] nvarchar(5) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[ID3] nvarchar(5) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[range] int NULL,
[name_en] nvarchar(100) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[name_zh] nvarchar(30) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
)
GO
ALTER TABLE [dbo].[country] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'國家列表',
'SCHEMA', N'dbo',
'TABLE', N'country'
GO
-- ----------------------------
-- Records of country
-- ----------------------------
BEGIN TRANSACTION
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'10', N'AQ', N'ATA', N'99', N'Antarctica', N'南極洲')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'100', N'BG', N'BGR', N'99', N'Bulgaria', N'保加利亞')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'104', N'MM', N'MMR', N'99', N'Myanmar', N'緬甸')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'108', N'BI', N'BDI', N'99', N'Burundi', N'蒲隆地')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'112', N'BY', N'BLR', N'99', N'Belarus', N'白俄羅斯')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'116', N'KH', N'KHM', N'99', N'Cambodia', N'柬埔寨')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'12', N'DZ', N'DZA', N'99', N'Algeria', N'阿爾及利亞')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'120', N'CM', N'CMR', N'99', N'Cameroon', N'喀麥隆')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'124', N'CA', N'CAN', N'3', N'Canada', N'加拿大')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'132', N'CV', N'CPV', N'99', N'Cabo Verde', N'維德角')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'136', N'KY', N'CYM', N'99', N'Cayman Islands', N'開曼群島')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'140', N'CF', N'CAF', N'99', N'Central African Republic', N'中非')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'144', N'LK', N'LKA', N'99', N'Sri Lanka', N'斯里蘭卡')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'148', N'TD', N'TCD', N'99', N'Chad', N'查德')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'152', N'CL', N'CHL', N'99', N'Chile', N'智利')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'156', N'CN', N'CHN', N'2', N'China', N'中國')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'158', N'TW', N'TWN', N'1', N'Republic of China(Taiwan)', N'中華民國(台灣)')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'16', N'AS', N'ASM', N'99', N'American Samoa', N'美屬薩摩亞')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'162', N'CX', N'CXR', N'99', N'Christmas Island', N'聖誕島')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'166', N'CC', N'CCK', N'99', N'Cocos (Keeling) Islands', N'科科斯（基林）群島')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'170', N'CO', N'COL', N'99', N'Colombia', N'哥倫比亞')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'174', N'KM', N'COM', N'99', N'Comoros', N'葛摩')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'175', N'YT', N'MYT', N'99', N'Mayotte', N'馬約特')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'178', N'CG', N'COG', N'99', N'Congo', N'剛果共和國')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'180', N'CD', N'COD', N'99', N'Congo (Democratic Republic of the)', N'剛果民主共和國')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'184', N'CK', N'COK', N'99', N'Cook Islands', N'庫克群島')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'188', N'CR', N'CRI', N'99', N'Costa Rica', N'哥斯大黎加')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'191', N'HR', N'HRV', N'99', N'Croatia', N'克羅埃西亞')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'192', N'CU', N'CUB', N'99', N'Cuba', N'古巴')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'196', N'CY', N'CYP', N'99', N'Cyprus', N'賽普勒斯')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'20', N'AD', N'AND', N'99', N'Andorra', N'安道爾')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'203', N'CZ', N'CZE', N'99', N'Czechia', N'捷克')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'204', N'BJ', N'BEN', N'99', N'Benin', N'貝南')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'208', N'DK', N'DNK', N'99', N'Denmark', N'丹麥')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'212', N'DM', N'DMA', N'99', N'Dominica', N'多米尼克')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'214', N'DO', N'DOM', N'99', N'Dominican Republic', N'多明尼加')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'218', N'EC', N'ECU', N'99', N'Ecuador', N'厄瓜多')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'222', N'SV', N'SLV', N'99', N'El Salvador', N'薩爾瓦多')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'226', N'GQ', N'GNQ', N'99', N'Equatorial Guinea', N'赤道幾內亞')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'231', N'ET', N'ETH', N'99', N'Ethiopia', N'衣索比亞')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'232', N'ER', N'ERI', N'99', N'Eritrea', N'厄利垂亞')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'233', N'EE', N'EST', N'99', N'Estonia', N'愛沙尼亞')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'234', N'FO', N'FRO', N'99', N'Faroe Islands', N'法羅群島')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'238', N'FK', N'FLK', N'99', N'Falkland Islands (Malvinas)', N'福克蘭群島')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'239', N'GS', N'SGS', N'99', N'South Georgia and the South Sandwich Islands', N'南喬治亞和南桑威奇群島')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'24', N'AO', N'AGO', N'99', N'Angola', N'安哥拉')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'242', N'FJ', N'FJI', N'99', N'Fiji', N'斐濟')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'246', N'FI', N'FIN', N'99', N'Finland', N'芬蘭')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'248', N'AX', N'ALA', N'99', N'Åland Islands', N'奧蘭')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'250', N'FR', N'FRA', N'99', N'France', N'法國')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'254', N'GF', N'GUF', N'99', N'French Guiana', N'法屬圭亞那')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'258', N'PF', N'PYF', N'99', N'French Polynesia', N'法屬玻里尼西亞')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'260', N'TF', N'ATF', N'99', N'French Southern Territories', N'法屬南部和南極領地')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'262', N'DJ', N'DJI', N'99', N'Djibouti', N'吉布地')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'266', N'GA', N'GAB', N'99', N'Gabon', N'加彭')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'268', N'GE', N'GEO', N'99', N'Georgia', N'喬治亞')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'270', N'GM', N'GMB', N'99', N'Gambia', N'甘比亞')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'275', N'PS', N'PSE', N'99', N'Palestine, State of', N'巴勒斯坦')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'276', N'DE', N'DEU', N'99', N'Germany', N'德國')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'28', N'AG', N'ATG', N'99', N'Antigua and Barbuda', N'安地卡及巴布達')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'288', N'GH', N'GHA', N'99', N'Ghana', N'迦納')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'292', N'GI', N'GIB', N'99', N'Gibraltar', N'直布羅陀')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'296', N'KI', N'KIR', N'99', N'Kiribati', N'吉里巴斯')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'300', N'GR', N'GRC', N'99', N'Greece', N'希臘')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'304', N'GL', N'GRL', N'99', N'Greenland', N'格陵蘭')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'308', N'GD', N'GRD', N'99', N'Grenada', N'格瑞那達')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'31', N'AZ', N'AZE', N'99', N'Azerbaijan', N'亞塞拜然')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'312', N'GP', N'GLP', N'99', N'Guadeloupe', N'瓜地洛普')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'316', N'GU', N'GUM', N'99', N'Guam', N'關島')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'32', N'AR', N'ARG', N'99', N'Argentina', N'阿根廷')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'320', N'GT', N'GTM', N'99', N'Guatemala', N'瓜地馬拉')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'324', N'GN', N'GIN', N'99', N'Guinea', N'幾內亞')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'328', N'GY', N'GUY', N'99', N'Guyana', N'蓋亞那')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'332', N'HT', N'HTI', N'99', N'Haiti', N'海地')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'334', N'HM', N'HMD', N'99', N'Heard Island and McDonald Islands', N'赫德島和麥克唐納群島')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'336', N'VA', N'VAT', N'99', N'Holy See', N'梵蒂岡')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'340', N'HN', N'HND', N'99', N'Honduras', N'宏都拉斯')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'344', N'HK', N'HKG', N'2', N'Hong Kong', N'香港')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'348', N'HU', N'HUN', N'99', N'Hungary', N'匈牙利')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'352', N'IS', N'ISL', N'99', N'Iceland', N'冰島')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'356', N'IN', N'IND', N'99', N'India', N'印度')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'36', N'AU', N'AUS', N'3', N'Australia', N'澳洲')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'360', N'ID', N'IDN', N'2', N'Indonesia', N'印度尼西亞')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'364', N'IR', N'IRN', N'99', N'Iran (Islamic Republic of)', N'伊朗')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'368', N'IQ', N'IRQ', N'99', N'Iraq', N'伊拉克')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'372', N'IE', N'IRL', N'99', N'Ireland', N'愛爾蘭')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'376', N'IL', N'ISR', N'99', N'Israel', N'以色列')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'380', N'IT', N'ITA', N'99', N'Italy', N'義大利')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'384', N'CI', N'CIV', N'99', N'Côte d''Ivoire', N'象牙海岸')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'388', N'JM', N'JAM', N'99', N'Jamaica', N'牙買加')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'392', N'JP', N'JPN', N'99', N'Japan', N'日本')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'398', N'KZ', N'KAZ', N'99', N'Kazakhstan', N'哈薩克')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'4', N'AF', N'AFG', N'99', N'Afghanistan', N'阿富汗')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'40', N'AT', N'AUT', N'99', N'Austria', N'奧地利')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'400', N'JO', N'JOR', N'99', N'Jordan', N'約旦')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'404', N'KE', N'KEN', N'99', N'Kenya', N'肯亞')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'408', N'KP', N'PRK', N'99', N'Korea (Democratic People''s Republic of)', N'北韓')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'410', N'KR', N'KOR', N'99', N'Korea (Republic of)', N'南韓')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'414', N'KW', N'KWT', N'99', N'Kuwait', N'科威特')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'417', N'KG', N'KGZ', N'99', N'Kyrgyzstan', N'吉爾吉斯')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'418', N'LA', N'LAO', N'99', N'Lao People''s Democratic Republic', N'寮國')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'422', N'LB', N'LBN', N'99', N'Lebanon', N'黎巴嫩')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'426', N'LS', N'LSO', N'99', N'Lesotho', N'賴索托')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'428', N'LV', N'LVA', N'99', N'Latvia', N'拉脫維亞')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'430', N'LR', N'LBR', N'99', N'Liberia', N'賴比瑞亞')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'434', N'LY', N'LBY', N'99', N'Libya', N'利比亞')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'438', N'LI', N'LIE', N'99', N'Liechtenstein', N'列支敦斯登')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'44', N'BS', N'BHS', N'99', N'Bahamas', N'巴哈馬')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'440', N'LT', N'LTU', N'99', N'Lithuania', N'立陶宛')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'442', N'LU', N'LUX', N'99', N'Luxembourg', N'盧森堡')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'446', N'MO', N'MAC', N'99', N'Macao', N'澳門')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'450', N'MG', N'MDG', N'99', N'Madagascar', N'馬達加斯加')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'454', N'MW', N'MWI', N'99', N'Malawi', N'馬拉威')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'458', N'MY', N'MYS', N'2', N'Malaysia', N'馬來西亞')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'462', N'MV', N'MDV', N'99', N'Maldives', N'馬爾地夫')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'466', N'ML', N'MLI', N'99', N'Mali', N'馬利')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'470', N'MT', N'MLT', N'99', N'Malta', N'馬爾他')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'474', N'MQ', N'MTQ', N'99', N'Martinique', N'馬丁尼克')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'478', N'MR', N'MRT', N'99', N'Mauritania', N'茅利塔尼亞')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'48', N'BH', N'BHR', N'99', N'Bahrain', N'巴林')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'480', N'MU', N'MUS', N'99', N'Mauritius', N'模里西斯')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'484', N'MX', N'MEX', N'99', N'Mexico', N'墨西哥')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'492', N'MC', N'MCO', N'99', N'Monaco', N'摩納哥')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'496', N'MN', N'MNG', N'99', N'Mongolia', N'蒙古')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'498', N'MD', N'MDA', N'99', N'Moldova (Republic of)', N'摩爾多瓦')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'499', N'ME', N'MNE', N'99', N'Montenegro', N'蒙特內哥羅')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'50', N'BD', N'BGD', N'99', N'Bangladesh', N'孟加拉')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'500', N'MS', N'MSR', N'99', N'Montserrat', N'蒙特塞拉特')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'504', N'MA', N'MAR', N'99', N'Morocco', N'摩洛哥')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'508', N'MZ', N'MOZ', N'99', N'Mozambique', N'莫三比克')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'51', N'AM', N'ARM', N'99', N'Armenia', N'亞美尼亞')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'512', N'OM', N'OMN', N'99', N'Oman', N'阿曼')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'516', N'NA', N'NAM', N'99', N'Namibia', N'納米比亞')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'52', N'BB', N'BRB', N'99', N'Barbados', N'巴貝多')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'520', N'NR', N'NRU', N'99', N'Nauru', N'諾魯')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'524', N'NP', N'NPL', N'99', N'Nepal', N'尼泊爾')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'528', N'NL', N'NLD', N'99', N'Netherlands', N'荷蘭')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'531', N'CW', N'CUW', N'99', N'Curacao !Curaçao', N'古拉索')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'533', N'AW', N'ABW', N'99', N'Aruba', N'阿魯巴')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'534', N'SX', N'SXM', N'99', N'Sint Maarten (Dutch part)', N'荷屬聖馬丁')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'535', N'BQ', N'BES', N'99', N'Bonaire, Sint Eustatius and Saba', N'荷蘭加勒比區')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'540', N'NC', N'NCL', N'99', N'New Caledonia', N'新喀里多尼亞')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'548', N'VU', N'VUT', N'99', N'Vanuatu', N'萬那杜')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'554', N'NZ', N'NZL', N'3', N'New Zealand', N'紐西蘭')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'558', N'NI', N'NIC', N'99', N'Nicaragua', N'尼加拉瓜')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'56', N'BE', N'BEL', N'99', N'Belgium', N'比利時')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'562', N'NE', N'NER', N'99', N'Niger', N'尼日')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'566', N'NG', N'NGA', N'99', N'Nigeria', N'奈及利亞')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'570', N'NU', N'NIU', N'99', N'Niue', N'紐埃')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'574', N'NF', N'NFK', N'99', N'Norfolk Island', N'諾福克島')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'578', N'NO', N'NOR', N'99', N'Norway', N'挪威')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'580', N'MP', N'MNP', N'99', N'Northern Mariana Islands', N'北馬利安納群島')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'581', N'UM', N'UMI', N'99', N'United States Minor Outlying Islands', N'美國本土外小島嶼')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'583', N'FM', N'FSM', N'99', N'Micronesia (Federated States of)', N'密克羅尼西亞聯邦')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'584', N'MH', N'MHL', N'99', N'Marshall Islands', N'馬紹爾群島')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'585', N'PW', N'PLW', N'99', N'Palau', N'帛琉')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'586', N'PK', N'PAK', N'99', N'Pakistan', N'巴基斯坦')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'591', N'PA', N'PAN', N'99', N'Panama', N'巴拿馬')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'598', N'PG', N'PNG', N'99', N'Papua New Guinea', N'巴布亞紐幾內亞')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'60', N'BM', N'BMU', N'99', N'Bermuda', N'百慕達')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'600', N'PY', N'PRY', N'99', N'Paraguay', N'巴拉圭')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'604', N'PE', N'PER', N'99', N'Peru', N'秘魯')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'608', N'PH', N'PHL', N'99', N'Philippines', N'菲律賓')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'612', N'PN', N'PCN', N'99', N'Pitcairn', N'皮特凱恩群島')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'616', N'PL', N'POL', N'99', N'Poland', N'波蘭')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'620', N'PT', N'PRT', N'99', N'Portugal', N'葡萄牙')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'624', N'GW', N'GNB', N'99', N'Guinea-Bissau', N'幾內亞比索')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'626', N'TL', N'TLS', N'99', N'Timor-Leste', N'東帝汶')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'630', N'PR', N'PRI', N'99', N'Puerto Rico', N'波多黎各')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'634', N'QA', N'QAT', N'99', N'Qatar', N'卡達')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'638', N'RE', N'REU', N'99', N'Réunion', N'留尼旺')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'64', N'BT', N'BTN', N'99', N'Bhutan', N'不丹')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'642', N'RO', N'ROU', N'99', N'Romania', N'羅馬尼亞')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'643', N'RU', N'RUS', N'99', N'Russian Federation', N'俄羅斯')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'646', N'RW', N'RWA', N'99', N'Rwanda', N'盧安達')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'652', N'BL', N'BLM', N'99', N'Saint Barthélemy', N'聖巴瑟米')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'654', N'SH', N'SHN', N'99', N'Saint Helena, Ascension and Tristan da Cunha', N'聖赫倫那、阿森松和特里斯坦-達庫尼亞')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'659', N'KN', N'KNA', N'99', N'Saint Kitts and Nevis', N'聖克里斯多福及尼維斯')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'660', N'AI', N'AIA', N'99', N'Anguilla', N'安圭拉')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'662', N'LC', N'LCA', N'99', N'Saint Lucia', N'聖露西亞')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'663', N'MF', N'MAF', N'99', N'Saint Martin (French part)', N'法屬聖馬丁')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'666', N'PM', N'SPM', N'99', N'Saint Pierre and Miquelon', N'聖皮埃與密克隆群島')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'670', N'VC', N'VCT', N'99', N'Saint Vincent and the Grenadines', N'聖文森及格瑞那丁')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'674', N'SM', N'SMR', N'99', N'San Marino', N'聖馬利諾')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'678', N'ST', N'STP', N'99', N'Sao Tome and Principe', N'聖多美普林西比')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'68', N'BO', N'BOL', N'99', N'Bolivia (Plurinational State of)', N'玻利維亞')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'682', N'SA', N'SAU', N'99', N'Saudi Arabia', N'沙烏地阿拉伯')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'686', N'SN', N'SEN', N'99', N'Senegal', N'塞內加爾')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'688', N'RS', N'SRB', N'99', N'Serbia', N'塞爾維亞')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'690', N'SC', N'SYC', N'99', N'Seychelles', N'塞席爾')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'694', N'SL', N'SLE', N'99', N'Sierra Leone', N'獅子山')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'70', N'BA', N'BIH', N'99', N'Bosnia and Herzegovina', N'波士尼亞與赫塞哥維納')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'702', N'SG', N'SGP', N'2', N'Singapore', N'新加坡')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'703', N'SK', N'SVK', N'99', N'Slovakia', N'斯洛伐克')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'704', N'VN', N'VNM', N'99', N'Viet Nam', N'越南')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'705', N'SI', N'SVN', N'99', N'Slovenia', N'斯洛維尼亞')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'706', N'SO', N'SOM', N'99', N'Somalia', N'索馬利亞')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'710', N'ZA', N'ZAF', N'99', N'South Africa', N'南非')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'716', N'ZW', N'ZWE', N'99', N'Zimbabwe', N'辛巴威')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'72', N'BW', N'BWA', N'99', N'Botswana', N'波札那')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'724', N'ES', N'ESP', N'99', N'Spain', N'西班牙')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'728', N'SS', N'SSD', N'99', N'South Sudan', N'南蘇丹')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'729', N'SD', N'SDN', N'99', N'Sudan', N'蘇丹')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'732', N'EH', N'ESH', N'99', N'Western Sahara', N'西撒哈拉')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'74', N'BV', N'BVT', N'99', N'Bouvet Island', N'布韋島')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'740', N'SR', N'SUR', N'99', N'Suriname', N'蘇利南')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'744', N'SJ', N'SJM', N'99', N'Svalbard and Jan Mayen', N'斯瓦爾巴和揚馬延')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'748', N'SZ', N'SWZ', N'99', N'Eswatini', N'史瓦帝尼')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'752', N'SE', N'SWE', N'99', N'Sweden', N'瑞典')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'756', N'CH', N'CHE', N'99', N'Switzerland', N'瑞士')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'76', N'BR', N'BRA', N'99', N'Brazil', N'巴西')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'760', N'SY', N'SYR', N'99', N'Syrian Arab Republic', N'敘利亞')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'762', N'TJ', N'TJK', N'99', N'Tajikistan', N'塔吉克')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'764', N'TH', N'THA', N'99', N'Thailand', N'泰國')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'768', N'TG', N'TGO', N'99', N'Togo', N'多哥')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'772', N'TK', N'TKL', N'99', N'Tokelau', N'托克勞')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'776', N'TO', N'TON', N'99', N'Tonga', N'東加')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'780', N'TT', N'TTO', N'99', N'Trinidad and Tobago', N'千里達及托巴哥')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'784', N'AE', N'ARE', N'99', N'United Arab Emirates', N'阿聯')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'788', N'TN', N'TUN', N'99', N'Tunisia', N'突尼西亞')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'792', N'TR', N'TUR', N'99', N'Türkiye', N'土耳其')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'795', N'TM', N'TKM', N'99', N'Turkmenistan', N'土庫曼')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'796', N'TC', N'TCA', N'99', N'Turks and Caicos Islands', N'特克斯與凱科斯群島')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'798', N'TV', N'TUV', N'99', N'Tuvalu', N'吐瓦魯')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'8', N'AL', N'ALB', N'99', N'Albania', N'阿爾巴尼亞')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'800', N'UG', N'UGA', N'99', N'Uganda', N'烏干達')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'804', N'UA', N'UKR', N'99', N'Ukraine', N'烏克蘭')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'807', N'MK', N'MKD', N'99', N'North Macedonia', N'北馬其頓')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'818', N'EG', N'EGY', N'99', N'Egypt', N'埃及')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'826', N'GB', N'GBR', N'99', N'United Kingdom of Great Britain and Northern Ireland', N'英國')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'831', N'GG', N'GGY', N'99', N'Guernsey', N'根西')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'832', N'JE', N'JEY', N'99', N'Jersey', N'澤西')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'833', N'IM', N'IMN', N'99', N'Isle of Man', N'曼島')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'834', N'TZ', N'TZA', N'99', N'Tanzania, United Republic of', N'坦尚尼亞')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'84', N'BZ', N'BLZ', N'99', N'Belize', N'貝里斯')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'840', N'US', N'USA', N'3', N'United States of America', N'美國')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'850', N'VI', N'VIR', N'99', N'Virgin Islands (U.S.)', N'美屬維京群島')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'854', N'BF', N'BFA', N'99', N'Burkina Faso', N'布吉納法索')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'858', N'UY', N'URY', N'99', N'Uruguay', N'烏拉圭')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'86', N'IO', N'IOT', N'99', N'British Indian Ocean Territory', N'英屬印度洋領地')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'860', N'UZ', N'UZB', N'99', N'Uzbekistan', N'烏茲別克')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'862', N'VE', N'VEN', N'99', N'Venezuela (Bolivarian Republic of)', N'委內瑞拉')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'876', N'WF', N'WLF', N'99', N'Wallis and Futuna', N'瓦利斯和富圖那')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'882', N'WS', N'WSM', N'99', N'Samoa', N'薩摩亞')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'887', N'YE', N'YEM', N'99', N'Yemen', N'葉門')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'894', N'ZM', N'ZMB', N'99', N'Zambia', N'尚比亞')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'90', N'SB', N'SLB', N'99', N'Solomon Islands', N'索羅門群島')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'92', N'VG', N'VGB', N'99', N'Virgin Islands (British)', N'英屬維京群島')
GO
INSERT INTO [dbo].[country] ([ID], [ID2], [ID3], [range], [name_en], [name_zh]) VALUES (N'96', N'BN', N'BRN', N'99', N'Brunei Darussalam', N'汶萊')
GO
COMMIT
GO
-- ----------------------------
-- Table structure for family_members
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[family_members]') AND type IN ('U'))
DROP TABLE [dbo].[family_members]
GO
CREATE TABLE [dbo].[family_members] (
[num] int IDENTITY(1,1) NOT NULL,
[follower_num] int NOT NULL,
[fam_name] nvarchar(255) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[fam_gender] nvarchar(10) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[fam_title] nvarchar(30) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[deceased] bit DEFAULT 0 NULL,
[birthdate] date NULL,
[lunar_birthday] nvarchar(30) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[age] nvarchar(10) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[zodiac] nvarchar(10) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[birth_time] nvarchar(10) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[city] nvarchar(255) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[area] nvarchar(255) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[address] nvarchar(255) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[phone] nvarchar(20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[mobile] nvarchar(20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
)
GO
ALTER TABLE [dbo].[family_members] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'家族成員資料',
'SCHEMA', N'dbo',
'TABLE', N'family_members'
GO
-- ----------------------------
-- Records of family_members
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [dbo].[family_members] ON
GO
INSERT INTO [dbo].[family_members] ([num], [follower_num], [fam_name], [fam_gender], [fam_title], [deceased], [birthdate], [lunar_birthday], [age], [zodiac], [birth_time], [city], [area], [address], [phone], [mobile]) VALUES (N'8', N'11', N'陳甲貳', N'', N'', N'0', NULL, N'', N'', N'', N'', N'', N'', N'', N'', N'')
GO
INSERT INTO [dbo].[family_members] ([num], [follower_num], [fam_name], [fam_gender], [fam_title], [deceased], [birthdate], [lunar_birthday], [age], [zodiac], [birth_time], [city], [area], [address], [phone], [mobile]) VALUES (N'9', N'11', N'陳甲叁', N'', N'', N'1', NULL, N'', N'', N'', N'', N'', N'', N'', N'', N'')
GO
SET IDENTITY_INSERT [dbo].[family_members] OFF
GO
COMMIT
GO
-- ----------------------------
-- Table structure for files
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[files]') AND type IN ('U'))
DROP TABLE [dbo].[files]
GO
CREATE TABLE [dbo].[files] (
[num] int IDENTITY(1,1) NOT NULL,
[subject] nvarchar(50) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[word] nvarchar(max) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[reg_time] datetime DEFAULT getdate() NULL,
[modify_time] datetime NULL,
[customize_data] nvarchar(max) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[paperset] nvarchar(15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
)
GO
ALTER TABLE [dbo].[files] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'套表列印設定',
'SCHEMA', N'dbo',
'TABLE', N'files'
GO
-- ----------------------------
-- Records of files
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [dbo].[files] ON
GO
INSERT INTO [dbo].[files] ([num], [subject], [word], [reg_time], [modify_time], [customize_data], [paperset]) VALUES (N'25', N'[標準L1A]大牌位-佛光注照-長生祿位-A3(直)', N'<div class="page border" data-body-class="tblt-l a3">
<div class="content">
<div class="bg"><img alt="Alternate Text" src="./tablet-2.svg" /></div>
<div class="text">
<div class="top_text_1">{$牌位主標題}</div>
<div class="top_text_2">{orderItem.print_id}</div>
<div class="top_text_3">個</div>
<div class="right_text text-block fit-text vertical text-start border">{$右標題}</div>
<div class="mid_text text-block fit-text vertical border" style="{$mid_text_style}">{orderItem.f_num_tablet}</div>
<div class="mid_text_2 text-block fit-text vertical border">{$祈福姓名2}</div>
<div class="left_text text-block fit-text vertical text-start border" style="{$left_text_style}">{orderItem.from_id_tablet}</div>
<div class="txt_up vertical">&nbsp;</div>
<div class="txt_down vertical">&nbsp;</div>
</div>
</div>
</div>
', N'2023-03-28 00:00:00.000', N'2024-12-13 23:50:33.097', N'$牌位主標題:
$牌位副標題:
$右標題:
$祈福姓名:
$祈福姓名2:
$陽上姓名:
$編號:', N'tblt-l a3')
GO
INSERT INTO [dbo].[files] ([num], [subject], [word], [reg_time], [modify_time], [customize_data], [paperset]) VALUES (N'26', N'[標準M1A]個人大牌-佛光注照-長生祿位-A4(直)', N'<div class="page border" data-body-class="tblt-m a4">
<div class="content">
<div class="bg"><img alt="Alternate Text" src="./tablet-2.svg" /></div>
<div class="text">
<div class="top_text_1">{$牌位主標題}</div>
<div class="top_text_2">{orderItem.print_id}</div>
<div class="top_text_3">個</div>
<div class="right_text text-block fit-text vertical text-start border">{$右標題}</div>
<div class="mid_text text-block fit-text vertical border" style="{$mid_text_style}">{orderItem.f_num_tablet}</div>
<div class="mid_text_2 text-block fit-text vertical border">{$祈福姓名2}</div>
<div class="left_text text-block fit-text vertical text-start border" style="{$left_text_style}">{orderItem.from_id_tablet}</div>
<div class="txt_up vertical">&nbsp;</div>
<div class="txt_down vertical">&nbsp;</div>
</div>
</div>
</div>
', N'2023-03-28 00:00:00.000', N'2024-12-13 23:50:30.630', N'$牌位主標題:
$牌位副標題:
$右標題:
$祈福姓名:
$祈福姓名2:
$陽上姓名:
$編號:', N'tblt-m a4')
GO
INSERT INTO [dbo].[files] ([num], [subject], [word], [reg_time], [modify_time], [customize_data], [paperset]) VALUES (N'27', N'[標準M2A]個人大牌-佛光注照-長生祿位-A4(直, 合併)', N'<div class="page border" data-body-class="tblt-m a4-mrg">
<div class="content">
<div class="bg"><img alt="Alternate Text" src="./tablet-2.svg" /></div>
<div class="text">
<div class="top_text_1">{$牌位主標題}</div>
<div class="top_text_2">{orderItem.print_id}</div>
<div class="top_text_3">個</div>
<div class="right_text text-block fit-text vertical text-start border">{$右標題}</div>
<div class="mid_text text-block fit-text vertical border" style="{$mid_text_style}">{orderItem.f_num_tablet}</div>
<div class="mid_text_2 text-block fit-text vertical border">{$祈福姓名2}</div>
<div class="left_text text-block fit-text vertical text-start border" style="{$left_text_style}">{orderItem.from_id_tablet}</div>
<div class="txt_up vertical">&nbsp;</div>
<div class="txt_down vertical">&nbsp;</div>
</div>
</div>
</div>
', N'2023-03-28 00:00:00.000', N'2024-12-13 23:50:28.437', N'$牌位主標題:
$牌位副標題:
$右標題:
$祈福姓名:
$祈福姓名2:
$陽上姓名:
$編號:', N'tblt-m a4-mrg')
GO
INSERT INTO [dbo].[files] ([num], [subject], [word], [reg_time], [modify_time], [customize_data], [paperset]) VALUES (N'28', N'[標準S1A]個人中牌-佛光注照-長生祿位-A5(直)', N'<div class="page border" data-body-class="tblt-s a5">
<div class="content">
<div class="bg"><img alt="Alternate Text" src="./tablet-2.svg" /></div>
<div class="text">
<div class="top_text_1">{$牌位主標題}</div>
<div class="top_text_2">{orderItem.print_id}</div>
<div class="top_text_3">個</div>
<div class="right_text text-block fit-text vertical text-start border">{$右標題}</div>
<div class="mid_text text-block fit-text vertical border" style="{$mid_text_style}">{orderItem.f_num_tablet}</div>
<div class="mid_text_2 text-block fit-text vertical border">{$祈福姓名2}</div>
<div class="left_text text-block fit-text vertical text-start border" style="{$left_text_style}">{orderItem.from_id_tablet}</div>
<div class="txt_up vertical">&nbsp;</div>
<div class="txt_down vertical">&nbsp;</div>
</div>
</div>
</div>
', N'2023-03-28 00:00:00.000', N'2024-12-13 23:50:25.553', N'$牌位主標題:
$牌位副標題:
$右標題:
$祈福姓名:
$祈福姓名2:
$陽上姓名:
$編號:', N'tblt-s a5')
GO
INSERT INTO [dbo].[files] ([num], [subject], [word], [reg_time], [modify_time], [customize_data], [paperset]) VALUES (N'29', N'[標準S2A]個人中牌-佛光注照-長生祿位-A4(橫, 合併)', N'<div class="page border" data-body-class="tblt-s a4l-mrg">
<div class="content">
<div class="bg"><img alt="Alternate Text" src="./tablet-2.svg" /></div>
<div class="text">
<div class="top_text_1">{$牌位主標題}</div>
<div class="top_text_2">{orderItem.print_id}</div>
<div class="top_text_3">個</div>
<div class="right_text text-block fit-text vertical text-start border">{$右標題}</div>
<div class="mid_text text-block fit-text vertical border" style="{$mid_text_style}">{orderItem.f_num_tablet}</div>
<div class="mid_text_2 text-block fit-text vertical border">{$祈福姓名2}</div>
<div class="left_text text-block fit-text vertical text-start border" style="{$left_text_style}">{orderItem.from_id_tablet}</div>
<div class="txt_up vertical">&nbsp;</div>
<div class="txt_down vertical">&nbsp;</div>
</div>
</div>
</div>
', N'2023-03-28 00:00:00.000', N'2024-12-13 23:50:23.603', N'$牌位主標題:
$牌位副標題:
$右標題:
$祈福姓名:
$祈福姓名2:
$陽上姓名:
$編號:', N'tblt-s a4l-mrg')
GO
INSERT INTO [dbo].[files] ([num], [subject], [word], [reg_time], [modify_time], [customize_data], [paperset]) VALUES (N'30', N'[標準S3A]個人中牌-佛光注照-長生祿位-A3(直, 合併)', N'<div class="page border" data-body-class="tblt-s a3-mrg">
<div class="content">
<div class="bg"><img alt="Alternate Text" src="./tablet-2.svg" /></div>
<div class="text">
<div class="top_text_1">{$牌位主標題}</div>
<div class="top_text_2">{orderItem.print_id}</div>
<div class="top_text_3">個</div>
<div class="right_text text-block fit-text vertical text-start border">{$右標題}</div>
<div class="mid_text text-block fit-text vertical border" style="{$mid_text_style}">{orderItem.f_num_tablet}</div>
<div class="mid_text_2 text-block fit-text vertical border">{$祈福姓名2}</div>
<div class="left_text text-block fit-text vertical text-start border" style="{$left_text_style}">{orderItem.from_id_tablet}</div>
<div class="txt_up vertical">&nbsp;</div>
<div class="txt_down vertical">&nbsp;</div>
</div>
</div>
</div>
', N'2023-03-28 00:00:00.000', N'2024-12-13 23:50:21.727', N'$牌位主標題:
$牌位副標題:
$右標題:
$祈福姓名:
$祈福姓名2:
$陽上姓名:
$編號:', N'tblt-s a3-mrg')
GO
INSERT INTO [dbo].[files] ([num], [subject], [word], [reg_time], [modify_time], [customize_data], [paperset]) VALUES (N'31', N'[標準X1A]隨喜牌位-佛光注照-長生祿位-A4(橫)', N'<div class="page border" data-body-class="tblt-xs a4l-mrg">
<div class="content">
<div class="bg"><img alt="Alternate Text" src="./tablet-2A.svg" /></div>
<div class="text">
<div class="top_text_1">{$牌位主標題}</div>
<div class="top_text_2">{orderItem.print_id}</div>
<div class="top_text_3">&nbsp;</div>
<div class="right_text text-block fit-text vertical text-start border">{$右標題}</div>
<div class="mid_text text-block fit-text vertical border" style="{$mid_text_style}">{orderItem.f_num_tablet}</div>
<div class="mid_text_2 text-block fit-text vertical border">{$祈福姓名2}</div>
<div class="left_text text-block fit-text vertical text-start border" style="{$left_text_style}">{orderItem.from_id_tablet}</div>
<div class="txt_up vertical">&nbsp;</div>
<div class="txt_down vertical">&nbsp;</div>
</div>
</div>
</div>
', N'2023-03-28 00:00:00.000', N'2024-12-13 23:50:20.130', N'$牌位主標題:
$牌位副標題:
$右標題:
$祈福姓名:
$祈福姓名2:
$陽上姓名:
$編號:', N'tblt-xs a4l-mrg')
GO
INSERT INTO [dbo].[files] ([num], [subject], [word], [reg_time], [modify_time], [customize_data], [paperset]) VALUES (N'32', N'[標準X2A]隨喜牌位-佛光注照-長生祿位-A3(直)', N'<div class="page border" data-body-class="tblt-xs a3-mrg">
<div class="content">
<div class="bg"><img alt="Alternate Text" src="./tablet-2A.svg" /></div>
<div class="text">
<div class="top_text_1">{$牌位主標題}</div>
<div class="top_text_2">{orderItem.print_id}</div>
<div class="top_text_3">個</div>
<div class="right_text text-block fit-text vertical text-start border">{$右標題}</div>
<div class="mid_text text-block fit-text vertical border" style="{$mid_text_style}">{orderItem.f_num_tablet}</div>
<div class="mid_text_2 text-block fit-text vertical border">{$祈福姓名2}</div>
<div class="left_text text-block fit-text vertical text-start border" style="{$left_text_style}">{orderItem.from_id_tablet}</div>
<div class="txt_up vertical">&nbsp;</div>
<div class="txt_down vertical">&nbsp;</div>
</div>
</div>
</div>
', N'2023-03-28 00:00:00.000', N'2024-12-13 23:50:17.937', N'$牌位主標題:
$牌位副標題:
$右標題:
$祈福姓名:
$祈福姓名2:
$陽上姓名:
$編號:', N'tblt-xs a3-mrg')
GO
INSERT INTO [dbo].[files] ([num], [subject], [word], [reg_time], [modify_time], [customize_data], [paperset]) VALUES (N'33', N'[標準L1B]大牌位-佛力超薦-往生蓮位-A3(直)', N'<div class="page border" data-body-class="tblt-l a3">
<div class="content">
<div class="bg"><img alt="Alternate Text" src="./tablet-1.svg" /></div>
<div class="text">
<div class="top_text_1">{$牌位主標題}</div>
<div class="top_text_2">{orderItem.print_id}</div>
<div class="top_text_3">個</div>
<div class="right_text text-block fit-text vertical text-start border">{$右標題}</div>
<div class="mid_text text-block fit-text vertical border" style="{$mid_text_style}">{orderItem.f_num_tablet}</div>
<div class="mid_text_2 text-block fit-text vertical border">{$祈福姓名2}</div>
<div class="left_text text-block fit-text vertical text-start border" style="{$left_text_style}">{orderItem.from_id_tablet}</div>
<div class="txt_up vertical">陽上</div>
<div class="txt_down vertical">拜薦</div>
</div>
</div>
</div>
', N'2023-03-28 00:00:00.000', N'2024-12-13 23:50:15.683', N'$牌位主標題:
$牌位副標題:
$右標題:
$祈福姓名:
$祈福姓名2:
$陽上姓名:
$編號:', N'tblt-l a3')
GO
INSERT INTO [dbo].[files] ([num], [subject], [word], [reg_time], [modify_time], [customize_data], [paperset]) VALUES (N'34', N'[標準M1B]個人大牌-佛力超薦-往生蓮位-A4(直)', N'<div class="page border" data-body-class="tblt-m a4">
<div class="content">
<div class="bg"><img alt="Alternate Text" src="./tablet-1.svg" /></div>
<div class="text">
<div class="top_text_1">{$牌位主標題}</div>
<div class="top_text_2">{orderItem.print_id}</div>
<div class="top_text_3">個</div>
<div class="right_text text-block fit-text vertical text-start border">{$右標題}</div>
<div class="mid_text text-block fit-text vertical border" style="{$mid_text_style}">{orderItem.f_num_tablet}</div>
<div class="mid_text_2 text-block fit-text vertical border">{$祈福姓名2}</div>
<div class="left_text text-block fit-text vertical text-start border" style="{$left_text_style}">{orderItem.from_id_tablet}</div>
<div class="txt_up vertical">陽上</div>
<div class="txt_down vertical">拜薦</div>
</div>
</div>
</div>
', N'2023-03-28 00:00:00.000', N'2024-12-13 23:50:13.433', N'$牌位主標題:
$牌位副標題:
$右標題:
$祈福姓名:
$祈福姓名2:
$陽上姓名:
$編號:', N'tblt-m a4')
GO
INSERT INTO [dbo].[files] ([num], [subject], [word], [reg_time], [modify_time], [customize_data], [paperset]) VALUES (N'35', N'[標準M2B]個人大牌-佛力超薦-往生蓮位-A4(直, 合併)', N'<div class="page border" data-body-class="tblt-m a4-mrg">
<div class="content">
<div class="bg"><img alt="Alternate Text" src="./tablet-1.svg" /></div>
<div class="text">
<div class="top_text_1">{$牌位主標題}</div>
<div class="top_text_2">{orderItem.print_id}</div>
<div class="top_text_3">個</div>
<div class="right_text text-block fit-text vertical text-start border">{$右標題}</div>
<div class="mid_text text-block fit-text vertical border" title="祈福姓名" style="{$mid_text_style}">{orderItem.f_num_tablet}</div>
<div class="mid_text_2 text-block fit-text vertical border" title="祈福姓名2">{$祈福姓名2}</div>
<div class="left_text text-block fit-text vertical text-start border" title="陽上姓名" style="{$left_text_style}">{orderItem.from_id_tablet}</div>
<div class="txt_up vertical">陽上</div>
<div class="txt_down vertical">拜薦</div>
</div>
</div>
</div>
', N'2023-03-28 00:00:00.000', N'2024-12-13 23:50:11.073', N'$牌位主標題:
$牌位副標題:
$右標題:
$祈福姓名:
$祈福姓名2:
$陽上姓名:
$編號:', N'tblt-m a4-mrg')
GO
INSERT INTO [dbo].[files] ([num], [subject], [word], [reg_time], [modify_time], [customize_data], [paperset]) VALUES (N'36', N'[標準S1B]個人中牌-佛力超薦-往生蓮位-A5(直)', N'<div class="page border" data-body-class="tblt-s a5">
<div class="content">
<div class="bg"><img alt="Alternate Text" src="./tablet-1.svg" /></div>
<div class="text">
<div class="top_text_1">{$牌位主標題}</div>
<div class="top_text_2">{orderItem.print_id}</div>
<div class="top_text_3">個</div>
<div class="right_text text-block fit-text vertical text-start border">{$右標題}</div>
<div class="mid_text text-block fit-text vertical border" style="{$mid_text_style}">{orderItem.f_num_tablet}</div>
<div class="mid_text_2 text-block fit-text vertical border">{$祈福姓名2}</div>
<div class="left_text text-block fit-text vertical text-start border" style="{$left_text_style}">{orderItem.from_id_tablet}</div>
<div class="txt_up vertical">陽上</div>
<div class="txt_down vertical">拜薦</div>
</div>
</div>
</div>
', N'2023-03-28 00:00:00.000', N'2024-12-13 23:50:08.320', N'$牌位主標題:
$牌位副標題:
$右標題:
$祈福姓名:
$祈福姓名2:
$陽上姓名:
$編號:', N'tblt-s a5')
GO
INSERT INTO [dbo].[files] ([num], [subject], [word], [reg_time], [modify_time], [customize_data], [paperset]) VALUES (N'37', N'[標準S2B]個人中牌-佛力超薦-往生蓮位-A4(橫, 合併)', N'<div class="page border" data-body-class="tblt-s a4l-mrg">
<div class="content">
<div class="bg"><img alt="Alternate Text" src="./tablet-1.svg" /></div>
<div class="text">
<div class="top_text_1">{$牌位主標題}</div>
<div class="top_text_2">{orderItem.print_id}</div>
<div class="top_text_3">個</div>
<div class="right_text text-block fit-text vertical text-start border">{$右標題}</div>
<div class="mid_text text-block fit-text vertical border" style="{$mid_text_style}">{orderItem.f_num_tablet}</div>
<div class="mid_text_2 text-block fit-text vertical border">{$祈福姓名2}</div>
<div class="left_text text-block fit-text vertical text-start border" style="{$left_text_style}">{orderItem.from_id_tablet}</div>
<div class="txt_up vertical">陽上</div>
<div class="txt_down vertical">拜薦</div>
</div>
</div>
</div>
', N'2023-03-28 00:00:00.000', N'2024-12-13 23:50:06.263', N'$牌位主標題:
$牌位副標題:
$右標題:
$祈福姓名:
$祈福姓名2:
$陽上姓名:
$編號:', N'tblt-s a4l-mrg')
GO
INSERT INTO [dbo].[files] ([num], [subject], [word], [reg_time], [modify_time], [customize_data], [paperset]) VALUES (N'38', N'[標準S3B]個人中牌-佛力超薦-往生蓮位-A3(直, 合併)', N'<div class="page border" data-body-class="tblt-s a3-mrg">
<div class="content">
<div class="bg"><img alt="Alternate Text" src="./tablet-1.svg" /></div>
<div class="text">
<div class="top_text_1">{$牌位主標題}</div>
<div class="top_text_2">{orderItem.print_id}</div>
<div class="top_text_3">個</div>
<div class="right_text text-block fit-text vertical text-start border">{$右標題}</div>
<div class="mid_text text-block fit-text vertical border" style="{$mid_text_style}">{orderItem.f_num_tablet}</div>
<div class="mid_text_2 text-block fit-text vertical border">{$祈福姓名2}</div>
<div class="left_text text-block fit-text vertical text-start border" style="{$left_text_style}">{orderItem.from_id_tablet}</div>
<div class="txt_up vertical">陽上</div>
<div class="txt_down vertical">拜薦</div>
</div>
</div>
</div>
', N'2023-03-28 00:00:00.000', N'2024-12-13 23:50:04.340', N'$牌位主標題:
$牌位副標題:
$右標題:
$祈福姓名:
$祈福姓名2:
$陽上姓名:
$編號:', N'tblt-s a3-mrg')
GO
INSERT INTO [dbo].[files] ([num], [subject], [word], [reg_time], [modify_time], [customize_data], [paperset]) VALUES (N'39', N'[標準X1B]隨喜牌位-佛力超薦-往生蓮位-A4(橫)', N'<div class="page border" data-body-class="tblt-xs a4l-mrg">
<div class="content">
<div class="bg"><img alt="Alternate Text" src="./tablet-1A.svg" /></div>
<div class="text">
<div class="top_text_1">{$牌位主標題}</div>
<div class="top_text_2">{orderItem.print_id}</div>
<div class="top_text_3">&nbsp;</div>
<div class="right_text text-block fit-text vertical text-start border">{$右標題}</div>
<div class="mid_text text-block fit-text vertical border" style="{$mid_text_style}">{orderItem.f_num_tablet}</div>
<div class="mid_text_2 text-block fit-text vertical border">{$祈福姓名2}</div>
<div class="left_text text-block fit-text vertical text-start border" style="{$left_text_style}">{orderItem.from_id_tablet}</div>
<div class="txt_up vertical">陽上</div>
<div class="txt_down vertical">拜薦</div>
</div>
</div>
</div>
', N'2023-03-28 00:00:00.000', N'2024-12-13 23:50:02.170', N'$牌位主標題:
$牌位副標題:
$右標題:
$祈福姓名:
$祈福姓名2:
$陽上姓名:
$編號:', N'tblt-xs a4l-mrg')
GO
INSERT INTO [dbo].[files] ([num], [subject], [word], [reg_time], [modify_time], [customize_data], [paperset]) VALUES (N'40', N'[標準X2B]隨喜牌位-佛力超薦-往生蓮位-A3(直)', N'<div class="page border" data-body-class="tblt-xs a3-mrg">
<div class="content">
<div class="bg"><img alt="Alternate Text" src="./tablet-1A.svg" /></div>
<div class="text">
<div class="top_text_1">{$牌位主標題}</div>
<div class="top_text_2">{orderItem.print_id}</div>
<div class="top_text_3">個</div>
<div class="right_text text-block fit-text vertical text-start border">{$右標題}</div>
<div class="mid_text text-block fit-text vertical border" style="{$mid_text_style}">{orderItem.f_num_tablet}</div>
<div class="mid_text_2 text-block fit-text vertical border">{$祈福姓名2}</div>
<div class="left_text text-block fit-text vertical text-start border" style="{$left_text_style}">{orderItem.from_id_tablet}</div>
<div class="txt_up vertical">陽上</div>
<div class="txt_down vertical">拜薦</div>
</div>
</div>
</div>
', N'2023-03-28 00:00:00.000', N'2024-12-13 23:49:59.323', N'$牌位主標題:
$牌位副標題:
$右標題:
$祈福姓名:
$祈福姓名2:
$陽上姓名:
$編號:', N'tblt-xs a3-mrg')
GO
INSERT INTO [dbo].[files] ([num], [subject], [word], [reg_time], [modify_time], [customize_data], [paperset]) VALUES (N'44', N'[標準M3A]個人大牌-佛光注照-長生祿位-A3(横, 合併)', N'<div class="page border" data-body-class="tblt-m a3-mrg">
<div class="content">
<div class="bg"><img alt="Alternate Text" src="./tablet-2.svg" /></div>
<div class="text">
<div class="top_text_1">{$牌位主標題}</div>
<div class="top_text_2">{orderItem.print_id}</div>
<div class="top_text_3">個</div>
<div class="right_text text-block fit-text vertical text-start border">{$右標題}</div>
<div class="mid_text text-block fit-text vertical border" style="{$mid_text_style}">{orderItem.f_num_tablet}</div>
<div class="mid_text_2 text-block fit-text vertical border">{$祈福姓名2}</div>
<div class="left_text text-block fit-text vertical text-start border" style="{$left_text_style}">{orderItem.from_id_tablet}</div>
<div class="txt_up vertical">&nbsp;</div>
<div class="txt_down vertical">&nbsp;</div>
</div>
</div>
</div>
', N'2023-04-26 00:00:00.000', N'2024-12-13 23:49:12.333', N'$牌位主標題:
$牌位副標題:
$右標題:
$祈福姓名:
$祈福姓名2:
$陽上姓名:
$編號:', N'tblt-m a3-mrg')
GO
INSERT INTO [dbo].[files] ([num], [subject], [word], [reg_time], [modify_time], [customize_data], [paperset]) VALUES (N'45', N'[標準M3B]個人大牌-佛力超薦-往生蓮位-A3(横, 合併)', N'<div class="page border" data-body-class="tblt-m a3-mrg">
<div class="content">
<div class="bg"><img alt="Alternate Text" src="./tablet-1.svg" /></div>
<div class="text">
<div class="top_text_1">{$牌位主標題}</div>
<div class="top_text_2">{orderItem.print_id}</div>
<div class="top_text_3">&nbsp;</div>
<div class="right_text text-block fit-text vertical text-start border">{$右標題}</div>
<div class="mid_text text-block fit-text vertical border" style="{$mid_text_style}">{orderItem.f_num_tablet}</div>
<div class="mid_text_2 text-block fit-text vertical border">{$祈福姓名2}</div>
<div class="left_text text-block fit-text vertical text-start border"style="{$left_text_style}">{orderItem.from_id_tablet}</div>
<div class="txt_up vertical">陽上</div>
<div class="txt_down vertical">拜薦</div>
</div>
</div>
</div>
', N'2023-04-26 00:00:00.000', N'2024-12-13 23:17:11.763', N'$牌位主標題:
$牌位副標題:
$右標題:
$祈福姓名:
$祈福姓名2:
$陽上姓名:
$編號:', N'tblt-l a3-mrg')
GO
INSERT INTO [dbo].[files] ([num], [subject], [word], [reg_time], [modify_time], [customize_data], [paperset]) VALUES (N'207', N'[標準L2A]大牌位-佛光注照-長生祿位-特-A3(直)', N'<div class="page border" data-body-class="tblt-l a3">
<div class="content">
<div class="bg"><img alt="Alternate Text" src="./tablet-2.svg" /></div>
<div class="text">
<div class="top_text_1">{$牌位主標題}</div>
<div class="top_text_2">{orderItem.print_id}</div>
<div class="top_text_3">個</div>
<div class="right_text text-block fit-text vertical text-start border">{$右標題}</div>
<div class="mid_text text-block fit-text vertical border" style="{$mid_text_style}">{orderItem.f_num_tablet}</div>
<div class="mid_text_2 text-block fit-text vertical border">{$祈福姓名2}</div>
<div class="left_text text-block fit-text vertical text-start border" style="{$left_text_style}">{orderItem.from_id_tablet}</div>
<div class="txt_up vertical">&nbsp;</div>
<div class="txt_down vertical">&nbsp;</div>
</div>
</div>
</div>
', N'2024-11-29 00:00:00.000', N'2024-12-13 23:49:07.337', N'$牌位主標題:
$牌位副標題:
$右標題:
$祈福姓名:
$祈福姓名2:合家
$陽上姓名:
$編號:', N'tblt-l a3 l2a')
GO
INSERT INTO [dbo].[files] ([num], [subject], [word], [reg_time], [modify_time], [customize_data], [paperset]) VALUES (N'210', N'[標準L2B]大牌位-佛力超薦-往生蓮位-特-A3(直)', N'<div class="page border" data-body-class="tblt-l a3">
<div class="content">
<div class="bg"><img alt="Alternate Text" src="./tablet-1.svg" /></div>
<div class="text">
<div class="top_text_1">{$牌位主標題}</div>
<div class="top_text_2">{orderItem.print_id}</div>
<div class="top_text_3">個</div>
<div class="right_text text-block fit-text vertical text-start border">{$右標題}</div>
<div class="mid_text text-block fit-text vertical border" style="{$mid_text_style}">{orderItem.f_num_tablet}</div>
<div class="mid_text_2 text-block fit-text vertical border">{$祈福姓名2}</div>
<div class="mid_text_3 text-block fit-text vertical border">亡者 {$祈福姓名3}</div>
<div class="mid_text_4 text-block fit-text vertical border">亡者 {$祈福姓名4}</div>
<div class="left_text text-block fit-text vertical text-start border" style="{$left_text_style}">{orderItem.from_id_tablet}</div>
<div class="txt_up vertical">陽上</div>
<div class="txt_down vertical">拜薦</div>
</div>
</div>
</div>
', N'2024-11-29 00:00:00.000', N'2026-02-04 17:07:53.873', N'$牌位主標題:
$牌位副標題:
$右標題:
$祈福姓名:
$祈福姓名2:氏門中歷代宗親暨眾冤親債主
$祈福姓名3:
$祈福姓名4:
$陽上姓名:
$編號:', N'tblt-l a3 l2b')
GO
INSERT INTO [dbo].[files] ([num], [subject], [word], [reg_time], [modify_time], [customize_data], [paperset]) VALUES (N'211', N'[標準L2B]大牌位-佛力超薦-往生蓮位-特-A3(測)', N'<div class="page border" data-body-class="tblt-l a3">
<div class="content">
<div class="bg"><img alt="Alternate Text" src="./tablet-1.svg" /></div>
<div class="text">
<div class="top_text_2">{orderItem.print_id}</div>
<div class="mid_text text-block fit-text vertical border" style="{$mid_text_style}">{orderItem.f_num_tablet}</div>
<div class="left_text text-block fit-text vertical text-start border" style="{$left_text_style}">{orderItem.from_id_tablet}</div>
<div class="txt_up vertical">陽上</div>
<div class="txt_down vertical">拜薦</div>
</div>
</div>
</div>
', N'2026-02-04 00:00:00.000', N'2026-02-04 17:17:34.380', N'', N'tblt-l a3 l2b')
GO
SET IDENTITY_INSERT [dbo].[files] OFF
GO
COMMIT
GO
-- ----------------------------
-- Table structure for followers
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[followers]') AND type IN ('U'))
DROP TABLE [dbo].[followers]
GO
CREATE TABLE [dbo].[followers] (
[num] int IDENTITY(1,1) NOT NULL,
[f_number] nvarchar(20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[u_name] nvarchar(20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[sex] nvarchar(2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[identity_type] int NULL,
[birthday] datetime NULL,
[phone] nvarchar(max) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[email] nvarchar(200) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[refugedate] datetime NULL,
[refuge_name] nvarchar(20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[address] nvarchar(200) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[demo] nvarchar(max) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[leader] int NULL,
[socialid1] nvarchar(50) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[socialid2] nvarchar(50) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[tab] nvarchar(max) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[contactor] nvarchar(20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[contactor_phone] nvarchar(max) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[blood] nvarchar(2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[customize_data] nvarchar(max) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[introducer] nvarchar(20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[refuge_area] nvarchar(25) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[id_code] nvarchar(max) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[passport] nvarchar(max) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[cellphone] nvarchar(max) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[reg_time] datetime DEFAULT getdate() NULL,
[admin_log] nvarchar(50) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[join_date] datetime NULL,
[country] nvarchar(5) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[appellation_id] int NULL,
[follower_hash] nvarchar(100) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[search_keywords] varchar(max) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
)
GO
ALTER TABLE [dbo].[followers] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'信眾資料',
'SCHEMA', N'dbo',
'TABLE', N'followers'
GO
-- ----------------------------
-- Records of followers
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [dbo].[followers] ON
GO
INSERT INTO [dbo].[followers] ([num], [f_number], [u_name], [sex], [identity_type], [birthday], [phone], [email], [refugedate], [refuge_name], [address], [demo], [leader], [socialid1], [socialid2], [tab], [contactor], [contactor_phone], [blood], [customize_data], [introducer], [refuge_area], [id_code], [passport], [cellphone], [reg_time], [admin_log], [join_date], [country], [appellation_id], [follower_hash], [search_keywords]) VALUES (N'11', N'M2026022400001', N'陳甲壹', N'男眾', N'10', NULL, NULL, NULL, NULL, NULL, N'台中市潭子區中山路二段135號', NULL, NULL, NULL, NULL, N'', NULL, NULL, N'', NULL, NULL, NULL, NULL, NULL, N'ovR7d9MNoWFsE2AdUUhm4wwbKsjnBgwWd==', N'2026-02-24 15:26:34.147', NULL, NULL, N'158', NULL, NULL, N'7c303930302d3030302d3030317c7c')
GO
SET IDENTITY_INSERT [dbo].[followers] OFF
GO
COMMIT
GO
-- ----------------------------
-- Table structure for followers_tablet
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[followers_tablet]') AND type IN ('U'))
DROP TABLE [dbo].[followers_tablet]
GO
CREATE TABLE [dbo].[followers_tablet] (
[num] int IDENTITY(1,1) NOT NULL,
[f_num] int NULL,
[type] nvarchar(100) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[title] nvarchar(max) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
)
GO
ALTER TABLE [dbo].[followers_tablet] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'信眾牌位資料',
'SCHEMA', N'dbo',
'TABLE', N'followers_tablet'
GO
-- ----------------------------
-- Records of followers_tablet
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [dbo].[followers_tablet] ON
GO
SET IDENTITY_INSERT [dbo].[followers_tablet] OFF
GO
COMMIT
GO
-- ----------------------------
-- Table structure for GuaDanOrder
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[GuaDanOrder]') AND type IN ('U'))
DROP TABLE [dbo].[GuaDanOrder]
GO
CREATE TABLE [dbo].[GuaDanOrder] (
[StartDate] date NULL,
[EndDate] date NULL,
[CreateUser] int NULL,
[CreatedAt] datetime2(7) NULL,
[UpdatedAt] datetime2(7) NULL,
[Notes] nvarchar(100) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[GuaDanOrderNo] nvarchar(20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[BookerFollowerNum] int NULL,
[BookerName] nvarchar(20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[BookerPhone] nvarchar(12) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[IsDeleted] bit DEFAULT 0 NOT NULL,
[Uuid] uniqueidentifier NOT NULL,
[ActivityNum] int NULL,
[IsCancel] bit DEFAULT 0 NOT NULL
)
GO
ALTER TABLE [dbo].[GuaDanOrder] SET (LOCK_ESCALATION = TABLE)
GO
-- ----------------------------
-- Records of GuaDanOrder
-- ----------------------------
BEGIN TRANSACTION
GO
COMMIT
GO
-- ----------------------------
-- Table structure for GuaDanOrderGuest
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[GuaDanOrderGuest]') AND type IN ('U'))
DROP TABLE [dbo].[GuaDanOrderGuest]
GO
CREATE TABLE [dbo].[GuaDanOrderGuest] (
[GuaDanOrderNo] nvarchar(20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[FollowerNum] int NULL,
[IsDeleted] bit DEFAULT 0 NOT NULL,
[Uuid] uniqueidentifier DEFAULT newid() NOT NULL,
[RoomUuid] uniqueidentifier NULL,
[BedUuid] uniqueidentifier NULL,
[CheckInAt] date NULL,
[CheckOutAt] date NULL,
[StatusCode] nvarchar(20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[OrderUuid] uniqueidentifier NULL
)
GO
ALTER TABLE [dbo].[GuaDanOrderGuest] SET (LOCK_ESCALATION = TABLE)
GO
-- ----------------------------
-- Records of GuaDanOrderGuest
-- ----------------------------
BEGIN TRANSACTION
GO
COMMIT
GO
-- ----------------------------
-- Table structure for GuadanTimeSetting
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[GuadanTimeSetting]') AND type IN ('U'))
DROP TABLE [dbo].[GuadanTimeSetting]
GO
CREATE TABLE [dbo].[GuadanTimeSetting] (
[Id] uniqueidentifier NOT NULL,
[EarliestCheckIn] nvarchar(5) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[LatestCheckOut] nvarchar(5) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[IsActive] bit DEFAULT 1 NOT NULL,
[CreatedAt] datetime NULL,
[UpdatedAt] datetime NULL
)
GO
ALTER TABLE [dbo].[GuadanTimeSetting] SET (LOCK_ESCALATION = TABLE)
GO
-- ----------------------------
-- Records of GuadanTimeSetting
-- ----------------------------
BEGIN TRANSACTION
GO
COMMIT
GO
-- ----------------------------
-- Table structure for item
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[item]') AND type IN ('U'))
DROP TABLE [dbo].[item]
GO
CREATE TABLE [dbo].[item] (
[num] int IDENTITY(1,1) NOT NULL,
[title] nvarchar(50) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[url] nvarchar(100) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[target] nvarchar(2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[price] nvarchar(10) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[demo] nvarchar(255) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[other] nvarchar(255) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[root] int DEFAULT 0 NULL,
[range] int NULL,
[other_url] nvarchar(255) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[s_id] nvarchar(10) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
)
GO
ALTER TABLE [dbo].[item] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'選項設定檔',
'SCHEMA', N'dbo',
'TABLE', N'item'
GO
-- ----------------------------
-- Records of item
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [dbo].[item] ON
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'1', N'權限', NULL, N'A', NULL, N'權限管理', NULL, N'0', N'10', NULL, NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'2', N'使用者登錄', N'~/admin/user/reg.aspx', N'A', N'', N'管理者資料新增', N'', N'1', N'2', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'3', N'使用者管理', N'~/admin/user/index.aspx', N'A', N'', N'管理者資料查詢、修改、刪除', N'', N'1', N'3', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'4', N'選項', NULL, N'A', NULL, N'選項管理', NULL, N'0', N'8', NULL, NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'5', N'選項登錄', N'~/admin/item/index.aspx', N'A', NULL, N'選項資料新增', NULL, N'4', N'5', NULL, NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'7', N'選項排序', N'~/admin/item/range.aspx', N'A', NULL, N'設定主選項及次選項的排序', NULL, N'4', N'36', NULL, NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'8', N'群組登錄', N'~/admin/user/group_reg.aspx', N'A', NULL, N'登錄群組及權限設定', NULL, N'1', N'5', NULL, NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'9', N'群組資料', N'~/admin/user/group_show.aspx', N'A', N'', N'群組資料管理', N'', N'1', N'4', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'10', N'後台設定', N'~/admin/item/setting.aspx', N'A', NULL, N'設定編輯器圖片路徑、公司信箱、公司名稱…相關設定', NULL, N'4', N'37', NULL, NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'11', N'變更管理密碼', N'~/admin/user/pass_edit.aspx', N'A', NULL, N'變更登錄後端之密碼', NULL, N'1', N'74', NULL, NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'12', N'操作記錄查詢', N'~/admin/user/log.aspx', N'A', N'', N'', N'', N'1', N'123', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'20', N'公告', N'', N'A', N'', N'', N'', N'0', N'13', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'21', N'公告管理', N'~/admin/news/index.aspx', N'A', N'', N'', N'', N'20', N'126', N'~/admin/news/news_reg.aspx', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'22', N'公告分類管理', N'~/admin/news/kind_reg.aspx', N'A', N'', N'', N'', N'20', N'125', N'~/admin/news/range.aspx,~/admin/news/range2.aspx', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'23', N'人事', N'', N'A', N'', N'', N'', N'0', N'11', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'24', N'人員組別管理', N'~/admin/hr/kind_reg.aspx', N'A', N'', N'', N'', N'23', N'129', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'25', N'職稱管理', N'~/admin/hr/title_reg.aspx', N'A', N'', N'', N'', N'23', N'130', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'26', N'人員管理', N'~/admin/hr/index.aspx', N'A', N'', N'', N'', N'23', N'131', N'~/admin/hr/reg.aspx', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'27', N'考勤', N'~/admin/hr/index2.aspx', N'A', N'', N'', N'', N'23', N'132', N'~/admin/hr/attendances.aspx', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'28', N'信眾', N'', N'A', N'', N'', N'', N'0', N'2', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'29', N'信眾資料', N'~/admin/follower/index.aspx', N'A', N'', N'', N'', N'28', N'134', N'~/admin/follower/reg.aspx', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'30', N'公告檢視', N'~/admin/news/list.aspx', N'A', N'', N'', N'', N'20', N'134', N'~/admin/news/reg.aspx', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'31', N'活動', N'', N'A', N'', N'', N'', N'0', N'3', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'34', N'活動詳細分類', N'~/admin/activity/kind_reg.aspx', N'A', N'', N'', N'', N'31', N'139', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'35', N'活動管理', N'~/admin/activity/index.aspx', N'A', N'', N'', N'', N'31', N'140', N'~/admin/activity/reg.aspx', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'36', N'基本資料', N'', N'A', N'', N'', N'', N'0', N'1', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'37', N'套表列印設定', N'~/admin/files/index.aspx', N'A', N'', N'', N'', N'36', N'141', N'~/admin/files/reg.aspx', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'38', N'報名', N'~/admin/order/index.aspx', N'A', N'', N'', N'', N'0', N'4', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'39', N'報名管理', N'~/admin/order/index.aspx', N'A', N'', N'', N'', N'38', N'143', N'~/admin/order/reg.aspx,~/admin/order/bed_reg.aspx', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'40', N'庫存', N'', N'A', N'', N'', N'', N'0', N'12', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'41', N'倉庫資料維護', N'~/admin/stock/kind_reg.aspx', N'A', N'', N'', N'', N'40', N'145', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'42', N'庫存管理', N'~/admin/stock/index.aspx', N'A', N'', N'', N'', N'40', N'147', N'~/admin/stock/news_reg.aspx', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'43', N'帳務', N'', N'A', N'', N'', N'', N'0', N'14', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'44', N'收支項目維護', N'~/admin/accounting/kind_reg.aspx', N'A', N'', N'', N'', N'43', N'148', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'45', N'收支帳戶維護', N'~/admin/accounting/kind_reg2.aspx', N'A', N'', N'', N'', N'43', N'149', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'46', N'專案', N'', N'A', N'', N'', N'', N'0', N'9', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'47', N'類別管理', N'~/admin/project/kind_reg.aspx', N'A', N'', N'', N'', N'46', N'151', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'48', N'收支管理', N'~/admin/accounting/index.aspx', N'A', N'', N'', N'', N'43', N'152', N'~/admin/accounting/news_reg.aspx', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'49', N'專案管理', N'~/admin/project/index.aspx', N'A', N'', N'', N'', N'46', N'153', N'~/admin/project/news_reg.aspx,~/admin/project/update.aspx,~/admin/project/reg.aspx', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'50', N'贊助報告', N'~/admin/project/list.aspx', N'A', N'', N'', N'', N'46', N'154', N'~/admin/project/news_reg.aspx', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'51', N'品項分類管理', N'~/admin/activity/itemKind.aspx', N'A', N'', N'', N'', N'36', N'142', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'52', N'品項管理', N'~/admin/activity/index2.aspx', N'A', N'', N'', N'', N'36', N'143', N'~/admin/activity/item_reg.aspx', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'53', N'人員匯入', N'~/admin/hr/import.aspx', N'A', N'', N'', N'', N'23', N'128', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'54', N'信眾匯入', N'~/admin/follower/import.aspx', N'A', N'', N'', N'', N'28', N'133', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'55', N'掛單', N'', N'A', N'', N'', N'', N'0', N'7', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'56', N'房間管理', N'~/admin/bed/kind_reg.aspx', N'A', N'', N'', N'', N'55', N'160', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'57', N'報到名單​', N'~/admin/order/index2.aspx', N'A', N'', N'', N'', N'38', N'161', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'58', N'活動主類型', N'~/admin/activity/kind_reg2.aspx', N'A', N'', N'', N'', N'31', N'138', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'59', N'供應商', N'', N'A', N'', N'', N'', N'0', N'15', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'60', N'供應商分類管理', N'~/admin/supplier/kind_reg.aspx', N'A', N'', N'', N'', N'59', N'164', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'61', N'供應商管理', N'~/admin/supplier/index.aspx', N'A', N'', N'', N'', N'59', N'163', N'~/admin/supplier/reg.aspx', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'62', N'庫存異動原因', N'~/admin/stock/reason_reg.aspx', N'A', N'', N'', N'', N'40', N'146', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'63', N'牌位查詢列印', N'~/admin/printpw/yulan.aspx', N'A', N'', N'各活動的牌位查詢列印', N'', N'31', N'160', N'~/admin/printpw/index.aspx', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'64', N'疏文查詢', N'~/admin/shuwen/shuwen.aspx', N'A', N'', N'', N'', N'38', N'165', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'65', N'入帳沖帳', N'', N'A', N'', N'', N'', N'0', N'5', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'66', N'登錄匯款資料', N'~/admin/transfer/register.aspx', N'B', N'', N'', N'', N'65', N'167', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'67', N'出納:核對匯款人', N'~/admin/transfer/verify1.aspx', N'A', N'', N'', N'', N'65', N'168', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'68', N'出納:核對金額', N'~/admin/transfer/verify2.aspx', N'A', N'', N'', N'', N'65', N'169', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'69', N'個人-沖帳流程', N'~/admin/transfer/personal_reconcile.aspx', N'A', N'', N'', N'', N'65', N'170', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'70', N'共同-沖帳流程', N'~/admin/transfer/group_reconcile.aspx', N'A', N'', N'', N'', N'65', N'171', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'71', N'餘額核銷', N'~/admin/transfer/balance_reconcile.aspx', N'A', N'', N'', N'', N'65', N'173', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'72', N'餘額核銷查詢', N'~/admin/transfer/balance_reconcile_query.aspx', N'A', N'', N'', N'', N'65', N'174', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'73', N'沖帳查詢', N'~/admin/transfer/verify_order_record_query.aspx', N'A', N'', N'', N'', N'65', N'172', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'74', N'匯款/沖帳管理', N'~/admin/transfer/index.aspx', N'A', N'', N'', N'', N'65', N'166', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'75', N'掛單統計', N'~/admin/guadan/statistics.aspx', N'A', NULL, NULL, NULL, N'55', N'173', NULL, NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'76', N'掛單時間參數設置', N'~/admin/guadan/guadantime/timeindex.aspx', N'A', NULL, NULL, N'', N'55', N'174', N'~/admin/guadan/guadantime/timeset.aspx,~/admin/guadan/guadantime/edit.aspx', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'77', N'掛單統計報表', N'~/admin/guadan/statistics_table.aspx', N'A', NULL, NULL, NULL, N'55', N'173', NULL, NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'78', N'掛單蓮友', N'~/admin/guadan/guest/index.aspx', N'A', NULL, NULL, NULL, N'55', N'171', NULL, NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'79', N'客房管理', N'~/admin/region/bed/index.aspx', N'A', NULL, NULL, NULL, N'55', N'168', NULL, NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'80', N'床位和掛單狀態管理', N'~/admin/region/bed/bedstatus/index.aspx', N'A', NULL, NULL, NULL, N'65', N'169', N'~/admin/region/bed/bedstatus/create.aspx', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'81', N'掛單資料', N'~/admin/guadan/index.aspx', N'A', NULL, NULL, NULL, N'55', N'170', N'~/admin/guadan/view.aspx,~/admin/guadan/update.aspx', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'82', N'新建掛單', N'~/admin/guadan/create.aspx', N'A', NULL, NULL, NULL, N'55', N'169', NULL, NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'83', N'報名統計-1', N'~/admin/pivot/pivot-01.aspx', N'A', N'', N'', N'', N'38', N'175', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'84', N'報名統計-2', N'~/admin/pivot/query.aspx', N'A', N'', N'', N'', N'38', N'176', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'85', N'區域管理', N'', N'A', N'', N'', N'', N'0', N'6', N'', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'86', N'區域資料', N'~/admin/region/index.aspx', N'A', N'', N'', N'', N'85', N'178', N'~/admin/region/handle_bed_in_used.aspx', NULL)
GO
INSERT INTO [dbo].[item] ([num], [title], [url], [target], [price], [demo], [other], [root], [range], [other_url], [s_id]) VALUES (N'87', N'報名管理2', N'~/admin/order/index2.aspx', N'A', N'', N'', N'', N'38', N'179', N'', NULL)
GO
SET IDENTITY_INSERT [dbo].[item] OFF
GO
COMMIT
GO
-- ----------------------------
-- Table structure for member
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[member]') AND type IN ('U'))
DROP TABLE [dbo].[member]
GO
CREATE TABLE [dbo].[member] (
[num] int IDENTITY(1,1) NOT NULL,
[f_num] int NULL,
[m_number] nvarchar(20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[u_name] nvarchar(20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[sex] nvarchar(2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[id_code] nvarchar(max) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[birthday] datetime NULL,
[blood] nvarchar(2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[educational] nvarchar(50) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[refugedate] datetime NULL,
[refuge_name] nvarchar(20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[refuge_area] nvarchar(50) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[demo] nvarchar(max) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[admin_num] int NULL,
[takedate] datetime NULL,
[leavedate] datetime NULL,
[group_kind] int NULL,
[title_kind] int NULL,
[salary] real NULL,
[phone] nvarchar(max) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[com_email] nvarchar(200) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[email] nvarchar(200) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[contact] nvarchar(100) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[address1] nvarchar(200) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[address2] nvarchar(200) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[reg_time] datetime DEFAULT getdate() NULL,
[pic1] nvarchar(50) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
)
GO
ALTER TABLE [dbo].[member] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'人員主檔',
'SCHEMA', N'dbo',
'TABLE', N'member'
GO
-- ----------------------------
-- Records of member
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [dbo].[member] ON
GO
SET IDENTITY_INSERT [dbo].[member] OFF
GO
COMMIT
GO
-- ----------------------------
-- Table structure for member_check
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[member_check]') AND type IN ('U'))
DROP TABLE [dbo].[member_check]
GO
CREATE TABLE [dbo].[member_check] (
[num] int IDENTITY(1,1) NOT NULL,
[mem_num] int NULL,
[check_date] date NULL,
[check_time] time(3) NULL,
[check_type] int NULL,
[demo] nvarchar(max) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[login_type] int NULL,
[login_ip] nvarchar(50) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[hour] int NULL
)
GO
ALTER TABLE [dbo].[member_check] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'考勤',
'SCHEMA', N'dbo',
'TABLE', N'member_check'
GO
-- ----------------------------
-- Records of member_check
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [dbo].[member_check] ON
GO
SET IDENTITY_INSERT [dbo].[member_check] OFF
GO
COMMIT
GO
-- ----------------------------
-- Table structure for member_group
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[member_group]') AND type IN ('U'))
DROP TABLE [dbo].[member_group]
GO
CREATE TABLE [dbo].[member_group] (
[num] int IDENTITY(1,1) NOT NULL,
[kind] nvarchar(100) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[starttime] time NULL,
[offtime] time NULL,
[resttime] int NULL,
[root] int DEFAULT 0 NULL,
[range] int NULL,
[demo] nvarchar(max) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
)
GO
ALTER TABLE [dbo].[member_group] SET (LOCK_ESCALATION = TABLE)
GO
EXEC sp_addextendedproperty
'MS_Description', N'人員組別管理',
'SCHEMA', N'dbo',
'TABLE', N'member_group'
GO
-- ----------------------------
-- Records of member_group
-- ----------------------------
BEGIN TRANSACTION
GO
SET IDENTITY_INSERT [dbo].[member_group] ON
GO
SET IDENTITY_INSERT [dbo].[member_group] OFF
GO
COMMIT
GO
-- ----------------------------
-- Table structure for member_title
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[member_title]') AND type IN ('U'))
DROP TABLE [dbo].[member_title]
GO
CREATE TABLE [dbo].[member_title] (
[num] int IDENTITY(1,1) NOT NUL
Reference in New Issue View Git Blame Copy Permalink