-
Notifications
You must be signed in to change notification settings - Fork 3
/
ddns.sql
28 lines (24 loc) · 895 Bytes
/
ddns.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";
CREATE TABLE `accounts` (
`A_id` int(11) NOT NULL,
`user` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`password` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`dmnid` int(11) NOT NULL,
`approved` int(11) NOT NULL DEFAULT '0',
`email` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`registered` int(100) NOT NULL,
`lastupdate` int(100) NOT NULL,
`ip` varchar(50) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE `domains` (
`D_id` int(11) NOT NULL,
`domain` varchar(50) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
ALTER TABLE `accounts`
ADD PRIMARY KEY (`A_id`);
ALTER TABLE `domains`
ADD PRIMARY KEY (`D_id`),
ADD UNIQUE KEY `domain` (`domain`);