Click here to Skip to main content
15,438,113 members
Home / Discussions / Database
   

Database

 
AnswerRe: About Delphi 11 Professional Edition Pin
0x01AA6-Jan-22 9:34
professional0x01AA6-Jan-22 9:34 
QuestionConnecting DB tables Pin
MekaC31-Oct-21 20:48
MemberMekaC31-Oct-21 20:48 
AnswerRe: Connecting DB tables Pin
David Mujica1-Nov-21 3:28
MemberDavid Mujica1-Nov-21 3:28 
GeneralRe: Connecting DB tables Pin
MekaC1-Nov-21 15:59
MemberMekaC1-Nov-21 15:59 
AnswerRe: Connecting DB tables Pin
Member 153296131-Nov-21 3:53
MemberMember 153296131-Nov-21 3:53 
GeneralRe: Connecting DB tables Pin
MekaC1-Nov-21 16:00
MemberMekaC1-Nov-21 16:00 
GeneralRe: Connecting DB tables Pin
Member 153296132-Nov-21 1:09
MemberMember 153296132-Nov-21 1:09 
GeneralRe: Connecting DB tables Pin
MekaC1-Nov-21 15:59
MemberMekaC1-Nov-21 15:59 
Here are my tables Smile | :) :

Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` int(30) NOT NULL,
  `name` varchar(250) NOT NULL,
  `description` text NOT NULL,
  `date_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `comments`
--

CREATE TABLE `comments` (
  `id` int(30) NOT NULL,
  `topic_id` int(30) NOT NULL,
  `user_id` int(30) NOT NULL,
  `comment` text NOT NULL,
  `date_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `date_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `forum_views`
--

CREATE TABLE `forum_views` (
  `id` int(30) NOT NULL,
  `topic_id` int(30) NOT NULL,
  `user_id` int(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `friendship`
--

CREATE TABLE `friendship` (
  `friend_id` int(11) NOT NULL,
  `receiver` varchar(30) NOT NULL,
  `sender` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `member`
--

CREATE TABLE `member` (
  `member_id` int(11) NOT NULL,
  `username` varchar(30) NOT NULL,
  `email` varchar(30) NOT NULL,
  `sex` varchar(100) NOT NULL,
  `password` varchar(30) NOT NULL,
  `day` varchar(100) NOT NULL,
  `month` varchar(30) NOT NULL,
  `year` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `messageid` int(11) NOT NULL,
  `sender_id` int(11) NOT NULL,
  `receiver_id` int(11) NOT NULL,
  `message` varchar(5000) NOT NULL,
  `date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `myfriends`
--

CREATE TABLE `myfriends` (
  `friend_id` int(11) NOT NULL,
  `myid` varchar(30) NOT NULL,
  `myfriends` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `output_images`
--

CREATE TABLE `output_images` (
  `imageId` int(11) NOT NULL,
  `imageType` varchar(255) NOT NULL,
  `imageData` longblob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `output_images`
--

EDIT: CHill60 - Hex Dump removed for readability

-- --------------------------------------------------------

--
-- Table structure for table `replies`
--

CREATE TABLE `replies` (
  `id` int(30) NOT NULL,
  `comment_id` int(30) NOT NULL,
  `reply` text NOT NULL,
  `user_id` int(11) NOT NULL,
  `date_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `date_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_member`
--

CREATE TABLE `tbl_member` (
  `id` int(11) NOT NULL,
  `username` varchar(255) NOT NULL,
  `password` varchar(200) NOT NULL,
  `email` varchar(255) NOT NULL,
  `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `comment` text NOT NULL,
  `image` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_member`
--

INSERT INTO `tbl_member` (`id`, `username`, `password`, `email`, `create_at`, `comment`, `image`) VALUES
(1, 'meka', '$2y$10$J/echPaDjmOaPWswI.z9BOZ21D7kaylVDvK.zAL4hhRXS8qxhcrIW', 'coti032@gmail.com', '2021-08-27 21:10:05', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `topics`
--

CREATE TABLE `topics` (
  `id` int(30) NOT NULL,
  `category_ids` text NOT NULL,
  `title` varchar(250) NOT NULL,
  `content` text NOT NULL,
  `user_id` int(30) NOT NULL,
  `date_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(30) NOT NULL,
  `name` text NOT NULL,
  `username` varchar(200) NOT NULL,
  `password` text NOT NULL,
  `type` tinyint(1) NOT NULL DEFAULT '3' COMMENT '1=Admin,2=Staff, 3= subscriber'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--


modified 2-Nov-21 6:01am.

GeneralRe: Connecting DB tables Pin
Richard MacCutchan1-Nov-21 22:46
mveRichard MacCutchan1-Nov-21 22:46 
SuggestionRe: Connecting DB tables Pin
CHill602-Nov-21 0:05
mveCHill602-Nov-21 0:05 
AnswerRe: Connecting DB tables Pin
Eddy Vluggen12-Nov-21 12:02
professionalEddy Vluggen12-Nov-21 12:02 
QuestionHow much difference is there between SQL server 2008 and 2012 Pin
jkirkerx28-Oct-21 9:09
professionaljkirkerx28-Oct-21 9:09 
AnswerRe: How much difference is there between SQL server 2008 and 2012 Pin
phil.o28-Oct-21 9:35
mvephil.o28-Oct-21 9:35 
GeneralRe: How much difference is there between SQL server 2008 and 2012 Pin
jkirkerx28-Oct-21 9:43
professionaljkirkerx28-Oct-21 9:43 
GeneralRe: How much difference is there between SQL server 2008 and 2012 Pin
phil.o28-Oct-21 9:58
mvephil.o28-Oct-21 9:58 
GeneralRe: How much difference is there between SQL server 2008 and 2012 Pin
jkirkerx28-Oct-21 10:09
professionaljkirkerx28-Oct-21 10:09 
QuestionRe: How much difference is there between SQL server 2008 and 2012 Pin
CHill602-Nov-21 0:10
mveCHill602-Nov-21 0:10 
AnswerRe: How much difference is there between SQL server 2008 and 2012 Pin
jkirkerx2-Nov-21 7:45
professionaljkirkerx2-Nov-21 7:45 
QuestionArray Issue Pin
MekaC24-Oct-21 17:59
MemberMekaC24-Oct-21 17:59 
AnswerRe: Array Issue Pin
Richard Deeming24-Oct-21 22:05
mveRichard Deeming24-Oct-21 22:05 
GeneralRe: Array Issue Pin
MekaC25-Oct-21 11:13
MemberMekaC25-Oct-21 11:13 
AnswerRe: Array Issue Pin
Richard MacCutchan24-Oct-21 22:07
mveRichard MacCutchan24-Oct-21 22:07 
GeneralRe: Array Issue Pin
MekaC25-Oct-21 11:14
MemberMekaC25-Oct-21 11:14 
AnswerRe: Array Issue Pin
jkirkerx28-Oct-21 9:04
professionaljkirkerx28-Oct-21 9:04 
QuestionLooking for feedback and contributions to database project Pin Pin
Michael Sydney Balloni17-Oct-21 13:06
mvaMichael Sydney Balloni17-Oct-21 13:06 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.