From 3de91148bc3b634feb6d4b882c743317c517b8b0 Mon Sep 17 00:00:00 2001 From: arf20 Date: Sat, 16 Mar 2024 17:15:11 +0100 Subject: Add client and admin panels --- dbinit.sql | 9 +++++++++ 1 file changed, 9 insertions(+) (limited to 'dbinit.sql') diff --git a/dbinit.sql b/dbinit.sql index 5a989ab..d9220d1 100644 --- a/dbinit.sql +++ b/dbinit.sql @@ -11,3 +11,12 @@ CREATE TABLE `arfnet2`.`users` ( `regdate` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , PRIMARY KEY (`id`) ); + +CREATE TABLE `arfnet2`.`services` ( + `id` INT NOT NULL AUTO_INCREMENT , + `name` VARCHAR(255) NOT NULL , + `type` ENUM('free','standard','premium') NOT NULL , + `billing` DECIMAL NOT NULL , + `description` TEXT NOT NULL , + PRIMARY KEY (`id`) +); -- cgit v1.2.3