-- This is a demo table, the actionid should be a key and autoincrement in real life
--
CREATE TABLE actions (
actionid integer NOT NULL,
actionname text NOT NULL
);
insert into actions (actionid,actionname) values(1,'Show Admin Menu');
insert into actions (actionid,actionname) values(2,'Add Action');
insert into actions (actionid,actionname) values(3,'Delete Action');
insert into actions (actionid,actionname) values(4,'Modify Action');
insert into actions (actionid,actionname) values(5,'View Action');
insert into actions (actionid,actionname) values(6,'Add Group');
insert into actions (actionid,actionname) values(7,'Delete Group');
insert into actions (actionid,actionname) values(8,'Modify Group');
insert into actions (actionid,actionname) values(9,'View Group');
insert into actions (actionid,actionname) values(10,'Add Account');
insert into actions (actionid,actionname) values(11,'Delete Account');
insert into actions (actionid,actionname) values(12,'Modify Account');
insert into actions (actionid,actionname) values(13,'View Account');
|